Hi guys,<BR>Upon inserting a record, I want to immediately gather its unique ID value so that I can push this value across to another table.<BR><BR>How is this best done?<BR><BR>Thanks,<BR>late nights
Read the FAQ on this.<BR><BR>Craig.
too easy!<BR><BR>idOfAddedRecord = objRS("ID")<BR>response.write idOfAddedRecord & "<BR>"<BR><BR>How robust is this? Im not likely to have this fall over am I?<BR><BR>late nights
...caused a problem so far.<BR><BR>Oliver.
...supposed to read: "It's very robust. I've used it a lot and it never caused a problem so far."<BR><BR>Oliver.
robustness is less of an issue with it than out-and-out performance. the SQL method is always faster<BR><BR>how much traffic have you had against it?
...ID when first creating a new account, so it wasn't overloaded. Did you have problems with it then?<BR><BR>Oliver.