RE: output cf to html

2002-05-02 Thread Paul Ihrig
- 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

RE: output cf to html

2002-05-02 Thread Sam Roach
--#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

RE: output cf to html

2002-05-01 Thread Margaret Fisk
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

RE: output cf to html

2002-05-01 Thread BillyC
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

RE: output cf to html

2002-05-01 Thread Sam Roach
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:

RE: output cf to html

2002-05-01 Thread Bryan Love
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

RE: output cf to html

2002-05-01 Thread Paul Ihrig
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

RE: output cf to html

2002-05-01 Thread Bryan Love
]] 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

RE: output cf to html

2002-05-01 Thread Paul Ihrig
[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

RE: output cf to html

2002-05-01 Thread Bryan Love
]] 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