5 messages in com.mysql.lists.win32How do I get insetid back
FromSent OnAttachments
Nimoy Pugh04 Nov 1999 18:49 
Brian Andrews04 Nov 1999 23:26 
Sinisa Milivojevic05 Nov 1999 03:11 
Nimoy Pugh05 Nov 1999 07:19 
Tim Endres05 Nov 1999 07:43 
Subject:How do I get insetid back
From:Nimoy Pugh (npu@ro.com)
Date:11/04/1999 06:49:24 PM
List:com.mysql.lists.win32

I rewriting a perl app in vbscript on NT. I used Active State's perl first and it works just like it did on the UNIX platform. Not I'm using an odbc connection from with in an asp vbscript.

Set DBH = Server.CreateObject("ADODB.Connection") DBH.Open "database","password" Query="insert into orders (order_no) values ('')" set rs=dbh.execute(Query)

What do I do to get at the insert id (the order_no is an auto increment field). On a whim I tried rs("insertid") but it didn't like that.