Re: SQL Error on INSERT

From: John Blessing (jb_at_**REMOVE**THIS**LbeHelpdesk.com)
Date: 03/19/05 

Date: Sat, 19 Mar 2005 10:03:12 -0000

<westernnord@webtv.net> wrote in message
news:OqNE$BELFHA.2420@TK2MSFTNGP12.phx.gbl...
> Here is the new error I am getting after some code changes:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression '131150 09 BA'.
> /xmlListener.asp, line 69
>
> Here is the Response.Write of the "sqlString" variable:
>
> INSERT INTO cart ( cart_user_id, cart_store_id, cart_product_id,
> cart_gift_wrap, cart_gift_wrap_price, cart_item_number, cart_item_name,
> cart_item_attributes, cart_item_quantity, cart_item_price ) VALUES ( 423,
> 6, 0, 1, 4.95, 131150 09 BA, Men's Leather Slippers, 09 / 43 BLACK, 2,
> 150.00 )

Any text values must be wrapped in single quotes. If your text value
already containsa single quote you need to replace every occurrence with
two, so your sql looks like:

NSERT INTO cart ( cart_user_id, cart_store_id, cart_product_id,
cart_gift_wrap, cart_gift_wrap_price, cart_item_number, cart_item_name,
cart_item_attributes, cart_item_quantity, cart_item_price ) VALUES ( 423, 6,
0, 1, 4.95, '131150 09 BA', 'Men''s Leather Slippers', '09 / 43 BLACK', 2,
150.00 ) 

-- 
John Blessing
http://www.LbeHelpdesk.com - Help Desk software priced to suit all 
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings 
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

Relevant Pages
Loading