Yes
Dim Sql As String = "UPDATE university SET uniqueCode='',password=@password WHERE uniqueCode=@uniqueCode and (strEmail=@strEmail)", conn)
BC30205: End of statement expected after that final bracket.
I will put password between []
Thanks
Thanks jbenson001
I was thinking of password here, sorry:
Link
It is an Access DB that I have, so I would need to replace that SQL, wouldn't I?
I am getting an error on that line:
Dim Sql As String = "UPDATE university SET uniqueCode='',password=@password WHERE uniqueCode=@uniqueCode and...
Hello
I know that 'password' is a reserved word and needs to go in square brackets, as in [password], but where do those square brackets go in something like this, please:
Dim Sql As String = "UPDATE university SET uniqueCode='',password=@password WHERE......
...
Hello Dashley
I haven't tried this out yet (I have had to adapt your code a little to the syntax I was using), but I think I have tidied up the
confusion with Webmaster email and user email), so I now have:
Dim myMessage As New MailMessage
Dim Smtpserver As New SmtpClient
Dim strEmailValue As...
Hello jBenson001
Thank you for your reply.
myMessage looks like this:
Dim myMessage As New MailMessage
Dim Smtpserver As New SmtpClient
Dim strEmailValue As String
Dim Message As String = "yourmessage"
'Request.Form - extract data from form...
Hello
My SMTP code includes:
Dim strEmailValue As String
Dim Message As String = "yourmessage"
'Request.Form - extract data from form field
Dim youremail As String = Request.Form("strEmailValue")
Dim yourmessage As String = Request.Form("your_message")
...
Many thanks for your reply, JRB-Bldr
I take it then that the server automatically creates that link and something like SMTP posts it to the user?
Good idea about looking at one of my own emails that contains a link and then Open the Source of the email.
Thanks again!
Hello
Can I ask about the logic behind a request for a password reset where a user has forgotten his password?
These passwords will eventually be hashed/salted.
The user completes a field requesting his email address. The code checks that he exists in the database. If not, an onscreen error...
Hello
I have a Web page here, but instead of the welcome message greeting the user's email, I have:
strEmailValue is the user's email address (the variable)
strEmail is the email column in my database
strEmailTextBox is the ID of the email form field
What is the reason, please, why I get...
'The remember me code should go in the block that successfully logs in the user - just before the Response.Redirect call'.
That sounds logical now that you point it out. I will do that, and get rid of the second button.
OK, I will subscribe to the ASP.NET room here.
Thanks again
Thanks for getting back to me, Borvik.
One sub relates to a user logging on via a login form so the code will scrutinise the database to check that he exists as a registrant. This code (I am sure there are errors with it as I have not done a login form before) is:
Protected Sub...
Hello
I am getting the following error:
BC30269: 'Protected Sub btnLogin_Click(sender As Object, e As EventArgs) 'has multiple definitions with identical signatures'.
I take it that the error refers to the fact that I use Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As...
The problem was not 'ConnectionString' as such, but the line above it. The error disappeared when I used:
Dim ConnectionString As String = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=|DataDirectory|students.mdb;"
Dim conn As New OleDbConnection(ConnectionString)
That is, I had not...
Hello
I am trying to create a log-in page (MS Access) for the first time, and I am getting this error (among others!):
Compilation Error: BC30469: Reference to a non-shared member requires an object reference.
The error (blue underline) specifically refers to 'ConnectionString'.
Aren't I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.