| Author |
 Topic  |
|
n/a
9 Posts |
 Posted - 05/01/2003 : 21:56:02
|
Hello,
Have a strange problem ... ever since the month rolled over to May, Aleza is not showing the newest links in the Newest Links box or showing the new icon next to the top category. The lastest links shown in the newest links box are ones that were added on the last day of April.
Anyone seen this or know how to correct it?
Gene |
|
|
n/a
9 Posts |
Posted - 05/08/2003 : 17:19:09
|
Ok so I have tracked this down a bit more. In reviewing the links table in the database, all new entries in the database are being written to the datein column as:
day/month/year instead of month/day/year
Now I have not made any changes outside of cosmetic ones, and have even gone as far as downloading a fresh copy and setting it up using the database I have built.
Entries are being written as day/month/year whether they are:
- entered via the form on the site and approved
- using the copy feature to copy a link from one category to another
Anyone have any ideas?
Gene |
 |
|
|
n/a
10 Posts |
Posted - 05/09/2003 : 19:36:40
|
You're not alone. I have the same problem here. The date format in the DB "flipped" on May 1st. My links have been added from within the resource manager.
For example, entries made today would put "9/5/2003" in the datein column in the links table in the DB, whereas the same entry last month would have put a "4/9/2003"
Now my newest links box looks bad. It will show "9/5 - [hyperlinked name] -" and that's it.
|
|
|
|
n/a
9 Posts |
Posted - 05/10/2003 : 01:18:57
|
Ok so at least I am not going crazy 
While I haven't fixed our found the cause of the problem, I have remedied it by downloading the access database each night and changing the date format in the datein column.
Gene |
|
|
|
n/a
10 Posts |
Posted - 05/11/2003 : 10:28:41
|
Could you edit the \language\lang_windows.asp file? That's what I did where it says...
'Repeat
CONST LV_NLtemplate = "<tr><td width=""40""><p align=""right""><font face=""Verdana"" size=""1""><MONTH>/<DAY></font></td><td>
I switched to <DAY>/<MONTH> instead.
I also increased this CONST as shown make the output look better...
CONST LV_NMmaxchars = 250
-Dave |
Edited by - n/a on 05/11/2003 10:30:53 |
|
|
|
n/a
9 Posts |
Posted - 05/12/2003 : 19:40:37
|
Yes I did play around with that as well ... but would much prefer to find the error that is causing the dates to be entered into the db the wrong way ... especially as how I have been manually changing the dates in the db
Gene |
|
|
|
n/a
9 Posts |
Posted - 05/15/2003 : 13:55:57
|
Ok so weirdness prevails some more ...
Had 2 new entries into the database today [5/15/03] ... both of these entries automatically wrote to the database in the proper format.
help ! 
Gene |
|
|
|
n/a
2 Posts |
Posted - 05/16/2003 : 09:03:41
|
What is the server language. American, English, French....?
It should be a Session.LCID problem here related to the way the server read the dates. |
|
|
|
n/a
10 Posts |
Posted - 05/16/2003 : 16:41:41
|
Entries in my DB since May 13th, 2003 have been entered in the proper USA method of month/day/year were entered, where prior to May 13th they would have been day/month/year.
I think solgel has the right idea. I'd expect the fix is something like...
<% Session.LCID = 1033 %>
or
<% Set Locale(1033) %>
in the right spot, but I need to dig deeper to know for sure. Actually, I'm going to use a different country code and work it backwards.
-Dave |
|
|
|
n/a
10 Posts |
Posted - 05/16/2003 : 17:35:47
|
OK... I think I found a fix.
Check your \admin\connection.asp file. Change "session.LCID = 1030" to "session.LCID = 1033" instead. (1030 is Danish and 1033 is US)
That should prevent European date formats in the db. But it doesn't explain why the format change happened in the first place. Still checking... |
|
|
|
n/a
10 Posts |
Posted - 05/16/2003 : 17:51:37
|
OK, so I went back into my DB of mixed dates and changed all European dates to US date format. Everything looks and works perfectly fine.
Maybe I'm wrong, but I'll chalk up the date flip glitch to server gremlins and how they juggle the Locale LCID = xxxx, Session LCID = xxxx, Database LCID = xxxx functions.
Let me know if this works out for you.
-Dave |
Edited by - n/a on 05/16/2003 18:01:51 |
|
|
|
n/a
10 Posts |
Posted - 05/16/2003 : 17:56:33
|
| Also change the root connection.asp "Session.LCID = 1030" to "Session.LCID = 1033" as well. |
|
|
|
n/a
16 Posts |
Posted - 04/02/2007 : 01:33:46
|
[url]http://blogosfer.com/viaggra/[/url] [url]http://dundeeunited.org/forum/topic.asp?TOPIC_ID=64[/url] [url]http://dundeeunited.org/forum/topic.asp?TOPIC_ID=57[/url]
<xc9058f3d> <f56rtyupolke3> |
|
|
|
n/a
42 Posts |
Posted - 04/10/2007 : 05:13:35
|
its rate [url]http://www.kohukohu.com/forum/topic.asp?TOPIC_ID=763[/url] an [url]http://www.kohukohu.com/forum/topic.asp?TOPIC_ID=771[/url] is a medicine [url]http://dundeeunited.org/forum/topic.asp?TOPIC_ID=154[/url] strength of the [url]http://www.ad-pecjak.si/forum2/topic.asp?TOPIC_ID=167[/url] and social [url]http://www.ad-pecjak.si/forum2/topic.asp?TOPIC_ID=169[/url] does
<xc9f58c21> <G56rtqupålke3> |
|
|
|
n/a
89 Posts |
Posted - 04/23/2007 : 09:01:21
|
own [url]http://sites.blockstar.com/bestmeds/phentermine.html[/url] Trials [url]http://sites.blockstar.com/medcat/buy-viagra.html[/url] you use pre [url]http://www.microbial-ecology.net/forum/topic.asp?TOPIC_ID=277[/url] the tablets have
<x7b79ed48> <G56rtqupålke3> |
|
|
|
n/a
53 Posts |
Posted - 05/18/2007 : 08:52:24
|
to take [url]http://www.angelfire.com/va2/dynastyreview/_disc1/00001441.htm[/url] If you are [url]http://www.angelfire.com/tx6/policy2/_disc/00000298.htm[/url] Do not take [url]http://www.optics.arizona.edu/aschlak/_disc1/000006ae.htm[/url] considered [url]http://www.angelfire.com/hiphop2/mbp/_disc/000001b5.htm[/url] his prescription [url]http://www.earto.org/DESCA/DESCAFeedback/0000006a.htm[/url] information [url]http://www.angelfire.com/tx6/policy2/_disc/000002a3.htm[/url] ephedrine products containing [url]http://members.tripod.com/forumtllm/disc1/000001b6.htm[/url] honest [url]http://www.usd.edu/sildl/_vti_bin/shtml.exe/_tiopdisc/00001392.htm[/url] Inform your doctor
Hello |
|
|
|
Topic |
|
new month