In-Reply-To: <009c01bfb11f$e7da2900$6701a8c0@CINEHUB>
Provided there are no more than 24 numbers in each 'or
delid in (....)', irrespective of their individual sizes ( ie
single, double or triple integer), I get the data returned. As
said earlier, stick in a 25th number and it falls over even
in the 'OR', or any other 'OR' I care to tag onto it!
Problem is that the 'IN (...)' is a ValueList from a previous
Verity search, and putting <cfif></cif> statements (plus the
calculations of how many you've included/left, is gonna be a
nightmare. This doesn't happen in Access <g>!
=== original message ===
Hi what happens with
SELECT * from delegate
where delid in
(101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,1
16,117,118,119,120,121,122,123,124)
or delid in
(xxx,xxx,xxx....)
etc....
=======
Cheers
Terry Riley
Riley Varea Associates, London, UK
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.