| Author |
 Topic  |
|
|
ugur
Starting Member
Turkey
3 Posts |
 Posted - 19 June 2001 : 11:31:06
|
Hello,
I am running snitz on oracle , i am worked very hard last two days for this...
At the end it is working (may be with a lot of bugs but it is working )..
I want to share my knowledge with you ,
if you can give me an email address or a link for upload i can send you my export file from Oracle Database ,and some tricks may be,
i hope official version on Oracle will released as soon as possible,
also i want to know when this release will be published,
sincerely
Ugur
Edited by - ugur on 19 June 2001 11:48:46
Edited by - ugur on 20 June 2001 06:56:05 |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 19 June 2001 : 11:58:39
|
Could you send the file to me or mail me a link to a zipfile for download ?
Thanks you 
Pierre
Join the Snitz WebRing |
 |
|
|
ugur
Starting Member
Turkey
3 Posts |
Posted - 20 June 2001 : 06:55:41
|
www.linkplus.com.tr/db1.dmp
version 8.1.6
user db1
and a ORACLE SQL corresponds LIMIT clause in MYSQL in line 243 of topic.asp
'## Forum_SQL - Get all topicsFrom DB
strSql= "SELECT M_NAME,M_ICQ,M_YAHOO,M_AIM,M_TITLE,MEMBER_ID,M_Homepage,M_LEVEL,"
strSql= strSql & "M_POSTS,M_COUNTRY,REPLY_ID,R_AUTHOR,TOPIC_ID,R_MESSAGE,R_DATE "
strSql = strSql & " FROM (SELECT * FROM " & strMemberTablePrefix & "MEMBERS, " & strTablePrefix & "REPLY "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "REPLY.R_AUTHOR "
strSql = strSql & " AND TOPIC_ID = " & Request.QueryString("TOPIC_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "REPLY.R_DATE" & ") "
strSql = strSql & " WHERE ROWNUM <=" & cint(strPageSize) * mypage
if mypage >1 then
strsql= strSql & " MINUS "
strSql= strSql & "SELECT M_NAME,M_ICQ,M_YAHOO,M_AIM,M_TITLE,MEMBER_ID,M_Homepage,M_LEVEL,"
strSql= strSql & "M_POSTS,M_COUNTRY,REPLY_ID,R_AUTHOR,TOPIC_ID,R_MESSAGE,R_DATE "
strSql = strSql & " FROM (SELECT * FROM " & strMemberTablePrefix & "MEMBERS, " & strTablePrefix & "REPLY "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "REPLY.R_AUTHOR "
strSql = strSql & " AND TOPIC_ID = " & Request.QueryString("TOPIC_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "REPLY.R_DATE" & ") "
strSql = strSql & " WHERE ROWNUM <= "& cint(strPageSize) * (mypage -1)
end if
Edited by - ugur on 20 June 2001 06:56:32 |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 20 June 2001 : 13:26:46
|
I get a server not found error.
But isn't this only the database setup ? That was the easy part, the hard(er) part was to integrate the support into the existing code.
I thought you wanted to share the complete code.
Pierre
Join the Snitz WebRing |
|
|
|
ugur
Starting Member
Turkey
3 Posts |
Posted - 21 June 2001 : 12:09:52
|
you can get my code from www.linkplus.com.tr/forum.zip,
AND FOR ANOTHER PEOPLE WHO WILL DOWNLOAD THE CODE PLEASE DO NOT USE THIS CODES FOR ANY MATTER EXCEPT FOR TEST OR GETTING IDEA PURPOSES,
it has many bugs , it is not completed . For example i must change two more sql statement in asp files that includes "LIMIT clause for mysql" to "ROWNUM for oracle" ,and there will be many other errors about assignments "type mismach" that i haven't resolve yet.
I planning to correct them about two months later before my projects' dead line ,if an official version of Snitz on Oracle won't be released and one more point %50 percent of messages in code translated in Turkish Language.
I hope my work will help for Snitzs' official developers and officail version will be released soon .
If any other question will be asked to me about my work or especially oracle(i am also a support analyst for oracle), i am ready to answer them.
|
|
|
| |
Topic |
|
|
|
Forum Locked
Topic Locked
