| Author |
 Topic Search  Topic Options
|
dj air 
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 13 February 2005 at 5:22pm |
|
you have 1000 members , what sort of traffic, users do you get on at once?
also how many forums, topics and threads do you have, likely to get if its quite a few i would recommend going back to SQL.
|
 |
sfd19
Senior Member
Joined: 20 December 2004
Status: Offline
Points: 263
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 5:32pm |
 Info_Tech wrote:
-boRg- wrote:
The CDate error on the forum_posts.asp page is usually cousred by the edit date, if the post has been edited.
The problem comes when changing servers etc. from a server that uses a period (.) in decimal numbers and those servers that use (,) in decimal numbers eg:-
123456.55
123456,55
If you have access to the server, changing the servers settings to use (.) instead of (,) or vise versa would sortout this issue.
|
I do not have access to the server. Could you tell me where specifically to look in the forum and what to edit? Thanks. |
Was my post right above yours not clear enough - where I explained what to do when you do not have access to the server?
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 5:41pm |
dj air, to see the forum of my website: http://www.iraqvoice.com/justa/aforum/default.asp
sfd19, No it wasn't clear enough "to me"...It would be great if you give me an explaination as if you're talking to a beginner that is facing this issue for the first time. Thanks.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 6:29pm |
|
with the number of posts (60 thosand) i would recommend the SQL version.
|
|
sfd19
Senior Member
Joined: 20 December 2004
Status: Offline
Points: 263
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 8:18pm |
Info_Tech wrote:
dj air, to see the forum of my website: http://www.iraqvoice.com/justa/aforum/default.asp
sfd19, No it wasn't clear enough "to me"...It would be great if you give me an explaination as if you're talking to a beginner that is facing this issue for the first time. Thanks. |
That is how I tried to explain it. Which part was not 'beginner-like'?
sfd19 wrote:
Right before this line in /functions/functions_format_post.asp
If isNumeric(dtmEditedDate) Then dtmEditedDate = CDate(dtmEditedDate) Else dtmEditedDate = 0
add a new line.
When your server is using "." in the date format (eg German servers) then add
dtmEditedDate = Replace(dtmEditedDate,",",".")
or when your server is using "," in the date format (eg American servers) then add
dtmEditedDate = Replace(dtmEditedDate,".",",")
When you are not sure what format your current server is using then check for a message in your database that has been edited with the current server settings and see if that server is using "," or "." in the number of the edited date. Then apply the fitting code line from above. |
|
|
|
|
