Professional Web Applications Themes

Multiple Category Search Page - Dreamweaver AppDev

I'm trying to create a search page, with the option of selecting one of more categories. I understand how to code it, so the Click event runs through which are checked and which aren't.. etc... but wanted to use a SPROC rather than create a SQL Statement (the latter would be easier I know) I'm wondering how I can construct the SPROC, on the Database?? I suppose, the one way would create a string to pass as the parameter to end up something like WHERE CategoryID = '1' OR '2' OR '3' etc... if my SPROC is along lines.. SELECT ...

  1. #1

    Default Multiple Category Search Page

    I'm trying to create a search page, with the option of selecting one of more
    categories.

    I understand how to code it, so the Click event runs through which are
    checked and which aren't.. etc... but wanted to use a SPROC rather than
    create a SQL Statement (the latter would be easier I know)

    I'm wondering how I can construct the SPROC, on the Database??

    I suppose, the one way would create a string to pass as the parameter to end
    up something like

    WHERE CategoryID = '1' OR '2' OR '3' etc...

    if my SPROC is along lines.. SELECT * FROM dbo.Table WHERE CategoryID =
    CategoryID

    Anyone have any ideas??

    Calvin Willman Guest

  2. #2

    Default Re: Multiple Category Search Page

    Parp...

    i use the in keyword.

    so select * from products where categoryid in categoryid and pass (1,2)


    On 20/4/05 5:40 pm, in article BE8C4493.B22%calvinwillmanorange.net,
    "Calvin Willman" <calvinwillmanorange.net> wrote:
    > I'm trying to create a search page, with the option of selecting one of more
    > categories.
    >
    > I understand how to code it, so the Click event runs through which are
    > checked and which aren't.. etc... but wanted to use a SPROC rather than
    > create a SQL Statement (the latter would be easier I know)
    >
    > I'm wondering how I can construct the SPROC, on the Database??
    >
    > I suppose, the one way would create a string to pass as the parameter to end
    > up something like
    >
    > WHERE CategoryID = '1' OR '2' OR '3' etc...
    >
    > if my SPROC is along lines.. SELECT * FROM dbo.Table WHERE CategoryID =
    > CategoryID
    >
    > Anyone have any ideas??
    >
    Calvin Willman Guest

Similar Threads

  1. Datagrid with multiple *header/category* rows
    By ivan.svaljek@gmail.com in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: September 12th, 05:00 PM
  2. ANN: InterAKT Site Search - search in multiple tables
    By Alexandro Colorado in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: November 29th, 04:23 PM
  3. Search multiple keywords across multiple fields
    By Darren Heinrich in forum ASP Database
    Replies: 3
    Last Post: February 6th, 05:29 AM
  4. Page that displays SQL results by category?
    By Lurk Master Flex in forum PHP Development
    Replies: 1
    Last Post: December 1st, 06:56 PM
  5. [PHP] Category and sub-category logic
    By Chris W. Parker in forum PHP Development
    Replies: 6
    Last Post: August 17th, 05:44 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139