No..nothing that simple. The statement still does not work.. I hate errors like these.
Without the AS AGE thing, the statement works fine, so I know the error lies with that bit of code. Any other ideas anyone? -Gel -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] 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
