Error, Incorrect synthax near ..... What am I doingwrong

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Error, Incorrect synthax near ..... What am I doingwrong

    I have three pages. Page one displays an article heading. (title). When a user
    clicks this title, the article opens on page two. At the bottom of the article
    is a link the says 'add a comment' When a user clicks the link, the articleId
    is passed as a hidden link to page three. The recordset for page three is
    filtered as using the url parameter filtering for only the articleid that was
    clicked. Page three has a form that simply allows a user to add a comment so I
    have another recordset and an insert behavior. My tables are articles
    --------- articleId article articledate comment ------------- commentid
    articleid comment comentDate Users --------- userid username Problem is when
    the user clicks the 'add comment' on page two, this error is thrown Microsoft
    OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server
    Driver][SQL Server]Line 1: Incorrect syntax near ','. How do I fix it? Thanks
    assigned

    logic Guest

  2. Similar Questions and Discussions

    1. #38252 [Asn->Csd]: Incorrect PDO error message
      ID: 38252 Updated by: iliaa@php.net Reported By: stochnagara at hotmail dot com -Status: Assigned +Status: ...
    2. #39580 [NEW]: Incorrect Error in Configure PDO
      From: drh1 at cec dot wustl dot edu Operating system: Mac OS 10.4.8 PHP version: 5.2.0 PHP Bug Type: *Compile Issues Bug...
    3. error: Incorrect database or cursor name format
      Does anyone have got an idea where I can find a solution for the following problem: I am running a 4ge-application since years. The...
    4. configured Identity is incorrect error
      Hi, I have a website that uses some custom written COM+ components to handle Office documents etc. If I am logged on and have the Identity for...
    5. ftp error 530 login incorrect
      hi im trying to use dreamweaver to upload a file and i received this error notice an ftp error occured cannot make connection to host 530 login...
  3. #2

    Default Re: Error, Incorrect synthax near ..... What am I doing wrong

    Look in the address bar when you hover over the comment link on page 2,
    is the link correct, it should be something like
    [url]http://www.mysite.com/comments.asp?articleid=12345[/url]

    If so, what is the code on page 3?

    Brett


    logic wrote:
    > I have three pages. Page one displays an article heading. (title). When a user
    > clicks this title, the article opens on page two. At the bottom of the article
    > is a link the says 'add a comment' When a user clicks the link, the articleId
    > is passed as a hidden link to page three. The recordset for page three is
    > filtered as using the url parameter filtering for only the articleid that was
    > clicked. Page three has a form that simply allows a user to add a comment so I
    > have another recordset and an insert behavior. My tables are articles
    > --------- articleId article articledate comment ------------- commentid
    > articleid comment comentDate Users --------- userid username Problem is when
    > the user clicks the 'add comment' on page two, this error is thrown Microsoft
    > OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server
    > Driver][SQL Server]Line 1: Incorrect syntax near ','. How do I fix it? Thanks
    > assigned
    >
    Ba Work 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