> -Original Message-
> From: Mark Benson [mailto:[EMAIL PROTECTED]
> If I try that it returns:
> You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE' at
line 1
> so I guess something doesn't work there. I also tried it with and
without the line ending and it didn't work ei
On Thursday, December 16, 2004, at 05:21PM, Norland, Martin <[EMAIL PROTECTED]>
wrote:
>"INSERT INTO `foobar2` SET part_no='$data[0]', foo_no='$data[1]',
>alt_no='$data[2]', descript='$data[3]', price='$data[4]',
>unit_sale='$data[5]', unit_issue='$data[6]', weight='$data[7]',
>brand='$data[8]'
> -Original Message-
> From: Mark Benson [mailto:[EMAIL PROTECTED]
> The following SQL statement returns an error. What is wrong with it?
The error is stated as being near 'ON DUPLICATE KEY
> UPDATE foo_no='$data[1]', alt_no='$data[2]', descript='$data[3]', pr'
>
> "INSERT INTO `foobar2`
The following SQL statement returns an error. What is wrong with it? The error
is stated as being near 'ON DUPLICATE KEY UPDATE foo_no='$data[1]',
alt_no='$data[2]', descript='$data[3]', pr'
"INSERT INTO `foobar2` SET part_no='$data[0]', foo_no='$data[1]',
alt_no='$data[2]', descript='$data[3]'
