Thanks for everyone's help on the hash problems, I've gone and done it the
way Dave has suggested.
!-- Update the answers in the database --
cfloop index=i from=1 to=#CheckQuestions.recordCount#
cfquery name=UpdateAnswers datasource=user020
UPDATE
True...but sometimes I prefer the simpler more readable loop example for
debugging, I guess I'm thinking back to pre CF 5.0 days...assuming that cfdump
came available with CF 5.0?
Andrew.
You don't use that for anything other than debugging do you? You'll get all
form fields which you might
Hi guys,
I've got a problem whereby I'm trying to reference my looped variable in an
SQL statement.
!-- Update the answers in the database --
cfloop index=i from=1 to=#CheckQuestions.recordCount#
cfquery name=UpdateAnswers datasource=user020
UPDATE
#form.answer##i# tries to return the value of form.answer, followed by
the value of i. You want something like this:
form[answer i]
HTH.
--Ben
Stuart Kidd wrote:
Hi guys,
I've got a problem whereby I'm trying to reference my looped variable in an
SQL statement.
!-- Update
- Original Message -
From: Stuart Kidd [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, April 21, 2005 12:45 PM
Subject: More hash on the mailing list
Hi guys,
I've got a problem whereby I'm trying to reference my looped variable in
an
SQL statement
If your form fields are named answer1, answer2, etc. then reference them
like this in the query:
#FORM[answer i]#
Ade
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: 21 April 2005 20:45
To: CF-Talk
Subject: More hash on the mailing list
Hi guys,
I've got
I've got a problem whereby I'm trying to reference my looped
variable in an SQL statement.
!-- Update the answers in the database --
cfloop index=i from=1
to=#CheckQuestions.recordCount#
cfquery name=UpdateAnswers datasource=user020
UPDATE
Hi guys,
I've got a problem whereby I'm trying to reference my looped variable in an
SQL statement.
If I want to check the output of some form variables I output them like so
(notice how the looped variable is referenced: #form[t]):
cfoutput
cfloop index=t list=#form.fieldnames#
Message-
From: Andrew Grosset [mailto:[EMAIL PROTECTED]
Sent: 22 April 2005 02:20
To: CF-Talk
Subject: More hash on the mailing list
Hi guys,
I've got a problem whereby I'm trying to reference my looped variable in an
SQL statement.
If I want to check the output of some form variables I
9 matches
Mail list logo