What happens if you put single-quotes around the 1 like this: select from team where COUNTRYID == '1'
Matt M. On Tue, Feb 2, 2010 at 7:02 AM, Nurettin Omer Hamzaoglu <[email protected]> wrote: > There are about 20 records with COUNTRYID = 1 but the following query > doesn't retrieve any records. > > <cfquery name="getTeams"> > select from team where COUNTRYID == 1 > </cfquery> > > -- > Open BlueDragon Public Mailing List > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon > mailing list - http://groups.google.com/group/openbd?hl=en > > !! save a network - please trim replies before posting !! -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
