Re: ASP - Stored Procedure best practice?

Hi Mike.

Do you know of a recommended method in doing this for a form with multiple
fields which allows a user to specify more criteria on multiple fields?
Seems like building the dynamic sql statement in the stored procedure with
the specified field parameters is the only method I can think of to do
multiple criteria searching but I guess I still would like to avoid.

Thanks for your info and reply. Much appreciated.

J


"Mike C#" <xyz@xxxxxxx> wrote in message
news:ee266d$OHHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
You can pass the comparison string in as a parameter in a parameterized
query. If you want a "wild-card search", just append '%' to the end of
the string before you pass it in. Also it's a good idea to *not* pre-pend
'%' to the front of the search string.

"J" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:%23otfgI$OHHA.4484@xxxxxxxxxxxxxxxxxxxxxxx
Hello. I was wondering if anyone would recommend or point me to a best
practice method in programming a search field on an .asp page that calls
a SQL Server stored procedure to do 'LIKE' searches? The only method
that seems to accommodate this that comes to my mind as of now is using
dynamic sql in the stored procedure but hear that it's not good practice
using dynamic sql.

Thanks in advance.

J





.

Relevant Pages

  • Re: ASP - Stored Procedure best practice?
    ... fields which allows a user to specify more criteria on multiple fields? ... multiple criteria searching but I guess I still would like to avoid. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: ASP - Stored Procedure best practice?
    ... fields which allows a user to specify more criteria on multiple fields? ... multiple criteria searching but I guess I still would like to avoid. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: ASP - Stored Procedure best practice?
    ... fields which allows a user to specify more criteria on multiple fields? ... multiple criteria searching but I guess I still would like to avoid. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Word field Skip IF problem
    ... You can certainly make a field that SKIPs with multiple criteria, ... These are also the mergefields in my word docs. ... It basically says Skip record if "mergefield to" does not equal that ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Can Excel return multiple correct answers?
    ... If I'm reading the 2000 manual correct, it looks like I can have multiple ... And that's by putting the criteria on the SAME row? ... bunch in one column, and then do a V-Lookup, because there are multiple ...
    (microsoft.public.excel.worksheet.functions)