close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Registration Page

Thread began 2/03/2010 3:43 pm by shesters381675 | Last modified 2/08/2010 1:18 pm by Jimmy Wu | 1688 views | 11 replies |

shesters381675

Registration Page

[Microsoft][ODBC Microsoft Access Driver] The field 'UserNames.UserName' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

I keep getting the above message. When I try to create a registration from the registration page, I enter in a username and password and then hit submit. Thiat error is returned.

Also, I created a username and password in the database manually, and if I try to log on with it I get this message, which I had one time before but can't remember what we did to fix it...

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'UserName = email address

Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

please compress your security assist files into a zip archive and attach it to your reply so I can examine the code.

Sign in to reply to this post

shesters381675

Files

Here are the files you requested.

Thanks.

Attached Files
Webassit.zip
Sign in to reply to this post

Jason ByrnesWebAssist

There are a couple of probelms I can see:
1) The Insert record server behavior on the registration page is only set to store a value in the password column, it is not set to store anything in the username column


I think the cause for this is that you have selected the UserName column as the primary key column.


your table should have the following column at minimum:

UserID - Primary Key/Auto Number
UserName - text
userPassword - Text


when running the wizard, the UserID column should eb selected as the key column.



2) Password should be avoidde3d as a column name, it is a reserved word by the ODBC driver:
321266

Sign in to reply to this post

shesters381675

Great, I changed my database and was able to register the user. However, I seem to still be experiencing some sort of type problem. Here is the error I recieved. (Is it possible the helper file is not updated? I re-ran the wizard...)

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/WA_SecurityAssist/Helper_VB.asp, line 19


Here is the code it is referencing:

Dim idx
For idx=0 To UBound(WA_Auth_Parameter.Item("columns"))
If idx <> 0 Then
WA_Auth_loginSQL = WA_Auth_loginSQL & " AND "
End If
WA_Auth_loginSQL = WA_Auth_loginSQL & WA_Auth_Parameter.Item("columns")(idx) & " = ? "
WA_Auth_login_cmd.Parameters.Append(WA_Auth_login_cmd.CreateParameter("param"&idx, WA_Auth_Parameter.Item("columnTypes")(idx), 1, WA_Auth_Parameter.Item("columnSizes")(idx), WA_Auth_Parameter.Item("columnValues")(idx)))
Next

Sign in to reply to this post

Jason ByrnesWebAssist

please send a copy of your currant login page.

Sign in to reply to this post

shesters381675

Login Page

Here is the Login Page.

Sign in to reply to this post

Jason ByrnesWebAssist

there was no attachment to your last reply.

Sign in to reply to this post

shesters381675

Login Page

Trying again.

Thanks.

Attached Files
UserNames_LogIn.zip
Sign in to reply to this post

Jason ByrnesWebAssist

The Authenticate User server behavior is set to use tyhe UserID column as the username column.


When running the security Assist wizard, you need to make sure the correct columns are chosen.

On the First Step of the wizard, make sure to select the UserID column as the Key Column.


On the third step, you will want to set the Username column as the unique column.


On the fifth step, make sure to select the Correct columns for the username and password column.


On the sixth step, you will need to select the correct columns for the email to address, the user name and the password as well.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...