 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Getting Started / May 2006Getting Started Tutorial
The tutorial is either has several things left out or it is operator error. 1. the cfdump does not work - it returns nothing. 2. Attribute validation error for tag cfoutput error returns nothing. I work with Fireworks and DW but I am new to CF. This tutorial does not look difficult but when not much of what they give us works - it is very frustrating. Thanks my code is below. <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> <!--- <cfdump var=#artwork#> ---> </CFIF> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Art Gallery Pieces</title> </head> <body bgcolor="##0066CC"> <img src="images/logo.gif" width="140" height="45"> <br><br> <table border="0" cellpadding="15" cellspacing="0" bgcolor="##FFFFFF"> <cfoutput query="artwork"> <tr> <td valign="top" align="center" width="200"> <img src="images/#artwork.LARGEIMAGE#"width="200" height="200"><br> <strong>#artwork.artName#</strong><br> Artist: #artwork.firstName# #artwork.lastName#<br> Price: #artwork.price#<br> #artwork.mediatype# - #artwork.description#<br> <font color="##FF0000">#artwork.isSold#</font></td> </tr> </cfoutput> </table> Is your query even returning anything? No the query does not return anything. No the query has not returned anything yet. Well, if your query isn't returning anything, then you won't be seeing any output, either using the CFOUTPUT or CFDUMP methods. Is there any data in your database? Are you able to query your datasource outside of ColdFusion to see if it is your query that is at fault, or perhaps you have no matching data in your database. Phil The cftutorial database has data and I tested the database connection- it was good. I removed the WHERE clause and the error :The value of the attribute query, which is currently "artwork", is invalid. What happens if you just try to view the output of the query using CFDUMP and comment out the rest of the code (or CFABORT after CFDUMP)? Phil I used CFDUMP and commented out the rest of the code- I previewed page and nothing was returned. thks Even without a WHERE clause? If so, you have no DATA coming from your QUERY, which probably means nothing in the database. Even without a where clause and I checked the tables in the database - they all contain several rows. jim So, what do you get when you run this? <cfquery NAME="tbl_count" datasource="cftutorial"> SELECT 'artists' AS tbl_type, count(*) AS cnt FROM artists UNION SELECT 'art' AS tbl_type, count(*) AS cnt FROM art UNION SELECT 'media' AS tbl_type, count(*) AS cnt FROM media </cfquery> <cfdump var="#tbl_count#"> Phil I got a result set listing 45 art 10 artists 8 meida I think that this is what is messing you up <b><CFIF #ParameterExists(Add)# is "Yes"></b> The ParameterExists() function is deprecated, and you should be using IsDefined, and you should have written it like this: <CFIF #IsDefined(Add)> If you also want to check the <i>value</i> of Add, then you also need to include a check to see if it has the appropriate value, something like this: <CFIF #IsDefined(Add) AND Add EQ "Yes"> At any rate, I believe that you are skipping the entire query because your CFIF statement is never TRUE. Phil I got rid of the <CFIF #ParameterExists(Add)# is "Yes"> and the <cfdump> worked fine. Thanks for your patience and help Jim Sorry that it took so long. I was focusing on your query and didn't even stop to look at the CFIF tag that controlled access to the dang thing! Phil |
Reply to this Message |
 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.