Single quotes instead of double, but also: Change OR property_features LIKE "2" To: OR property_features = '2'
Steve c -----Original Message----- From: Pragnesh [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 June 2003 10:52 AM To: CFAussie Mailing List Subject: [cfaussie] Cant work out SQL Query error. HI All, Cannot work out why the sql query is throwing an error. Worst thing is when I execute the query in MS ACCESS it runs but thro CF it throws this error. Any suggestions would be appreciated. Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 8. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL Query is: SELECT property_id from property_details where property_features LIKE "1" OR property_features LIKE "%,1" OR property_features LIKE "1,%" OR property_features LIKE "%,1,%" OR property_features LIKE "2" OR property_features LIKE "%,2" OR property_features LIKE "2,%" OR property_features LIKE "%,2,%" --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
