| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> I figured out that the easiest way to deal with jet database is to connect to them usin access, creating the request, and the copy/pasting it where needed
<1> i get betweem operator without end in query expression
<1> error message
<2> take out the ( )
<0> select * from mydatafield between #2/9/2006 00:00:00# and #2/10/2006 23:59:59#;
<0> select * from table where field between #2/9/2006 00:00:00# and #2/10/2006 23:59:59#;
<1> ok now it works
<1> thanks
<1> but i dont understand why sql has date in format mm/dd/yyyy
<1> instead of dd/mm/yyyy
<0> because it was created by english-centered people maybe
<0> i, for one, would prefer yyyy/mm/dd
<3> me too
<3> same format time is in
<3> yyyy/mm/dd hh:mi:ss is the most logical format
<0> most significant data first is just more logical
<0> yup
<4> it's all a pack of lies
<3> what is?
<5> hah. took me a while.
<3> i think sql uses whatever format that the current system uses
<5> access doesn't use quotes for date strings.
<4> mistell :)
<3> and dayna should know
<3> shes used access longer than people have used windows :-D
<5> select * from tbl where datefield between 02/06/2005 and 02/07/2005
<6> anyone familiar with directshow?
<5> pfff. i wouldn't piss on access unless someone was paying me.
<3> i am a little
<5> PARADOX was my hell on earth for 7 years.
<3> oh yeah, paradox, that was it, sorry, my bad
<5> nomel_: the word is not unfamiliar to me.
<7> paradox is god awful
<7> luckily i changed jobs and went from paradox -> mssql
<5> access isn't any better.
<7> never looked back
<7> no it isn't
<1> in access works fine but in adoquery1.sql i get parameter object is improperly defined. incosistent or incomplete information was provided
<5> and non-standard and barely documented sql leaves MUCH to be desired.
<0> http://img374.imageshack.us/my.php?image=outuo4.jpg
<5> impossib: are you using parameters?
<1> no
<1> parameter list is blank
<1> is it a bug or something
<8> raid
<8> kills bugs dead
<5> impossib: it is not a bug.
<5> impossib: paste your query here please.
<1> WHERE History.datetim between #8/24/2006 00:00:00# and #8/2/2006 23:59:59#;
<4> : indicates parameter
<5> thanks. saved me some typing.
<4> :)
<5> lose the time part anyway...
<5> and you can't use # with between.
<5> only with like
<4> and i find it easier to use parameters with time/date queries
<5> select * from tbl where datefield between 02/06/2005 and 02/07/2005
<4> select * from tbl where datefield between :startdate and :enddate
<9> arent dates supposed to be iso-whatnot format yyyy-mm-dd ?
<5> ootje: this is access... not a real db.
<9> right.
<9> might as well add to the mess then
<5> access uses shortdateformat
<5> the locale setting.
<1> DaynaGirl the last example you gave me doesnt work
<5> impossib: it did for me.
<5> what error are you getting?
<5> did you copy/paste it... or did you modify it to fit your db design?
<7> jesus my daughter is weird
<7> baby's are just odd
<7> kinda dorky
<7> very entertaining
<6> wow...directshow is pretty kick ***!
<1> WHERE History.datetim between 24/8/2006 and 2/9/2006; no error no results
<5> k. first of all... is your computer set up for d/m/yyyy ?
<5> that's the commonwealth date format.
<1> what **** is that
<5> 24 is not a valid month.
<5> and for a history table.. those dates are in the future.
<5> so there likely aren't any data for that range.
<1> so you say that it should be WHERE History.datetim between 8/24/2006 and 9/2/2006;
<1> im gettin' crazy i cant make a select call in my db!!!!!!!
<1> neither 8/24 or 24/8 works
<1> i tried all possible formats and all possible quotes only #mm/dd/yyyy time# worked but not in delphi
<6> why does msdn have to **** so bad? anyone?
<10> someone know a good source for crc16/crc16ccitt
<10> i got the crc16 ccitt variant already..
<10> just dont know howto produce the crc16 (normal)
<5> impossib: yes
<5> impossib: try this. select * from history where history.datetim >= 08/24/2006
<5> then check if there are any entries in the date range you specified.
<5> hmmm taking a long time to answer there impossib
<8> hes thinking?
<8> and i bought 2 packs of guitar strings today
<5> good girl :-)
<5> *pat pat*
<5> *grin*
<1> DaynaGirl sorry but >= date is the first string i used
<1> nothing does
<5> then there are no records.
<8> girl?
<5> I was kidding.
<5> just laugh and move on.
<8> my man boobs aren't that big
<5> I'd like to try to learn guitar... but I don't like calluses
<8> its fun
<8> i enjoy it...can be relaxing or a way to get some frustration out
<1> ok fixed it using parameters
<6> i want to learn the violin.
<6> supposedly i'm getting too old though.
<6> DaynaGirl: have you messed with graphedit much?
<6> DaynaGirl: for directshow.
<5> no.
<5> I have never used direct show.
<5> although I sense it is in my future.
<3> how so?
<5> there are some instruments you have to learn while young to be considered any good.
<5> I don't know why... its just what they say...
<5> like in ballet... if you didn't start when you were 4 or 5 you are soooo over the hill.
<6> damn...that was next on my list if the violin didn't work :(
<5> me too.
<5> I've often thought of taking a dance cl***..
<5> my mom says I clomp around like a guy...
<6> i would seriously like to take gymnastics...but...i'd feel so damn dumb walking into a cl*** with a bunch of little kids.
<9> go for line dance :P
<6> hahah...boo.
<6> slow dancing is the only kind i like :P
<1> i play violin since 8 and piano since 5
<2> i've just played the fool since i was 5
<5> la.
<1> i mastrubate since 9
<5> man... you sit here sweating wondering why the air conditioning isn't working that well...
<1> i swear
<5> then you go outisde where its 30 something...
<5> and come back inside... and whoa... its soooo nice.
<2> so you've been a wanker since 9 impossib ;P
<2> heh
<5> he's a born wanker
<2> :)
<5> a wanker through and through.
<1> come on dont tell me you dont do it
<1> i was just more hot than you in my age
<5> man I do it so much.... its a wonder I don't get a RSI
<2> i get my missus to do it for me .. i'm just lazy ;)
<5> if I didn't... it would dry up and blow away in the wind.
<3> http://www.boston.com/news/local/articles/2006/08/30/guard_families_cope_in_two_dimensions/
<3> this is an interesting compile
<3> first it checks if a file is.. usable, THEN it checks for its presence
<11> Goodnight!
Return to
#delphi
or
Go to some related
logs:
A-10C Thunderbolt III
#bsd
#delphi
vista no start menu found
#windows
#flash
#narcotics
#qmail
#politics
#flash
|
|
