DeveloperBarn

Centurion · #21 July 14th, 2009, 07:17 AM

Quote:

Originally Posted by micky

koi baat nahi, chalne lagegi, chinta mat kar

You need to check if your recordset has a record or not, before you can read its value like rs("password").
So add such code

Code:

If NOT rs.BOF and NOT rs.EOF
 If oldpassword = "" Or newpassword = "" Then
  Response.Write "Make sure password is valid and fill all the fields please!"
 ElseIf rs("password") <> oldpassword Then
  Response.Write "Wrong password inserted!"
 ElseIf newpassword <> confirmpassword Then
  Response.Write "Confirm password and new password are not the same!"
 ElseIf oldpassword = newpassword Then
  Response.Write "Old password and new password are the same!"
 Else
    
    sql = "UPDATE mem SET password = '" & newpassword & "' WHERE " _
  & "username = '" & Request.Form("username") & "'"

  conn.Execute(sql)
  Response.Write "Your Password has been changed!"
 End If
 End If
rs.Close
 Set rs = Nothing
 conn.Close
 Set conn = Nothing
'End If

you mean?

Code:

If NOT rs.BOF and NOT rs.EOF Then

i have done this and no errors come up but it doesnt seem to change the password.. khalas khatum hoi gya!!!

micky · #22 July 14th, 2009, 07:55 AM

You need to learn to debug

Debug and see if its going in IF loop or not and if going, then in which IF loop does it go!

Centurion · #23 July 14th, 2009, 08:08 AM

Quote:

Originally Posted by micky

You need to learn to debug

Debug and see if its going in IF loop or not and if going, then in which IF loop does it go!

it checks to see if its EOF and its not so then it goes through.. then crashes at password. thats as far as i can debug.. what else can i do?

micky · #24 July 14th, 2009, 08:18 AM

after the eof line, print the password and see what it brings from database.

Centurion · #25 July 14th, 2009, 08:22 AM

Quote:

Originally Posted by micky

after the eof line, print the password and see what it brings from database.

as i sed before it just goes to the end if and displays no error..

If NOT rs.BOF and NOT rs.EOF Then
response.write rs("password")
response.end

micky · #26 July 14th, 2009, 08:27 AM

If its not going inside IF loop, then probably you dont have such record in database.

Centurion · #27 July 14th, 2009, 08:30 AM

Quote:

Originally Posted by micky

If its not going inside IF loop, then probably you dont have such record in database.

i do have those records!!

micky · #28 July 14th, 2009, 08:34 AM

Quote:

Originally Posted by wbva

i do have those records!!

Ok, response.write your query and copy that query in your database's query analyzer and see what does it returns!!

As i said, its all debugging now.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Server Integration Services	guddu	Microsoft SQL Server	1	April 24th, 2009 07:08 AM
SQL Server CREATE TABLE..LIKE	Wolffy	SQL Code Samples	2	March 12th, 2009 04:51 PM
SQL Server 2008	stephenhy88	Microsoft SQL Server	7	August 13th, 2008 01:55 AM
SQL Server Views	theChris	Microsoft SQL Server	3	March 23rd, 2008 07:35 PM

DeveloperBarn

mdb to SQL SERVER

mdb to SQL SERVER

Similar Threads