Throws the following error. CFML Runtime Error illegal argument in range: select from team where COUNTRYID == '1'
Type Application Detail Filters of type java.lang.Character are not supported On Feb 2, 8:49 pm, Matthew McGinty <[email protected]> wrote: > 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 !!
