zackly what it is, im pretty sure. not a biggie, just kinda was like, WOAH!!! anyhew...later..
tw -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 5:55 PM To: CF-Talk Subject: RE: state a reserved word in cf? Ah, is state one of the columns returned by "get"? if so, "state" will refer to get.state, not variables.state. You should not use a variable with the same name as the db column. ======================================================================== === 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 1:17 PM > To: CF-Talk > Subject: RE: state a reserved word in cf? > > > 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 Get the mailserver that powers this list at http://www.coolfusion.com