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 INTO tblMyTable (txtField) > VALUES ('#frmTxtField#') > > '#frmTxtField#' comes from a textarea form element. > Sometimes I get a "truncate data" error from the database. Sometimes it > does the insert but only the first 30 or so characters. > > I feel like I'm missing something obvious. > > > ~Guy > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182927 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
