Right said Adrian.
Also for #2 a quick code would be something like check fro beginning of each
month and pull data from database.
Something like below but you have to check the syntax-
Say variable yourDate contains your date so check if the day is 1 then pull
data from db.
<CFIF #Day(yourDate)# EQ 1>
<CFQUERY ....>
<CFELSE>
....
...
</CFIF>
Thanks.
-Sandeep Singh Vohra
>>> "Adrian Lynch" <[EMAIL PROTECTED]> 7/13/2007 8:25 AM >>>
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:2900
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
