Why do you have a single quote after the WHERE statement? WHERE '(zip <
-----Original Message----- From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:37 PM To: CF-Talk Subject: cfqueryparam question (errors) Sadly, I'm just learning to use cfqueryparam in my querys. However, I get an error every time! "[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). " For the life of me I can't understand why I get this. Query works great without. ColdFusion MX. <cfquery datasource="#attributes.DataSource#" name="Dest"> SELECT * FROM mytable WHERE '(zip < <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#variables.LatN#"> ) ' </cfquery> Anyone see a problem?? Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
