MSAccess v. MySQL query error

[Walter Conti]

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:3226
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15