Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26

Thread: Incorrect syntax error

  1. #21
    Join Date
    Apr 2003
    Posts
    13,269
    Rep Power
    34

    Default Re: Incorrect syntax error

    Quote Originally Posted by editor
    where is the "insert" or "update" sql statement?
    omansur didn't post the update or insert query because he didn't know where to look for it. All he knew was that after the user buy something from his online shop and submits thier credit card info, the order info is not being inserted into the database when he checks it. He is using a shopping cart script.
    "The best software is the one that fits your needs." - A_A

    Virus free since: date unknown
    Anti-virus free since: August 2008

  2. #22
    Join Date
    Jun 2003
    Posts
    159
    Rep Power
    0

    Default Re: Incorrect syntax error

    Sorry fellows I need more info. What else can you tell me.
    I have within me the blood of kings....take me to the leader of your world.

  3. #23
    Join Date
    Apr 2003
    Posts
    13,269
    Rep Power
    34

    Default Re: Incorrect syntax error

    Editor, the problem is fixed. When we took the discussion to email, I fixed the problem for him. I'm just trying to tell you what the problem was.
    "The best software is the one that fits your needs." - A_A

    Virus free since: date unknown
    Anti-virus free since: August 2008

  4. #24
    Join Date
    Jun 2003
    Posts
    159
    Rep Power
    0

    Default Re: Incorrect syntax error

    Oh, wonderful! what was the problem?
    I have within me the blood of kings....take me to the leader of your world.

  5. #25
    Join Date
    Apr 2003
    Posts
    13,269
    Rep Power
    34

    Default Re: Incorrect syntax error

    In a function in an include file, the script was trying to create an object to a component which was used to encrypt the credit card number before being stored in the database. The whole shopping script suppressed the error, with using on error resume next and on error goto 0 from the global.asa level. So no error was generated when the object to the component couldn't be created.

    The function exited at the error, returning an empty value, which then led to a cascade of other problems later down in the script.

    Since the errors were suppressed, the script continued to run. But the database queries did not execute because of the empty values that were being returned from the functions earlier in the script.

    Hope that made sense to you.
    "The best software is the one that fits your needs." - A_A

    Virus free since: date unknown
    Anti-virus free since: August 2008

  6. #26
    Join Date
    Jun 2003
    Posts
    159
    Rep Power
    0

    Default Re: Incorrect syntax error

    lol...it did...what a pity.
    I have within me the blood of kings....take me to the leader of your world.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •