Groups | Blog | Home
all groups > inetserver asp db > september 2003 >

inetserver asp db : problem with deleteing record thru Radio Button



A. J.
9/28/2003 5:21:54 AM
hi,
whne I used this code to delete record from MS access DB thru Radio
Button I'm always got a balnk ID

===
<%
ID = request("ID")
MySQL2= "Delete from soon where ID = " & ID & ""
'conn.Execute(MySQL2)
response.write(MySQL2)
'response.redirect("soon1.asp")
%>
===
Any idea ?

A. J.

*** Sent via Developersdex http://www.developersdex.com ***
A. J.
9/28/2003 6:02:01 AM
Thanks for your reply
here is the code
===
<html>
<head>
<title></title>
</head>
<body>
<Form name="MyForm" method="POST" action="soon-del.asp">
<input type="radio" value="<%=rs("ID")%>" name="ID">
<input type="submit" value="Delete" name="Del" style="font-family:
Tahoma; font-size: 10pt; color:#0000FF">
</Form>
</BODY></HTML>

===




A. J.

*** Sent via Developersdex http://www.developersdex.com ***
Ken Schaefer
9/28/2003 10:40:31 PM
What is the name of your radio button (ie, show us the HTML source of your
webpage where the radio button is)?

Cheers
Ken

[quoted text, click to view]
: hi,
: whne I used this code to delete record from MS access DB thru Radio
: Button I'm always got a balnk ID
:
: ===
: <%
: ID = request("ID")
: MySQL2= "Delete from soon where ID = " & ID & ""
: 'conn.Execute(MySQL2)
: response.write(MySQL2)
: 'response.redirect("soon1.asp")
: %>
: ===
: Any idea ?
:
: A. J.
:
: *** Sent via Developersdex http://www.developersdex.com ***
: Don't just participate in USENET...get rewarded for it!

Ken Schaefer
9/29/2003 10:57:19 AM
On soon-del.asp can you do the following please?

<%
For Each Item in Request.Form

Response.Write(Item & " = " & Request.Form(Item) & "<br>")

Next
%>

so we can see what is in the Request.Form collection.

Cheers
Ken


[quoted text, click to view]
: Thanks for your reply
: here is the code
: ===
: <html>
: <head>
: <title></title>
: </head>
: <body>
: <Form name="MyForm" method="POST" action="soon-del.asp">
: <input type="radio" value="<%=rs("ID")%>" name="ID">
: <input type="submit" value="Delete" name="Del" style="font-family:
: Tahoma; font-size: 10pt; color:#0000FF">
: </Form>
: </BODY></HTML>
:
: ===
:
:
:
:
: A. J.
:
: *** Sent via Developersdex http://www.developersdex.com ***
: Don't just participate in USENET...get rewarded for it!

AddThis Social Bookmark Button