Avatar of Nigel-SA
Nigel-SA
 asked on

How do you pass 2 parameters in cfgridcolumn href?

I can pass 1 value, I need to pass ACN & TDA_UIC

<cfgridcolumn name="ACN" header="ACN"  href="../MRE_ReqDetailOverviewgood_Update.cfm" hrefkey="TDA_UIC" select="false">

Then on resultspage.cfm I'm using #URL.CFGRIDKEY# to create link

Any help appreciated. - thanks.

<cfgridcolumn name="ACN" header="ACN"  href="../MRE_ReqDetailOverviewgood_Update.cfm" hrefkey="TDA_UIC" select="false">

Open in new window

ColdFusion Language

Avatar of undefined
Last Comment
Nigel-SA

8/22/2022 - Mon
Bhavesh Shah

hey author,

i tried find somethng on net but unfortunate didnt found.
but i have 1 solution.....
in ur query make 1 column

ACN & '~' + TDA_UIC as LinkCOlumn

Pass this column in href.

While retriving value,use GetToken

<CFSET ACN = GetToken(GRIDKEY,1,"~")>
<CFSET TDA_UIC = GetToken(GRIDKEY,2,"~")>
Nigel-SA

ASKER
Brichsoft - Thanks - I need some further guidance (novice)
in the query i get "keyword not found where expected"
none of these syntax's work, talking to oracle db:
MRE_PRIORITY_FY.TDA_UIC & '~' + MRE_PRIORITY_FY.ACN As LinkColumn,
(MRE_PRIORITY_FY.TDA_UIC) & '~' + (MRE_PRIORITY_FY.ACN) As LinkColumn,
((MRE_PRIORITY_FY.TDA_UIC) & '~' + (MRE_PRIORITY_FY.ACN)) As LinkColumn,
((MRE_PRIORITY_FY.TDA_UIC) and '~' + (MRE_PRIORITY_FY.ACN)) As LinkColumn,
Bhavesh Shah


Oh....

Its my mistake...

Very sory nigel

this should work
MRE_PRIORITY_FY.TDA_UIC + '~' + MRE_PRIORITY_FY.ACN As LinkColumn,

or

check out this link as i'm not good in oracle.

http://www.codeguru.com/forum/showthread.php?t=307851


secondly, hope both columns are string
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Nigel-SA

ASKER
:) I tried that as well. "invalid number ", both the fields are "CHAR"s

I'll check the second option - thanks
ASKER CERTIFIED SOLUTION
Bhavesh Shah

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Nigel-SA

ASKER
Excellent - it works!  Almost there.
It passes the values toretrieve file with "Variable GRIDKEY is undefined." error - see http:
MRE_ReqDetailOverviewgood_Update.cfm?CFGRIDKEY=012009001~MCW07CAA00
I did as you suggested above:
<CFSET ACN = GetToken(GRIDKEY,1,"~")>
<CFSET TDA_UIC = GetToken(GRIDKEY,2,"~")>

Then in sql I did which does not seem correct:
WHERE MRE_REQUIREMENT.ACN ='#URL.GRIDKEY#'and MRE_REQUIREMENT.TDA_UIC = '#URL.GRIDKEY#'

Thanks for your help, this is huge for me...
Nigel-SA

ASKER
:) Ok GRIDKEY needs to be CFGRIDKEY

Now, how does it distinguish the difference between CFGRIDKEY1 for ACN and CFGRIDKEY1 for TDA_UIC?

WHERE MRE_REQUIREMENT.ACN ='#URL.CFGRIDKEY#'and MRE_REQUIREMENT.TDA_UIC = '#URL.CFGRIDKEY#'
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Bhavesh Shah

WHERE MRE_REQUIREMENT.ACN ='#GetToken(URL.CFGRIDKEY,1,'~')#'and MRE_REQUIREMENT.TDA_UIC = '#GetToken(URL.CFGRIDKEY,2,'~')#'
Bhavesh Shah


Hope this works.
Nigel-SA

ASKER
Brichsoft, actually I just got this working because they're declare in the CFSET above...

WHERE MRE_REQUIREMENT.ACN ='#ACN#'and MRE_REQUIREMENT.TDA_UIC = '#TDA_UIC#'

Good job - thanks for your help
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Nigel-SA

ASKER
Excellent support - thanks