iROSE/mssql help

[flnet]

Hi all

I'm busy making my own cms for iROSE (Arcturus)
But i've a few problems

1: I'm trying to make a ruff-rose like rating page, with this mssql query:

SELECT top 50
			SHO.tblGS_AVATAR.txtACCOUNT,
			SHO.tblGS_AVATAR.txtNAME as char_name,
			seven_ORA.UserInfo.Account,
			seven_ORA.UserInfo.[Right],
			SHO.tblGS_AVATAR.btLEVEL as level,
			SHO.tblGS_AVATAR.intJOB as job
			FROM
			SHO.tblGS_AVATAR
			left Join seven_ORA.UserInfo ON SHO.tblGS_AVATAR.txtACCOUNT = seven_ORA.UserInfo.Account
			WHERE
			seven_ORA.UserInfo.[Right] = '1'
			ORDER BY
			SHO.tblGS_AVATAR.btLEVEL DESC

and I get this "nice" error:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SHO.tblGS_AVATAR'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'seven_ORA.UserInfo'.

How can I fix that?

fixed:

SELECT top 50
			SHO..tblGS_AVATAR.txtACCOUNT,
			SHO..tblGS_AVATAR.txtNAME as char_name,
			seven_ORA..UserInfo.Account,
			seven_ORA..UserInfo.[Right],
			SHO..tblGS_AVATAR.btLEVEL as lvl,
			SHO..tblGS_AVATAR.intJOB as job
			FROM
			SHO..tblGS_AVATAR,
			seven_ORA..UserInfo
			WHERE
            SHO..tblGS_AVATAR.txtACCOUNT = seven_ORA..UserInfo.Account
			COLLATE Latin1_General_CI_AS
			AND
			seven_ORA..UserInfo.[Right] = '1'
			ORDER BY
			SHO..tblGS_AVATAR.btLEVEL DESC

2: My cms is a one file site.
The images are stored in the database.
But now i'm using for that a mysql database, because I don't know how a can make a record that can store information up to 4 gb (longtext in mysql)
Can I do the same with mssql?

[MentaL]

[Shirou]

will this work on mssql ? we need a Website tha work with iRose

[flnet]

I add you on msn, so we can talk about that.