With 4.01 try htmlencodedformat or
<cfwddx action="cfml2wddx" input="#UrlEncodedFormat(your2darray)#"
output="wddx_packet">
or after the db insert when pulling the packet out of the db
<cfwddx action="wddx2cfml" input="#UrlEncodedFormat(wddx_packet)#"
output="YourVar">
or
<cfwddx action="wddx2cfml" input="#HtmlEditformat(wddx_packet)#"
output="YourVar">
You'll probably need to play around with a few different combos to see which
will work.
Not sure of the sitch, but likely all the percent (%) signs are wreaking
havoc on allaires wddx parser.
Steve
----- Original Message -----
From: "zknoll" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 2:33 PM
Subject: reading out my xml packet
> I am putting a 2-D array into an xml packet, storing that packet in a
> memo field in a access 2000 database, and then reading it
> back out. Everything works fine untill the reading back out part. I get
> the following error:
> XML parsing error: no element found (error code 3, line 1, column 0,
> buffer offset -1)
> Now I know there is an element because I can see stuff in that field in
> the database. I think the error could be because I have
> some really wierd characters here is an example of what the xml looks
> like into the database: (see below). Keep in mind I have
> to work within CF version 4.01 so don't give me solutions that I need
> 4.51 for. Thanks
>
> <!-------this snippets from the part where I get it out of the
> database------->
> <cfquery datasource="#cfdatasource#" name="allpers">
> select search1 from personals
> </cfquery>
>
> <!----this line throws the cferror---->
> <cfwddx action="WDDX2CFML" input="#allpers.search1#"
> output="SearchArray">
>
>
> <!----this is what it looks like in the database----------->
>
> <wddxPacket version='0.9'><header></header><data>
> <array length='17'><array length='2'>
> <string>haircolor</string>
> <string> like '%'</string></array><array length='2'>
> <string>eyecolor</string><string>like '%'</string>
> </array><array length='2'><string>heightinch</string>
> <string>like '%'</string></array><arraylength='2'>
> <string>maritalstatus</string><string>like '%'</string>
> </array><array length='2'>
> <string>childrennum</string><string>like '%'</string>
> </array><array length='2'><string>RELIGIOUSOBS</string>
> <string>like '%'</string></array><array length='2'>
> <string>ISRAELLIVE</string><string>like '%'</string>
> </array><array length='2'><string>kosher</string>
> <string>like '%'</string></array><array length='2'>
> <string>education</string><string>like '%'</string>
> </array><array length='2'><string>occupation</string>
> <string>like '%'</string></array><array length='2'>
> <string>smoking</string><string>like '%'</string>
> </array><array length='2'><string>drinking</string>
> <string>like '%'</string></array><array length='2'>
> <string>pets</string><string>like '%'</string></array>
> <array length='2'><string>athletic</string>
> <string>like '%'</string></array><array length='2'>
> <string>gender</string><string>= 'female'</string>
> </array><array length='2'><string>(age</string>
> <string>>1 and age < 121)</string></array>
> <array length='2'><string>not picture</string>
> <string> = 'n/a'</string></array></array></data>
> </wddxPacket>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
