Oh that should be "Hosted" not Hosted events....
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 10 September 2003 13:08
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] UDF problem
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
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
