RE: Dynamic queries within a loop

I don't know if this will make a difference, but try using alternating quote types. Like this: Might make a difference. -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Tuesday, May 06, 2014 10:32 AM To: cf-talk Subject: Re: Dynamic queries within a

Re: Dynamic queries within a loop

>> I am not understanding the variables part? >> >> Do I create a local var? Can you give me the exact syntax? > >Every variable scope in CF can be treated as a structure. So, if you do this: > > > >it's equivalent to doing this: > > > >and this: > > > >The last example shows a literal string bein

Re: Dynamic queries within a loop

> I am not understanding the variables part? > > Do I create a local var? Can you give me the exact syntax? Every variable scope in CF can be treated as a structure. So, if you do this: it's equivalent to doing this: and this: The last example shows a literal string being used to create

Re: Dynamic queries within a loop

>errrŠ Variables["getCourse" & I].CREDITDESIGNATIONTO > >One of those bad boys. > > > >On 4/18/14, 10:28 AM, "Bobby" wrote: > >> Hi Bobby I am not understanding the variables part? Do I create a local var? Can you give me the exact syntax? ~

Re: Dynamic queries within a loop

>errrŠ Variables["getCourse" & I].CREDITDESIGNATIONTO > >One of those bad boys. > > > >On 4/18/14, 10:28 AM, "Bobby" wrote: > >> Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Antholo

Re: Dynamic queries within a loop

errrŠ Variables["getCourse" & I].CREDITDESIGNATIONTO One of those bad boys. On 4/18/14, 10:28 AM, "Bobby" wrote: > >Variables["getCourse" & i & ".CREDITDESIGNATIONTO©÷] > > >On 4/18/14, 9:42 AM, "Torrent Girl" wrote: > >> >>This actually worked for me: #evaluate("getCourse" & i & >>".CREDIT

Re: Dynamic queries within a loop

Variables["getCourse" & i & ".CREDITDESIGNATIONTO²] On 4/18/14, 9:42 AM, "Torrent Girl" wrote: > >This actually worked for me: #evaluate("getCourse" & i & >".CREDITDESIGNATIONTO")# > >but of course everyone will tell me not to use evaluate. > >How can I rewrite this properly? > > > ~~

Re: Dynamic queries within a loop

This actually worked for me: #evaluate("getCourse" & i & ".CREDITDESIGNATIONTO")# but of course everyone will tell me not to use evaluate. How can I rewrite this properly? ~| Order the Adobe Coldfusion Anthology now! http://w

Re: Dynamic queries within a loop

> Perhaps you do a cfset above the second proc > > > > Then reference that in the tag > > > > the thing that's popping out to me is your "in" params > > cfsqltype="CF_SQL_DATE" > variable="fromDate" > value="#getCourse#i#.CREDITDESIGNATIONFROM#"> > cfsqltype="CF_

Re: Dynamic queries within a loop

Perhaps you do a cfset above the second proc Then reference that in the tag the thing that's popping out to me is your "in" params something looks very wrong here. Like you almost want to dynamically evaluate a queryname #eval("getCourse" & i & ".CREDITDESIGNATIONTO")# (BTW, the

Dynamic queries within a loop

Hello, I have an issue that I am hoping you all can help me with. I have a loop, in which I need to call a coldfusion query that is dynamic. I then need to call another query, based on the first query and output the results dynamically. I am stuck on this. Here is my loop and queries: