nvarchar Insert

2004-10-29 Thread Guy McDowell
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

Re: nvarchar Insert

2004-10-29 Thread Joe Rinehart
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

RE: nvarchar Insert

2004-10-29 Thread Tangorre, Michael
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

RE: nvarchar Insert

2004-10-29 Thread Pascal Peters
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

Re: nvarchar Insert

2004-10-29 Thread guy . mcdowell
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

RE: nvarchar Insert

2004-10-29 Thread Tangorre, Michael
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

Re: nvarchar Insert

2004-10-29 Thread G
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

Re: nvarchar Insert

2004-10-29 Thread guy . mcdowell
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

Re: nvarchar Insert

2004-10-29 Thread guy . mcdowell
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