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 7
Example 6 Main Menu Example 8
<CFQUERY DATASOURCE="#Request.DSN#" NAME="GetPeople">
SELECT FName, LName, BirthDate
FROM People
WHERE BirthDate <= #CreateODBCDate('01/01/1901')#
OR FName = 'Jack'
</CFQUERY>
<CFOUTPUT QUERY="GetPeople">
#FName#, #LName#, #BirthDate#<BR>
</CFOUTPUT>
Santa Rockin, Clause, 31-Dec-1848
Jack, Frost, 24-Nov-1863
Jack, Skeleton, 31-Oct-1964
Copyright 2008 KomputerMan.com, Inc. All Rights Reserved.