... that means I'd have to use a sig... :-> Tore.
PS: That's a close call on your vision there Scott. -----Original Message----- From: Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 10:36 AM To: ActiveServerPages Subject: Re: Sorting SQL Server Dates.. cut and paste? I have this vision of Tore, red-faced, steam coming from ears, typing furiously each and every time date questions are posed here. Tore you could change your sig to Tore List Resident Date Field Evangelist It has a nice ring to it, ya? My pet peeve is short-hand coding. ie rsgrid("Name") instead of rsgrid.Fields("Name").value etc cheers ----- Original Message ----- From: "Showbear" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, August 22, 2002 11:49 PM Subject: RE: Sorting SQL Server Dates.. : Dave, are they stored in the db as dates, or as text? : : This list has a resident evangelist on the subject of date fields who is : supported by many of us. He may be able to paste some of his previous : messages on this subject into a reply to help you understand the problem : you may be having. Tore? : : : : -----Original Message----- : From: Dave Green [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, August 21, 2002 5:47 PM : To: ActiveServerPages : Subject: Sorting SQL Server Dates.. : : : What's the scoop with sorting SQL Server dates? : Some sample data: : : 8/19/2002 : 8/07/2002 : 1/1/1000 : 12/12/2000 : 12/31/9999 : : Running a query against this data like: : : Select theDate from theTable order by theDate : : Returns an invalid sort order. Thanks for your help. : : -- : Dave Green | PremierStudios | 913.438.1004 : : : : -----Original Message----- : From: Ben Timby [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, August 21, 2002 6:38 PM : To: ActiveServerPages : Subject: RE: website statistics : : : : -----BEGIN PGP SIGNED MESSAGE----- : Hash: SHA1 : : I would not suggest an ASP app for WWW stats. You should get a log : parser. It will filter your HTTP logs, and give you stats. AnaLOG is a : good/free one. : : Ben Timby : Webexcellence : PH: 317.423.3548 x23 : TF: 800.808.6332 x23 : FX: 317.423.8735 : [EMAIL PROTECTED] : www.webexc.com : : - -----Original Message----- : From: Brett M. Spahr [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, August 21, 2002 1:10 PM : To: ActiveServerPages : Subject: website statistics : : : : Does anyone know of a good, free asp app for tracking : website statistics? : : - --- : You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To : unsubscribe send a blank email to %%email.unsub%% : : -----BEGIN PGP SIGNATURE----- : Version: PGP 7.0.4 : : iQA/AwUBPWQdaPnby1cCm2Q8EQJKPgCgyITj7o7i/fbH/hkjs/ck7GGKz4YAoIrA : o9YZThzhrVV6g9laZxj6iwFg : =d+J3 : -----END PGP SIGNATURE----- : : : : --- : You are currently subscribed to activeserverpages as: : [EMAIL PROTECTED] To unsubscribe send a blank email to : %%email.unsub%% : : : --- : You are currently subscribed to activeserverpages as: : [EMAIL PROTECTED] To unsubscribe send a blank email to : %%email.unsub%% : : : : --- : You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] : To unsubscribe send a blank email to %%email.unsub%% : --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
