Search results for query: *

I'm joining 2 tables, A and B, as described below Table A title_id effective_fiscal_yr end_fiscal_yr Table B title_id fiscal_yr So Table A contains a year range, whereas table B contains specific years. So I want to set up joiner conditions as: a.title_id = b.title_id and...

We've got a VB6 application that hits a MS SQL Server 2000 DB. We use command object to append query parameters. What I cannot figure out is how to use the command object paremeter append method when dealing with a SQL in() function. How do you use parameter.append when referring to a SQL...

I work on an application that uses MS SQL Server 2K. We have a need to periodically reference a linked server to gather some Oracle data inside SQL Server queries. My linked server knowledge is sketchy at best, and our DBA who manages these connections is not readily available to us...

Is there a Javascript function that simply checks to see if what I am referring to is an object on a web form? For example, the Javascript would be doing some client side validation of a web form that may or may not contain a checkbox. If the checkbox exists, I want to run some validation on...

Is there some accepted benchmark that says if you are running a web server on a machine with x processors of y speed with z memory, it should be able to comfortably handle n users? We have a period of time each year where, due to deadlines and procrastinators, our site gets totally bombarded...

I'm doing some Excel stuff on my computer at home, which I never do, and I'm trying to do some financial calculations. On my work machine, when I type a function name into a cell and get to the "(" character, it pops up a list of the parameters it expects, sort of like as Alt text in...

I am in the process of learning C#/.Net and am going through the QUE 70-315 Training Guide by Amit Kalani. The book is not necessarily relevant to my question but I am including it in case someone has also used the book. I am doing an exercise that builds a single-table data form (Step By Step...

I'm having an intermittent problem on my computer. Windows 2000 SP4 with IE 6 SP1, all critical updates and service packs up to date. Sometimes my browser indicates 0 bit cypher strength. I have downloaded and installed 128 bit some time ago. Some boots my browser indicates 128 bit and I can...

This is really bizarre and at first I thought I had probably done it myself and not known it but it has happened three times this week and I am quite confident that I am not doing it. Certain emails of mine are being printed. I am not printing them. Other people who use the printers are...

Assume I have a table with columns A, B, and C, all of which are of a numeric datatype. I want to write a select that will bring back the lowest value of the three. The idea is similar to using the MIN() function, but instead of choosing the minimum value out of a series of rows, want the min...

I have a Word document with a series of carriage returns that I want to remove. I've done this before but I cannot recall the string that represents a carriage return for which you have to search. I think it is something like ^P or something but I cannot recall. Thanks for any help.

I'm running Windows 2000 Professional on my machine at work. I've noticed this thing where whatever window is active, every 60 seconds or so, it loses focus for a split second and then regains focus. The way I can see it is that the titlebar turns grey very briefly before returning to blue...

We have an application that automatically generates an email and sends them to the users when certain events happen. We are using the CDONTS object to do this. The problem is that we get these users who swear up and down that they never got the email. The application, however, does not throw...

I am using CDONTS to send email from a web page. I have added the functionality to send attachments. I sent a word document to both my work email (viewed through MS Outlook) as well as my personal yahoo address. In Outlook, the attachment is recognized and can be opened, saved, etc, as...

We're building a site that must function on both IE & Netscape for both PC & Mac. We're seeing the following issue and cannot find anyone else documenting the same problem, but I think someone must have come across this before and might know the solution: We're running some Javascript form...

I have a series of textboxes that are all related and are involved in the summarization of numbers. Putting a number in textbox A affects what is displayed in textbox B. If a change in textbox A makes the number in textbox B negative, I'd like to use Javascript to make the text in textbox B...

I'm running Windows 2000 Professional. Any time I open my control panel, it takes about 3 minutes to open. No exaggerration, really 3 minutes. There's no hour glass or anything, but in the time that the control panel is loading I cannot do anything with any other programs. It's like you...

Think this is probably a pretty stupid question, but: How do I know what version of ADO my machine is running? I can't figure out where to look for this. Thanks for any help.

I am using the following attribute in my <input> tag: style=&quot;text-align:right&quot; This works fine in IE 5; however, I need it to work in Netscape 4.08 as well. Not surprisingly, it doesn't. I've looked in a book that suggests that &quot;style=textAlign:right&quot; should work for...

I have a page that reloads itself every 15 seconds. What is happening is that every second time it reloads, it is printing a portion of the stylesheet as well as some of the JavaScript code at the top of the page. It prints the same portion of code every time, the bottom three quarters or so...