>
> I tried to put a match as being united states and it returned 0 entries.
> This of course includes my wife not being returned.
>
hmm, when I put mine in, I got only one match -- Michael's wife! :) Oh
well, that great catch is already taken.
hey Marc, a question on how you're doing the mileage search. Is it based on
ZIP? if so, are you doing a lookup to a ZIPs table for my ZIP within X miles
of any ZIP in that table and then using those results as a filter on the
dating search? if so, how do you stop a large number of nearest ZIP's (in
your comment you mentioned "try putting in within 8000 miles of me") from
resulting a huge-ass query like:
Select PersonID as MyMatchID From Persons where ZIP IN (10001, 10002, 10003,
.....[up to thousands of ZIP codes])
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
