We did some stuff where our users may be pulling a form off the net that
they've never used before, and where they would need to save the form
submitted data to a db on their LAN.
To accomplish this we built the forms, and processing cfm scripts so that it
checked for the existance of the tables in sql7 to hold the data, if they
were there - parse the form.fieldnames var and insert, if the tables did not
exist in the users db's, our cfm scripts created the tables needed, by again
parsing the form.fieldnames cf variable. To accomplish this, our field
names described the column name, datatype and field length.
Form.TableName_ClientFirstName_char_30
This approach may be way more work than its worth to you, but it was a cool
approach for our issues. likey there's better, but... YMMV
Steve
----- Original Message -----
From: "Peter Benoit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 17, 2000 6:40 AM
Subject: Dynamic form submission
> Not sure if this went through or not, since the exchange server at work
> apparently stopped working... :/
>
>
> I have a dynamic number of form fields, which basically depends on the
> number of matching records in the DB. How can I write a dynamic insert or
> update based on an unknown number of form fields?
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.