Announcement

Collapse
No announcement yet.

[SOLVED] what's wrong with my filter

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] what's wrong with my filter

    I'm confused what is wrong with my WHERE clause
    any ideas ?

    SC6_formSQL_errors.jpg



    here is the Error I get:

    Error while accessing the database:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and DiseaseID = 1' at line 1



    Arthur
    Last edited by aka; 10-22-2013, 01:34 AM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    Quotes around [field] ?? To be sure what's wrong set the sql debug on and it will show you the generated sql statement before executing. You can cut/past this in the sql builder to check it out. (application -> debug)
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Solved

      Yes, thank you for reminding me about the DEBUG mode - it hewlped to fix it easily.
      Arthur
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment

      Working...
      X