OK..this is a real bitch and I cant see why its not working :
We are using the following UDF (altered from CFLIB):
function QueryGetCellByKeyLinks(theQueryLinks, keyFieldLinks,
keyFieldLinksValue, columnNameLinks){
var key_field_value_list_Links =
Evaluate("ValueList(rsEnhancedBoothSettingsLinks.#keyFieldLinks#)");
var row_number_Links =
ListFindNoCase(key_field_value_list_Links, keyFieldLinksValue);
tVar =
rsEnhancedBoothSettingsLinks[columnNameLinks][row_number_Links];
tColumn = columnNameLinks;
tRowNumber = row_number_Links;
tkeyfieldvaluelist = key_field_value_list_Links;
return
rsEnhancedBoothSettingsLinks[columnNameLinks][row_number_Links];
}
We have a recordset returned from an SP below :
BDISPLAY IEVENTID ILANGUAGEID ILINKDISPLAYALIASID
ILINKID VCLEVEL VCLINKALIAS VCLINKNAME
1 100012 1 1 1 18 A Exhibitor Details
1 100012 1 2 2 18 B Product Gallery
1 100012 1 3 3 18 C Press Releases
1 100012 1 4 4 18 D Brands
1 100012 1 5 5 18 E Contacts
1 100012 1 6 6 18 F Countries
1 100012 1 7 7 18 G Hosted
1 100012 1 8 8 18 H Product Brochure
1 100012 1 9 9 18 I E-Coupons
1 100012 1 10 10 18 J Request a Meeting
1 100012 1 11 11 18 K Regions
1 100012 1 12 12 18 L Send an Email
1 100012 1 13 13 18 M Distributors
1 100012 1 14 14 18 N Suppliers
We are calling it via the following syntax :
<!--- Hosted Events -->
<cfif QueryGetCellByKeyLinks(rsEnhancedBoothSettingsLinks, "VCLINKNAME",
"Hosted Events", "bDisplay") EQ 1>
<cfset vcHostedEventsLink =
QueryGetCellByKeyLinks(rsEnhancedBoothSettingsLinks, "VCLINKNAME", "Hosted",
"VCLINKALIAS")>
</cfif>
Now, this all seems to run AOK, up until Countries, but nothing whatsoever
happens from Hosted Events onwards. The snippet above should be returning
"G" but its returning nada?
Whats the scoop with this?!
Thanks
N
