On Mon, 18 Nov 2002 [EMAIL PROTECTED] wrote: > Theoretically your scalar method should work, but then you are > sacrificing memory over processing, so it is really more an > environmental decision than anything.
Well there was a little method to the madness. If there is more than one row returned I'll use the returned rows to build the selection list so it won't go to waste. Indications from the users are that they will be guessing at the domain name quite often. I.e., "the word 'free' is in the domain name but not sure if it is 'freestuff.com' or stuffforfree.com'" There could be a problem if they did a values like 'th' and there were hundreds of thousands of domains (not this week :-) but I have sucked up 4 MBtye files on an old 386 with 8 MByte RAM running DOS using perl to save on disk accesses. I've got a heftier system now - OS and hardware. ;-) Rod -- "Open Source Software - Sometimes you get more than you paid for..."
