Search results for query: *

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

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...

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...

Hi, I created a big Mysql database that includes dates values. I need to convert all dates to a specific format. Can I do it through Alter Table ? How can I change all Dates format if not? Thanks Yossi

hi, The names of my tables are in uppercase. When I dump the contents of the database to file, using mysqldump, and then read it back in on a linux machine, or on the windows machine which it was dumped on, the tables are created with lower case names??? (3.23.55 version of mysql and win2k)...

Hi, While debuging my code Using JDeveloper I have lots of String parameters with very long values. Trying to watch the value in Watches, Data or Smart DAta gives me part of the string. How can I retrieve the all string for debuging perposes only? Thanks Yossi

Hi, As you anderstand I'm new to mysql. I installed Mysql 3.23.55 on my Win2K OS and as default the server executable is mysqld-nt.exe I would like to replace it with mysqld-max-nt and all I tried including mysqld-max-nt --install give my a notice that the service allready exist. I even disabled...

Hi helper, I have 2 tables as follows: Product table: Product_Num LabelType 1111 12 2222 23 3333 10 4444 22 etc.... Data Type table: Id Product_Num Data_Type Data 1 1111 1 20.3 2 1111 2 33.6 3 1111 3 10 4...

Hi, I need to bind 3 prices ('Data' column values)to 3 text boxes. I have the following table: product Type Data 1111 1 22.30 1111 2 32.70 1111 3 40.00 To Add the Data_Type table I use: dataSet.Tables.Add(Obj_DataType.GetSelect(&quot;1111&quot;))...

Hi, I have created a Dataset that contais a DataTable. for retrieving a specific value I use the following: dataSet.Tables.Add(&quot;select Data from Data_Type where product='111'&quot;)); txtProductName.DataBindings.Add(&quot;Text&quot;, dataSet, &quot;Data_Type.Data&quot;) My problem is...

Hi, I am building an nTier project. my Data Access layer containes classes in few directories. I have no idea how to create the Data Access.dll in order to reference it to the rest of the layers. Using csc /target:library /out:Data Access.dll a*.cs etc... look for the clesses in the directory of...

Hi, I used to work with ADO connecting to my SQL server and to activate a stored procedure ('Temp_SP') that expect few params i have done the following: ####### ....... str= &quot;exec Temp_SP Param1_Val,Param2_val&quot; //executing the SP... oConn.Execute SQLQuery, , adExecuteNoRecords...

Hi, I am just creating my first Project in C#,be patient if you can. My objective is to create a GUI that will interact with the sql server db. I have created 'Client' project, so far so good. I added a project 'DataAccess' that includes all classes that do the connection to the db. Now, my...

Hi helper, I have installed .NET Beta 2 on my Win 2K OS. When I try and create a project(Windows application), I receive an error which reads An error occured while loading the document. Fix the error, and then try loading the document again. The error message follows: File or...

Hi, After altering tables on the model and using the update wizard nothing is changing in my sql server db. Can somone tell me what am i missing? Thanks