February 7th, 2007, 08:43 PM
|
 |
Wizard Down Under
|
|
Join Date: Dec 2006
Location: Australia
|
|
Update database via dynamically created form
Just a little script I wrote for an aspfree user, currently set to work without a database but move a few comment indicators and your good to go!
Code:
<html>
<title>Give Dr_Rock lots of rep</title>
<body bgcolor="#FFFFFF">
<%
Dim strSQL, strVariableValue, bulFirstEntry, intCounter
If Request("submit") <> "" Then
bulFirstEntry = true
strSQL = "Update this_table Set this_field = desired_value where"
for each variable_name in request.form
If request.form(variable_name) = "1" then
'strip "select" and leaves us with the db row unique id
variable_value=Replace(variable_name , "select", "")
if bulFirstEntry then
strSQL = strSQL & " id =" & variable_value
bulFirstEntry = false
else
strSQL = strSQL & " or id =" & variable_value & " "
end if
End If
next
response.write(strSQL)
Else
response.write("no good")
End If
%>
<form action="<%= request.servervariables("script_name") %>" method="post">
<%
'Do Until rs.EOF
for intCounter=1 to 10
%>
<input type="checkbox" name="select<% Response.write(intCounter) 'rs("id") %>" value="1">Row <% Response.write(intCounter) 'rs("id") %><br>
<%
next
' rs.MoveNext
'Loop
%>
<input type="submit" name="submit" value="Submit">
</form>
</body>
</html>
|
ASP Free Forums Sponsor:
icon!
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
