Ahmed, Yes, I've got several people using it in the UK. The particular web templates we're talking about are the SangfroidJr web templates here:
http://www.gotdotnet.com/Community/Workspaces/Workspace.aspx?id=d5affd3e-f27a-4b79-93b2-cd75a6242e5c To make it work with the UK date format, you can either go into the registry and change the date format SA uses in the database, or you can change the "CAST" command on those pages to use a "CONVERT" command. Peter Martin sent me the following as an example: > PM> Brent, > > PM> Had a look at the books online, converted the templates to use CONVERT > PM> instead of CAST and all works fine now! > > PM> Thanks for your assistance, and for doing the pages to start with! > > PM> Command used was > > PM> convert(datetime,laststatuschange ,3) > > PM> 3 is UK datetime style Brent Wednesday, July 9, 2003, 7:45:50 AM, you wrote: AH> Is anyone using/has been able to use Brent's great web templates on UK date format? AH> I keep geting the following error message each time I try to drill-down for details of a particular check. AH> Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) AH> [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. AH> /SangfroidJr/OneCheck.asp, line 41 AH> --------------------------------- AH> Yahoo! Plus - For a better Internet experience -- BrentO Trackman(men) have bigger balls. To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
