when passing characters to a stored proc (NOT using CFSTOREDPROC) all string
types such as varchar, char, nvarchar, etc... should be surrounded by single
quotes and all numeric types should not.
nvarchar should be treated just like varchar, nchar should be treated just
like char, and so on...
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-----Original Message-----
From: CT, Loo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 8:43 AM
To: CF-Talk
Subject: Double byte datatype
Dear all,
Please HELP!
I am having problem to update/insert record into a database in MS SQL 7.0
using
store procedure.
Some fields /parameters of the store procedure are of nvarchar, ntext, nchar
data type. Is there any CFSQLType or CF functions that supports these
datatype?
Is there any work around method?
FYI, I am developing on Cold Fusion version 4.5.
Your advice are much appreciated.
Thank you.
Kind regards,
looct
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
