Ah great - thanks Chad, Howie and Diana. I've been on holiday since early
July and have forgotten the basics :p For some reason, my local IIS machine
has stopped wanting to serve web pages. Calling up 192.168.0.1/test.cfm
(or.htm) from another machine, it just waits....and waits, and nothing
happens. On the machine itself, I can't access the Interet Services Manager
in Administrative Tools - any ideas? (sorry it's off thread).
Will
----- Original Message -----
From: "Chad Gray" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Saturday, August 25, 2001 6:13 PM
Subject: Re: Quick query question (qqq)
> With the LIKE statement.
>
> SELECT username
> FROM table
> WHERE username LIKE 'm%'
>
> The % symbol is a wildcard.
>
> You can also use
> WHERE username BETWEEN 'm' AND 'z'
>
> This will give you all the records that are between m and z.
>
>
>
>
> At 05:59 PM 8/25/2001 +0100, you wrote:
> >I have a list of towns (3000 or so), and need to output them per letter
in
> >the alphabet. For instance, I might need to pull up all towns starting
with
> >the letter M. To choose the letter, there will be a drop down box with
A-Z
> >in it (form.letter)
> >
> >How can I do this in my query?
> >
> >Cheers
> >
> >Will
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
