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 robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2899
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
