Reserved Word? Where?

[GwenH]

Okay ladies and gents, I've been all over this code. I can' t find any syntax errors. The error message is telling me "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect." Since I am positive that everything is spelled correctly, and all three fields specified exist in the database table under identical names to those specififed in the SELECT statement, including those in the WHERE statement, I must be using a reserved word. But I don't see one! Any ideas?

Thanks,
GwenH

[paross1]

You have an extra comma after email, so it looks like you are missing a parameter in your select.

Change this:
SELECT resumeID, fName, email,
FROM evals
WHERE resumeID = #url.resumeID#

to this:
SELECT resumeID, fName, email
FROM evals
WHERE resumeID = #url.resumeID#

Phil

[GwenH]

Thank you so much! I feel so stupid! How could I have missed that? I went over and over that code.

Thanks again,
GwenH

[Dan_Bracuk]

quote:

---

Originally posted by: GwenH
Thank you so much! I feel so stupid! How could I have missed that? I went over and over that code.

Thanks again,
GwenH

---

Consider formattting your code like this:

select field1
, field2
, field 3

from etc

It has more advantages than I am willing to type.

[paross1]

Nothing like having a fresh set of eyes look at your stuff. I have stared at some of the most obvious errors for hours that someone else took one second to point out!

Phil