Please do not hesitate to contact us if you have any problems.
Jeff Zanzinger
Trowbridge and Associates
321-725-2981 (Phone)
[EMAIL PROTECTED]
100% Committed to Customer Satisfaction
-----Original Message-----
From: Jeff Zanzinger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 7:56 AM
To: '[EMAIL PROTECTED]'
Subject: MySQL insert issue related to a unique column
I have a MySQL 40 column table where I select an entire row then insert
it into another (different) 40 column table. For some reason the insert
fails and after much troubleshooting I've isolated the cause to a field
heading labeled prod_num. This field is a type varchar(10) and it's
value is 1090C. If I set the value to 1090 it works ok. I've also
tried TINYTEXT same problem. If I use the value 1090C in other fields
works ok so problem seems to be related to field labeled prod_num.
Another mystery, if I reset the value in my script to 1090C after the
select the insert also works OK. I have checked to make sure there are
no new line returns and just don't know what else to try.
This problem is keeping me up at night and appreciate any advice.
Jeff Zanzinger
DCI
321-725-2981 (Phone)
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
