need help with boolean field 1

[slickwillyslim]

i was thinking of putting a yes/no field in my Access database (order table), so that when a user completes the order, assuming they've added several different items, the boolean field will go from false to true. if they quit the session before completing the order i would like to use a sessionid or something to delete that user's order contents with code in the session on_end based on the boolean field remaining false. is it possible to change the database boolean field from false to true from an ASP page? if yes, how?

 

[Veep]

set conn=server.createobject("adodb.connection")
conn.open YourConnectionString
strSql="Update tbl_Orders SET didTheyOrderAnything = 0 " _
& "WHERE SessionID =" & WhateverTheirSessionThatYouSavedIDIs
conn.execute(strSql)