| Author |
 Topic  |
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
 Posted - 18 April 2001 : 02:04:08
|
Doh, make that 1 down 2 to go :(
Microsoft OLE DB Provider for ODBC Drivers error '80020009'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/forums/default.asp, line 0
|
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 April 2001 : 09:18:37
|
hmm, the first error i posted I get when i try to edit any topic now (i can edit replys ok) so it looks like its a similar problem to the first one you solved for me richard. I just still for the life of me can't see where the problem in the construction of the query is (assuming that is the problem).
Second error I posted I get when I switch on feature poll and refresh default.asp
Cheers.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 April 2001 : 11:41:44
|
I would guess it has something to do with the sql statement being built. Since I can't/couldn't test this on an sql server, didn't know there would be a problem with it until someone tried it.
I will update the mod with the changes if Rich can find out the bugs with the it. 
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 April 2001 : 11:56:57
|
I'm guessing thats it too. Although im still scrathing my head as to why the changes Richard suggested before worked :) Query seems to produce the same result set (although I was so tired when I was checking it I may have missed something).
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 18 April 2001 : 13:32:56
|
I don't know why, but the poll code does funny things when I save it in interdev. Some of the "'s turn into " and the forum colors end up not working until I go find the spot and fix it. It's happened 3 times now and always at the same place. Has this happened to anyone else?
@tomic
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 April 2001 : 13:59:32
|
quote:
I would guess it has something to do with the sql statement being built. Since I can't/couldn't test this on an sql server, didn't know there would be a problem with it until someone tried it.
I will update the mod with the changes if Rich can find out the bugs with the it.
The error in question is normally caused when you are retreiving memo fields from a db ie T_MESSAGE they should be made the last fields in the select statement.
so T_MESSAGE,T_DATE would be wrong
|
|
|
|
Gribbles
Starting Member
United Kingdom
7 Posts |
Posted - 18 April 2001 : 14:07:08
|
Has anyone had a problem with a poll topic not displaying page counts correctly?
I have one that has definately gone over onto 2 pages, but only displays the first page with no page links at the top or bottom..
Any ideas?
Edited by - gribbles on 18 April 2001 14:07:47 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 April 2001 : 17:52:52
|
quote:
The error in question is normally caused when you are retreiving memo fields from a db ie T_MESSAGE they should be made the last fields in the select statement.
so T_MESSAGE,T_DATE would be wrong
Aah. Ok, so T_MESSAGE should be the last field in the SELECT statements then. Didn't know that. Learn something knew everyday.
Will update the mod with these fixes.
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 April 2001 : 18:01:42
|
Thanks for the bit of information Huw, its certainly something I had never come across before. Started going through chagining the order of some of the columns on the select statement now and things are starting to work better for me
Thanks again
|
|
|
|
Mang
Starting Member
16 Posts |
Posted - 20 April 2001 : 11:42:47
|
How do you implement this mod if my default.asp etc is already heavily modified? I cannot just replace them else I'll lose several other configs and mods.
thanks!
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 April 2001 : 12:12:40
|
Just Copy and paste the code into your forum files. Taken from the readme:
"All added codes are clearly commented in each file.
Just do a search for "Poll Mod" and you will find the codes that have been added."
|
|
|
|
Mang
Starting Member
16 Posts |
Posted - 20 April 2001 : 14:14:47
|
Thanks, I obviously missed that part
|
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 23 April 2001 : 03:19:06
|
quote:
what will happen if i change radio button to check box? is it only make the result more than 100%, which is ok, or won't do at all?
I'd like to see a choice between the two when setting up a poll.
nobody's interested in this?
I want to have a choice between multi choices and single choice. e.g.
poll
which one you have used
a
b
c
d
(multi choice)
poll 2
which one you like the best
a
b
c
d
single choice
I think this is essencial for a poll.
I need a selection of sig/mul when setting up the poll, and if multi is selected, the radio button turn to be checkbox.
|
|
|
|
Morpheus73
Average Member
Denmark
597 Posts |
Posted - 23 April 2001 : 04:03:11
|
quote:
quote:
what will happen if i change radio button to check box? is it only make the result more than 100%, which is ok, or won't do at all?
I'd like to see a choice between the two when setting up a poll.
nobody's interested in this?
I want to have a choice between multi choices and single choice. e.g.
poll
which one you have used
a
b
c
d
(multi choice)
poll 2
which one you like the best
a
b
c
d
single choice
I think this is essencial for a poll.
I need a selection of sig/mul when setting up the poll, and if multi is selected, the radio button turn to be checkbox.
I think maybe we are duscussing another mod here....a mod that I need too...a Snitz Survey mod, - an extended version with both single/multiple choise polls and fill in text areas, all collected in the database with an admin interface.
mph73
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 April 2001 : 11:28:46
|
Mod has been updated with bug fixes and also included some graphics. See the first post in this topic for more info.
|
|
|
|
Topic |
|
Topic Locked
