Author |
Topic |
phynias
New Member
USA
64 Posts |
Posted - 03 October 2000 : 10:51:11
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Phynias, Do you have a cleaned up version of the Poll modification that works with Beta 5 and hence the coming release of 3.1? Thanks,
KenDude was Here! <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
dont see why the release thats out now wouldnt work...
=P http://www.greeneggsnspam.com/newstrax/ |
|
|
ISJX_YICK
New Member
France
68 Posts |
Posted - 07 October 2000 : 21:43:01
|
i think that what he meant was : can you modify the 1st link on the 1st topic on that thread to link to a finally working one or tell that the actual link is ok with all the mod that people ask after on that thread
... may be add a info.txt in the zip to explain what we *mayů have to change to make it match with v3.1
i didn't checked it yet .. so maybe it will yet be that way .in that case :) just laugh at me :) hehe
WOW THAT's NICE !!! |
|
|
ISJX_YICK
New Member
France
68 Posts |
Posted - 07 October 2000 : 21:45:15
|
by the way , is there a way to have a file that create the fields in the database so that we don't have to edit it ourself ? now that i have uploaded it on site, it is under that path that i can access and i need to ask someone to do the job for me if i have to make it with access.
an asp file creating new fields in the table would be really better in all cases and it will be better for error handling ;)
let me know
WOW THAT's NICE !!! |
|
|
John
Junior Member
USA
427 Posts |
Posted - 07 October 2000 : 22:42:08
|
Umm yeah it does
CREATE TABLE whatever ALTER TABLE whatever ADD FIELD something int
or somewhere along those lines
<center><font size=1>Khoor#vqlw}#xvhuv/#wkdq{#iru#uhdglqj#=, Decoder</font id=size1></center> |
|
|
phynias
New Member
USA
64 Posts |
Posted - 08 October 2000 : 00:35:07
|
I added a script to update your snitz database. PLEASE backup your database before hand. I am not responsible if stuff gets hosed.
The scripted adds 2 tables and a field to an existing table. I also changed part of the code. One of the fields I used was a yes/no and I changed it to just an integer.
=P http://www.greeneggsnspam.com/newstrax/ |
|
|
ISJX_YICK
New Member
France
68 Posts |
Posted - 08 October 2000 : 07:58:59
|
thanks :) nice work :) and quick too
that forum really rocks !
btw when i edit my message it seems it makes: edited by .. at ... and date ... if the 1st post was re-edited we'll know that the link has been updated ... i'm not sure while downloading poll that it is an updated one :) ..just to make things easier, remember to add yourself
modified on : and/or added: autodatabase modification support ... etc (i know my ideas sucks :) hehe)
WOW THAT's NICE !!!
Edited by - ISJX_YICK on 08 October 2000 08:02:52 |
|
|
phynias
New Member
USA
64 Posts |
Posted - 08 October 2000 : 13:15:59
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> thanks :) nice work :) and quick too
that forum really rocks !
btw when i edit my message it seems it makes: edited by .. at ... and date ... if the 1st post was re-edited we'll know that the link has been updated ... i'm not sure while downloading poll that it is an updated one :) ..just to make things easier, remember to add yourself
modified on : and/or added: autodatabase modification support ... etc (i know my ideas sucks :) hehe)
WOW THAT's NICE !!!
Edited by - ISJX_YICK on 08 October 2000 08:02:52 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> I couldn't really follow what you where saying. care to explain it again?
=P http://www.greeneggsnspam.com/newstrax/ |
|
|
ISJX_YICK
New Member
France
68 Posts |
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 09 October 2000 : 04:43:37
|
I couldn't get this poll addon to v3.1 final.
1) the dbupdate.asp should say sqlstr="ALTER TABLE FORUM_TOPIC<font color=red>S</font id=red> ADD ispoll INTEGER"
2) Also there where a bunch of errors with the sql statements when I tried past the poll stuff from the readme onto it.
I fixed it so the recordsets accept the sql statements. then I got this perplexing error
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /snitz31/topic.asp, line 546 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> that line contains: <b>rss.Open sql, cn</b>
I commented that out and then got some other errors from the polls function in inc_functions.asp and decided to give up and post the errors here.
This is a cool addon if I can get it work!
- Alan www.calvsa.net
|
|
|
phynias
New Member
USA
64 Posts |
Posted - 09 October 2000 : 10:48:57
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I couldn't get this poll addon to v3.1 final.
1) the dbupdate.asp should say sqlstr="ALTER TABLE FORUM_TOPIC<font color=red>S</font id=red> ADD ispoll INTEGER"
2) Also there where a bunch of errors with the sql statements when I tried past the poll stuff from the readme onto it.
I fixed it so the recordsets accept the sql statements. then I got this perplexing error
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /snitz31/topic.asp, line 546 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> that line contains: <b>rss.Open sql, cn</b>
I commented that out and then got some other errors from the polls function in inc_functions.asp and decided to give up and post the errors here.
This is a cool addon if I can get it work!
- Alan www.calvsa.net
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
What errors where you getting before you changed anything.
=P http://www.greeneggsnspam.com/newstrax/ |
|
|
phynias
New Member
USA
64 Posts |
Posted - 09 October 2000 : 10:50:46
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I couldn't get this poll addon to v3.1 final.
1) the dbupdate.asp should say sqlstr="ALTER TABLE FORUM_TOPIC<font color=red>S</font id=red> ADD ispoll INTEGER"
2) Also there where a bunch of errors with the sql statements when I tried past the poll stuff from the readme onto it.
I fixed it so the recordsets accept the sql statements. then I got this perplexing error
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /snitz31/topic.asp, line 546 <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> that line contains: <b>rss.Open sql, cn</b>
I commented that out and then got some other errors from the polls function in inc_functions.asp and decided to give up and post the errors here.
This is a cool addon if I can get it work!
- Alan www.calvsa.net
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
What errors where you getting before you changed anything. Also I would need the lines in your code since it may not be the same as mine.
=P http://www.greeneggsnspam.com/newstrax/ <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
=P http://www.greeneggsnspam.com/newstrax/ |
|
|
phynias
New Member
USA
64 Posts |
Posted - 09 October 2000 : 10:52:11
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I couldn't get this poll addon to v3.1 final.
1) the dbupdate.asp should say sqlstr="ALTER TABLE FORUM_TOPIC<font color=red>S</font id=red> ADD ispoll INTEGER" <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> FIXED <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> 2) Also there where a bunch of errors with the sql statements when I tried past the poll stuff from the readme onto it. I fixed it so the recordsets accept the sql statements. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
What errors where you getting before you changed anything. Also I would need the lines in your code since it may not be the same as mine.
=P http://www.greeneggsnspam.com/newstrax/
=P http://www.greeneggsnspam.com/newstrax/ |
|
|
phynias
New Member
USA
64 Posts |
Posted - 09 October 2000 : 10:52:41
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I couldn't get this poll addon to v3.1 final.
1) the dbupdate.asp should say sqlstr="ALTER TABLE FORUM_TOPIC<font color=red>S</font id=red> ADD ispoll INTEGER" <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>FIXED
************************************************************************* <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> 2) Also there where a bunch of errors with the sql statements when I tried past the poll stuff from the readme onto it. I fixed it so the recordsets accept the sql statements. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
What errors where you getting before you changed anything. Also I would need the lines in your code since it may not be the same as mine.
Edited by - phynias on 09 October 2000 10:53:47 |
|
|
JK_Bowman
New Member
USA
60 Posts |
|
phynias
New Member
USA
64 Posts |
|
Topic |
|