This was resolved by adding an auto-increment column. MySQL does not seem capable of coping with the situation below.
----- Original Message ----- From: "Dave" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 5:36 PM Subject: INSERT INTO ..... SELECT > I am having problems with this INSERT INTO, below is a example. The SQL is > built in an ASP page and ASPVariable is, well the variable in the ASP page. > > For some reason this will only insert the first row. In my test data the > SELECT alone returns 3 rows, but when added to the INSERT INTO only one rows > gets inserted. > > If I take out the ASPVariable and only have values from TableB in the SELECT > it works fine. > > Will MySQL not allow me to mix variables with table values with this INSERT? > > Cheers > Dave > ------------------------------ > > INSERT INTO TableA (ColumnA, ColumnB, ColumnC) > > SELECT ASPVariable, b.value1, v.value2 > > FROM TableB b > > WHERE b.ValueKey = ASPVariable > > > --------------------------------------------------------------------- > 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