Sigh! I just made the emplid field the same as the last name in both tables. Now both tables are being appropriately updated, but I have the same error as I had before! Unknown column 'underhill' in 'where clause'.
The only where clause is Update respond set Page=$in{'level'} where emplid=$in{'emplid'}. I'm not changing anything outside of the function I've been working in. Help! Diane Schips [EMAIL PROTECTED] www.MainshipSystems.com -----Original Message----- From: Sheila Fenelon [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 1:58 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Perl & mysql help urgently needed! Diane Schips wrote: > > Is it ok that $emplid > is declared locally? How do I return the contents of that field from the > function? If I can return the correct data, that might resolve the other > errors as well. > I see the return $emplid; but what value is stored in it? And didn't you want that to be stored in the table? The 'return' statement should work as long as your call to the function saves the return value: $new_emplid = insert_new_record(); Sheila -- Sheila Fenelon http://www.shefen.com/ ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.