Duplicating Ranking System

Expand Post »

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

(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

Similar Threads

website ranking in Search Engine Optimization
alexa ranking in Search Engine Optimization
Ranking Array Failure? in C
Forum Rank Problem in DaniWeb Community Feedback
Forum software? in Social Media and Online Communities

skb0415

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

Permalink

Jun 29th, 2009

Re: Duplicating Ranking System

Click to Expand / Collapse Quote originally posted by skb0415 ...

(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:

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 & "'"

Let me know if this works for you.

jsvanc

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

18 posts
since Jun 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Need help manager page

Next Thread in ASP Forum Timeline: Constructing an A href link in CDO

DaniWeb Message

Cancel Changes

User Name
Password