Hi all,
I know this is really simple and I am just missing something
obvious..but what's the syntax for subtracting two dates in SQL? I tried
creating the Query in MS Access and just copying and pasting the code
into CF...but the code that works in Access throws an error in CF.
Here it is:
--------------------------
<CFQUERY name="results" datasource="modelagency" dbtype="ODBC">
Select minfo.appdate, minfo.fname, minfo.lname, minfo.mname,
minfo.gender, minfo.dob, minfo.telhome, minfo.telwork, minfo.telcell,
minfo.pager, minfo.address1, minfo.address2, minfo.occupation,
minfo.agent, minfo.height, minfo.weight, minfo.ethnicity,
minfo.skincolor, minfo.talent, minfo.mexp, minfo.comments,
minfo.modelpic,DateDiff("yyyy",minfo.DOB,NOW()) AS AGE FROM minfo
WHERE 0 = 0
<CFIF IsDefined("form.fname") AND #form.fname# NEQ "">
AND fname LIKE '%#form.fname#%'
</CFIF>
<CFIF IsDefined("form.lname") AND #form.lname# NEQ "">
AND lname LIKE '%#form.lname#%'
</CFIF>
</CFQUERY>
---------------------------
See the date diff thingy at the end there?
-Gel
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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
