Update DB using FP 2000

[Jasonsymr]

Hi

I am trying to update an access database using Frontpage 2000. I have
an update.asp page that accepts information from updateform.asp page
and then queries the mdb for the matching ID number and updates the
record.

When I go into access, I can see that the update took place.

My issue is that when I click submit on the form, it passes the
information to the update.asp page and then returns a "No records
returned" page even though its updating the database.
How can I troubleshoot this.

Regards

Jason

 

[Jasonsymr]

Here is the code FP created to the database update. Again the database
updates and proceeds to give me a no records returned page. Is this
supposed to happen, or should it confirm the update took place.

<%
fp_sQry="UPDATE Results Set
OrgName='::OrgName::',OrgPhone='::OrgPhone::',OrgAddress='::OrgAddress::',OrgCity='::OrgCity::',OrgState='::OrgState::',OrgZipCode='::OrgZipCode::',NumberSponsors='::NumberSponsors::',D1=':1::'
Where ID= ::ID::"
fp_sDefault="OrgName=&OrgPhone=&OrgAddress=&OrgCity=&OrgState=&OrgZipCode=&NumberSponsors=&D1=&ID="
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="SubmitBar"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>