CFGraph

2002-03-03 Thread Rudy Rustam

Hi guys,

When using CFGraph to create a flash file Any idea where is the flash
file located?

Thanks in advance

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



Re: Developers Exchange... How *could* they!?

2002-03-03 Thread Valerie L. Criswell

WOW! this is excellent. I usually go there and begin a search with a big
groan and a sigh.  Now maybe I can make some time to actually browse the
place.  How wonderfully cool!


[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 9:21 PM
Subject: Re: Developers Exchange... How *could* they!?


 At least they haven't made the site compatible with Netscape 6 yet, so
 you could load the site in NS6 and then go on a magnifying glass hunting
 expedition :)

 jon

 Matt Robertson wrote:
  For two days now I've been doing searches on the Developers Exchange and
  getting regular one- to two-second responses.  I just searched for
  ''ColdFusion'' and got back 374 results in just under 3 seconds.
 
  I'm shocked and outraged.  I no longer have the time to go to the water
  cooler, doze off or chat with the ladies in the next office while
  waiting for search results.  This has completely fouled up my workflow.
 
  How could Macromedia do this to all of their loyal CF developers, and me
  in particular???


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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



Upgrading to CF 5...

2002-03-03 Thread Kevin Langevin

Hi all...I just attempted to upgrade a CF 4.5 server to CF 5, and got a slew
of errors stating that ordinal 259 could not be located in dynamic link
library SHSMP.DLL.  ANy thoughts on what caused this and what I can do to
rectify the situation?


Kevin Langevin
Web Guy In Charge
UsWebGuys
954-327-5780


-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 10:15 AM
To: CF-Talk
Subject: CFGraph


Hi guys,

When using CFGraph to create a flash file. Any idea where is the flash
file located?

Thanks in advance


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Upgrading to CF 5...

2002-03-03 Thread Howie Hamlin

That DLL is a heap manager that (I assume) CF uses internally.  Where are you seeing 
these errors?

It's possible that an older version of the DLL is on your system and does not have an 
internal function that is required by CF.  I
have two on my system - one in my CF backup folder (version is 5.0.0.0) and one in the 
CF bin folder.  The one in the CF bin folder
is a later one and is 117k in size and has a version of 6.0.1.3.

Do a search of your system for all occurances of shsmp.dll and also make sure that the 
6.0.1.3 version is the one in your cf\bin
folder.  If you have older versions in your cf\bin folder or in your windows system 
folder then that could be causing the problem.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
 Find out how iMS Stacks up to the competition: 
http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: Kevin Langevin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, March 03, 2002 12:07 PM
Subject: Upgrading to CF 5...


 Hi all...I just attempted to upgrade a CF 4.5 server to CF 5, and got a slew
 of errors stating that ordinal 259 could not be located in dynamic link
 library SHSMP.DLL.  ANy thoughts on what caused this and what I can do to
 rectify the situation?


 Kevin Langevin
 Web Guy In Charge
 UsWebGuys
 954-327-5780


 -Original Message-
 From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, March 03, 2002 10:15 AM
 To: CF-Talk
 Subject: CFGraph


 Hi guys,

 When using CFGraph to create a flash file. Any idea where is the flash
 file located?

 Thanks in advance


 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Upgrading to CF 5...

2002-03-03 Thread Dave Watts

 Hi allI just attempted to upgrade a CF 45 server 
 to CF 5, and got a slew of errors stating that ordinal 
 259 could not be located in dynamic link library 
 SHSMPDLL Any thoughts on what caused this and 
 what I can do to rectify the situation?

That's the SmartHeap DLL, which CF uses to manage memory, as Howie noted
You might want to make sure you've turned off CF 45 before attempting the
upgrade You might also want to make sure you don't have any conflicting
versions In addition to searching for SHSMPDLL, you might also search for
SHW32DLL, which is another name for the library (I suppose that's the
non-SMP version of it) If you've installed any other applications
(services, typically, I'd guess) which might use this, they may have
installed a different version

Dave Watts, CTO, Fig Leaf Software
http://wwwfigleafcom/
voice: (202) 797-5496
fax: (202) 797-5444
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



RE: CFGraph

2002-03-03 Thread Dave Watts

 When using CFGraph to create a flash file Any idea where 
 is the flash file located?

I'm pretty sure that it's dynamically generated That is, it's not stored
anywhere - it's generated on the fly and returned to the browser The
templates used to generate them, though, are in the \CFUSION\cfgraphs
directory They have a swt extension

Dave Watts, CTO, Fig Leaf Software
http://wwwfigleafcom/
voice: (202) 797-5496
fax: (202) 797-5444
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



RE: ColdFusion, IIS and Virtual Directories

2002-03-03 Thread Dave Watts

 I recently started administering a ColdFusion Server with 
 Windows 2000 Advanced Server using IIS to deliver webpages, 
 after being primarily a developer for the past couple of 
 years I am having a real problem working with virtual 
 directories due to IIS and Windows 2000 security features 
 working so closely together I can run CFM pages from 
 websites I set-up as long as there are no virtual directories, 
 but when I set-up a virtual directory to another place on 
 the server, I get a password prompt on any CF page I try, 
 but on none of the other pages (htm and css, etc) Any 
 ideas?

Make sure that the anonymous user account (IUSR_MACHINENAME) has read access
to your static files, and execute access to your CFM files Also, make sure
that the CF service (typically running as SYSTEM) has read access to your
CFM files Finally, make sure that the anonymous user, along with any other
user accounts that you want to have run CFM files, has read/execute access
to \CFUSION\BIN\ISCFDLL

Finally, you might want to configure each one of these virtual directories
so that it runs within the context of the website it's in You can do that
by right-clicking on the virtual directory and selecting Properties
You'll then see a Remove button in the lower right of the dialog If this
isn't grayed out, click on it to remove the virtual directory as a separate
application - it'll then run as part of the parent site

Dave Watts, CTO, Fig Leaf Software
http://wwwfigleafcom/
voice: (202) 797-5496
fax: (202) 797-5444
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



Re: CFGraph

2002-03-03 Thread Bruce H. Sorge

CFGraph does not store the graphs. There are templates that are installed
that lay out the basic framework for the graphs. That is the who purpose of
having a dynamic graphing engine, so that you do not have to create and
store the graphs. This is also why you have to have the Jrun server and the
Macromedia Generator installed. The files are java applets that use the
generator to render and display the charts.
- Original Message -
From: Rudy Rustam [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, March 03, 2002 9:15 AM
Subject: CFGraph


 Hi guys,

 When using CFGraph to create a flash file. Any idea where is the flash
 file located?

 Thanks in advance

 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CFGraph

2002-03-03 Thread Mike Chambers

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, March 03, 2002 1:35 PM

  When using CFGraph to create a flash file. Any idea where
  is the flash file located?
 
 I'm pretty sure that it's dynamically generated. That is, 
 it's not stored anywhere - it's generated on the fly and 
 returned to the browser. 

just wanted to confirm that that is correct.

mike chambers

[EMAIL PROTECTED]
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: CFGraph

2002-03-03 Thread Mike Chambers

 -Original Message-
 From: Bruce H. Sorge [mailto:[EMAIL PROTECTED]] 
The files are java 
 applets that use the generator to render and display the charts.

just a quick note, the files are Generator templates, that are processed
by Generator to dynamically create the Flash movies. Generator's
interface is a Java Servlet.

mike chambers

[EMAIL PROTECTED]
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Developers Exchange... How *could* they!?

2002-03-03 Thread Robert Everland

Too bad they still haven't fixed the advanced search so that you can search
by author.


Bob Everland 

-Original Message-
From: Valerie L. Criswell
To: CF-Talk
Sent: 3/3/02 12:05 PM
Subject: Re: Developers Exchange... How *could* they!?

WOW! this is excellent. I usually go there and begin a search with a big
groan and a sigh.  Now maybe I can make some time to actually browse the
place.  How wonderfully cool!


[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 9:21 PM
Subject: Re: Developers Exchange... How *could* they!?


 At least they haven't made the site compatible with Netscape 6 yet, so
 you could load the site in NS6 and then go on a magnifying glass
hunting
 expedition :)

 jon

 Matt Robertson wrote:
  For two days now I've been doing searches on the Developers Exchange
and
  getting regular one- to two-second responses.  I just searched for
  ''ColdFusion'' and got back 374 results in just under 3 seconds.
 
  I'm shocked and outraged.  I no longer have the time to go to the
water
  cooler, doze off or chat with the ladies in the next office while
  waiting for search results.  This has completely fouled up my
workflow.
 
  How could Macromedia do this to all of their loyal CF developers,
and me
  in particular???



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Developers Exchange... How *could* they!?

2002-03-03 Thread Matt Robertson

Robert wrote:

 Too bad they still haven't fixed the advanced 
 search so that you can search by author

I noticed that as well  I'm curious to hear this from Macromedia: what
did you guys do to make such a big change in performance?

--Matt Robertson--
MSB Designs, Inc
http://mysecretbasecom

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusionb
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



Re: cfif in cfset

2002-03-03 Thread Aaron Rouse

Ah, what a life must be like to actually use CF5 day to day.  Still stuck on
4.5x at work and lots of talk of them not upgrading CF, but switching to
something else completely.

Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion


- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 4:47 PM
Subject: Re: cfif in cfset


 You could roll your own, which lets you eliminate the need for DE().  It's
 about 45% faster in my tests using CF5.  Without the DE() functions used
in
 the IIf(), the difference is a lot less.

 The way this function operates is less flexible that CF's built-in IIf(),
 since you couldn't do something like IIff(IsDefined(myvariable),
myvariable,
 )).

 cfscript
 function IIff(arg0, arg1, arg2) {
   if (arg0) return arg1;
   return arg2;
 }
 /cfscript

 cfset iterations = 25000
 cfset x = 37

 cfset t = GetTickCount()
 cfloop index=i from=1 to=#iterations#
   cfset a = IIf(x gt 50, DE(1), DE(2))
 /cfloop
 cfset time1 = GetTickCount() - t

 cfset t = GetTickCount()
 cfloop index=i from=1 to=#iterations#
   cfset b = IIff(x gt 50, 1, 2)
 /cfloop
 cfset time2 = GetTickCount() - t

 pre
 pre
 Over #NumberFormat(iterations)# iterations:

 IIf() with DE() = #NumberFormat(time1)#
 IIff()  = #NumberFormat(time2)#
 /pre
 /cfoutput


 Jim



 - Original Message -
 From: Aaron Rouse [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Saturday, March 02, 2002 3:10 PM
 Subject: Re: cfif in cfset


  I know the DE() function which is commonly used with IIF is resource
  intensive.  I once stripped out a sizeable amount of IIF() functions
from
 a
  page and put in CFIF tags in place and picked up a noticeable amount in
 the
  load times.  In a lot of cases the IIF() is used, people could have used
  CFIF.
 
  Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion
 
 
  - Original Message -
  From: Nick McClure [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Saturday, March 02, 2002 3:46 PM
  Subject: Re: cfif in cfset
 
 
   You know, I don't know the answer to that question. I use it often
 enough,
   and I don't notice a problem.
  
   It is the only thing that you can use accomplish the problem.
  
   You could write a function and use cfscript to take care of it for
you.
  
   At 11:40 PM 3/2/2002 +0200, you wrote:
   Nick,
   
 You want to use IIF
   
   I've heard it's resource intensive, true?
 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: cfif in cfset

2002-03-03 Thread Douglas Brown

sumtin else. getta rope






Success is a journey, not a destination!!



Doug Brown
- Original Message - 
From: Aaron Rouse [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, March 03, 2002 1:52 PM
Subject: Re: cfif in cfset


 Ah, what a life must be like to actually use CF5 day to day.  Still 
stuck on
 4.5x at work and lots of talk of them not upgrading CF, but switching 
to
 something else completely.
 
 Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion
 
 
 - Original Message -
 From: Jim McAtee [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Saturday, March 02, 2002 4:47 PM
 Subject: Re: cfif in cfset
 
 
  You could roll your own, which lets you eliminate the need for DE(). 
 It's
  about 45% faster in my tests using CF5.  Without the DE() functions 
used
 in
  the IIf(), the difference is a lot less.
 
  The way this function operates is less flexible that CF's built-in 
IIf(),
  since you couldn't do something like IIff(IsDefined(myvariable),
 myvariable,
  )).
 
  cfscript
  function IIff(arg0, arg1, arg2) {
if (arg0) return arg1;
return arg2;
  }
  /cfscript
 
  cfset iterations = 25000
  cfset x = 37
 
  cfset t = GetTickCount()
  cfloop index=i from=1 to=#iterations#
cfset a = IIf(x gt 50, DE(1), DE(2))
  /cfloop
  cfset time1 = GetTickCount() - t
 
  cfset t = GetTickCount()
  cfloop index=i from=1 to=#iterations#
cfset b = IIff(x gt 50, 1, 2)
  /cfloop
  cfset time2 = GetTickCount() - t
 
  pre
  pre
  Over #NumberFormat(iterations)# iterations:
 
  IIf() with DE() = #NumberFormat(time1)#
  IIff()  = #NumberFormat(time2)#
  /pre
  /cfoutput
 
 
  Jim
 
 
 
  - Original Message -
  From: Aaron Rouse [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Saturday, March 02, 2002 3:10 PM
  Subject: Re: cfif in cfset
 
 
   I know the DE() function which is commonly used with IIF is 
resource
   intensive.  I once stripped out a sizeable amount of IIF() 
functions
 from
  a
   page and put in CFIF tags in place and picked up a noticeable 
amount in
  the
   load times.  In a lot of cases the IIF() is used, people could 
have used
   CFIF.
  
   Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion
  
  
   - Original Message -
   From: Nick McClure [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Saturday, March 02, 2002 3:46 PM
   Subject: Re: cfif in cfset
  
  
You know, I don't know the answer to that question. I use it 
often
  enough,
and I don't notice a problem.
   
It is the only thing that you can use accomplish the problem.
   
You could write a function and use cfscript to take care of it 
for
 you.
   
At 11:40 PM 3/2/2002 +0200, you wrote:
Nick,

  You want to use IIF

I've heard it's resource intensive, true?
  
 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



simple cfloop

2002-03-03 Thread Sorgatz, Rex

Beginner CFer with an easy question The situation: the user selects the
rows to query based upon ticking checkboxes So, this is the first page:

form action=tallycfm method=post
input type=checkbox name=id value=180
input type=checkbox name=id value=192
input type=checkbox name=id value=204
input type=checkbox name=id value=307
input type=submit value=go
/form 

Using a list and a cfloop to return multiple columns in only the rows the
user selects, what would the tallycfm page look like? I'm looking at
something like this, but I know it's wrong:

cfloop index=ListIndex list=#FORMid# delimiters=,
cfquery name=listsQuery datasource=xxx
SELECT this, that, theotherthing
FROM tblName
WHERE ID = #id#
/cfquery 
cfoutput
query=listsQuery#this#br#that#br#theotherthing#brbr/cfoutput
/cfloop

Thanks for your help

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



Re: simple cfloop

2002-03-03 Thread Paul Giesenhagen

The way your are doing it, just do the following:
Take plain outputs and put them around the loop (so it doesn't have to
output,output output ...(don't know if it matters)..

Then do as you were doing ...

cfoutput
cfloop index=ListIndex list=#FORM.id# delimiters=,
cfquery name=listsQuery datasource=xxx
SELECT this, that, theotherthing
FROM tblName
WHERE ID = #id#
/cfquery
#this#br#that#br#theotherthing#brbr
/cfloop
/cfoutput


You could also do IN

cfquery datasoure=xxx name=listsQuery
SELECT this, that, theotherthing
FROM tblName
WHERE ID IN (#id#)
/cfquery

cfoutput query=listsQuery
#this#br#that#br#theotherthing#brbr
/cfoutput



- Original Message -
From: Sorgatz, Rex [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, March 03, 2002 7:33 PM
Subject: simple cfloop


 Beginner CFer with an easy question. The situation: the user selects th
e
 rows to query based upon ticking checkboxes. So, this is the first page
:

 form action=tally.cfm method=post
 input type=checkbox name=id value=180
 input type=checkbox name=id value=192
 input type=checkbox name=id value=204
 input type=checkbox name=id value=307
 input type=submit value=go
 /form

 Using a list and a cfloop to return multiple columns in only the rows t
he
 user selects, what would the tally.cfm page look like? I'm looking at
 something like this, but I know it's wrong:

 cfloop index=ListIndex list=#FORM.id# delimiters=,
 cfquery name=listsQuery datasource=xxx
 SELECT this, that, theotherthing
 FROM tblName
 WHERE ID = #id#
 /cfquery
 cfoutput
 query=listsQuery#this#br#that#br#theotherthing#brbr/cfout
put
 /cfloop

 Thanks for your help.

 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: simple cfloop

2002-03-03 Thread Kelly Matthews

Yep in is much better, quicker too!

[EMAIL PROTECTED] writes:
cfquery datasoure=xxx name=listsQuery
SELECT this, that, theotherthing
FROM tblName
WHERE ID IN (#id#)
/cfquery

cfoutput query=listsQuery
#this#br#that#br#theotherthing#brbr
/cfoutput


~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
~~

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: simple cfloop

2002-03-03 Thread stas

You don't need multiple queries. Just run one query with WHERE ID IN
(#form.id#) and do a cfloop query = myQuery.

-Original Message-
From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, March 03, 2002 8:33 PM
To: CF-Talk
Subject: simple cfloop


Beginner CFer with an easy question. The situation: the user selects the
rows to query based upon ticking checkboxes. So, this is the first page:

form action=tally.cfm method=post
input type=checkbox name=id value=180
input type=checkbox name=id value=192
input type=checkbox name=id value=204
input type=checkbox name=id value=307
input type=submit value=go
/form 

Using a list and a cfloop to return multiple columns in only the rows
the user selects, what would the tally.cfm page look like? I'm looking
at something like this, but I know it's wrong:

cfloop index=ListIndex list=#FORM.id# delimiters=, cfquery
name=listsQuery datasource=xxx SELECT this, that, theotherthing
FROM tblName WHERE ID = #id# /cfquery 
cfoutput
query=listsQuery#this#br#that#br#theotherthing#brbr/cfoutput

/cfloop

Thanks for your help.


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: OOT - Information

2002-03-03 Thread Eric J Hoffman

Contact me offlist.  We are not hiring per se, but at this time we are
looking at subcontractors for some jobs.

Regards,

Eric J. Hoffman
Director of Internet Development
DataStream Connexion, LLC
(formerly Small Dog Design)

-Original Message-
From: Troy Montour [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:15 AM
To: CF-Talk
Subject: OOT - Information


Hello everyone,
As its sitting on a month and half of looking for a job and no luck
yet I was wondering if anyone has any leads for the
Minnesota,Minneapolis area I could check out and hopefully get hired.

Thank You
Troy Montour
Vampires Inc
4663 Main ST
Fridley, MN 55421
Phone: (612) 867-6831
Fax: (763) 586-0552
www.vampiresinc.com


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



Purge Client Vars

2002-03-03 Thread Webmaster

Hi,
Anyone having a problem purging client vars?  (CGLOBAL/ CDATA)  Mine was
working and for some reason on the 15th it just stopped (The log showed the
purg every day and on the 15th, no more log mesaages)  I can't see anything
I did or changed that would cause this  I have tried changing the purge
interval but nothing seems to help  I am running NT2k SP2 with CF5 and
latest fixes I have am using a DB for my client var store
Anyone have any ideas or anything I can look at that might help?
Best Regards,
 Joe Hansen

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusionb
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



old question, new answer?

2002-03-03 Thread Eric J Hoffman

Anyone have a good, free or cheap webchat program for a non-profit that is
Cf-based or you use in a CF site that works reasonably well?  Any ideas are
welcomethe gallery seems to be sparse

Regards,

Eric J Hoffman
Director of Internet Development
DataStream Connexion, LLC
(formerly Small Dog Design)

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



get modification date of file via http

2002-03-03 Thread James Sleeman

Hi all,
anybody know if there is a way of getting the modification date of a
file without retrieving the entire file using CFHTTP

Essentially what I want to do, in pseudo code is

CFHTTP URL=SomeURL ACTION=GETHEADERS
CFIF DateCompare(modificationDateOf(CFHTTPGetHeaders),
modificationDateOf(FileWeHave))
Download file
/CFIF

ie the same thing that a web browser cache might do when requesting  file -
if the header indicates the URL is newer than the file in the cache,
download it, otherwise use the cached version

---
James Sleeman
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



CFQUERYPARAM: a good generic numeric type?

2002-03-03 Thread Matt Robertson

Was reading Ben Forta's article on CFQUERYPARAM in CFDJ  I need to get
off my butt and use this instead of just wrapping vars in a VAL
statement  

However I have to support four db platforms (Access, SQL Server, mySQL
and Oracle) with the same code  Is there a single numeric SQL type that
will work with simple ID numbers on all four platforms?

CF_SQL_INTEGER?
CF_SQL_NUMERIC?

--Matt--
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists



RE: Regular Expression Help

2002-03-03 Thread Pascal Peters

lWordList = ArrayToList(myarray,|);
REReplaceNoCase(mystring,([^[:alnum]])(#lWordList#)([^[:alnum]]),\1\3
,ALL);

This will replace the words defined in myarray by empty strings.

-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: zaterdag 2 maart 2002 13:29
To: CF-Talk
Subject: Re: Regular Expression Help


On Sat, 2002-03-02 at 10:10, Jared Stark wrote:
 Hello all.  I am trying to write a simple search engine, and would 
like 
 to replace certain commonly used prepositions from the search string 
 such as 'a','the','for', etc...
 
 I have an array of the prepositions that I would like to remove, 
however 
 the problem I have is that it is removing them when they are subsets 
of 
 other words, for example 'them' would become 'm' when removing 'the', 
 'bag' would become 'bg' when removing 'a', etc...  
 
 I'm not an expert at regular expression, but I'm assuming it is 
possible 
 to remove only those instances where the prepositions are stand-alone 
 and not subsets of other words.  Could someone render me some 
 assistance?

If you want to use regular expressions to do it, easiest way would be to
use the character class for whitespace before and after your
preposition.

However don't underestimate the power of the CF list processing
functions, think of your search term as a list seperated by whitespace
and you can use any of the CF list functions.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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