Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Insert Record - Get ID from Session Variable

Insert Record - Get ID from Session Variable

Thread began 4/07/2009 2:57 am by Ian | Last modified 4/08/2009 8:11 am by Ian | 7466 views | 7 replies

4/08/2009 6:13 amIan

Hi Ray,

A bit more info here, and I dont know if I am barking up the wrong tree.

If I add this line

Session("var_auctionid") = WA_AppBuilderRecordset.Fields.Item(WA_indexField).Value

AFTER this one

if (NOT WA_AppBuilderRecordset.EOF) then Session(WA_sessionName) = WA_AppBuilderRecordset.Fields.Item(WA_indexField).Value

Which in theory is doing the same thing, but without using the WA function variables and excluding the "If NOT" statement then I get this error:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/members/additem.asp, line 55

Which suggests the the extension is not picking up the newly inserted record - which does exist by the way because I checked the SQL table and also the ID field is definately an autonumber.

Thanks
Ian

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.