Tip Bank

DevX - Software Development Resource

Passing a CSV List Within an IN Statement

Question: I have a CSV list I am passing through as a parameter in a stored procedure. ——————————-Example of Region list:1,2,3,4,5,6,7,8,9,10CREATE PROCEDURE sp_getReport @Regionlist varchar(100) AS …….Select * from tblRegionwhere

DevX - Software Development Resource

Outlook Web Access and GAL

Question: Does OWA have access to the GAL to send messages to other users? Answer: Yes, Outlook Web Access (OWA) does have access to the Global Address List (GAL) from

DevX - Software Development Resource

Using #include

Question: I use from stl in a .h file: #include …….typedef vector IntVector; // error! But in the last line, the compiler returns the message: missing ‘;’ before ‘

DevX - Software Development Resource

WAP and Packet Formats

Question: Let’s say a WAP server has a WAP stack of the following layers: Connectionless WSP UDP IP Would you give me example packets that arrive at the server from

DevX - Software Development Resource

Large WML Files

Question: Can I arrange the WML information on my server in one huge file and still have it delivered to a WAP device? Answer: The largest “deck” you can have

DevX - Software Development Resource

E-mail Forwarding With Exchange 5.5

Question: How does a person in my office forward certain e-mails from his account in the office to his external e-mail account? Answer: Sounds to me like Auto-Replies to the

DevX - Software Development Resource

Constraints on Social Security Number

Question: How do I put a named constraint on a social security number defined as number(9) so that no hyphens are allowed in? Answer: To prevent numbers with hyphens from

DevX - Software Development Resource

Stopping Services for Backup

Question: As backup for a client, can I write a script in Exchange to shut down the service, copy all the data files to another drive, and then restart the

DevX - Software Development Resource

Software to Convert Informix dat to dbf

Question: Is there any software that will convert database files from Informix to dbf files? Answer: I’m not aware of any. Sort of like rebuilding a Ferrari and putting in