Can this be done?

[Joel Blanchette]

Hello All,
Wondering if there is a way to make the html files to using cold
fusion on a windows server 2000 iis5?  I need to map all the html in a
site to cold fusion.  I don't really feel like changing all the html
extensions to cfm.

Thanks.

Joel

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can this be done ?

[gregg Kachel]

I'm wondering if this is possible, as I haven't had any luck.  I hope
someone can help me =).  I am trying to do is list all the manufactures in
my database by state. No, problem, works fine. But, I only want it to list
five states at a time, and have a next button that will take the user to the
next five states. Unfortuneatly, I can only get it to go up the next five
"records" in the database. Is there a way to have it go next to the next
catagory ?  Thanks ahead of time,
Gregg
webmaster
www.houseboatmagazine.com

PS: here is the code I have so far !



  SELECT id, state, statename, company
  FROM HBMF
 Order by state





Click on the state or province for houseboat manufactures in that state
only.


 



#statename#




Or, you may browse the entire listing below of houseboat manufactures.
  


  
Manufactures
  
  
  Sorry, no matching records.
  


 
 

 #statename#
  
   
 #company#
  
  
  







There are #manf.RecordCount# items in the database.
You are currently viewing records #StartRow# to #Evaluate(StartRow
+ MaxRows - 1)#



 Next page


 Previous page




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

can this be done?

[Jeff Fongemie]

Hello cf-talk,

  I have an existing project where a form takes a field "name" and
  inserts in in a row "name" in an Access database.

  So, we have about 1000 names in the database as one name (firstname
  lastname). Now, the client changes
  his mind, and wants to be able to sort by last name, firstname.

  Yes, this was discussed prior to, and was deemed not needed.

  Is there a way, to somehow break up the full name into 2 fields, say
  by using the space as a separator?  I would only need to do this
  once as it is an event. Could I make two new fields, last_name and
  first_name, then get the fullname, break it up using the space, then
  insert first_name, then last_name?

  Is this even possible? This would have been so much easier if client
  said yes to this at the design stage!


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]


_
Composed on Monday, May 13, 2002, at 11:55:57 AM

__
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can this be done?

[sebastian palmigiani]

I don't know if this is possible. I just know I can't figure out how to do
it.

I want to dynamically determine whether the  tag has a query
parameter. 

The following does not work but shows what I  want to do:





query="ShowMemberInfo"'


>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Can This be done?

[Ben Densmore]

I have a page where I display info on 16 players (I'm running a fantasy 
football league and trying to have everything automated) This info comes 
from a DB. The info is displayed like this in an html table.

  4 
  QB 
   Kurt Warner 
  STL 
  
  
  
  
   
  
now there is 16 of these. I need to insert only the ones are checked 
which will be 8 players. How can I insert these into my DB, I keep 
getting a numeric value out of range error message so I'm guessing it's 
trying to grab all the form values in my page and insert them into one 
line in my DB, I need to have it so Player one info will be inserted 
into 4 columns, then player 2 will be inserted into the next row of 
columns etc.. I hope I explained this ok. Thanks for any help someone 
may offer.

Ben Densmore


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can this be done??

[Yager, Brian T Contractor/NCCIM]

I want to be able to run a file on one server that goes out to a page on another
server, run a query, grab the information, and put it into a DB on the first
server.  Has anyone done this before??



Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can this be done?

[Che Vilnonis]

Hello all..

I'm bidding on a job and the client told me something that a competitor
does that seems pretty amazing.

He said that this competitor can dynamically build certain sections of
a homepage based on the search term that was used on the previous page
of a search engine site, no matter which one is used.

I know you can look at the CGI.HTTP_REFERER value for some search engines,
but does anyone know how to do this for all sites. Is there a tool, CFC or
UDF that could do this for me? Is there an easy way to parse the info out?

Che Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Can this be done?

[Mauricio Giraldo]

speculating:

cffile the apache/iis logs... parse the last couple of lines... output...

dont wanna think what will happen if the logs are a few megabytes big...

- mga
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Can this be done?

[Mauricio Giraldo]

>The logs just contain the same data that would be in CGI.HTTP_REFERER 

hm... wasn't aware of that
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com

Re: Can this be done?

[Douglas Brown]

What version of CF?




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Joel Blanchette" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 1:24 PM
Subject: Can this be done?


> Hello All,
> Wondering if there is a way to make the html files to using cold
> fusion on a windows server 2000 iis5?  I need to map all the html in a
> site to cold fusion.  I don't really feel like changing all the html
> extensions to cfm.
>
> Thanks.
>
> Joel
>
> 
__
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can this be done?

[Tony Weeg]

cf 5 yeah.from the iis manager,
add an extension, called .html
that is mapped to use the iscf.dll
(basically mirror the settings that
the .cfm file have, just change the .cfm
to .html, or whatever .tony if you want)

cfmx is a bit harder

tw


-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 29, 2002 4:24 PM
To: CF-Talk
Subject: Can this be done?


Hello All,
Wondering if there is a way to make the html files to using cold
fusion on a windows server 2000 iis5?  I need to map all the html in a
site to cold fusion.  I don't really feel like changing all the html
extensions to cfm.

Thanks.

Joel


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can this be done?

[Candace Cottrell]

Is there a reason why you need to change the file extensions?

Are you using Dreamweaver at all?

Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org

 
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 08/29/02 19:39 PM >>>
Hello All,
Wondering if there is a way to make the html files to using cold
fusion on a windows server 2000 iis5?  I need to map all the html in a
site to cold fusion.  I don't really feel like changing all the html
extensions to cfm.

Thanks.

Joel


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can this be done?

[Charles McElwee]

Haven't tried this, but I think you can go into the Internet Services
Manager under Admin Tools, go the Properties for the Default Web Site
(or sub directory), choose the Home Directory tab and click on the
Configuration button.  Under Application Mappings, add .htm and point it
to the same .dll used by the version of CF you are using.  You should
see the mappings already set up for the .CFM files there.  I've played
around with this to have CF process .css style sheets...

Chuck McElwee
Macromedia Certified Advanced ColdFusion Developer
www.etechsolutions.com
[EMAIL PROTECTED]

-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 29, 2002 4:24 PM
To: CF-Talk
Subject: Can this be done?


Hello All,
Wondering if there is a way to make the html files to using cold
fusion on a windows server 2000 iis5?  I need to map all the html in a
site to cold fusion.  I don't really feel like changing all the html
extensions to cfm.

Thanks.

Joel


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can this be done?

[cfhelp]

I don't know if this will work on MX

Go into IIS go to the webs properties click on the "Home Directory" tab and
then click "Configuration" Double click .cfm and copy the Executable path
Close it and click "add" Paste the path and in the executable and make the
extension .htm do the same for .html.

Rick

-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 29, 2002 3:24 PM
To: CF-Talk
Subject: Can this be done?

Hello All,
Wondering if there is a way to make the html files to using cold
fusion on a windows server 2000 iis5?  I need to map all the html in a
site to cold fusion.  I don't really feel like changing all the html
extensions to cfm.

Thanks.

Joel


__
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can this be done?

[novakbanda]

Just go into the IIS config... website properties... Home Directory tab...
and click CONFIGURATION.

Look at the .cfm entry and how it's set up... then set up another entry for
htm or .html (whichever you like) that looks identical.

All .htm (or .html) will then be parsed through the CF engine and will be
treated the same as .cfm files.

-Novak

- Original Message -
From: "Joel Blanchette" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 1:24 PM
Subject: Can this be done?


> Hello All,
> Wondering if there is a way to make the html files to using cold
> fusion on a windows server 2000 iis5?  I need to map all the html in a
> site to cold fusion.  I don't really feel like changing all the html
> extensions to cfm.
>
> Thanks.
>
> Joel
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can this be done?

[Brook Davies]

Open up IIS, and click on the properties of the website in question. Click 
on the home directory tab. Then click Configuration. Copy the path used in 
the *.cfm mapping and create a new mapping for *.html that points to the 
same executable as the *cfm path. That should do it

At 03:24 PM 29/08/02 -0500, you wrote:
>Hello All,
> Wondering if there is a way to make the html files to using cold
>fusion on a windows server 2000 iis5?  I need to map all the html in a
>site to cold fusion.  I don't really feel like changing all the html
>extensions to cfm.
>
>Thanks.
>
>Joel
>
>
__
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can this be done ?

[paul smith]

Gregg:

Sure it can be done.  Check out my bride's website at
http://www.bike70th.com - It displays 10 days at a time
no matter how many news items per day.

You just have to do the arithmetic.  I'll send you the
CF template privately.

best,  paul


At 05:03 PM 7/28/00 -0600, you wrote:
>I'm wondering if this is possible, as I haven't had any luck.  I hope
>someone can help me =).  I am trying to do is list all the manufactures in
>my database by state. No, problem, works fine. But, I only want it to list
>five states at a time, and have a next button that will take the user to the
>next five states. Unfortuneatly, I can only get it to go up the next five
>"records" in the database. Is there a way to have it go next to the next
>catagory ?  Thanks ahead of time,
>Gregg
>webmaster
>www.houseboatmagazine.com
>
>PS: here is the code I have so far !
>
>
>
>   SELECT id, state, statename, company
>   FROM HBMF
>  Order by state
>
>
>
>
>
>Click on the state or province for houseboat manufactures in that state
>only.
>
>
>  
>
>
>
>#statename#
>
>
>
>
>Or, you may browse the entire listing below of houseboat manufactures.
>   
>
>
>   
> Manufactures
>   
>   
>   Sorry, no matching records.
>   
>
>
>  
>  Maxrows="#maxrows#">
>
> #statename#
>   
>
>  #company#
>   
>   
>   
>
>
>
>
>
>
>
>There are #manf.RecordCount# items in the database.
>You are currently viewing records #StartRow# to #Evaluate(StartRow
>+ MaxRows - 1)#
>
>
>
>  Next page
>
>
>  Previous page
>
>
>
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Can this be done ?

[Jonathan Karlen]

One thought that quickly comes to mind is this:

Build a table States and put all 50 states in it.  Pull from it a list of
states and for each state query the database for manufacturers in that
state.  Then you could do next five records from the States table.  This
might take a performance hit.  You also might be able to do something with
GROUP BY.

Jonathan Karlen

- Original Message -
From: gregg Kachel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 6:03 PM
Subject: Can this be done ?


> I'm wondering if this is possible, as I haven't had any luck.  I hope
> someone can help me =).  I am trying to do is list all the manufactures in
> my database by state. No, problem, works fine. But, I only want it to list
> five states at a time, and have a next button that will take the user to
the
> next five states. Unfortuneatly, I can only get it to go up the next five
> "records" in the database. Is there a way to have it go next to the next
> catagory ?  Thanks ahead of time,
> Gregg
> webmaster
> www.houseboatmagazine.com
>
> PS: here is the code I have so far !
>
>
> 
>   SELECT id, state, statename, company
>   FROM HBMF
>  Order by state
>
> 
> 
>
>
> Click on the state or province for houseboat manufactures in that state
> only.
> 
> 
>  
> 
> 
>
> #statename#
> 
> 
> 
> 
> Or, you may browse the entire listing below of houseboat manufactures.
>   
> 
>
>   
> Manufactures
>   
>   
>   Sorry, no matching records.
>   
> 
>
>  
>   Maxrows="#maxrows#">
>
>  #statename#
>   
>
>  #company#
>   
>   
>   
>
>
>
>
> 
> 
> 
> There are #manf.RecordCount# items in the database.
> You are currently viewing records #StartRow# to
#Evaluate(StartRow
> + MaxRows - 1)#
> 
>
> 
>  Next page
> 
> 
>  Previous page
>
> 
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Can this be done ?

[David Hannum]

Try caching the query, then do a group by state with a startrow and maxrows
in your cfoutput.  You'll have to build your
next / previous counters to populate your startrow variable.  If you can't
build your own, there's a tag in the Alliare Developers Exchange that can
help.

Dave


- Original Message -
From: gregg Kachel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 7:03 PM
Subject: Can this be done ?


I'm wondering if this is possible, as I haven't had any luck.  I hope
someone can help me =).  I am trying to do is list all the manufactures in
my database by state. No, problem, works fine. But, I only want it to list
five states at a time, and have a next button that will take the user to the
next five states. Unfortuneatly, I can only get it to go up the next five
"records" in the database. Is there a way to have it go next to the next
catagory ?  Thanks ahead of time,
Gregg
webmaster
www.houseboatmagazine.com

PS: here is the code I have so far !



  SELECT id, state, statename, company
  FROM HBMF
 Order by state





Click on the state or province for houseboat manufactures in that state
only.


 



#statename#




Or, you may browse the entire listing below of houseboat manufactures.
  


  
Manufactures
  
  
  Sorry, no matching records.
  


 
 

 #statename#
  
   
 #company#
  
  
  







There are #manf.RecordCount# items in the database.
You are currently viewing records #StartRow# to #Evaluate(StartRow
+ MaxRows - 1)#



 Next page


 Previous page





--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

re: can this be done

[gregg Kachel]

This is a multi-part message in MIME format.

--=_NextPart_000_0017_01BFFB95.42423F80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Steve,=20

Thanks for the help, unfortuneatly its still not doing what it needs to =
do.  What I am trying to do is get the next to bring up the next five =
STATES and what ever manufactures are under that state. This code will =
only bring up the next five actual manufactures when I hit next.  Paul =
was gracious enough to send me this template, but unfortuneatly I'm =
rather new at CF, and have a hard time following his logic.  I know it =
works well on his page, and some how the next button and the previous =
bottons are turned around, and they will not bring up anything but there =
is no error, nor does any text come up ! It just comes with a blank =
screen.

The template and what I have gotten figured out so far is below:










SELECT id, state, company, statename
FROM HBMF
=20
 ORDER BY statename



SELECT ID
FROM HBMF
ORDER BY company

























 House boat Manufactures/TITLE>




Houseboat manufactures, listed by state: 





 #statename#
  
   
 #company#
  
  
  














































Hi Gregg,
>
>
>  Paul or whoever  can answer me, having a hard time understanding some
of
> this logic.  The next botton and previous buttons do not work, and
seem to
> be switched.  Any ideas what I am doing wrong ? Here is the code,
thanks.
>

I had a look at the code you gave...  It looked a little over complex,
so I
stripped a load of the code out and wound up with this:





SELECT id, state, statename, company
FROM HBMF
Order by statename



#statename#


#company#






























One of the reasons your previous code may not have been working was
because
of the use of the start variable.  By not specifying the scope of the
variable and using  to check the existance of the variable, you

were probably winding up with a start variable in the 'variables' scope
and
one in the 'form' scope and looking at the 'variables' scope version
rather
than the one passed from the form.
So what I've done is made sure that the start variable is properly
referenced, by using form.start in the cfparam and for any other
references.

Hope this is a little clearer.

Regards

Stephen

Gregg Kachel
Webmaster
www.houseboatmagazine.com
www.houseboat.net
www.pdbworld.com/


--=_NextPart_000_0017_01BFFB95.42423F80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Steve, 
Thanks for the help, unfortuneatly =
its still=20
not doing what it needs to do.  What I am trying to do is get the =
next to=20
bring up the next five STATES and what ever manufactures are under that =
state.=20
This code will only bring up the next five actual manufactures when I =
hit=20
next.  Paul was gracious enough to send me this template, but =
unfortuneatly=20
I'm rather new at CF, and have a hard time following his logic.  I =
know it=20
works well on his page, and some how the next button and the previous =
bottons=20
are turned around, and they will not bring up anything but there is no =
error,=20
nor does any text come up ! It just comes with a blank =
screen.
 
The template and what I have gotten =
figured out so=20
far is below:
 

 

 

 
    SELECT id, state, =
company,=20
statename    FROM HBMF  ORDER BY=20
statename
 
SELECT IDFROM HBMFORDER BY=20
company
 

 

 

 
=