Well, it's not the elegant way - but i'll give it a try. I hope it works.
Thanks Aaron.
Patric
----- Original Message -----
From: "Aaron Johnson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 14, 2001 6:42 AM
Subject: RE: Comparing 2 Lists in a query
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Patric,
>
> I don't think there is anyway to do it SQL (you can do a "select *
> from hotels WHERE merkale IN ('var1,var2'), but this means your the
> form variable merkale would have to be ordered exactly the same as
> the vars in the db)...
>
> However, you could get all the hotels from your DB that match the
> other criteria (zipcode, city..) and then loop over the results of
> the query and compare the two lists you have to see if they are equal
> using a custom tag from the Gallery called <cf_listcompare> available
> here
> (http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347369-2830-
> 11D4-AA9700508B94F380&method=Full).
>
> HTH.
>
> Aaron Johnson, MCSE, MCP+I
> Allaire Certified ColdFusion Developer
> MINDSEYE, Inc.
> <phn>617.350.0339
> <fax>617.350.8884
> <icq>66172567
> [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
