December 16, 1998

Comparing Dates

Question: How do I compare dates to determine if one comes after or before another? Answer: You can just use the normal IF statement: IF ld_date1 < ld_date2 THEN ... ...END IF

SQL Server Errors

Question: When rebuiling indexes I receive an error. Error 1501:[SQL Server] Sort Failure What is happening, and what do I need to do to fix this problem? Answer: I was unable to find specific documentation on that error. However, with similiar errors (see article Q140265 in the Microsoft knowledge base),

API for NT Command Scheduler?

Question: How can I program the NT Command Scheduler (AT command) using VB5? What are the API calls? Right now I’m just using Shell to run AT. Is this my only option? Answer: This is a very simple example that should show you what you need to know to use

BCP

Question: Can you import Excel files into SQL Server tables using bcp? if so what is the command line? Answer: You can’t execute bcp directly against an Excel file. However, Excel gives you the option of saving your worksheet as comma-delimeted or fixed length. You can then run the bcp

Visual Studio 6 Hoses NT

Question: As part of a normal Visual Studio 6 upgrade on an NT Server 4.0 SP3 machine, Setup rebooted the machine “to continue the install.” I then got a blue screen and STOP and this message: “The dynamic link library winsrv could not be found in the specified path Default

How to create NT user home drive

Question: I set the usri3_home_dir and home_dir_drive when I create an NT account using VB code. I also need to create the home directory on a specified NT server. Any ideas? Answer: Assuming you have rights to do so on the server in question, you can simply: MkDir “\lj_serverc$users” MkDir

Display Values of Fields on Confirmation Page

Using Active Server Pages, you can easily get the values of fields on a form to display on another Web page for user validation as a simple confirmation page. In the page with the tag, you might have: On NextPage.asp you can include the following code to extract the values

Why Class String Doesn’t Have an Implicit Conversion to char *

The standard class string (unlike MFC CString for example) doesn’t have a char * conversion operator for two reasons. First, implicit conversions can cause undesirable surprises when you least expect them. Legacy C code is combined with new C++ code in many systems. In its pre-standardized form, C used char

Passing Information via the Query String

You can pass information via the URL very easily. This process is called passing information via the Query String. The Query String is the bit of information that is on the address line with the URL and to the right of the question mark (?). An example would be: http://www.myserver.com/mypage.asp?Name=Bob&FavoriteSite=Inquirydotcom

No more posts to show