Tip Bank

Question: What can I use in SQL that does the same thing that IIF(test,TruePart,FalsePart) does in Access? Answer: You can achieve the same result using the aggregate function COUNT and

Question: How do I convert Informix Database to SQL Server 7, or even to Access? Answer: First, you need to create the identical database in SQL7 or Access (same field

Question: Is it possible in VB 6.0 to include pieces of code through an include- or importstatement like the C #include-preprocessor command or the Cobol copy-statement? Answer: You can add

Question: My SQL statement at the moment is: SELECT * FROM NewsItemsHow do I sort the dates in descending order? Answer: Use the ORDER BY clause to sort the results

Question: Is there an ODBC driver that can connect our existing Informix database on Unix to SQL Server 7.0 on NT 4.0? Answer: Yes. You need to run the Informix

Question: Can you put a variable within quotations?For example: Shell “Explorer.exe (?var)” Answer: You have to concatenate the two strings together. If your variable is named var, you would call

Similar to a procedure call in many programming languages, Server.Execute in IIS 5.0 calls a different ASP file as if it were part of the same ASP file. And it

Question: Do you know of any resource that readily identifies the differences between WAP 1.0, 1.1, and 1.2? Answer: Not that I’m aware of, but you might want to let

Question: If I create an ASP that outputs WML, can I use the Nokia Toolkit 6150 phone to view the ASP output? Answer: Yes, you can use the emulator tools