S
Sparky Arbuckle
I have the following sql statement, typically it would grab a specific
value but I also want to be able to grab all values within the
database. Can I use the same SQL statement? I thought I could just use
* and pull everything but that doesn't appear to work.
SELECT tblRacers.RacerID, tblRacers.strLName, tblRacers.strFName,
tblRacers.strAgeCat, tblRacers.strRaceCat FROM tblRacers WHERE
tblRacers.strAgeCat='" & strAgeCat & "' AND tblRacers.strRaceCat='" &
strRaceCat & "';
I thought if the value passed in for strAgeCat/strRaceCat was * it
would pull all but I guess that isn't the case. Any suggestions on how
to approach this?
Thanks!
value but I also want to be able to grab all values within the
database. Can I use the same SQL statement? I thought I could just use
* and pull everything but that doesn't appear to work.
SELECT tblRacers.RacerID, tblRacers.strLName, tblRacers.strFName,
tblRacers.strAgeCat, tblRacers.strRaceCat FROM tblRacers WHERE
tblRacers.strAgeCat='" & strAgeCat & "' AND tblRacers.strRaceCat='" &
strRaceCat & "';
I thought if the value passed in for strAgeCat/strRaceCat was * it
would pull all but I guess that isn't the case. Any suggestions on how
to approach this?
Thanks!