Hi,
Having trouble with this one.
SQL 2000 and the field datatype is nvarchar set to 300 chars.
Insert Statement:
INSERT INTO tblMyTable (txtField)
VALUES ('#frmTxtField#')
'#frmTxtField#' comes from a textarea form element.
Sometimes I get a truncate data error from the database. Sometimes
Guy,
I'd double check your column definition to make sure it's set to 300
and not 30...I've been known to do things like this from time to time.
-joe
On Fri, 29 Oct 2004 10:12:56 -0400, Guy McDowell [EMAIL PROTECTED] wrote:
Hi,
Having trouble with this one.
SQL 2000 and the field
From: Guy McDowell [mailto:[EMAIL PROTECTED]
SQL 2000 and the field datatype is nvarchar set to 300 chars.
Insert Statement:
INSERT INTO tblMyTable (txtField)
VALUES ('#frmTxtField#')
'#frmTxtField#' comes from a textarea form element.
Sometimes I get a truncate data error from the
cfqueryparam ??
-Original Message-
From: Guy McDowell [mailto:[EMAIL PROTECTED]
Sent: 29 October 2004 16:13
To: CF-Talk
Subject: nvarchar Insert
Hi,
Having trouble with this one.
SQL 2000 and the field datatype is nvarchar set to 300 chars.
Insert Statement:
INSERT
to
[EMAIL PROTECTED]
To
CF-Talk [EMAIL PROTECTED]
cc
Subject
Re: nvarchar Insert
Guy,
I'd double check your column definition to make sure it's set to 300
and not 30...I've been known to do things like this from time to time.
-joe
On Fri, 29 Oct 2004 10:12:56 -0400, Guy McDowell [EMAIL
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
CAST(pl.txtDescription AS nvarchar) AS txtDescription
snipped from books-on-line
nvarchar(n)
Variable-length Unicode character data of n characters. n must be a
value from 1 through 4,000. Storage size, in bytes, is two times the
number of
for?
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, October 29, 2004 9:30 AM
Subject: Re: nvarchar Insert
Yep, double checked that. Now I'm using cfqueryparam, and the insert is
working flawlessly. However the output is truncated to less than 30
characters
Yep, it's Latin. In design circles it's known as the Lorem Ipsum text and
has been the standard place-holder text since about the 1500's. I think
it's a piece by Cicero on human suffering and the pursuit of pleasure. My
latin's not so good anymore.
Thanks Michael for On Line Books tip. Should
Booyah! It Works. Thanks again, wise ones.
Truly,
Guy McDowell
Web Developer
[EMAIL PROTECTED] - Magma Communications Ltd.
t: 613.228.3565 x6348
f: 613.228.8313
http://websites.magma.ca
This e-mail message is confidential, may be privileged and is intended for
the exclusive use of the
9 matches
Mail list logo