Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    83

    Unanswered: Is there a limit to the number of 'AND' conditions I can use?

    I know there is a limit to the number of values I can put into a IN condition, but is there a limit to the number of ANDs I can have in one query? I'm running into a strange problem that makes me think that is the cause.

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Not as far as I know. How many AND's?

  3. #3
    Join Date
    Jan 2004
    Posts
    83
    well, i'm embarassed to say about 1200. because of some bad architecture and two databases living in two different environments, i have to use coldfusion to build a dynamic query.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Desparate times call for desparate measures.
    Since details about your exact situation are scant, the following may or may not be viable for you.
    INSERT appropriate desired data into GTT & do the final SELECT from it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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