Professional Web Applications Themes

Help with search results in asp vbs - Dreamweaver AppDev

I have this query: SELECT * FROM dbo.subwatch WHERE subname like 'varsubname%' AND vendornum like 'varvendornum%' AND city like 'varcity%' AND State like 'varstate%' AND reasonadded like 'varreason%' ORDER BY subname the problem is I need the vendornum to be = and not like... so if I search for vendor# 123 id does not return results on vendor# 1234 and so on... if I use = instead of like it does not return results if left empty... What am I missing?...

  1. #1

    Default Help with search results in asp vbs

    I have this query:

    SELECT *
    FROM dbo.subwatch
    WHERE subname like 'varsubname%' AND vendornum like 'varvendornum%' AND city
    like 'varcity%' AND State like 'varstate%' AND reasonadded like 'varreason%'
    ORDER BY subname

    the problem is I need the vendornum to be = and not like... so if I search
    for vendor# 123 id does not return results on vendor# 1234 and so on... if I
    use = instead of like it does not return results if left empty... What am I
    missing?


    Chris Guest

  2. #2

    Default Re: Help with search results in asp vbs

    Try

    vendornum like 'varvendornum'

    --
    Jules
    [url]http://www.charon.co.uk/charoncart[/url]
    Charon Cart 3
    Shopping Cart Extension for Dreamweaver MX/MX 2004


    Julian Roberts Guest

  3. #3

    Default Re: Help with search results in asp vbs

    Thanks Julian...

    I thought I had tried that already... but it worked like a charm...

    Thanks again!

    Chris

    "Julian Roberts" <newsgcharon.co.uk> wrote in message
    news:cv30r3$ag2$1forums.macromedia.com...
    > Try
    >
    > vendornum like 'varvendornum'
    >
    > --
    > Jules
    > [url]http://www.charon.co.uk/charoncart[/url]
    > Charon Cart 3
    > Shopping Cart Extension for Dreamweaver MX/MX 2004
    >
    >

    Chris Guest

Similar Threads

  1. Clikckabel Search Results
    By Bskyweb in forum Coldfusion Database Access
    Replies: 1
    Last Post: August 15th, 07:23 PM
  2. Search results
    By Bskyweb in forum Coldfusion Database Access
    Replies: 3
    Last Post: July 16th, 07:52 PM
  3. Sending search results to a results page..with asp
    By dan.how in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 26th, 04:18 PM
  4. search results pages
    By Jomo in forum Macromedia ColdFusion
    Replies: 1
    Last Post: February 19th, 12:35 AM
  5. Search within Search Results
    By Maria Kovacs in forum ASP Database
    Replies: 1
    Last Post: October 7th, 04:45 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