ODBiC Discussion Board


RE: (No topic), ismail, 10-08-2002

Error Message for UPDATE Message

by Michelle Andrews, March 9, 2005 15:11

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

I am simply trying to update a record in my MS Access database. Please advise what you are finding wrong.

<form action="<%=MM_editAction%>" method="POST" name="frmmyceu" id="frmmyceu"> <table width="95%" border="0" cellspacing="0" cellpadding="3"> <tr> <td width="54%"><strong>CEU NAME : </strong></td> <td width="46%"><%=(rs_ceuDisplay.Fields.Item("ceuName").Value)%></td> </tr> <tr> <td><strong>CEU TYPE : </strong></td> <td><%=(rs_ceuDisplay.Fields.Item("ceuType").Value)%></td> </tr> <tr> <td><strong>NUMBER OF CREDITS: </strong></td> <td><%=(rs_ceuDisplay.Fields.Item("ceuCredit").Value)%></td> </tr> <tr> <td><strong>CREDITABLE ORGANIZATION: </strong></td> <td><%=(rs_ceuDisplay.Fields.Item("credOrg").Value)%></td> </tr> <tr> <td><strong>LOCATION:</strong></td> <td><%=(rs_ceuDisplay.Fields.Item("location").Value)%></td> </tr> <tr> <td><strong>DESCRIPTION:</strong></td> <td><%=(rs_ceuDisplay.Fields.Item("ceuDescription").Value)%></td> </tr> <tr> <td><strong>IP CORE COMPETENCY: </strong></td> <td><%=(rs_ceuDisplay.Fields.Item("IP_Competency_Area").Value)%></td> </tr> <tr> <td><strong>DATE:</strong></td> <td><input name="date" type="text" id="date" value="<%=(rs_ceuDisplay.Fields.Item("date").Value)%>"></td> </tr> <tr> <td> </td> <td align="right"><label> <input type="submit" name="Submit" value="updatedate"> <input name="reset" type="reset" id="reset" value="Reset"> </label></td> </tr> <tr> <td> </td> <td> </td> </tr> </table> <input type="hidden" name="MM_update" value="frmmyceu"> <input type="hidden" name="MM_recordId" value="<%= rs_ceuDisplay.Fields.Item("userceuId").Value %>"> </form>


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.