#1
  1. An Ominous Coward
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jan 2002
    Posts
    4,425
    Rep Power
    0

    Access Fails to Recognize Valid SQL


    Given the following SQL statement:
    Code:
    SELECT cycle, month FROM the_table WHERE cycle <= 49999 AND cycle > 49999-10000
    and the following table record:
    Code:
    ID   CYCLE   MONTH   OTHER....STUFF
    --------------------------------------------
    41   40100   February   ....................
    --------------------------------------------
    Am I incorrect in my belief that that if I feed the SQL statement above to Access, it should return the cycle and month from record 41? The SQL statement executes without error, as does the code and other statements in the same code. However, the SQL statement above, when applied, does absolutely nothing. I cannot figure for the life of my WHY it does not return this record? I know from other statements that the 49999-10000 does indeed become 39999 like it should. What else could I possibly be missing?

    I know the code itself (perl) is not to blame for reasons that would take another 3 pages of post to explain. Needless to say, however, I have thoroughly covered that venue. Event when I change the statement to explicitly read:
    Code:
    SELECT ID FROM the_table WHERE cycle = 40100
    It returns absolutely nothing from Access. Ugh... what a headache..

    Thanks,
    Chris
  2. #2
  3. An Ominous Coward
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jan 2002
    Posts
    4,425
    Rep Power
    0
    Oh for crying out loud....

    We have two databases, one to develop with and the other for production because it's easier to just copy one mdb file over another with Access. Funny thing... haha ha... I was looking at the development database while testing my code on the production one so there IS NO record 41 and up because that information wasn't published yet... my god I can't wait until I get the new CMS system in place...
  4. #3
  5. Big Endian
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2001
    Location
    Fly-over country
    Posts
    1,172
    Rep Power
    30
    It it makes you feel any better, I spent the last two days trying to get my first Linux terminal server (www.ltsp.org) working. I did everything the instructions said but my thin client wouldn't boot and connect to the server. I checked and rechecked everything. I searched the web. I tried different NIC cards. I swore. I threatened the machine.

    Turns out the boot floppy had a cyclic redundancy error. AARGH!

    Fifteen minutes later everything worked like a charm...

IMN logo majestic logo threadwatch logo seochat tools logo