XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / How to covert for MSSQL?
Register
1
replicator
How to covert for MSSQL?

  • 2006/9/12 4:45

  • replicator

  • Just popping in

  • Posts: 8

  • Since: 2006/9/12


Ok a few question, i wanted to install this on my local machine, but I cant get it to install

It says, install path my physical path is I:/inetpub/wwwroot

just wanted to make sure thats what i put in there

also, i have mssql as a server, how do i get it to work with that?

Thanks again Everyone
2
McNaz
Re: How to covert for MSSQL?

  • 2006/9/12 7:45

  • McNaz

  • Just can't stay away

  • Posts: 574

  • Since: 2003/4/21


Xoops currently works under mySQL only.

You can try to get it to work under MSSQL buy writing a MSSQL database class in Xoops/classes/database.
3
replicator
Re: How to covert for MSSQL?

  • 2006/9/12 12:00

  • replicator

  • Just popping in

  • Posts: 8

  • Since: 2006/9/12


Do you knwo if anyone else has done this?
I have no idea where to start if i did that.
4
Dave_L
Re: How to covert for MSSQL?

  • 2006/9/12 13:22

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


I've never seen anyone post about doing it successfully.

Maybe you can be the first.
5
McNaz
Re: How to covert for MSSQL?

  • 2006/9/12 13:50

  • McNaz

  • Just can't stay away

  • Posts: 574

  • Since: 2003/4/21


This might be trickier to do than you might suspect as there are specific areas in XOOPS that are geared towards mySQL's SQL syntax, specifically in regards to the Criteria and CriteriaCompo classes that generate SQL LIMIT statements that are specific to mySQL only.

In other words, even if you manage to write a database driver for MSSQL (not difficult on its own), you may find that this is still not sufficient.

Sorry for the bad news.

Cheers.
6
replicator
Re: How to covert for MSSQL?

  • 2006/9/13 14:11

  • replicator

  • Just popping in

  • Posts: 8

  • Since: 2006/9/12


McNaz

Could you help me write a mssql class moduel just like the mysql.php one?

I will try to fix the rest of the stuff in the DB. If i can get it to connect to the DB, and atleast come up.

Then i will work on the rest, and post a maybe a turtorial here on how to convert. :)

Thanks again for your help.
7
McNaz
Re: How to covert for MSSQL?

  • 2006/9/13 14:49

  • McNaz

  • Just can't stay away

  • Posts: 574

  • Since: 2003/4/21


Hi there.

Quote:
Could you help me write a mssql class moduel just like the mysql.php one?


If only it were that simple. This will not be sufficient as XOOPS still generates incorrect SQL statements (mainly due to the Criteria core class) that makes it incompatible with MSSQL unless this is fixed as well. This means hacking the core which is never a good idea.

Also, I am under a heavy load of work from paying clients and just cannot volunteer any time to look at this.

Hopefully someone else will be able to help here.

Cheers.
8
davidl2
Re: How to covert for MSSQL?

  • 2006/9/13 15:07

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Seriously, it would possibly be easier to get MySQL running in one form or another on your system - then to get this work done... as you'd be looking at a substantial core re-write.

And unless it was for a very heavily paid contract - I can't see people doing this.
9
replicator
Re: How to covert for MSSQL?

  • 2006/9/13 15:34

  • replicator

  • Just popping in

  • Posts: 8

  • Since: 2006/9/12


THanks for all the comments.

I found this article online, about the LIMIT statment.

Could you explain a littmore about what that does? and why it cant be changed?

Here is info i found:

MSSQL Supports both standards-based approaches.

MSSQL 2000 didn't support ROW_NUMBER(). Instead, a MSSQL 2000-specific syntax was needed:
SELECT TOP n columns
FROM tablename
ORDER BY key ASC

Documentation
MySQL Doesn't support the standard. Alternative solution:

SELECT columns
FROM tablename
ORDER BY key ASC
LIMIT n

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

390 user(s) are online (301 user(s) are browsing Support Forums)

Members: 0

Guests: 390

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits