kewl, You may do one thing - Populate a static html or text file at the beginning of the month and include that to your main page.You can leverage CF Admin Scheduler to run this every 1st of the month and create/update a textfile for the current month from database..lets say it's called currentmonth.html.
Now in your workshops.cfm, you may include this currentmonth.html to show current month's data. I will send you a sample code sometime tonight and you may model the same for your requirement.don't worry.. keep working hard.. -Sandy Vohra >>> "Connie Works" <[EMAIL PROTECTED]> 7/13/2007 5:09 PM >>> Sandeep, It is all static Connie Works Business Systems Specialist Center for University Teaching, Learning, and Assessment Building 41/215 University of West Florida Pensacola, Florida 32514 Telephone: 1-850-474-3080; FAX: 1-850-857-6331 http://uwf.edu/cutla -----Original Message----- From: Sandeep Vohra [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 4:04 PM To: CF-Newbie Subject: RE: Empty lines Connie - Please go through this link and see if you can get help from last comment.. http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt183.htm I will write a code and test it on CF Server once I get back home, I do not have access to it right now. Also just curious - How do you populate you content on home page right now? Is it all static? Thanks. -Sandy Vohra >>> "Connie Works" <[EMAIL PROTECTED]> 7/13/2007 3:58 PM >>> Adrian, I appreciate your help, but when I added the cfif code I get an error stating that it isn't support in CFMX7. This is the code I have written and the URL to show you what it looks like -- http://uwf.edu/cutla/dev/calendar-workshops.cfm <CFQUERY NAME = "August2007" DATASOURCE = "cutla_calendar"> SELECT * FROM calendar WHERE Month = 'August 2007' ORDER BY Date2 </CFQUERY> <CFOUTPUT QUERY = "August2007"> <strong>#Title#</strong><br /> #Topic#<br /> #Comment1# #Comment2# #Comment3# #Comment4#<br /> #Date#<br/> #Time#<br/> #Place#<br/> <br /> </CFOUTPUT> I've gone through every resource book I have and still can't find what I'm looking for. Again, I appreciate any help you can give me. Connie Works Business Systems Specialist Center for University Teaching, Learning, and Assessment Building 41/215 University of West Florida Pensacola, Florida 32514 Telephone: 1-850-474-3080; FAX: 1-850-857-6331 http://uwf.edu/cutla -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 7:26 AM To: CF-Newbie Subject: RE: Empty lines 1. Check if there is data present before outputting. <cfoutput query="myLovelyQuery"> <cfif Trim(myLovelyQuery.myNotSoNiceColumn) NEQ ""> #myLovelyQuery.myNotSoNiceColumn# </cfif> </cfoutput> 2. Look at the scheduler in the CF Administrator and/or cf schedule. Adrian -----Original Message----- From: Connie Works Sent: 11 July 2007 22:49 To: CF-Newbie Subject: Empty lines This is my first ColdFusion project and I'm suffering from an acute case of newbietis and have gone totally brain dead. I've created a simple query/output program in order to keep our center's online calendar up-to-date. But, I'm having two problems that I am hoping someone can help me with. 1. If no data has been entered into the field of a record in my database, I am getting a blank line on my webpage. How do I set my defaults either in Access or in my CF program so that if there is no data, it will not create a blank line. 2. Also, I need to create a program where at the beginning of each month, our homepage and calendar will automatically update itself from the database. I have no idea where to begin. Connie Works ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2908 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
