|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
January 2nd, 2003, 12:07 PM
|
||||
|
||||
|
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
January 2nd, 2003, 12:28 PM
|
||||
|
||||
|
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...
|
|
#3
January 2nd, 2003, 01:03 PM
|
||||
|
||||
|
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...
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Access Fails to Recognize Valid SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
