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_ReqDetailOver viewgood_U pdate.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_ReqDetailOver
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">
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,
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.TDA_UIC)
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
ASKER
:) I tried that as well. "invalid number ", both the fields are "CHAR"s
I'll check the second option - thanks
I'll check the second option - thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ~MCW07CAA0 0
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...
It passes the values toretrieve file with "Variable GRIDKEY is undefined." error - see http:
MRE_ReqDetailOverviewgood_
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...
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#'
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#'
WHERE MRE_REQUIREMENT.ACN ='#GetToken(URL.CFGRIDKEY, 1,'~')#'an d MRE_REQUIREMENT.TDA_UIC = '#GetToken(URL.CFGRIDKEY,2 ,'~')#'
Hope this works.
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
WHERE MRE_REQUIREMENT.ACN ='#ACN#'and MRE_REQUIREMENT.TDA_UIC = '#TDA_UIC#'
Good job - thanks for your help
ASKER
Excellent support - thanks
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,"~")>