SQL syntax error in ColdFusion

lauriel
lauriel used Ask the Experts™
on
I'm getting a syntax error (missing operator)on an easy SQL Select statement in ColdFusion...I can't find any documentation that says my code is wrong! Here it is:

<CFQUERY NAME="CheckMembershipID" DATASOURCE="my_members">
    SELECT first_name, last_name, login, individual_id
    FROM members
    WHERE individual_id = #form.individ_id#
</CFQUERY>

Thanks!!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Check the following
a) FORM.individ_id is getting filled with a value you're not expecting(or nothing at all, or b) your database table has a record where the username is NULL, or some other data weirdness.

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- PAQ'd and points refunded

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Venabili
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial