DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Hybrid View

  1. #1
    Join Date
    Aug 2006

    Incorrect Syntax near '='

    Select Distinct Civilpartynames3.casenumber,civilpartynames3.partynamefull,civilpartynames3.ty,civilpartyn ames3.filing,civilpartynames3.cat,civilpartynames3.csid,civilattynames.attynm from civilpartynames3,civilattynames where civilpartynames3.casenumber = civilattynames.casenumber and civilattynames.attynm = 'FARLEY G HOLT,ESQ' AND Civilpartynames3.Filing = year(civilpartynames3.filing)= 2000 and month(civilpartynames3.filing)= 5

    I know it has to do with the part with the first equal sign where it checks that the year equals 2000 but I dont know why .

    I resolved the problem, thanks anyways . , I just had to remove the part that said "Civilpartynames3.filing = "
    Last edited by Matrix.net; 03-28-2007 at 12:09 PM.

Similar Threads

  1. SQL Statement
    By shers in forum Database
    Replies: 4
    Last Post: 06-17-2006, 04:01 AM
  2. Replies: 5
    Last Post: 04-09-2006, 08:28 PM
  3. Replies: 16
    Last Post: 08-12-2002, 10:06 PM
  4. Incorrect syntax near 'collate'
    By Daryl in forum Database
    Replies: 0
    Last Post: 03-01-2002, 01:08 PM
  5. Incorrect syntax near '#IND'
    By Mario in forum Database
    Replies: 2
    Last Post: 07-29-2000, 07:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.