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,
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#'
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,"~")>