That was it. I changed the datatype to "text" and ewverything is OK now.
THanks guys! On Thu, 4 Sep 2003 14:26:12 +0100, Craig Dudley wrote: > 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 Get the mailserver that powers this list at http://www.coolfusion.com
