Pls help. Dynamic Field Name and DB Insert using ColdFusion
Posted on 2004-08-30
I have this page where I am using my database to store field names for my user interface. I have reasons for this.
The one problem I am facing is with my database insert.
I have a text box where the user can "update" a value
I am trying to write an update statement that will handle a field name that is dynamic??
<cfquery name="qGetData" datasource="#myDsn#">
SET someValue = '#FORM.fieldvalue#'
WHERE UserID = '#FORM.UserID#'
My problem is the dynamic part. I can't SET the someValue = '#FORM.fieldvalue#' because the #fieldvalue# is dynamic. Since the page is dynamically created, I do not know the name of the field....
Can anyone help?