Incorrect Syntax near '='


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Incorrect Syntax near '='

Threaded View

  1. #1
    Join Date
    Aug 2006
    Location
    PA
    Posts
    259

    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 01:09 PM.

Similar Threads

  1. SQL Statement
    By shers in forum Database
    Replies: 4
    Last Post: 06-17-2006, 05:01 AM
  2. Replies: 5
    Last Post: 04-09-2006, 09:28 PM
  3. Replies: 16
    Last Post: 08-12-2002, 11:06 PM
  4. Incorrect syntax near 'collate'
    By Daryl in forum Database
    Replies: 0
    Last Post: 03-01-2002, 02:08 PM
  5. Incorrect syntax near '#IND'
    By Mario in forum Database
    Replies: 2
    Last Post: 07-29-2000, 08: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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