EasyCFM.COM ColdFusion Forums / Coding Help! / And yet more help....

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: And yet more help....

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Zeroeon
11-08-2002 @ 11:33 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 27
Joined: Oct 2002

Hi finally Im not responsble for the forum ...... YAY !!!!

But now im in charge of the admin section of the community but Im having trouble with the damm <cfoutput query"blabla">.

It doesn'nt seem to output what im selecting in my query!!!!! Here's the code:

<cfelseif (action equal "voirTutorialACorriger")>
       <cfquery datasource="flashadn" username="blabla" password="blabla" name="tutorialInfoACorriger">
            select * from tutorial where tutorialID=#tutorialID# and status='acorriger'
       </cfquery>
  <cfoutput query="tutorialInfoACorriger">
    <form method="get" action="./admTutorial.cfm" name="FormACorriger">
      <table width="339" border="0">
        <tr align="left" valign="top">
          <td width="119" nowrap>ID : </td>
          <td width="204" nowrap><input type="hidden" name="tutorialID" value="#tutorialID#">#tutorialID#</td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Date de creation : </td>
          <td nowrap>#cDate#</td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Titre : </td>
          <td nowrap><input name="title" type="text" value="#title#" size="49"></td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Description : </td>
          <td nowrap> </td>
        </tr>
        <tr align="left" valign="top">
          <td height="187" nowrap> </td>
          <td nowrap><textarea name="description" cols="50" rows="10">#description#</textarea></td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Source : </td>
          <td nowrap><input name="source" type="file" value="#source#" size="47"></td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap><input type="hidden" name="action" value="updateTutorial"><input type="submit" value="Ok"></form></td>
          <td nowrap><form method="get" action="./admTutorial.cfm">
            <input type="hidden" name="tutorialID" value="#tutorialID#">
            <input type="hidden" name="action" value="suprimerTutorial">
            <input type="submit" value="Supprimer"></td>
        </tr>
      </table>
    </form>
  </cfoutput>

It does'nt want to show me the result of the query .... Plz help me !!!!!!

Thx in advance

Zeroeon

Webmaster
11-08-2002 @ 2:15 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

Try slapping a <cfif> around it.



<cfquery datasource="flashadn" username="blabla" password="blabla" name="tutorialInfoACorriger">
            select * from tutorial where tutorialID=#tutorialID# and status='acorriger'
       </cfquery>

<cfif tutorialInfoACorriger.RecordCount>


  <cfoutput query="tutorialInfoACorriger">
    <form method="get" action="./admTutorial.cfm" name="FormACorriger">
      <table width="339" border="0">
        <tr align="left" valign="top">
          <td width="119" nowrap>ID : </td>
          <td width="204" nowrap><input type="hidden" name="tutorialID" value="#tutorialID#">#tutorialID#</td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Date de creation : </td>
          <td nowrap>#cDate#</td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Titre : </td>
          <td nowrap><input name="title" type="text" value="#title#" size="49"></td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Description : </td>
          <td nowrap> </td>
        </tr>
        <tr align="left" valign="top">
          <td height="187" nowrap> </td>
          <td nowrap><textarea name="description" cols="50" rows="10">#description#</textarea></td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap>Source : </td>
          <td nowrap><input name="source" type="file" value="#source#" size="47"></td>
        </tr>
        <tr align="left" valign="top">
          <td nowrap><input type="hidden" name="action" value="updateTutorial"><input type="submit" value="Ok"></form></td>
          <td nowrap><form method="get" action="./admTutorial.cfm">
            <input type="hidden" name="tutorialID" value="#tutorialID#">
            <input type="hidden" name="action" value="suprimerTutorial">
            <input type="submit" value="Supprimer"></td>
        </tr>
      </table>
    </form>
  </cfoutput>

<cfelse>

   There were no results found!

</cfif>


If you get the message "There were no results found!" then that means there are no records found, hence why you'r not getting anything... If you still get a blank screen, please let me know.

Thanks,
Pablo Varando
EasyCFM.COM, LLC.


Website Designed and Developed by Pablo Varando.