Ask a Question related to ASP Database, Design and Development.
-
Geoff Wickens #1
Updating database information
I am trying to collect information from a form on one page and then pass it
to the page with the code below for processing. I can get the data to update
when I use code as below. My problem comes that I want to use the data
collected in my form in the UPDATE statement. Any assistance would be
gratefully received.
<%
e = Request.Form("eventid")
d = Request.Form("ddate")
b = Request.Form("band")
t = Request.Form("ttime")
v = Request.Form("venue")
n = Request.Form("notes")
c = Request.Form("confirm")
Set Catalog=Server.CreateObject("ADODB.Recordset")
Catalog.open "UPDATE tblbookings SET ddate = '13/12/05' WHERE eventID = 11",
"DSN=calendar"
%>
<p>Booking amended.</p>
<p>Return to <a href="admin.asp">Admin</a> page</p>
Geoff Wickens Guest
-
Updating FTP Information for already existing roles
I have a Contribute 4 site set up with a ton of different access roles set up - I'm hoping I don't have to redo them. Here's my situation. We... -
updating database
I posted this in the general dis part too but maybe this is better place since it has to do with forms... here is my problem I need to overcome.... -
Selecting/Updating information using command buttons
I have a simple database that has an area for users to store address information on a "SITE" form. This includes the postcode/zip code,... -
Updating Database with ASP
Hi, I'm just learning how to use ASP and I've been trying to figure out how to add records to my database. I'm learning it out of a book and... -
Microsoft Cursor Engine - Insufficient base table information for updating or refreshing.
Hi, Since my db upgrade from SQL 7 to SQL 2000, one of my MTS objects fails with the error: "0x80004005 Microsoft Cursor Engine - Insufficient... -
Geoff Wickens #2 Re: Updating database information
The code I am trying to use is:
<%
e = Request.Form("eventid")
d = Request.Form("ddate")
b = Request.Form("band")
t = Request.Form("ttime")
v = Request.Form("venue")
n = Request.Form("notes")
c = Request.Form("confirm")
Set Catalog=Server.CreateObject("ADODB.Recordset")
Catalog.open "UPDATE tblbookings SET ddate =" & d & " WHERE eventID =" & e,
"DSN=calendar"
%>
<p>Booking amended.</p>
<p>Return to <a href="admin.asp">Admin</a> page</p>
"Geoff Wickens" <gwickens@hotmail.com> wrote in message
news:wwo3b.971$Ah5.432@newsfep1-gui.server.ntli.net...it> I am trying to collect information from a form on one page and then passupdate> to the page with the code below for processing. I can get the data to11",> when I use code as below. My problem comes that I want to use the data
> collected in my form in the UPDATE statement. Any assistance would be
> gratefully received.
>
> <%
> e = Request.Form("eventid")
> d = Request.Form("ddate")
> b = Request.Form("band")
> t = Request.Form("ttime")
> v = Request.Form("venue")
> n = Request.Form("notes")
> c = Request.Form("confirm")
>
>
> Set Catalog=Server.CreateObject("ADODB.Recordset")
>
> Catalog.open "UPDATE tblbookings SET ddate = '13/12/05' WHERE eventID => "DSN=calendar"
>
>
>
> %>
> <p>Booking amended.</p>
> <p>Return to <a href="admin.asp">Admin</a> page</p>
>
>
Geoff Wickens Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
