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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
