You use a SELECT *

This is usually a bad habit as it makes the SQL engine do extra work &
degrades performance -- in this case, it also causes confusion.'

What is the name of the column in the query that contains the style
name?

Dick
On Apr 13, 2004, at 9:53 AM, Joy Holman wrote:

> Yes, I want to output the stylenames as the html code is generated.
>  Sorry, I added the list after sending the previous code. (Actually, I
> don't care if I have a list of the stylenames or not; I just want to
> get one of the style name values from the query into each of the
> onClick events.) The format of the list is defaulted to commas.
>  Here's the code with the CF list.
>
>  <cfquery��name="q_menu" datasource="mchfaq">
>  SELECT * from qa_menu
>  order by menu_sortText
>  </cfquery>
>  <cfoutput>
>  <cfset bmarklinkList = #ValueList(q_menu.menu_bmarkLink)#>
>
>  <script language="_javascript_" type="text/_javascript_">
>  <!--
>  function targetid(){
>  return #bmarklinkList#;
>  }
>  -->
>  </script>
>  </cfoutput>
>
>  <ul>
>  <cfoutput query="q_menu">
>  <li><A��HREF="" q_menu.menu_nonBmarkLink neq
> "">"#q_menu.menu_nonBmarkLink#"><cfelse>"##Ans"
>  
> </a></li>
>  </cfoutput>
>  </ul>
>
>  Basically, if the href value is an external URL, ignore the rest of
> the if statement. If the href value is a bookmark link, have the href
> go to a specific position on the page, (#Ans), and using CSS display
> the previously hidden content of the style names in the onClick.
>
>  I've substituted style name values where the js goes, like so:
>  <li><A HREF="" q_menu.menu_nonBmarkLink neq"">
> "#q_menu.menu_nonBmarkLink#"><cfelse>"##Ans"
>  
> </a> </li>
>
>  <li><A��HREF="" q_menu.menu_nonBmarkLink
> neq"">"#q_menu.menu_nonBmarkLink#"><cfelse>"##Ans"
>  
> </a> </li>
>
>  <li><A��HREF="" q_menu.menu_nonBmarkLink
> neq"">"#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans"
>  
> </li>
>
>  I'd really like this to work. I think I could use this code a lot.
>  Thanks again.
>  Joy
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to