Try single quotes instead of double??? ----- Original Message ----- From: "Pragnesh" <[EMAIL PROTECTED]> Newsgroups: cfaussie To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 10:52 AM 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/
