jokerparis
Programmer
i have 2 files :<br><br>the first form.cfm<br><br><<html><br><head><title>Untitled</title></head><br><body><br> <form action="nextpage.cfm" method="POST" name="formulaire"><br> Pseudo :<br> <br><input type="Text" name="user" required="No" size="10"><br><br> Sujet :<br> <br><input type="Text" name="subject" required="No" size="80"><br><br> Date :<br> <br><input type="Text" name="date" required="No" size="10"><br><br> Votre Texte :<br> <br><input type="Text" name="body" required="No" size="10"><br><br> <!--<br><textarea rows=5 cols=50 name="body">Post Goes Here</textarea>--><br> <br><br><input type="submit" value="Submit"><br> </form><br></body><br><br></html><br><br>and the second :<br><br><cfquery datasource="forum"><br>INSERT INTO question(user_id , subject , body , date)<br>VALUES ( '#user#' , '#subject#' , '#body#' , '#date#' )<br></cfquery><br><br>all my fields in my base are text format and i have a automatic number for the id , when i try to complete the forrm and click submit this message appear :<br><br>Error Diagnostic Information<br>ODBC Error Code = 37000 (Syntax error or access violation)<br><br><br>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<br><br><br><br>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:28).<br><br><br>Date/Time: 07/20/00 15:51:05<br>Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)<br>Remote Address: 127.0.0.1<br>HTTP Referer: <A HREF=" TARGET="_new">