Professional Web Applications Themes

Need Help with SQL syntax error - ASP Database

I get the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. /sds-test/manageproducts.asp, line 79 I have displayed the sqlStr with Response.Write sqlStr with the following result: INSERT INTO union ( union_merchant_id, union_store_id, union_product_id ) VALUES ( 1, 2, 68 ) I am using Windows XP with IIS. The my code is as follows: sqlString = "SELECT store_id FROM store " &_ "WHERE store_merchant_id =" & RS( "merchant_id" ) SET RSstore = Con.Execute( sqlString ) WHILE NOT RSstore.EOF sqlStr = "INSERT INTO union " &_ "( union_merchant_id, ...

  1. #1

    Default Need Help with SQL syntax error

    I get the following error:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
    [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
    statement.
    /sds-test/manageproducts.asp, line 79

    I have displayed the sqlStr with Response.Write sqlStr with the following
    result:
    INSERT INTO union ( union_merchant_id, union_store_id, union_product_id )
    VALUES ( 1, 2, 68 )

    I am using Windows XP with IIS. The my code is as follows:
    sqlString = "SELECT store_id FROM store " &_

    "WHERE store_merchant_id =" & RS( "merchant_id" )

    SET RSstore = Con.Execute( sqlString )

    WHILE NOT RSstore.EOF

    sqlStr = "INSERT INTO union " &_

    "( union_merchant_id, union_store_id, union_product_id ) VALUES ( " &_

    RS( "merchant_id" ) & ", " &_

    RSstore( "store_id" ) & ", " &_

    RSprod( "product_id" ) & " )"

    SET RSunion = Con.Execute( sqlStr )

    RSstore.MoveNext

    WEND

    Can anyone shed some light on my plight?


    Guest

  2. #2

    Default Re: Need Help with SQL syntax error

    Try doing:

    INSERT INTO [union] (...rest of sql...

    See here. http://www.aspfaq.com/show.asp?id=2080

    Ray at home

    <net> wrote in message
    news:phx.gbl... 



    Ray Guest

  3. #3

    Default Re: Need Help with SQL syntax error

    Fabulous.....Thanks Ray, you saved the day....I saved the keyword site on my
    favorites for future reference.

    "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
    message news:phx.gbl... [/ref]
    following [/ref]
    union_product_id ) 
    >
    >
    >[/ref]


    Guest

  4. #4

    Default Re: Need Help with SQL syntax error

    Stop using ODBC/DSN. Please read the following links for more info.

    http://www.aspfaq.com/show.asp?id=2126

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado_deprecated_components.asp


    net wrote: 

    Joker Guest

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Help on Syntax error please
    By Gilles in forum MySQL
    Replies: 0
    Last Post: April 28th, 01:51 PM
  3. Syntax error?
    By Joneleth in forum MySQL
    Replies: 2
    Last Post: February 15th, 04:46 PM
  4. error : syntax error at or near $1 for over select rows
    By vinita bansal in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: December 27th, 06:51 PM
  5. SQL Syntax Error
    By Frank Py in forum ASP Database
    Replies: 2
    Last Post: July 11th, 07:38 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