Insert entire XML into database

i have created form variable "frmdata" , , init form .xdp xml schema data binding.
after user filled in form , submitted, there way can retrieve xml , store entire xml database(ms sql)?
i'm using database qpac (jdbc.jar) insert value.

i tried following sql statement value stored empty.

insert claimdetails(formdata)
values ('{$/process_data/frmdata$}');

any idea?

thanks,
leia

hi
try like:
{$ serialize(/process_data/frmdata/form-data/data/*,false) $}

i haven't tried it, think should work.

{$ serialize(/process_data/frmdata/form-data/data/xdp/datasets/data/*, false) $}
will give results deeper in hierarchy.

bear in mind, if xml data contains quote (') character, prematurely complete values clause , cause sql error.

howard

More discussions in LiveCycle pre-ES (6.x and 7.x) discussions

adobe