Recent content by noodles1

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?