I'd recommend you find a copy for cf_dump.cfm -- it's great for
debugging.
The problem is if your url.id isn't defined, the query doesn't get built
so your cfoutput is calling a nonexistent query. You could put the
cfoutput inside the cfif.... ?
Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New Zealand
http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/
-----Original Message-----
From: Cecilia Shaw [mailto:[EMAIL PROTECTED]]
Sent: Monday, 6 May 2002 1:04 p.m.
To: CF-Talk
Subject: RE: SQL Statement
YES! That is why this is so confusing to me. I revised the statement
and here is what I have:
<CFIF IsDefined("URL.ID")>
<CFQUERY NAME="queryname" DATASOURCE="#db#">
SELECT contact.contact_key, progress.*
FROM contact,progress
WHERE contact.contact_key = progress.contact_key
AND contact.contact_key = #SESSION.member_contact_key#
ADN contact.contact_key = #URL.contact_key#
</cfquery>
</cfif>
<cfoutput query="progress_report">
This is the error I am getting:
Error Diagnostic Information
QUERY
The QUERY attribute of the tag does not specify the name of an available
query
The error occurred while processing an element with a general identifier
of
(CFOUTPUT), occupying document position (75:1) to (75:34).
=======
Any suggestions?
================
>From: "Matt Liotta" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL Statement
>Date: Sun, 5 May 2002 17:52:14 -0700
>
>Are you not running CF 5?
>
>-Matt
>
> > -----Original Message-----
> > From: Cecilia Shaw [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, May 05, 2002 5:47 PM
> > To: CF-Talk
> > Subject: RE: SQL Statement
> >
> > Now I'm getting an error message:
> >
> > ColdFusion cannot determine how to process the tag <CFDUMP>. The tag
>name
> > may be misspelled.
> >
> > If you are using tags whose names begin with CF but are not
ColdFusion
> > tags
> > you should contact Allaire Support.
> >
> >
> > The error occurred while processing an element with a general
>identifier
> > of
> > (CFDUMP), occupying document position (30:2) to (30:33).
> >
> > Still unsure about this.
> >
> > >From: "Matthew Walker" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: CF-Talk <[EMAIL PROTECTED]>
> > >Subject: RE: SQL Statement
> > >Date: Mon, 6 May 2002 11:41:43 +1200
> > >
> > >Have you tried <cfdump var="#queryname#"> ?
> > >
> > >Also you don't need a datasource in a cfoutput.
> > >
> > >-----Original Message-----
> > >From: Cecilia Shaw [mailto:[EMAIL PROTECTED]]
> > >Sent: Monday, 6 May 2002 11:28 a.m.
> > >To: CF-Talk
> > >Subject: re: SQL Statement
> > >
> > >
> > >I have a SQL statement that is returning a blank page. The query
is
>as
> > >follows:
> > >
> > ><CFIF IsDefined("URL.ID")>
> > > <CFQUERY NAME="queryname" DATASOURCE="#db#">
> > > SELECT contact.contact_key, progress.*
> > > FROM contact,progress
> > > WHERE contact.contact_key = progress.contact_key
> > > AND contact.contact_key = #SESSION.memberID#
> > > ADN contact.contact_key = #URL.ID#
> > > </cfquery>
> > ></cfif>
> > >
> > ><cfoutput query="queryname" Datasource=#db#>
> > ><table border="0" cellpadding="3" cellspacing="3">
> > ><th align="left" colspan="3" bgcolor="006951">
> > ><font color="White">
> > >Here are the current progress tracker scores for:
> > >#URL.contact_key#</font></th>
> > >
> > >
> > ><tr bgcolor="E5E5E5"><td align="right" valign="top">Planks:</td>
> > ><td align="left" valign="top" colspan="2">
> > >Minutes: #plank_min#<br>
> > >Seconds: #plank_sec#<br>
> > ><strong>Total Points for Planks:
>#plank_pts#</strong></td></tr></table>
> > ></cfoutput>
> > >
> > >At a loss, please help!!
> > >
> > >
> > >
> > >
> > >Cecilia Jimason Shaw
> > >
> > >
> > >
> > >
> > >
> >
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
