Creating a dynamic query... doing lots of processing, and then
(eventually) <cfoutput>ing it.
Glad to see i'm not alone! ;-)
Cheers
Gav
On Tue, 15 Mar 2005 15:00:52 +1000, Darryl Lyons
<[EMAIL PROTECTED]> wrote:
> Yeah, I've used the same concept as well. CFMX 7 definately does fix it
> for dynamic queries. Are you getting the data from the database or
> creating a dynamic query?
>
> Darryl Lyons
>
> [EMAIL PROTECTED] wrote on 15/03/2005 02:46:25 PM:
>
> > Hi All,
> >
> > I've got a very strange problem happening with QofQ in CFMX 6.1
> >
> > I'm sure the problem is fixed with the additions to QofQ in CF 7, but
> > 6.1 is defo a problem.
> >
> > There's a simple enough fix, so i figure i'll post it here so anyone
> > that googles for it at a later stage will find the solution.
> >
> >
> > If you have a query, with mainly numbers in one column (but some text
> > too), and try to do a query of query on it, CF gives the following
> > error message:
> >
> > "some text from query" must be interprettable as a valid number in the
> > current locale.
> >
> > The problem (i guess) is that CF looks at the first few records and
> > determines the field type. In my case, the first 100 records were
> > numeric, then i had some text.
> >
> > So to solve it, i just added some text in the first row of the query.
> > I can then do a QofQ later on to remove it.
> >
> > <cfset qSpList = queryNew("course_id,course_type,course_name") />
> > <cfset queryAddRow(qSpList) />
> > <cfset querySetCell(qSpList,"course_id","xx") />
> > <cfset querySetCell(qSpList,"course_type","xx") />
> > <cfset querySetCell(qSpList,"course_name","xx") />
> >
> > I hope that helps someone at some stage.
> >
> > Gav
> >
> > ---
> > You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED]
> > To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> > Aussie Macromedia Developers: http://lists.daemon.com.au/
>
> To unsubscribe from this email please forward this email to [EMAIL PROTECTED]
>
> This email message is confidential and may be privileged. If you are not the
> intended recipient
> please forward the email to [EMAIL PROTECTED] and delete the original.
>
> ABN AMRO Morgans Limited and its associates hold or may hold securities in
> the companies/trusts mentioned herein.
> Any general advice included in this email has been prepared without taking
> into account your objectives, financial situation or needs.
> Before acting on the advice, you should consider its appropriateness or
> discuss with one of our investment advisors.
>
> ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of
> ASX Group.
> A principal member of the Financial Planning Association.
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
