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
