Hi,
I have an insert query that runs perfectly on my development server, but
fails with a syntax error when run on a client's site (shared hosting).
The database is Access (I know, I know -- not my idea), and I've confirmed
over and over again that the local and remote copies of the database are
identical.
Here's the query:
<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>
This inserts a record properly when run on my dev server. When run on the
remote server, CF reports a syntax error in the SQL. Both SELECT and INSERT
queries have been run against the same database. SELECTs run fine against
this table. Only the above INSERT seems to fail, and only on the remote
server.
This is very weird. Has anyone ever seen anything like this?
--
Thanks,
Tom
Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:259441
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
