Nasgaweb Homepage
Forum Home Forum Home » Nasgaweb Forums » Database
  New Posts New Posts RSS Feed - Names with apostrophes
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database Old Celt Equipment

Names with apostrophes

 Post Reply Post Reply
McSanta View Drop Down

Joined: 4/12/05
Location: United States
Status: Offline
Points: 1595
Post Options Post Options   Thanks (0) Thanks(0)   Quote McSanta Quote  Post ReplyReply Direct Link To This Post Topic: Names with apostrophes
    Posted: 1/11/13 at 7:56am
It appears that your queries does not handle names with apostrophes -- such as selecting the 2012 All Amatuers database then selecting a thrower like Jon O'Neil results in the following error message: 

Microsoft JET Database Engine

error '80040e14'

Syntax error (missing operator) in query expression 'Year(Games.Gamesstart) = 2012 AND Athletes.Firstname='Jon' AND Athletes.Lastname='O'Neil' ORDER BY Games.Gamesstart;'.

/dbase/resultsathlete3.asp, line 74

Or when you select the person directly from the main menu, the following error is generated

Microsoft VBScript runtime

error '800a0005'

Invalid procedure call or argument: 'Left'

/dbase/resultsathlete3.asp, line 44

my guess and the obvious guess is the SQL is being screwed up by the apostrophe in the throwers name -- In case you did not knwo, I though you should be made aware of this .

Mark McVey

"The work of science is to substitute facts for appearances and demonstrations for impressions." -John Ruskin
Back to Top
Max5684 View Drop Down

Joined: 7/21/14
Location: Springfield, IL
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Max5684 Quote  Post ReplyReply Direct Link To This Post Posted: 7/21/14 at 3:19pm
You are correct. This is a problem with the query string not being properly sanitized before being run against the database. You can get around this by two single quotes ('') - not a double quote (") - in place of the single quote.

I have asked the owner of the database to let me lend a hand with rewriting the back-end and interface but I haven't heard back yet.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.11
Copyright ©2001-2012 Web Wiz Ltd.

This page was generated in 0.047 seconds.