Search results for query: *

Hello, I have just moved our web server from Windows 2000(with IIS 5) to a Windows 2003(with IIS 6) machine. The new server displays the dates as mm/dd/yyyy hh:mm:ss am where as the old server displays them in the format we want - dd/mm/yyyy . The data is coming from the same database so I know...

Hello. I need to write a VB application that can update the DNS entry on the DNS server for a particular computer. For example when the application runs it will update the DNS entry for "myserver" to point to a particular(known) IP address. How can this be done? Any help would great! Neil

Hello. I am trying to create a datagrid that has the results of several datatables. Each datatable contains a partnumber and quantity. I would the the row in the datagrid to contain the partnumber and then the quantity of this partnumber from each of the tables, effectively join the tables. How...

Hello! I am trying to sset the visible property of a template column within a datagrid at runtime. So, for example, i want some users to be able to view the Edit column and others not to see it. How can this be done programmatically? I know the template column has a Visible property that can...

Hello... Is there a way to display the memory that my VB program is currently using from within the code?? I have tried using the GlobalMemoryStatus API but that only shows the total memory usage for the machine not for the VB application. Anyone any ideas? Neil

Hello... I have a database that is replicated across two servers using transactional replication, which works ok. However, I have found that the table sizes on the primary and secondary servers are significantally different even though they have the same number of rows. The tables are far...

Hello, I have a very annoying problem with an application that I have inherited. The application in question uses several ActiveX.exe. When I modify any of the ActiveX I find that I have to recomile the whole application otherwise it loses its reference to the modifed ActiveX. I have tried...

Hello, I am trying to write an SQL insert that gets some values from another table and some values created from elsewhere. What i would like to do is: insert into table1 (Board,entity,info,value,clocked) values('A','B','C',select value from table2 where info=123,getDate()) Is something like...

Hello... I have a table which has a field that holds an integer value. What I want to do is calculate the difference(ie subtract) of this field for my selected records. eg ID Value ---------------- 1 30 2 10 Get the difference of value between record 1 and record 2...

Hello! I am trying to update the hour/min part of a datetime field, i can update it using the dateadd funtion: Update shiftCalculator set Rotation_Time =dateadd(hh,8,Rotation_Time) this works fine if I want to advance current time by a certain amount, but how can i set it to a specific value? I...

Hi, I have created some classes that I want to use for several programs. Some of these classes require input files (for configuration data etc). I have kept the classes in a seperate location (ie windows folder) from the application and included the path to the classes in my classpath. I can...

Hello... Could someone explain to me why after compiling my Java program I get some class files that look like: classname$x.class (where x is a number) I need these for the program to run, but I have no idea how or why they are created or what they do... they are all pretty small (only 1K)...

Hello... I have developed a simple java program and part of its functionality is to write to a text file. When i run the program from the windows command prompt using the "Java" command, the program works fine and writes to a text file as expected. However, when i run the program using the...

Hello, I have an application that talks to an SQL Server database. My application works fine, but what i would like to do i have the ability to check if the connection to the database is valid before carrying out any queries on it. Is there an easy way to test this? My application will be...

Hello, I am newbie to java so be kind, but how do i change the color of the text in a textarea? I can change the font for the text, but have no idea how to change the colour! Please help, Neil

Hi, I am trying to write an application to read from the COM port on my PC using the java communications api. However, when I try to enumerate the ports on my Windows 2000 PC it doesn't return any ports.. Here is my Code: import javax.comm.*; import java.util.*; public class PortList {...

Hello, I have the following stored procedure: CREATE PROCEDURE avg_daily_prod @start_date datetime = '01/11/2003', @end_date datetime = '12/11/2003', @day int =3, @sums int = null output, @days int = null output @tempsum int= null, as set datefirst 1 set dateformat dmy select @sums=...

Hello, I am trying to fill in a cell in my datagrid in the following way: <ItemTemplate> <% if DataBinder.Eval(Container.DataItem, &quot;type&quot;)) = &quot;1&quot;) Then GetTotal(DataBinder.Eval(Container.DataItem, &quot;type_of_expense&quot;), DataBinder.Eval(Container.DataItem...

Hello, I have created a web application in Visual Studio 2003 and I have deployed it on our webserver without any problems. However, it has since been necessary for me to make a few changes to the application. Is there an easy way for me to apply these changes to the application on the...

Hello, I am trying to create a Stored procedure in the following way: CREATE PROC RetroReport @RetroCreated int output, @RetroShipped int output, @RetroCancelled int output, @Retro2DayGap int output AS SELECT @RetroCreated =(Select count(*) FROM Retrofit_Orders where date_created >=...