View Full Version : XML as possible storage solution?

09-29-2006, 02:16 PM
I have a couple of forms that have at least 100 fields on them. Only 4 or 5 fields need to be stored in my SQL db, but the entire form needs to be able to be saved as a draft, then upon final submittal saved as a PDF for historical purposes.

Rather than add all of those columns to my db that I really don't need there, I was thinking that upon saving as a draft I could save the form as a XML file. That way when brought back up I could reference the XML tags back into my CFFORM for editing. I have never used XML before, so am I thinking about its functionality correctly? If so, what is the most effective way to accomplish this? I see that there is the CFXML tag and the XMLNew function, but I'm not sure which one I should use. Any guidance is appreciated!