Question: Is it possible to assign an account to both SQL Server and SQL Executive and be able to log into Windows NT to perform task schedualing? I read in

Question: I’d like to write a little program that determines the type of system one has. It would be able to report, among other things, processor type, system/bios type/ver #,

Question: Is it possible to have more than one font type in a text area? I have tried, but I can only change the whole text area component. Answer: It

Question: Can a script be placed in an external JavaScript file so it doesn’t have to be placed on all 200 pages of our Web site? Answer: Yes, as long

Question: We are trying to develop an intranet application and have traversed many rough roads and dead ends. Our environment is Internet Explorer 4.0 (some IE3), SQL Server 6.5 (soon

Question: I would like to have a page that allows a user to conduct a search. I would like the action of the search to be an ASP page that

When using JavaScript in your Web pages, you should keep in mind that a user’s browser might not support JavaScript. This could either be because the browser is old or

Using JavaScript, you can set up a form such that when the Web page is loaded the cursor is in the text box. This functionality avoids making the user click

Generally, namespaces are open so it is perfectly legal to expand existing namespaces with additional declarations and definitions in several files. The only exception to the rule is namespace std.

You can use JavaScript at the top of an HTML document to detect if a frameset is loaded and if not, load the frameset. If a window’s top property points

If you’re looking for a development environment for JavaScript, JavaScript debuggers are available as a free download from both Microsoft and Netscape. The feature set of the two products is

You should pay attention when using default arguments in virtual functions. The default values in the overriding function have to be identical to the corresponding default values in the base

#including a file more than once during the same compilation session will most likely cause the compiler to issue error messages since definitions and declarations of the file are repeated.

You can use Rnd followed by Randomize to seed Visual Basic’s random number generator. Whenever you use the same seed, Rnd produces the same sequence of random numbers: Rnd -1Randomize

The “Auto-Propercase Text Box at Entry” tip [VBPJ May 1997, page 63] has a simpler solution. The StrConv function can propercase any string. You can achieve the same effect with

While developing a database front end for hand-tool management, I discovered a need to handle both fractional and decimal representations of dimensions in the same text box. This makes it

When you define a form named MyForm, Visual Basic creates one instance with the name “MyForm.” Many programmers confuse this special instance with other instances created using Dim. For example,

Question: We want to begin collecting customer e-mail addresses from our Web site. Our current file system is mainframe based, storing all data in uppercase format. Are e-mail addresses case

Question: In my Visual Basic ActiveX DLLs, some of the methods that I created for my objects use optional parameters. When I attempt to call these methods, I receive a

Question: I have noticed that some sites have tables that sit side-by-side. I can never duplicate this behavior with my HTML scripts. Do you have any suggestions? Answer: Positioning two

A type-name is merely a placeholder that has to be substituted with a proper type. For example: template T min( const T& first, const T& second); //T is a type-name,

To decide when it is safe to exit your program, use a DataUnsafe function. Set the DataModified variable to False when you load or save data, or when you start

Question: I’m trying to query our Human Resources database to find the number of temporary employees in each department. I’m using the following SQL statement: select count (*)from employeewhere status

Question: I have a table like this: name cat1 cat2—- —— —–A 1 orangeA 1 orangeB 1 appleB 1 appleB 1 appleC 2 bananaC 2 bananaC 2 bananaC 2 banana

Question: Is there any other way apart from using the INSERT INTO command that allows you to append a line to a database? I have a primary key “ID,” but

Question: I am working with a client that has a Powerbuilder application. We need to call that app through a variety of APIs. The client says that they cannot act

Question: How can I dynamically add a visual userobject to a visual userobject? The PB documentation mentions how to add a userobject to a window at run-time, but not how

Question: I have a select query “Select * from Table where ID in (8, 2,3,78,32,1,7)” that I want returned in the same order that the IDs are in in the

Question: I need to know how to order by the count of the selected field. For example: Select xxx count(xxx)from prod-tableorder by xxxI’d like to order/rank field xxx highest to

Question: Is there a limit to the number of connections to an SQL server? If so, how many connections are permitted at one time? Answer: The number of connections is