navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Can't add field to Spooky Login

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Can't add field to Spooky Login
Page: [1]
 
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

 
Can't add field to Spooky Login - 4/3/2001 20:01:00   
Am trying to add a field to Spooky Login database and am having problems.
I've gone thru the instructions (included w/ Spooky Login) twice and have
not been successful. The error message I get is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/includes/a_system.asp, line 81

I get the error when I try to use the System Setups in Admin and tell the field
isManager to be visible on the registration form. I am using Spooky Login 2.33.

I don't believe my error is in the a_system.asp since I did not edit that file.
I don't really know for sure so please correct me if I'm wrong. But just to be safe,
here is line 81 of a_system.asp:

objRs.fields.item(9).Value = ShowField

Here are the edits I made to the files per the instructions. The field name is
"isManager" and is a text field of size 1. ANd it is added to the end of the
spooky_login97.mdb.

File a_config.asp

...line 90 Dims
Private isManager

...line 99 - 103 Increment Array
Dim arrValInput(31)
Dim arrErrMsg(31)
Dim arrFieldNames
ReDim arrFieldNames(31)
Dim arrMaxLth(31)

...line 108 - 109 Add column name and add new value
CONST strAllFields = "UserID,x_firstname,x_lastname,UserName,x_email,EmailUse,Password,AddDateTime,UpdateDateTime,AccessLevel,Admin,ActiveAccount,AccountExpires,RemoteAddress,LoginCount,x_company, x_address, x_city, x_state, x_zip, x_country, x_phone, x_fax, x_website, x_UserFound,aps_uid,x_RefId,x_trans_id,x_auth_code,u_id,isManager"
CONST strDefShowFields = "1001111111111110000000000000000"

...line 133 Add new column max length
arrMaxLth(31) = 1 ' isManager

...line 151 Add value to "Sub GetExtendedInfo"
isManager = objRs.fields.item(30).value

...line 169 Add value to "Sub SetExtendedInfo"
If isManager <> "" AND isManager <> 0 then objRs.fields.item(30).value = isManager

...line 189 Add value to "Sub ValidateExtendedInfo"
isManager = ValidateInput(Request.Form("isManager"),3,31)

...line 292 Add new text for column name
CONST txtIsManager = "Manager Y or N"


File admin_users.asp

...line 252-254 Add new Display Input
If (Mid(strShowField, 31, 1) = "1") then
Call DoInputRow ("isManager",txtIsManager, "", 1,31,1)
End if


File register.asp

...line 1214-126 Add new Display Input
If (Mid(strShowField, 31, 1) = "1") then
Call DoRegInputRow ("isManager",txtIsManager, isManager, 1,31,1)
End if


File a_users.asp

...line 173 Add new array
isManager = aResults(30,0)

Any help will be greatly appreciated...

Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Can't add field to Spooky Login - 4/3/2001 16:48:00   
Could you check your database design, and make sure that the field length for showfields is "40" and not "30" ?

I extended it in that or the next version to allow for new fields. Yours may still be 30?


(in reply to rdouglass)
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

 
RE: Can't add field to Spooky Login - 4/4/2001 13:21:00   
Thanks! That was it. I also changed the g_required_fields to 40 as well.

Thanks much for the help...


(in reply to rdouglass)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Can't add field to Spooky Login - 4/4/2001 13:36:00   
Cool.
Ive changed that in the latest version 2.34 +

Using a binary code via a text field is a great way to supply a config, and its amazing how fast you can use up each '0' or '1'


(in reply to rdouglass)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Can't add field to Spooky Login
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts