I need a quick lesson in querying my database.

[kg9ie]

I'm working on my first database intensive program, and I don't have any good references on SQL.

I couldn't even get a simple SELECT statement to work. What I need is a sample statement. Here's what I tried:
"SELECT * from myTableName WHERE " & myTableField & "=" & myData

myData is a string. The database is Access, and I get a syntax error on SQL statement.

Can someone please help?
Any good references on the Net?


Thanks,
Todd

 

[petermeachem]

myData is a string
Strings have quotes round them. "=" & myData should be more like
"= '" & myData & "'"

If mydata contains a ', then you need to replace it with '' first.

Try that. If you still have problems post a chunk of code. Peter Meachem
peter @ accuflight.com

 

[johnwm]

Check spaces round equals signs as well Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[petermeachem]

Spaces round = signs don't matter. Extra spaces round string do

This is ok

"SELECT * from myTableName WHERE " & myTableField & " = '" & myData & "'"


This isn't

"SELECT * from myTableName WHERE " & myTableField & "=' " & myData & " ' "
Peter Meachem
peter @ accuflight.com

 

[kg9ie]

Thanks Peter.

You were right.


Todd

 

[BigOrangeMonkey]

For quick easy to understand lessons try SQL in 24 Hours by SAMS, I always find that these 24Hr books give you a good foot hold when you're very new to something.