|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
writing to a database, please help! |
|
From: |
casey |
|
Date: |
4/8/2001 7:35:42 PM |
|
IP: |
128.174.0.218 |
We are trying to write to a database and we keep getting an error with out code. If anyone could please help us, it would be greatly appreciated!
'The following is the connection to the TimeSlot Table Elizabeth
Dim rsTimeSlot
Set rsTimeSlot = Server.CreateObject("ADODB.Recordset")
rsTimeSlot.Open "Timeslot", objConn, adOpenFowardly, adLockOptimistic, adCmdTable
rsTimeSlot("PersonID") = Session("PersonID")
rsTimeSlot("AgencyID") = "E1"
rsTimeSlot("ZoneID") = "E1"
rsTimeSlot("WeekID") =
"Select Case (Request.Form("WeekID"))
Case "One"
rsTimeSlot("WeekID) = "1"
Case "Two"
rsTimeSlot("WeekID) = "2"
Case "Three"
rsTimeSlot("WeekID) = "3"
Case "Four"
rsTimeSlot("WeekID) = "4""
rsTimeSlot.Update
|
Follow Up - Re: writing to a database, please help! - Akshay 4/10/2001 3:21:18 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
