|
ocano -> database interface wizard update error (3/26/2008 12:44:28)
|
Need some help figuring out what's giving me this error:
Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
when trying to use the update/edit record part in a page made by the database interface wizard in frontpage 2003.
The code in the update page is.
<%
fp_sQry="UPDATE Results SET xDate = '::xDate::' , Account_Number = '::Account_Number::' , Member_Name = '::Member_Name::' , Card_Number = '::Card_Number::' , Completed_By = '::Completed_By::' , Remote_computer_name = '::Remote_computer_name::' , User_name = '::User_name::' , Browser_type = '::Browser_type::' , Timestamp = '::Timestamp::' WHERE (ID = ::ID::)"
fp_sDefault="xDate=&Account_Number=&Member_Name=&Card_Number=&Completed_By=&Remote_computer_name=&User_name=&Browser_type=&Timestamp=&ID=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="debitfm"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&xDate=202&Account_Number=202&Member_Name=202&Card_Number=202&Completed_By=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
Please help!!! I don't know much about this kind of stuff!!
Thanks!!!
|
|
|
|
