RE: [KCFusion] dynamic code

2003-03-07 Thread Matt Jones 

#PreserveSingleQuotes(FORM.Insert_qry)#

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:43 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] dynamic code


I'm trying to run a query that is passed from the form page with embedded CF
variables in it.  It doesn't sound that tough but for some reason I can't
get it to work.  This in under MX and must work in 5, too.  I've tried
various uses of Evaluate and can't get it to resolve the inner variable.
jeff.descr is a form variable and is a local var in the action code.  

Form page contains:
input name=insert_qry type=hidden value=INSERT INTO CUSIPGROUP (DESCR,
CHANGEUSER) VALUES ('#jeff.descr[loopcount]#', 'jabrown')

Action code contains:
cfquery name=qInsert datasource=scooby
#FORM.Insert_qry#
/cfquery


Does anyone know anything that might work?  We are trying to solve our
cfgridupdate problems quickly without rewriting everything and get some
code-reuse, too.

Thanks for the help.

Jeff Brown
State Street - Kansas City
816-871-9441
[EMAIL PROTECTED]



*
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email 
in error please notify [EMAIL PROTECTED]
*

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion] dynamic code

2003-03-07 Thread Matt Jones 
btw you are gonna want to be real careful about doing something like this, this is a 
bad thing, and hidden formfields can be modified by anyone

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:43 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] dynamic code


I'm trying to run a query that is passed from the form page with embedded CF
variables in it.  It doesn't sound that tough but for some reason I can't
get it to work.  This in under MX and must work in 5, too.  I've tried
various uses of Evaluate and can't get it to resolve the inner variable.
jeff.descr is a form variable and is a local var in the action code.  

Form page contains:
input name=insert_qry type=hidden value=INSERT INTO CUSIPGROUP (DESCR,
CHANGEUSER) VALUES ('#jeff.descr[loopcount]#', 'jabrown')

Action code contains:
cfquery name=qInsert datasource=scooby
#FORM.Insert_qry#
/cfquery


Does anyone know anything that might work?  We are trying to solve our
cfgridupdate problems quickly without rewriting everything and get some
code-reuse, too.

Thanks for the help.

Jeff Brown
State Street - Kansas City
816-871-9441
[EMAIL PROTECTED]



*
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email 
in error please notify [EMAIL PROTECTED]
*

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion] dynamic code

2003-03-07 Thread jabrown 
That's true.  This is probably a pretty bad idea.  I'll go back to putting
the query in the action code.  Thanks for the help and quick reply.

-Original Message-
From: Matt Jones [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:46 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] dynamic code


btw you are gonna want to be real careful about doing something like this,
this is a bad thing, and hidden formfields can be modified by anyone

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:43 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] dynamic code


I'm trying to run a query that is passed from the form page with embedded CF
variables in it.  It doesn't sound that tough but for some reason I can't
get it to work.  This in under MX and must work in 5, too.  I've tried
various uses of Evaluate and can't get it to resolve the inner variable.
jeff.descr is a form variable and is a local var in the action code.  

Form page contains:
input name=insert_qry type=hidden value=INSERT INTO CUSIPGROUP (DESCR,
CHANGEUSER) VALUES ('#jeff.descr[loopcount]#', 'jabrown')

Action code contains:
cfquery name=qInsert datasource=scooby
#FORM.Insert_qry#
/cfquery


Does anyone know anything that might work?  We are trying to solve our
cfgridupdate problems quickly without rewriting everything and get some
code-reuse, too.

Thanks for the help.

Jeff Brown
State Street - Kansas City
816-871-9441
[EMAIL PROTECTED]



*
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email 
in error please notify [EMAIL PROTECTED]
*

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]

RE: [KCFusion] dynamic code

2003-03-07 Thread jabrown 
Title: RE: [KCFusion] dynamic code



Thanks. I definitely see the error of my ways.

  -Original Message-From: Dunwiddie, Bruce 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 07, 2003 3:59 
  PMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] 
  dynamic code
  form action=""http://www.statestreetkc.com/somepage.cfm" 
  target=_blank>http://www.statestreetkc.com/somepage.cfm" 
  method="post"  input type="hidden" name="insert_qty" value="truncate 
  master"  input type="button" value="Click me to make someone have a REALLY 
  bad day!!" /form 
  -Original Message- From: Matt 
  Jones [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, March 07, 2003 3:46 PM To: [EMAIL PROTECTED] Subject: RE: 
  [KCFusion] dynamic code 
  btw you are gonna want to be real careful about doing 
  something like this, this is a bad thing, and hidden formfields can be 
  modified by anyone
  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, March 07, 2003 3:43 PM To: [EMAIL PROTECTED] Subject: [KCFusion] 
  dynamic code 
  I'm trying to run a query that is passed from the form page 
  with embedded CF variables in it. It doesn't 
  sound that tough but for some reason I can't get it to 
  work. This in under MX and must work in 5, too. I've tried 
  various uses of Evaluate and can't get it to resolve the 
  inner variable. jeff.descr is a form variable and is a 
  local var in the action code. 
  Form page contains: input 
  name="insert_qry" type="hidden" value="INSERT INTO CUSIPGROUP (DESCR, 
  CHANGEUSER) VALUES ('#jeff.descr[loopcount]#', 
  'jabrown')" 
  Action code contains: cfquery 
  name="qInsert" datasource="scooby" #FORM.Insert_qry# /cfquery 
  
  Does anyone know anything that might work? We are trying 
  to solve our cfgridupdate problems quickly without 
  rewriting everything and get some code-reuse, 
  too. 
  Thanks for the help. 
  Jeff Brown State Street - Kansas 
  City 816-871-9441 [EMAIL PROTECTED] 
  * 
  This email and any files transmitted with it are 
  confidential and intended solely for the use of the 
  individual or entity to whom they are addressed. If 
  you have received this email in error please notify 
  [EMAIL PROTECTED] * 
  
__ 
  The KCFusion.org list and website is hosted by Humankind 
  Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] 
  Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] 
  To Subscribe mailto:[EMAIL PROTECTED] 
  To Unsubscribe mailto:[EMAIL PROTECTED] 
 __ 
  The KCFusion.org list and website is hosted by Humankind 
  Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] 
  Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] 
  To Subscribe mailto:[EMAIL PROTECTED] 
  To Unsubscribe mailto:[EMAIL PROTECTED]