You can say select url as myurl in the query, but yea, that's going to require code changes...
> -----Original Message----- > From: Bill Woodland [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 27, 2006 5:30 PM > To: CF-Talk > Subject: Re: is URL a structure, or not? > > >As I've said, is it possible that his query is returning a column named > URL. > >And since he's inside a cfoutput block, cf looks to the query first when > >dereferencing variables (I believe). What's the order again? > > > >So a reference to url becomes a reference to queryname.url, which is a > >string. Although if this type of thing was the case, I would imaging > that > >this would've came up before on this list... > > > >Russ > > > >> > > Thanks, Russ. You got it...I hadn't noticed that. I'm working on a site > which I didn't write, nor am I familiar with the table structures. I > changed my test script to use a different table, and it worked fine. > > OK, so now I changed the code in my real script (not the test script) to > use structkeyexists, and it seems to want to use URL from the query > instead of the URL structure (which does exist). > > I would think that structkeyexists would search for the named structure, > not string variables, and form, session, url, and even my query modusers > would be structures. > > Is there any way to make structkeyexists IGNORE the fields in the query? > If not, then we have a lot of recoding to do to deploy this app on the new > server. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244928 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
