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
