I am a new member of the list and expect this has been discussed, my apologies. Having recently upgraded our NT mysql, I'm suddenly having a problem with last_insert_id: rstemp.open "select last_insert_id() as recordid",connection used to work by now gives an error, is this a known bug? If not I'll provide details, thank you all. -- Dan Cappannari --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php