1) CF-Talk removes attachments. We cannot see your graphic example. 2) This may not be an option anymore, but perhaps storing dates as day, month, year might have been useful for this particular application. If this is not an option, look at the datePart() function.
3) Here is a code snipet to alternate rowcolors. Somepeople like to use the IIF. I haven't done any testing, so I don't know if one is better than the other. <tr <cfif getQuery.currentRow MOD 2 EQ 1>bgcolor="##ABBBD9"</cfif>> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 1:56 PM To: CF-Talk Subject: How can this be implemented in CF ? Hi I currently have a What's On Guide that is currently static html pages, but I intend to make this database driven using Coldfusion. I want to display the following fields from my db table, Eventtitle, eventdate, and location which has already been set up and polulated with some sample data. These display event information for the forthcoming months, Looking at the graphic example attached which shows a design mock up of how it should look when fully working with Coldfusion, How would you break the events (fields from the database) sorted by month so you display November and all of novembers months are displayed, then if there are entries for December , the December title is displayed and decembers events etc. Finally how would you be able to make the table cell rows alternate colors such as in the example attached for each record? Any ideas on the best possible solution/ implementation with CF would be appreciated. Ian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
