Ask a Question related to Coldfusion Database Access, Design and Development.
-
stillwaiting #1
Insert record from dynamic form problem
XP Pro, CF 6.1(built in webserver), MySQL 4.1.13, DW MX04,
I am trying to insert a records from a dynamic form. I created it all in Dreamweaver MX '04.
The general structure is a multi-purpose form that, depending on a URL variable, dynamically inserts all of the information for the form. When I
created the MM_InsertRecord behavior, it seemed to not have a problem getting the info from the dynamic fields. This is what Dreamweaver wrote and I
just don't understand it well enough to know whether I am getting it right. Below is the error and the line where it occurred but I have a hunch that
it will do this all the way down.
---------------------------------------------------
A CFML variable name cannot end with a "." character.
The variable FORM. ends with a "." character. You must supply an additional structure key or delete the "." character.
The CFML compiler was processing:
* an expression beginning with "IsDefined", on line 6, column 9.This message is usually caused by a problem in the expressions structure.
* a cfif tag beginning on line 6, column 4.
* a cfif tag beginning on line 6, column 4.
The error occurred in C:\CFusionMX\wwwroot\site\admin\data_input.cfm: line 6
4 : <cfquery datasource="fh_places" username="********" password="*******">
5 : INSERT INTO fh_places.lodge_info (name, site, email, phone, address, city,"state", country, zip) VALUES (
6 : <cfif IsDefined("FORM.<cfoutput>#Form_population.positio n_1#</cfoutput>") AND #FORM.<cfoutput>
7 : #Form_population.position_1#</cfoutput># NEQ"">'#FORM.<cfoutput>#Form_population.position_1 #</cfoutput>#'
8 : <cfelse>
-----------------------------------------------------
I will post the complete code, - some repetitive stuff, in a response post so if you want to see more you can.
stillwaiting
stillwaiting Guest
-
Insert Record Wizard problem
For some reason when I use the Insert Record Wizard to set up an ASP.net Insert Record page one of the fields gets inserted with double quotes... -
Ins. Record from dynamic form problem
XP Pro, CF 6.1(built in webserver), MySQL 4.1.13, DW MX04, I am trying to insert a records from a dynamic form. I created it all in Dreamweaver MX... -
form validation with insert record
Hi everyone, i have implemented a simple form(email, name, nick_name, password) for inserting a member into a table, i have written some validation... -
Insert Record (php) - Error, but I have a form on thepage!
I am unable to create an INSERT RECORD behavior for php in DW04 because it says I must have a form. Problem is, I do have a form! I am selecting the... -
Multiple insert - iterate form collection - checkbox name dynamic?
How does one loop through the contents of a form complicated by dynamic construction of checkboxes which are assigned a 'model' and 'listingID' to...



Reply With Quote

