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:313965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4