You must be trying to put in more text than the field can hold, that's all that error messsage means. Either increase the no of chars the field can hold or make it 'text'.
And btw, don't use nvarchar unless your storing or planning to store unicode strings, varchar would be the correct data type unless the string is REALLY big, in which case you'd probably be better off with 'text' (not 'ntext', for the same unicode reason) -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 14:19 To: CF-Talk Subject: RE: <cfquery syntax I just tried the below and get a totally different error message now. I guess the <cfparam must do something with the data being truncated? ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:2) to (70:43 On Thu, 4 Sep 2003 09:13:26 -0400, Tony Weeg wrote: > just for shites and giggles...have ya tried... > > <cfquery name="Update" datasource="prefs"> > UPDATE tblProfiles > SET > strSelect='#ListGetAt(commalist,1,'|')#' > WHERE strUsername='#auth#' > </cfquery> > > just wondrin' > > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Bushy [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 9:08 AM > To: CF-Talk > Subject: RE: <cfquery syntax > > > On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote: > > > what does your query look like? I usually get that error when I try > > to do an insert of text characters into a INT type field in > > > the db. > > Below is my query. The Data Type for all fields is "nvarchar" > > <cfquery name="Update" datasource="prefs"> > UPDATE tblProfiles > SET > strSelect=<cfqueryparam value="#ListGetAt(commalist,1,'|')#" > cfsqltype="CF_SQL_LONGVARCHAR"> > WHERE strUsername='#auth#' > </cfquery> > > > > > > > > > tony weeg > > sr. web applications architect > > navtrak, inc. > > [EMAIL PROTECTED] > > www.navtrak.net > > office 410.548.2337 > > fax 410.860.2337 > > > > > > -----Original Message----- > > From: Bushy [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 04, 2003 8:52 AM > > To: CF-Talk > > Subject: RE: <cfquery syntax > > > > > > I'm getting a little further but now I get this error. What does > > this > > mean? > > > > Error Diagnostic Information > > ODBC Error Code = 37000 (Syntax error or access violation) > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit > > conversion from data type text to data type nvarchar, table > > 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function > > to run this query. > > > > > > On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: > > > > > > I checked the database and there seems to be something wrong > > > > with > > > > the <cfqueryparam> because when I check the fields using SQL Query > > > > > Analyzer there are question marks "?" in the fields which I > > > > think > > > > is an error trying to update the fields? > > > > > > If you look at debug output for an SQL statement that's using > > > CFQUERYPARAM, you'll see question marks in the SQL, which are used > as > > > placeholders. You may want to remove the quotes around the > > > CFQUERYPARAM tag in your case. > > > > > > > Do I need the <cfqueryparam>? > > > > > > It's not absolutely necessary, but it is a really good idea to use > > > it > > > whenever possible. > > > > > > Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ > > > voice: (202) 797-5496 > > > fax: (202) 797-5444 > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
