-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 8:16 PM
To: CF-Talk
Subject: RE: output cf to html
example
query...
SELECT state, city, firstName, lastName
FROM myTable
ORDER BY state, city, firstName, lastName
--
cfoutput query=myQuery group=state
#state#br
--#firstName#br
cfset firstNametemp = firstName
/cfif
-#lastName#br
/cfoutput
-- Sam
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:16 PM
To: CF-Talk
Subject: RE: output cf to html
example
Just schedule it on your CF server in Administration Tools.
Delete the original file
Create a new file
Write the report + html coding to the file.
Or am I missing the point?
Margaret
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 2:35 PM
Hehe.. wouldn't ya know that you can do this with CFSchedule - take a
look in cf admin (or can be set up programmatically) - let's you
schedule a page, and optionally, save as html - sound like what you
want? :-)
---
Billy Cravens
-Original Message-
From: Paul Ihrig [mailto:[EMAIL
As another option you could cache the queries for 24hours.
cfquery name=my_query datasource=my_datasource
CachedWithin=#CreateTimeSpan(1,0,0,0)#
-- Sam
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 2:35 PM
To: CF-Talk
Subject:
This is your most reliable option (CFschedule is flaky).
At the top of the page that displays the report (report.cfm) put this line:
cfset today = dateFormat(now(),mm_dd_yy)
cfset fileName = #expandPath(./)#/report_#today#.htm
cfif NOT
thanks guys...
i will try it a few differnt way that you suggested.
Now if i could only learn how to
loop over my quries with a group
with QaQ??
then i think i wouldnt even need to do this
right now i have like 20 incldes a hiting the same data source many, many
times
just to get the output
]]
Sent: Wednesday, May 01, 2002 3:18 PM
To: CF-Talk
Subject: RE: output cf to html
thanks guys...
i will try it a few differnt way that you suggested.
Now if i could only learn how to
loop over my quries with a group
with QaQ??
then i think i wouldnt even need to do this
right now i have like 20
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 6:40 PM
To: CF-Talk
Subject: RE: output cf to html
simple lesson in query grouping...
When you specify a group attribute like so...
cfoutput query=myQuery group=firstName
do whatever
cfoutput
do inner stuff
]]
Sent: Wednesday, May 01, 2002 4:34 PM
To: CF-Talk
Subject: RE: output cf to html
yeh...
i think i understand that Bryan
but when i am doing a count on the records
then dividing them into say 3
generating separate columns of data
say 3
that's where i get all messed up
i can easily out put
10 matches
Mail list logo