The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Set ProjectQ = coDB.Execute("select SubRegionID, FocusID, from tbl_Project where ProjectID = " & Request("ProjectID"))

error:

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.


what the hell is wrong with my query?  I don't see it
LVL 1
dba123Asked:
Who is Participating?
 
arbertCommented:
You have a comma after FocusID before the from statement...
0
 
arbertCommented:
Set ProjectQ = coDB.Execute("select SubRegionID, FocusID from tbl_Project where ProjectID = " & Request("ProjectID"))
0
 
dba123Author Commented:
unbelievable......ahhhhh
0
 
dba123Author Commented:
hmmm, maybe it's time for contacts lenses
0
 
arbertCommented:
nah, just sounds like it's close to the end of your day :)  Those are the hardest problems to find!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.