DaniWeb Forum Index > Web Development > ASP

ASP RSS

Duplicating Ranking System

Please support our ASP advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Jun 2009

Posts: 1

Reputation: skb0415 is an unknown quantity at this point

Solved Threads: 0

skb0415

Offline

Newbie Poster

Duplicating Ranking System

Jun 15th, 2009

I have been struggling over this for about a week now. I am trying to duplicate a ranking system for a client so that it can be accessed privately and players can have a different rating from publicly. I have added new field to encompass my new information. Everything works out fine until I want to UPDATE the information and I then get this error:

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/administration/scouting_update_ranktestpriv.asp, line 30

When I go to look at this line this is the written code

Help with Code Tags

(Toggle Plain Text)

elseIf msrankpriv <> "0" Then
	sSQL = "UPDATE memberSports SET msrankpriv = " & msrankpriv & " WHERE msMember = " & memberId
	Line 30---->objConn.Execute sSQL
	sSQL = "UPDATE memberSports SET mscheckspriv = " & mscheckspriv & " WHERE msMember = " & memberId

Can anyone please help me identify my problem. I think it is simple but I cannot figure it out

•

Join Date: Jun 2009

Posts: 18

Reputation: jsvanc is an unknown quantity at this point

Solved Threads: 1

jsvanc

Offline

Newbie Poster

Re: Duplicating Ranking System

Jun 29th, 2009

•

Originally Posted by skb0415

Help with Code Tags

(Toggle Plain Text)
elseIf msrankpriv <> "0" Then
	sSQL = "UPDATE memberSports SET msrankpriv = " & msrankpriv & " WHERE msMember = " & memberId
	Line 30---->objConn.Execute sSQL
	sSQL = "UPDATE memberSports SET mscheckspriv = " & mscheckspriv & " WHERE msMember = " & memberId
elseIf msrankpriv <> "0" Then sSQL = "UPDATE memberSports SET msrankpriv = " & msrankpriv & " WHERE msMember = " & memberId Line 30---->objConn.Execute sSQL sSQL = "UPDATE memberSports SET mscheckspriv = " & mscheckspriv & " WHERE msMember = " & memberId

Try this:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
elseIf msrankpriv <> "0" Then
	sSQL = "UPDATE memberSports SET msrankpriv = '" & msrankpriv & "' WHERE msMember = '" & memberId & "'"
	objConn.Execute sSQL
	sSQL = "UPDATE memberSports SET mscheckspriv = '" & mscheckspriv & "' WHERE msMember = '" & memberId & "'"
elseIf msrankpriv <> "0" Then
	sSQL = "UPDATE memberSports SET msrankpriv = '" & msrankpriv & "' WHERE msMember = '" & memberId & "'"
	objConn.Execute sSQL
	sSQL = "UPDATE memberSports SET mscheckspriv = '" & mscheckspriv & "' WHERE msMember = '" & memberId & "'"