MySQL, as of yet, doesn't support sub-selects ! -----Message d'origine----- De : daniel [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 11 juillet 2002 02:37 À : [EMAIL PROTECTED] Objet : subselect in an insert
why is it that this doens't work? INSERT INTO mytable (column0, column1, column2, column3, column4) values ($value0, (SELECT id from othertable where login='$ENV{REMOTE_USER}'), $value2, $value3, $value4)"; the error i'm getting says that there's an error in my sql syntax near 'select id from othertable...' i'm user perl with dbi.pm if that's any help. _________________________________ daniel a. g. quinn starving programmer in the beginning of a change, the patriot is a scarce man, brave, hated and scorned. when his cause succeeds, however, the timid join him, for then it costs nothing to be a patriot. - mark twain --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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