The way I dealt with this was to use the undocument cfusion_encrypt function - works just like encrypt(), but it only encrypts to alphanumeric characters, ensuring that it's sql safe.
----- Original Message ----- From: "Kola Oyedeji" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 26, 2001 9:50 AM Subject: problem inserting encrypted wddx packet into database > Hi - sorry for the cross post > > I hope someone can shed some light on the best way to do this. I have a > structure which is turned into a wddx packet and then encrypted. However > when I try save it to the database I get an error: > > SQL = "UPDATE sales SET serializedStruct = 'M&L0?@(.FF/?2CD&718NI3'. > E.>>P>X0SL'4PJ<;_@^7D8S!!L@/49.#6D'S M"-=6[ZQ8Q91K:898NQG'Q*I)[_"SMEO8V > &:J$V]6_*RN(NM<+>6J-3^ 1JH > MQTZWNUO-FB80Y91+E/79?&$G]$D=K1+Q$5JLV57]D@/WGAY^C!Z/M:O[_;C% > MRHR:SJ:AE<>JT8/: L(&4_)QMS$L%UZB0F0_<8&"[6:1JF3BI'- YR!_;[S > M*6F:O1/=.#>^P-W,);RK)$Z[]=3!Q4Z2K1>CF,"/HD&:#_&,F526"*@"XO"- > @CKWU9LB,4Z&K\$ ' WHERE transactionNumber = '195572' AND CustomerID = > 232387" > > I'm assuming its because of some of the characters the encrypt tag spits > out(such as commas and quotes) as when I save it using URlencodedFOrmat its > fine. But when I do that and its time to de-serailize it I get the following > error: > > XML parsing error: not well-formed (error code 4, line 1, column 22, buffer > offset 22) > > Thanks in advance for any light you can shed on this> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
