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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2905
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
