TO is a reserved word in mySQL. Most probably that is causing an error. What's the error message you get?
Will -----Original Message----- From: Walter Conti [mailto:[EMAIL PROTECTED] Sent: 08 January 2008 22:31 To: CF-Newbie Subject: MSAccess v. MySQL query error Please help an abs_newbie coming from MSAccess. The db is MySQL: <cfset url.id = "XXXXXXE9-112F-AF35-A2532AE2F80E1930"> <cfset x = "[EMAIL PROTECTED]"> this query works ok: <cfquery name="addEmailAddr" datasource="firme"> INSERT INTO friendsEmails( petition )values( <cfqueryparam value='#url.id#' cfsqltype="CF_SQL_varchar"> ) </cfquery> this one doesn't, it bums at the second param: <cfquery name="addEmailAddr" datasource="firme"> INSERT INTO friendsEmails( petition, to )values( <cfqueryparam value='#url.id#' cfsqltype="CF_SQL_varchar">, <cfqueryparam value='#x#' cfsqltype="CF_SQL_varchar"> ) </cfquery> Thanks very much. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3227 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
