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:4666 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
