I'm having a strange problem with client variables with a proffessional
version of CFMX, updater 2 applied.  This problem has existed ever since I
switched client vars from the registry to the database earlier today.

My client variable database is accessed via an OCI datasource, Oracle
version 9i.

The cdata table's cfid and app columns are defined as varchar2(20) and
varchar2(64) respectively.

Everytime a client variable is created, a new row is inserted into the table
instead of updating the existing row. The cfid and app columns are right
padded with spaces!  The same problem exists with cglobal's cfid column,
which is defined as varchar2(20), but not with cglobal's data column, which
is defined as varchar2(2000).  None of my client variables are ever read
successfully.

The only work-around I can think of is to put a database trigger on the
columns having trouble to trim the data.  Has anyone else seen this problem
or can anyone suggest a fix or a better work-around?

***
The information in this e-mail is confidential and intended solely for the
individual or entity to whom it is addressed. If you have received this
e-mail in error please notify the sender by return e-mail, delete this
e-mail, and refrain from any disclosure or action based on the information.
****

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to