 |  |  |  |  |  |  |  |
Duplicating Ranking System
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
Can anyone please help me identify my problem. I think it is simple but I cannot figure it out
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
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 = " & memberIdCan anyone please help me identify my problem. I think it is simple but I cannot figure it out
•
•
•
•
Originally Posted by skb0415 
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)
Let me know if this works for you.
Hit any user to continue......
|
Similar Threads
- website ranking (Search Engine Optimization)
- alexa ranking (Search Engine Optimization)
- Ranking Array Failure? (C)
- Forum Rank Problem (DaniWeb Community Feedback)
- Forum software? (Social Media and Online Communities)
- Daniweb User Titles (DaniWeb Community Feedback)
- Senior Techie Qualification (DaniWeb Community Feedback)
- Non-google rankings (Search Engine Optimization)
- what are good post-intervals for ranks (Social Media and Online Communities)
- Rank help (HTML and CSS)
Other Threads in the ASP Forum
- Previous Thread: Need help manager page
- Next Thread: Constructing an A href link in CDO
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest ASP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection calendar changeable connection current database databaseconnection diagnostics dreamweaver excel fso html iis microsoft msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption server single specfic sqlserver sqlserverconnection toolkit web webserver windows7
