What DB are you using? If it's something you can create a stored proceedure in and pass in a bunch of variables rather than do the entire complex SQL statement in the web page code I'd go down that path. SPs are much more efficient in that respect.
Cheers Anna > -----Original Message----- > From: Dian Chapman [mailto:[EMAIL PROTECTED] > Sent: Thursday, 26 August 2004 02:22 > To: Group - ASP > Subject: [ASP] Multi Criteria Searches > > Hi folks... > > I've volunteered to help a Missing Persons site get their > stuff back online (after their previous dev demanded money > and then bailed<sigh>). > > Most shouldn't be too difficult...just a lot of grunt work. > However, there will be one complex search pages for which > I'm not quite sure how to handle. This being for an actual > missing or found person match...for which there can be a pile > of items that folks will attempt to match to narrow their search. > > Say someone tries searching the "Doe" DB to see if their > missing person matches someone who was found, yet > unidentified. They might attempt to match several criteria such as: > > * male > * 45 yrs > * missing city > * with various traits > > Possibly several other specific details. Most all the fields > are individual ones, although the distinguishing marks fields > is a memo field! > > Anyone have a clue on how this should be handled, outside of > a huge ...OR...statement??? > > TIA for any info... > > Dian ~ > > > > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.742 / Virus Database: 495 - Release Date: 8/19/2004 > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> Make a clean sweep of pop-up ads. > Yahoo! Companion Toolbar. > Now with Pop-Up Blocker. Get it for free! > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM > -------------------------------------------------------------- > ------~-> > > -------------------------------------------------------------- > ------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
