RE: Help with resolving a variable...
actually what I did was
Then in the insert statement for the values I did
'#Evaluate(surnamecomm)#'
-Original Message-
From: Bruce, Rodney (Contractor) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:18 PM
To: CF-Talk
Subject: RE: Help with resolving a variable...
I believe it would be one of these
or
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:09 PM
To: CF-Talk
Subject: RE: Help with resolving a variable...
Ok wait still confused...
Evaluate(WHAT?)
For instance Evaluate(surname_Comm) doesn't work
nor does Evaluate(#surname#_Comm)
Sorry just not sure how to display it properly... Was using a CFSET tag like
That gives an error Makes surnamecomm = to
Evaluate(smith_comm) instead of just smith_comm I am probably missing
something minor...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate. I set a comma delimited list of names and
> then create a loop to create 3 questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
>
> It creates this part fine and as you can see for each
> category there are 3 radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to
> resolve all the values rather than have to type up 200 separate values
> in the insert statement.
>
> However if I want to loop through on the insert page similarly to how
> I am looping through on the form I can't resolve the variable. Because
> if I pass a value named smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value
of
> smith_comm by looping through? Any ideas??
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help with resolving a variable...
Then in your INSERT:
#Evaluate(TempVar)#
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 12:09 PM
Subject: RE: Help with resolving a variable...
> Ok wait still confused...
> Evaluate(WHAT?)
> For instance Evaluate(surname_Comm) doesn't work
> nor does Evaluate(#surname#_Comm)
> Sorry just not sure how to display it properly... Was using a CFSET tag like
>
> That gives an error
>
> Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm
> I am probably missing something minor...
>
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 16, 2002 3:03 PM
> To: CF-Talk
> Subject: Re: Help with resolving a variable...
>
>
> Evaluate()
> Use that to find the value of the vars you are dynamically building the
> names for
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Macromedia Associate Partner
> www.macromedia.com
>
> - Original Message -----
> From: "Kelly Matthews" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 16, 2002 11:46 AM
> Subject: Help with resolving a variable...
>
>
> > Ok we have a survey where we have to rate each person in 3 categories.
> > We have 50 people to rate. I set a comma delimited list of names and
> > then create a loop to create 3 questions
> > for each person, so we can rate each of the 50 people in the 3 categories.
> > Looks like this:
> >
> >
> >
> > > style="background: white">
> > > style="background: BBE9FF">
> > > style="background: 9DCBFF">
> >
> >
> > > style="background: white">
> > > style="background: BBE9FF">
> > > style="background: 9DCBFF">
> >
> >
> > > style="background: white">
> > > style="background: BBE9FF">
> > > style="background: 9DCBFF"> > name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
> >
> > It creates this part fine and as you can see for each
> > category there are 3 radio buttons all
> > w/ the same name. So if the surname for the first person were smith the
> > first set of radio
> > buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> > It does this for all 50 people, works great.
> >
> > Here is the problem when I hit submit I want to loop through to
> > resolve all the values rather than have to type up 200 separate values
> > in the insert statement.
> >
> > However if I want to loop through on the insert page similarly to how
> > I am looping through on the form I can't resolve the variable. Because
> > if I pass a value named smith_comm
> > I can't loop through to get the value of smith_comm...
> > Meaning an insert statement like:
> >
> >
> >
> > INSERT INTO SCORES
> > (#trim(Surname)#_Comm)
> > VALUES
> > ('#trim(surname)#_comm') (obviously that won't work because it will
> > insert a value of smith_comm instead of say "3" How do I find the value
> of
> > smith_comm by looping through? Any ideas??
> >
> >
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
Ok I figured it out, ignore my last message. Thanks again!
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate. I set a comma delimited list of names and
> then create a loop to create 3 questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
>
> It creates this part fine and as you can see for each
> category there are 3 radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to
> resolve all the values rather than have to type up 200 separate values
> in the insert statement.
>
> However if I want to loop through on the insert page similarly to how
> I am looping through on the form I can't resolve the variable. Because
> if I pass a value named smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value
of
> smith_comm by looping through? Any ideas??
>
>
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
#result#
(Should write 2)
Jerry
>>> [EMAIL PROTECTED] 01/16/02 03:09PM >>>
Ok wait still confused...
Evaluate(WHAT?)
For instance Evaluate(surname_Comm) doesn't work
nor does Evaluate(#surname#_Comm)
Sorry just not sure how to display it properly... Was using a CFSET tag
like
That gives an error
Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm
I am probably missing something minor...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate. I set a comma delimited list of names and
> then create a loop to create 3 questions
> for each person, so we can rate each of the 50 people in the 3 categories
.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background:
5785FF">
>
> It creates this part fine and as you can see for each
> category there are 3 radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to
> resolve all the values rather than have to type up 200 separate
values
> in the insert statement.
>
> However if I want to loop through on the insert page similarly to how
> I am looping through on the form I can't resolve the variable. Because
> if I pass a value named smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value
of
> smith_comm by looping through? Any ideas??
>
>
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
I believe it would be one of these
or
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:09 PM
To: CF-Talk
Subject: RE: Help with resolving a variable...
Ok wait still confused...
Evaluate(WHAT?)
For instance Evaluate(surname_Comm) doesn't work
nor does Evaluate(#surname#_Comm)
Sorry just not sure how to display it properly... Was using a CFSET tag like
That gives an error
Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm
I am probably missing something minor...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate. I set a comma delimited list of names and
> then create a loop to create 3 questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
>
> It creates this part fine and as you can see for each
> category there are 3 radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to
> resolve all the values rather than have to type up 200 separate values
> in the insert statement.
>
> However if I want to loop through on the insert page similarly to how
> I am looping through on the form I can't resolve the variable. Because
> if I pass a value named smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value
of
> smith_comm by looping through? Any ideas??
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
Ok wait still confused...
Evaluate(WHAT?)
For instance Evaluate(surname_Comm) doesn't work
nor does Evaluate(#surname#_Comm)
Sorry just not sure how to display it properly... Was using a CFSET tag like
That gives an error
Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm
I am probably missing something minor...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate. I set a comma delimited list of names and
> then create a loop to create 3 questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
>
> It creates this part fine and as you can see for each
> category there are 3 radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to
> resolve all the values rather than have to type up 200 separate values
> in the insert statement.
>
> However if I want to loop through on the insert page similarly to how
> I am looping through on the form I can't resolve the variable. Because
> if I pass a value named smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value
of
> smith_comm by looping through? Any ideas??
>
>
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
oh dammit that's right I knew there was a solution cuz I had this problem
well over
a year ago just couldn't remember. Thanks Bryan! :)
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate. I set a comma delimited list of names and
> then create a loop to create 3 questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
>
> It creates this part fine and as you can see for each
> category there are 3 radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to
> resolve all the values rather than have to type up 200 separate values
> in the insert statement.
>
> However if I want to loop through on the insert page similarly to how
> I am looping through on the form I can't resolve the variable. Because
> if I pass a value named smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value
of
> smith_comm by looping through? Any ideas??
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate.
> I set a comma delimited list of names and then create a loop to create 3
> questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF">
>
>
> style="background: white">
> style="background: BBE9FF">
> style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
>
>
> It creates this part fine and as you can see for each category there are 3
> radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to resolve all
> the values rather
> than have to type up 200 separate values in the insert statement.
>
> However if I want to loop through on the insert page similarly to how I am
> looping through on the
> form I can't resolve the variable. Because if I pass a value named
> smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
>
>
>
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value of
> smith_comm by looping through? Any ideas??
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate.
I set a comma delimited list of names and then create a loop to create 3
questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
It creates this part fine and as you can see for each category there are 3
radio buttons all
w/ the same name. So if the surname for the first person were smith the
first set of radio
buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
It does this for all 50 people, works great.
Here is the problem when I hit submit I want to loop through to resolve all
the values rather
than have to type up 200 separate values in the insert statement.
However if I want to loop through on the insert page similarly to how I am
looping through on the
form I can't resolve the variable. Because if I pass a value named
smith_comm
I can't loop through to get the value of smith_comm...
Meaning an insert statement like:
INSERT INTO SCORES
(#trim(Surname)#_Comm)
VALUES
('#trim(surname)#_comm') (obviously that won't work because it will
insert a value of smith_comm instead of say "3" How do I find the value of
smith_comm by looping through? Any ideas??
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
