Using getRows in a search

Results 1 to 2 of 2

Thread: Using getRows in a search

  1. #1
    Join Date
    Dec 1969

    Default Using getRows in a search

    We&#039re trying to use getRows in a search engine, but are having problems passing a variable in a stored procedure. Here&#039s some code:<BR><BR>ListName = Request("ListName")<BR>objRS.Open "EXEC getList &#039" & ListName & "&#039" ,objConn<BR><BR>No problem when executing only the stored procedure without requesting ListName (the parameter).<BR><BR>Is this possible? Or is it that getRows dumps the entire recordset then disconnnects, so that it is not possible to use a variable as a "filter" with getRows/getTables?

  2. #2
    DontWorry Guest

    Default RE: Using getRows in a search

    GetRows and stored procs are different chocolate bars, still bars and taste the same.<BR>Something wrong with your stored proc, or something else. These two things are separated. can&#039t answer you , NOTENOUGHINFO.<BR>had some extra time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts