This Looks Like a Job for KomputerMan
HOME About Kurtis | On-Line Inventory Management Application | Da Web TimeClock
CF Kustom Tag Gallery |CF Presentations | Sample Applications
Example 6
Example 5 Main Menu Example 7
<CFQUERY DATASOURCE="#Request.DSN#" NAME="GetPeople">
SELECT FName, LName, BirthDate
FROM People
WHERE BirthDate <= #CreateODBCDate('01/01/1901')#
</CFQUERY>
<CFOUTPUT QUERY="GetPeople">
#FName#, #LName#, #BirthDate#<BR>
</CFOUTPUT>
Santa Rockin, Clause, 1848-12-31 00:00:00.0
Jack, Frost, 1863-11-24 00:00:00.0
Copyright 2008 KomputerMan.com, Inc. All Rights Reserved.