Searching a Database

[Aidan]

I have set up an access database and i am accessing it through sql statements.Would anyone be able to tell me how to search the database by a customers name?

Any help would br greatly appreciated!

 

[stustarz]

Use a where clause in your SQL statement e.g.:

SELECT * FROM customers WHERE CustomerName = James

 

[Aidan]

Variable

If i were to search the database using a variable as opposed to a name would i use the same code?

 

[stustarz]

Yeah! well:

Dim strSelectStatement As String
Dim strSearchTerm As String = "James"

The single () quotes are important when searching on text
strSelectStatement = "SELECT * FROM customer WHERE CustomerName = " & strSearchTerm & ""

 

[coldfusion244]

You can also choose which fields you want returned as well. No sense in grabbing every field if all you need is their address. Anyway, here is a list of MySQL commands.. should come in handy.

http://dev.mysql.com/doc/mysql/en/