RE: CF's Most Wanted ::

2002-04-23 Thread Shawn Grover

On the topic of CFFILE and uploading, I would luv to see some kinda of
reliable, efficient tool to allow uploading of multiple files/folder
structures.

The only way to handle this currently is to either include multiple File
Input boxes on your form, or use a third party tool like AppletFile.  Doing
uploads of multiple files over HTTP would kill the server eventually (cuz
all uploads go to memory, until the server side code does something with
it).  I'm picturing a server side java applet with a listener port, and a
client side interface tool.  But these could both be triggered from a CFFile
tag somehow.

Maybe it's just wishful thinking on my part, but, that's the idea of this
thread isn't it?

Shawn Grover

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 9:44 AM
To: CF-Talk
Subject: Re: CF's Most Wanted ::


Hmmm why is this one going on so long. I realize that we have the
ever so useful cffile tag, but would like to see something on the
order of the cffile action=UPLOAD filefield=attachment ...
being integrated into cfmail and on another note I would LOVE to
see the ability for multiple attachments without using multiple
cfmail tags.




Success is a journey, not a destination!!



Doug Brown
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 7:09 AM
Subject: RE: CF's Most Wanted ::


 Already there:

 cffile action=UPLOAD filefield=attachment ...
 cfmail to=#to# from=#from# subject=#subject#
 mimeattach=#cffile.serverFile# 

 ---
 Billy Cravens


 -Original Message-
 From: Douglas Brown [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 22, 2002 6:05 PM
 To: CF-Talk
 Subject: Re: CF's Most Wanted ::

 You have to uplaod files to the server, before you can use them
in
 the mail tag Billy. That is unless your clients are using your
 server to send the files with.




 Success is a journey, not a destination!!



 Doug Brown
 - Original Message -
 From: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, April 22, 2002 3:16 PM
 Subject: RE: CF's Most Wanted ::


  Huh?  You can already attach files - and what would
server-side
 code be
  uploading to?
 
  ---
  Billy Cravens
 
 
  -Original Message-
  From: Douglas Brown [mailto:[EMAIL PROTECTED]]
  Sent: Monday, April 22, 2002 4:09 PM
  To: CF-Talk
  Subject: Re: CF's Most Wanted ::
 
  I would like to see an uplaod feature built in to cfmail for
  attachments!!!
 
 
 
  Success is a journey, not a destination!!
 
 
 
  Doug Brown
  - Original Message -
  From: Matthew Walker [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, April 22, 2002 2:00 PM
  Subject: Re: CF's Most Wanted ::
 
 
   I'd like to see custom tags able to tell CF to process the
 code
  inside. Some
   tags do, like cfoutput and cfquery, while some don't like
  cfloop. I'd like
   to be able to do this too with my custom tags without having
 to
  plonk ugly
   cfoutput tags inside each invocation.
  
  
   - Original Message -
   From: Tyler Silcox [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Tuesday, April 23, 2002 2:05 AM
   Subject: CF's Most Wanted ::
  
  
(Features, that is...)
   
With all this talk of learning other languages to flesh
out
  your
   portfolio, and more importantly your knowledge, along with
the
  looming
   release of NEO/CFMX, I've been trying to think of the
features
  that I
   currently miss in my ColdFusion.  And I thought what better
 way
  to get
   Macromedia's attention, then by creating a heated discussion
  among the
   leading, path-forging cf users, which obviously reside on
this
  list (yes,
   I'm buttering you up.)
   
It seams to me that we see some of the same issues
puzzling
  new or
   begginer users over and over again, or some great features
 that
  are
   available though creative uses of custom tags are not
readily
  available to
   those developers hosting on shared servers.  And I feel that
 MM
  could easily
   add some nice new tags or attributes to current tags that
 solve
  most
   everyone's problems (and I know nothing is that easy, but
 it'd
  be nice.)
   I also know most of us have submitted feature requests on
MM's
  site, but the
   community never really geats to chime in.  So what I'd like
to
  do is gather
   up a few of your ideas for improving ColdFusion just to let
MM
  know what
   we're are thinking.  I'm also very interested in what other
  developers are
   thinking, and I'm sure y'all are too.
   
I know that timing probably isn't the best for their very,
  very busy
   brains over in MM land right now, but there really isn't
 anytime
  better than
   the present.
   
Here's some of the basic probelms that I've come across
and
  that I've seen
   pop up on this list over and over from the last couple of
 years:
   
cfmail/cfpop:
Needs more stability, more power, ability to read

RE: CF's Most Wanted ::

2002-04-23 Thread Shawn Grover

In terms of standards, I agree.  If a standard already exists that does the
job, then it should not be changed.

However, the HTTP upload standard is slightly flawed.  Or at least the
current implementations of it are.  If I upload a 100 Megabyte file (and
there are occasional cases where this is needed), then the server MUST have
100 Megabytes of available memory.  Now tie that upload in with other common
uploads of 1 or two meg a piece, and the server very quickly runs out of
resources.

We have written a client communiation tool that allows file uploads.  The
biggest request we get for improvements is to allow multiple file selection,
and/or selection of a folder and upload it's contents recursively.  In this
type of situation, where the files in question range from  1 Meg to  20
Meg, we would crash our server very quickly - because of the way HTTP Upload
works.  As a result, we have limited the system to one file at a time.

My two cents worth.

Shawn Grover

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 10:25 AM
To: CF-Talk
Subject: Re: CF's Most Wanted ::


Shawn Grover wrote:
 On the topic of CFFILE and uploading, I would luv to see some kinda of
 reliable, efficient tool to allow uploading of multiple files/folder
 structures.

 The only way to handle this currently is to either include multiple File
 Input boxes on your form, or use a third party tool like AppletFile.
Doing
 uploads of multiple files over HTTP would kill the server eventually (cuz
 all uploads go to memory, until the server side code does something with
 it).  I'm picturing a server side java applet with a listener port, and a
 client side interface tool.  But these could both be triggered from a
CFFile
 tag somehow.

No thank you :)

IMHO, for maximum usability across clients and servers (and firewalls),
the only protocol that should be used for communication between the
client and the server is HTTP. I would be perfectly happy if the W3C
just added a new attribute to input type=file. That attribute should
be optional and have the name multiple and be a true/false field, with
the default to false.

The effect should be that people can simply select multiple files or
even folders when uploading, but the uploading still happens exactly as
it is done now through HTTP.
This is an entirely client side matter, I would imagine that with any
reasonably advanced Java or even Flash plugin this would already be
possible. On the server side, no changes will be needed, sine HTTP
already allows for multiple file uploads in one request.

I hope that you will all agree with me that employing (propietary?)
non-default protocols for something that can be easily handled by HTTP
is a practice from the previous century.

Jochem


__
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



IIS Configuration? (was RE: CF's Most Wanted ::)

2002-04-23 Thread Shawn Grover

With the below messages in mind, is there any way to configure IIS to spool
form data to disk, rather than memory? specifically the File Form elements.

Thanks

Shawn Grover

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 11:16 AM
To: CF-Talk
Subject: RE: CF's Most Wanted ::


 However, the HTTP upload standard is slightly flawed. Or
 at least the current implementations of it are. If I
 upload a 100 Megabyte file (and there are occasional
 cases where this is needed), then the server MUST have
 100 Megabytes of available memory. Now tie that upload
 in with other common uploads of 1 or two meg a piece,
 and the server very quickly runs out of resources.

That doesn't have anything to do with HTTP. That's purely an implementation
issue. There's no reason why data can't be spooled to disk rather than
stored in memory.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


__
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: IIS Configuration? (was RE: CF's Most Wanted ::)

2002-04-23 Thread Shawn Grover

And I don't recall any setting in CF Administrator (or IIS) that allows you
to specify if form data is stored to disk or memory.  Am I missing something
here?

I know my server side CF page can use CFFile to write an uploaded file to
disk, but the file resides in memory until my CF page is executed.

i.e.
1) Client Side Web page
2) Posts to server
3) File is uploaded to server via HTTP
4) file is stored in memory until it is fully uploaded
5) action page is then loaded/executed
6) File is transferred from memory to disk via CFFILE.

If I can switch the server to store files to disk rather than memory, then I
can eliminate the Out Of Resources errors I've been getting when dealing
with large files (in my case 60+ Meg - due to the amount of memory we've put
on that server).

Shawn Grover

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 11:38 AM
To: CF-Talk
Subject: RE: IIS Configuration? (was RE: CF's Most Wanted ::)


 With the below messages in mind, is there any way to
 configure IIS to spool form data to disk, rather than
 memory? specifically the File Form elements.

When you POST data to a CF page, I think that IIS simply hands off the
entire request to CF, which is then responsible for where the data is
stored.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


__
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: CFLOOP problem with commas

2002-04-23 Thread Shawn Grover

change your delimiter.

cfloop index=ListOfURLs list= #URL1#||#URL2# delimiter=||

that should solve the problem. (it's off the top of my head, so could be a
little wrong).

Shawn Grover


-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 2:25 PM
To: CF-Talk
Subject: CFLOOP problem with commas


I am trying to CFLOOP through a collection of URLs. The problem comes
from the fact that there are commas in some of the URLs. To illustrate
the problem, my code is as follows:

CFSET URL1=
http://www.foobar.com/selector/en/prodselect.asp?Xcntry=USAXlang=en_US
error=novars

CFSET URL2=
http://www.foobar.com/SRVS/CGI-BIN/WEBCGI.EXE?New,Kb=x_main_en,Company=
{7C4ED4E1-1DE9-46A0-BC3E-BE1C2FA9E9C9},varset=Xlang:en_US,varset=Xcntry:
USA,varset=prodID:DC220DC

cfloop index=ListOfURLs list= #URL1#, #URL2#
cfoutput
#ListofUrls#
/cfoutput
hr
/cfloop


THIS OUTPUTS THE FOLLOWING:

http://www.foobar.com/selector/en/prodselect.asp?Xcntry=USAXlang=en_US;
error=novars


 http://www.foobar.com/SRVS/CGI-BIN/WEBCGI.EXE?New


Kb=x_main_en


Company={7C4ED4E1-1DE9-46A0-BC3E-BE1C2FA9E9C9}


varset=Xlang:en_US


varset=Xcntry:USA


varset=prodID:DC220DC




As you can see, the first URL outputs normally, but the second URL
breaks at every comma. Is there a way around this? I don't want to
insert Chr() codes if I can help it!



__
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: CF's Most Wanted ::

2002-04-22 Thread Shawn Grover

I have found a need for this type of ability again and again. Something as
simple as determining the size of the image (hieght and width) before
displaying it, to determine if resizing needs to be done.  Now, if I ALWAYS
have access to the CF Server in question, then it isn't a problem to use
CFX_Image.  However, a number of the sites I manage are hosted on 3rd party
servers, which DO NOT allow me to install and use CFX tags, or DLLs.

End result is that I need to either find creative ways around the issue
(i.e. specify the width of an image, but not the height, so that it gets
dynamically resized when rendered), or I need to cripple my sites in small
ways.  We all know that workarounds are NOT the best solution, and crippling
a site is never a good solution.  But unless I have control of the server,
what choice do I have?

Having a native CFIMAGE tag which could handle this would most definetly
alleviate this issue.  But I'm sure care must be taken not to bloat the core
functionality of CF with too many goodies.

My thoughts, not yours

Shawn Grover

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 8:18 AM
To: CF-Talk
Subject: RE: CF's Most Wanted ::


 Abilty to resize images on the fly, store in cache, read
 dimensions, etc.
 (should be a cinch with Macromedia's expertise in graphic
 products [yea, right])

There are plenty of CFX tags out there that do this. I'm not saying we
shouldn't do it - just that solutions exist already. :)


__
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



RE: RecordCount is 0 en Stored Procedure

2002-04-18 Thread Shawn Grover

If it's SQL Server, you can do it like this:


 SELECT UserName FROM EkSelfAssRpts
WHERE  UserName=@UsernameAux AND
FirstName=@FirstNameAux  AND Title=@TitleAux

if @@RowCount = 0
begin
... do your action ...
end

Just keep in mind you have to check @@RowCount (and @@Error) immediately
after the operation in question - the next command resets these values.

Shawn Grover

-Original Message-
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:31 AM
To: CF-Talk
Subject: RecordCount is 0 en Stored Procedure


Hi all:
I got this query in transac-SQL.
I would like to know when the result recorset is 0.
I wrote this tricky code down here but I think is
wrong.
Any ideas??.
Thanks in advance friends.
Mario


 SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts
WHERE  UserName=@UsernameAux AND
FirstName=@FirstNameAux  AND Title=@TitleAux

IF  @Count=0
 BEGIN
  /*Here I write my action*/
 END


_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

__
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



CF Studio - Split for two different files?

2002-04-18 Thread Shawn Grover

Is it possible to view two different files at the same time?  Without having
to use the selection tabs
Kinda like the Window Split function

Haven't seen any reference to this capability, but I could be wrong

Shawn Grover

__
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



CFTransaction Rollback on error?

2002-04-16 Thread Shawn Grover

I have a custom tag that handles errors for us.  I added these lines of code
to the tag to do a rollback, if an error occurs and a transaction is in the
process:

!--- If we are in a transaction, do a rollback ---
cfif ListFindNoCase(getbasetaglist(),CFTRANSACTION) gt 0
cftransaction action=ROLLBACK/
/cfif

However, I keep getting an error saying the rollback MUST be between
cftransaction action=begin and /cftransaction tags.

My custom tag eventually does a cfabort if an error occurs (after
displaying appropriate messages).  Is that where the problem is?  If so, do
I need to do an explicit rollback like this?

Any suggestions are appreciated.  Thank you.

Shawn Grover

__
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



RE: INPUT checkboxes

2002-04-16 Thread Shawn Grover

You haven't indicated if the checkboxes are checked.  If not, then no value
gets passed for them - Only checked boxes get passed when the form is
submitted.  I would use CFPARAM on the processing page to set default
values, then check those values (if needed) before processing.

Shawn Grover

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 17:15
To: CF-Talk
Subject: Re: INPUT checkboxes


Hi,

I need to pass all the boxes checked to another template but the below only
passes the first one?

 input class=formbuttons type=checkbox name=mcp
value=mcpMust Change Passwordbr
 input class=formbuttons type=checkbox name=ccp
value=ccpCannot Change Passwordbr
 input class=formbuttons type=checkbox name=pne
value=pnePassword Never Expiresbr
 input class=formbuttons type=checkbox name=ad
value=adAccount Disabled




+---
+

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+




__
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: CFTransaction Rollback on error?

2002-04-16 Thread Shawn Grover

Nope, got the same error.  Thanks though.

Any other ideas/insight?

Shawn Grover

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:23 AM
To: CF-Talk
Subject: Re: CFTransaction  Rollback on error?


Just before the CFABORT, try placing the CFTRANSACTION check in again and
close the transaction if there is one open.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 12:17 PM
Subject: CFTransaction  Rollback on error?


 I have a custom tag that handles errors for us.  I added these lines of
code
 to the tag to do a rollback, if an error occurs and a transaction is in
the
 process:

 !--- If we are in a transaction, do a rollback ---
 cfif ListFindNoCase(getbasetaglist(),CFTRANSACTION) gt 0
 cftransaction action=ROLLBACK/
 /cfif

 However, I keep getting an error saying the rollback MUST be between
 cftransaction action=begin and /cftransaction tags.

 My custom tag eventually does a cfabort if an error occurs (after
 displaying appropriate messages).  Is that where the problem is?  If so,
do
 I need to do an explicit rollback like this?

 Any suggestions are appreciated.  Thank you.

 Shawn Grover



__
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: CFTransaction Rollback on error?

2002-04-16 Thread Shawn Grover

Yep.  Something like this:

cftransaction action=Begin
cftry
cfquery name=SomeUpdate...

/cfquery

!--- The Error Handler handles any controled errors ---  
 cfmodule
template=MyErrorHandler.cfm...

cftransaction action=commit
cfcatch type=Database
!--- The Error Handler also takes care of unhandled errors 
---
cfmodule template=MyErrorHandler.cfm ...
/cfcatch
/cftry
/cftransaction

Error Handler Code is similar to this (the parts that matter for this
discussion... grins):

cfif ErrorExists
cfif ListFindNoCase(GetBaseTagList(), CFTRANSACTION) gt 0
cftransaction action=rollback
/cfif

cfabort
/cfif

But, I get the error I initially reported on the Rollback line.

Hope that helps some.

Shawn Grover

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 11:29 AM
To: CF-Talk
Subject: Re: CFTransaction  Rollback on error?


You are using action=begin on the opening CFTRANSACTION call right?

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 1:28 PM
Subject: RE: CFTransaction  Rollback on error?


 Nope, got the same error.  Thanks though.

 Any other ideas/insight?

 Shawn Grover

 -Original Message-
 From: Justin Scott [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 16, 2002 10:23 AM
 To: CF-Talk
 Subject: Re: CFTransaction  Rollback on error?


 Just before the CFABORT, try placing the CFTRANSACTION check in again and
 close the transaction if there is one open.

 -Justin Scott, Lead Developer
  Sceiron Internet Services, Inc.
  http://www.sceiron.com


 - Original Message -
 From: Shawn Grover [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, April 16, 2002 12:17 PM
 Subject: CFTransaction  Rollback on error?


  I have a custom tag that handles errors for us.  I added these lines of
 code
  to the tag to do a rollback, if an error occurs and a transaction is in
 the
  process:
 
  !--- If we are in a transaction, do a rollback ---
  cfif ListFindNoCase(getbasetaglist(),CFTRANSACTION) gt 0
  cftransaction action=ROLLBACK/
  /cfif
 
  However, I keep getting an error saying the rollback MUST be between
  cftransaction action=begin and /cftransaction tags.
 
  My custom tag eventually does a cfabort if an error occurs (after
  displaying appropriate messages).  Is that where the problem is?  If so,
 do
  I need to do an explicit rollback like this?
 
  Any suggestions are appreciated.  Thank you.
 
  Shawn Grover
 
 



__
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: Looking for fast, reliable and potentially cheap CF Hosting

2002-04-16 Thread Shawn Grover

I agree - you get what you pay for.  However, www.readyhosting.com has
excellent rates, CF and SQL Support, and a ton of other advantages.  I have
a client with two sites on there, and have experienced almost no problems
that weren't code related.

My thoughts, not yours

Shawn Grover

-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 2:01 PM
To: CF-Talk
Subject: RE: Looking for fast, reliable and potentially cheap CF Hosting


One thing to watch.  What you pay for is what you get.  If its almost to
cheap.thats because it is. What do you want reliable or
cheap(note this has nothing to do with mirhouse just simply a reply to
the first post...)

 [EMAIL PROTECTED] 04/16/02 03:37PM 
http://www.mirhouse.com/

Rick

-Original Message-
From: slurpy slurpy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 2:36 PM
To: CF-Talk
Subject: Looking for fast, reliable and potentially cheap CF Hosting


Hi guys,

I've just finish a small web site for one of my clients. Need good and
reliable hosting. The site is very small and there are small access DB
currently MS Access, however will be glad if could switch to MS SQL. Any
suggestions regarding the quality as well as pricings of such hosting are
welcome.

Thank you, Slurpy.



-
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax



__
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



RE: Help needed - More client variable weirdness

2002-04-13 Thread Shawn Grover

No, our server is an internal development server.  However, the target
platform will use SSL.  Anything special I should know about in that case?


-Original Message-
From: J L [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 10:13 PM
To: CF-Talk
Subject: Re: Help needed - More client variable weirdness


Just curious.. are you using SSL?
___
Get the FREE email that has everyone talking at
http://www.mail2world.com

-Original Message-

 From: Shawn Grover
 Sent: 4/12/2002 6:16:18 PM
 To: [EMAIL PROTECTED]
 Subject: Help needed - More client variable weirdness

 Looking for ideas here, cuz I'm fresh out.

 Using a SQL Server 2000 database to store the client variables. On my
 computer, I can log into our web app, and see NEW record/CFID for me.
When I
 log out - which is meant to clear/remove the client variables, my
record is
 deleted - as it should be.

 On a different workstation, as a different user we see different
behaviour
 (only this one workstation). When logging out, the client variables
are
 zeroed/set to defaults - whereas the record should be deleted. When
the
 user logs in again, they get the same CFID/CFToken, and this record is
 reused.

 In Application.CFM, I convert the CFID and CFToken cookies to be
memory
 based cookies. So, if all browsers are closed, and the user then opens
a
 new browser and tries to login, they should get a different
CFID/CFToken.

 The workstation in question has IE 5.5, with the latest security
patchs. We
 have tried deleting the cookie for our domain as well, with the same
 results.

 This is getting annoying because the developer will do work, get
something
 functional on his box, and mark it as done. Yet when another of us
tries to
 use the code, it fails - and we've tracked it down to a client
variable
 issue.

 Any suggestions? Thanks in advance.

 Shawn Grover



__
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: Access table record limit?

2002-04-12 Thread Shawn Grover

I once worked with an Access DB that would hit 100K + records in one table
on a regular basis.  It performed fine.  However, it was a rather
speciallized app, and I think it was primarily doing inserts into the table.
But, I did need to reference the table to extract information through a
second application - never had any problems with the table.

HTH.

Shawn Grover

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 7:40 AM
To: CF-Talk
Subject: Access table record limit?


Does anyone know what a practical limit of records should be in an Access
table? The reason I ask is that I have a table for a feature I am
implementing that with some really broad estimates of mine could hit 20,000
records in a year of heavy usage (for this app, which really wouldn't be
heavy usage relatively speaking...). Any higher than that and I'd insist on
SQL Server for performance. This particular table has just 4 fields, and is
nicely indexable... I've seen some outrageous Access databases in my time
that worked, but I can't remember if I've seen 20k records in one table.

jon


__
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: Preventing SQL injection attacks...?

2002-04-12 Thread Shawn Grover

I haven't used this tag, but did write an in-house UDF that is called in
Application.cfm.  It simply loops through all form, url, and cookie
parameters and replaces a single quote with chr(96) (hope I got that right),
and strips HTML tags.  It would be very easy to change this to also strip
out semi-colons.  The logic/code required is very simple to do.  There's a
few samples of stuff like this at www.cflib.org.

This is a filtering method, and may not catch everything, but with this, and
our use of stored procs where we can, and CFQUERYPARAM, I don't think we are
open to this attack.  hmmm... I better go test that to be sure grins

Shawn Grover

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 10:53 AM
To: CF-Talk
Subject: Re: Preventing SQL injection attacks...?


There is a custom tag... cf_formfilter on the developers exchange that
I've been using... It searches the caller.form.fieldnames structure looking
for all sorts of nasty includes.

After just reading it again I think I can also make it filter url submitted
input as well.

Anyone here use or have comments on this tags limitations? Was an easy first
step for me but I am suddenly worried about url hacks as well.

Brian



At 08:17 AM 4/12/02 -0700, you wrote:
Hi all,

Had some interesting errors in our logs yesterday. It appears that
someone's
trying to hack our database by inserting SQL query language into the URL
string.

We're doing all the standard security measures, including filtering for
single quotes, using database passwords, and the like, and we locked out
their IP immediately. But really, how do you prevent this? Any
ideas/feedback out there?

Ian

Portent Interactive
Helping clients build customer relationships on the web since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com



__
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



Help needed - More client variable weirdness

2002-04-12 Thread Shawn Grover

Looking for ideas here, cuz I'm fresh out.

Using a SQL Server 2000 database to store the client variables. On my
computer, I can log into our web app, and see NEW record/CFID for me. When I
log out - which is meant to clear/remove the client variables, my record is
deleted - as it should be.

On a different workstation, as a different user we see different behaviour
(only this one workstation).  When logging out, the client variables are
zeroed/set to defaults - whereas the record should be deleted.  When the
user logs in again, they get the same CFID/CFToken, and this record is
reused.

In Application.CFM, I convert the CFID and CFToken cookies to be memory
based cookies.  So, if all browsers are closed, and the user then opens a
new browser and tries to login, they should get a different CFID/CFToken.

The workstation in question has IE 5.5, with the latest security patchs.  We
have tried deleting the cookie for our domain as well, with the same
results.

This is getting annoying because the developer will do work, get something
functional on his box, and mark it as done.  Yet when another of us tries to
use the code, it fails - and we've tracked it down to a client variable
issue.

Any suggestions?  Thanks in advance.

Shawn Grover

__
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
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



InTransaction Function?

2002-04-12 Thread Shawn Grover

I'm sure I've seen this topic before, but can't seem to find anything in the
archives, or through a google search...

Is it possible to dynamically determine if the code being processed is in
the middle of a CFTransaction?

For instance:
cftransaction action=begin
cfquery/
cfif InTransaction
 Show Message
/cfif
/cftransaction

I make a call to a custom Error Handler tag in a transaction, and need to
know if a RollBack needs to be done or not.  I'd rather not have to create a
new attribute/flag for the custom tag, if it's not needed.

Thanks.

Shawn Grover


__
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: Help! How can I extract a form from a webpage?

2002-04-11 Thread Shawn Grover

The Form names are URL parameters, if the form is submitted with the GET
method.

So, you can just scan through your Query_String for the name/value pairs.

This can be done by looping through the URL elemetents (in cfscript
something like for( field in url )), or by parsing the parameters as a
list.

HTH

Shawn Grover

-Original Message-
From: Ernie Pena [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 1:46 PM
To: CF-Talk
Subject: Help! How can I extract a form from a webpage?


I know using the cfhttp I can grab the page but how can I get all the input
box field names from the content that was returned via a get?


Ernie Pena
Sr. CF Developer
M.D. ANDERSON



__
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



DBVARName in CFStoredProcs

2002-04-10 Thread Shawn Grover

Just want a quick clarification.  Over the last few days I've seen a few
posts regarding stored procs.  These posts were specifiying the dbarname
parameter like so:  DBVARNAME=ParamName.

My own experience says the  symbol is not required, and can sometimes cause
problems.  Am I wrong in this?  Is there a prefered method with regards to
this?

Thanks In Advance

Shawn Grover

__
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
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



Client Variable Weirdness

2002-04-10 Thread Shawn Grover

We are using client vars for various things.  One of our develpment boxes
handles things differently for some reason, so I'm looking for ideas on how
to resolve this.

We have code in application.cfm to convert the CFID and CFTOKEN to memory
based cookies (so that they get destroyed when all browser instances are
closed).  This should mean that the next time a browser window is opened
(without any others being opened first), a new CFID and CFTOKEN are created.
And if that is the case, then a new set of client variables are created for
the new CFID.

However, this one workstation always gets the same CFID/CFTOKEN.  We know
this because it will consistently come up with client variables/values which
should not exist yet.

Any ideas what to look for on this workstation?  The cookie settings are the
same as the other workstations.  Or maybe our understanding of how the
client variables are handled is wrong?

Thanks for any insight

Shawn Grover

__
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: Coldfusion function

2002-04-10 Thread Shawn Grover

Or an include file... if your template makes use of CF Tags and client
output.  UDFs are good in most cases, and include files are good in others.
Look at your needs and make a judgement call

Shawn Grover

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:23 PM
To: CF-Talk
Subject: RE: Coldfusion function


UDF's my friend.  Of course you must have CF5. Check out cflib.org for some
good examples of user defined functions.

Kevin


-Original Message-
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:19 PM
To: CF-Talk
Subject: Coldfusion function

Hi All:
I'm coming today with perhaps a silly question.
I have a complete template and I want to reuse its
functionality .
My question is : Is there anyway to create functions
in coldfusion??
If so , which is the best option??
My function would only takes two parameters.
Thanks in advance friends.
Mario

 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
 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

_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com


__
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: Concatanation (THANKS)

2002-04-10 Thread Shawn Grover

one minor flaw with that routine  you are limited to one record per
file.  If you need to associate multiple records to a single file, or a
single file to multiple records, then you will need a cross reference table
(i.e. FileID, RecordID)

But even worse yet, if your file can be associated with multiple records in
multiple tables (where a file can be referenced from an image table, and a
download table for instance), then you need include a table pointer of some
sort:
(i.e. FileID, TableName, RecordID)

HTH

Shawn Grover

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:48 PM
To: CF-Talk
Subject: RE: Concatanation (THANKS)


THANKS!! Went with that route. Much easier than what I was trying to
attempt.

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:43 PM
To: CF-Talk
Subject: Re: Concatanation


I would have an extra table to associate files uploads with the record (i.e.
Filename_ID,record_ID,
filename).  For each upload grab the name of the file uploaded (server.file
if memory serves) and
store it in the new table along with the record_ID in question.  Then to
display lateer you can just
grab all filenames associated with a given record ID.

HTH

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: James Taavon [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 12:36 PM
Subject: Concatanation


 Is it possible to concatenate multiple file uploads within the same field
in
 a database in order to list all files uploaded for a particular record?
How
 would it be done?




__
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: Coldfusion function

2002-04-10 Thread Shawn Grover

I agree with Billy.  Custom tags offer the most in terms of flexibility and
portability.  There are some minor gotcha's with them, but as long as you
treat them as a descrete function (i.e. it 'kinda' spawns a new thread (no
new thread really, but doesn't have access to all the resources the calling
page does - unless you code for it), then you should be fine.

If you're familiar with custom tags, then you're well on your way.  If not,
then you're about to see how flexible CF can be  grins

One thing I try to do is to NOT use the REQUEST scope just so a variable is
available in a custom tag.  That's equivalent to making your variables
global, and that can lead to all kinds of other headaches.  I prefer passing
my information to the custom tag as an Attribute.  However, that said, there
are always exceptions to the rule...

My two cents worth

Shawn Grover

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:56 PM
To: CF-Talk
Subject: RE: Coldfusion function


An include file is the same thing as the code being inline - so if you set a
variable before the include, it's available to the included template.

However, for cleaner encapsulation, I'd go the custom tag route.

---
Billy Cravens


-Original Message-
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:51 PM
To: CF-Talk
Subject: RE: Coldfusion function

I got CF4.5 so , I think I can not use UDF's .
An include file allow me to pass parameters??.
Creating a custom tag could work???.
Any other choice??
Thanks for replying
Mario




--- Shawn Grover [EMAIL PROTECTED] escribió: 
Or an include file... if your template makes use of
 CF Tags and client
 output.  UDFs are good in most cases, and include
 files are good in others.
 Look at your needs and make a judgement call

 Shawn Grover

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 10, 2002 2:23 PM
 To: CF-Talk
 Subject: RE: Coldfusion function


 UDF's my friend.  Of course you must have CF5. Check
 out cflib.org for some
 good examples of user defined functions.

 Kevin


 -Original Message-
 From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 10, 2002 3:19 PM
 To: CF-Talk
 Subject: Coldfusion function

 Hi All:
 I'm coming today with perhaps a silly question.
 I have a complete template and I want to reuse its
 functionality .
 My question is : Is there anyway to create functions
 in coldfusion??
 If so , which is the best option??
 My function would only takes two parameters.
 Thanks in advance friends.
 Mario

  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
  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


_
 Do You Yahoo!?
 Información de Estados Unidos y América Latina, en
 Yahoo! Noticias.
 Visítanos en http://noticias.espanol.yahoo.com






__
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
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



Handle concurrency issues without stored procedures?

2002-04-10 Thread Shawn Grover

Can anyone give me an idea how to handle concurrent updates when using
CFQUERY?

What we normally do in a stored procedure is to add the LastUpdate date/time
value to the where clause, then check the RowCount to see if zero rows
were affected (if so, then it's a good bet the date changed, which means
someone else has updated the record), and then either raise a SQL error, or
return a specific value to be intercepted with CFStoredProc.StatusCode.

However, we are in a situation where stored procs are not being used.  And
with CFQuery, we can't use return codes, and even doing multiple updates is
troublesome (having to use SET NOCOUNT ON/OFF).

So, I'm looking for ideas.  I think we have a method to handle it, but want
to see what others are doing for this situation.

Thanks.

Shawn Grover

__
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



Where is the best place to put business rules?

2002-04-02 Thread Shawn Grover

We need to determine where the best place to put our business rules is.
I'm favouring Stored Procedures, while another developer is favouring CF
code (on the action pages).  But we are looking for objective comments on
the pros and cons.

The situation is as follows:
We our developing a web app, running on IIS and CF 5.0, with a SQL Server
2000 back end.  This web app may be placed into a clustered environment in
the near future. Business rules can be placed either on the CF Templates
(action pages), or in Stored Procedures.  Short of building DLL's strictly
for business rules, these are the only options we see for an n-tier web app.
(When I say business rules, I mean stuff like if flag A is true, then set
fields 1 through 10 to these values, otherwise set fields 10 to 15 to
different values).

So at the bottom line, we have two questions:
1) Where is the best place to put the business rules?  CF Templates (using
CFTransaction), or Stored Procedures (using SQL Transactions).  We realize
that some business rules need to reside on the templates, such as client
side data validation.  But processing pages are a different story.
2) What is more likely to need clustering - the Web/CF Server, or the SQL
Server.  This is expected to be a high volume site.

Thank you for your time and responses.

Shawn Grover

__
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



RE: best password encryption method

2002-04-02 Thread Shawn Grover

I agree - this is the most secure.

when logging in, you hash the entered password, then do a select on the
username, and the hashed password - if you get a record back, they are
authenticated.  Doing it this way avoids ever having to decrypt a password.

Only catch is if you offer a system that can email the password to a user -
now you need to decrypt the password, which hashing does not support.

My 2 cents worth.

Shawn Grover

-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 9:13 PM
To: CF-Talk
Subject: Re: best password encryption method


My suggestion would be to use HASH (one-way encryption). Unless you have a
specific reason for needing to decrypt passwords.

 anyone can suggest what is the best method to encrypt password that stored
 in the database?


 --
-
 Pharmaniaga Berhad, your integrated healthcare provider
 www.pharmaniaga.com.my
 www.ehealth4all.com, your most convenient way to healthcare, everyday...
 The information transmitted is intended only for the person or entity to
 which it is addressed and may contain confidential or privileged material.
 If you received this in error, please contact the sender and delete the
 material from any computer. Any review, retransmission, dissemination or
 other use of, or taking of any action in reliance upon, this information
by
 persons or entities other than the intended recipient is prohibited.
 --
-


__
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: Announcement: New Flash MX component

2002-03-28 Thread Shawn Grover

Cool Tool Dave!

Showed it to a coworker, and his comment was be nice if you could do
something like this for an MPEG file.
But, I can see lots of places this can come in handy.

Shawn Grover

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 9:44 AM
To: CF-Talk
Subject: Announcement: New Flash MX component


This is a little OT, but I'm very excited to be able to announce the
introduction of a new Flash MX component. Everyone's been hearing from MM
about how Flash MX will save the world; here's a little demonstration.
DaVinci is a component that can be used by itself, or within a larger
Flash application, for capturing user input in a way that would be, well,
difficult with just HTML.

Fig Leaf Software Announces 'DaVinci'

'DaVinci' is the first of a series of Flash MX components
being developed by Fig Leaf Software.

Using DaVinci, you can add image annotation capabilities
to your web-based applications. End-users may add lines,
text, scribbles, and other geometric forms that sit in
layers on top of a background JPEG image. The vector
drawings are represented as XML and can be saved into a
database for future reference.

The component can be dropped into any HTML-based web page,
or included as part of a complete Flash MX solution.

Because the component was developed using Flash MX from
Macromedia, it is cross-browser compatible with any device
running the Flash 6 player.

Fig Leaf Software will soon begin soliciting feedback from
beta testers. If you want to join the beta, or get more
information, go to http://davinci.figleaf.com;

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


__
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: Complex List Delimiter

2002-03-28 Thread Shawn Grover

Don't know for sure but it appears the delimiter is acting as a regular
expression.  Square brakets in a regular expression indicate optional
components.

So, as a shot in the dark you could try \[pagebreak\]

HTH

Shawn Grover

-Original Message-
From: Wallick, Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 9:54 AM
To: CF-Talk
Subject: Complex List Delimiter


Quick question for you gurus out there


I want to use a text delimiter for my content that's in a database. I want
to use [pagebreak] as the delimiter. In php, I would use:

// Split the text into an array of pages
$textarray = split(\[pagebreak], $content);

However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar
function) is interpreted as any of the characters in the [pagebreak] string
could be a delimiter (i.e. [ p a g e b r e a k ]).

Any ideas?

mike wallick
* web application developer
* [EMAIL PROTECTED]
* 651.628.5377
* http://www.securecomputing.com


__
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



RE: Checking an email

2002-03-28 Thread Shawn Grover

why not just use the pop services?  Most servers allow you to query for mail
headers without downloading the actual message itself.  You might be able to
do this through CFPOP (never used it, so I'm not sure).  If not, then you
will need to look into the POP or SMTP protocols, or another tool/component.

hth

Shawn Grover

-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:13 PM
To: CF-Talk
Subject: Re: Checking an email


Depends on the Email Server's Configuration. Its not as common to be able to
do
that nowadays as it used to be. Most of the time Email Administrators are
going
to have the vrfy command disabled on the email server.

Quoting Jeff Green [EMAIL PROTECTED]:

 Hi all,

 Is it possible to check to see if an email exists without sending the
 email
 address an actual email?

 TIA,
 jeff


__
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: cfparam vs. cfif/isDefined/cfset

2002-03-26 Thread Shawn Grover

I agree, if you are using the application scope, they must be locked.
However, I fail to see a need to scope the variables (meaning local scope).
If Application.cfm gets run on every page (except includes, cfmodules/custom
tags), then these variables are ALWAYS available to you.

As for the CFIF to determine if they exist, that's the purpose of CFPARAM
with a default attribute.  If the parameter exists, it is used as is,
otherwise it is created with the default value.  I've heard some talk over
time as to performance issues and such regarding CFPARAM and IsDefined(),
but have never seen a definitive answer saying one is most definetly
faster - and my own testing says they are both fast enough (for my purposes
at least).

Some people will recommend putting all your variables in the Request scope
(thereby allowing custom tags to have access to them).  I look at this as
declaring all your variables as global - which is frowned on in other
programming languages (C/C++, VB, Fortran, etc.) because it means more
care/management is required to make sure they are not being inadvertently
changed in some obscure function.  It is better programming practice to use
the smallest scope (local scope) where possible, and pass parameters to
functions (or custom tags in this case).  Those who would dispute this
either know something I don't, or don't have much experience outside web
development (no offense intended...).

As for my own practices regarding variables similar to what you've shown, I
declare a LOCAL scoped structure called App.
Then make each variable a member of the structure.  For example:

cfscript
App = StructNew();
//Datasources
StructInsert(App, DSN, MyDSN);

//Locations
StructInsert(App, BaseURL, http://localhost/myapp;);
StructInsert(App, BaseDirectory, /myapp);
structInsert(App, IncludesDir, #App.BaseDirectory#/includes;

..
/cfscript

With a little more thought, it's possible to declare the structure in the
application or session scope, and only create it once.  Just be sure to lock
where needed.  And keep in mind that only YOU know the right answer for your
needs.

My two cents worth.

Shawn Grover

-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 1:11 PM
To: CF-Talk
Subject: Re: cfparam vs. cfif/isDefined/cfset


Yes, they MUST be locked.

These look like variables that don't change - I'd do a CFIF test on one, and
if it doesn't exist then set them all.  As long as you always set them all
together, you can use the existence of one to test for all.

This way the app vars are set only once, and don't bog down your pages,
since Application.cfm is called with every request.

Chris Norloff

-- Original Message --
from: Earl, George [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Tue, 26 Mar 2002 11:21:07 -0500

Here is my application.cfm file:

cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0,
0)#

cfparam name=application.appnameroot default=/appname
cfparam name=application.includesDir default=/appname/includes
cfparam name=application.imagesDir default=/appname/images
cfparam name=application.menusDir default=/appname/menus
cfparam name=application.templatesDir default=/appname/templates
cfparam name=application.smapDir default=/appname/smap

Should I be locking these cfparam tags? Should I wrap them all in one lock
or should I lock each one individually?

What is the difference between using cfparam tags as I have above and using
cfif with isDefined and cfset to accomplish the same thing? Is one method a
better practice than the other?

Thanks!

George
[EMAIL PROTECTED]



__
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



CFCookie vs Javascript cookie vs ASP cookie ??

2002-03-26 Thread Shawn Grover

Experience tells me that ASP and Javascript have problems reading cookies
set by Cold Fusion.  And Cold Fusion seems to have problems reading cookies
set in JS or ASP.

I'm just curious if I'm the only one seeing this behaviour, or maybe I've
missed something in my understanding of how the cookies are supposed to
work.

Any insight into this???  Thanks

Shawn Grover

__
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: cfparam vs. cfif/isDefined/cfset

2002-03-26 Thread Shawn Grover

In your particular case, then yes, this makes sense.  And for variables in
application scope, this is probably good practice.  I just wanted to point
out that what is right for one situation is not always right for all
situations.  But that's kinda like stating the obvious to developers isn't
it?... grins

Shawn Grover

-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:58 AM
To: CF-Talk
Subject: RE: cfparam vs. cfif/isDefined/cfset

snip
For example: we maintain 5 server locations, some secure and some not.  Some
of the site-specific information is contained in application scoped
variables.  We either set them all or we don't set any.  Thus, we check for
one of them, and if it doesn't exist then set all of them.
/snip

__
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



RE: CFCookie vs Javascript cookie vs ASP cookie ??

2002-03-26 Thread Shawn Grover

Thanks Dave.  Somehow I knew I could count on you.  I'm looking into the
path issue now (making sure it was declared...), but suspect that's where
the problem is.

Shawn Grover

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 1:19 PM
To: CF-Talk
Subject: RE: CFCookie vs Javascript cookie vs ASP cookie ??


 Experience tells me that ASP and Javascript have problems
 reading cookies set by Cold Fusion. And Cold Fusion seems
 to have problems reading cookies set in JS or ASP.

 I'm just curious if I'm the only one seeing this behaviour,
 or maybe I've missed something in my understanding of how
 the cookies are supposed to work.

That hasn't been my experience; cookies are cookies, and the browser doesn't
care (or even know) which cookies are set by what program type.

That said, it's possible that you're using different paths, hosts or domains
between the three, in which case one application may not see cookies written
by another application.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


__
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



CFGrid Enhancements/Replacement?

2002-03-25 Thread Shawn Grover

We have a need for a grid that will allow hiding/showing columns, adding new
rows, displaying query results, capturing click and double click events, and
summing columns together with the result in another column.  Preferably
without requiring the user to load the Java 2 runtime environment.  All the
above processing needs to take place client side.

Unfortunately, CFGrid isn't quite up to the task, and the Customized version
previous contractors came up with isn't either.

So, I was hoping someone here could point me to a suitable applet/control,
before we look at re-coding the current grid control we have to meet all of
our needs.

Thanks in advance.

Shawn Grover

__
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: CF JS Menus

2002-03-22 Thread Shawn Grover

The menu system I was thinking about was the Milonic menu
http://www.milonic.com/menu/

When I was looking for menus, this one seemed to be the most robust that I
could find, and that didn't have any costs involved.

Shawn Grover

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 5:52 PM
To: CF-Talk
Subject: Re: CF  JS Menus


Thanks Shawn.
This is for a school project I am putting together..so free is what I am
looking for. I'd like to get into DHTML, Javascript, and DOM more, but with
graduation coming up, I just dont have time right now...

so anyone reading this..any free menus would be great.
I am looking for something that I can use with CF.
I have a query that grabs the main categories and then loops around another
query passing in the main catid to get the sub cats and thus I get the info
needed to give the javascript to generate the menus.. I have on working in
some versions of NS and all IE but need it to work in IE4+, NS4.08+.

Thanks for any links.. advice, help.. much appreciated.
Mike


- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 7:48 PM
Subject: RE: CF  JS Menus


 Hiermenus is now charging for licensed use.  And their prices are pretty
 extreme.
 I checked into this in January sometime - it was something like $500 if
your
 site had less than 20 pages, $900 if it was between 20 and 40 pages, and
 $1500 if you had more than 40 pages.

 After doing some checking around, there are some very good systems out
there
 that are much less (free even), and meet or exceed Hiermenus'
capabilities.
 Unfortunately, I don't have the links with me I'll see if I can dig
them
 out tonight...

 Shawn Grover

 -Original Message-
 From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 21, 2002 4:23 PM
 To: CF-Talk
 Subject: RE: CF  JS Menus


 You might also want to check out
 http://www.webreference.com/dhtml/hiermenus/


 Chuck McElwee
 etech solutions inc
 www.etechsolutions.com


 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 21, 2002 4:37 PM
 To: CF-Talk
 Subject: Re: CF  JS Menus


 We have a very solid script that is very compatible with many browsers.

 http://www.quilldesign.com/popupmenupro/index.cfm

 Drop in and check it out...

 Paul Giesenhagen
 QuillDesign
 http://www.quilldesign.com
 SiteDirector v2.0 - Commerce Builder


  Hello Everyone.
 
  I have been playing with the IE DOM and NS DOM for the past two weeks,
and
  decided to ask if anyone knows of any good JS menu scripts that looks
nice
  and work in IE4+, NS4.08+?
  I would appreciate any links or advice.
 
  Mike
 




__
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: Multiple File Upload

2002-03-22 Thread Shawn Grover

but do they release their source code to you when you purchase the product?


-Original Message-
From: Birgit Pauli-Haack [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 6:11 PM
To: CF-Talk
Subject: Re: Multiple File Upload


I found two java applet solutions: both around $200 if I recall it
correctly...

AppletFile by Infomentum, Inc.
http://www.infomentum.com/products/

or

JUpload by  Persits Software, Inc.
http://www.aspupload.com/jupload.html

Birgit


Thursday, March 21, 2002, 11:08:26 AM, you wrote:

 I need to have a multiple file upload.

OL I've only ever heard two answers to this:

OL 1. Some kind of custom Active-X somethingorother.
OL 2. Multiple file input fields, followed by looping over cffile.

OL I'd certainly be interested if anyone has any better solutions.

OL -- Owen

OL 
OL Athens County Library Services
OL http://www.athenscounty.lib.oh.us


OL 

__
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



RE: Password Protected File Downloads

2002-03-21 Thread Shawn Grover

that's how I've done it.  Also allows you to log file access and such...

-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:14 PM
To: CF-Talk
Subject: RE: Password Protected File Downloads


Use CFCONTENT to serve up the actual document and store the file in a
subdirectory somewhere off the root.

That would be my guess.

M

-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:54 PM
To: CF-Talk
Subject: Password Protected File Downloads


Hey all,

What is the most efficient way to provide files for download to a client
after username/password authentication *without* using NT Authentication.

The simple way is to validate the user using CF and then just display the
documents using CFDirectory, but, if anyone know the URL to the document,
they can bypass the cfm template altogether.  I was thinking about randomly
renaming documents and storing the filenames in a DB, but that seems sloppy
too.

This client is currently in a virtual hosting environment, so adding
directory security seems out of the question.

Any thoughts would be greatly appreciated.

TIA,

- jim




__
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



RE: CF JS Menus

2002-03-21 Thread Shawn Grover

Hiermenus is now charging for licensed use.  And their prices are pretty
extreme.
I checked into this in January sometime - it was something like $500 if your
site had less than 20 pages, $900 if it was between 20 and 40 pages, and
$1500 if you had more than 40 pages.

After doing some checking around, there are some very good systems out there
that are much less (free even), and meet or exceed Hiermenus' capabilities.
Unfortunately, I don't have the links with me I'll see if I can dig them
out tonight...

Shawn Grover

-Original Message-
From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:23 PM
To: CF-Talk
Subject: RE: CF  JS Menus


You might also want to check out
http://www.webreference.com/dhtml/hiermenus/


Chuck McElwee
etech solutions inc
www.etechsolutions.com


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:37 PM
To: CF-Talk
Subject: Re: CF  JS Menus


We have a very solid script that is very compatible with many browsers.

http://www.quilldesign.com/popupmenupro/index.cfm

Drop in and check it out...

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


 Hello Everyone.

 I have been playing with the IE DOM and NS DOM for the past two weeks, and
 decided to ask if anyone knows of any good JS menu scripts that looks nice
 and work in IE4+, NS4.08+?
 I would appreciate any links or advice.

 Mike



__
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



RE: Need Suggestions - Multiple instances of application.

2002-03-20 Thread Shawn Grover

Thanks Mark.  I'll have to do some reading, but are you saying Session
Variables only apply to the current Application Name?  And if that is the
case, what about Client variables? (we are not using session variables
because of the chances at clustered servers for this app)  That WOULD make
life easy - just name our app dynamically based on the Company name/id.

Does anyone else have any other suggestions?

Thanks in advance.

Shawn Grover

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 7:25 PM
To: CF-Talk
Subject: RE: Need Suggestions - Multiple instances of application.


How about a login HTML page that is outside the appication.  When the user
logs in you instantiate the application name (after processing the login).
You would need an application name to handle exceptions too - otherwise it
would error out. When the user provides the information and you know what
company they belong too you set up the application name that pertains to
that company - then store it in a session variable and reuse it in the
cfapplication tag. Then you would have something like:

cfapplication name=#somCompanyName#  


The application variables would only be written once for each number of
companies you have (and you would have that many applications), and they
would remain within the scope of that company.  I'm not really  sure it
would work - having clearly never tried it, but hey ... it's an idea ha,
and it solves that whole URL variable thing.

Mark

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 5:32 PM
To: CF-Talk
Subject: Need Suggestions - Multiple instances of application.


We need to allow our users to have access to one or more company's data at a
given time.  This is done through our application interface, but in essance
would require a separate instance of the application for each company.  I'm
looking for ideas how to do this.

The problem is this:  We put company specific information into client
variables.  Opening a second company would overwrite the first's client
vars.  Previous contractors began looking at this issue, but did not
complete it.  They were passing a generated token on each call to new
windows.  However, from an implentation standpoint, the end user may change
the URL parameter for the token (hacking), and the token was generated by
simple math that may or may not have been sufficient to come up with a
unique ID.

One of our developers here has suggested using a database table in some way.
Before we go down that road, I'm hoping to get some feedback on how others
have handled this.  Are these the only two feasible options?  Placing a
token of somesort in the URL parameters or Taking a database hit on each new
page/window?

I guess we can get into dynamic naming of cookies, but I think managing that
would be a large issue.

Thanks in advance for any ideas.

Shawn Grover



__
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: Need Suggestions - Multiple instances of application.

2002-03-20 Thread Shawn Grover

Unfortunately, yes.  The user CAN access two companies in two different
browser windows at the same time (especially the support personel).  Session
Variables are not being used, but Client Variables are (shouldn't be tooo
much differnce though).  And I agree - I'd like to drop the URL token.

At this point, we have focused on getting the core functionality of the app
in place for one company at a time.  Adding the ability to access more than
one company simultaneously can come later as an enhancement to the
application.  We felt it best to get the app running properly first (at
least more important than this multi-company issue).

Thanks for the input.

Shawn Grover

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 7:50 AM
To: CF-Talk
Subject: Re: Need Suggestions - Multiple instances of application.


Do users ever hava a valid need to access two companies at the same time in
two different browser windows?  If not, just use session variables to store
the company information and drop the url token altogether.

Jim

- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002 4:31 PM
Subject: Need Suggestions - Multiple instances of application.


 We need to allow our users to have access to one or more company's data at
a
 given time.  This is done through our application interface, but in
essance
 would require a separate instance of the application for each company.
I'm
 looking for ideas how to do this.

 The problem is this:  We put company specific information into client
 variables.  Opening a second company would overwrite the first's client
 vars.  Previous contractors began looking at this issue, but did not
 complete it.  They were passing a generated token on each call to new
 windows.  However, from an implentation standpoint, the end user may
change
 the URL parameter for the token (hacking), and the token was generated by
 simple math that may or may not have been sufficient to come up with a
 unique ID.

 One of our developers here has suggested using a database table in some
way.
 Before we go down that road, I'm hoping to get some feedback on how others
 have handled this.  Are these the only two feasible options?  Placing a
 token of somesort in the URL parameters or Taking a database hit on each
new
 page/window?

 I guess we can get into dynamic naming of cookies, but I think managing
that
 would be a large issue.

 Thanks in advance for any ideas.

 Shawn Grover


__
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: HTML email images?

2002-03-20 Thread Shawn Grover

I don't know the code off the top of my head, but what you are looking for
is embedded images - not links to an image.  The difference being the image
file is sent as part of the email - kinda like an attachment.  I've seen
reference to this on the list in the past, so checking the archives might
help.  Otherwise, I know there are a few sites out there that have info on
this.

Sorry I couldn't be more help.

Shawn Grover

-Original Message-
From: Sharon Diorio [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 11:12 AM
To: CF-Talk
Subject: HTML email images?


I've got a client that wants to email dynamically generated HTML reports.
Unfortunately, this is on a secured site.  I know how to do an HTML email
with images pulled from a website, but is there a way to do an HTML email
with images as attachments?

Sharon DiOrio

__
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



Need Suggestions - Multiple instances of application.

2002-03-19 Thread Shawn Grover

We need to allow our users to have access to one or more company's data at a
given time.  This is done through our application interface, but in essance
would require a separate instance of the application for each company.  I'm
looking for ideas how to do this.

The problem is this:  We put company specific information into client
variables.  Opening a second company would overwrite the first's client
vars.  Previous contractors began looking at this issue, but did not
complete it.  They were passing a generated token on each call to new
windows.  However, from an implentation standpoint, the end user may change
the URL parameter for the token (hacking), and the token was generated by
simple math that may or may not have been sufficient to come up with a
unique ID.

One of our developers here has suggested using a database table in some way.
Before we go down that road, I'm hoping to get some feedback on how others
have handled this.  Are these the only two feasible options?  Placing a
token of somesort in the URL parameters or Taking a database hit on each new
page/window?

I guess we can get into dynamic naming of cookies, but I think managing that
would be a large issue.

Thanks in advance for any ideas.

Shawn Grover

__
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: UDF question

2002-03-18 Thread Shawn Grover

I have two comments on this:

1) with today's computer's, the speed issue shouldn't be an issue at all.
Unless you are doing something inside a loop over thousands of iterations,
on multiple websites (hosted on the same server) at the same time, the
performance hit should be very minor.  If you are looping through thousands
of iterations, you expect a delay anyways.

2) Why not offer a simple merged solution?  i.e. have CF Server
automatically lock any variables, unless the developer has explitly stated a
lock beforehand.

You're example would be an instance when the developer has not explitly
locked anything, whereas if they had done something like this:

cflock
cfloop ...
cfset session.x = ...
cfset session.y = ...
/cfloop
/cflock

Then the developer has explitly stated where to start/end the lock.
However, if they hadn't, then everything would still run properly because
there would be an inherent lock.  And then they are responsible for the
corresponding performance hit (if any).  The logic to do this sort of coding
should be very simple.

As for myself, I currently set my servers to automagically lock all reads of
application and session variables.  Keeps my code very clean when I'm only
reading elements (99% of my use of session variables).

My 2 cents worth

Shawn Grover
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 1:26 PM
To: CF-Talk
Subject: RE: UDF question


(Taking off Macromedia cap and speaking as just one of yall...)
The question is - do you want CF to automatically handle everything for
you at the sacrifice of speed? Here is a good example:

cfset session.x = 1
cfset session.y = 2
cfloop ...
cfset session[foo#x# = 
/cfloop

If CF had to auto lock this, it would need to use:

cflock ..
cfset session.x = 1
/cflock
cflock ..
cfset session.y = 2
/cflock
cfloop ...
cflock ...
...
/cflock
/cfloop

It would be very difficult to make a system smart enough to know Hey, I
could use one lock around this particular block of code. Therefore, we
would be stuck with the slower alternative. Personally, I'd rather just
do the work. It can't be that hard to cflock, or duplicate to the
request scope.

. again, all of the above is my personal opinion, not that of the
company.


===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

My ally is the Force, and a powerful ally it is. - Yoda

 -Original Message-
 From: junkMail [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 18, 2002 3:18 PM
 To: CF-Talk
 Subject: Re: UDF question


 With respect to this issue, comparing CFML to C++ is apples
 to oranges.

 I can't expect a low-level language to automatically manage
 concurrent access
 to shared memory resources, because I have defined the
 resources and I have
 decided how they are to be accessed and shared.   I can't
 expect a such system
 to be prescient.



__
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



RE: RE: UDF question

2002-03-18 Thread Shawn Grover

You can begin mulitple threads simply by declaring a frameset.  In that
case, you'll have two or more pages being loaded into their respective
frames with (near) simultaneous calls.  Which means the server can be
responding to either of those calls at any given time.  The problem now
comes when these two (or more pages) make reference to a common session or
applicaiton variable.  Who get's precedence?  What if they are both writing
at the same instance.  This is the reason for locking.

The argument here though is that the server should be able to handle this
locking on the fly, on it's own.

I think this is going come down to a developer style issue - more than one
way to do it, and all of them right because they acheive the same results.

I've yet to see strong arguments why CF Server should not handle the
locking, but then again, I've yet to see strong arguments why the developers
shouldn't handle it.  Hence, I think a compromise is in order, and would
offer the best solution for everyone involved (see my earlier post on this
thread).

My observations, not yours.

Shawn Grover

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 3:01 PM
To: CF-Talk
Subject: RE: RE: UDF question


I don't think it's a multi-threaded language because it is not possible
(to my knowledge) to start a new thread and have it run while the main
thread continues execution, then notify the main thread when it's done
executing.  The fact that we need to be concerned about multi-threading
comes into play because the server itself is multi-threaded and those
other threads can affect the performance of a single thread.

As I sit here I'm starting to think that CFML is neither mulit-threaded
nor single threaded.  It's somewhere in between because it has
characteristics of both.  Fractal threaded maybe? :-)


My humble opinion.

Matt Small
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 4:38 PM
To: CF-Talk
Subject: Re: RE: UDF question

See below:

- Original Message -
From: Matthew R. Small [EMAIL PROTECTED]
Date: Monday, March 18, 2002 2:33 pm
Subject: RE: UDF question

 The only concurrency issues that seem to come up in CF are when we
 needto single thread any piece of code - that's what the locks do.
 But I
 haven't seen any code at all that allows us to start new threads
 in the
 same page.
Everytime a new user goes onto your web site, a new thread is used for
that user.  So although at the page level, you can't start new threads,
threading certainly exists in CF at the application level.

 As I understand it, C++ is a multi-threaded language.  CFAS is a
 multi-threaded application written in C++.  CFML is a single-threaded
 language that needs to take into account multiple threads on
 occasion.
If CF needs to take into account multiple threads, then it's multi-
threaded capable. :)


 Please correct me if I'm wrong.

 - Matt Small

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 18, 2002 4:10 PM
 To: CF-Talk
 Subject: Re: UDF question

 CF is merely an abstraction of a crap load of C++ code.

 I agree with you on the process that happens when you define a
 variable
 in CF.  I don't see how that absolves the programmer of coming up
 with
 the best way of handling concurrency issues.

 Regardless, CF does provide you with many mechanisms of locking
 control.  What really matters is picking the one that suits you,
 and to
 write code that is in line with the decision you've made.


 - Original Message -
 From: junkMail [EMAIL PROTECTED]
 Date: Monday, March 18, 2002 1:18 pm
 Subject: Re: UDF question

  With respect to this issue, comparing CFML to C++ is apples to
  oranges.
  I can't expect a low-level language to automatically manage
  concurrent access
  to shared memory resources, because I have defined the resources
  and I have
  decided how they are to be accessed and shared.   I can't expect
 a
  such system
  to be prescient.
 
  The situation is different in ColdFusion.  Although I declare
 and
  use the
  variables, ColdFusion creates the resources in memory and
  essentially decides
  how they are to be accessed and shared.  ColdFusion can AND
 SHOULD
  manage the
  concurrency issues.
 
  C++ is not a multi-threaded language.  It's a language capable
 of
  producingmulti-threaded applications, such as ColdFusion.
 
  [EMAIL PROTECTED]
 
 
  - Original Message -
  From: [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, March 18, 2002 1:58 PM
  Subject: Re: UDF question
 
 
   Interesting.
  
   Any language that implements locking (read:  any that are worth
   programming in) uses some sort of sloppy locking mechanism.
  Some are
   downright evil (read: C++).  Certainly, I can't think of any
  multi-
   threaded languages that handle concurrency automatically

RE: CFLOCK all the time?

2002-03-18 Thread Shawn Grover

read through the thread UDF Question.  It is directly related (although,
kinda long winded) to this topic, and can offer some insights.

-Original Message-
From: John Kivus [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 4:29 PM
To: CF-Talk
Subject: CFLOCK all the time?


We're currently having a debate over programming standards at my
company. Should we CFLOCK every session and application variable or just
application variables? I know that using CFLOCK can cause some
performances issues. What do other people think?

John Kivus
IQ Interactive

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

__
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: Conversion help, Centimeters to Feet Inches

2002-03-18 Thread Shawn Grover

Or, check the libraries at CFLIB.ORG - I think I recall seeing conversion
functions there

Shawn Grover

-Original Message-
From: Brian Simpson [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 5:54 PM
To: CF-Talk
Subject: Conversion help, Centimeters to Feet Inches


Conversion help,  Centimeters to Feet Inches

Anyone know how to convert Centimeters to Feet Inches?

I have a customer that has all the data in Metric and wants it displayed in
both Metric and US

kg to lbs is easy:

1 kg = 2.204623 lbs
55 kg = 121.3 lbs

CFSET LBS = #GetProfileRecords.Weight# * 2.204623

CFOUTPUT#NumberFormat(LBS,'___._')#/CFOUTPUT LBS




100 cm = 3.280 feet or 1 foot = 30.48 cm
166 cms = 5'6

How do you convert it to display properly in  Feet' and Inches ?


Thanks for your help.


__
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: Conversion help, Centimeters to Feet Inches

2002-03-18 Thread Shawn Grover

if you first convert your metric measurment to feet, they you'll likely have
a decimal value.
Strip the decimal value off of the number, and multiply it (the decimal
part) by 12 to get the inches.  I could be wrong on that, it might be a
division... hmm  can't think straight... need to get some sleep.

Shawn Grover

-Original Message-
From: Brian Simpson [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 5:54 PM
To: CF-Talk
Subject: Conversion help, Centimeters to Feet Inches


Conversion help,  Centimeters to Feet Inches

Anyone know how to convert Centimeters to Feet Inches?

I have a customer that has all the data in Metric and wants it displayed in
both Metric and US

kg to lbs is easy:

1 kg = 2.204623 lbs
55 kg = 121.3 lbs

CFSET LBS = #GetProfileRecords.Weight# * 2.204623

CFOUTPUT#NumberFormat(LBS,'___._')#/CFOUTPUT LBS




100 cm = 3.280 feet or 1 foot = 30.48 cm
166 cms = 5'6

How do you convert it to display properly in  Feet' and Inches ?


Thanks for your help.


__
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: SQL case insensitive search ???

2002-03-15 Thread Shawn Grover

It isn't case sensitive if the database hasn't been setup that way when the
server was installed.
This can be changed through the server management interfaces (normally).

However, you can get around the issue by casting your field and your
parameter to upper or lower case.
i.e.

Select *
from My Table
Where upper(Field1) = upper(@Param1)

or something similar

HTH

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 10:39 PM
To: CF-Talk
Subject: RE: SQL case insensitive search ???


it should be case insensitive to begin with?

All '%searchString%' does is cause your query to table scan the whole
table since the wildcard is in front.

J.

John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com

more people are killed by donkeys than by airplane crashes each year


-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 9:36 PM
To: CF-Talk
Subject: SQL case insensitive search ???


how does one go about structuring a case insensitive search on a text
field in a database?

Currently using

WHERE Table.FieldName LIKE '%searchString%'

Thanks,
Brian



__
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



Studio 4.5.2 problem?

2002-03-14 Thread Shawn Grover

Just curious if anyone else has seen this problem.

If I use the split screen option to view different parts of my code, the app
sometimes craps out with an Invalid Exception error, and I have to end task
to recover.
Is this a known issue? or is it likely just the configuration of my box?

Thanks in advance.

Shawn Grover

__
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: CFTransactions and SQL Transactions?

2002-03-12 Thread Shawn Grover

In my experience, this would be better done in a single stored procedure
call (which would then call any other required stored procs).  SQL Server
supports nested transactions, so each of your 'child' stored procs can also
use transactions if required.

If you are writing this from scratch, put as much logic as you can into the
stored procs (afterall, the database server is meant to handle data for you,
whereas your web server is meant to present web pages).

As for CFTRANSACTION, we are unclear on how it could handle a rollback if
you have stored procs within it that have committed their SQL Transactions.

Until I hear more, I'm recommending to my team to NOT use CFTransaction for
that reason.  The data for our current app is critical, and we have to stick
with methods we know to work well.

Let me know if you hear any more on this.  I'm not getting the impression
that I'll see lots on this from the list.

Shawn Grover

-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 5:48 AM
To: CF-Talk
Subject: RE: CFTransactions and SQL Transactions?


Shawn,

I don't have an answer but am anxiously awaiting one.

I have a case where in order to get some records into our SQL database I
execute a SP to enter a blank record and then call several SP's to update
different fields in the record with values.  I need to wrap this in a
cftransaction and am just trying to gather some more information before
doing it.

__

Bill Grover
Supervisor MIS  Phone:  301.424.3300 x3324
EU Services, Inc.   FAX:301.424.3696
649 North Horners Lane  E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__



 -Original Message-
 From: Shawn Grover [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 3:03 PM
 To: CF-Talk
 Subject: CFTransactions and SQL Transactions?


 This is a repost cuz I think I got lost in the shuffle on
 Friday, and no-one
 has responed yet.

 TIA.

 -Original Message-
 From: Shawn Grover [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 08, 2002 9:54 AM
 To: CF-Talk
 Subject: CFTransactions and SQL Transactions?


 I'm looking for more information about using CFTransaction.
 My personal opinion is that it's better to use SQL Server transactions
 within our stored procedures (cuz we are using SQL 2000 as
 our back end),
 and transfer as much business logic as possible to the stored procs.

 However, in a few cases, we've seen the requirement for
 something like this:

 cftransaction action=BEGIN
   cfstoredproc/cfstoredproc
   cfif somecondition
   cfstoredproc/cfstoredproc
   cfelse
   cfstoredproc/cfstoredproc
   /cfif
 /cftransaction

 My concerns are that this may cause problems if the stored procedures
 themselves contain transaction processing.  And I need to make a
 recommendation based on solid information on whether to allow
 this process,
 or force the developers to take the time to wrap this logic within one
 stored proc call.  (of course, they can call existing stored
 procs from
 within a stored procedure, and check the return codes to
 determine if a
 rollback needs to happen before processing is complete).

 So, any suggestions?  Thanks in advance.

 Shawn Grover




__
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: What's wrong with this simple UDF?

2002-03-12 Thread Shawn Grover

You have to do your VAR statements before anything else.

Try it this way:

function pad(str, length, padChar) {
 var strLen = len(trim(str));
 var difference = length - strLen;

 str = trim(str);
 if (strLen GT length) {


Shawn Grover

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 12:27 PM
To: CF-Talk
Subject: What's wrong with this simple UDF?


function pad(str, length, padChar) {
 str = trim(str);
 var strLen = len(str);//--##This is the error line##
 var difference = length - strLen;

 if (strLen GT length) {
  newStr = str;
 } else {
  newStr = str  repeatstring(padChar, difference);
 }
 return newstr;
}

Here's the error I'm getting:
==
Just in time compilation error
Invalid parser construct found on line 8 at position 2. ColdFusion was
looking at the following text:
var
Invalid expression format. The usual cause is an error in the
expression structure.
==

BTW, it doesn't seem to help do declare:
var strLen = '';
strLen =  trim(str);

Thanks,
Jamie

__
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: SQL in a CFIF

2002-03-12 Thread Shawn Grover

Yep.

cfif MyCondition
cfquery name=myquery datasource=mydsn
Select * from MyTable
/cfquery
/cfif

OR

cfquery name=MyQuery datasource=MyDSN
Select * from MyTable
cfif MyCondition
Where lID = #IDVar#
/cfif
/cfquery

OR

Put the full SQL Statement into a string, using CFIF as needed to build your
string, then like so:

cfquery name=MyQuery datasource=MyDSN
#MySQLString#
/cfquery

Hopefully that answers what you were asking.

Shawn Grover

-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 2:30 PM
To: CF-Talk
Subject: SQL in a CFIF


How would write a select statement within a CFIF statement.

1. Can it be done?

2. What is the Syntax?

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[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: Target back to parent.

2002-03-11 Thread Shawn Grover

Yes, the Form object has a Target attribute.
(i.e. form action=mypage.cfm target=_top)

If needed, I think you can set the target dynamically through JS
document.forms[0].target=MainWindow;
(I could be wrong on this though... couldn't find confirmation in my JS
book.)

Hope that helps.

Shawn Grover

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 11:04 AM
To: CF-Talk
Subject: Re: Target back to parent.


I am not worried about form field access.  I am more worried about posting
back to that original page and closing the current window (hence the
window.close())

Is there a target attribute?

Thanks,

Neil

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 12:59 PM
Subject: RE: Target back to parent.


 You can reference the parent window with opener

 opener.document.formname.fieldname.value=whatever;
 window.close();

 _
 steve oliver
 senior internet developer
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 12:47 PM
 To: CF-Talk
 Subject: Target back to parent.


 If I use JavaScript to spawn a new window how can I have that spawned
 window's form post back to the parent page, and then close the spawned
 window.

 Thanks,

 Neil




__
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: Target back to parent.

2002-03-11 Thread Shawn Grover

form  Target=MainWindow onSubmit=self.close();

Would that do the trick?  (haven't had the need to try it out, so no
sure)

Shawn Grover


-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 11:50 AM
To: CF-Talk
Subject: Re: Target back to parent.


Correct so what would I use to submit the form to the opener  and then
close the child?

Neil

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 1:08 PM
Subject: RE: Target back to parent.


 What exactly do you mean by posting back to the page? You run that
 script in the spawned window, and it sends anything you want back to the
 parent window, then the window.close() (run in the spawned window) will
 close the spawned window.

 _
 steve oliver
 senior internet developer
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 1:04 PM
 To: CF-Talk
 Subject: Re: Target back to parent.


 I am not worried about form field access.  I am more worried about
 posting
 back to that original page and closing the current window (hence the
 window.close())

 Is there a target attribute?

 Thanks,

 Neil

 - Original Message -
 From: Steve Oliver [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 12:59 PM
 Subject: RE: Target back to parent.


  You can reference the parent window with opener
 
  opener.document.formname.fieldname.value=whatever;
  window.close();
 
  _
  steve oliver
  senior internet developer
  atnet solutions, inc.
  http://www.atnetsolutions.com
 
 
  -Original Message-
  From: Neil H. [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 11, 2002 12:47 PM
  To: CF-Talk
  Subject: Target back to parent.
 
 
  If I use JavaScript to spawn a new window how can I have that spawned
  window's form post back to the parent page, and then close the spawned
  window.
 
  Thanks,
 
  Neil
 
 
 



__
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



CFTransactions and SQL Transactions?

2002-03-11 Thread Shawn Grover

This is a repost cuz I think I got lost in the shuffle on Friday, and no-one
has responed yet.

TIA.

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:54 AM
To: CF-Talk
Subject: CFTransactions and SQL Transactions?


I'm looking for more information about using CFTransaction.
My personal opinion is that it's better to use SQL Server transactions
within our stored procedures (cuz we are using SQL 2000 as our back end),
and transfer as much business logic as possible to the stored procs.

However, in a few cases, we've seen the requirement for something like this:

cftransaction action=BEGIN
cfstoredproc/cfstoredproc
cfif somecondition
cfstoredproc/cfstoredproc
cfelse
cfstoredproc/cfstoredproc
/cfif
/cftransaction

My concerns are that this may cause problems if the stored procedures
themselves contain transaction processing.  And I need to make a
recommendation based on solid information on whether to allow this process,
or force the developers to take the time to wrap this logic within one
stored proc call.  (of course, they can call existing stored procs from
within a stored procedure, and check the return codes to determine if a
rollback needs to happen before processing is complete).

So, any suggestions?  Thanks in advance.

Shawn Grover


__
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: Target back to parent.

2002-03-11 Thread Shawn Grover

Hm good point.

But, you should be able to do something like window.opener.name
but check to make sure it's not null

But now that I think of it, maybe the other method would be best
assigning values from the child window to hidden form fields on the
main.  at least I can see how that would work properly, but it DOES take
a bit more coding up front...

Let me know what you come up with, I can see us needing something like that
here right quick

Shawn Grover

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 1:12 PM
To: CF-Talk
Subject: Re: Target back to parent.


How do you name the Main Window, main window?  (Did that make sense :) )

Thanks,

Neil

- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 2:00 PM
Subject: RE: Target back to parent.


 form  Target=MainWindow onSubmit=self.close();

 Would that do the trick?  (haven't had the need to try it out, so no
 sure)

 Shawn Grover


 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 11:50 AM
 To: CF-Talk
 Subject: Re: Target back to parent.


 Correct so what would I use to submit the form to the opener  and then
 close the child?

 Neil

 - Original Message -
 From: Steve Oliver [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 1:08 PM
 Subject: RE: Target back to parent.


  What exactly do you mean by posting back to the page? You run that
  script in the spawned window, and it sends anything you want back to the
  parent window, then the window.close() (run in the spawned window) will
  close the spawned window.
 
  _
  steve oliver
  senior internet developer
  atnet solutions, inc.
  http://www.atnetsolutions.com
 
 
  -Original Message-
  From: Neil H. [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 11, 2002 1:04 PM
  To: CF-Talk
  Subject: Re: Target back to parent.
 
 
  I am not worried about form field access.  I am more worried about
  posting
  back to that original page and closing the current window (hence the
  window.close())
 
  Is there a target attribute?
 
  Thanks,
 
  Neil
 
  - Original Message -
  From: Steve Oliver [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, March 11, 2002 12:59 PM
  Subject: RE: Target back to parent.
 
 
   You can reference the parent window with opener
  
   opener.document.formname.fieldname.value=whatever;
   window.close();
  
   _
   steve oliver
   senior internet developer
   atnet solutions, inc.
   http://www.atnetsolutions.com
  
  
   -Original Message-
   From: Neil H. [mailto:[EMAIL PROTECTED]]
   Sent: Monday, March 11, 2002 12:47 PM
   To: CF-Talk
   Subject: Target back to parent.
  
  
   If I use JavaScript to spawn a new window how can I have that spawned
   window's form post back to the parent page, and then close the spawned
   window.
  
   Thanks,
  
   Neil
  
  
  
 
 



__
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: Target back to parent.

2002-03-11 Thread Shawn Grover

Don't know if the name property of a window is readonly or not, but if it
isn't, then you could try something like this:

script
window.name = MainWindow;
var subwin = open(.);
/script

and then set your target on the child window to the name you defined in the
script.
I'd try it out, but I'm tied up with an update query with 180+ parameters
right now

Shawn Grover

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 1:29 PM
To: CF-Talk
Subject: Re: Target back to parent.


Ok that doesn't seem good.  I found a basic way be searching but it doesn't
seem to work.  I am using the chromeless windows so I think that is screwing
me up.

Neil

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 3:23 PM
Subject: RE: Target back to parent.


 Only way to name the main window mainwindow would be to have a
 frameset with the frame name set to mainwindow

 _
 steve oliver
 senior internet developer
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 3:12 PM
 To: CF-Talk
 Subject: Re: Target back to parent.


 How do you name the Main Window, main window?  (Did that make sense :) )

 Thanks,

 Neil

 - Original Message -
 From: Shawn Grover [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 2:00 PM
 Subject: RE: Target back to parent.


  form  Target=MainWindow onSubmit=self.close();
 
  Would that do the trick?  (haven't had the need to try it out, so no
  sure)
 
  Shawn Grover
 
 
  -Original Message-
  From: Neil H. [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 11, 2002 11:50 AM
  To: CF-Talk
  Subject: Re: Target back to parent.
 
 
  Correct so what would I use to submit the form to the opener  and
 then
  close the child?
 
  Neil
 
  - Original Message -
  From: Steve Oliver [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, March 11, 2002 1:08 PM
  Subject: RE: Target back to parent.
 
 
   What exactly do you mean by posting back to the page? You run that
   script in the spawned window, and it sends anything you want back to
 the
   parent window, then the window.close() (run in the spawned window)
 will
   close the spawned window.
  
   _
   steve oliver
   senior internet developer
   atnet solutions, inc.
   http://www.atnetsolutions.com
  
  
   -Original Message-
   From: Neil H. [mailto:[EMAIL PROTECTED]]
   Sent: Monday, March 11, 2002 1:04 PM
   To: CF-Talk
   Subject: Re: Target back to parent.
  
  
   I am not worried about form field access.  I am more worried about
   posting
   back to that original page and closing the current window (hence the
   window.close())
  
   Is there a target attribute?
  
   Thanks,
  
   Neil
  
   - Original Message -
   From: Steve Oliver [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Monday, March 11, 2002 12:59 PM
   Subject: RE: Target back to parent.
  
  
You can reference the parent window with opener
   
opener.document.formname.fieldname.value=whatever;
window.close();
   
_
steve oliver
senior internet developer
atnet solutions, inc.
http://www.atnetsolutions.com
   
   
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 12:47 PM
To: CF-Talk
Subject: Target back to parent.
   
   
If I use JavaScript to spawn a new window how can I have that
 spawned
window's form post back to the parent page, and then close the
 spawned
window.
   
Thanks,
   
Neil
   
   
   
  
  
 
 



__
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: Target back to parent.

2002-03-11 Thread Shawn Grover

Niel out of curiosity.. is your child window modal?  If so, the rules
are a little bit different.  We've found that the only way to process the
action page nicely (meaning without a blank window opening for a moment), is
to use a hidden IFRAME on the modal window, and set our form's target to the
IFrame.

Before we did this (and having proved it again afterwards), we were getting
some tough javascript problems to fix (unable to refresh the current page,
etc.).

Hope that helps.

Shawn Grover


-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 2:36 PM
To: CF-Talk
Subject: Re: Target back to parent.


Sigh
This is frustrating.  What a long day.

Neil

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 4:05 PM
Subject: RE: Target back to parent.


 That's what I have netscape for.  That's the only thing I like about it,
 is it's little javascript error log. It catches every javascript error,
 unlike IE, which sometimes lets them fly on by without doing anything.

 _
 steve oliver
 senior internet developer
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 4:01 PM
 To: CF-Talk
 Subject: Re: Target back to parent.


 Yeah for some reason that bit of code didn't work :(

 Neil

 - Original Message -
 From: Steve Oliver [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 3:51 PM
 Subject: RE: Target back to parent.


  You don't need to send the form variables back to the mainwindow.
 
  Just submit the form in the child window, process the data there, then
  close it and reload the main window, you will see the changes there
 upon
  reload.
 
  _
  steve oliver
  senior internet developer
  atnet solutions, inc.
  http://www.atnetsolutions.com
 
 
  -Original Message-
  From: Steve Oliver [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 11, 2002 3:47 PM
  To: CF-Talk
  Subject: RE: Target back to parent.
 
 
  Sure, just put a form in the child window, that goes to an action page
  (in the child window) to update your dbase or whatever.
 
  Then at the end of the action page. Include this.
 
  script
  opener.location.reload();
  wndow.close();
  /script
 
 
 
  _
  steve oliver
  senior internet developer
  atnet solutions, inc.
  http://www.atnetsolutions.com
 
 
  -Original Message-
  From: Neil H. [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 11, 2002 3:43 PM
  To: CF-Talk
  Subject: Re: Target back to parent.
 
 
  This is strange.  The application I am trying to emulate works like
  this:
  The child window posts back to itself and then forces the parent to
  refresh.
  I wonder if you all would have any suggestions on this one?
 
  Thanks,
 
  Neil
 
  - Original Message -
  From: Neil H. [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, March 11, 2002 3:28 PM
  Subject: Re: Target back to parent.
 
 
   Ok that doesn't seem good.  I found a basic way be searching but it
  doesn't
   seem to work.  I am using the chromeless windows so I think that is
  screwing
   me up.
  
   Neil
  
   - Original Message -
   From: Steve Oliver [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Monday, March 11, 2002 3:23 PM
   Subject: RE: Target back to parent.
  
  
Only way to name the main window mainwindow would be to have a
frameset with the frame name set to mainwindow
   
_
steve oliver
senior internet developer
atnet solutions, inc.
http://www.atnetsolutions.com
   
   
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 3:12 PM
To: CF-Talk
Subject: Re: Target back to parent.
   
   
How do you name the Main Window, main window?  (Did that make
 sense
  :) )
   
Thanks,
   
Neil
   
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 2:00 PM
Subject: RE: Target back to parent.
   
   
 form  Target=MainWindow onSubmit=self.close();

 Would that do the trick?  (haven't had the need to try it out,
 so
  no
 sure)

 Shawn Grover


 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 11, 2002 11:50 AM
 To: CF-Talk
 Subject: Re: Target back to parent.


 Correct so what would I use to submit the form to the opener
  and
then
 close the child?

 Neil

 - Original Message -
 From: Steve Oliver [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 1:08 PM
 Subject: RE: Target back to parent.


  What

CFTransactions and SQL Transactions?

2002-03-08 Thread Shawn Grover

I'm looking for more information about using CFTransaction.
My personal opinion is that it's better to use SQL Server transactions
within our stored procedures (cuz we are using SQL 2000 as our back end),
and transfer as much business logic as possible to the stored procs.

However, in a few cases, we've seen the requirement for something like this:

cftransaction action=BEGIN
cfstoredproc/cfstoredproc
cfif somecondition
cfstoredproc/cfstoredproc
cfelse
cfstoredproc/cfstoredproc
/cfif
/cftransaction

My concerns are that this may cause problems if the stored procedures
themselves contain transaction processing.  And I need to make a
recommendation based on solid information on whether to allow this process,
or force the developers to take the time to wrap this logic within one
stored proc call.  (of course, they can call existing stored procs from
within a stored procedure, and check the return codes to determine if a
rollback needs to happen before processing is complete).

So, any suggestions?  Thanks in advance.

Shawn Grover

__
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: Intranet apps

2002-03-08 Thread Shawn Grover

When I want to know what my local weather is like, I look out the window.
When I want to know the forcast (rarely), I watch broadcast news, or the
weather station on tv for a few minutes.

I tend to agree with Adam.  A company's main page should be about the
company - not necessarily about the environment around their building.
However, if the managers decide they want weather info, then I would handle
it as a simple link on the main page to a weather page.  This way, you are
still providing the information, but minimizing the use of screen real
estate for it, and allowing the user to choose if they want to see it or
not.

My two cents worth.

Shawn Grover

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:51 AM
To: CF-Talk
Subject: RE: Intranet apps


At 09:49 AM 03/08/2002 -0600, you wrote:
Not to ruin the party or be overly nosey, but please don't put local
weather
information on your corporate intranet, that's just plain wrong in so many
ways.

  I don't understand what is so wrong about it, however your description
below is obviously a flawed implementation.  I see no reason why you can't
get local weather based on the user's sign in.  ( New York people see New
York info, Chicago people see Chicago info, etc.. )


  When I worked for a global company based in Minneapolis, I would login
to their corporate intranet and 70% of the page was the local, Minneapolis
weather forecast. I'm sure the intentions were good, but everyone from New
York, Chicago, LA, UK, etc would get a nice big browser full of 26 and
heavy snow each time they needed information about the actual company.
It's
probably good to let people stick to their own sources for weather
information (morning news, newspaper, weather.com, etc), and keep the
intranet specific to the actual company.

Adam.




--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com


__
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: SQL Statement dumping data

2002-03-08 Thread Shawn Grover

My own thoughts are that it is better to let your database server handle
it's own data whenever possible.
By creating a CF Template, you are asking your web server to do data
operations.  Simple enough for the most part, but if the template get's hit
by multiple users, or you have a high volume site, then you are placing
unnecessary load on your servers.

My thoughts, not yours

Shawn Grover

-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 10:01 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data


WOW!!, I haven't worked with DTS packages and not much with stored
procedures. I will do some research. You think that this is a better
solution then building a cf template and setup an automated task to run
the cf template (in order to process the csv file)?

Thanks,
Jason Larson


-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:50 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data

set up a DTS package to import the CSV file.

create an SP to run the DTS package.

use SQL Agent to schedule the SP.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 11:31 AM
To: CF-Talk
Subject: RE: SQL Statement dumping data


What I am trying to accomplish is:

I have a client that will be pushing up a csv file to a site and then I
will setup a autmoated task that will dump all the data in a table and
then refresh the data with the data in the csv file.

Thanks for the quick reply
Jason

-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 9:26 AM
To: CF-Talk
Subject: Re: SQL Statement dumping data

Do you mean delete all the data or Export the data?

Clint

- Original Message -
From: Jason Larson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 08, 2002 10:22 AM
Subject: OT: SQL Statement dumping data


 I was wondering if anybody had the sql statement that will allow me to
 dump all the data out of the table in a database?

 Thanks for the help
 Jason






__
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: Intranet apps

2002-03-08 Thread Shawn Grover

I tend to agree with Adam.  A company's main page should be about the
company - not necessarily about the environment around their building.

  Whether or not it should be on the companies main page might be worthy of
an argument / discussion.

Yep, it could be an argument/discussion, with no right answer as it always
comes down to specific situations.  In cases like this, I'd just tell my
supervisor that it's a business decision (offering my arguments for or
against the idea), and let him handle it, or make the decision.  Then I do
whatever needs to be done.  In cases where I can make the choice (my own
site for example), then I consider the idea's worth, make a choice, and do
it.  grins

The arguments/suggestions presented are all good and valid.  My only comment
on all of this is that some people tend to be focusing on applets that work
with zip codes.  I live in Canada where we don't have zip codes, so these
tools become academic interest only (if that is ALL they can handle - I have
seen reference to others that would work fine)...  On the other hand, I
don't have a requirement to show weather on any of my projects at this time,
so I don't need the tool...

My thoughts not yours...

Shawn Grover

__
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



Recovering CF Admin password?

2002-03-08 Thread Shawn Grover

I have an aquaintance who has 'misplaced' his password for their Cold Fusion
Administrator. (no, it's not me).
I know I've seen this issue pop up before (and am searching the archives as
I type this), so am hoping someone can give me some info on how to
recover/change the admin password. (He has Network Admin access and physical
access to the server).

Cold Fusion 5.0 Enterprise, Win2K

Any tips?  Thanks

Shawn Grover

__
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: Forum or threaded app

2002-03-08 Thread Shawn Grover

I used the javascript/dhtml one by SNITZ at one time.  It seemed pretty
thorough and easily integrated into a site.  However, that was almost two
years ago so I don't know if it's still around, or what it's like if it is.

I just checked their URL (www.snitz.com - if I'm remembering right), and it
would seem they are no longer in the forum business..

On the otherhand, check the Developers Exchange, I know there were a few
apps like this in there...

Shawn Grover

-Original Message-
From: Wolf, Alan [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 5:18 PM
To: CF-Talk
Subject: Forum or threaded app


Is there a free easily configurable threaded discussion group application,
no where near the level of forums that someone could recommend?

Alan L. Wolf
MCSE, MCP, MCP + I
SAIC Frederick
PO Box B Bldg 458
Frederick, Maryland 21702
[EMAIL PROTECTED]
301-846-5479 (V)
301-846-6886 (F)

__
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: [OT] Re: VTML Builder

2002-03-07 Thread Shawn Grover

Oracle does the same thing in VB applications. We have always had to trim
our variables to get rid of the excess spaces

Doubt that helped ya any

Shawn Grover

-Original Message-
From: freddy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 1:25 PM
To: CF-Talk
Subject: Re: [OT] Re: VTML Builder


I already get a ton of spam...I don't like it so I delete it.  And also I do
not mind  filling out forms writing, or
deleting emails. Besides it seems I get so many more responses to any
criticism I make on this list than I do to any of
the questions I have needed answered so I thought I'd do it again :-)
I am still waiting for a single response to my question about char fields
returned via stored procedures in oracle being
padded to a length of 255 and whether it is a bug or there is a way around
it.
Thanks in advance...

Gyrus wrote:

  What difference does it make? If you want it fill out the info...
  it is faster than writing an email to complain about it.

 Maybe I'm being too cynical, but to me *spam* makes the
 difference. I was just looking for some assurance that the
 download is actually *free*, and not paid for by allowing
 the people you give your info to to sell that info on for
 marketing (I couldn't see any assurance on the site).

 BTW, it would have been faster for you to not criticise
 my questioning than to do so (nod to Bill Hicks ;)

 - Gyrus

 
 - [EMAIL PROTECTED]
 work: http://www.tengai.co.uk
 play: http://www.norlonto.net
 - PGP key available
 


__
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: Rotating banners

2002-03-06 Thread Shawn Grover

I agree that you have to consider the volume of traffic, and single
threading issues.  However, I would be assuming that the banner rotator
would be a javascript function on a page, or a CFM file retrieved via
CFHTTP.  In this case, I'd just use CF to build a javascript array of the
necessary URLs for each page.  Then the array/ordered collection does not
need to be in the application scope, it would be a local variable.

But, I do see ways to shoot that idea out of the water too.  I guess it
comes down to my in-experience with banner rotators, and banner ads in
general.  So, I will follow the list's guidance on this topic.

My $0.25 worth.

Shawn Grover

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 3:10 AM
To: CF-Talk
Subject: RE: Rotating banners


It all depends really on the level of traffic on the site.
The higher the traffic then the larger the sample and the closer the random
selection from the weighted list will get to the desired result.
To use Shawn's ordered collection from a randomly distributed list you'd
need to hold it or at least the latest selection in an application variable
which would move each time it was accessed. This would be problematic for a
high traffic site, since you'd have to single thread access to this part of
the application.cfm.
For a low traffic site this would give a better approximation and the
application variable might access might not be a problem.

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 19:03
To: CF-Talk
Subject: RE: Rotating banners


I don't think this will work well

Yes, you have listed the banner ID's in the proper percentage, but there is
no guarantee that the random number will
match that weighting.

For instance, a random number generator could (in theory) produce
1,1,1,1,1,1,4,5,1,1.  Now, if the ID at position 1 was weighted for 10%,
they are really getting more than 10% in this case.  The problem being that
you can't rely on a random number to pick the weighted elements.

A different option would be to maybe do like Ben mentioned below in creating
a list or array of the elements, but randomly distribute the IDs within the
Array (you've already determined how many there should be of each ID based
on the weight).  Then, you just need to loop through the list or array,
showing the next element.  This would result in the proper weighting, I
think.

Then again, I've never had to worry about rotating banners - but I'm
normally good at finding holes in solutions (sorry Ben).

Shawn Grover

-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 11:35 AM
To: CF-Talk
Subject: Re: Rotating banners


I would think that you would loop through your query, and build a list.
For each query record, loop from 1 to the weight value, and add the
bannerID to the a list called bannerIDList for each nested loop.  This way
if you have one banner with bannerID=301 and weight=2, and a second
banner with bannerID=302 and weight=10, the list would look like:

301,301,302,302,302,302,302,302,302,302,302,302

Then you could pull a random ID from this list and run the query.

 Elizabeth Walter [EMAIL PROTECTED] 03/05/02 01:14PM 
Hello-

I am developing a banner rotating tool and need some ideas on how to best
handle a requirement.  I have gotten the tool to a point where it displays
banners randomly- no problem.  Now what I need to do is give certain
banners
more weight than others:  some banners need to be displayed more
frequently than the rest.  The code that I have below gives equal weight
to
each banner; I need to find a way to give some banners more prevalence on
our pages.


cfset activeBanners=arrayNew(1)

cfoutput query=qryActive
cfset activeBanners[#qryActive.currentRow#] = #id#
/cfoutput

cfset rows = arrayLen(activeBanners)

cfset randomId = randRange(1,#arrayLen(activeBanners)#)

cfquery datasource=#dsn# name=qryBanners
SELECT
i.*,
a.advert_name
FROM
images i, advertiser a
WHERE
i.id = #activeBanners[randomId]# and
i.advert_id = a.advert_id
/cfquery


Any ideas?

Thanks in advance,
Elizabeth





__
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: Rotating banners

2002-03-05 Thread Shawn Grover

I don't think this will work well

Yes, you have listed the banner ID's in the proper percentage, but there is
no guarantee that the random number will
match that weighting.

For instance, a random number generator could (in theory) produce
1,1,1,1,1,1,4,5,1,1.  Now, if the ID at position 1 was weighted for 10%,
they are really getting more than 10% in this case.  The problem being that
you can't rely on a random number to pick the weighted elements.

A different option would be to maybe do like Ben mentioned below in creating
a list or array of the elements, but randomly distribute the IDs within the
Array (you've already determined how many there should be of each ID based
on the weight).  Then, you just need to loop through the list or array,
showing the next element.  This would result in the proper weighting, I
think.

Then again, I've never had to worry about rotating banners - but I'm
normally good at finding holes in solutions (sorry Ben).

Shawn Grover

-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 11:35 AM
To: CF-Talk
Subject: Re: Rotating banners


I would think that you would loop through your query, and build a list.
For each query record, loop from 1 to the weight value, and add the
bannerID to the a list called bannerIDList for each nested loop.  This way
if you have one banner with bannerID=301 and weight=2, and a second
banner with bannerID=302 and weight=10, the list would look like:

301,301,302,302,302,302,302,302,302,302,302,302

Then you could pull a random ID from this list and run the query.

 Elizabeth Walter [EMAIL PROTECTED] 03/05/02 01:14PM 
Hello-

I am developing a banner rotating tool and need some ideas on how to best
handle a requirement.  I have gotten the tool to a point where it displays
banners randomly- no problem.  Now what I need to do is give certain
banners
more weight than others:  some banners need to be displayed more
frequently than the rest.  The code that I have below gives equal weight
to
each banner; I need to find a way to give some banners more prevalence on
our pages.


cfset activeBanners=arrayNew(1)

cfoutput query=qryActive
cfset activeBanners[#qryActive.currentRow#] = #id#
/cfoutput

cfset rows = arrayLen(activeBanners)

cfset randomId = randRange(1,#arrayLen(activeBanners)#)

cfquery datasource=#dsn# name=qryBanners
SELECT
i.*,
a.advert_name
FROM
images i, advertiser a
WHERE
i.id = #activeBanners[randomId]# and
i.advert_id = a.advert_id
/cfquery


Any ideas?

Thanks in advance,
Elizabeth



__
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: it's finally happened

2002-03-05 Thread Shawn Grover

Had a similar problem this morning...

We had a power outage yesterday, and lost some work, but we got to leave
early as a result.  When I came back to my files this morning the file I was
working on had been damaged sorta.  It was a rendered version of my CF code
(the page was correct, but was no longer dynamic).  This could be because I
had cut and paste a rendered copy into a NEW document (for troubleshooting)
when the power went out.  I can only guess that somehow the file system
messed things up in this case as a result of the unexpected shutdown (no, I
did not save the NEW document over my original).

I had to rename the file, restore from Source Safe, then cut and paste the
changes to the original file (thank god I was only working on javascript at
the time).

I did look for a back up copy, but didn't find any.  Can someone tell me
where CF Studio stores it's backup files?  Or if it is an option I need to
turn on?  Thus far, I haven't found any option, but do recall seeing backup
files created before (*.bak I think).  Thanks in advance.

Shawn Grover

-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:49 PM
To: CF-Talk
Subject: it's finally happened


Studio crashed and the file I was playing with is blank.

I can find no files starting cf~ with anything in them which has been
suggested as a solution on this list.

I do have an encrypted version of the the original file, I wonder if
someone could send me the thingy which will unencrypt it... it would
save ms a lot of hair pulling

thanks.

--
Regards;

Richard Meredith-Hardy
-
[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: it's finally happened

2002-03-05 Thread Shawn Grover

Thanks Michael that's what I was looking for Hopefully it helps out
Richard as well (the original poster).

Shawn Grover

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 1:04 PM
To: CF-Talk
Subject: Re: it's finally happened


If your using studio 5 then you probably have a backup copy of your work in
C:\Program Files\Macromedia\ColdFusion Studio 5\AutoBackup\
It should give an option to reload the most recent backup when you restart.

At 02:49 PM 3/5/02, you wrote:
Studio crashed and the file I was playing with is blank.

I can find no files starting cf~ with anything in them which has been
suggested as a solution on this list.

I do have an encrypted version of the the original file, I wonder if
someone could send me the thingy which will unencrypt it... it would
save ms a lot of hair pulling

thanks.

--
Regards;

Richard Meredith-Hardy
-
[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



CFGrid Applet Help?

2002-03-05 Thread Shawn Grover

We have a case where previous contractors have created a customized version
of the CFGrid form element, then implemented it through Applets  I'm
looking for information on how to work with this applet in this manner

A snippet of code follows:

applet name=MyGrid code=comnomatterwarecontrolsourGridFormApplet
codebase=#AppBaseURL#/GLOBAL/JAVA archive=ourgridjar mayscript
height=145 width=230
param name=griddescription
VALUE=3%02#MyQueryObjectrecordCount#%02145%02230%020%020%020%02FF%02Re
d%02E%020%02N%02N%02%03%02%03%02%03%02N%02Verdana%02%03%02%03%02%03%02%03%02
%03%02N%02N%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02N%02N%01
RecordDate%02Y%02N%02Date%02135%020%022%02%03%02%03%02N%02N%01Field1%02Y%02N
%02Field+Name1%02%03%021%022%02%03%02%03%02N%02N%02%03%02%03%02%03%02%03%02%
03%02%03%02%03%021%02999%2C999%2E999%021%01Field2%02Y%02N%02Filed+Name2%
020%020%020%02%03%02%03%02N%02N
param name=griddata VALUE=#convertForGrid(MyQueryObject,
'Field1,Field2,Field3,Field4')#
param name=endeditdomcallback VALUE=endEditDisplay
/applet

The biggest question we have is how do we come up with the value for the
griddescription parameter?  And is it possible to dynamically add a
column?  Currently, we need to modify the number of columns the grid
displays (with the appropriate header, and visible/hidden property) but are
not having any luck  (we know the first number of GridDescription is the
column count, but changing it seems to break the applet)

I'm hoping someone can point me to an online resource on this, and the
possible parameters for the applet  We'd rather not have to
reverse-engineer the java code


Thanks in advance

Shawn Grover
__
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: Refreshing parent window on close

2002-03-02 Thread Shawn Grover

In the popup window's onClose event (or onUnload... I can never 
remember
which), enter this line:

self.opener.refresh();

Or, alternately, self.opener.location='originalPageURL.cfm';

Hope that helps.

Shawn Grover

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002 11:50 AM
To: CF-Talk
Subject: Refreshing parent window on close


Hi,

On one page I'm doing at the moment, there's a bunch of cfifs - in a
certain instance it will produce a button which, when pressed, will pop 
up a
window.  After the user has done what they need to do in the
popped-up-window, I need it to close and for the original parent window 
to
be refreshed.

Any ideas how?

Thanks

Will

---
A woman drove me to drink and I didn't even have the decency to thank
her. --W.C. Fields


__
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: Regular Expression Help

2002-03-01 Thread Shawn Grover

Going from limited memory of the subject here, but try something like this:

[\w the|a|..] (the 'the|a|..' part would be your preposition
list...)

I think the \w means you are looking for whole words.  Or it might be \W...

Hope that helps some...

Shawn Grover


-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:11 PM
To: CF-Talk
Subject: Regular Expression Help


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?

Much thanks,
Jared


__
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: Fusebox Question

2002-02-28 Thread Shawn Grover

For me, the concept of Fusebox is good, but in practicality it becomes a
pain to debug... having to track back through ALL included files to find an
error...



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 9:54 AM
To: CF-Talk
Subject: RE: Fusebox Question


Fusebox isn't really a changing of anything, all that it does it allow you
to have a more thought out way of managing your code. It borrows things from
oop where it applies. I use it as much as I can, I would not go back. It
allows me to reuse code much easier.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 11:48 AM
To: CF-Talk
Subject: Fusebox Question


I'm evaluating whether to use Fusebox methodology for our next Intranet. My
question is how does fusebox work with CF Advanced Security? We use our NT
Security groups for many of our apps. Don't want to lose that.


Thanks


__
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: Custom error (cfthrow) question

2002-02-28 Thread Shawn Grover

try scoping it with CFCATCH.NativeErrorCode not sure if that will help

On the otherhand, if your CFCatch block is catching ALL errors, then you
have to make sure it is a DATABASE type before you can check the value of
NativeErrorCode, or SQLState.  In my case, I make have a CFCatch block
specifically for database types of errors.

Hope that helps.

 Shawn Grover

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 3:00 PM
To: CF-Talk
Subject: RE: Custom error (cfthrow) question


I tried the nativeerrorcode attribute and I get this error (on a 5.0
server):

Just in time compilation error
An unknown attribute 'NATIVEERRORCODE' has been encountered at document
position (171:27) to (171:41) while processing tag CFCATCH. This tag
can
only take the following attributes:
*   TYPE




 -Original Message-
 From: Fred Jambukeswaran [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, February 28, 2002 12:19 PM
 To:   CF-Talk
 Subject:  RE: Custom error (cfthrow) question

 Lets say you wanted to throw a fieldmissing error
 use cfthrow like:
 cfthrow type=fieldmissing message=hey buddy fill in all the
 fields
 detail=missing field: first_name

 Then you can catch it along with your database error as follows:

 cftry
   !--- code here ---

   cfcatch type=Database NativeErrorCode =22001
   !--- do database error processing here ---
   /cfcatch
   cfcatch type=fieldmissing
   !--- do missing field error processing here ---
   /cfcatch
 /cftry

 -Original Message-
 From: Owens, Howard [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 28, 2002 3:03 PM
 To: CF-Talk
 Subject: Custom error (cfthrow) question


 I've used CFTRY/CFCATCH before.  But I've never been clear on exactly

 how to
 catch specific ODBC type of errors, to put up a custom error message.

 I want an error message for : ODBC Error Code = 22001 (String data
 right
 truncation)

 If that error comes up, as opposed to any other error, I want to be
 able to
 say, Hey buddy, you're input field is too big -- trim it back)

 I've used CFTHROW to do something like cfif form.field is blah
 throw
 /cfif  but I'm not sure I can catch and ODBC error and throw a
 custom
 error -- can I?  How would you handle this?

 H.




__
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



Modal Window and Java Applet?

2002-02-28 Thread Shawn Grover

We have a custom java applet which needs to run inside an IE55+ modal
window (opened via javascript)
We're seeing some problems with this - extremely slow page execution,
non-responsive java portion of the window, etc

Has anyone else run into this type of problem?  Any suggestions on how to
resolve it?

The applet seems to run fine if we use a regular window, but not in the
modal window

Hope I'm not being to vague
Thanks in advance

Shawn Grover
__
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: Modal Window and Java Applet?

2002-02-28 Thread Shawn Grover

DOH!!!  Nevermind, we did a test and was able to get things working fine in
a modal window outside our app.  So now it comes down to finding what part
of our architecture doesn't agree with this setup

Thanks anyway.

Shawn Grover

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 4:16 PM
To: CF-Talk
Subject: Modal Window and Java Applet?


We have a custom java applet which needs to run inside an IE5.5+ modal
window (opened via javascript).
We're seeing some problems with this - extremely slow page execution,
non-responsive java portion of the window, etc.

Has anyone else run into this type of problem?  Any suggestions on how to
resolve it?

The applet seems to run fine if we use a regular window, but not in the
modal window.

Hope I'm not being to vague...
Thanks in advance.

Shawn Grover

__
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: Template running more than once?

2002-02-27 Thread Shawn Grover

It is an action page for a form, but the submit button is NOT being
double-clicked.
I guess I can add this code to see if the browser somehow thinks a double
click is being done, but I don't think that is the issue.

Thanks though.

Shawn Grover

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 5:21 PM
To: CF-Talk
Subject: RE: Template running more than once?


Is is an action page off a form?

Browsers will allow a double click on the submit form to process the action

page twice

To keep people from clicking the submit button twice use this:

INPUT TYPE=Button NAME=Submit VALUE=Start Activity
onClick=if(this.value == 'Start Activity') this.form.submit();
this.value='Please Wait.';



At 05:00 PM 2/26/2002 -0700, you wrote:
Thanks.  We looked into the dynamic image tags and this doesn't seem to be
the problem in our case.

Anyone have any other ideas/suggestions?

Shawn Grover

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 5:00 PM
To: CF-Talk
Subject: RE: Template running more than once?


  We have a case where it appears our template is running twice - but only
  intermittently.

I had a similar problem and it was, thankfully, tracked down to an error in
a dynamic img tag. Disable images in your browser and see if it still loads
the tempalte twice. If it doesn't then try looking in any dynamic image or
anchor tags for improperly closed tags.



__
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



OT: Closing a window from JS without prompt?

2002-02-27 Thread Shawn Grover

I'm looking for ideas on how to close a Parent window from Javascript
without getting the confirmation prompt.
We don't have an issue with any child windows, but we open an interface to
our app then want to close the original window without the prompt.

Any tips?  Thanks in advance.

Shawn Grover
__
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:SOLUTION - Closing a window from JS without prompt?

2002-02-27 Thread Shawn Grover

We managed to do it, but by tricking the calling window.  Here's a code
snippet that might be useful for some of you out there:

mainwin = window.open('#NewURL#', 'mainwin', '');
!--- Close original window, this trick works under IE5.5+ only ---
mainwin.opener = mainwin;
window.opener = mainwin;
window.close();

(to be fair, I have to give credit for this to another of our developers...)

Shawn Grover


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 12:28 PM
To: CF-Talk
Subject: RE: Closing a window from JS without prompt?


that snippet didn't work in either NS or IE for me

IE didn't even load the page and NS bombed because it said that closes
was
not defined

i just pasted that snippet into a page.

is there something else that needs to be done?




Justin Waldrip [EMAIL PROTECTED] on 02/27/2002 01:17:54 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk [EMAIL PROTECTED]
cc:

Subject:  RE: Closing a window from JS without prompt?


I have an app that opens up a window full screen and then I need to
close the parent window that is behind it. So what I did was added th
e
object code below to the head and then refresh the parent window with
the onload function that initiates and closes the parent window. Work
s
like a champ for me. You might have to play around with it depending
on
your need.

html
head
 titleUntitled/title
 !--- // Must have this in the head // ---
 object id=closes type=application/x-oleobject
classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11
  param name=Command value=Close
 /object
/head

script
function closeme() {
 closes.Click();
}
/script


body onload=document.form.CloseArea.focus();

form
 input type=text name=CloseArea onfocus=closeme()
style=width: 0px;
/form

/body
/html

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 1:04 PM
To: CF-Talk
Subject: OT: Closing a window from JS without prompt?

I'm looking for ideas on how to close a Parent window from Javascript
without getting the confirmation prompt.
We don't have an issue with any child windows, but we open an interface

to
our app then want to close the original window without the prompt.

Any tips?  Thanks in advance.

Shawn Grover



__
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: Developer version of CF Server 4.5?

2002-02-27 Thread Shawn Grover

download the Enterprise evaluation version
when the 30 days times out, it becomes the developer version.

Shawn Grover

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 1:48 PM
To: CF-Talk
Subject: Developer version of CF Server 4.5?


Anybody know where I can download a developer version of CF Server
4.5?  Can't seem to find one on MM's site.

__
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: RE: Developer version of CF Server 4.5?

2002-02-27 Thread Shawn Grover

DOH!!!  I obviously didn't read that close enough


- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 1:02 PM
Subject: Re: RE: Developer version of CF Server 4.5?


 I would, but there are no versions of CF Server 4.5 on MM's site.


 - Original Message -
 From: Shawn Grover [EMAIL PROTECTED]
 Date: Wednesday, February 27, 2002 1:54 pm
 Subject: RE: Developer version of CF Server 4.5?

  download the Enterprise evaluation version
  when the 30 days times out, it becomes the developer version...
 .
 

  Shawn Grover
 

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, February 27, 2002 1:48 PM
  To: CF-Talk
  Subject: Developer version of CF Server 4.5?
 

 

  Anybody know where I can download a developer version of CF Server
  4.5?  Can't seem to find one on MM's site.
 

  ___
 _
 __
  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?sideb
 ar=lists
 


__
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: Template running more than once?

2002-02-26 Thread Shawn Grover

Thanks.  We looked into the dynamic image tags and this doesn't seem to be
the problem in our case.

Anyone have any other ideas/suggestions?

Shawn Grover

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 5:00 PM
To: CF-Talk
Subject: RE: Template running more than once?


 We have a case where it appears our template is running twice - but only
 intermittently.

I had a similar problem and it was, thankfully, tracked down to an error in
a dynamic img tag. Disable images in your browser and see if it still loads
the tempalte twice. If it doesn't then try looking in any dynamic image or
anchor tags for improperly closed tags.

__
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



Template running more than once?

2002-02-25 Thread Shawn Grover

We have a case where it appears our template is running twice - but only
intermittently.
We did a SQL Profile/Trace and noticed two calls to the stored proc on the
page, for one page request (us clicking the form submit button only once).
We also added some logging capabilities to the stored proc involved here and
saw something like this:

SP Starting
SP Starting
SP Processing
SP End
SP End

(notice the SINGLE processing line)

This again was would occur on a single page submission.  We tested this by
going through the page submission routine a number of times, and sometimes
it works as expected and others causes this problem.  Any ideas?

We do take into account concurrency via a where clause like this Where
Last_Updated = @LastUpdated AND ... (with proper date conversions and
such).  Then check to see if @@RowCount is zero - which would indicate a
concurrency issue, and failed update.  The error we are getting seems to
indicate the concurrency issue - however, our data does get updated. And
checking the SQL Trace shows two calls to the SP occasionally which
indicates the template is executing twice.  If we are getting the
concurrency error, BUT our data is updated, then the page seems to be
running, updating the data, then running again, and then failing.

So, I'm looking for ideas on how this situation could occur, and how to
resolve it.  We are running CF5 on Win2K with a SQL 2000 back end.

Thanks for any input.

Shawn Grover

(my appologies for the rambling description).
__
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: clean redirection?

2002-02-21 Thread Shawn Grover

In this case, you could have a page strictly for redirection (let's 
call it
redirect.cfm).
Then, in that file you'd do something like this:

cfparam name=URL.q default = 

cfif len(URL.q) gt 0 then
cflocation url=#URL.q#
cfelse
... redirect to another page - either back, or an error page maybe
/cfif

This would display the page, without the actual refering link
(www.mysite.com/redirect.cfm?q=http://anothersite.com), and would 
allow you
to add logging or anything else before the CFLOCATION call.

Hopefully I understood what you are asking correctly.

Shawn Grover

-Original Message-
From: Jason Davis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 2:24 AM
To: CF-Talk
Subject: Re: clean redirection?


Jim,

 They're just using a bit of script to control what appears in the
browser's
 status bar, triggered by the mouseover.  This is from a google link:

 a href=/url?q=http://www.gamblehouse.com
 onMouseOver=window.status='go to www.GambleHouse.com';return 
true
 onMouseOut=window.status='';return true
 Online Casino Guide - Find Casinos with the Best Payouts and 
Bonuses!/a

I know about the status bar, what I'm asking is, what is the code 
behind
/url?q=http://www.gamblehouse.com

how are they reffering the webpage, without the
/url?q=http://www.gamblehouse.com
address appear on my browser?

Thanks.



 Jim


 - Original Message -
 From: Jason Davis [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, February 21, 2002 12:14 AM
 Subject: OT: clean redirection?


  I want to reffer certain webpages upon click of an ANCHOR
  something like:
  a
 
href=http://www.mydomain.com/redirect/ref.cfm?url=http://www.jumpto
com
  Click here to visit/a
 
  Issue is, on ref.cfm I have a script that counts the hits
  I gave to http://www.jumpto; - but I don't want
  the entire link
  
(http://www.mydomain.com/redirect/ref.asp?url=http://www.jumpto.com)
  to be displayed in the address bar of IE.
 
  I tried scriptlocation.href='http://www.jumpto.com'/script
  on the ref.asp file, but it cropps the back button..
 
  I was wondering how google/yahoo do their reffering, without
  the user seeing the actual reffer.
 
  Google:
  http://www.google.com/search?hl=enq=casino
  (see one of the sponsered links)
 
  Yahoo:
  http://search.yahoo.com/bin/search?p=casino
 
 

__
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



OT: intercepting keystrokes??

2002-02-12 Thread Shawn Grover

Is it possible to intercept the keystrokes from anywhere on the web page
(i.e. an input text box may or may not have focus).

I have a need to simulate the windows behaviour of the Alt-Key combinations
(i.e. Alt-F opens a file menu, Alt-S may trigger a button event, etc.)

I'm looking for ideas on how to do this.  I'm assuming I'll need javascript
and event coding.  A sample would be good too - should be enough for me to
get started.

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: Future of the internet

2002-02-11 Thread Shawn Grover

I hear all this talk of limited Broadband.  Maybe I'm just lucky living 
in a
metropolitan area in Canada - DSL and Cable are the same price and is 
fairly
affordable (about $40 Cdn / month).  It'd be nice if it were cheaper, 
but
this isn't too bad.  Then again, I have heard some grumblings that 
Canada is
a bit further ahead in adoption of newer technology (could be wrong 
though).

As for the Future of the internet... makes me think - with all these 
Nodes
on the I-Net, sooner or later someone is going to try to put them 
together
in a neural net or something similar.  So THE killer app in this case 
would
be the I-Net itself...

On a different note, I don't see how this discussion has much to do 
with
Cold Fusion anymore grins

Shawn Grover

-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 7:29 AM
To: CF-Talk
Subject: RE: Future of the internet


I agree with this on both counts, even here in Australia the feeling is
very mutual. The broadband that is reliable is limited to coverage
(Cable), and the DSL services are far to expensive and will kill the
market and at the moment is also very unreliable with the uptime.

I myself have had the time to think about where the future is headed,
and there many opportunities that will open up when this gets sorted,
But there has to be 2 things present.

1) The medium has enough coverage to give your product the coverage it
needs, and to deliver the way this is to look.

2) Security, this will be a big undertaking and people would be 
hesitant
to hook to something that offers very little protection to any stored
information.

But I see so much old technology that could be changed for the better,
when broadband is here.



-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, 12 February 2002 12:43 AM
To: CF-Talk
Subject: Re: Future of the internet

The killer app for now is broadband, and that's something that the US
is
really falling behind on. Once broadband is prevalent, it will allow 
the
web
to BE both the medium (for information and entertainment) and the
mechanism
(for delivery of content and information, as well as a voice, video, 
and
data communications medium).  If the government/telco's/etc. don't get
their
collective acts together, we're going to be an InfoTech 3rd world
nation.  I
mean, hell, I live in a neighborhood of $300k houses in suburban Phila
and
apparently nobody wants to provide brandband to us.  After that, I 
think
the
next killer app is mainstream home/personal server/firewall (or, more
accuratly, appliance) for storing information, video, music, etc., but
for
that to succeed, broadband needs to be prevalent.

Sorry, Doug, but I think it goes way beyond the integration of Flash 
and
CF,
though personal bandwidth is important for that to succeed as well.

Pete


__
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



OT: Java Menu?

2002-02-10 Thread Shawn Grover

I find myself in need for a decent java based menu system.  The ones at
www.imint.com are a bit large for our purposes (file size).

I need something that emulates a Windows menu system, allows check boxes and
possibly icons on the menus, and is as small as possible.  I thought I'd ask
here before I go through the hassles of building one myself.  The source
code must be part of the purchase price (or a free one is better).

Thanks for any tips.

__
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



Another RegEx question

2002-01-29 Thread Shawn Grover

I find myself needing to find all the HREF values on a given page.  Regular
Expressions are the answer, but I haven't nailed the pattern yet.

Any help???

I've tried the following:
   \w+:\/\/[^/:]+:\d*?[^# ]*
   (\w+)://([^/:]+)(:\d+)?/(.*)[\s|]
   href=\S.*[\S|]

They tend to give me more than just the href value, like the next 3 tags and
text between em.
The first two patterns are directly from a microsoft article on this (I'm
working in VB too), with the first being the same as the second but no
__
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: Another RegEx question

2002-01-29 Thread Shawn Grover

Thanks, but if I have an anchor tag in this format, it won't return the 
HREF
alone
a href=http://someplace.com/page.cfm; name=SomeName

Your regular expression will include the name attribute as well.


-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:20 AM
To: CF-Talk
Subject: RE: Another RegEx question


If you just want the value of href, do something like:

Rereplacenocase(string, a href=([^]*), \1, ALL)

__
steve oliver
cresco technologies, inc.
http://www.crescotech.com


-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 29, 2002 1:10 PM
To: CF-Talk
Subject: Another RegEx question


I find myself needing to find all the HREF values on a given page.
Regular
Expressions are the answer, but I haven't nailed the pattern yet.

Any help???

I've tried the following:
   \w+:\/\/[^/:]+:\d*?[^# ]*
   (\w+)://([^/:]+)(:\d+)?/(.*)[\s|]
   href=\S.*[\S|]

They tend to give me more than just the href value, like the next 3 
tags
and
text between em.
The first two patterns are directly from a microsoft article on this
(I'm
working in VB too), with the first being the same as the second but no


__
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: Cold Fusion and Visual Source Safe

2002-01-29 Thread Shawn Grover

We use it extensively for all of our projects - CF and otherwise.

For our web apps, it's pretty handy for each developer to use the same
working folder on the development server.  But you have to be aware of 
who
has what checked out in that case.

VSS saved our buts once or twice when files became corrupted - we were 
able
to just retrieve the next one back in the history.

On the other hand, we did have some problems with the VSS database 
becoming
messed up.  We ended up fixing it when new servers were installed (we 
were
functional, but just had to be extra careful).

I wouldn't approach any commercial venture with out version control of 
some
sort.

Shawn Grover

-Original Message-
From: Jaye Morris [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 2:28 PM
To: CF-Talk
Subject: Cold Fusion and Visual Source Safe


Hope this is not too OT.  Are there any dev teams uisng Visual Source
Safe for their code (or similar product)?  Did you find it useful?


// Jaye Morris, Multimedia Designer

__
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: Cold Fusion and Visual Source Safe

2002-01-29 Thread Shawn Grover

snip
And, as with any versioning system, your source control is only as good a
s long
as all users agree to use it consistently.
/snip

Agree??? I didn't have a choice.  I was pretty much told to use it, or go
elsewhere. 
(hmmm that sounds more extreme than it was...)
__
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: little OT, getting DataTypeEnum from DAO

2002-01-29 Thread Shawn Grover

You are looking at the constant values for Field Types.  This type of 
info
is also available through ADO.  I had found a list on 
msdn.microsoft.com of
the values and their names, but don't quite remember where.  I was 
doing
searches on ADO and OpenSchema at the time.

Hopefully this is enough to get you started.

Shawn Grover


-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 1:26 PM
To: CF-Talk
Subject: little OT, getting DataTypeEnum from DAO


Hi all,
I'm doing a little experimentation with getting table  field 
information 
from Access using some code Brendan Avery posted (RE: SQL for grabbing 
list 
of tables in DB / fields in table?). My intention is to use this 
information to further automate the creation of administration systems.

Anyway, I've got it sussed to the point of being able to get the table 
names, field names, types, sizes, wether they are required etc, however 

the 
types are defined as an integer which is identified by a DAO constant.

Now, I know nothing really about this whole COM business, I used 
Object 
Browser in access and found DAO.DataTypeEnum holds all these 
constants, 
but how do I get that information into CF ?

Here is the code as it stands...

CFOBJECT TYPE=COM ACTION=CREATE NAME=objAccess 
CLASS=Access.Application
CFSET objDBEngine=objAccess.DBEngine
CFSET 
objDatabase=objDBEngine.OpenDatabase(d:\jobs\web-fusion\Dist_demonstr

ator_c
lient\_database\ECommerce.mdb)
CFSET objTableDefs=objDatabase.TableDefs

CFLOOP COLLECTION=#objTableDefs# ITEM=tableDef
CFOUTPUT
H3#tableDef.Name#/H3
CFFLUSH
CFLOOP COLLECTION=#tableDef.Fields# ITEM=field
#field.Name# (#field.Type#, #field.Size#, #field.Required#)BR
CFFLUSH
/CFLOOP
/CFOUTPUT
/CFLOOP

Anybody here a COM guru :-)




__
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: extracting data from a huge text file

2002-01-25 Thread Shawn Grover

Another option..  Why not open it as an ODBC data source, and let the 
ODBC
drivers worry about the size of the file?  We recently did something 
like
this with VB for a text file, only a few lines/records though.  But it
should still work well with larger files.


-Original Message-
From: Chris Giminez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 6:56 PM
To: CF-Talk
Subject: Re: extracting data from a huge text file


It's called CFX_ReadLine and with an initial test, it looks like it's 
going
to do the trick.
thanks very much!!

Chris





 I'm trying to retrieve data and put it into a database from a text 
file.
 The text file is over 100MB with  (I'm guessing) around 260,000 
records,
each record contains 85
 fields.
 
 I tried to create a conditional loop at each line break, which works 
fine
if I am working on a
 smaller version of the file, but chokes on the 100MB monster. Is 
there a
more efficient way to
deal
 with this other than looping through it or is there a way to break 
this
file up into smaller
chunks
 and deal with it piece by piece?


 Been a while since I used it but I wrote a cfx called... hmm.. I 
don't
 recall what it was called /-) ... anyway, the cfx was to read in log
 files one line at a time.

 Which is what it does, one carriage-deliminated line per call, not 
the
 entire file all at once.

 It's somewhere at http://www.intrafoundation.com/freeware.html.

 --min
 

__
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: Geographical dispersion

2002-01-25 Thread Shawn Grover

Isn't this the type of thing Akami does?? Hope I got the name right.

If I'm remebering right, they mirror a website to multiple geographic
locations, and requests for the site are served by the location closest to
them (thus improving speed).

Shawn Grover

-Original Message-
From: Paris Lundis [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 4:41 PM
To: CF-Talk
Subject: RE: Geographical dispersion


well a solution will be elegant and certainly complex... I forgot expensive
as well... client should be deep pocketed.. whether you do it yourself or
opt for proven products... it take enough work to call it a skill..

hopefully others will chime in on this topic.

First, outsource your DNS... someplace you have the ability to dynamically
update your IP info via the web when you need to live time... See Enom.com
service... plug in your multiple locations separate Nameservers.. be sure to
register those initially as nameservers with INternic...

From the switching layer, companies like F5 and Coyote Point has DNS loaded
switches/load balancers that have geographic distribution... you of course
need multiple units on each end for redundancy.. it gets expensive... but
they are cheap on Ebay...

From the disk end... I believe you can easily map a remote drive via
Windows.. based on IP with proper permissions.. once you do that, you can
run one of the may mirror packages to push the flat files into
synchronization.. ideally, one is the master and one is the servant... Folks
like EMC offer addon software (20-40k) for their Symmetrix system that
allows such... but mapping and lowly software likely will cut it for you..
or an FTP client with duplication feature set...

From the database side... SQL Server 7 + has some transaction stuff...  I
don't use such.. but mature databases will have distribution facilities...
Oracle and MySQl also have a good set of tools to accommodate...be sure to
buy some aspirin before you start...getting it to work and synching
seamlessly is another feat...

Those are the pieces...

With the multiples and DNS stuff, you also can get full usage of all gear
versus having unused gear that isn't regularly tested and operational
online...  highly recommend doing it that way.. otherwise when something
happens you might be embarrassed.

-paris




-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 17:50
To: CF-Talk
Subject: Re: Geographical dispersion


See if you can find a hosting company that does load balancing..M
aybe try co-locating 2 servers in different places with Windows 2000
server to load balance..or find someone that has a hardware load
balancer.without the client actually having their own physical lo
cation/network available it may be difficult

 [EMAIL PROTECTED] 01/24/02 09:10PM 
Hi!
We have a client who needs their ColdFusion site mirrored geograph
ically.
They need it so that if Seattle gets hit with an earthquake (since we
 are
out of the Seattle area), the mirrored site in Chicago (for example)
will
automatically pick up without any site outage.  I am not familiar wit
h all
the details of how mirroring works, but the hosting companies I have
talked
to so far cannot offer this service... they say that mirroring it in
the
same rack is not a problem, but mirroring across the country poses so
me kind
of problem. Is there a hosting company that anyone knows of that can
take
care of this situation?  We actually have two applications for a solu
tion to
this problem.  We have this new site that needs to be hosted and mirr
ored,
but we also have a Linux server in a data center here that needs to b
e
mirrored somewhere else in the country also (with auto switch over).
 I
thought Akamai would be a solution, but the rep from there said that
they do
only hit dispersion, but not actual content and site mirroring.  Any
ideas?
Sorry if some of the terminology is off...kind of over my head here..
  :)
Thanks, Christine
[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




__
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: msmenu

2002-01-24 Thread Shawn Grover

There is a javascript menu at www.milonic.com/menu that does this for 
you.
And is cross platform compatible.
But that may not be an option if you are already developing with the 
msmenu.

Shawn Grover

-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 11:25 AM
To: CF-Talk
Subject: msmenu


Is there a way to highlight the menu header after you've clicked a link 
in
one of the menus?

In other words can I alter the color scheme of individual items instead 
of
the whole menu bar?

Thanks,

Steven D Dworman
-
Web Consultant
Systems Administrator

ComSpec International - http://www.comspec-intnl.com
phone: 248.647.8841
cell:  734.972.9676
-
EMPOWER-XL ***Software for Higher Education***
http://www.empower-xl.com

__
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: CFStoredProc vs CFQUERY

2002-01-21 Thread Shawn Grover

Use the CFPROCRESULT name=MyQueryObject inside the CFSTOREDPROC 
tags
(normally the last one specified)...

Using cfstoredproc tags eliminates a bunch of errors - in the CFQuery 
call,
how do you know the Date is a proper format?  the cfprocparam tags 
handle
any neccessary conversion (within reason) for you.

Also, with cfstoredproc, you can have multiple recordsets returned, and 
have
access to the Stored Procedures return value.  You can't do that with
CFQuery.

Shawn Grover

-Original Message-
From: Steven Durette [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 6:15 PM
To: CF-Talk
Subject: CFStoredProc vs CFQUERY


I was just wondering if any one knew the difference between the 
following:

CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO 

dbVarName = @param2
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE = 

BAR dbVarName = @param3
/CFSTOREDPROC

AND THIS:

CFQUERY Name=qryMyQuery DATASOURCE=mydatasource
{CALL usp_myproc(01/23/1971, 31)}
/CFQUERY

Also, when the stored procedure returns a query, how would you access 
it 
through the first method?  The second method at least allows you to 
name 
the query so that you can access the resulting recordset.

Thanks,

Steve Durette
Database Administrator/Web Developer
Engineering/Construction System Support
SBC/Ameritech



__
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



Looking for suggestions for a Virtual Museum

2002-01-16 Thread Shawn Grover

One of the sites I volunteer my time for is considering putting their museum
online (a virtual museum).

I'm looking for ideas on how to accomplish this.  When they say virtual
museum they simply mean providing access to some/most/all of the museum
resources online.  We do not necessarily need a VRML environment (and I'd
rather avoid the extra complexity).  So basically a search engine to their
resources.

I have considered taking the content management route (meaning they upload
Word/PDF/Image/etc. files, and it gets mapped into the site automatically),
but am not yet convinced this is the best solution.  Most of the museum
artifacts are old magazines, pilot and maintenance manuals and such - well
suited for content management I think.  But I'm not sure if a CM system
would be able to handle our particular needs for searching/sorting/storage.
(I'd roll my own if we go this route, so that's not really a strong
argument).  Unfortunately, they only have maybe 1% (if that) of their
resources in digital format thus far.

Anyone want to offer ideas on how to approach this project??  It would be
great to hear from someone who has but museum resources online before.

If it helps, here is their current website:  www.arrow2000.ab.ca  This site
is undergoing massive revisions (using the powers of Cold Fusion of
course... grins) and will likely integrate with the virtual museum
concept at a later date.

Thanks for any feedback.  I think this project is a bit bigger than I
thought when I first agreed to take it on, but hey, I gotta learn how to
handle a project of this size sooner or later...

__
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: Phone App Server

2002-01-15 Thread Shawn Grover

Took a look at their web site.  didn't see any details relating to CF.

How does it work with CF???  tied into a web page? back end processing 
of
the voice messages?  web presentation of the recorded messages and 
managment
items???

Just curious - we have an in-house developed phone system, it might be
interesting to see how this relates...

Shawn Grover

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 11:36 AM
To: CF-Talk
Subject: RE: Phone App Server


So close. Thx Howie.

Duane

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:18 PM
To: CF-Talk
Subject: Re: Phone App Server


www.voxeo.com

Howie

- Original Message -
From: Duane Boudreau [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 12:30 PM
Subject: Phone App Server


 Hi All,

 Does anyone know the url and name of the company that makes the phone 
app
 software that interacts with ColdFusion? The company was Voxio or 
Vexio,
or
 something like that. If anyone was at the 2000 DevCon Jeremy Allaire
 built/showed a music selection demo of it on stage on the second day.


 Thanks,
 Duane




__
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



Need clarification on Content Management

2002-01-15 Thread Shawn Grover

To me, Content Management is one of those terms which is used to describe a
process, but leaves room for interpretation.

If Content Management means what I think it does (web managed system for
adding content to a web site), it could be useful.  But does this mean the
added content is HTML files? database fields presented in HTML? PDF files?
Word files?, etc.

I guess what I'm looking for is a system where a user can upload a file of
any given format, and have the system automagically tie it into the public
side of the site.  Is this the purpose of Content Management?

Thus far, to allow this type of features, I've been making the user enter
the data into a web based form, which populates a database, and then
presenting the data as required.  Is there an easier way??

Thanks for any info... and I appologize for my ramblings...

__
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



<    1   2   3   4   5   6   >