It sounds like you need to combine the results from the 2 queries into a single query object....OR write a more complex query to join all the tables involved to produce a single recordset.

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  ----- Original Message -----
  From: Joy Holman
  To: CF-Talk
  Sent: Tuesday, April 13, 2004 11:55 AM
  Subject: Re: passing multiple CF vaules to a _javascript_ variable

  The rendered output is a menu of links. One query column
  returns the text for a link, another query column returns the target for the link. The style name column is used in an onClick event to set a CSS style to display content when clicked.

  The style name doesn't display on screen.

  I'm able to generate all the values I need except for all the
  stylename values. If I only had one result from the query, it would work fine. But I can't get the style name value to change as additional menu items are generated from the query results. Maybe what I need is help with _javascript_.

  I don't know how to explain it any better. I guess that's a drawback of not being able to talk in real time. Thanks for your efforts. I'll keep at it.

  event.

  From the query results, I create the js: target() which returns

  the value of the stylename field. How do I loop over the

  stylename values so that I get one value per onClick event which

  is generates multiple times based on the number of records in

  the query?

  >I am sorry...
  >
  >I can't understand what you are trying to do.
  >
  >It is a simple matter to include the value of a column from the query
  >in a line of text generated within the output tags...
  >
  >But you are already doing that...
  >
  >
  >Maybe this would help me to help you:
  >
  >1) show me a few lines of the rendered output that you desire--- no CF
  >tags, just the rendered output.
  >
  >2) put an asterisk or something in front of each value in the rendered
  >output that you want to dynamically create with your CF code,
  >
  >3) Run your query and display the output of enough rows showing the
  >columns & their values that contain the dynamic data
  >
  >
  >HTH
  >
  >Dick
  >
  >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote:
  >
  >>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to