[cfaussie] RE: New look up date by years old with a 2 year spread < 2 > 2

[Mark Stanton]

Sorry Greg

I meant putting the cfoutput & pre in a seperate block rather than inside
the cfquery. See below:


 <cfoutput><pre>
 SELECT  Talent.talentID ,
  Talent.Name ,
  Talent.Gender ,
  Talent.DOB ,
  Talent.Hair ,
  Talent.Eye ,
  Talent.Height ,
  Talent.Clothessize ,
  Talent.shoesize ,
  Talent.hobbies ,
  Talent.BIO ,
  Talent.Compcard ,
  Talent.ID
 FROM   Talent
 where Talent.DOB between ('#Olderthan#') and ('#Youngerthan#')
</pre></cfoutput>

<cfquery name="getRecord" datasource="interact">
 SELECT  Talent.talentID ,
  Talent.Name ,
  Talent.Gender ,
  Talent.DOB ,
  Talent.Hair ,
  Talent.Eye ,
  Talent.Height ,
  Talent.Clothessize ,
  Talent.shoesize ,
  Talent.hobbies ,
  Talent.BIO ,
  Talent.Compcard ,
  Talent.ID
 FROM   Talent
 where Talent.DOB between ('#Olderthan#') and ('#Youngerthan#')
</cfquery>
Cheers

Mark


______________
Mark Stanton
Web Production
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
www.gruden.com


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/