November 2, 1999

Handling Single and Double Quotes

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 quotes (‘) because it thinks that the text is over and that there is an extra ‘. What can I

ADO Recordset

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 from adRecModified to adRecNotModified, but without reverting the field values to the original values. Answer: I don’t believe it’s possible,

ActiveX Control to read URL properties

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 ActiveX control of some type that accepts a URL, so I can parse out what I need and pass it

Round to a Whole Number

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 when I divide the cost of the education into the cost of the program, I get a number with lots

Maximum String Length

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 long your strings can get. In Netscape, you should be wary of creating strings longer than a megabyte in length

Validate Data With Regular Expressions and XSL

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 perform surprisingly complex queries. Yet the language has been hamstrung somewhat in that the current XSL query language can only

Memory Management

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 allavailable memory is used up before kicking in the garbage collector,while others will run it incrementally. That is why Runtime.gc()

Filter Data from a Database

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 technique. Specifically, you’ll learn how to display a list of states as they exist in the database as a drop-down

Consolidating Tables for Easier Database Maintenance

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 housekeeping”?meaning, observing the old saw that there’s a place for everything and everything in its place?you can arrive at a

No more posts to show