Professional Web Applications Themes

Syntax error in Query Expression, - ASP

Hi everyone I have a page on my site in which i wish to display links to brochures, and i have stored an index of these links in my database. however when i pass from the master page, [url]http://www.tripakltd.com/brochures.asp[/url] to the detail page, by selecting a item from the list/menu and submitting, i cannot seem to be able to carry a variable as a value, i.e i am submitting CategoryID as a variable so i want it to equal % but i only seem to be able to get it to work if a specify a figure, such as number ...

  1. #1

    Default Syntax error in Query Expression,

    Hi everyone

    I have a page on my site in which i wish to display links to brochures, and
    i have stored an index of these links in my database.

    however when i pass from the master page,
    [url]http://www.tripakltd.com/brochures.asp[/url] to the detail page, by selecting a
    item from the list/menu and submitting, i cannot seem to be able to carry a
    variable as a value, i.e i am submitting CategoryID as a variable so i want
    it to equal % but i only seem to be able to get it to work if a specify a
    figure, such as number 1, and then that isnt very useful because for every
    product i select on the drop down list/menu i'll only receive the brochures
    associated with number 1.

    Please could someone assist me with fixing this?

    Many thanks

    Raphael


    Raphael Gluck Guest

  2. #2

    Default Re: Syntax error in Query Expression,

    Raphael Gluck wrote:
    > Hi everyone
    >
    > I have a page on my site in which i wish to display links to
    > brochures, and i have stored an index of these links in my database.
    >
    It's pretty tough to troubleshoot something without seeing any code. For
    some general help, take a look at these:

    [url]http://tinyurl.com/qg4o[/url]
    [url]http://tinyurl.com/qg3u[/url]
    [url]http://tinyurl.com/qg47[/url]
    [url]http://tinyurl.com/qg4j[/url]

    HTH,
    Bob Barrows


    Bob Barrows Guest

Similar Threads

  1. Syntax error (missing operator) in query expression
    By crystalfish0318 in forum Coldfusion Database Access
    Replies: 3
    Last Post: May 23rd, 06:00 PM
  2. Replies: 6
    Last Post: September 2nd, 01:22 PM
  3. Query Of Queries syntax error
    By Spaniard1981 in forum Coldfusion Database Access
    Replies: 2
    Last Post: August 15th, 01:54 PM
  4. Replies: 4
    Last Post: September 29th, 10:23 AM
  5. Replies: 4
    Last Post: July 11th, 07:58 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