SQL - too few parameters! Should be simple fix?

Question

Select *
FROM attendees
WHERE fname = Jim

I'm creating a recordset in Dreamweaver from my access database. The table 'attendees' is correct, and the field 'fname' is correct. I tried ="Jim" and every combination of quotes, no quotes, etc.

The error I'm given is:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

I'm guessing the solution is something very simple... please help!

Answer 1

i would suspect your problem is with the connection string, not the query. (btw, you should have single quotes around "Jim" if the field is a text field.

maybe you could paste that into your message so we can see it?

Answer 2

Always enumerate all the columns you want in the record set.

you may need to prefix the table name with a DB owner (SQLServer has "dbo") or instance

Are you already connected to the DB? Is this the first query? Does this query run in Access itself? What is an example of a query that works for inside Dreamweaver?

Answer 3

Select *
FROM attendees
WHERE fname = "Jim"

i think that should work. make your program perhaps print out the query it is executing to the screen and then copy that query and try in from within access

if you are using asp, please remeber that in your code, you will have to enter the quotes doubled (i.e. to escape the quote in asp, use double)

sql = "Select * FROM attendees WHERE fname = ""Jim"""

Answer 4

Try using this Syntax:

SELECT * FROM `attendees` WHERE `fname` = 'Jim'

Also make sure to check spelling.