Closed Thread Icon

Topic awaiting preservation: SQL Problem (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=13066" title="Pages that link to Topic awaiting preservation: SQL Problem (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: SQL Problem <span class="small">(Page 1 of 1)</span>\

 
Kaniz
Bipolar (III) Inmate

From:
Insane since: Jun 2003

posted posted 02-27-2004 23:36

I'm having a bit of a hard tim with a SQL situation, and cant seem to wrap my head around a 'whats wrong with this statement?

Basicly, I have a table for room reservations, the relevant fields to this problem are arrival date and departure date.

The table looks something like

id

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 02-28-2004 00:38

yep you're backwards


arrival <= 5/3 <-- arrive before 5/3
depart >= 5/3 <-- leaves after 5/3

heh read slowly

I do know for a fact, that there are currently entires in the table that have a ( arrival ) date starting at/after 5/3/2004, and have the departure date at or before 5/3/2004



.:[ Never resist a perfect moment ]:.

[This message has been edited by bitdamaged (edited 02-28-2004).]

Kaniz
Bipolar (III) Inmate

From:
Insane since: Jun 2003

posted posted 02-28-2004 00:48

hahah yep I realized that after I had posted, and got things working now. I knew it was something silly like that.


[This message has been edited by Kaniz (edited 02-28-2004).]

« BackwardsOnwards »

Show Forum Drop Down Menu