Creating database fields from Struct(FORM)

[Niles Runeberg]

I have a survey that has a few questions which change every month. I am looking
for a way to edit the HTML only and add the relevant FORM variables, and then
have the system do the rest i.e. create the neccasary variables and then submit
the information.

Here is what I have as a script to generate the database fields...

<cfset VARIABLES.dbScript = "create table survey (">
<cfset VARIABLES.firstLoop = "True">
<cfloop list="#structKeyList(FORM)#" index="currentKey">
<cfscript>
if (VARIABLES.firstLoop IS "True")
{
VARIABLES.dbScript = VARIABLES.dbScript &
currentKey & " VARCHAR2(50)";
VARIABLES.firstLoop = "False";
}
else
{
VARIABLES.dbScript = VARIABLES.dbScript & ", " &
currentKey &
" VARCHAR2(50)";
}
</cfscript>
</cfloop>
<cfset VARIABLES.dbScript = VARIABLES.dbScript & ")">


This is supposed tol generate a simple script for building my database (that's
a simplified Oracle syntax) It's horribly inefficient use of storage, but I
want quick and easy so...

Can I use and modify the procedure above to generate an insert statement from
the form variables? This will actually be my action page, whereas step 2 is
just a widget to help you create the table.

Does this make sense? What I am trying to do is build the survey form, then
using the widget I created in step 2 to build a script to create storage for
the form, simply by filling it out and submitting it to the widget. Then I use
the code in step 3 as my action page, and it will stuff the form fields into
your database.

Will this work? Is this a good idea? Any other suggestions?

[Niles Runeberg]

Should I rephrase the question?