Author |
Topic |
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 13 July 2001 : 18:48:17
|
Hi, After implementing Huw´s Member Profile (definable fields) Mod, I receive this message after answering "yes" in the pop-up window that follows the yes-answer: ====== Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'my_Conn.execute'
/forum/pop_admin_table.asp, line 16 ============== What shall I do??? Cheers / Tomas
!-Keep distance in traffic-! www.whiplash.se www.whiplash.pp.se |
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 13 July 2001 : 20:41:58
|
Change this line(16) in pop_admin_table.asp: my_Conn.Execute= "INSERT INTO " & strTablePrefix & "USERFIELDS (USR_LABEL,USR_FIELDTYPE,USR_SHORTNAME) Values ('NewLabel','S','User_" & usrNum & "')"
to
my_Conn.Execute("INSERT INTO " & strTablePrefix & "USERFIELDS (USR_LABEL,USR_FIELDTYPE,USR_SHORTNAME) Values ('NewLabel','S','User_" & usrNum & "')")
or just remove the =
@tomic
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 14 July 2001 : 02:07:27
|
Thank's @tomic! It worked perfect.
I found a new problem with the mods. After checking the box to enable user fields and clicking set, the confirm text appear, but after returning to the User Fields Configuration, the check box is empty. Should it be empty or...? Is it just to continue or is there something missing? Cheers / Tomas
!-Keep distance in traffic-! www.whiplash.se www.whiplash.pp.se
Edited by - tomasalsbro on 14 July 2001 05:13:11 |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 14 July 2001 : 02:47:36
|
I can't help you there, after I fixed that it crashed the server so many times i gave up on this particular mod and just decided to edit the database.
@tomic
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 14 July 2001 : 02:48:23
|
I can't help you there, after I fixed that it crashed the server so many times i gave up on this particular mod and just decided to edit the database.
@tomic
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 14 July 2001 : 03:31:26
|
quote:
I can't help you there, after I fixed that it crashed the server so many times i gave up on this particular mod and just decided to edit the database.
@tomic
Ahh - so you hade the same problem or what to say? I had no problems with the server at all - but I haven't looked at the effects on the databas.
I'll try to reach Huw and see what his opinion is. By the way - thank's so far @tomic! Cheers / Tomas
!-Keep distance in traffic-! www.whiplash.se www.whiplash.pp.se |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 15 July 2001 : 04:55:27
|
Hi, Huw helpted me solve the problem. He wrote: Look to see if you have a file called mod_config or something similar, check that any variables relating to the userfields mod are uncommented. My file was: mod_config.asp
He's suggestion solved my problem with the check box. Cheers / Tomas
!-Keep distance in traffic-! www.whiplash.se www.whiplash.pp.se |
|
|
|
Topic |
|