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