Hey all,
I've been working with PHP for a while now, but up until now I've dealt mostly with MySQL and Oracle databases. I need to know if anyone out there knows how to use ADO to insert a row into a Microsoft SQL database and get the id of the inserted row back. I can do it using SELECT MAX(id) FROM table, but that's not going to work once multiple client apps are updating the database at once. I figure there must be a way. If anyone can help me with this problem I would really appreciate it. Thanks.
A.
I've been working with PHP for a while now, but up until now I've dealt mostly with MySQL and Oracle databases. I need to know if anyone out there knows how to use ADO to insert a row into a Microsoft SQL database and get the id of the inserted row back. I can do it using SELECT MAX(id) FROM table, but that's not going to work once multiple client apps are updating the database at once. I figure there must be a way. If anyone can help me with this problem I would really appreciate it. Thanks.
A.