Now - I did consider something like that from seeing it in sample code.. but can you answer me this? Why would you go through that when the <cfoutput query=""> does the same thing?
The line I am actually putting out refers back to the original window that spawned it.. so it is <a href= "javascript:opener.document.location='http://www.speedpeople.com/cart/de tails.cfm?ItemID=#GetWheelCodes.ItemID#';this.window.location='http://ww w.speedpeople.com/ApplicationGuides/WheelAppGuide/WheelAppControl.cfm'" <javascript:opener.document.location='http://www.speedpeople.com/cart/de tails.cfm?ItemID=#GetWheelCodes.ItemID#';this.window.location='http://ww w.speedpeople.com/ApplicationGuides/WheelAppGuide/WheelAppControl.cfm'> TARGET="_parent" class="DarkYellowFont">#GetWheelCodes.ItemName# : #UnitPrice#</a> Is it a performance thing? Would it be worth converting that link above into the sample you provided? Thanks! jay Tyler Clendenin wrote: actually i woud say this: <cfoutput> Here is the list<br>#ArrayToList(GetWheelCodes["ItemCode"], "<br>")# </cfoutput> ----- Original Message ----- From: "Chris Kief" <mailto:[EMAIL PROTECTED]> <[EMAIL PROTECTED]> To: "CF-Talk" <mailto:[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Sent: Friday, June 07, 2002 6:26 PM Subject: RE: Dreamweaver MX You might want to do it like this actually (we don't want "Here is the list:" over and over and over again) Here is the list:<br> <cfoutput query="GetWheelCodes"> #GetWheelCodes.ItemCode#<br> </cfoutput> -----Original Message----- From: Chris Kief [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Friday, June 07, 2002 3:23 PM To: CF-Talk Subject: RE: Dreamweaver MX Simple...you need to loop your output like this... <cfoutput query="GetWheelCodes"> Here is the list:<br> #GetWheelCodes.ItemCode#<br> </cfoutput> The query part of the cfoutput tag is the key...it tells ColdFusion to loop over the block of code between the <cfoutput> tags for each result in your query. HTH...chris -----Original Message----- From: Jason Miller [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Friday, June 07, 2002 6:18 PM To: CF-Talk Subject: Re: Dreamweaver MX Hello All - I am having some serious problems on what I feel should be easy. I have 4 frames - from left to right. I run queries on each frame and pass the variables - at the end resulting with a list of relevant products. So I am having problem with the list. I get a specific product - but only 1 where I should be getting a list of 4 or 5 - The product I am getting is correct though. Code is - <cfquery name="GetBoltPattern" datasource="mine"> SELECT BoltPattern FROM WheelAppGuide WHERE Make = '#Make#' AND Model = '#Model#' </cfquery> <cfoutput><cfset BoltPattern="#GetBoltPattern.BoltPattern#"></cfoutput> <!-- then compare to right set of numbers of item code from items --> <cfquery na me="GetWheelCodes" datasource="mine"> SELECT ItemID, ItemName, ItemCode FROM Items WHERE Right(ItemCode, 4) = '#BoltPattern#' </cfquery> Now - on outputting this list - very simply - I only get 1 item - in many cases I should get like 10 or so. <cfoutput>Here is the list:<br> #GetWheelCodes.ItemCode#<br></cfoutput> Do I need to loop the query in GetWheelCodes for some reason? please help - I am going on ridicioulous amount of hours working on this silly little thing. thanks!!!!!!!!!! jason ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
