asp UPDATE DELETE issue

Hi peoples
Please please please help..am i going mad?
ok, here is the issue
i have just started a new website...and i am moving forward from htm to asp.
i am using ms access db 2003 and frontpage 2003 to create my pages.Also i am using a windows 2003 server which doesnt currently have frontpage extentions installed.
All is going great as far as creating the pages and pulling down the quieries to show.
however i have now created a little section for adding,updating and deleting. I have looked at microsoft web site plus many others that show step by step how to do this and example is www.frontpagemagic.com/drw/add-edit-delete/editrecord/index.asp. i can create a new record, but i cant update or delete and records. Is there something wrong with the server? do i need frontpage extentions installed? what about permissions, is that an issue, is there any naming issues that i need to be aware of in acccess?
please please help

oh forgot to show code..
this is the bit for update...
<form method="POST" action="modifycarsupdate.asp">
<table BORDER="0" id="table1">
<tr>
<td><b>ID:</b></td>
<td><input NAME="carID" SIZE="40" VALUE="<%=request ("carID")%>"></td>
</tr>
<tr>
<td><b>Company:</b></td>
<td>
<input NAME="company" SIZE="40" VALUE="<%=request ("company")%>"></td>
</tr>
<tr>
<td>Make</td>
<td>
<input NAME="Make" SIZE="40" VALUE="<%=request ("Make")%>"></td>
</tr>
</table>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

And this is the bit which is passed from the above...
<html>

<body>

<table width="100%">
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE contract_hire SET company='::company::', make='::make::' WHERE carID='::carID::'"
fp_sDefault="company=&make=&carID="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


</tbody>
</table>
<p> </p>

</body>

</html>
So what have i done wrong?

asp UPDATE DELETE issue

asp UPDATE DELETE issue

stevelibby

txbakers

mattglet

Spooky

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week