No, I'm just using single quote, this is my code.
<cfif IsNumeric(#qry_getSpcListInfo.ItmValue#)>
<cfset valueliststr = #qry_getSpcListInfo.ItmValue#>
<cfelse>
<cfset valueliststr = '#qry_getSpcListInfo.ItmValue#'>
</cfif>
I'm passing that variable in query. Thanks.
----- Original Message -----
From: "Nick de Voil" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Tuesday, May 17, 2005 11:35 AM
Subject: Re: Database error
> > I'm getting this error, whenever I'm trying to update the database, I'm
> using CFMX 7, this is my query
> >
> > UPDATE Person SET Person.DatExp = 99991231 , Person.DependentSeq = 0 ,
> Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta =
> 'M' WHERE Person.Objectno = 2005
>
> Are you using backtick characters around blopez5955 instead of single
quote
> characters?
>
> Nick
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206887
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
