|
 |
asp_databases thread: Retreiving the Rows of the database and allowing the user to delete
Message #1 by "vishal mishra" <vismis@r...> on Wed, 30 May 2001 13:15:57
|
|
Hi,
Retrieving the rows of the database is an easy job which can be done by
passing a simple sql query. But i want to give the user an option of
deleting the rows of the database from that very file in which i am
retrieving it by providing a check box to select and delete.
My example you can understand better if you keep the picture of inbox
of your email acoount which also has the option to delete by selecting it
into the check box.also let me know how i can link the records for further
pages.
Thanks in advance.
Regards,
vishal
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 30 May 2001 23:02:04 +1000
|
|
<%Do While Not objRS.EOF%>
<input type="checkbox" name="delete" value="<% =objRS("ID")%>">
<%
objRS.movenext
Loop
%>
on the next page.
If Request.Form("delete").Count > 0 then
strSQL = "DELETE FROM table1 WHERE ID IN (" & Request.Form("delete") &
")"
objConn.execute(strSQL)
End If
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "vishal mishra" <vismis@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, May 30, 2001 1:15 PM
Subject: [asp_databases] Retreiving the Rows of the database and allowing
the user to delete
: Hi,
: Retrieving the rows of the database is an easy job which can be done by
: passing a simple sql query. But i want to give the user an option of
: deleting the rows of the database from that very file in which i am
: retrieving it by providing a check box to select and delete.
: My example you can understand better if you keep the picture of inbox
: of your email acoount which also has the option to delete by selecting it
: into the check box.also let me know how i can link the records for further
: pages.
: Thanks in advance.
:
: Regards,
: vishal
Message #3 by "stewart severino" <lux_seve@h...> on Wed, 30 May 2001 12:14:01 -0400
|
|
Hi Vishal,
I was wondering if you can me an example of what you are speaking about. I need exactley what you have mentioned in your last reply
Thanks,
Stu
>From: "vishal mishra"
>Reply-To: "ASP Databases"
>To: "ASP Databases"
>Subject: [asp_databases] Retreiving the Rows of the database and allowing the user to delete
>Date: Wed, 30 May 2001 13:15:57
>
>Hi,
> Retrieving the rows of the database is an easy job which can be done by
>passing a simple sql query. But i want to give the user an option of
>deleting the rows of the database from that very file in which i am
>retrieving it by providing a check box to select and delete.
> My example you can understand better if you keep the picture of inbox
>of your email acoount which also has the option to delete by selecting it
>into the check box.also let me know how i can link the records for further
>pages.
> Thanks in advance.
>
> Regards,
> vishal
>
|
|
|
View Cart
