Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / ColdFusion / Getting Started / May 2006



Tip: Looking for answers? Try searching our database.

Getting Started Tutorial

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rockhiker - 26 May 2006 22:02 GMT
RE: getting started tutorial. I have got everything working until the <cfdump
var ="artwork"> The code is attached.

The error returned :     Variable ARTWORK is undefined.

Any help is cool

thks
jim

<CFIF #ParameterExists(Add)# is "Yes">
<CFQUERY NAME="ARTWORK" datasource="CFTUTORIAL">
SELECT FIRSTNAME, LASTNAME, ARTNAME, DESCRIPTION, PRICE, LARGEIMAGE, ISSOLD,
MEDIATYPE
FROM ARTISTS, ART, MEDIA
WHERE ARTIST.ARTISTID=ART.ARTISTID
AND ART.MEDIAID = MEDIA.MEDIAID
</CFQUERY>
</CFIF>
<cfdump var="#ARTWORK#">
Dan Bracuk - 26 May 2006 22:26 GMT
<blockquote>quote:<br><hr><i>Originally posted by: <b><b>rockhiker</b></b></i>
RE: getting started tutorial. I have got everything working until the <cfdump
var ="artwork"> The code is attached.

The error returned :     Variable ARTWORK is undefined.
Any help is cool
thks
jim<hr></blockquote>
My guess is that ParameterExists(Add) is not  "Yes".  Therefore your query did
not run.
jdeline - 26 May 2006 23:08 GMT
The correct syntax is <cfdump var=#ARTWORK#> - no double-quotes.
rockhiker - 30 May 2006 17:36 GMT
I tried the <cfdump var = #artwork#> with and without quotes.  It does not return a query result set as shown in the tutorial. Only the page displays.

thks

Jim
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.