using variables.state outputs it fine.
using just state doesn't work...here is the code.
the data had city, state in 1 field with a / at the end
so I had to clean that up...anyway, running that
with state doesn't work, but variables.state works.
<cfquery name="get" datasource="******">
select * from consignee where city like '%,%'
</cfquery>
<cfloop query = "get">
<cfset commaFind = find(',',get.city,1)>
<cfset state = left(right(get.city,3),2)>
<cfset city = left(get.city,commaFind - 1)>
<cfoutput>#commaFind#</cfoutput><BR>
<cfoutput>#variables.state#</cfoutput><BR>
<cfoutput>#city#</cfoutput>
<cfabort>
<cfquery name="update" datasource="*******">
update consignee
set city = '#cityNow#', state = '#stateNow#'
where companyName = '#get.companyName#' and city
='#get.city#'
</cfquery>
</cfloop>
tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 1:55 PM
To: CF-Talk
Subject: RE: state a reserved word in cf?
What happens if you use variables.state?
========================================================================
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email : [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 10:45 AM
> To: CF-Talk
> Subject: state a reserved word in cf?
>
>
> I have a variable returned and want to call it state, when I
> try to cfoutput it, as #state# I gets nothing :( however,
> call it anything else...and BLAMMM its there?
>
> tony weeg
> sr. web applications architect
> navtrak, inc.
> [EMAIL PROTECTED]
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
