Question: How do I limit an SQL SELECT statement to returning just the top ten producing offices? Answer: Use the TOP operator or SET ROWCOUNT to 10. Related Posts UK
Question: When I add sites to my Microsoft Internet Explorer Favorites, the site’s logo (or icon) appears by the Web page’s name instead of the little “e” that usually appears
Question: JavaScript provides straightforward methods for detecting things like browser version and platform, and a few options such as whether the client will accept cookies. But is there a way
Question: I am trying to put lines of text into an array: messageArray = new Array();messageArray[0] = ‘Information deduced from the document’s content.’ I’m running into problems with the single
Question: Is there a way to programmatically reset the status of a record in an ADO 2.1 recordset? For example, I would like to change the status of a record
Question: I have a VB database application that, when I pass a unique id to a client object, opens that record (this explanation is simplified). I have to write an
Question: I have a program that calculates the number of people the government could send to college with the money they spend on certain defense programs. The script works, but
Question: What is the maximum length of a JavaScript string? Answer: Although there is no specific limit on the length of a JavaScript String, there are practical limits on how
xtensible Stylesheet Language (XSL) has slowly been gaining a reputation as the SQL of the hierarchical data world. Even with only the partial implementation that Microsoft’s XSL offers, you can
ven though the Java Virtual Machine performs automatic garbagecollection, you can’t completely forget about memory managementissues. How and when garbage collection is performed isimplementation dependent. Some JVMs will wait until
n last month’s 10-Minute Solution, you learned how to display selective data from a database based on the user’s choice. This time you’ll see how to improve and optimize this
n designing a relational system, the simplicity of each individual relation belies the complexity engendered by the multiplicity of tables created by implementing that model. However, simply by observing “good
y now I am sure that many Visual Basic developers are leveraging their Visual Basic skills to do some Web development. In this Solution, I’ll cover DHTML Behaviors, a new
isual Basic offers many methods for sharing data within an application. When we talk about sharing data, there are several possible levels of sharing: Within a procedure Within a form/code
Question: How do I design a matrix using XML? This matrix needs to be a separate tree from the main XML tree. How do I communicate between the two trees?
Question: I am using the XMLHTTPRequest object in Visual Basic to invoke an async call. How do I register a complete event handler of the XMLHTTPRequest object? Answer: You’re not
Question: I’m using MSXML to create a DOMDocument and add nodes and attributes. When I’m done, I’d like to save the XML text into a string. Unfortunately, the Save method
Question: I’m looking for sample database in a form of Create Table statement+Insert statements and beginner-level assignments using this database. Do you know where I can find something like that?
The new FlatScrollbar controls expose the ability to selectively disable their arrows. This is useful, for example, when the thumb indicator is at its minimum or maximum: Private Sub FlatScrollBar1_Change()
Most VB controls don’t let you determine whether they should display a scrollbar or not. For example, a VB ListBox control displays a vertical scrollbar only when the number of
The VB CommandButton control supports neither the ForeColor nor the BackColor properties. If you want to create colorful buttons without resorting to 3rd party controls, you can use an OptionButton
By default, VB’s CheckBox controls automatically toggle their Value property when the user clicks on them. This is usually the desired behavior, but at times you may want to be
The ComboBox control doesn’t expose any property that lets you to control the width of its list area, but this can be easily accomplished by sending it the CB_SETDROPPEDWIDTH message,
Unlike the TextBox control, the ComboBox control doesn’t expose any MaxLength property, so you have no means of limiting the numbers of characters typed by the end user in the
Contrary to common belief, Debug.Print statements are not always removed from an executable. This behavior can be demonstrated easily. Open a new project, place a single CommandButton on the default
It’s possible to streamline some calculation procedures in Excel and add calculation capabilities that don’t exist in Word. Unfortunately, most textbooks on VB for Office 97 are focused on nonmathematical
Because server/client round-trips are inherently inefficient, you should try to eliminate the need for excessive round-trips. When you design a class or a user-defined interface, you should never expose three
In C, algorithms that rely on pointers such as bsearch() and lfind() return a null pointer to indicate that the sought after element wasn’t found. Unlike a pointer, a reference
Enhancements to the lock manager in SQL Server 6.5 provide row-level concurrency for INSERT operations. Properly implemented rowlock increases the speed of multi-user INSERT operations. Insert rowlock (IRL) is OFF
Similar to GzipServlet, this tip uses header information for tuningoutput of our servlets; this one allows you to check the header ‘Accept-Language’. If your user has set some language preferences