Isn't "memo" a reserved word? It could be a difference in jdbc driver,
and that might be the difference that would cause it to choke on one
server and not the other. Maybe try putting that field-name in
brackets [memo].
Cheers,
Kris
> <cfquery name="test" datasource="#dsn#">
> INSERT INTO orders (OrderNumber, CustomerID, CrtItemID, CrtProductID,
> CrtProductName, CrtPrice, CrtQuantity, QuotedShipping, FiguredTax,
> OrderStatus, DateOfOrder, PaymentMethod, OrderCompleted, ShippingMethod,
> DiscountAmount, OrderTotal, ShippedTo, memo, TrackingNumber, CrtType,
> CrtApproved, FraudFlag, FraudReason, VisitorIP, downloads, paid) VALUES
> ('11070609310342', 3, '6', 'SCSticker', 'Silver Comet Sticker', '9', '3',
> '0', '0.72', 'Received', '2006-11-07', 'CreditCard', 'No', 'N/A', '0', '9.72',
> 'Tom McNeer<br> <br> 1735 Johnson Road NE <br> Atlanta, GA 30306<br>US', '',
> '0', 'Normal', 'No', '', '', 'N/A', '0^0', 'no')
> </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259554
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
