Do a <cfdump var="#Client_id#"> right before the query start to verify that the variable has a value. If the variable contains a blank, or a non-number, then the query will fail.
To make sure that the query always passes a value, you can send the variable as paramed. SELECT client.client_id, client.Last_Name, client.First_Name, case_defendant_id, sex FROM client, case_defendant WHERE client.client_id = <cfqueryparam value="#Client_id#"> AND client.client_id = case_defendant.client_id ---------------------------------- William Seiter IT Web Developer / Consultant Is your income limited by the red tape and paperwork? Let SoftEx BackOffice help you. They know how to take care of the 'busy work' of your contracts and let you focus on the 'WOW' factor. http://www.softexconsulting.com/softex_office.cfm ::-----Original Message----- ::From: Tracie Nance [mailto:[EMAIL PROTECTED] ::Sent: Wednesday, October 15, 2008 4:22 PM ::To: cf-talk ::Subject: ODBC Error :: ::OK guys .. I am new to CF. I have a desktop ODBC that connects. The ::data source within CF connects. Why do I get this error? I get so far ::into the program and then I get this message .. :: ::Error Executing Database Query. ::[Macromedia][SequeLink JDBC Driver][ODBC Socket][Informix][Informix ODBC ::Driver]Invalid string or buffer length. :: ::The error occurred in ::C:\Inetpub\wwwroot\bbpacts\Search\qry_searchpactsid.cfm: line 4 ::Called from C:\Inetpub\wwwroot\bbpacts\search.cfm: line 16 ::Called from C:\Inetpub\wwwroot\bbpacts\Search\qry_searchpactsid.cfm: line ::4 ::Called from C:\Inetpub\wwwroot\bbpacts\search.cfm: line 16 :: ::2 : SELECT client.client_id, client.Last_Name, client.First_Name, ::case_defendant_id, sex ::3 : FROM client, case_defendant ::4 : WHERE client.client_id = #Client_id# ::5 : AND client.client_id = case_defendant.client_id ::6 : </CFQUERY> :: :: :: :: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
