Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > newbie question

Reply
Thread Tools

newbie question

 
 
Auddog
Guest
Posts: n/a
 
      01-07-2005
I'm passing a variable in a Request.QueryString and now I'm wanting to
insert that variable into my database along with other information from the
form. All the other inserts use something like this adoRS("fk_projectid") =
Request.Form("title"). I just can't seem to get the varibale that I pass
into the database. Below is my code

<%
DIM adoDB, adoRS, objConn, id
id = Request.QueryString("id")
' Create the Database Object, and connect to it
Set adoDB = Server.CreateObject("ADODB.Connection")
adoDB.Open strConnection
' Create the Recordset Object
Set adoRS = Server.CreateObject("ADODB.RecordSet")
adoRS.Open "ShopLog", adoDB, adLockOptimistic, adCmdTable

adoRS.AddNew
adoRS("fk_projectid") = Request.Write("id")
adoRS("sd_title") = Request.Form("title")
adoRS("copies") = Request.Form("copies")
adoRS("duedate") = Request.Form("duedate")
adoRS.Update

' Tidy up afterwards
adoRS.Close
Set adoRS = Nothing
adoDB.Close
Set adoDB = Nothing
%>


 
Reply With Quote
 
 
 
 
McKirahan
Guest
Posts: n/a
 
      01-07-2005
"Auddog" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm passing a variable in a Request.QueryString and now I'm wanting to
> insert that variable into my database along with other information from

the
> form. All the other inserts use something like this adoRS("fk_projectid")

=
> Request.Form("title"). I just can't seem to get the varibale that I pass
> into the database. Below is my code


[snip]

adoRS("fk_projectid") = id


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VONAGE Newbie w/newbie question New_kid@nowhere.new VOIP 0 08-11-2007 01:40 PM
another newbie question from another newbie.... Lee UK VOIP 4 05-17-2005 04:10 PM
newbie: cisco vlan newbie question No Spam Cisco 3 06-07-2004 10:02 AM
dumb newbie question (or newbie dumb question) Jerry C. Perl Misc 8 11-23-2003 04:11 AM
Newbie! I'm a newbie! What's wrong with this program? Id0x Python 4 07-20-2003 11:40 PM



Advertisments