Will, can you browse pages locally on the IIS machine itself form the IIS
machine? Make sure the IIS and ColdFusion server are running. When you can
check the document settings in IIS make sure that Index.cfm and
Index.htm-html are still there and are in 1st and 2nd position, if not add
them. Also, when you can, check the webserver.log in the ColdFusion logs to
see if there are any clues there. Also, if you were away has anyone taken
care of the Red Worm Default.ida issues by patching the IIS Server, that is
of course if it is accessible via NAT from the public Internet.
Kind Regards - Mike Brunt
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 10:29 AM
To: CF-Talk
Subject: Re: Quick query question (qqq)
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
