ASP/MYSQL Forum

[devworld]

Anyone know of a ASP scripted forum that can run on MYSQL Database backend? I'm currently trying to reconfigure the ASP-DEV forum to run on MYSQL, but progress is not good

Cheers

[RFH Customer: Jon Freeman]

Guess I could search on Google to see if I can help... but do you have a reason for wanting asp?

[RFH Customer: Jon Freeman]

(one thing with php btw is it can talk to MySQL naitelvy - I'm not clever enough to know what that means performance wise in practice but you don't have to go through ODBC that way)

[Staff: Warren Ashcroft]

(one thing with php btw is it can talk to MySQL naitelvy - I'm not clever enough to know what that means performance wise in practice but you don't have to go through ODBC that way)

So can ASP - when the right connection string is used.

[devworld]

The reason i wanted asp is because I know alot more about ASP than I do about PHP. Therefore it would be easier for me to tweak it to match in with my site.

I fell upon Snitz last night and installed it. I'm going to give a go and see what happens. It is ASP and supports MSSQL, Access and MYSQL so covers my criteria.

If you guys have previously had any problems with Snitz or know a better solution, your comments are very welcome.

Cheers

[RFH Customer: Jon Freeman]

The reason i wanted asp is because I know alot more about ASP than I do about PHP. Therefore it would be easier for me to tweak it to match in with my site.

Hmmm. know that feeling but I think overall I am more comfortable with something I would say is C like - used ASP (VB) becuse it was free and on my Win 2K pro box - later moves towards me now mostly moving onto php came in part from a desire to learn Linux as a home user and the Lamp (Linux/Apache/MySql/php) is quite popular.

I did a conversion once on VB-Acesss to VB MySQL but that is the site now on php and it was some time ago - trying to remember where the problems are - Date on SQL is one I think I hit with MySQL wanting the ISO (?) yyyyy-mm-dd format (a better format to be honest).

[RFH Reseller: Glynn]

I fell upon Snitz last night and installed it. I'm going to give a go and see what happens. It is ASP and supports MSSQL, Access and MYSQL so covers my criteria.

If you guys have previously had any problems with Snitz or know a better solution, your comments are very welcome.

Cheers

I've been running Snitz for a few years without problems although not with MySQL. Have used it with Access and MSSSQL no probs. It's nothing fancy but does the trick!

[RFH Customer: Jon Freeman]

Another difference MYSQL vs Access wise you might enounter is a rows-affected vs rows-returned thing. MySQL distinguishes between the results of an Update, insert, delete which changes data and a Select which only asks. MySQL provides a way round this. eg if you were using myODBC there is a compatibility setting.

Another one probably only Linux (can't try access there on my set up) and maybe OS, not DB when changing things (casued me much grief recently) is case sensitivty when dealing with a table name. SELECT * from song works but SELECT * from Song fails on my set up.

[RFH Reseller: nick]

Another one probably only Linux (can't try access there on my set up) and maybe OS, not DB when changing things (casued me much grief recently) is case sensitivty when dealing with a table name. SELECT * from song works but SELECT * from Song fails on my set up.

The case sensitivity is determined by the underlying OS MySQL is running on, therefore most Unix based systems are case sensitive with their table names, but MySQL on Windows is case-insensitive. I say 'most' Unix based systems, because Mac OS X provides an exception, as it uses a case-insensitive file system meaning case-insensitive table names too.

----
EDIT
Therefore I would add that common sense says always use the same case for things throughout. I just stick with lowercase everything, as it is a safe and easy to remember way to do it. One thing I don't think you can do, even in a case-insensitive environment, is mix the case versions within the same SQL statement.

[RFH Customer: Jon Freeman]

Thanks nick. Did adopt the policy you suggested BTW. Also did that with forms and "GET" on the php side where I had not (my failure) been consistant with asp.