I don't see any query that is updating anything in
the code you sent.
-----Original Message-----
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 1:51 PM
To: CF-Talk
Subject: Re: Code review, PLEASE
Sorry bout that:
This is the error
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (8:1) to (8:46).
Date/Time: 03/19/01 14:49:50
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 127.0.0.1
HTTP Referer: http://127.0.0.1/nto/Interview2.cfm
----------------------------------------------------------------------------
----
"Dylan Bromby" <[EMAIL PROTECTED]> wrote in message
000401c0b0ac$60463050$6401a8c0@bromby">news:000401c0b0ac$60463050$6401a8c0@bromby...
> why don't you post either the error or what isn't happening that you think
> should so we don't have to guess. :)
>
> -----Original Message-----
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 11:27 AM
> 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
