really oughtta be wrapping those values in <cfqueryparam> tags.
----- Original Message -----
From: Ketan Patel
To: CF-Talk
Sent: Thursday, January 08, 2004 1:42 PM
Subject: Need help with preservesinglequotes() while inseting.
Hi All,
I am having hard time with preservesinglequotes() function in access table.
I have a insert statement with following
<cfquery datasource="#request.dsn#" name="insItem" dbtype="ODBC">
INSERT INTO products
( id,
state,
sku,
keywords,
meta_description,
image_a,
image_b,
title,
short_description,
content,
taxable,
price,
build_date,
edit_date,
admin_user,
ship_code,
meta_title,
vendorid
)
VALUES(
'#trim(variables.newid)#',
#trim(getitem.Active)#,
'#trim(GetItem.sku)#',
'#trim(preservesinglequotes(getitem.kws))#',
'#trim(preservesinglequotes(getitem.descs))#',
'#trim(preservesinglequotes(getitem.image))#',
'#trim(preservesinglequotes(getitem.image2))#',
'#trim(preservesinglequotes(getitem.name))#',
'#trim(preservesinglequotes(getitem.title))#',
'#trim(preservesinglequotes(getitem.description))#',
1,
'#trim(getitem.price)#',
#CreateODBCDateTime(todayDate)#,
#CreateODBCDateTime(todayDate)#,
'demo',
0,
'#trim(preservesinglequotes(getitem.thetitle))#",
'#trim(getitem.VID)#'
)
</cfquery>
Following are the values getting inserted in to my access table
INSERT INTO products
( id, state, sku, keywords, meta_description, image_a, image_b, title,
short_description, content, taxable, price, build_date, edit_date,
admin_user, ship_code, meta_title, vendorid )
VALUES(
'E72168FA-988F-455F-9CB6615CB6181EC1',
1,
'BEY-SQ509-SHIPSWHEELCLOCK',
'13 1/2" Brass/Oak Ship's Wheel Clock,nautclocks,nautical gifts,ocean
gifts,sea themed gifts',
'Nautical Gifts Online carries and other nautclocks.Quartz clock in solid
brass tarnishproof porthole, solid oak ship's wheel.<br>Dia: 13 1/2", D: 3
1/2"',
'/weather/SQ509.jpg',
'',
'13 1/2" Brass/Oak Ship's Wheel Clock', '13 1/2" Brass/Oak Ship's Wheel
Clock from White Marlin Designs.',
'Quartz clock in solid brass tarnishproof porthole, solid oak ship's
wheel.<br>Dia: 13 1/2", D: 3 1/2"',
1,
'231.0000',
{ts '2004-01-08 15:15:02'},
{ts '2004-01-08 15:15:02'},
'ocean',
0,
'13 1/2" Brass/Oak Ship's Wheel Clock - nautclocks at Nautical Gifts
Online",
'DD9036B6-8C91-41E6-ABEC1157E85B86F4' )
Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
"It's Not Creative if it doesn't Sell."
http://www.g3group.com <http://www.g3group.com>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
