Yes there are limits to client variables:
1. Cookie client vars = 4000 chars.
2. Registry client vars = ??
2. Database client vars for ORACLE 8i using native drivers = 4000 chars
3. Database client vars for ORACLE 8i using ODBC drivers = 2000 chars
4. Database client vars for MS SQL Server 7 = unlimited
You would be shocked at how long a string becomes when you serialize it
using WDDX!
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 7:58 AM
To: CF-Talk
Subject: ODBC Error 37000 Revisted
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
