RE: Auto Date selection and format

2004-07-01 Thread Mike Koponick
Michael/Wesley, Thanks for your help. You got me going in the right direction! Thanks again!!! Mike -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 7:37 PM To: Mike Koponick Cc: [EMAIL PROTECTED] Subject: Re: Auto Date selection

Auto Date selection and format

2004-06-30 Thread Mike Koponick
Hello all, I would like to be able to select the certain dates within my script. select created_date, status, user, comment1, comment7, comment8, action from users WHERE customerid = 'Customer' AND created_date BETWEEN '2004-05-31' AND '2004-07-01' ORDER BY created_date, status into outfile

RE: OUTFILE to CVS with headers

2004-06-25 Thread Mike Koponick
Bob, That did the trick! Thanks! Mike -Original Message- From: Bessares, Bob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 6:03 PM To: [EMAIL PROTECTED]; Mike Koponick Subject: RE: OUTFILE to CVS with headers well, you can easily output into a comma separated file

OUTFILE to CVS with headers

2004-06-24 Thread Mike Koponick
Hello, I'm working on a project where I must export to a text file and the text file needs to be formed into columns so that it can be imported into a WORD mail merge document. So, the format of the output file has to have the headers for each column and the lines must have a CR at the end of

Encrypt data

2004-02-24 Thread Mike Koponick
Hello everyone, I'm new to the list and did a little searching on the archives but wanted to ask my question to the group. I have a requirement to encrypt all data stored into a database. I was wondering if there was a different way of doing this or should I use the encrypt/decrypt functions?