Syntax error in Query Expression,

Ask a Question related to ASP, Design and Development.

  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. Similar Questions and Discussions

    1. Syntax error (missing operator) in query expression
      Hi, I have received the following error: ODBC Error Code = 37000 (Syntax error or access violation) Syntax error (missing operator) in query...
    2. [microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
      I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when...
    3. Query Of Queries syntax error
      Hello I am running a Query of Queries and I'm getting the following error: Query Of Queries syntax error. Encountered "Section" at line 0, column...
    4. Syntax error in UPDATE query
      Thanks in advance for any help... I am trying to update form data to a database from code in the action page code below.. the form is a dual purpose...
    5. syntax error (missing operator) query expression
      valuA = (request.form("toadd")) If valuA = "" then SQL = "UPDATE CourseReg SET attended='Active' WHERE ID IN("&request.form("toadd")&")" Set RS =...
  3. #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

Posting Permissions

  • You may not post new threads
  • You may 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