Creating txt via ASP to feed Generator Listboxes

Building a Generator based dynamic Flash Site we need to feed some Generator List Boxes with the results of a query. The query is pulled up by some ASP code. The results of the query have to be converted into as many txt files as we have Listboxes. To enable Generator to read them, the text files have to look as follows and should be in the same folder as the ASP file: clip, instanceName, content (-- this is how the header has to look like) txt1, DB column instanceName, sql processed txt1, DB column instanceName, sql Processed txt1, DB column instanceName, sql Processed clip: txt1 has to be always the same in one textfile (see specifications below) DB column instanceName: uniqueID (part of the SQL query; could alternatively be autogenerated by some script) sql processed: Value that must go into the Generator Listbox (result of prequery. Since we just need a customisable template, you can use the same query field for all of the listboxes) Important is that the number of records has to be variable, according to the number of results of the SQL query (there will always have to be a different number of entries in our Generator Listbox). Since the textfile must change accordingly to the results of each query, we need some scripting that gets rid of the old txt files onLoad of a new html page (maybe the front page, but that has to be flexible ??" we should be able to place the script into any page we need). See [login to view URL] for more details ## Deliverables - The list boxes of [login to view URL] in (gensearch) all need to be populated with the contents of the 3 dynamically generated txt files. - A Script, which deletes all the generated text files onLoad of any website we specify - Manual that enables us to customise the scripts in a way that we can generate more txt files and change the content of the clip column (The content for “instanceName?? and “categories?? has to be dynamically generated) and the headers of all the columns. ## Deadline information We need an example by the end of the week. Everything has to be finished by the end of next week