Re: Help with resolving a variable...

2002-01-16 Thread Bryan Stevenson 

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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=You forgot
 to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=You forgot
 to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio
 name=#trim(Surname)#_Extr value=4 style=background: 5785FF
 input name=#trim(Surname)#_Extr_required type=hidden  value=You forgot
 to rate b#trim(Surname)#/b for bExtra Effort/b.
 /CFLOOP
 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 
__
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...

2002-01-16 Thread Kelly Matthews 

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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCommitted to AAAE 
 Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio 
 name=#trim(Surname)#_Extr value=4 style=background: 5785FF 
 input name=#trim(Surname)#_Extr_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bExtra Effort/b. 
 /CFLOOP 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 

__
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...

2002-01-16 Thread Kelly Matthews 

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
CFSET surnamecomm = Evaluate(#surname#_Comm)
That gives an error
CFSET surnamecomm = Evaluate(#surname#_Comm)
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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCommitted to AAAE 
 Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio 
 name=#trim(Surname)#_Extr value=4 style=background: 5785FF 
 input name=#trim(Surname)#_Extr_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bExtra Effort/b. 
 /CFLOOP 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 

__
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...

2002-01-16 Thread Bruce, Rodney (Contractor) 

I believe it would be one of these


CFSET surnamecomm = #Evaluate(surname_#Comm#)#
or
CFSET surnamecomm = #Evaluate(#surname#_Comm)#


-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
CFSET surnamecomm = Evaluate(#surname#_Comm)
That gives an error
CFSET surnamecomm = Evaluate(#surname#_Comm)
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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCommitted to AAAE 
 Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio 
 name=#trim(Surname)#_Extr value=4 style=background: 5785FF 
 input name=#trim(Surname)#_Extr_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bExtra Effort/b. 
 /CFLOOP 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 


__
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...

2002-01-16 Thread Jerry Johnson 

cfset surname=jerry
cfset jerry_comm=2

cfset result=evaluate(#surname#_comm)

cfoutput#result#/cfoutput

(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
CFSET surnamecomm = Evaluate(#surname#_Comm)
That gives an error
CFSET surnamecomm = Evaluate(#surname#_Comm)
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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=Y
ou 
 forgot to rate b#trim(Surname)#/b for bCommitted to AAAE 
 Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=Y
ou 
 forgot to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio 
 name=#trim(Surname)#_Extr value=4 style=background: 
5785FF 
 input name=#trim(Surname)#_Extr_required type=hidden  value=Y
ou 
 forgot to rate b#trim(Surname)#/b for bExtra Effort/b. 
 /CFLOOP 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 


__
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...

2002-01-16 Thread Kelly Matthews 

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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCommitted to AAAE 
 Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio 
 name=#trim(Surname)#_Extr value=4 style=background: 5785FF 
 input name=#trim(Surname)#_Extr_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bExtra Effort/b. 
 /CFLOOP 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 

__
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...

2002-01-16 Thread Bryan Stevenson 

cfset TempVar= #surname#  _Comm

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
 CFSET surnamecomm = Evaluate(#surname#_Comm)
 That gives an error
 CFSET surnamecomm = Evaluate(#surname#_Comm)
 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:
 
  cfloop index=Surname list=#ChunkLast#
  cfset ChunkFirstIndex = ChunkFirstIndex +1
  cfinput type=radio  name=#trim(Surname)#_Comm value=1
  style=background: white
  cfinput type=radio  name=#trim(Surname)#_Comm value=2
  style=background: BBE9FF
  cfinput type=radio  name=#trim(Surname)#_Comm value=3
  style=background: 9DCBFF
  input name=#trim(Surname)#_Comm_required type=hidden  value=You
  forgot to rate b#trim(Surname)#/b for bCommitted to AAAE
  Goals,/b
 
  cfinput type=radio  name=#trim(Surname)#_Cust value=1
  style=background: white
  cfinput type=radio  name=#trim(Surname)#_Cust value=2
  style=background: BBE9FF
  cfinput type=radio  name=#trim(Surname)#_Cust value=3
  style=background: 9DCBFF
  input name=#trim(Surname)#_Cust_required type=hidden  value=You
  forgot to rate b#trim(Surname)#/b for bCustomer Service/b.
 
  cfinput type=radio  name=#trim(Surname)#_Extr value=1
  style=background: white
  cfinput type=radio  name=#trim(Surname)#_Extr value=2
  style=background: BBE9FF
  cfinput type=radio  name=#trim(Surname)#_Extr value=3
  style=background: 9DCBFFcfinput type=radio
  name=#trim(Surname)#_Extr value=4 style=background: 5785FF
  input name=#trim(Surname)#_Extr_required type=hidden  value=You
  forgot to rate b#trim(Surname)#/b for bExtra Effort/b.
  /CFLOOP 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:
  cfloop index=Surname list=#ChunkLast#
  cfset ChunkFirstIndex = ChunkFirstIndex +1
  CFQUERY datasource=SC2002
   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??
  /CFQUERY
 

 
__
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...

2002-01-16 Thread Kelly Matthews 

actually what I did was 
CFSET surnamecomm = #Surname#_Comm
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


CFSET surnamecomm = #Evaluate(surname_#Comm#)#
or
CFSET surnamecomm = #Evaluate(#surname#_Comm)#


-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
CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET
surnamecomm = Evaluate(#surname#_Comm) 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:

 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 cfinput type=radio  name=#trim(Surname)#_Comm value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Comm value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Comm value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Comm_required type=hidden  value=You
 forgot to rate b#trim(Surname)#/b for bCommitted to AAAE 
 Goals,/b

 cfinput type=radio  name=#trim(Surname)#_Cust value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Cust value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Cust value=3
 style=background: 9DCBFF
 input name=#trim(Surname)#_Cust_required type=hidden  value=You
 forgot to rate b#trim(Surname)#/b for bCustomer Service/b.

 cfinput type=radio  name=#trim(Surname)#_Extr value=1
 style=background: white
 cfinput type=radio  name=#trim(Surname)#_Extr value=2
 style=background: BBE9FF
 cfinput type=radio  name=#trim(Surname)#_Extr value=3
 style=background: 9DCBFFcfinput type=radio
 name=#trim(Surname)#_Extr value=4 style=background: 5785FF 
 input name=#trim(Surname)#_Extr_required type=hidden  value=You 
 forgot to rate b#trim(Surname)#/b for bExtra Effort/b. 
 /CFLOOP 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:
 cfloop index=Surname list=#ChunkLast#
 cfset ChunkFirstIndex = ChunkFirstIndex +1
 CFQUERY datasource=SC2002
  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??
 /CFQUERY
 



__
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