selectCandidate is your query name; a query can't be converted to a string.
You may want one of your query column names instead.
-----Original Message-----
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2: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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
