At 12:56 -0400 5/1/02, Carole E. Mah wrote:
>Does anyone know if the JSTL database tags (<sql>) provide any method for
>retrieving the unique ID of the row that was inserted last (when you set
>up you mySQL database table to AUTO_INCREMENT the unique id).
>
>This is how I do it using PHP, which provides the mysql_insert_id()
>function for just this purpose:
>
> $query = "INSERT INTO foo (name, phone) VALUES ('Jane Doe','555-1212')";
> $LINK = mysql_pconnect ($DB_SERVER, $DB_LOGIN, $DB_PASSWORD);
> $result = mysql_db_query ("$DB", $query);
> $my_id = mysql_insert_id($LINK);
>
>Thanks!
>
>-carole
Don't know of any such thing in JSTL, but you can issue this query
to get the value from the server:
SELECT LAST_INSERT_ID()
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
