Recent content by JOBARAM

Hi Tony, I have done some thing similar and it works: SELECT * FROM table_name ORDER BY datetime_field ASC LIMIT 0, 2 Thanks mate Jo

hi, I have the following table: ID |Type |TimeStampe 10 |1 |2005-04-25 16:37:58 10 |2 |2005-04-25 16:39:58 10 |3 |2005-04-25 16:38:58 10 |4 |2005-04-25 16:38:58 I need to create a query that will get me 2 types (limit 2) that have the oldest timestamp (1 and 3). How do I do that? Thanks Jo

Thanks Paul for the help. I will do as you advised. Would you have any idea how to access registry keys from a a dos script? Thanks again Jo

My os is Windows

Hi Paul, Thanks for your reply. Is there any tool or command that can do the uninstallation for me? I am trying to avoid direct access to the registry. I have come across a few solution that doesn't work for me: % sudo port -v -d uninstall perl5.8 or % vrmperl Do you have any sugestions? Thanks Jo

Hi, I am building an installer that installs perl 5.8.2 and I really would like to know how to silent uninstall it. I would like to use a batch file for that. Please advise. Thanks Jo

hi, My application uses Log4j as its logger. Log detailes is written to logger name - xxxx.log. This log file is saved for one day more only. its name is changed to xxxx.log.19-09-2000(the day it was created). I need to save the logs for a period of more the 2 days. Should I use log4j.properties...

Hi, I need to retrieve the PC's Printers shared names, not the name of printers the PC uses. I am using: PrintService[] services = PrintServiceLookup.lookupPrintServices(DocFlavor.SERVICE_FORMATTED.PRINTABLE,null); but the services retrieves the name of printers the PC uses and not the shared...

Hi, I have few radio button and I need each one that is marked to open a different screen/table on top of the one that was opened previously. Please advise Thanks Jo

Hi helper, I have Start and End columns, type Time. I need to do something when the current time is in between Start and End. I use the following: DATE_FORMAT(now(),'%H:%i:%s') Between Start AND End It works great if the time in the same day, it does'nt work if Start is 23:00:00 and End...

hi, I have a datetime field 'LastActivationTime' and I want to create a query that add 1 to different field every half an hour from current time. I tried the following: DATE_FORMAT(LastActivationTime,'%H:%i:%s') + 0.5 < DATE_FORMAT(now(),'%H:%i:%s'). Can I do that? Can I put LastActivationTime...

Thanks mate, I'll do that. Yossi

Jo, Thanks for your reply. I use a simple drop table. many of the times it works but one time unexpectedly it faild and from that point I couldn't create\drop the table again. Maybe its related to configuration of the db via My.ini file? or some thing else??? Thanks again Yossi

Hi, I'm using Innodb type tables in my db. I'm running a routine that should drop a table and create it again. running this routine several times caused the table not to be created again, so if you type ' Show tables' you don't see it, but after creating it again despite the fact that you see an...

Yes I have noticed Mysql has only one format to enter Dates. Tanks for the tip.