I thought it would be useful to have a place to put handy tit-bits on programming the database side of things here.

-- Anonymous, March 04, 2002

Answers

This shows how to get output parameters from stored procs back to the application via ADODB.

I was just reading my ASP book, which describes use of stored procs from ADO (or ADODB - what's the diff?) and came across this great page: http://www.aspalliance.com/stevesmith/articles/sprocs.asp it has loads of stuff on getting back the row id of a row just added and various workarounds. Do you fancy trying to get the script listed in http://www.aspalliance.com/stevesmith/articles/adocode.asp working on ceetak. It might be useful for testing etc.

-- Anonymous, March 04, 2002

Hi all,

Not sure if this is usefull to you, for Ultradev.

Retrieve Autonumber Shows you how to insert a record into a table and then retrieve the newly created autonumber into a session variable.

http://www.charon.co.uk/UltradevDownloads_UD4.asp

Andy

-- Anonymous, March 07, 2002