Web Wiz Support and Community Forums : Web Wiz Forums 7.7a released https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 05:03:57 +0000 Sun, 18 Apr 2004 12:35:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9513 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Web Wiz Forums 7.7a released : The forum does use dates produced...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54442.html#54442 Author: WebWiz-Bruce
Subject: 9513
Posted: 18 April 2004 at 12:35pm

The forum does use dates produced by the server or update dates in thedatabase with dates/times that are not the correcnt date/time.

The server date time is used as problems were found where the SQLdatabase was at a different time setting to the server the forum was on.

Also there are many, many other issues that I don't want to spend allday explaining. But basically there are many problems with making theforum compatible with mySQL that stretch further then just ADOproblems, recordset paging, and sub quiries.
]]> Sun, 18 Apr 2004 12:35:09 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54442.html#54442 <![CDATA[Web Wiz Forums 7.7a released : So what&#039;ll be next. The MySQL...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54333.html#54333 Author: dpyers
Subject: 9513
Posted: 17 April 2004 at 2:09pm

So what'll be next. The MySQL or the asp.net version?]]> Sat, 17 Apr 2004 14:09:06 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54333.html#54333 <![CDATA[Web Wiz Forums 7.7a released : Again, correct me if I&#039;m...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54329.html#54329 Author: ljamal
Subject: 9513
Posted: 17 April 2004 at 1:19pm

Again, correct me if I'm wrong, but ...
With dates, you are always added the current date/time to the database, should you not be using the native databases time functions? In the case where there is a difference between forum and database time, you could use the native date function as well as the native dateAdd function for the database and cirumvent all database date problems.

Never been a fan of ADO updates and inserts. I prefer using the .execute method or stored procedures as it is faster.]]> Sat, 17 Apr 2004 13:19:18 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54329.html#54329 <![CDATA[Web Wiz Forums 7.7a released : It&#039;s not just the paging,...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54326.html#54326 Author: WebWiz-Bruce
Subject: 9513
Posted: 17 April 2004 at 1:09pm

It's not just the paging, but ADO is often used in the code for thingslike updating the database, particully when dates are involved as ithas been found that using an SQL update statement often leads to serverand database incompatibilty problems with things like dats and times.With ADO handling this less problems occur.

Currently there is allot of code that would not run with the myODBSdriver and would require that nearly all files be re-written to workwith mySQL.

Hopefully a better myODBC driver will become available, but as Ihaven't seen a new driver in over a year my guess is that there willnever be one that is fully compatiable with ADO.
]]> Sat, 17 Apr 2004 13:09:15 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54326.html#54326 <![CDATA[Web Wiz Forums 7.7a released : Why? Ideally, for paging you...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54325.html#54325 Author: ljamal
Subject: 9513
Posted: 17 April 2004 at 12:59pm

Why?
Ideally, for paging you want to use the most effcient manner. For MSSQL, that would be allowing the database to handle paging via a stored procedures.
Otherwise, that would be disconnected recordsets and arrays.
Currently, you are using ADO recordset paging and ADO recordset paging is not the most efficient manner of paging. It would be far better to use arrays to disconnect the recordset and "page" through the arrays. This method is ADO independent and would work for all databases.

Futhermore, using this method and some clever programming, you could utitilize MSSQL stored procedures for paging without re-writing the paging code for other databases AND make the forum that much more efficient with SQL Server.]]> Sat, 17 Apr 2004 12:59:20 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54325.html#54325 <![CDATA[Web Wiz Forums 7.7a released : I think it will have to wait till...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54320.html#54320 Author: WebWiz-Bruce
Subject: 9513
Posted: 17 April 2004 at 12:45pm

I think it will have to wait till a decent myODBC driver is released that fully supports ADO and recordset paging.]]> Sat, 17 Apr 2004 12:45:17 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54320.html#54320 <![CDATA[Web Wiz Forums 7.7a released : Will we need to wait until mySQL...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54253.html#54253 Author: JohnKn
Subject: 9513
Posted: 16 April 2004 at 6:11pm

Will we need to wait until mySQL 4.1 is released for the forum? Istarted trying to modify ver 7.6 to use mySQL but the lack of supportfor sub queries in mySQL 4.0 stalled that effort.]]> Fri, 16 Apr 2004 18:11:36 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post54253.html#54253 <![CDATA[Web Wiz Forums 7.7a released : I would like to know if u need...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post52323.html#52323 Author: iD.JenKen
Subject: 9513
Posted: 11 February 2004 at 1:49pm

I would like to know if u need help for u MYSQL version coz I need its . And I will give u some money . gl and really very good job man .

Dont hesitate to contact me @ jenkenzool@msn.com



Edited by iD.JenKen]]> Wed, 11 Feb 2004 13:49:42 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post52323.html#52323 <![CDATA[Web Wiz Forums 7.7a released : -boRg- wrote:No, I plan on...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post52136.html#52136 Author: zamalek
Subject: 9513
Posted: 10 February 2004 at 4:53pm

Originally posted by -boRg- -boRg- wrote:

No, I plan on a mySQL version.

That will be a really great idea and I'm waitng for it on a heated serface.

]]> Tue, 10 Feb 2004 16:53:01 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post52136.html#52136 <![CDATA[Web Wiz Forums 7.7a released : -boRg- wrote:Poeple shouldn&#039;t...]]> https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post51682.html#51682 Author: maddkat
Subject: 9513
Posted: 08 February 2004 at 5:08pm

Originally posted by -boRg- -boRg- wrote:

Poeple shouldn't wonder if they shopuld upgrade, it's a cse of you should always be running the latest version if you don't want your forum to be secure as new releases usually follow after security fixes.

If you want your forum to be secure from hackers you should always upgrade to the latest version!!

I agree with borg!!!!!
Maybe everyone should think about makeing the mod's standalone.
Meaning they could be droped right in to the new wwf with little changes. This will not work for every mod but most mod's should be
independent from wwf. Should maybe only rely on common.asp the language files. However Im still running wwf 7.1 untill I finnish some mod's on my portal, then I plan to upgrade to 7.7a
No matter what I tihnk the new wwf 7.7 is alot faster!!!!!!
great work borg.

]]> Sun, 08 Feb 2004 17:08:57 +0000 https://forums.webwiz.net/web-wiz-forums-7-7a-released_topic9513_post51682.html#51682