Op 2010-06-22 13:54, Alan T het geskryf: > > When I run it, I got error saying the SQL syntax is incorrect near > SELECT LAST_INSERT_ID() As NewPersonID > > Should I use > SELECT @NewPersonID := LAST_INSERT_ID();
I have never used MySQL so I have no idea. Better read the MySQL SQL syntax documentation. Sorry. Regards, - Graeme - ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ tiOPF-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/tiopf-talk
