Thanks, Ray, for input
1. I may have misinterpreted what you meant by currentRow, but including it
anywhere produced an error: unknown variable. Leaving off helped (as below
in 3)
2. Doing the len(trim as this:
<cfif len(trim(qHomeNews["banner#b#"]))>
produced an error: Paramenter 1 of function trim must be a basic value.
(same if currentRow added)
3. All worked fine IF I set the query alone, then checked it as:
<CFLoop from="1" to="5" index="b">
<CFSet qry = qNews["banner#b#"]>
<cfif len(trim(variables.qry))>
<CFSet MarqMess = Variables.MarqMess & " " & variables.qry>
etc etc
Not understand why what you had (without currentrow) didn't work, but error
in the trim as noted above.
Here is final code that works--but may still be way to not have to set the
qry string separately.
<cfset MarqMess = "News: ">
<CFLoop from="1" to="5" index="b">
<CFSet qry = qNews["banner#b#"]>
<cfif len(trim(variables.qry))>
<CFSet MarqMess = Variables.MarqMess & " " & variables.qry>
</cfif>
</CFLOOP>
----- Original Message -----
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 10:10 AM
Subject: RE: Not want Evaluate in my loop
> Here ya go...
>
> <cfloop from=1 to=5 index="b">
> <cfif len(trim(qNews["banner#b#"][currentRow]))>
> etc
>
> Basically, you just use bracket notation - but I believe you must also
> specify the correct row number. In this case, I just used currentRow.
> You can try w/o it as well.
>
> =======================================================================
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
>
> Email : [EMAIL PROTECTED]
> WWW : www.camdenfamily.com/morpheus
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -----Original Message-----
> > From: E. Keith Dodd [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, December 12, 2002 9:05 AM
> > To: CF-Talk
> > Subject: Not want Evaluate in my loop
> >
> >
> > I thought I'd done something like this before, but can't
> > locate similar code.
> >
> > Creating a news marquee that can be made up of from 1-5 text
> > fields contained in a larger query. Possibilities are:
> > qNews.Banner1, qNews.Banner2 ... qNews.Banner5
> >
> > Am able to put them together with:
> >
> > <CFSet MarqMess = "News: ">
> > <CFLoop from="1" to="5" index="b">
> > <CFSet qry = "qNews.banner" & b>
> > <cfif len(trim(evaluate(variables.qry)))>
> > <CFSet MarqMess = Variables.MarqMess & " " &
> > evaluate(variables.qry)>
> > </cfif>
> > </CFLOOP>
> >
> > Above works, but thought there should be a way to do this not
> > using the evaluate function.
> >
> > Appreciate any direction.
> > Thanks
> >
> > E. Keith Dodd
> > Wings of Eagles Services
> > www.wingserv.com
-
[This E-mail scanned for viruses by declude AntiVirus Software]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
