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
