Ok I found out what is causing the error. I am marking up a lot of
data to insert as a client variable. Basically I am joining three queries in
a structure then marking up the structure. When it is someone who only has a
few customers to mark up, no error. Once I get to someone with around 100 it
gives me the odbc error. Now I checked my odbc driver, it lets me use long
text retrieval. The SQL field is set as long text. So in theory it should
work no matter how much data I send to the SQL server. My question now is,
is there really a limit to how big a client variable can be, and if not why
am I getting this error. My next question will be going to allaire as I will
have to buy a support ticket to get this resolved.
Robert Everland III
Web Developer
Dixon Ticonderoga
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
