selectcandidate is the name of your query, to resolve the expression you need to
indicate a column name.
do you really want: <input type="hidden" name="id" value="#selectcandidate.id#> which
will store the ID column of the query as a hidden form field.
Craig
> -----Original Message-----
> From: Mike [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 3:01 PM
> To: CF-Talk
> Subject: Re: Code review, PLEASE
>
> This is what I get now with the ##
> Error Occurred While Processing Request
> Error Diagnostic Information
> Expression result cannot be converted to a string
>
> Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must
> evaluate to a value that can be converted to a string for output or dynamic
> text accumulation purposes. Complex objects, such as queries, arrays, and
> COM/DCOM objects, cannot be represented as strings.
>
> The error occurred while processing an element with a general
> identifier of (#selectcandidate#), occupying document position (22:39) to
> (22:55).
>
>
> Date/Time: 03/19/01 15:00:27
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
> Remote Address: 127.0.0.1
>
>
>
>
> "Paul Ihrig" <[EMAIL PROTECTED]> wrote in message
> 1097F6DBC531D2118F180008C7B1682D03A1537D@NBBJCMHEX1">news:1097F6DBC531D2118F180008C7B1682D03A1537D@NBBJCMHEX1...
> >
> > <input type="hidden" name="id" value="selectcandidate">
> > doesn't the value need # symbols?
> >
> > -paul
> >
> > Web Developer, NBBJ
> > Work: [EMAIL PROTECTED]
> > 614 241-3534
> > fax: 614 485-5534
> >
> > Home: [EMAIL PROTECTED]
> > 614 449-1681
> >
> > > icq: 47658358
> >
> >
> > -----Original Message-----
> > From: Mike [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 19, 2001 2:27 PM
> > To: CF-Talk
> > Subject: Code review, PLEASE
> >
> >
> > I have to be missing something: and I cant put my mouse on it
> >
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <!--- include toolbar.cfm--->
> > <cfinclude template="Toolbar.cfm">
> > <html>
> > <head>
> > <CFPARAM Name="ID" Default=1>
> > <title>Interview 2</title>
> > </head>
> > <CFQUERY NAME="selectcandidate" DATASOURCE="interview">
> > SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile,
> > InitialIntdate, InitialInt, TechIntvdate, TechIntv, PeerInterviewdate,
> > PeerInterview, MarkInterdate, MarkInter, ExtOfferdate, CheckRef,
> StartDate,
> > Comments
> > FROM interview
> > WHERE ID=#ID#
> > </CFQUERY>
> > <cfform action="interview2action.cfm" method="POST">
> >
> >
> > <CFSET NextID=#id#+1>
> > <CFSET PrevID=#id#-1>
> >
> > <body bgcolor="6699ff">
> > <cfoutput query="selectcandidate">
> > <input type="hidden" name="id" value="selectcandidate">
> >
> > <table width="95%" border="1" align="center" bgcolor="6699ff" >
> > <tr>
> > <td>ID</td>
> > <td>Candidate Name</td>
> > </tr>
> > <tr>
> > <td> #ID#</td>
> > <td> #EmpCandidate#</td>
> > </tr>
> > <tr>
> > <td>Initial Interview Date</td>
> > <td>Initial Interview Notes</td>
> > </tr>
> > <tr>
> > <td valign="top"> <cfinput type="Text" name="InitialIntdate"
> > value="#InitialIntdate#"></td>
> > <td> <textarea cols="65" rows="5"
> > name="InitialInt">#InitialInt#</textarea></td>
> > </tr>
> > <tr>
> > <td>Technical Interview Date</td>
> > <td>Technical Interview Notes</td>
> > </tr>
> > <tr>
> > <td valign="top"> <cfinput type="Text" name="TechIntvDate"
> > value="#Techintvdate#"></td>
> > <td> <textarea cols="65" rows="5"
> > name="TechIntv">#TechIntv#</textarea></td>
> > </tr>
> > <tr>
> > <td>Peer Interview Date</td>
> > <td>Peer Interview Notes</td>
> > </tr>
> > <tr>
> > <td valign="top"> <cfinput type="Text" name="PeerInterviewdate"
> > value="#PeerInterviewdate#" required="No"></td>
> > <td> <textarea cols="65" rows="5"
> > name="PeerInterview">#PeerInterview#</textarea></td>>
> > </tr>
> > <tr>
> > <td>Marketing Interview Date</td>
> > <td>Marketing Interview Notes</td>
> > </tr>
> > <tr>
> > <td valign="top"> <cfinput type="Text" name="MarkInterdate"
> > value="#MarkInterdate#" required="No"></td>
> > <td> <textarea cols="65" rows="5"
> > name="MarkInter">#MarkInter#</textarea></td>
> > </tr>
> > <tr>
> > <td valign="top">Offer Extended Date</td>
> > <td>Reference Check</td>
> > </tr>
> > <tr>
> > <td valign="top"> <cfinput type="Text" name="ExtOfferdate"
> > value="#ExtOfferdate#"></td>
> > <td> <textarea cols="65" rows="5"
> > name="CheckRef">#CheckRef#</textarea></td>
> > </tr>
> > <tr>
> > <td>Start Date</td>
> > <td>Additional Comments</td>
> > </tr>
> > <tr>
> > <td valign="top"> <cfinput type="Text" name="StartDate"
> > value="#StartDate#" required="No"></td>
> > <td><textarea cols="65" rows="5"
> > name="Comments">#Comments#</textarea></td>
> > </tr>
> > </table>
> >
> > <table width="85%" border="0">
> > <TR>
> > <TD align="left"><a href="interview2.cfm?ID=#PrevID#">Previous</a></TD>
> > <td align="right"><a href="interview2.cfm?ID=#NextID#">Next</a></td>
> > </td></TR></table>
> > </cfoutput>
> > <input type="submit" name="Action" value="Update Criteria">
> > </cfform>
> > </body>
> > </html>
> >
> >
> > TIA
> >
> > Michael
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
