Re: Search based where claused and stored proc

2009-03-29 Thread Arthur Fuller
An approach that has worked for me in the past and may work for you. Declare as many parms as you can possibly need and then code the statement like this: SELECT * FROM someWhere WHERE @parm1 = 123 OR @parm1 IS NULL AND @parm2 = 345 OR @parm2 IS NULL -- etc. This has the desired effect and elimi

RE: Search based where claused and stored proc

2009-03-27 Thread Gary Smith
f equality. This gets me closer, but not exactly there yet. From: Martin Gainty [mgai...@hotmail.com] Sent: Friday, March 27, 2009 1:58 PM To: b...@wisper-wireless.com; mysql@lists.mysql.com Subject: RE: Search based where claused and stored proc Ben-

RE: Search based where claused and stored proc

2009-03-27 Thread Martin Gainty
; To: mysql@lists.mysql.com > Subject: RE: Search based where claused and stored proc > Date: Fri, 27 Mar 2009 13:43:51 -0500 > > > > Ben Wiechman > Network Administrator > Wisper High Speed Internet > Office: 866.394.7737 > Direct: 320.256.0184 > C

RE: Search based where claused and stored proc

2009-03-27 Thread Ben Wiechman
Ben Wiechman Network Administrator Wisper High Speed Internet Office: 866.394.7737 Direct: 320.256.0184 Cell: 320.247.3224 b...@wisper-wireless.com > -Original Message- > From: Gary Smith [mailto:g...@primeexalia.com] > Sent: Friday, March 27, 2009 12:59 PM > To: mysql@lists.mysql.com