For now it's just Access. We're hoping to move to SQL later...but for now we just want to get their site up and rolling again.
Dian D. Chapman, Technical Consultant Microsoft MVP, Certified MOS Expert Editor/TechTrax Ezine Free Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: www.mousetrax.com/books.html Optimize your business docs: www.mousetrax.com/consulting Learn VBA the easy way: www.mousetrax.com/techcourses.html -----Original Message----- From: Anna Crooks [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 9:29 PM To: [EMAIL PROTECTED] Subject: RE: [ASP] Multi Criteria Searches 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 --- Incoming 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 --- 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 <*> 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/
