"Michael Culley" <mculley@NOSPAMoptushome.com.au> wrote in message
news:Oa82KEQcDHA.2308@TK2MSFTNGP12.phx.gbl...
> I presume this is VB. Just do
>
> > " SELECT DivNumber,DivRank,DivAge,DivGender "
> > " FROM FSTPoints WHERE TournamentName = '" &
Replace$(SelectedTournament, "'", "''") & "' AND
> > DivNumber = "
> > & iterate & ";"
>
> --
> Michael Culley
>
>
> "Fox" <fox @ connexions .net> wrote in message
news:eeH8hiPcDHA.2932@tk2msftngp13.phx.gbl...
> > The variable
> > SelectedTournament
> > will sometimes have an apostrophe within it.
> > When it does I get a 500 server error.
> > There have been some suggestions on how to
> > deal with this, such as doubling the single quotes
> > but there is no place to do this. Is there another
> > way to fix this right within the query itself ?
> >
> > " SELECT DivNumber,DivRank,DivAge,DivGender "
> > " FROM FSTPoints WHERE TournamentName = '" & SelectedTournament & "' AND
> > DivNumber = "
> > & iterate & ";"
> >
> >
>
>

> " SELECT DivNumber,DivRank,DivAge,DivGender "
> " FROM FSTPoints WHERE TournamentName = '" & Replace$(SelectedTournament, "'", "''") & "' AND
> DivNumber = "
> & iterate & ";"

"Fox" <fox @ connexions .net> wrote in message news:eeH8hiPcDHA.2932@tk2msftngp13.phx.gbl...
> The variable
> SelectedTournament
> will sometimes have an apostrophe within it.
> When it does I get a 500 server error.
> There have been some suggestions on how to
> deal with this, such as doubling the single quotes
> but there is no place to do this. Is there another
> way to fix this right within the query itself ?
>
> " SELECT DivNumber,DivRank,DivAge,DivGender "
> " FROM FSTPoints WHERE TournamentName = '" & SelectedTournament & "' AND
> DivNumber = "
> & iterate & ";"
>
>