Maybe it failed because there was no value for #menu_bmarkLink# when that variable was blank - which would be the case when the menu_nonBmarkLink column had a value. So maybe that column is relevant after all.
I'll pull out the record containing the menu_nonBmarkLink value and see if I get the results you did. At least that will pinpoint the problem better.
Thanks.
Joy
> I created the following test code and it runs just fine, I believe it
> does basically what you are asking code to do.
>
> HTH
>
> <!--- Test Code --->
> <cfscript>
> aQuery = queryNew("menu_bmarkLink,menu_Text,menu_nonBmarkLink");
> tmp = QueryAddRow(aQuery,4);
> tmp = QuerySetCell(aQuery,"menu_bmarkLink","MinorRts",1);
> tmp = QuerySetCell(aQuery,"menu_bmarkLink","FellSvc",2);
> tmp = QuerySetCell(aQuery,"menu_bmarkLink","AmnInf",3);
> tmp = QuerySetCell(aQuery,"menu_bmarkLink","AnteSter",4);
>
> tmp = QuerySetCell(aQuery,"menu_Text","MinorRts Link",1);
> tmp = QuerySetCell(aQuery,"menu_Text","FellSvc Link",2);
> tmp = QuerySetCell(aQuery,"menu_Text","AmnInf Link",3);
> tmp = QuerySetCell(aQuery,"menu_Text","AnteSter Link",4);
>
> </cfscript>
> <cfdump var="#aQuery#">
> <html>
> <head>
> <title>Untitled Document</title>
> <meta http-equiv="Content-Type" content="text/html;
> charset=iso-8859-1">
> <style>
> #FellSvc{display:none;}
> #MinorRts{display:none;}
> #AmnInf{display:none;}
> #AnteSter{display:none;}
>
> </style>
> </head>
>
> <body>
> <ul>
> <cfoutput query="aQuery">
> <li><A HREF="" > > display='block'">#menu_Text#</a></li>
> </cfoutput>
> </ul>
>
> <div id="FellSvc">FellSvc<br/><a href="" > > display='none'">Hide content</a></div>
> <div id="MinorRts">MinorRts<br/><a href="" > > display='none'">Hide content</a></div>
> <div id="AmnInf">AmnInf<br/><a href="" > > display='none'">Hide content</a></div>
> <div id="AnteSter">AnteSter<br/><a href="" > > display='none'">Hide content</a></div>
> </body>
>
<script language="_javascript_">
<!--
window.open = SymRealWinOpen;
//-->
</script>
</html>
>
> <!--- End Test Code --->
> --------------
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

