Hi Chuck, I will try this, but I think that the problem was the #REQUEST.dataSource# as when I changed this to the data-source name instead of using #REQUEST.dataSource# everything is fine. However, now that I now about the getURL function in CF I will not use this name as it might be a conflict.
A very weird day here. Thanks, John On Jul 23, 2009, at 5:44 PM, Chuck wrote: > > John, > > Try giving your query a different name than getURL, like qrygetURL. > There > is a function in ColdFusion called getURL(). Maybe it is conflicting. > > HTH > > -----Original Message----- > From: John Barrett [mailto:[email protected]] > Sent: Thursday, July 23, 2009 11:20 PM > To: cf-newbie > Subject: CF Query Weirdness > > > Hi, Should this work, or is there something I am missing and need > to take a > break at work? > I am using dreamweaver CS 4 for the code, and I am using the > getLinks before > the database field,a nd trust me all the database fields are in the > database, and there are no spelling errors, as I have checked over > and over. > > I get the error:Element URL is undefined in GETURL > > No the Database headers are ID, URL,title,description,category. > Therefore > getURL.URL should work right? > Thanks very much, > John > > <!--- code---> > <cfquery name="getURL" datasource="#REQUEST.dataSource#"> > SELECT * > FROM links > </cfquery> > <html> > <head> > <title>Display Links</title> > </head> > > <body> > <cfoutput query="getURL"> > <a href="#getURL.URL#">#getURL.title#</a> <br /> > #getURL.description# <br /> > #getURL.category# > > </cfoutput> > > </body> > </html> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4667 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
