| Author |
 Topic  |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
 Posted - 05 December 2000 : 20:49:34
|
HuwR, why haven't you posted that before... <i>(I know the answer, just joking...)</i><img src=icon_smile.gif border=0 align=middle>
Would solve alot of my problems, I don't know why SQL statements work on some hosts and not on others. I have personally tested that pmdbsetup.asp on Access 2000, Access97, MS SQL and MySQL and it's worked on all four for me, but so many people have problems with it, that I have been looking for other ways (such as the FORUM_PM.mdb that I posted so that you can just import just the table into an Access database). It's been very frustrating.
Thanks for the excellent, and much needed, tool.! <img src=icon_smile_cool.gif border=0 align=middle>
Edited by - Richard Kinser on 05 December 2000 20:58:30 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 05 December 2000 : 20:52:26
|
I only remembered about it today, so I finished it off. Hopefully it should work for access and SQL, I have tested it for both, don't know about MySQL, I expect some of it won't, but the error messages should be useful.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 05 December 2000 : 20:53:44
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Thanks HuwR,
Great script, Question: does the
who's on line needs the global.asa and
does it required server variables?
Wedont
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Not the one I used, it uses cookies and a table
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 05 December 2000 : 20:57:29
|
When you look at the lengthof topics like this, it's no wonder people want a seperate forum which just contains the code to download plus instructions.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2000 : 21:00:03
|
| I agree. It can get quite confusing. Especially when we are talking about different versions in the same thread. |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 05 December 2000 : 21:03:06
|
On a different note, to confuse the thread even more, I was thinking of trying to make the dbsetup a sort of generic affair musch like the mod commander, whereby you could write a psuedo script file which it used to generate the SQL.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2000 : 21:07:55
|
| I'd use it, it's definitely something that is needed. |
|
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 05 December 2000 : 21:16:59
|
Did further testing,
The outbox (eventhough enabled in preference)does not show any sent messages (no error displayed)
Probably a coockie thing, the sent messages
end up in a different user outbox.
Will get back on it later and post results.
Wedont
Edited by - wedont on 05 December 2000 21:29:43 |
|
|
|
infinity
New Member
New Zealand
90 Posts |
Posted - 05 December 2000 : 22:31:06
|
Will try posting this again... either I have lost the answer amoung all the messages in this thread now or no one managed to assist. I still have this problem with replying to messages... others may have had it and the answer may have been provided but I have been away for a few weeks and completely lost track of this topic etc... help or pointing me in the right direction would be appreciated.
-------- My original message ------
I have the PM mod installed... and it works fine in most regards as far as my testing has currently covered... except one thing.
If I reply to a message the message is posted okay (as in the person gets it) but this error comes up after sending it...
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'rsName'
/privatesend_info.asp, line 278
Line 278 is:
277- if strEmail = "1" then
278- if rsName("M_PMEMAIL") = "1" then
279- DoReplyEmail Request.Form("sendto")
280- end if
I checked the DB to make sure M_PMEMAIL exists and it does. Its value for all users (only 4 of us) is "0".
Any ideas why this has happened?
Thanks,
Infinity
Life is but a dream... and that dream is Here and Now. Therefore, Be here Now. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 December 2000 : 22:49:13
|
Try changing this:
278- if rsName("M_PMEMAIL") = "1" then
to this:
278- if rsName("M_PMEMAIL") = 1 then
|
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 06 December 2000 : 05:18:58
|
I want to hide the PM BOX for guest login... so the question is:
How can I check if is a guest login? SAY if request.cookiess("sumthing")=sumthing.... then login is guest hehehe
Is there any mod that let you search for all post from a user (on the search page or event though on member profile)
I had to edit several pages that called up a members_profile.asp page... what is it? I just have a pop_profile.asp page!
Thanx a lot
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 06 December 2000 : 05:26:39
|
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'rsName'
/forum/privatesend_info.asp, line 278
When you reply to sum1. The message arrives but you get this error.
I tryed to correct
if rsName("M_PMEMAIL") = "1" then
TO <font color=red>if rsName("M_PMEMAIL") = 1 then</font id=red>
but I get the same error...
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 06 December 2000 : 05:40:37
|
I tryed this too
if cstr(rsName("M_PMEMAIL")) = "1" then
but alway get Type mismatch
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
infinity
New Member
New Zealand
90 Posts |
Posted - 06 December 2000 : 07:08:41
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Try changing this:
278- if rsName("M_PMEMAIL") = "1" then
to this:
278- if rsName("M_PMEMAIL") = 1 then
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Life is but a dream... and that dream is Here and Now. Therefore, Be here Now. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Topic |
|
Topic Locked
