Re: Pulling email

2001-06-10 Thread Dain Anderson

Howie,

Oops. It should work now :-)

Thanks,

Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/



- Original Message -
From: Howie Hamlin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 1:50 AM
Subject: Re: Pulling email


 Your link doesn't seem to work...

 Regards,

 Howie

 - Original Message -
 From: Dain Anderson [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, June 10, 2001 1:09 AM
 Subject: Re: Pulling email


  Brian,
 
  I built a tag (and updated it today!) that parses emails, URLs and
UNC/File
  paths into active hyperlinks. You can download the tag for free w/source
at:
 
  http://cfcomet.com/cfcomet/utilities/CF_LinkFinder_v1-1.zip
 
  Dain Anderson
  Caretaker, CF Comet
  http://www.cfcomet.com/
 
 
  - Original Message -
  From: Brian Thornton [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, June 08, 2001 8:25 PM
  Subject: Pulling email
 
 
   I need to be able to pull the context of a [EMAIL PROTECTED] or
  applicable email address.
  
   ANyone know of anything?
  
  
  
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFgraph on O'Reilly Website 3

2001-06-10 Thread Jim Watkins

Ann,
I copied/pasted your code and results are at:
http://www.ngtcollege.org/graphexam.cfm  see what I mean.

Jim
- Original Message -
From: Ann Harrell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 8:27 PM
Subject: RE: CFgraph on O'Reilly Website 3



 http://www.allaire.com/documents/cf50/cf5_update.htm


 cfset Q1income=760
 cfset Q2income=87
 cfset Q3income=93
 cfset Q4income=86

 cfgraph type=Line
   title=Quarterly Income
   fill=yes
   cfgraphdata item=Q1 value=#Q1income#
   cfgraphdata item=Q2 value=#Q2income#
   cfgraphdata item=Q3 value=#Q3income#
   cfgraphdata item=Q3 value=#Q3income#
 /cfgraph


 Also, the example code on the reference page for cfgraphdata
 (CFDOCS/CFML_Reference/Tags40.html) should be as follwos:


 cfset NewIncome = 120
 cfset UsedIncome = 87
 cfset Leasingincome = 93
 cfset ServiceIncome = 76

 cfgraph type = bar title = Income by Department
   cfgraphdata item=New Vehicle Sales value=#NewIncome#
   cfgraphdata item=Used Vehicle Sales value=#UsedIncome#
   cfgraphdata item=Leasing value=#LeasingIncome#
   cfgraphdata item=Service value=#ServiceIncome#
 /cfgraph




  -Original Message-
  From: Jim Watkins [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, June 09, 2001 5:03 PM
  To: CF-Talk
  Subject: Re: CFgraph on O'Reilly Website 3
 
 
  Ann,
 
  Would you send me your exact code and I will copy and paste or
  maybe attach
  your cfm file off  list so I know I did it exactly right.  Send to
  [EMAIL PROTECTED]
 
  Jim
  - Original Message -
  From: Ann Harrell [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Saturday, June 09, 2001 2:09 PM
  Subject: RE: CFgraph on O'Reilly Website 3
 
 
  
   http://ann.bourbon.hoosierlink.net/snippet/graphexample2.cfm
   http://ann.bourbon.hoosierlink.net/snippet/graphexample1.cfm
  
   I'm on w2k SP1 and IIS.
  
   So, they do work for me.
  
   Ann
  
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 09, 2001 12:12 PM
To: CF-Talk
Subject: Re: CFgraph on O'Reilly Website 3
   
   
Thanks Ann
I did try them and they are at:
http://www.ngtcollege.org/graphtest3.cfm and
don't work either.
   
Jim
- Original Message -
From: Ann Harrell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 11:29 AM
Subject: RE: CFgraph on O'Reilly Website 3
   
   
 Jim did you try either of the corrected examples that I sent
  yesterday?
Did
 they work for you?

 Ann

  -Original Message-
  From: Jim Watkins [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, June 09, 2001 8:25 AM
  To: CF-Talk
  Subject: CFgraph on O'Reilly Website 3
 
 
  Does anyone run CF 5.0 on O'Reilly Website v.3 and get CFgraph
to
  draw
  graphs?  - Maybe that's my problem? If so what kind of file
associations
  should be set in Website?
 
  Jim Watkins
  http://www.ngtcollege.org
 
 
 

   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFgraph on O'Reilly Website 3

2001-06-10 Thread Jim Watkins

I have looked at all the log files displayed in CF 5 Administrator page.  No
clues.  Don't have a generator.log file that I can find.


- Original Message -
From: Deb Dickerson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 1:51 PM
Subject: RE: CFgraph on O'Reilly Website 3


 Have you tried looking at your log files (default-err.log,
 default-event.log, generator.log) to see if there are any errors being
 reported there?

 Deb

  -Original Message-
  From: Jim Watkins [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, June 09, 2001 1:12 PM
  To: CF-Talk
  Subject: Re: CFgraph on O'Reilly Website 3
 
 
  Thanks Ann
  I did try them and they are at:
  http://www.ngtcollege.org/graphtest3.cfm and
  don't work either.
 
  Jim
  - Original Message -
  From: Ann Harrell [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Saturday, June 09, 2001 11:29 AM
  Subject: RE: CFgraph on O'Reilly Website 3
 
 
   Jim did you try either of the corrected examples that I sent
yesterday?
  Did
   they work for you?
  
   Ann
  
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 09, 2001 8:25 AM
To: CF-Talk
Subject: CFgraph on O'Reilly Website 3
   
   
Does anyone run CF 5.0 on O'Reilly Website v.3 and get CFgraph to
draw
graphs?  - Maybe that's my problem? If so what kind of file
  associations
should be set in Website?
   
Jim Watkins
http://www.ngtcollege.org
   
   
   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



White Space

2001-06-10 Thread Jerry Staple

Hi 
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple
Web Applications Developer 
Biznet Solutions 
133 - 137 Lisburn Road 
Belfast 
BT9 7AG 
www.biznet-solutions.com 
[EMAIL PROTECTED]
Tel: +44 (0)28 90205652
Fax: +44 (0)28 9022 3223 



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: list and looping problems

2001-06-10 Thread David Shadovitz

Seamus,

Option #1: Simply delete everything in the database and then add everything in 
the new group list.  No need for updates.  You can get away with this because 
the new group list contains all of the fields (i.e. 2) in the database table, 
if I read you right.

Option #2: Remove items in-the-database-but-not-on-the-new-group-list *before* 
you loop over the list.  There are two ways to do this:
(a) Make a query for everything in the database table.  Loop over this query 
and see if the current row is in the new group list.  If not, delete it.
(b) If you can get all of the new group list's primary keys at once, you can do 
all of the deletions at once.  If GroupCode is the primary key:
  delete from tblGroupCopy where GroupCode not in (new-group-list-GroupCodes)

-David

On Thursday, June 07, 2001 Seamus Campbell [SMTP:[EMAIL PROTECTED]] wrote:
 However I cannot work out how to account for items originally on database but
 not on new group list i.e. groups that need to be deleted from original 
database
 after update process.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: White Space

2001-06-10 Thread Dick Applebaum


cfset string = ReReplace(String,  +,  , All)

HTH

Dick


At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
Hi
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: White Space

2001-06-10 Thread Dick Applebaum

Oops, you said white space, not space!

try

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset string = ReReplace(String, [#White#]+,  , All)




cfset string = ReReplace(String,  +,  , All)

HTH

Dick


At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
Hi
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: White Space

2001-06-10 Thread Joseph Thompson

The RE command set provides for a Space operator that should match tabs,
newlines, etc...

maybe:
cfset string = ReReplace(String, [space], , All)


 Oops, you said white space, not space!

 try

 cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
 cfset string = ReReplace(String, [#White#]+,  , All)



 
 cfset string = ReReplace(String,  +,  , All)
 
 HTH
 
 Dick
 
 
 At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
 Hi
 Could anyone tell me the Best way to strip out white space from a
 string??
 
 Much Appreciated
 Jerry Staple


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: White Space

2001-06-10 Thread Jerry Staple

Hi Dick

Ive tried the following code but to no avail:


cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset Questions = ReReplace(#OutputList.Question#, [#White#]+,  ,
All)


td height=10 width=25% background=white-rect.gif 
  div align=centerfont face=Arial, Helvetica, sans-serif
size=2font color=Blacknowrapb#Questions#/b/div
/td


Any Ideas

Cheers

Jerry


-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2001 11:19
To: CF-Talk
Subject: Re: White Space


Oops, you said white space, not space!

try

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset string = ReReplace(String, [#White#]+,  , All)




cfset string = ReReplace(String,  +,  , All)

HTH

Dick


At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
Hi
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: White Space

2001-06-10 Thread Jerry Staple

Hi Dick

Ive tried the following code but to no avail:


cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset Questions = ReReplace(#OutputList.Question#, [#White#]+,  ,
All)


td height=10 width=25% background=white-rect.gif 
  div align=centerfont face=Arial, Helvetica, sans-serif
size=2font color=Blacknowrapb#Questions#/b/div
/td


IE The question Output will be somrething Like Service Company in
ordewr to insert into a database i would like to replace with either
ServiceCompany or Service_Company


Any Ideas

Cheers

Jerry

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2001 11:19
To: CF-Talk
Subject: Re: White Space


Oops, you said white space, not space!

try

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset string = ReReplace(String, [#White#]+,  , All)




cfset string = ReReplace(String,  +,  , All)

HTH

Dick


At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
Hi
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: White Space

2001-06-10 Thread Dick Applebaum



Try

cfset White = #Chr(9)##Chr(10)##Chr(11)##Chr(12)##Chr(13)#
cfset Questions = ReReplace(#OutputList.Question#, [ #white#]*, ,All)

This will remove all spaces and white space.

Better for db insertion would be:

cfset Questions = ReReplaceNoCase(#OutputList.Question#, [^0-9A-Z_]*, ,All)

which kills all punctuation except the underscore.

HTH

Dick


At 11:42 AM +0100 6/10/01, Jerry Staple wrote:
Hi Dick

Ive tried the following code but to no avail:

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset Questions = ReReplace(#OutputList.Question#, [#White#]+,  ,
All)


td height=10 width=25% background=white-rect.gif
  div align=centerfont face=Arial, Helvetica, sans-serif
size=2font color=Blacknowrapb#Questions#/b/div
/td


IE The question Output will be somrething Like Service Company in
ordewr to insert into a database i would like to replace with either
ServiceCompany or Service_Company


Any Ideas

Cheers

Jerry

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2001 11:19
To: CF-Talk
Subject: Re: White Space


Oops, you said white space, not space!

try

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset string = ReReplace(String, [#White#]+,  , All)




cfset string = ReReplace(String,  +,  , All)

HTH

Dick


At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
Hi
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: list and looping problems

2001-06-10 Thread Seamus Campbell

many thanks -  (I actually have three tables to amend two of which have 
more than 2 fields).
I ended up doing this:
added three yes/no fields - one for update, one for insert, and one to say 
whether or not to show the entry
set all entries to No before an update/insert
then if an update set the update and show yes/no fields to Yes
and if insert set the insert and show yes/no fields to Yes
This seems to work quite well - I have no idea whether or not it is elegant 
or not.

Any opinions on this would be most welcome.

The only problem is that currently the update process updates anything that 
matches the ID code in both the old database and the new list. So I don't 
actually know if it has really been updated (ie not just overwritten).

I'm updating an existing site done in php and the previous program sent the 
owner back a list of titles inserted, updated, and deleted. These figures 
did not include titles that remained the same - I can't work out to do this 
- surely it would mean looping thru every field in every entry, which even 
if I could work how to do (which I can't) would seem like a huge amount of 
work???

The database is for a remainder (discounted) book distributor and quite 
often they will get the same books in again after 6 months or so; I thought 
that deleting entries would probably not be the way to go.
Also I thought that generally deleting entries from a database was not best 
practice???
Is this not frowned upon??

I'm actually having problems working out stuff with bulk updating/inserting 
- I can't find any tutorials or books that go into any details. Do you or 
anyone else know of anywhere I can learn more on this.
Again thanks for your help and any further help or suggestions are 
extremely welcome.

Seamus


At 07:18 pm 10/06/01 , you wrote:
Seamus,

Option #1: Simply delete everything in the database and then add 
everything in
the new group list.  No need for updates.  You can get away with this because
the new group list contains all of the fields (i.e. 2) in the database table,
if I read you right.

Option #2: Remove items in-the-database-but-not-on-the-new-group-list 
*before*
you loop over the list.  There are two ways to do this:
(a) Make a query for everything in the database table.  Loop over this query
and see if the current row is in the new group list.  If not, delete it.
(b) If you can get all of the new group list's primary keys at once, you 
can do
all of the deletions at once.  If GroupCode is the primary key:
   delete from tblGroupCopy where GroupCode not in (new-group-list-GroupCodes)

-David

On Thursday, June 07, 2001 Seamus Campbell [SMTP:[EMAIL PROTECTED]] wrote:
  However I cannot work out how to account for items originally on 
 database but
  not on new group list i.e. groups that need to be deleted from original
database
  after update process.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: White Space

2001-06-10 Thread Jerry Staple

Dick

Thats Just The Ticket!

Thanks Very Much

All the Best 
Jerry

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2001 12:35
To: CF-Talk
Subject: RE: White Space




Try

cfset White = #Chr(9)##Chr(10)##Chr(11)##Chr(12)##Chr(13)#
cfset Questions = ReReplace(#OutputList.Question#, [ #white#]*,
,All)

This will remove all spaces and white space.

Better for db insertion would be:

cfset Questions = ReReplaceNoCase(#OutputList.Question#, [^0-9A-Z_]*,
,All)

which kills all punctuation except the underscore.

HTH

Dick


At 11:42 AM +0100 6/10/01, Jerry Staple wrote:
Hi Dick

Ive tried the following code but to no avail:

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset Questions = ReReplace(#OutputList.Question#, [#White#]+,  ,
All)


td height=10 width=25% background=white-rect.gif
  div align=centerfont face=Arial, Helvetica, sans-serif
size=2font color=Blacknowrapb#Questions#/b/div
/td


IE The question Output will be somrething Like Service Company in
ordewr to insert into a database i would like to replace with either
ServiceCompany or Service_Company


Any Ideas

Cheers

Jerry

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2001 11:19
To: CF-Talk
Subject: Re: White Space


Oops, you said white space, not space!

try

cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)#
cfset string = ReReplace(String, [#White#]+,  , All)




cfset string = ReReplace(String,  +,  , All)

HTH

Dick


At 10:15 AM +0100 6/10/01, Jerry Staple wrote:
Hi
Could anyone tell me the Best way to strip out white space from a
string??

Much Appreciated
Jerry Staple

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Pulling email

2001-06-10 Thread Howie Hamlin

Yep, it does.  Thanks,

Howie

- Original Message - 
From: Dain Anderson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 2:36 AM
Subject: Re: Pulling email


 Howie,
 
 Oops. It should work now :-)
 
 Thanks,
 
 Dain Anderson
 Caretaker, CF Comet
 http://www.cfcomet.com/
 
 



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Can this be done? Flashy way??

2001-06-10 Thread Michael Lugassy

I'm trying to build a similiar mechanisem to Oddcast photomixer.
they use a very nice flash application that edit and run clips on the fly.
they supply a thumbnailed directory of images, cool list of songs
and a series of transitions between frames.

I'm intrested in building such an engine, I know CF is capable of talking
with Flash very easy, but I can't seem to find good objects/tags/snippets
that can help with my code.

if someone can point out on where I can find CF TAGS to build FLASH
stuff (I don't know FLASH AT ALL!) I'll be happy!

audio integration, visual effects, images, text, everything for a visual project
like this one.

please help.

Thanks,

Michael


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



simple flash procedure

2001-06-10 Thread Michael Lugassy

I'm trying to do a simlpe flash procedure now with Coldfusion ( I don't know flash at 
all!)
that will get a list of images (jpgs) I have locally on the hdd, a song I also have on 
the server (in which
format should I store it?) and the flash object will randomly change images while 
playing.

I'm trying to find a working object for flash that will require no special work and 
will throw
some nice effects on the animation playing.

anybody know anything?

Thanks,

Michael


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: simple flash procedure

2001-06-10 Thread Seth Turetsky

To the best of my knowledge, I don't think Flash can work dynamically like
that, since typically images and sounds have to be imported into Flash and
placed into the timeline before it is exported as a swf file(which is what
browsers can play).  Maybe Generator can do something like that?
Seth

- Original Message -
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 2:21 PM
Subject: simple flash procedure


 I'm trying to do a simlpe flash procedure now with Coldfusion ( I don't
know flash at all!)
 that will get a list of images (jpgs) I have locally on the hdd, a song I
also have on the server (in which
 format should I store it?) and the flash object will randomly change
images while playing.

 I'm trying to find a working object for flash that will require no special
work and will throw
 some nice effects on the animation playing.

 anybody know anything?

 Thanks,

 Michael



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Can this be done? Flashy way??

2001-06-10 Thread Steve Reich

 if someone can point out on where I can find CF TAGS to build FLASH
 stuff (I don't know FLASH AT ALL!) I'll be happy!

How about the CF_BuildFlashMovie tag? You just enter what you want the
application to do and pass it your experience level with Flash and it will
spit out a movie file and code for your page.

CF_BuildFlashMovie
specifications=I need it to build an application that will have audio
integration, visual effects, images, text, everything for a visual project.
Also must be able to edit and run clips on the fly
ExperienceLevel=I don't know FLASH AT ALL!) 

cfoutput#FullyFunctionalAndRobustFlashApplicationWithAllTheBellsAndWhistle
s#/cfoutput

You can download it at http://www.i-wish-it-was-that-easy.com ...

But seriously, Flash is much more than that. I would suggest you download
the Flash trial and play around with that. Once you have created your Flash
file, you can interact with it using CF, but this assumes you have an
existing flash application to begin with.

In playful jest...
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF5, cffile and cfcontent and deleting

2001-06-10 Thread Michael A. Cady

Hi Rich,

Windows NT Error 5 means that access to the file is denied because some
other process is using it.  My guess in your case is that your process that
serves up the CFCONTENT is the one that has the file open, therefore your
line of code which attempts to delete it can't because it is open.  When you
use CFFILE to delete the file it probably isn't in use (open).  Does this
make sense based on your code?

Does anyone know how to capture these types of errors from NT when working
with files?  I have a similar problem when a user views a file on the server
and then uploads a newer version with the same name (this is a requirement).
Sometimes NT doesn't release the first version fast enough and Error 5 is
thrown when the my code attempts to overwrite it with the newer version.
Any ideas?

Mike Cady

- Original Message -
From: Rich Wild [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 4:59 AM
Subject: CF5, cffile and cfcontent and deleting


 Got a bit of a query with CF5:

 If I try to serve a separate text file from a template via cfcontent and
 specify that the file must be deleted - an error is thrown:

 Error occurred while attempting to delete the file
 D:\development\text_server\this.txt

 Windows NT error number 5 occurred.

 However, I *can* delete the file using cffile

 Can anyone reproduce/confirm/explain this?

 ---
 Rich Wild
 Senior Web Designer

 ---
 e-mango.com ltd  Tel: 01202 587 400
 Lansdowne Place  Fax: 01202 587 401
 17 Holdenhurst Road
 Bournemouth   Mailto:[EMAIL PROTECTED]
 BH8 8EW, UK  http://www.e-mango.com
 ---
 This message may contain information which is legally
 privileged and/or confidential.  If you are not the
 intended recipient, you are hereby notified that any
 unauthorised disclosure, copying, distribution or use
 of this information is strictly prohibited. Such
 notification notwithstanding, any comments, opinions,
 information or conclusions expressed in this message
 are those of the originator, not of e-mango.com ltd,
 unless otherwise explicitly and independently indicated
 by an authorised representative of e-mango.com ltd.
 ---




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: setup HTTPS on local PC

2001-06-10 Thread SRetsky


--part1_dd.15d06787.28551ce9_boundary
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi:

I have https working fine on my web site, but I can't get it
to run on my local PC where I do development and testing.

When I try it now on my PC (https://testsite1/test1.cfm), I get:

IE:
The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be 
experiencing technical difficulties, or you may need to adjust your browser 
settings.

does anyone know the proper settings (IE  Netscape) to make this work?

thanks

Sandy


--part1_dd.15d06787.28551ce9_boundary
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: 7bit

HTMLFONT FACE=arial,helveticaFONT  SIZE=2Hi:
BR
BRI have https working fine on my web site, but I can't get it
BRto run on my local PC where I do development and testing.
BR
BRWhen I try it now on my PC (https://testsite1/test1.cfm), I get:
BR
BRIE:
BR/FONTFONT  COLOR=#00 SIZE=3 FAMILY=SANSSERIF FACE=Arial 
LANG=0BThe page cannot be displayed
BR/FONTFONT  COLOR=#00 SIZE=2 FAMILY=SANSSERIF FACE=Arial 
LANG=0/BThe page you are looking for is currently unavailable. The Web site might 
be 
BRexperiencing technical difficulties, or you may need to adjust your browser 
BRsettings.
BR
BRdoes anyone know the proper settings (IE amp; Netscape) to make this work?
BR
BRthanks
BR
BRSandy
BR/FONT/HTML

--part1_dd.15d06787.28551ce9_boundary--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: setup HTTPS on local PC

2001-06-10 Thread Duane Boudreau

To get the https protocal working locally you have to install an ssl key on
your machine

Duane

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, June 10, 2001 2:57 PM
 To: CF-Talk
 Subject: OT: setup HTTPS on local PC



 --part1_dd.15d06787.28551ce9_boundary
 Content-Type: text/plain; charset=US-ASCII
 Content-Transfer-Encoding: 7bit

 Hi:

 I have https working fine on my web site, but I can't get it
 to run on my local PC where I do development and testing.

 When I try it now on my PC (https://testsite1/test1.cfm), I get:

 IE:
 The page cannot be displayed
 The page you are looking for is currently unavailable. The Web
 site might be
 experiencing technical difficulties, or you may need to adjust
 your browser
 settings.

 does anyone know the proper settings (IE  Netscape) to make this work?

 thanks

 Sandy


 --part1_dd.15d06787.28551ce9_boundary
 Content-Type: text/html; charset=US-ASCII
 Content-Transfer-Encoding: 7bit

 HTMLFONT FACE=arial,helveticaFONT  SIZE=2Hi:
 BR
 BRI have https working fine on my web site, but I can't get it
 BRto run on my local PC where I do development and testing.
 BR
 BRWhen I try it now on my PC (https://testsite1/test1.cfm), I get:
 BR
 BRIE:
 BR/FONTFONT  COLOR=#00 SIZE=3 FAMILY=SANSSERIF
 FACE=Arial LANG=0BThe page cannot be displayed
 BR/FONTFONT  COLOR=#00 SIZE=2 FAMILY=SANSSERIF
 FACE=Arial LANG=0/BThe page you are looking for is
 currently unavailable. The Web site might be
 BRexperiencing technical difficulties, or you may need to
 adjust your browser
 BRsettings.
 BR
 BRdoes anyone know the proper settings (IE amp; Netscape) to
 make this work?
 BR
 BRthanks
 BR
 BRSandy
 BR/FONT/HTML

 --part1_dd.15d06787.28551ce9_boundary--

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFCONTENT Problem

2001-06-10 Thread Rich Z

I'm sure this problem has been addressed before, but here it is:
 
I'm trying to make a file available for download through CFCONTENT. The
cfm page send.cfm looks like this::
 
cfcontent type=unknown file=c:\archive\file.mp3 deletefile=No
 
The problem is, instead of sending that file, it sends the right file
but it names it send.cfm instead of the actual file name. 
 
Any idea how to resolve this?
 
Thanks,
Rich
 
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFCONTENT Problem

2001-06-10 Thread Duane Boudreau


If you are using NT with SP 6a:

add this to send.cfm

cfheader name=Content-Disposition value=attachment;
Filename=myfile.txt



 -Original Message-
 From: Rich Z [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, June 10, 2001 4:17 PM
 To: CF-Talk
 Subject: CFCONTENT Problem


 I'm sure this problem has been addressed before, but here it is:

 I'm trying to make a file available for download through CFCONTENT. The
 cfm page send.cfm looks like this::

 cfcontent type=unknown file=c:\archive\file.mp3 deletefile=No

 The problem is, instead of sending that file, it sends the right file
 but it names it send.cfm instead of the actual file name.

 Any idea how to resolve this?

 Thanks,
 Rich





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFCONTENT Problem

2001-06-10 Thread Dain Anderson

Give this a shot:

CFHEADER NAME=Content-Disposition VALUE=attachment; filename=file.mp3
CFCONTENT TYPE=unknown FILE=c:\archive\file.mp3 DELETEFILE=No

Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/



- Original Message -
From: Rich Z [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 4:17 PM
Subject: CFCONTENT Problem


 I'm sure this problem has been addressed before, but here it is:

 I'm trying to make a file available for download through CFCONTENT. The
 cfm page send.cfm looks like this::

 cfcontent type=unknown file=c:\archive\file.mp3 deletefile=No

 The problem is, instead of sending that file, it sends the right file
 but it names it send.cfm instead of the actual file name.

 Any idea how to resolve this?

 Thanks,
 Rich





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFTree form submittal

2001-06-10 Thread Aaron Rouse

How can a form be submitted via JavaScript when there is a CFTree in that
form and you are selecting nothing from that CFTree?  I simple
document.frm.submit(); does not work with Netscape, when you get to the
posting screen you get a Error resolving parameter TREE.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



ClickBank

2001-06-10 Thread Alii Design

Does anyone have any experience with integrating Clickbank into a CF app?
I haven't seen any examples or tags in the dev gallery.
Rich

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 10, 2001 4:46 PM
To: CF-Talk
Subject: CFTree form submittal


How can a form be submitted via JavaScript when there is a CFTree in that
form and you are selecting nothing from that CFTree?  I simple
document.frm.submit(); does not work with Netscape, when you get to the
posting screen you get a Error resolving parameter TREE.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Alter table

2001-06-10 Thread Mark Warrick

From the SQL documentation:

ALTER TABLE (T-SQL)
Modifies a table definition by altering, adding or dropping columns and
constraints, or by disabling or enabling constraints and triggers.

Syntax
ALTER TABLE table
{[ALTER COLUMN column_name
{new_data_type [ (precision[, scale] ) ]
[ NULL | NOT NULL ]
| {ADD | DROP} ROWGUIDCOL
}
]
| ADD
{[ column_definition ]
|  column_name AS computed_column_expression
}[,...n]
| [WITH CHECK | WITH NOCHECK] ADD
{ table_constraint }[,...n]
| DROP
{[CONSTRAINT] constraint_name
| COLUMN column
}[,...n]
| {CHECK | NOCHECK} CONSTRAINT
{ALL | constraint_name[,...n]}
| {ENABLE | DISABLE} TRIGGER
{ALL | trigger_name[,...n]}
}

column_definition ::= { column_name data_type }
[ [ DEFAULT constant_expression ]
| [ IDENTITY [(seed, increment ) [NOT FOR REPLICATION] ] ]
]
[ ROWGUIDCOL ]
[ column_constraint] [ ...n]

column_constraint ::= [CONSTRAINT constraint_name]
{
[ NULL | NOT NULL ]
| [{ PRIMARY KEY | UNIQUE }
[CLUSTERED | NONCLUSTERED]
[WITH FILLFACTOR = fillfactor]
[ON {filegroup | DEFAULT} ]]
 ]
| [[FOREIGN KEY]
REFERENCES ref_table [(ref_column) ]
[NOT FOR REPLICATION]
 ]
| CHECK [NOT FOR REPLICATION]
(logical_expression)
}


table_constraint ::= [CONSTRAINT constraint_name]
{[{ PRIMARY KEY | UNIQUE }
[ CLUSTERED | NONCLUSTERED]
{ ( column[,...n] ) }
[ WITH FILLFACTOR = fillfactor]
[ON {filegroup | DEFAULT} ]
]
|FOREIGN KEY
[(column[,...n])]
REFERENCES ref_table [(ref_column[,...n])]
[NOT FOR REPLICATION]
|DEFAULT constant_expression
[FOR column]
|CHECK [NOT FOR REPLICATION]
(logical_expression)
}

Arguments
table
Is the name of the table to be altered. If the table is not in the current
database or owned by the current user, the database and owner can be
explicitly specified.
WITH CHECK | WITH NOCHECK
Specifies whether the data in the table is or is not validated against a
newly added or reenabled FOREIGN KEY or CHECK constraint. If not specified,
WITH CHECK is assumed for new constraints, and WITH NOCHECK is assumed for
reenabled constraints.
If you do not want to verify new CHECK or FOREIGN KEY constraints against
existing data, use WITH NOCHECK. (This is not recommended except in rare
cases). The new constraint will be evaluated in all future updates. Any
constraint violations that are suppressed by WITH NOCHECK when the
constraint is added may cause future updates to fail if they update rows
with data that does not comply with the constraint.

Constraints defined WITH NOCHECK are not considered by the query optimizer.
These constraints are ignored until all such constraints are reenabled using
ALTER TABLE table CHECK CONSTRAINT ALL.

ALTER COLUMN
Specifies that the given column is to be changed or altered. ALTER COLUMN is
not allowed if the compatibility level is 65 or earlier. For more
information, see sp_dbcmptlevel. The altered column cannot be:
A column with a text, image, ntext, or timestamp data type.
The ROWGUIDCOL for the table.
A computed column or be used in a computed column.
A replicated column.
Used in an index, unless the column is a varchar or varbinary data type, the
data type is not changed, and the new size is equal to or larger than the
old size.
Used in statistics generated by the CREATE STATISTICS statement. First
remove the statistics using the DROP STATISTICS statement. Statistics
automatically generated by the query optimizer are automatically dropped by
ALTER COLUMN.
Used in a PRIMARY KEY or [FOREIGN KEY] REFERENCES constraint.
Used in a CHECK or UNIQUE constraint, except that altering the length of a
variable-length column used in a CHECK or UNIQUE constraint is allowed.
Associated with a default, except that changing the length, precision, or
scale of a column is allowed if the data type is not changed.
Some data type changes may result in a change in the data. For example,
changing an nchar or nvarchar column to char or varchar can result in the
conversion of extended characters. For more information, see CAST and
Convert. Reducing the precision and scale of a column may result in data
truncation.

column_name
Is the name of the column to be altered, added or dropped. For new columns,
column_name can be omitted for columns created with a timestamp data type.
The name timestamp is used if no column_name is specified for a timestamp
data type column.
new_data_type
Is the new data type for the altered column. Criteria for the new_data_type
of an altered column are:
The previous data type must be implicitly convertible to the new data type.
new_data_type cannot be timestamp.
ANSI null defaults are always on for ALTER COLUMN; if not specified, the
column is nullable.
ANSI padding is 

RE: CF 5 Cfgraph question

2001-06-10 Thread Michael Bruce


Yes
Pretty cool to. Use the URL and the URLcolumn attributes

-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 09, 2001 2:14 PM
To: CF-Talk
Subject: CF 5 Cfgraph question


Does CFGraph provide the ability to create drill-down Flash 
graphs similar to how PopChart does?

Regards,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFCONTENT Problem

2001-06-10 Thread Rich Z

Still happening. Is there something I need to do on the server side?

-Original Message-
From: Dain Anderson [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, June 10, 2001 4:38 PM
To: CF-Talk
Subject: Re: CFCONTENT Problem

Give this a shot:

CFHEADER NAME=Content-Disposition VALUE=attachment;
filename=file.mp3
CFCONTENT TYPE=unknown FILE=c:\archive\file.mp3 DELETEFILE=No

Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/



- Original Message -
From: Rich Z [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 4:17 PM
Subject: CFCONTENT Problem


 I'm sure this problem has been addressed before, but here it is:

 I'm trying to make a file available for download through CFCONTENT.
The
 cfm page send.cfm looks like this::

 cfcontent type=unknown file=c:\archive\file.mp3 deletefile=No

 The problem is, instead of sending that file, it sends the right file
 but it names it send.cfm instead of the actual file name.

 Any idea how to resolve this?

 Thanks,
 Rich





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFCONTENT Problem

2001-06-10 Thread Duane Boudreau

What is the WinNT SP?

Duane

 -Original Message-
 From: Rich Z [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, June 10, 2001 8:50 PM
 To: CF-Talk
 Subject: RE: CFCONTENT Problem
 
 
 Still happening. Is there something I need to do on the server side?
 
 -Original Message-
 From: Dain Anderson [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, June 10, 2001 4:38 PM
 To: CF-Talk
 Subject: Re: CFCONTENT Problem
 
 Give this a shot:
 
 CFHEADER NAME=Content-Disposition VALUE=attachment;
 filename=file.mp3
 CFCONTENT TYPE=unknown FILE=c:\archive\file.mp3 DELETEFILE=No
 
 Dain Anderson
 Caretaker, CF Comet
 http://www.cfcomet.com/
 
 
 
 - Original Message -
 From: Rich Z [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, June 10, 2001 4:17 PM
 Subject: CFCONTENT Problem
 
 
  I'm sure this problem has been addressed before, but here it is:
 
  I'm trying to make a file available for download through CFCONTENT.
 The
  cfm page send.cfm looks like this::
 
  cfcontent type=unknown file=c:\archive\file.mp3 deletefile=No
 
  The problem is, instead of sending that file, it sends the right file
  but it names it send.cfm instead of the actual file name.
 
  Any idea how to resolve this?
 
  Thanks,
  Rich
 
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFSTOREDPROC and performance question

2001-06-10 Thread Jon Hall

How about using BCP?

cfquery name=InsertInitial DATASOURCE=#DSN# USERNAME=#user#
PASSWORD=#pass#
BULK INSERT Table
FROM 'D:\FR\FileResource\101-200.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='
'
)
/cfquery

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ts_ba-bz_4fec.htm

jon

Marc Garrett wrote:

To the group:

I need to walk through about 11,000 records with 25 columns in a text file and insert 
them daily into a SQL Server database. Since I'm on a shared server, my templates 
need to execute in 180 seconds or less. 

If I use CFQUERY to insert row by row into the database, the query takes about 160 to 
200 seconds to complete. In an effort to boost performance, I wrote a stored 
procedure in SQL Server and called it via CFSTOREDPROC from CF. But the sp takes 
about 183 to 185 seconds to execute. 

Is this expected? Am I better off trying a query that simply calls the sp instead of 
using CFSTOREDPROC?

Thanks for any assistance.

Regards,

Marc Garrett




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: Possible virus warning

2001-06-10 Thread Zac

I received a very suspicious email from Pablo Varando 
[EMAIL PROTECTED] in response to one of my posts. The message has 
an attachment (hamster.zip.scr) that appears to be some sort of virus.

My email to Pablo asking for an explanation of this has gone unanswered 
so I thought, just to be safe, that I'd post a warning here.

It may be a case of his system being compromised and sending out these 
emails, or he just might have an odd sense of humour (I'm thinking the 
former) but if you do receive any unsolicited attachments from him I 
would consider it suspect and act accordingly.

--

History's third dimension is always fiction.

  Hermann Hesse

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFCONTENT Problem

2001-06-10 Thread Rich Z

I'm actually using Windows 2000 Server.

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, June 10, 2001 8:58 PM
To: CF-Talk
Subject: RE: CFCONTENT Problem

What is the WinNT SP?

Duane

 -Original Message-
 From: Rich Z [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, June 10, 2001 8:50 PM
 To: CF-Talk
 Subject: RE: CFCONTENT Problem
 
 
 Still happening. Is there something I need to do on the server side?
 
 -Original Message-
 From: Dain Anderson [mailto:[EMAIL PROTECTED]] 
 Sent: Sunday, June 10, 2001 4:38 PM
 To: CF-Talk
 Subject: Re: CFCONTENT Problem
 
 Give this a shot:
 
 CFHEADER NAME=Content-Disposition VALUE=attachment;
 filename=file.mp3
 CFCONTENT TYPE=unknown FILE=c:\archive\file.mp3 DELETEFILE=No
 
 Dain Anderson
 Caretaker, CF Comet
 http://www.cfcomet.com/
 
 
 
 - Original Message -
 From: Rich Z [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, June 10, 2001 4:17 PM
 Subject: CFCONTENT Problem
 
 
  I'm sure this problem has been addressed before, but here it is:
 
  I'm trying to make a file available for download through CFCONTENT.
 The
  cfm page send.cfm looks like this::
 
  cfcontent type=unknown file=c:\archive\file.mp3
deletefile=No
 
  The problem is, instead of sending that file, it sends the right
file
  but it names it send.cfm instead of the actual file name.
 
  Any idea how to resolve this?
 
  Thanks,
  Rich
 
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFSTOREDPROC and performance question

2001-06-10 Thread Aaron Rouse

Or DTS and you could schedule a Job to execute it whenever.  Could even use
DTS and then execute the package via a cfquery that is executed via a
cfschedule, but I would just keep it on the SQL Server side.

Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion

- Original Message -
From: Jon Hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 8:22 PM
Subject: Re: CFSTOREDPROC and performance question


 How about using BCP?

 cfquery name=InsertInitial DATASOURCE=#DSN# USERNAME=#user#
 PASSWORD=#pass#
 BULK INSERT Table
 FROM 'D:\FR\FileResource\101-200.csv'
 WITH
 (
 FIELDTERMINATOR=',',
 ROWTERMINATOR='
 '
 )
 /cfquery


http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ts_ba-bz
_4fec.htm

 jon

 Marc Garrett wrote:

 To the group:
 
 I need to walk through about 11,000 records with 25 columns in a text
file and insert them daily into a SQL Server database. Since I'm on a shared
server, my templates need to execute in 180 seconds or less.
 
 If I use CFQUERY to insert row by row into the database, the query takes
about 160 to 200 seconds to complete. In an effort to boost performance, I
wrote a stored procedure in SQL Server and called it via CFSTOREDPROC from
CF. But the sp takes about 183 to 185 seconds to execute.
 
 Is this expected? Am I better off trying a query that simply calls the sp
instead of using CFSTOREDPROC?
 
 Thanks for any assistance.
 
 Regards,
 
 Marc Garrett
 
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: setup HTTPS on local PC

2001-06-10 Thread Dan Phillips

Also make sure the certificate is not installed on the same network as your
local computer. I found out the hard way that this will cause a cert not to
work.

Dan Phillips
www.cfxhosting.com



-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 10, 2001 12:13 PM
To: CF-Talk
Subject: RE: setup HTTPS on local


To get the https protocal working locally you have to install an ssl key on
your machine

Duane

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, June 10, 2001 2:57 PM
 To: CF-Talk
 Subject: OT: setup HTTPS on local PC



 --part1_dd.15d06787.28551ce9_boundary
 Content-Type: text/plain; charset=US-ASCII
 Content-Transfer-Encoding: 7bit

 Hi:

 I have https working fine on my web site, but I can't get it
 to run on my local PC where I do development and testing.

 When I try it now on my PC (https://testsite1/test1.cfm), I get:

 IE:
 The page cannot be displayed
 The page you are looking for is currently unavailable. The Web
 site might be
 experiencing technical difficulties, or you may need to adjust
 your browser
 settings.

 does anyone know the proper settings (IE  Netscape) to make this work?

 thanks

 Sandy


 --part1_dd.15d06787.28551ce9_boundary
 Content-Type: text/html; charset=US-ASCII
 Content-Transfer-Encoding: 7bit

 HTMLFONT FACE=arial,helveticaFONT  SIZE=2Hi:
 BR
 BRI have https working fine on my web site, but I can't get it
 BRto run on my local PC where I do development and testing.
 BR
 BRWhen I try it now on my PC (https://testsite1/test1.cfm), I get:
 BR
 BRIE:
 BR/FONTFONT  COLOR=#00 SIZE=3 FAMILY=SANSSERIF
 FACE=Arial LANG=0BThe page cannot be displayed
 BR/FONTFONT  COLOR=#00 SIZE=2 FAMILY=SANSSERIF
 FACE=Arial LANG=0/BThe page you are looking for is
 currently unavailable. The Web site might be
 BRexperiencing technical difficulties, or you may need to
 adjust your browser
 BRsettings.
 BR
 BRdoes anyone know the proper settings (IE amp; Netscape) to
 make this work?
 BR
 BRthanks
 BR
 BRSandy
 BR/FONT/HTML

 --part1_dd.15d06787.28551ce9_boundary--

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFForms javaScript was Complimentary skill

2001-06-10 Thread Kay Smoljak

On Sat, 09 Jun 2001 13:23:23 -0700, Zac [EMAIL PROTECTED] wrote:

Does anyone have a link to a discussion of this? I've seen this being 
mentioned before and would be interested in any info about it.

An interesting discussion of this:
http://www.cftipsplus.com/

HTH,
K.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFForms javaScript was Complimentary skill

2001-06-10 Thread Zac


On Sunday, June 10, 2001, at 09:54 PM, Kay Smoljak wrote:

 An interesting discussion of this:
 http://www.cftipsplus.com/

Would you happen to have a URL to it? I couldn't find anything like an 
archive listing or even a search button on the site.

--

How do you spell relief?

C8 H10 N4 O2

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists