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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2906 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
