Hi Everyone,

I was wondering is it possible to have a script that when a visitor fills out an online form and submits it, the information is saved in a database as several file types, such as csv, xml, and etc?

If the above script is possible... when visitors submit the form, can the script also update the current files by adding the information from the form to the current files? No matter how many people fill out the form, I only want one file for each file type.

Please let me know if this is possible so I can go hire a programmer.

Regards,
Brandon

Yeah, you can, although it's an awkward design decision. IMO, you don't store information "in a database as several file types". You store information in the database it its own format. Then when you need to have a CSV version of the data, you export it to that format.

The CSV or XML or any other file version of your data is just another representation of the same data. Let the database store it in its own format, and then specify how you want it (in what format) when you actually need the data.

Imar---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Store it in one format only and use XSL(T) to transform it to whatever you want

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/