Re: More hash on the mailing list

2005-04-22 Thread Stuart Kidd
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

RE: More hash on the mailing list

2005-04-22 Thread Andrew Grosset
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

More hash on the mailing list

2005-04-21 Thread Stuart Kidd
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

Re: More hash on the mailing list

2005-04-21 Thread Ben Doom
#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

Re: More hash on the mailing list

2005-04-21 Thread Bryan Stevenson
- 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

RE: More hash on the mailing list

2005-04-21 Thread Adrian Lynch
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

RE: More hash on the mailing list

2005-04-21 Thread Dave Watts
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

More hash on the mailing list

2005-04-21 Thread Andrew Grosset
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#

RE: More hash on the mailing list

2005-04-21 Thread Adrian Lynch
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