asked on

Using Recordset Value in Insert

I am trying to insert a value into a database. SQL 2000

I have every variable from the previous page passing fine, except for an ID field.

I can display the ID field on the page where the Insert Command is.

I display the ID Field by doing...

<%=(Recordset1.Fields.Item("MemberID").Value)%>

How do I get this in the Dreamweaver Command Insert, I keep getting errors when I try to use
Request.Form("MemberID")
Request("MemberID")

I'm stuck and need help badly!!

Austin

SOLUTION

Garve

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

david_levine

Can you be more specific in the flow of what you are trying to do and where this Member Id is coming from. If it's auto generated, you can get it but AFTER it's been created via an insert statement. Is it that you need this auto generated number that gets created so you can use it elsewhere for other processing/data references?

Also, since you might be using Dreamweaver to do something, I found the following:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_16385

Also see http://www.kamath.com/tutorials/tut004_autonum.asp and

USCBigRed

ASKER

Hey Garve,

i'm not trying to update, and it is a autonumber. i'm just trying to insert the MemberID value into another table

USCBigRed

ASKER

Hey David,

I need to use the autonumber "MemberID"
from my first form and when the user goes to the 2nd form then I want it to auto insert that Autonumber Field into the MemberID field of another table in my database

Austin

ASKER CERTIFIED SOLUTION

david_levine

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

zawedikian

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

USCBigRed

ASKER

ya'll, i'm sooo sorry.

I figured this out!!
I wasn't even passing the value from the previous form

Gosh, i feel stupid.

I'm going to divi up points now, sorry for the troubles...
Austin

david_levine

Way more common then you'd imagine! Those are the "easy" ones to resolve vs having to write blobs of code. Glad it's resolved.