Insert XML Data into MySQL database

Question

Hi everyone, I'm very new with XML and I need help with
inserting XML data into mysql database using coldfusion. I looked
on the Coldfusion Documentation and saw how to Convert XML to a
Coldfusion query....but there was no example on how to do an
insert. If anyone can provide me a good example or direct me to a
right direction on how to do this, I would really appreciate it.

Thank you very much in advance
Alfie

alfie9 · Accepted Answer

Nevermind, I finally got it to work!!!!

alfie9 · Answer

I have a sample code on how to insert xml data into mysql using coldfusion, but I am getting an error "Out of range value adjusted for column "Id" at row 1" anyone have any ideas on why I am getting this error?

Thank you
Alfie

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.