Hi Dave,

Yes I realize that but I'm uprgrading code from CF5 to CFMX and I'm looking
for broken stuff. This worked in CF5. Whats interesting is that even though
I'm not attempting to use the field titled URL, it still bombs. This just
seems like a bug to me. I didn't create a variable titled URL... I created a
recordset named "bling". This means that any projects which access views and
stored procedures which return a "URL" field will break. Thats too bad.

Gracias!

-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 10:12 AM
To: CF-Talk
Subject: RE: Solved! ... (I think I found a CFMX bug!) - RE: CFMX 6.1 wind
ows problem... This is so simple... why doesn't it work?

> I figured out the problem I was having... it turns out it had
> to do with one of the field's in my recordset that was generated
> with <CFQUERY>. One of the fields was called "URL" because it
> holds the URL of a web page that needs to get used on the front
> end.
>
> The following code fails in CFMX. Looking at it, I can't think
> of a reason why this code would fail. Clearly, this code is not
> useful but it shouldn't bomb.
> -----------
> <cfquery name="bling" datasource="hooha">
> select 'http://neverlandranch.foo' as URL
> </cfquery>
> <cfoutput query="bling">
> #urldecode("michael jackson")#
> </cfoutput>
> -----------

"URL" is a reserved word in CFMX, as it refers to a variable (the URL
scope). It's always a really bad idea to use words in programs when those
words have any significance within that programming language, even if the
language allows it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to