devxlogo

The Latest

How to Make Text Wrap in HTML Forms

One common problem with typing into Web forms is dealing with input fields and having your words go right off the right edge of the box into infinity as you

Quickly Generate a GUID Using SQL Server

You can generate a GUID using SQL Server. All you need to do is open SQL Server Query Analyzer and execute following T-SQL statement: SELECT newid() This statement generates a

Why Obtain Recordset From Middle-Tier?

Question: I read the article ‘Obtaining Recordset From Middle-Tier COM Component’ and now am wondering why one would want to do this. As I understand it, this is only a

MTS running components on Web server

Question: We have ASP pages on a Web server with VB6 components that produce the majority of the HTML. These components run on the same machine as the the Web

SQL query results error

Question: To show my SQL query results in paged fashion, I used your article as reference. This error message appeared: ADODB.Recordset error ‘800a0cb3’ The operation requested by the application is

ASP results display in IE, but not Netscape

Question: I have a website that uses ASP to access a database and display information in a table format based on information the user selects on the screen. My ASP

Page Flashing and Reloads

Question: I know some of you have had this problem: a page (or especially a frameset) loads, then it quickly flashes off and reloads itself, but then ignores the scripts

Returning Recordsets From COM Components

Question: I have heard from some that it is a bad idea to return recordsets from COM components and that you should populate a variant array and send that back

A Quick Way to Read Database Contents in ASP

If you develop a complex Web application, you may find it a daunting task to keep track of the vast quantities of data on multiple domains in databases that quickly

Image Pop-Ups

Question: I want to have an image pop up, like a tool tip, when I hover over specific text. Is there any way to do this with DHTML or Javascript?

Remote NT Web Administration

Question: I want to provide the facility to add/delete/modify Windows NT users from a remote browser. However, I don’t know how to do it. Can you kindly help? Answer: This

Apostrophe causes syntax error in SQL query

Question: I have a problem with the add and update query in SQL. I am trying to update the database with a string which contains one or more apostrophes. SQL

Creating a For/Next Loop

Question: I tried using the replace function as shown below, but I receive an error on using “Next i”. Function formatOutput( theText )Dim iDim sNewStringFor i = 1 to Len(theText)

Designing a Pull-down Menu Over an Object

Question: Is it possible to design a pull down menu that will show over an object? Every way that I’ve tried still hides the part of the menu behind the

Calling a Nested Procedure in ASP

Question: Can we call a nested procedure in ASP? Answer: Nope. This isn’t supported in any Visual Basic-variant language. Having done nested procedures before (Pascal, I think), I never saw

Filtering Recordset Data

Question: After retrieving data into a recordset object, I want to filter this data. I tried using the objRs.filter method of ADO, but it doesn’t seem to work. This is

Determine How Fast Your ASP Scripts Really Are

Often when you’re developing script, you may want to determinejust how long the code takes to run. To do so, take advantage ofASP’s built-in Timer function. As you may know,

Using Active Server Pages

Question: How do I use Active Server Pages to create WAP pages? Answer: By setting the MIME type, you can use ASP to write WML. This command accomplishes this: Response.ContentType

Form Spinner Control

Question: When I create a spinner control and limit the upper and lower limits to specific integers, how do I wrap around the spinner to a specific integer range? For

Problem with Client SDK Driver Version 2.4

Question: After I install this driver, I see the error message when starting Lotus Notes Application: “The application uses CTL3D32.DLL, which is not the correct version. This version of CTL3D32.DLL

Interfacing WAP Pages with Phones

Question: Can WAP pages be built to interface directly with a phone and its functionality? Answer: Yes, you can write WAP pages that will display and call phone numbers directly,

What Are DCT Files?

Question: We have an application; within it is a file with the extension .DCT. What are .DCT files? Answer: DCT files are one of the files that Visual FoxPro uses

Minimizing/Maximizing the VFP Window with Code

Question: How can I make the Visual FoxPro main window minimize and maximize through code? Answer: VFP forms and the _SCREEN object have a property called “WindowState” that can be

Populating Databases

Question: I am trying to populate the stores (demo) database with a SQL script through dbaccess. The script keeps on returning syntax errors. The script is as follows: DECLARE status

Security of WAP Pages

Question: Can WAP pages be secure? Answer: Absolutely. WAP pages can be used for sending and receiving confidential information, such as credit cards and/or bank account statements. WAP was designed