Hi! Bryan,
Are saying that I can execute a store procedure without using CFStoredproc
tag??? Could you please elaborate a bit more?
The application that I am developing is to support both English and Chinese
characters input. Therefore, the data fields in database are defined as
ndatatype.
Oops, another question related to multibyte data input such as chinese
character. How do we control the maximum character to be accepted by the text
input box on a page? The maxlength element of the input tag doesn't seem to
support this. Please correct me if I am wrong.
Thanks.
Regards,
looct
----- Original Message -----
From: "Bryan Love" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 12:36 AM
Subject: RE: Double byte datatype
> 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
