For Julian Please

[Andy]

Hi Julian
After spending most of yesterday trying out various tutorial on inserting
into multiple tables, I came across your one. Within 5 mins it was working.
Thank you.

I wonder if you could advise on how to retrieve the UserID which is inserted
into the first table and insert it into the second table. I have got it all
working using a hidden field and static value for the USerID, but now I'm
stuck again.

Hope you can point me in the right direction.

Thanks Again

Andy

[Julian Roberts]

What code have you got? I think the example does show how to get the new ID
from one table and insert it into another.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Andy]

Hi Jules
I'm using the code below. Access 200 & classic ASP

<%
if Request("selected") <> "" then
RSProducts.AddNew
RSProducts("Product_Title")=Request("Product_Title ")
RSProducts("Product_Description")=Request("Product _Description")
RSProducts("Product_Image")=Request("Product_Image ")
RSProducts.Update
RSPrices.AddNew
RSPrices("ProductID")=Request("ProductID")
RSPrices("Price")=Request("Product_Price")
RSPrices.Update
Response.Redirect("charoninsert.asp")
end if
%>


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d3nudb$9lq$1@forums.macromedia.com...

> What code have you got? I think the example does show how to get the new
> ID from one table and insert it into another.
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>

[Andy]

Jules
I tried this but it didn't work!

<%
if Request("selected") <> "" then
RSProducts.AddNew
RSProducts("Product_Title")=Request("Product_Title ")
RSProducts("Product_Description")=Request("Product _Description")
RSProducts("Product_Image")=Request("Product_Image ")
RSProducts.Update
Session("ProductID")=RSProducts("ProductID")
RSPrices.AddNew
RSPrices("ProductID")=Session("ProductID")
RSPrices("Price")=Request("Product_Price")
RSPrices.Update
Response.Redirect("charoninsert.asp")
end if
%>



"Andy" <AndyjhughesNOSPAM@ntlworld.com> wrote in message
news:d3nuob$a5s$1@forums.macromedia.com...

> Hi Jules
> I'm using the code below. Access 200 & classic ASP
>
> <%
> if Request("selected") <> "" then
> RSProducts.AddNew
> RSProducts("Product_Title")=Request("Product_Title ")
> RSProducts("Product_Description")=Request("Product _Description")
> RSProducts("Product_Image")=Request("Product_Image ")
> RSProducts.Update
> RSPrices.AddNew
> RSPrices("ProductID")=Request("ProductID")
> RSPrices("Price")=Request("Product_Price")
> RSPrices.Update
> Response.Redirect("charoninsert.asp")
> end if
> %>
>
>
> "Julian Roberts" <newsg@charon.co.uk> wrote in message
> news:d3nudb$9lq$1@forums.macromedia.com...

>> What code have you got? I think the example does show how to get the new
>> ID from one table and insert it into another.
>>
>> --
>> Jules
>> [url]http://www.charon.co.uk/charoncart[/url]
>> Charon Cart 3
>> Shopping Cart Extension for Dreamweaver MX/MX 2004
>>
>>
>>

>
>
>
>