The recordset should be recstMod, I have corrected it. I have also added in Option Explicit.
But the error msg still exist.
Now the code looks like this for ModifyFeatures_verify.asp:
<form method="post" action="Modify Features.asp">
<input type="hidden" name="FeatID" value="<% =...
Hi all,
I have used Querystring to display the list for editing: Modify Features.asp
<%
recstMod.Open "SELECT * from FuncFeat", connectMod
Do While Not recstMod.EOF
Response.Write(recstMod("FeatName")) & "<a href='ModifyFeatures_verify.asp?FeatID=" & recstMod("FeatID") & "'> Edit</a><br>"...
The HTML output is as below (sorry,its a long one):
<!- - #include file= "adovbs.inc" - ->
<%@ Language = "VBScript" %>
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta...
Hi all,
<input type="hidden" name="FeatID" value="<% = rs("FeatID") %>
as of the code above, what is the meaning of input type="hidden"? When is it normally used in?
How is it different from input type="submit"?
Thank you
Hi all,
I have posted the problem in the ASP forum before, and was directed here.
I have the following script using QueryString:
<%
Dim connectDel, recstDel
Dim FeatureID
Set connectDel = Server.CreateObject("ADODB.Connection")
connectDel.Open("DRIVER={Microsoft Access...
Audio Control Delete
ATS Delete
ACI Delete
Video Control Delete
The output:
HDMIDelete
Smart SoundDelete
Plug and PlayDelete
PIPDelete
PIPDelete
Digital Module ControlDelete
Smart SurfDelete
SarnoffDelete
Service ControlDelete
Factory ControlDelete
Hotel ModeDelete
Close CaptionDelete
Smart...
Hi all,
<input type="hidden" name="FeatID" value="<% = rs("FeatID") %>
as of the code above, what is the meaning of input type="hidden"? When is it normally used in?
How is it different from input type="submit"?
Thank you
Hi all,
how can I properly align a list shown using QueryString since now its all centre align and there is no spacing between the delete link and "FeatName"?
Pls refer to thread333-1196584 for the script that I have posted earlier.
Any help is appreciated.
Ok, it works for me now.
Thank you
By the way, how can I add one more column(except FeatID) from the DB table other than the "FeatName" so it can also be listed as well?
Another thing is how can I properly align the list shown since now its all centre align and there is no spacing between the...
Ok, it works for me now.
Thank you
By the way, how can I add one more column(except FeatID) from the DB table other than the "FeatName" so it can also be listed as well?
Another thing is how can I properly align the list shown since now its all centre align and there is no spacing between the...
recstDel is a recordset object and I have declare it in the 1st line:
Dim connectDel, recstDel
By the way, my FeatID in the table in Access DB is of datatype "Auto Number
Hi all,
I am trying to run a delete script with a list shown and a delete link next to them.
The list is shown and the FeatID is to be passed over to another script for request.querystring
<%
Dim connectDel, recstDel
Dim FeatureID
Set connectDel = Server.CreateObject("ADODB.Connection")...
Got this error when try to run the below script you gave:
______________________________________________________
FeatID=Request.QueryString("FeatID")
rs.Open "DELETE * FROM FuncFeat WHERE FeatID=" & FeatID, DB
Set rs=Nothing
Set DB=Nothing
Response.Redirec("list.asp")...
I try to run the delete script, but have this error:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/project/Delete Features.asp, line 119, column 110
Response.Write(recstDel("FeatName")) & "<a href='delete.asp?FeatID=" & recstDel("FeatID") &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.