Re: Difficulty with forms and dynamically named variables

2007-08-30 Thread Judah McAuley
Chris Martin wrote: > When you do the database update, you'll have to run the select query > again and then use... > > > Evaluate is almost never, ever needed. SUBCAT is a dynamic key in the struct FORM. Happily, Coldfusion will evaluate the variable name and then working inside to out, the

RE: Difficulty with forms and dynamically named variables

2007-08-30 Thread Bobby Hartsfield
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Hugh Fidgen [mailto:[EMAIL PROTECTED] Sent: Thursday, August 30, 2007 10:25 AM To: CF-Talk Subject: Difficulty with forms and dynamically named variables Hiya, I'm trying to c

Re: Difficulty with forms and dynamically named variables

2007-08-30 Thread Nick de Voil
Hugh > I'm trying to create a query based form which reads it's elements from a > database table, then populates itself. Each input element would have be > dynamically named via the DB query. > > Creating the form isn't so bad, but handling the insert query the other side > is becoming a heada

Re: Difficulty with forms and dynamically named variables

2007-08-30 Thread Chris Martin
When you do the database update, you'll have to run the select query again and then use... INSERT INTO METADATA (ID, KEY, VALUE) VALUES ('#ID#', '#theSubCat#','#hello#') Chris Martin --- Gandy Ink Information Technology Department [EMAIL PROTE

Difficulty with forms and dynamically named variables

2007-08-30 Thread Hugh Fidgen
Hiya, I'm trying to create a query based form which reads it's elements from a database table, then populates itself. Each input element would have be dynamically named via the DB query. Creating the form isn't so bad, but handling the insert query the other side is becoming a headache. I can

Difficulty with forms and dynamically named variables

2007-08-30 Thread Hugh Fidgen
Hiya, I'm trying to create a query based form which reads it's elements from a database table, then populates itself. Each input element would have be dynamically named via the DB query. Creating the form isn't so bad, but handling the insert query the other side is becoming a headache. I can