This topic contains 3 replies, has 3 voices, and was last updated by 
-
Posts
-
Voting for the WGA Board of Directors has begun! Click here to go to the elections page and cast your votes for your favorite candidates.
Some general notes about this phase of the Board of Directors election process:
- Since there are 4 open Board positions, members may vote for up to 4 of the candidates.
- If you try to vote for more than 4 candidates, all your votes will be thrown out and you’ll be given a chance to vote again.
- Once you vote, you cannot vote again. Therefore, if you vote for fewer than 4 candidates, you can’t come back and vote for more. Also, you can’t change your votes (so get them right the first time!).
- All of the candidates have provided links to external sites (personal web sites, geocaching.com profiles, etc.) where you can get more information about them. Simply click on the name of a candidate on the elections page to launch a new browser window where the link provided will be displayed. (Note for geocaching.com profiles you’ll be asked to log in if you aren’t already…)
- Voting will end at exactly 11:59:59pm on May 14, 2003. The new Board members will be announced at the WGA meeting to be held during the 2003 WGA Spring Geo-Campout (May 17th).
If you have any questions about this phase of the Board of Directors election process, feel free to post them here.
Ok, I’m trying to cast my vote, but I’m getting an error message. Am I using the wrong password? The wrong name? Heck, I dont’ know! Any ideas?
Database error: Invalid SQL: SELECT * FROM member WHERE (nick = ‘Geo-Johnson’s’)
MySQL Error: 1064 (You have an error in your SQL syntax near ‘s’)’ at line 1)
Session halted.quote:
Originally posted by Geo-Johnson’s:
Database error: Invalid SQL: SELECT * FROM member WHERE (nick = ‘Geo-Johnson’s’)
MySQL Error: 1064 (You have an error in your SQL syntax near ‘s’)’ at line 1)
Session halted.Looks like a missing addslashes() to escape out the “‘” in Johnson’s. MySQL thinks the ‘ before the s is the end of your nick, then doesn’t know what to do with the s’ afterwards.
I’ve become intimately familiar with this problem the past couple of days when someone named “O’Brien” logged into the web-based work scheduling system I’m writing at work. It was alternately erroring out or displaying his name as O\\\’Brien. Ick.
quote:
Originally posted by Cheesehead Dave:
Looks like a missing addslashes() to escape out the “‘” in Johnson’s. MySQL thinks the ‘ before the s is the end of your nick, then doesn’t know what to do with the s’ afterwards.
Exactly right Cheesehead Dave. (Why aren’t you working on this instead of me. ) Typically I autogenerate all of my SQL queries and autofilter all of the stuff I get out of MySQL so I don’t have to deal with the addslashes()/stripslashes() business. Not so with this particular SELECT query, which lead to the bug.
Geo-Johnson’s… the problem has been corrected so please try voting again. And if any one else has problems voting, please post the problem here or let me know via email so I can get it corrected ASAP.
You must be logged in to reply to this topic.