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/headerdata
array length='17'array length='2'
stringhaircolor/string
string like '%'/string/arrayarray length='2'
stringeyecolor/stringstringlike '%'/string
/arrayarray length='2'stringheightinch/string
stringlike '%'/string/arrayarraylength='2'
stringmaritalstatus/stringstringlike '%'/string
/arrayarray length='2'
stringchildrennum/stringstringlike '%'/string
/arrayarray length='2'stringRELIGIOUSOBS/string
stringlike '%'/string/arrayarray length='2'
stringISRAELLIVE/stringstringlike '%'/string
/arrayarray length='2'stringkosher/string
stringlike '%'/string/arrayarray length='2'
stringeducation/stringstringlike '%'/string
/arrayarray length='2'stringoccupation/string
stringlike '%'/string/arrayarray length='2'
stringsmoking/stringstringlike '%'/string
/arrayarray length='2'stringdrinking/string
stringlike '%'/string/arrayarray length='2'
stringpets/stringstringlike '%'/string/array
array length='2'stringathletic/string
stringlike '%'/string/arrayarray length='2'
stringgender/stringstring= 'female'/string
/arrayarray length='2'string(age/string
stringgt;1 and age lt; 121)/string/array
array length='2'stringnot 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=listsbody=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=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.