I can't see it. I'm talking about ) (paranthisis) NOT ' (single quote). Also, why
don't you use <cfqueryparam> on that value?
Pascal
-----Oorspronkelijk bericht-----
Van: Brook Davies [mailto:[EMAIL PROTECTED]
Verzonden: vr 19/09/2003 17:57
Aan: CF-Talk
CC:
Onderwerp: RE: Help! Inserting WDDX into the database
Actual it's there is you look closely...
At 09:48 AM 9/19/2003 +0200, you wrote:
>I think you are missing a closing parenthisis:
>'#tempWddxData2#'
>)
></cfquery>
>
>Pascal
>
> -----Oorspronkelijk bericht-----
> Van: Brook Davies [mailto:[EMAIL PROTECTED]
> Verzonden: do 18/09/2003 22:37
> Aan: CF-Talk
> CC:
> Onderwerp: Help! Inserting WDDX into the database
>
>
>
> I have a WDDX packet that, no matter what I try, generates an
> error when I
> try to insert it into a SQL 7.0 DB. Any ideas?
>
> My Query looks like this:
>
> <cfwddx input="#tempWddxData#" output="tempWddxData2"
> action="cfml2wddx">
> <!--- add a new member to an existing pool --->
> <cfquery datasource="#request.datasource#" name="AddMember">
> insert into LeadDistr_members (
> usr_id,
> form_id,
> LeadDistrID,
> member_name,
> priority,
> wddxdata
> )
> values
> (
> <cfqueryparam cfsqltype="cf_sql_integer"
> value="#getmembers.usr_id#">,
> <cfqueryparam cfsqltype="cf_sql_integer"
> value="#getmembers.form_id#">,
> <cfqueryparam cfsqltype="cf_sql_integer"
> value="#newprofileID#">,
> <cfqueryparam cfsqltype="cf_sql_varchar"
> value="#getmembers.member_name#">,
> <cfqueryparam cfsqltype="cf_sql_integer"
> value="#getmembers.priority#">,
> '#tempWddxData2#'
> </cfquery>
>
>
> I end up with an error like the one below. Also below is the
> outputted SQL
> Statement from the debugger:
>
>
>==========================================================================================
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver][SQLServer]Line 16: Incorrect
> syntax
> near 'City
>
>
>==========================================================================================
>
> SQL insert into LeadDistr_members ( usr_id, form_id, LeadDistrID,
> member_name, priority, wddxdata ) values ( (param 1) , (param 2)
> , (param
> 3) , (param 4) , (param 5) , '<wddxPacket
> version=''1.0''><header/><data><struct><var
> name=''field1''><string>City</string></var><var
> name=''field2''><string></string></var><var
> name=''field3''><string></string></var><var
> name=''value2''><string></string></var><var
> name=''value3''><string></string></var><var
>
>name=''value1''><string>asdfasdf</string></var></struct></data></wddxPacket>'
>
>
>
>==========================================================================================
>
> I've spent an hour trying everything I can think of. Now I am
> stumped.
>
> Brook Davies
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137868
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
