Posted by cmk128 on 07/05/07 03:27

Hi
If i execute mysql_query with this string:
INSERT INTO `order`
(`revisionFamily`,`revisionNumber`,`PI_ID`,`invoiceNumber`,`date`,`customerModel`,`country`,`brandname`,`productNumber`,`quantity`,`lorryType`,`deliveryDate`,`FONO`,`PONO`,`ISSUED`,`ISSUED_Department`,`fuseCustomText`,`powerCableText`,`vde`,`socketUL`,`socketCustom`,`socketCustomText`,`waveLengthAM`,`waveLengthMW`,`waveLengthFM`,`waveLengthLW`,`waveLengthSW`,`waveLengthCustom`,`waveText`,`outputW`,`cdYes`,`cdNo`,`remoteYes`,`remoteNo`,`carsetNo`,`cassetAuto`,`cassetAllStop`,`cassetHalfStop`,`cassetSoundNo`,`casset1`,`casset2`,`cassetModNo`,`cassetAC`,`cassetMagnet`,`cd33`,`cd45`,`cd78`,`cdAutoStop`,`cdText`,`led`,`ledText`,`lcd`,`backLightYes`,`backLightNo`,`backLightColor`,`dc`,`phono`,`spkJack`,`beatCut`,`75ohmApproval`,`75ohm2NonApproval`,`mic`,`6.3`,`speaker35`,`aux`,`plugOtherCheckBox`,`speakerStandard`,`speakerCustom`,`speaker1Way`,`speaker2Way`,`speaker3Way`,`speakerText`,`speakerColor`,`speakerOther`,`mainColor`,`packing`,`catalog`,`warrantyCard`,`caution`,`laserClass1`,`thermalFseFitted`,`voltage`,`cablePaper`,`soundCase`,`back`,`paperText`,`dateCode`,`serialNo`,`barcodeNoLabel`,`paperOther`,`paperOtherText`,`spare2Text`,`AQL`,`outerCase`,`qcCompany`,`madeInChina`,`remarksPhoto`,`remarks`,`socketOtherRemarks`,`stockOutPhoto`,`stockOutClosing`,`stockOutETD`,`stockOutETA`,`stockOutVessel`,`stockOutInvoiceNo`,`stockOutMateReceiptDate`,`shipmentWith2Weeks`,`destination`,`LCno`,`LSD`,`ChequeNo`,`qcDate`,`qcConfirm`,`engineNotesPhoto`,`engineNotes`,`marketingNotesPhoto`,`marketingNotes`,`qcNotesPhoto`,`qcNotes`,`tips`,`warrantyCardPhoto`,`plasticBag`,`cdSheet`,`customerConfirm`,`shipHead1`,`shipHead2`,`colorA`,`QtyA`,`colorB`,`QtyB`,`colorC`,`QtyC`,`posted`,`giftBoxAttachment`,`cosmeticAttachment`,`boxAttachment`,`catalogAttachment`)
select
`revisionFamily`,`revisionNumber`,`PI_ID`,`invoiceNumber`,`date`,`customerModel`,`country`,`brandname`,`productNumber`,`quantity`,`lorryType`,`deliveryDate`,`FONO`,`PONO`,`ISSUED`,`ISSUED_Department`,`fuseCustomText`,`powerCableText`,`vde`,`socketUL`,`socketCustom`,`socketCustomText`,`waveLengthAM`,`waveLengthMW`,`waveLengthFM`,`waveLengthLW`,`waveLengthSW`,`waveLengthCustom`,`waveText`,`outputW`,`cdYes`,`cdNo`,`remoteYes`,`remoteNo`,`carsetNo`,`cassetAuto`,`cassetAllStop`,`cassetHalfStop`,`cassetSoundNo`,`casset1`,`casset2`,`cassetModNo`,`cassetAC`,`cassetMagnet`,`cd33`,`cd45`,`cd78`,`cdAutoStop`,`cdText`,`led`,`ledText`,`lcd`,`backLightYes`,`backLightNo`,`backLightColor`,`dc`,`phono`,`spkJack`,`beatCut`,`75ohmApproval`,`75ohm2NonApproval`,`mic`,`6.3`,`speaker35`,`aux`,`plugOtherCheckBox`,`speakerStandard`,`speakerCustom`,`speaker1Way`,`speaker2Way`,`speaker3Way`,`speakerText`,`speakerColor`,`speakerOther`,`mainColor`,`packing`,`catalog`,`warrantyCard`,`caution`,`laserClass1`,`thermalFseFitted`,`voltage`,`cablePaper`,`soundCase`,`back`,`paperText`,`dateCode`,`serialNo`,`barcodeNoLabel`,`paperOther`,`paperOtherText`,`spare2Text`,`AQL`,`outerCase`,`qcCompany`,`madeInChina`,`remarksPhoto`,`remarks`,`socketOtherRemarks`,`stockOutPhoto`,`stockOutClosing`,`stockOutETD`,`stockOutETA`,`stockOutVessel`,`stockOutInvoiceNo`,`stockOutMateReceiptDate`,`shipmentWith2Weeks`,`destination`,`LCno`,`LSD`,`ChequeNo`,`qcDate`,`qcConfirm`,`engineNotesPhoto`,`engineNotes`,`marketingNotesPhoto`,`marketingNotes`,`qcNotesPhoto`,`qcNotes`,`tips`,`warrantyCardPhoto`,`plasticBag`,`cdSheet`,`customerConfirm`,`shipHead1`,`shipHead2`,`colorA`,`QtyA`,`colorB`,`QtyB`,`colorC`,`QtyC`,`posted`,`giftBoxAttachment`,`cosmeticAttachment`,`boxAttachment`,`catalogAttachment`
from `order` where id=1

I got an error, but if i execute it in mysql client, this sql is ok.
why?
thanks
from Peter (cmk128@hotmail.com)

[Back to original message]