Skip to main content
G
GwenH
Inspiring
October 24, 2008
Question

Reserved Word? Where?

  • October 24, 2008
  • 2 replies
  • 643 views
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
    This topic has been closed for replies.

    2 replies

    G
    GwenHAuthor
    Inspiring
    October 24, 2008
    Thank you so much! I feel so stupid! How could I have missed that? I went over and over that code.

    Thanks again,
    GwenH
    D
    Dan_Bracuk
    Inspiring
    October 24, 2008
    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.

    P
    paross1
    Participating Frequently
    October 24, 2008
    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
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices