Search results for query: *

ESquared, I think you will find that either form works.

That's a good suggestion I think. Doesn't complicate things with hosted environments. ZipGenuis allows command line invocation, thus could be used from Run or Exec methods of a wscript.shell object.

dateadd(day, 0, datediff(day, 0, YourDateColumnOrVar))

I too have experienced orphaned Excel and Word processes when using office automation objects in ASP. Could not find anything wrong with the use of the office objects in the ASP code. I had to resort to developing a background housekeeping process that would run as a Scheduled Task on the web...

Any thing written to the Event Log that might provide a clue?

File type in a Windows context is essentially based on the extension of the filename and what application that extension is associated with. This results in the Windows shell knowing how to "describe" the file in Explorer, and what application to invoke to act upon the file when a filename of...

Can you explain what you mean when you say the only data that you have in the Parts structure is from the final pass of the inner loop? Have you checked to see how many passes through each of the loops are being done? I would also recommend putting in some checks for end-of-file conditions so...

System.ServiceProcess namespace. See ServiceController class and its Start & Stop methods etc.

The NativeDLL.h is used both for the building of NativeDLL.dll (from compiling NativeDll.cpp) as well as in the compilation of whatever source code you are calling the NativeDLL exported functions from. Thus, the definition NATIVEDLL_API means different things in different circumstances. When...

I have an ASP application using Crystal 7 and he Crystal Smart Viewers for displaying the report output. When the user selects the Print button on the viewer, the Windows Print Dialog appears, but many of the standard options are disabled, such as for printing indivdual pages or page ranges...

Thanks for the suggestions. I have checked through the source to try and ensure that no content is coming from outside the secure server. What surprises me is that it only happens to 1 group of users from a common office and only if the use the Load Balanced URL. I'll request a copy of the...

I have an ASP application that runs on 2 web servers load balanced via WLBS. The site uses SSL. I have 1 group of users that access the site from their office that, when accessing via the URL www.???, they are continually presented with the Security Information "This page contains both secure...

Here is the code of the main view ALTER View dbo.vew_Rpt_ESP_AnnualBenefitStatement As Select top 1000000 Product.ProductNo, Upper(IsNull(Product.ParentID, '')) As ParentID, Member.MbrNo, Member.SchemeNo, IsNull(Address.Line1, '') As Line1, IsNull(Address.Line2, '') As Line2...

I have a view that uses a number of other views. The columns associated with this view do not appear in the Query Analyzer Object Browser. Running the view in Query Analyzer appears to produce satisfactory results. If I alter the view by commenting out references to certain of the referenced...

Whilst, I know it is pssible to execute a Stored Prcoedure within a SELECT query, can I call a Stored Procedure where one or more of the arguments that need to be passed are obtained through a JOIN within the SELECT query?

I have a Web Application (ASP) that launches instances of Excel & Winword and on occasion these processes do not terminate. I am trying to write a house keeping scheduled task that will clean up these dormant processes if the process creation time is beyond a certain point. These processes are...

PHV, My typing at fault. That snippet should be t2.Addr_Ident_Code1. What I do have is 15515 rows in t1, 302510 rows in t2 and 14110 rows that match between t1 & t2 based on the join condition. I tried your proposed solution but get 0 rows updated.

JarlH, Thanks for the reply. In my circumstance, there can on be a 1-1 (or 0-1) relationship between rows across the 2 tables according to my join condition. Meaning that for each row in t1 there can only ever be 0 or 1 matching rows from t2 according to my join condition. Does that alter...

I seem to have a problem with a Update using a correlated subquery. When I run the following: UPDATE Agtable1 t1 SET t1.ztAddr_Line1 = (select t2.Addr_Line1 from Address t2 where t2.Addr_Type = t1.ztAddr_Type AND t2.Addr_Ident Code1 = t1.ztagree_no ) the subquery is returning 0 rows thus...

I have a Win32 service that intermittently crashes due to some kind of memory access problem. I can run it in debug mode and after enough time I can get the error to occur. It always appears to occur at the same instruction address. Using MS VC++ 6.0, is there a simple way that I can locate...