RE: Java Mailing List

2003-12-23 Thread Andre Mohamed
Great forums at the Big Moose Saloon here: www.javaranch.com
http://www.javaranch.com/ 

 
Regards,

 
Andr

 
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2003 17:11
To: CF-Talk
Subject: Re: Java Mailing List

 
 Does anyone have any recommendations in regards to a decent Java
mailing
 list? I was not too impressed with the forums over at suns site. Not
to
 generalize but the developers there seem to snub beginners, which is
too
bad
 since we all start somewhere.

really? i found the new to java forums to be relatively helpful, ditto
for
the i18n forums (though i've really never seen anythig like the cf
community). maybe something here:
http://www.cafeaulait.org/mailinglists.html

you might also post questions to the java  cf forums. there are some
sharp
folks there.
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFHTTP Question!

2003-10-17 Thread Andre Mohamed
Allan,

 
What is the URL you need to type into a browser in order to run
menu.asp?

 
That is the URL you need to specify for using CFHTTP.

 
(Remember when using CFHTTP it is the ColdFusion server running the
request so the URL needs to be from the perspective of what the
ColdFusion server can see the menu.asp page as which could mean using a
127.0.0.1 or localhost address since it is on the same server. Also, in
general better to use IP addresses to avoid domain name resolution
issues though you loose the obvious benefits.)

 
Andr

 
-Original Message-
From: Allan Clarke [mailto:[EMAIL PROTECTED] 
Sent: 17 October 2003 16:01
To: CF-Talk
Subject: CFHTTP Question!

 
Hello everybody,

I'm trying to call a .asp file from my coldfusion page
using cfhttp and I keep getting errors. Both files are
on the same server, just different folders under the
site webroot.
This should explain it:

The ColdFusion file is in
C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm

and the ASP file is in
C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp.

Can somebody show me how to use cfhttp to call the asp
file (menu.asp) in my coldfusion file
(searchreport.cfm)

Many Thanks
Allan

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFHTTP Question!

2003-10-17 Thread Andre Mohamed
If you are actually on the ColdFusion server can you browse to that same
URL?

 
Andr

 
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] 
Sent: 17 October 2003 16:55
To: CF-Talk
Subject: Re:CFHTTP Question!

 
When I browse the asp file in the browse, it displays the menu on the
browser. This is the url I'm using:

http://myProject/site/includes/topmenu/folder2/menu.asp

But when I include this url in cfhttp I get 
You are not authorized to view this page 
You do not have permission to view this directory or page using the
credentials you supplied. 

error.

Here is my code:

CFHTTP url="">
METHOD=GET RESOLVEURL=true throwonerror=yes/
cfoutput#CFHTTP.FileContent# /cfoutput

Am I missing some attributes in my cfhttp tag?

Allan,
 
What is the URL you need to type into a browser in order to run
menu.asp?
 
That is the URL you need to specify for using CFHTTP.
 
(Remember when using CFHTTP it is the ColdFusion server running the
request so the URL needs to be from the perspective of what the
ColdFusion server can see the menu.asp page as which could mean using a
127.0.0.1 or localhost address since it is on the same server. Also, in
general better to use IP addresses to avoid domain name resolution
issues though you loose the obvious benefits.)
 
Andr
 
-Original Message-
From: Allan Clarke [mailto:[EMAIL PROTECTED] 
Sent: 17 October 2003 16:01
To: CF-Talk
Subject: CFHTTP Question!
 
Hello everybody,

I'm trying to call a .asp file from my coldfusion page
using cfhttp and I keep getting errors. Both files are
on the same server, just different folders under the
site webroot.
This should explain it:

The ColdFusion file is in
C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm

and the ASP file is in
C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp.

Can somebody show me how to use cfhttp to call the asp
file (menu.asp) in my coldfusion file
(searchreport.cfm)

Many Thanks
Allan

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
_


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Dynamic page processing

2003-10-17 Thread Andre Mohamed
2) Create actual blank pages on the filesystem named astronomy.cfm, etc
when the content is created, then use application.cfm to get the ball
rolling.Is there much, if any, overhead in using the application.cfm
file in this manner?

 
A variant of this approach that is used by content management systems
like CommonSpot (http://www.paperthin.com http://www.paperthin.com/ )
is to have “stub” pages which set up various variables etc. that the
framework uses e.g. have an astronomy.cfm stub page which simply
includes/redirects/modules the actual content. This requires the
publishing and synchronizing of these stub pages when content is being
added/updated but you can utilize this to your advantage by allowing
them to cache various page settings.

 
This approach is somewhere in between having fully published static
pages which are very fast to serve and fully dynamic pages which are
always up to date but draining on the server.

 
Andr

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Is a Datasource really setup?

2003-10-16 Thread Andre Mohamed
Dwayne,

 
Try this:

 
cfscript
// Get the MX Service Factory...
factory =
CreateObject(java,coldfusion.server.ServiceFactory);
// Get the data source service...
dataSourceService = factory.dataSourceService;
// Finally, Get the datasources!
datasources = dataSourceService.getDataSources();
/cfscript

 
cfdump var=”#datasources#”

 
Might do the trick for you.

 
Andr

 
-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
Sent: 16 October 2003 02:14
To: CF-Talk
Subject: Is a Datasource really setup?

 
Is there some code that I can run to check the existance of datasource.
My code reporting that the tables in database does not exist. My host
ISP says that the Datasource has been registered with CF.This is a new
setup and I just don't think the datasource was setup correctly.Is
there any code that I can run to test it

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: developing java cfx

2003-10-14 Thread Andre Mohamed
This is a known issue, no way around it as far as I recall other than
getting your code right first time :-)

 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 14 October 2003 10:28
To: CF-Talk
Subject: developing java cfx

 
According the the CF docs reload=always is supposed to keep me from
having to restart CF everytime I recompile my cfx tag, but it doesn't
seem to be working. How do you guys do it?

-- 
mailto:[EMAIL PROTECTED]

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Nesting CFTRANSACTION?

2003-10-03 Thread Andre Mohamed
Jim,
 
There are several approaches one can take here. One of those
possibilities is to utilize the Composite Design Pattern (google will
give you endless examples including:
http://www.javaworld.com/javaworld/jw-09-2002/jw-0913-designpatterns_p.h
tml) perhaps in combination with the Strategy Design Pattern to
implement the transaction control (again google will help)
 
Another approach, if Composite is not appropriate for your parent-child
hierarchy is to allow transaction control to be handled by a
“service-oriented” CFC leaving the finer granular CFC’s free to ignore
the issues of transactions. After all, once you include the transaction
control at the lowest level, it precludes that CFC being used as part of
any larger transaction in the future – and that includes ones you
haven’t thought of yet. 
 
Andr
 
 
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: 03 October 2003 06:14
To: CF-Talk
Subject: Nesting CFTRANSACTION?
 
I'm in a position where a component can have a parent/child relationship
with other components of the same type.

When I delete a single component, no problem - the method starts a
transaction, deletes the component information from the database, cleans
up references to it in several join tables and updates a couple of
administrative tables.

When a component has Children I would like to delete them as well in the
same transaction.The best way to do this, of course, is to loop
through the children and call their delete() methods.

However when I do this (as I am) from with the parents delete() method
(making the call sorta recursive-like) I get the error we all know and
love: Cannot nest CFTRANSACTIONS

In short I don't want to really nest a transaction (that makes no real
sense) I simply want a way to include all the work in a single
transaction.Some way to determine if I'm in a transaction already and
not try to start a new one.

I'm trying to find some way to do this, perhaps by catching and using
the nesting error itself - but nothing remotely elegant is presenting
itself.

Any solutions, ideas or workarounds?

Jim Davis



_

[Todays 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Customg tag that will ring a phone

2003-10-03 Thread Andre Mohamed
I suspect this will only be really feasible via a C++ based CFX
leveraging the Telephone API (TAPI) if you are on Windows (not sure of
the solution to use on a Unix based OS). I know there is some C++ code
floating about to do this (try google) and all it would require is
wrapping it up in a CFX – your development team is probably already
aware of this. 
 
I doubt there is already a CFX implemented for this purpose.
 
Andr
 
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED] 
Sent: 03 October 2003 16:08
To: CF-Talk
Subject: Customg tag that will ring a phone
 
Hi,

is anyone aware of a CFX tag free or for purchase that will ring a
mobile
phone.

We have a modem in place here for doing the task, its just getting a go
between CF to the modem.

Our software development team are looking into this although they asked
to
put a feeler out to the community.

Thanks,

J


_

[Todays 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Customg tag that will ring a phone

2003-10-03 Thread Andre Mohamed
Jim,
 
That certainly sounds like a valid and potentially much simpler
approach.

Andr
 
-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED] 
Sent: 03 October 2003 16:30
To: CF-Talk
Subject: Re: Customg tag that will ring a phone
 
What if the modem has a command-line interface you could invoke directly

from the OS?Then it could just be a matter of sending ATDT and whatnot

via CFEXECUTE, wouldn't it?

- Jim

Andre Mohamed wrote:

 I suspect this will only be really feasible via a C++ based CFX
 leveraging the Telephone API (TAPI) if you are on Windows (not sure of
 the solution to use on a Unix based OS). I know there is some C++ code
 floating about to do this (try google) and all it would require is
 wrapping it up in a CFX - your development team is probably already
 aware of this.

 I doubt there is already a CFX implemented for this purpose.

 Andr

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]
 Sent: 03 October 2003 16:08
 To: CF-Talk
 Subject: Customg tag that will ring a phone

 Hi,

 is anyone aware of a CFX tag free or for purchase that will ring a
 mobile
 phone.

 We have a modem in place here for doing the task, its just getting a
go
 between CF to the modem.

 Our software development team are looking into this although they
asked
 to
 put a feeler out to the community.

 Thanks,

 J


_

 [Todays
 
_

[Todays 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Multilingual site?

2003-09-26 Thread Andre Mohamed
Erm,just to be anal and incite multiple flames (I’ve learnt thistechnique from others on the list)…I believe UTF actually stands for“UCS transformation format” rather than the more popular interpretationof “Unicode Transformation Format” :-) UCS Stands for Universal Character Set a.k.a “Universal Multiple-OctetCoded Character Set” which is defined as being a superset of Unicode. So if we are to believe all of that then UTF-8 (UCS transformationformat 8) is not strictly Unicode specific. Now that I’ve put you all to sleep with this exciting information, wecan get back to addressing the original question of this thread. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 07:40To: CF-TalkSubject: Re: Multilingual site?  And no, UTF-8 is NOT Unicode : UTF8 is an 8 bit encodeing system andUnicode is a 16 bit code. UTF-8 suports Unicode (or any other 16 bitsystem), just as base64 is NOT ASCII, it suports ASCII (or any 8 bitssystem), and ASCII is NOT English (or any other language).Unicode Transformation Format. i rather doubt anyone would have createdUTFsw/out unicode. do they somehow predate unicode? are the UTF ever usedwithanything besides unicode? what character sequence codes do they use? international ms office comes with arial unicode ms, As I told you, it was 2 years ago.it was in international ms office two years ago. Just try a page in Unicode with Netscape 4.7 and you will see ;-(why bring up that pile of dead code?you personally don't want to use unicode, fine. you personally don'tneedthe euro symbol, fine. however, this discussion was about m11n(multilingual) sites. unicode is by far the best choice for these sortsofapplications. it offers developers the widest range of languages withtheleast cost/resistance in cf._[Todays 
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



RE: Multilingual site?

2003-09-26 Thread Andre Mohamed
Doh! Hoping no one would be as anal as me and actually check that out…ohwell. I did try (secretly trying to prolong this exciting debate) Interesting how an abbreviation can mean two things, not ambiguous atall. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 16:06To: CF-TalkSubject: Re: Multilingual site?  Erm,just to be anal and incite multiple flames (I've learnt this technique from others on the list).I believe UTF actually stands for UCS transformation format rather than the more popularinterpretation of Unicode Transformation Format :-)no thats not quite correct. its unicode OR ucs. theUTF-8 definitionactually states Unicode (or UCS) Transformation Format, 8-bit encodingform. UTF-8 is the Unicode Transformation Format that serializes aUnicodescalar value (code point) as a sequence of one to four bytes, asspecifiedin...http://www.unicode.org/glossary/nice try though._[Todays 
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



RE: Multilingual site?

2003-09-26 Thread Andre Mohamed
Yes, although originally the U in UTF stood for UCS, it seems that overtime there has been some kind of revisionism leaning towards Unicode –probably to avoid confusion and more specifically to prevent these kindsof discussions turning up on mailing lists ;) I’ve now managed to successfully bore my self to sleep with thisriveting subject matter. Just enough energy left to sign off… Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 17:07To: CF-TalkSubject: Re: Multilingual site?  Not that I am an expert on any of this, but can you really go tounicode.org an expect any acronym with a U in it not to mean Unicode?well they actually acknowledge UCS in the OR bit. they also have UCS-2,etcdefined in their glossary and they have synched up to ISO 10646,etc.--sothey aren't that one-sided. but since the unicode consortium is doingmostof the work these days (or did, the commercial driving force behind itlooksto be satisified with the encoding as is and may actually peter out) iguess i'll take their definition. Reading rfc2044 at ietf.org, I get...UTF-8, a transformation format of Unicode and ISO 10646 So Andre may still be correct.hard to say. for me its still unicode as the char codes represented inthattransform is unicode. its not used by anything else, etc._[Todays 
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
1) Code Templates

If you mean the ability to create and load templates to use as new files
then the Dreamweaver does support this.

2) Search and save as a file

If you mean the ability to save search/replace queries and load them
again at a later point then yes, Dreamweaver does support this.

André

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED] 
Sent: 22 September 2003 14:28
To: CF-Talk
Subject: RE: dreamweaver stuff

Massimo 

Before I cast my vote - not having the opportunity to yet download DWMX
2004 does anyone know if any of the following features are now
supported?

.   Split code view
.   Collapsible code
.   Code templates
.   Bookmarks
.   Search and save as a file

Kola

 -Original Message-
 From: Massimo Foti [mailto:[EMAIL PROTECTED]
 Sent: 22 September 2003 14:18
 To: CF-Talk
 Subject: Re: dreamweaver stuff
 
  One thing I miss or can't seem to find is the Split View. Is this
gone?
 It
  was really helpful to look at 2 areas of code on a page at once.
 
 Cast your vote:
 
 http://www.macromedia.com/support/email/wishform/
 
 
 Massimo Foti
 Certified Dreamweaver MX Developer
 Certified Advanced ColdFusion MX Developer
 http://www.massimocorner.com/
 
 
 



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

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


RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
Not a solution but:

In Dreamweaver, using just the Tab key will indent blocks of code for
you. You can't do that in Studio.

You can write your own extensions to create your own toolbars if you
want.

André

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: 22 September 2003 14:51
To: CF-Talk
Subject: RE: dreamweaver stuff

I also would like to have a custom Tool Bar and be able to create a
button
for it by selecting a Shortcut. I guess that would like a MACRO. Create
a
button that does a list of commands in order and with conditions.

I liked the buttons on the side in Studio for indenting code, now it's a
shortcut under 'Text'.

I am a mouse user and not so much on the short cuts.

Rick

-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 22, 2003 8:41 AM
To: CF-Talk
Subject: RE: dreamweaver stuff

1) Code Templates

If you mean the ability to create and load templates to use as new files
then the Dreamweaver does support this.

2) Search and save as a file

If you mean the ability to save search/replace queries and load them
again at a later point then yes, Dreamweaver does support this.

André

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED] 
Sent: 22 September 2003 14:28
To: CF-Talk
Subject: RE: dreamweaver stuff

Massimo 

Before I cast my vote - not having the opportunity to yet download DWMX
2004 does anyone know if any of the following features are now
supported?

.   Split code view
.   Collapsible code
.   Code templates
.   Bookmarks
.   Search and save as a file

Kola

 -Original Message-
 From: Massimo Foti [mailto:[EMAIL PROTECTED]
 Sent: 22 September 2003 14:18
 To: CF-Talk
 Subject: Re: dreamweaver stuff
 
  One thing I miss or can't seem to find is the Split View. Is this
gone?
 It
  was really helpful to look at 2 areas of code on a page at once.
 
 Cast your vote:
 
 http://www.macromedia.com/support/email/wishform/
 
 
 Massimo Foti
 Certified Dreamweaver MX Developer
 Certified Advanced ColdFusion MX Developer
 http://www.massimocorner.com/
 
 
 





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

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


RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
F10 Code Inspector.

André

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: 22 September 2003 14:42
To: CF-Talk
Subject: RE: dreamweaver stuff

No I am referring to Split View in CF Studio it gives you 2 views of the
code. 

Example:

So you can look at a query at the top of the Doc and a CFOUTPUT at the
bottom at the same time.

Collapsible code is nice also.

Rick

-Original Message-
From: Bailey, Neal [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 22, 2003 8:29 AM
To: CF-Talk
Subject: RE: dreamweaver stuff

Hey Rick,

If you are referring to viewing your page in Code View and Design View
at
the same time, then Yes this feature is still present in MX 2004. When
you
open a document you will see on the top tab three buttons, Code,
Split
and Design. Click on Split to switch to split screen mode. This is
defiantly one the most useful features of Dreamweaver. 

- Neal

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 22, 2003 7:20 AM
To: CF-Talk
Subject: RE: dreamweaver stuff

While we are on DW subject...

I just started using it last week now that I have multiple sites and
different developers working on them Studio just didn't seem like the
way to
go. 

One thing I miss or can't seem to find is the Split View. Is this gone?
It
was really helpful to look at 2 areas of code on a page at once.

Rick

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 22, 2003 7:43 AM
To: CF-Talk
Subject: Re: dreamweaver stuff

I do know the answer to the first question is definitely no.

Part of the problem with the title bar is that it is not a relative path
based on the Site, it's relative to the document and only goes one
directory, so a file that looks like this:

C:\MySites\myCoolSite\mySubDir\myOtherDir\myChildDir\myfile.cfm where
myCoolSite is the DW site root, will display like this in both DWMX and
2004:

myCoolSite (myChildDir/myfile.cfm)

If indeed DWMX DID show the entire path relative to the site, then it
would
be reasonable :)

I have partially written an extension to show the full file path
(Windows
only) in a toolbar...

HTH,
Calvin

- Original Message - 
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 8:38 AM
Subject: RE: dreamweaver stuff


  I'm trying to acclimatize to dreamweaver and I'm hoping
  somebody on the list can tell me if theres a way to do
  these 2 things:
 
  1) display the entire file path in the dreamweaver title
  bar. Having only the file name and the last directory visible
  and not being able to get the full path from file properties,
  etc. makes it really difficult for me to keep track of what
  I'm doing, especially when I've got more than one site with
  the same directory and I need to know which site I'm editing.
 
  2) eliminate the Update Files: Scan site for links to renamed
  files? dialog when I remove or rename files.

 First, let me preface this by saying I haven't worked much with DWMX
2004;
I
 have worked quite a bit with DWMX 6.1, though.

 Unfortunately, I don't have definitive answers for either question,
and
 suspect that for both of them, the answer is no, you can't do that.
 However, within the site-based work style encouraged by Dreamweaver,
these
 behaviors make sense.

 When you create a site, one of the benefits of this is that you don't
have
 to deal with file paths directly, when working with that site.
Dreamweaver
 provides a site-relative path in the title bar, and in theory, you
shouldn't
 have to worry too much about where on the filesystem the site files
actually
 are - after all, you may have local and remote site information within
your
 site definition, and those paths may well change between the two. It
would
 be nice, though, if the Site panel updated to show the site containing
the
 file you're actually working on.

 Also, when you move or rename a file through Dreamweaver, the Update
files
 dialog box is one of the benefits - it automatically fixes any
references
to
 that file. If you do these operations through your filesystem browser
 instead of through Dreamweaver, you won't get a prompt within
Dreamweaver,
 though.

 A lot of the Site stuff is best suited to a specific way of working,
and
 if you work that way, it's very helpful. If you don't, though, it may
be
 less helpful. I find it very useful for working with static HTML, and
for
 managing Contribute users. For application development, I find it less
 helpful, although I still typically use it anyway. DWMX 2004
deemphasizes
 the reliance on setting up sites, as I understand it, so you may want
to
 take a look at it.

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

 




~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137913
Archives: 

RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
Right you are.

-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED] 
Sent: 22 September 2003 15:20
To: CF-Talk
Subject: RE: dreamweaver stuff

Not a solution but:

In Dreamweaver, using just the Tab key will indent blocks of code for
you. You can't do that in Studio.


Sure you can. In HomeSite+, hit F8 to bring up the Options. Click on the

Editor option in the left nav pane. Check the 4th checkbox from the
bottom 
(Tab/Shift+Tab performs block indent/unindent) and then Apply and
you're 
good to go.

Regards,
Dave.

_
Add MSN 8 Internet Software to your existing Internet access and enjoy 
patented spam protection and more.  Sign up now!   
http://join.msn.com/?page=dept/byoa


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

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


RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
In order to get Homesite+ I'm pretty sure you need to buy DW.

You can get Homesite by itself but not Homesite+or something like
that. It's changing every 5 minutes so who knows.

You have to ask yourself, will MM continue developing two products that
have such a large overlap of functionality?

André

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED] 
Sent: 22 September 2003 15:37
To: CF-Talk
Subject: RE: dreamweaver stuff

A Now I see what MM is up to - we're supposed to buy both
products and use Dreamweaver side by side with CF studio ;-)

Kola

 -Original Message-
 From: Massimo Foti [mailto:[EMAIL PROTECTED]
 Sent: 22 September 2003 15:29
 To: CF-Talk
 Subject: Re: dreamweaver stuff
 
  Out of those 5 developer-centric features only 1 of them is
possible in
  DWMX? I don't believe in knocking things before you've tried it but
 this
  isn't a good start is it? Perhaps I'm the only one using those
 features.
 
 I never suggested DW MX can replace Homesite/CF Studio, not here, not
 ever.
 Personally I am happy using both side by side (plus TopStyle)
 
 
 Massimo Foti
 Certified Dreamweaver MX Developer
 Certified Advanced ColdFusion MX Developer
 http://www.massimocorner.com/
 
 
 
 



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

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


RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
  In order to get Homesite+ I'm pretty sure you need to buy DW.
 
 Right. But if you, like me, don't need the additional functionalities,
 Homesite 5.5 is 99 bucks (29 for the upgrade)
 
 
  You can get Homesite by itself but not Homesite+or something
like
  that. It's changing every 5 minutes so who knows.
 
 It never changed since DW MX was released, almost a year and an half
ago

That'll shut me up.
 
 
  You have to ask yourself, will MM continue developing two products
that
  have such a large overlap of functionality?
 
 That's indeed a good question
 
 
 Massimo Foti
 Certified Dreamweaver MX Developer
 Certified Advanced ColdFusion MX Developer
 http://www.massimocorner.com/
 
 
 
 
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137942
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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


RE: dreamweaver stuff

2003-09-22 Thread Andre Mohamed
 Eh? This was done about a year ago I think. It's not flipped back and
 forth at all. MACR simply stopped selling ColdFusion Studio, renamed
it
 as HS+ and put it with DW. Whether you like that move or not, I don't
 think MACR is being wishy-washy about it.

I've been corrected on this point already. That'll teach me to comment.

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

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


RE: Correction

2003-09-19 Thread Andre Mohamed
Just to be anal, you don't need any #'s or the GT 0 at end as GT 0
evaluates to true.

cfif listFind(variables.accesslist,cat_ID)


André

-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: 19 September 2003 17:32
To: CF-Talk
Subject: Correction

Don't you just love when people make suggestions on how to change code
and their suggestion is hosed? 

Like the one I just publihsed. I dropped a pound sign:

cfif  #listfind(variables.accesslist, cat_ID)# GT 0 

There, THAT'S better...

Put the pound signs outside the function:


cfif  #listfind(variables.accesslist, cat_ID) GT 0 


I'm not sure what I'm doing wrong with this list function.  I have a 
variable with a list in it, I want to take an action when the variable

is equal to the query row variable.  I can get it to work with 
listcontains but that will return more values than I want.  I can also

get it to recognize the first value in the list  when I hardcode the 
list rather than use a value.  It's almost like it doesn't evaluate 
the variable and treat it as a list.

Here's the code,
cfset variables.accesslist = 1, 82, 104
!--- Cat_ID equals 1 ---

cfif  listfind(#variables.accesslist#, #cat_ID#) GT 0 
Blah, Blah, Blah

cfelse
..


/cfif

The cfelse condition is always returned.  I've tried every combination

of quotes and pound signs also, to no avail.

Any help would be appreciated.

Daron Smith

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

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


RE: ListFind not working properly

2003-09-19 Thread Andre Mohamed
Replace all spaces on the list first.

-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED] 
Sent: 19 September 2003 17:06
To: CF-Talk
Subject: FW: ListFind not working properly

I'm not sure what I'm doing wrong with this list function.  I have a
variable with a list in it, I want to take an action when the variable
is equal to the query row variable.  I can get it to work with
listcontains but that will return more values than I want.  I can also
get it to recognize the first value in the list  when I hardcode the
list rather than use a value.  It's almost like it doesn't evaluate the
variable and treat it as a list.

Here's the code,
cfset variables.accesslist = 1, 82, 104
!--- Cat_ID equals 1 ---

cfif  listfind(#variables.accesslist#, #cat_ID#) GT 0 
Blah, Blah, Blah

cfelse
..

/cfif

The cfelse condition is always returned.  I've tried every combination
of quotes and pound signs also, to no avail.

Any help would be appreciated.

Daron Smith


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

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


RE: wanted features (was Re: (Admin) disclosure)

2003-09-18 Thread Andre Mohamed
Michael,

You should be able to utilize the underlying HttpSessionListener
interface to monitor session creations and destructions, though that
requires writing an appropriate Java class which isn't a big deal if you
don't mind getting your hands dirty with Java. You'll also need to use
J2EE sessions.

Admittedly, having a native ColdFusion hook for these events would be
useful i.e. you register a CFC that listens for these events and when
the event occurs all the listening CFCs get notified with the
appropriate event. Unfortunately, CFCs don't support interfaces so this
might be a little tricky to implement i.e. deciding which method in the
CFC to call.

Are you aware of the SessionTracker class that maintains a collection of
sessions for a given ColdFusion application?

André
 
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: 18 September 2003 06:07
To: CF-Talk
Subject: Re: wanted features (was Re: (Admin) disclosure)

 The two biggest requests for new functionality I here are:

 1) End of session processing (however it's done, an event model, a
 special template handler, etc - people are always asking how do I
tell
 when a user is about to time-out).
That would be great. OnEventEnd as a setting of some sort in the
CFAPPLICATION
tag to run a template when the specific event ends (OnSessionEnd,
OnApplicationEnd). An admin or programatic way of watching the current
session
information would also be great. You can hack such a thing now, but
built in
would be so much nicer.

 2) Direct Image manipulation (at the very least information access and
 resizing - it seems like every other week somebody is asking how to do
a
 thumbnail gallery).  This is pretty easy nowadays if you know a little
 Java - but many CFers don't.
Direct image, PDF, RTF, etc. manipulation/creation. We can create graphs
on the
fly nativly in CF, we can create images using the CFX_Image tag, we can
use X,Y,
or Z product to create PDFs. Why not make it all native to CF.

 Even if NNTP's not in demand it does seem like one of the only major
 protocols that CF doesn't support natively.  For that reason alone it
 might be nice to see it in there (Supports all major Internet
 protocols).
My point. :)



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

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


RE: Gzipping cold fusion pages on IIS 5.0

2003-09-11 Thread Andre Mohamed
I concur. 

HTTP compression works well with IIS5.0 and ColdFusion MX.

No added purchase or change to code necessary.

See here for a good description of how to set it up:

http://www.eggheadcafe.com/articles/20020716.asp


The gzip filter from Servlet Suite also works well:

http://www.servletsuite.com/servlets/gzipflt.htm

But is not as efficient as implementing compression via IIS.

André

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 11 September 2003 01:21
To: CF-Talk
Subject: Re: Gzipping cold fusion pages on IIS 5.0

Scott Ashman wrote:
 Anyone know of a good product / method that can incorporate the
gzipping of
 files with cold fusion output?  IIS 5.0 has compression ability but it
seems
 to really only be useful with static pages.  I've seen a couple of
$1k+
 solutions, but would rather have a cheaper solution.

The IIS 5 compression works fine with CF MX.

Jochem



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

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


RE: Sending binary directly to the browser?

2003-09-05 Thread Andre Mohamed
Are you sure it's binary data?

Does it return true when you try isBinary(gifdatahere)??

You can try outputting the data to the output stream directly by
utilizing the underlying page context.

Christian Cantrell blogged an example of doing this here:

http://www.markme.com/cantrell/archives/002658.cfm


André

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: 05 September 2003 16:04
To: CF-Talk
Subject: Re: Sending binary directly to the browser?

cfcontent type=image/gif; charset=8859_1
cfoutput#gifdatahere#/cfoutput

I've tried, but it does not work.
If gifdatahere contains binary, CFCONTENT complains it can accept only a
string,
if it is a string, the string is truncated to the first zero byte.


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

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


RE: Massaged query output to Excel file (was query output to Excel fi le)

2003-09-05 Thread Andre Mohamed
George,

I have done this and it works quite successfully.

I use XSLT to transform the XML into both tab delimited and csv format
amongst others then in combination with cfcontent I allow the user to
export/save the data in their desired format.

The XML document is built up at the same time as it is being displayed
in HTML e.g. 

In your cfloop

cfloop
td#column1#/td
cfset
xmlDoc.xmlRoot.xmlChildren[rowIndex].xmlChildren[i].xmlText = column1
/cfloop

You could of course generate the HTML/Report output using XSL too but I
found it more efficient to generate the HTML and XML document
concurrently because the HTML view will always be seen before the user
optionally exports it to another format.

André

-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED] 
Sent: 04 September 2003 18:23
To: CF-Talk
Subject: Massaged query output to Excel file (was query output to Excel
fi le)

Petr said:
 What would you say is the best way of creating an Excel file 
 from query
 data?
 I don't need to know how to create a .csv file.

Different but similar. I need to create an Excel file (or a CSV file, or
a
tab delimited file, or a print file) from query output that has been
massaged into reports that are already displaying on the screen (i.e.,
save
the displayed report output to Excel, CSV, tab delimited or print). We
have
a guy on our team looking into saving the formatted query output to xml
from
which we would then generate any of the other formats. Has anyone tried
this? Does anyone have other ideas on how to do this?

George
[EMAIL PROTECTED]


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

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


RE: meeting room booking application

2003-09-04 Thread Andre Mohamed
Mike,

Does it need to be ColdFusion?

And if it is, does it need to be customizable?

If not there are plenty around in other languages.

Regards,

André

-Original Message-
From: Michael Traher [mailto:[EMAIL PROTECTED] 
Sent: 04 September 2003 17:01
To: CF-Talk
Subject: meeting room booking application

Anybody know of a 'meeting room booking' application in CF?

I've done some searches but not found quite the right thing.

Seems to me it must be a common kind of requirement to manage shared
resources on an intranet.

Of course if we had the time we could write one... ;-)

Michael Traher 
Systems Manager



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

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


RE: query output to Excel file

2003-09-04 Thread Andre Mohamed
Tony,

Alternatively, just append the data to a variable as you are looping
through with commas as delimiters etc. and then write the variable to
the file when you are done.

André

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 04 September 2003 16:55
To: CF-Talk
Subject: RE: query output to Excel file

but I could in the same light, write the data as comma delimited inside
a cfsavecontent?

and then from there...dump the data in the cfsavecontent into the
cffile, as one file system hit?

tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 04, 2003 11:34 AM
To: CF-Talk
Subject: Re: query output to Excel file


Tony,
You can do anything you need to do in the cf template, writing it out as
you would normal html. Excel can open an html file (formatted like a
table) and it will function exactly like excel. The following code
will trick the browser into thinking it's dealing with excel: CFHEADER
NAME=Content-Disposition VALUE=attachment; filename=sample.xls
CFCONTENT TYPE=application/excel

If you're going to email the file to someone, I would think that you
could use cffile to write the content (using cfsavecontent to build the
page).

-Deanna


- Original Message - 
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 10:13 AM
Subject: RE: query output to Excel file


 trouble is, I cant do it all in 1 query, I have cf logic that HAS to 
 be there, and it is then emailed to a client :( so, is there a way to 
 take a cfquery object that is returned, and just dump that into 
 something, and send it, versus writing line by line by line

 tony weeg
 sr. web applications architect
 navtrak, inc.
 [EMAIL PROTECTED]
 www.navtrak.net
 office 410.548.2337
 fax 410.860.2337


 -Original Message-
 From: Craig Dudley [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 04, 2003 10:53 AM
 To: CF-Talk
 Subject: RE: query output to Excel file


 Youre using SQL server yes?

 So DTS would be the best option for that amount of data, Jon Hall 
 posted all about it a few months back, check the archives.

 -Original Message-
 From: Tony Weeg [mailto:[EMAIL PROTECTED]
 Sent: 04 September 2003 15:54
 To: CF-Talk
 Subject: RE: query output to Excel file


 id love to know myself, I have a query that returns an assload of 
 data, that I have to write to csv, and now it takes 45 minutes to 
 complete...there has to be a better way!

 tony weeg
 sr. web applications architect
 navtrak, inc.
 [EMAIL PROTECTED]
 www.navtrak.net
 office 410.548.2337
 fax 410.860.2337


 -Original Message-
 From: Petr Kysela [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 04, 2003 10:45 AM
 To: CF-Talk
 Subject: query output to Excel file


 What would you say is the best way of creating an Excel file from 
 query data? I don't need to know how to create a .csv file.

 I've seen solutions through ADO objects, ODBC dsn, custom tags, etc.

 But surely there must be something quick and easy.

 Cheers



 


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

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


RE: Load Balancing

2003-09-02 Thread Andre Mohamed
Shahzad,

A few pointers:

If you locate the relevant services via the services applet you can
specify files to run on various events including:

First Failure
Second Failure
Subsequent Failures

In addition to specifying a file to execute you can indicate you want
the service automatically restarted.

If you go with the batch file route, it’s just a matter of using net
start with the appropriate service name e.g.

Net start “ColdFusion MX Application Server”

You can find the name of the service name by right clicking on the
appropriate service and looking at the “general” tab.

There are already batch files provided for stopping and starting MX
services:

Start.bat
Stop.bat

Located here:

{cfroot}\bin


André

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 02 September 2003 11:37
To: CF-Talk
Subject: RE: Load Balancing

How does that batch file know when to be executed. Or shall I schedule
every 1 min? which I don't feel is right. Because I want to start the
restart the services whenever it crashes not just one off. Also can I
have a copy of that batch file (to stop or restart IIS/CFMX services) if
someone has written

Thanks
Shaz

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: 02 September 2003 10:40
To: CF-Talk
Subject: Re: Load Balancing


On Tuesday 02 Sep 2003 09:20 am, Shahzad.Butt wrote:
 So all I need is that if for some reason either IIS or CF server is 
 crashed or stopped then either it shuts down the server or it restart 
 that services.

Seems easy enough - write a batch file that requests a file from your 
webserver, and if it doesn't get it, stops the service.
I use CygWin for stuff like this.

-- 
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***



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

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


RE: machII(too much)

2003-09-02 Thread Andre Mohamed
Perhaps you thinking of the Heisenberg Uncertainty principle.

André

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: 02 September 2003 14:45
To: CF-Talk
Subject: RE: machII(too much)

But then it dawned on me that maybe the debug output was causing the
higher
times.

Does anyone know the name of this effect. Where you change the
environment
you are measuring? I'm sure is has a name.

Ade

-Original Message-
From: Mark Stewart [mailto:[EMAIL PROTECTED]
Sent: 18 August 2003 16:49
To: CF-Talk
Subject: RE: machII(too much)


That's what I was saying last week, but not so fast... To get the fast
times, you need to turn off the debug output and then you'll see those
times
*drastically* reduced. I was banging my head against the wall last week
not
understanding why a simple contact manager would take 500 - 1000ms
(according to cfmx debug output). But then it dawned on me that maybe
the
debug output was causing the higher times. Sure enough, that's what it
was.
I'm now consistently getting 50 - 100ms rendering times. 

I would like to see some benchmark times on larger applications though.

Mark

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

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


RE: Mutiple SQL Inserts

2003-09-02 Thread Andre Mohamed
No help whatsoever but for future reference:

This arrangement is sometimes referred to as a Vertical Partition as
opposed to Horizontal Partitions which is what you might use for
archiving data etc. 

Vertical Partitions are definitely worth considering for saving space if
the circumstances are as you describe.

The most convenient way to deal with them is to create a database view -
preferably and updatable view that joins the two tables. Then you just
perform the single insert/update on the view as normal.


André

-Original Message-
From: Rick Kennerly [mailto:[EMAIL PROTECTED] 
Sent: 02 September 2003 13:54
To: CF-Talk
Subject: Mutiple SQL Inserts

I didn't realize until this project that all of my relational database
work was kind of one-dimensional, all of the related tables were built
with dropdowns to feed the main table in mind.  None of the related
tables update information by users. 

Now I have a project where I need to add several fields to a
well-established table in a db.  However, only one in 500 new inserts
would need these fields, so a related (sub)table is the way to go to
save 
space.  The problem is, not one of my references addresses an example of
multiple Inserts into a DB. 

I've thought of two approaches.  Is there a best practice? (or something
I haven't thought of?)

Action_Form

Queryinsert info into new related table
Queryget row number from new related table
Querypass the row number of the new related table to the form and
Insert 
the entire form into main table

all in one shot

or

a series of forms and action pages that kind of step through the
transaction.  

Rick 



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

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


RE: Logging users in with CFC

2003-08-26 Thread Andre Mohamed
Mike,

Macromedia has an article about this very topic:

http://www.macromedia.com/devnet/mx/coldfusion/articles/cfc_practices.ht
ml

It’s been there for about a year so I’m sure there are more
comprehensive examples around by now.

Regards,

André

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2003 04:24
To: CF-Talk
Subject: RE: Logging users in with CFC

Tony, to be honest, I'm not sure.  It's just that I haven't seen any
examples of CFCs being used for that functionality, so I wondered why. 

It seems that one of the ways to collect all the functionality related
to
users is to have a users.cfc where you'd have a method called login, one
called listusers, one called updateprofile, one called emailpassword
etc,
and then all the database access, and action related to user access is
in
the one place.   This is what's advocated in other applications about
CFCs,
but I haven't seen login, authentication, updating last login date,
number
of logins etc  - all that user access stuff - gathered into a CFC.

So I wondered if that was because people have always done it without
CFCs
and therefore old habits are at play, or whether there was a logical
reason
not to include this stuff in CFCs, that I wasn't seeing. (Believe me
there's
a LOT about my world that I don't see.  Just ask my wife!)



Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.




-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 26 August 2003 1:05 PM
To: CF-Talk
Subject: RE: Logging users in with CFC

what things might you be worried about?

security?

just wondering...i hadnt given it much thought
but now that you mention it, what things are 
you wondering about?

later.
tw





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

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


RE: Good News: (was RE: Mach II 1.0 )

2003-08-14 Thread Andre Mohamed
Murat,

There are plenty of resources covering OOP which are language agnostic
and indeed OOAD is of course language neutral.

I believe that's what Hal was referring to and even if he wasn't it's
still a valid.

I'm pretty sure there have been recommendations for OO books/resources
on this list in the past. There are even a couple of titles which in
fact do cover OOP with CF and I have no doubt that in the near future
there will be a proliferation of these titles/resources specific to CF.


André

-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: 14 August 2003 11:58
To: CF-Talk
Subject: RE: Good News: (was RE: Mach II 1.0 )

Who is the audience?

You say we, CFMX developers, need to learn OO.

OK. I want to learn it to create powerful apps but how? There is no
source
for OO programming in CF?

-Original Message-
From: Hal Helms [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 14, 2003 11:40 AM
To: CF-Talk
Subject: RE: Good News: (was RE: Mach II 1.0 )


You won't really need to know much about XML, Michael, but you will need
to
know OO to do a lot with Mach-II.

Hal Helms
Java for CF Programmers class 
in Las Vegas, August 18-22
www.halhelms.com

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 14, 2003 1:35 AM
To: CF-Talk
Subject: Good News: (was RE: Mach II 1.0 )


Hal put a new version of Mach-II on the site Mach-II.com last night, and
bingo!  The problem was I wasn't using US date format.  In a jiffy, he
corrected the bug so it accepted international date formats and now it
goes.

Like lightning it goes!

It installed and the sample apps worked just like that - right out of
the
box. No muss, no fuss.

Now I want to know more about how this whole thing works. 

I get the impression that working in the Mach-II environment is going to
require a knowledge of object-oriented programming terminology that I
don't
have.  Is that right? For example I rather get the impression that
expressions like MVC - Model View Conroller are familiar to people
who've
done other programming.  Is this so? If I want to become adept at
using
Mach-ii am I going to have to learn about OO Programming?

I can see that amongst the disciplines I'm going to have to know well
are
XML, but I need to learn more about that anyway.  Anything else?

Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.








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

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


RE: Webservices, Components passing parameters

2003-08-14 Thread Andre Mohamed
Try this:

Go to your ColdFusion Administrator. Locate the web service in question
via Data  Services - Web Services. Click on the refresh icon.

Try running your code again.

André

-Original Message-
From: A.Little [mailto:[EMAIL PROTECTED] 
Sent: 08 August 2003 10:00
To: CF-Talk
Subject: Webservices, Components  passing parameters

Hi all,

OK, can anyone tell me what I;m doing wrong here... I have created a
very
simple webservice (see code below), which works fine if I try to call it
as
a cfc, but as soon as I try to call the method as a webservice, I get
the
error 'Web service operation getDocTitle with parameters {5459} could
not
be found.' 

If I comment out the parameter/argument bits - so nothing is passed and
nothing is expected by the cfc - it all works fine. I'm sure there must
be
something simple I've missed

TIA
Alex

Code samples:
cfc page:
cfcomponent
   cffunction name=getDocTitle access=remote returntype=string
cfargument name=DocumentID type=numeric
required=yes

cfquery name=qry_getDoc datasource=#request.dsn#
SELECT DocumentTitle FROM tblDocument
WHERE DocumentID = cfqueryparam
cfsqltype=cf_sql_integer value=#arguments.documentid#
/cfquery
cfreturn qry_getDoc.DocumentTitle
   /cffunction
/cfcomponent  

Calling page:

cfscript
DocumentID = 5459;
ws =
createobject(webservice,http://kn-dev.open.ac.uk/testarea/webservice/
docu
ment.cfc?wsdl);
testvar = ws.getDocTitle(#DocumentID#);
/cfscript

cfdump var=#testvar#


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Caller access to query

2003-08-14 Thread Andre Mohamed
Some people (not necessarily me) believe doing this is better:

cf_mytag theQuery=#myQuery#/

i.e. passing the query by value and hence avoiding breaking any kind of
encapsulation.

Inside the tag you refer to the query in the normal way e.g.

cfset localQuery = attributes.theQuery

or just:

cfloop query=attributes.theQuery
...
/cfloop

However, if you follow the syntax of native ColdFusion tags then the
analogous approach is to do what you have opted to do. E.g.

cf_mytag theQuery=myQuery/

Inside the tag:

cfset localQuery = caller[attributes.theQuery]/


André

-Original Message-
From: Venable, John [mailto:[EMAIL PROTECTED] 
Sent: 13 August 2003 19:13
To: CF-Talk
Subject: RE: Caller access to query

Thanks everyone, I was passing the queryname in as an attribute and
cfset
_localQuery = Evaluate(Caller. + Attributes.query) / was just what I
needed. I had to change the + to  for concatenation though.

Thanks

John Venable

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 12:58 PM
To: CF-Talk
Subject: RE: Caller access to query


If myquery is the query on your page then in your custom tag

cfset _localQuery = Caller.myquery /

Better is to pass the query in the tag

cf_mytag query=myquery /

and in the tag

cfset _localQuery = Evaluate(Caller. + Attributes.query) /


WG

-Original Message-
From: Venable, John [mailto:[EMAIL PROTECTED]
Sent: 13 August 2003 17:45
To: CF-Talk
Subject: Caller access to query


Is there a way to access an existing query recordset from a custom tag
called on the page? So if I have a query in a page, and I call a custom
tag,
can i use the query data through come sort of caller scope object? I
can't
seem to make it work.

Thanks

John Venable



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

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


RE: Problem calling CFC from .NET

2003-08-14 Thread Andre Mohamed
In other words you need to come up with your own mechanism for
maintaining a session across web service invocations. This is fairly
trivial and there are different approaches you can take.

If you called the CFC as a web service from within ColdFusion you'd have
the same problem. However, you called it as a local object which meant
it would maintain its state.

The access attribute being set to remote only indicates that the CFC
can be called as a web service not that it IS a web service only CFC.

André

-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED] 
Sent: 08 August 2003 09:01
To: CF-Talk
Subject: Re: Problem calling CFC from .NET

On Thursday, Aug 7, 2003, at 17:12 US/Pacific, kevin ruggiero wrote:
 Well, I'm not sure it warranted an of course not, seeing as how it 
 did work fine when called from ColdFusion

If you call if from CF, it's like a local function call. If you call it 
as a web service, there's no sense of session management - the calling 
client could be anything so there is no standard way to maintain a 
session. Sorry, I thought this was very obvious but I guess I'm making 
assumptions - no offense intended :(

 That would make sense, I just was not aware that CF will not maintain 
 state on calls to web services.

Well, it's more that the *client* isn't maintaining session so each 
time CF is called, it treats it as a new session (imagine turning off 
cookies and not being able to add tokens to the URL).

 I was hoping that it could maintain state through some mechanism 
 similar to session management, which I don't believe is unreasonable 
 to fathom.

Normally session management occurs through collaboration between the 
server and the client. It relies on the client following a protocol, 
either through cookies being passed back and forth or through URL data. 
Web Services can be called by a wide variety of clients that know 
nothing about cookies or URL parameters - so there is nothing for the 
server to hang on to...

Sean A Corfield -- http://www.corfield.org/blog/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Simple html question

2003-08-14 Thread Andre Mohamed
You can't get smaller than 1 pixel thickness (unless you consider
dotted/dashed borders)

table style=border:1px solid black
tr
tdhello world/td
/tr
/table

That's as thin as you can get (it definitely doesn't look the same the
default border - though that depends on your browser)

André

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED] 
Sent: 12 August 2003 17:36
To: CF-Talk
Subject: Simple html question

Hi,
Just a very simple question,
is it possible to apply a style to a table to manipulate its border,
border=1 is just a tab to thick for the fine layout our designer has
done.

I tried table style=border:1px;border-color:#00, but this just
gives
the default border of one.

Can't seem to find anything in the style editor shipped with CF studio
4.5,

Respectfully,

j.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: THE FIX (struct question)

2003-08-14 Thread Andre Mohamed
You might just escape punishment this once before the # Nazi's come
along...

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 11 August 2003 13:32
To: CF-Talk
Subject: RE: THE FIX (struct question)

laziness brings in more #'s

its easy to use #'s

its hard to remember every instance every time where one doesn’t need
#'s

I think last night I was dreaming in myriad patterns of #'s and ()'s

analysis

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 11, 2003 5:47 AM
To: CF-Talk
Subject: RE: THE FIX (struct question)


Tony,

Minor point but you shouldn't need the #'s.

André

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 11 August 2003 04:46
To: CF-Talk
Subject: THE FIX (struct question)

heres how...

cfset numberOfThesePuppies =
#arraylen(structFindKey(session.cart,product.id))#

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Sunday, August 10, 2003 11:43 PM
To: CF-Talk
Subject: struct question


what function(s) do i need to use, if i want to know
how many occurences of a value are present in a structure? thanks!

im drawing a blank here..

tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331 





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: THE FIX (struct question)

2003-08-14 Thread Andre Mohamed
Tony,

Minor point but you shouldn't need the #'s.

André

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 11 August 2003 04:46
To: CF-Talk
Subject: THE FIX (struct question)

heres how...

cfset numberOfThesePuppies =
#arraylen(structFindKey(session.cart,product.id))#

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Sunday, August 10, 2003 11:43 PM
To: CF-Talk
Subject: struct question


what function(s) do i need to use, if i want to know
how many occurences of a value are present in a structure?
thanks!

im drawing a blank here..

tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Load testing...

2003-08-11 Thread Andre Mohamed
Ryan,

Try Google and free load testing tools.

More specifically, you'll want to search for Load/Stress testing
specific to web sites e.g. the following are all free:

1)Microsoft's Web Application Stress Tool
http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062a-4
39e-a67d-75a89aa36495DisplayLang=en 

2)Apache's JMeter http://jakarta.apache.org/jmeter 

3)OpenSTA http://www.opensta.org

Amongst MANY MANY MANY others.

Micrsoft's tool is good to get started with if you are new to the area
though somewhat limited in more advanced functionality.

André

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED] 
Sent: 11 August 2003 09:36
To: CF-Talk
Subject: Load testing...

Hello

I want to load test one of my sites, to see what sort of traffic it can
handle, to see if there are areas I need to improve etc...

Am I dreaming thinking their are tools (free is good) out there to do
this?

Ryan



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMAIL Send Failure

2003-08-06 Thread Andre Mohamed
Is the SMTP server accessible from your new box?

Can you ping 65.110.72.126 from the box?

I suspect not because that is what the log files say.

Verify the correct IP address to use for your SMTP server.

André

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: 06 August 2003 13:51
To: CF-Talk
Subject: CFMAIL Send Failure

I've got a dedicated box running win2003, IIS 6.0 and CFMX 6.1.
I'm a newbie at server admin BTW.
Since moving a few of my sites to this box, my cfmail tags have quit
working.

I must be missing a config issue, because in CFAdmin, the Mail server
verification fails.
In addition, in the mail logs, I get these errors:

Could not connect to SMTP host: 65.110.72.126, port: 25; nested
exception
is: java.net.ConnectException: Connection refused: connect 
 
Invalid Addresses; nested exception is:
javax.mail.SendFailedException:
500 Unkown temp error 
 
Invalid Addresses; nested exception is:
javax.mail.SendFailedException:
550 Mail rejected ; nested exception is: javax.mail.SendFailedException:
550
Mail rejected

How do I solve? (SMTP services in IIS are not installed, could this be
the
problem)?

Thanks, Mark 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: GetPageContext() function...cfinclude from a cfscript?

2003-07-08 Thread Andre Mohamed
GetPageContext() allows you to gain access to the underlying JSP/Servlet
page context.

This allows you to share sessions and requests with JSP's and Servlets
as well as letting you perform server-side re-directs and forwards.
cflocation as I'm sure you know performs a client-side redirect.

The full scope of possibilities that access to the page context is not
covered here. For more information refer to your CF Documentation
(Integrating J2EE and Java elements in CFML Applications)

For more information on methods available to the page context refer to
the JSP/Servlet API's available from java.sun.com. Alternatively, look
for any JSP tutorial that mentions the context.

That should get you on your way.


André
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED] 
Sent: 08 July 2003 13:56
To: CF-Talk
Subject: GetPageContext() function...cfinclude from a cfscript?

Could someone please explain what GetPageContext() does within CFMX?  I
just
came across it in one of the other posts and it got me thinking about
using
GetPageContext().include(somefile.cfm) for cfincludes within
cfscripts,
but it doesn't seem to share the same memory/variables (which, I guess,
could be a benefit.)  What is possible with this tag?  Is it slow?  What
other functions are available, etc?  I've gotta know!
 
Tyler


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFUnit

2003-07-04 Thread Andre Mohamed
Although I haven't got the DRK or seen the code for CFUnit, what I
gather from Christian's article is that the CFUnit framework is merely
just one single CFC!! i.e. it is vastly simplified compared with JUnit.

Again, this is mostly guess work but it probably goes something like
this:

A singe CFC called TestCase.cfc containing a method run(). 

This run method implements the Template Method design pattern i.e. it
calls some other private methods like setUp() and teardown() etc. 

At some point during the proceedings CFC metadata is used to introspect
the CFC for all methods beginning with test. These test methods are
called one by one.

Inside of each of the test methods you invoke the CFC you are testing
and subsequently invoke some assertion methods (which are defined in
the base TestCase.cfc). These assertion methods are presumably fairly
trivial and comprise of things like assertEquals, assertTrue etc.
Obviously you can add your own assert methods to the base class as
needed.

Again, I'm guessing but I think all these assert methods do is output an
HTML table row with the results of the assertion.

I could be way off because as I said I haven't seen the implementation
of CFUnit but I think that's pretty much it i.e. ONE CFC! And no where
near as complex as JUnit.

On your point about having an equals method: This would be feasible if
the CFC you were testing implemented and equals method which was able
to tell whether it was equal to another CFC by way of comparing instance
variables/object state etc. i.e. it would require a custom
implementation of an equals() method for every CFC that you built - just
as you would have to do in Java (using the default implementation of
equals() defined in the Object base class that everything extends
USUALLY doesn't provide the results you are after)

André


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED] 
Sent: 03 July 2003 18:06
To: CF-Talk
Subject: RE: CFUnit

 It can quite easily be transferred to CFC.

I started down this road but found several barriers to replicating junit
in
CFMX for testing cfcs. when is object a equal to object b for
example.
If anyone has replicated the example in the Junit example (called test
infected I think? ) in cf I'd love to see it.

testing custom tags, I guess would be easier as you can look for the
output
your are expecting.
What can you do/test with the DRK CFunit?

 Unfortunately, there are some of us that can't afford the DRKs!!

Well I'd prefer an ipod.

WG


-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 17:48
To: CF-Talk
Subject: RE: CFUnit


I'm hoping it will be released separatelyor continue writing my own
version. It's not hard to do and have already developed a version for
unit testing custom tags. See the links I just posted to see how you
could implement your own (even more comprehensive) version.

Unfortunately, there are some of us that can't afford the DRKs!!


André
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 17:49
To: CF-Talk
Subject: RE: CFUnit

Anyway to get this without the drk ?

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 17:33
To: CF-Talk
Subject: RE: CFUnit


Christian Cantrall. And it rocks. I _love_ the unit tester (and even
added some more stuff to it).


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Robertson-Ravo, Neil (RX)
 [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 03, 2003 10:30 AM
 To: CF-Talk
 Subject: CFUnit


 Anyone got any ideas who came up with the CFUnit stuff on the
 DRK3?





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFUnit

2003-07-04 Thread Andre Mohamed
Try www.junit.org?

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: 04 July 2003 08:56
To: CF-Talk
Subject: Re: CFUnit

On Thursday 03 Jul 2003 23:43 pm, Christian Cantrell wrote:
 I wrote the code (it is not based on anyone else's work), but the
 concept is based on the JUnit testing framework:

What license was junit under ?
http://junit.sourceforge.net/cpl-v10.html is a 404...

-- 
Thomas C
Advanced ColdFusion Programmer

PLEASE NOTE: When the Recipient Is Not Directly Observing This E-mail,
It May 
Cease to Exist or Will Exist Only in a Vague and Undetermined State.
PLEASE ALSO NOTE: I don't speak for the company that sent this.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Caching cfc objects in the application scope

2003-07-04 Thread Andre Mohamed
Raymond,

Can you perhaps quantify a little in terms of the level of stress that
you have found to trigger this behavior?

If it does turn out to be a bug and it isn't rectified in Red Sky then
there are some serious implications for CFC based application frameworks
such as FBMX which of course relies on an application level CFC.

In addition, migrating to use of the server scope instead (if that turns
out to be a solution) would not be practical in most cases.

André

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: 04 July 2003 05:41
To: CF-Talk
Subject: RE: Caching cfc objects in the application scope

 On Thursday, Jul 3, 2003, at 08:53 US/Pacific, Raymond Camden wrote:
  It does improve performance. However, I (and others) have 
 found issues 
  with CFCs that are cached and under load. (And I don't mean 
 big honkin 
  amazon.com load, just medium level load.) Issues like:
 
 It does improve performance is a bit of a blanket 
 statement. It *may* 
 improve performance depending on what your CFC does and how 
 you use it.

Well, if you take the process of recreating the object out, you _will_
save time. It may just be a very small amount of time. ;)

 As for load issues, macromedia.com is heavily CFC-based and 
 uses a lot 
 of CFCs stored in server scope (we're the only application in town so 
 we don't use application scope :) and we've never seen the sort of 
 issues Ray has seen - even with tens of thousands of active 
 concurrent 
 users (we have 15,000-20,000 active sessions across six CFMX 
 instances 
 during morning peak load).

The bugs I found were confirmed by MACR engineering, however, they were
always stored in the application scope, so maybe that had an impact.
Actually, since it was so easy for me to reproduce the bugs locally with
a stress tool, I'll see if the server scope makes a difference.

-Ray


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFUnit

2003-07-04 Thread Andre Mohamed
Christian,

Thanks for filling in the blanks. I may implement my own version at some
point or begrudgingly hand over some money to get the DRK as it also
appears to have some other great stuff.

Regarding my comments on CFUnit's apparent simplicity compared to JUnit,
these comments were not meant to be taken as criticisms (just in case
you thought so!)

On the contrary, the ability to implement a unit testing framework
with just 2 tag based objects is one of the most blinding testaments
to ColdFusion's power and ease of use!

Nice work.

André

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED] 
Sent: 04 July 2003 16:25
To: CF-Talk
Subject: Re: CFUnit

On Friday, July 4, 2003, at 04:55 AM, Andre Mohamed wrote:

 Although I haven't got the DRK or seen the code for CFUnit, what I
 gather from Christian's article is that the CFUnit framework is 
 merely
 just one single CFC

There are two components: test_case.cfc and test_suite.cfc.  Test case 
is the base component for all cfunit tests, and test_suite allows you 
to bundle multiple test cases into a set, and run them all together.

 it is vastly simplified compared with JUnit.

ColdFusion components are vastly simplified compared to Java objects, 
therefore I think a vastly simplified testing framework is appropriate.

 These assertion methods are presumably fairly
 trivial and comprise of things like assertEquals, assertTrue etc.

There are about 10 assert functions.

 Obviously you can add your own assert methods to the base class as
 needed.

Absolutely.  They are very easy to add.

 I could be way off because as I said I haven't seen the implementation
 of CFUnit but I think that's pretty much it

You're pretty close!

 i.e. ONE CFC! And no where
 near as complex as JUnit.

No, it is not nearly as complex as JUnit.  JUnit is designed to solve 
much more complex problems.  CFUnit is designed to introduce the 
concept of unit testing to ColdFusion developers and provide them with 
a sound, straightforward implementation which can be extended as 
necessary.  However I doubt many ColdFusion developers would have a 
need to extend it much beyond what it already provides.

 On your point about having an equals method: This would be feasible 
 if
 the CFC you were testing implemented and equals method which was
able
 to tell whether it was equal to another CFC by way of comparing 
 instance
 variables/object state etc. i.e. it would require a custom
 implementation of an equals() method for every CFC that you built

This is exactly right, which is why CFUnit does not provide this type 
of equals method.  It certainly wouldn't be difficult to add, however, 
if you were inclined to do that level of unit testing.

Christian


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Parse formated list

2003-07-03 Thread Andre Mohamed
You would use ListFind not ListContains because ListContains looks at
elements to see if they contain the specified substring.

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED] 
Sent: 03 July 2003 14:29
To: CF-Talk
Subject: RE: Parse formated list

This ???

ListContains(list, substring [, delimiters ])

Description
Determines the index of the first list element that contains a specified
substring.

Return value
Index of the first list element that contains substring. If not found,
returns zero.

Category
List functions

Syntax
ListContains(list, substring [, delimiters ])

WG

-Original Message-
From: jeremy [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 14:16
To: CF-Talk
Subject: Parse formated list


I have a list of days in a month being returned from a query. Example
record set would be 2,19,19,21,27 Number between 1 and 31. I then loop
through this query with the code below which generates a list var that
looks like 19,19,21,27 when outputted.

CFLOCK Scope=Session Type=Exclusive Timeout=5
CFSET Session.Calendar.EventListingDate = 
CFLOOP Query=getmonth
CFSET Days = #DateFormat(getmonth.auctiondate,
dd)#
CFSET Session.Calendar.EventListingDate =
ListAppend( Session.Calendar.EventListingDate, Variables.Days)
/CFLOOP
/CFLOCK

That is all well. HERE IS THE PROBLEM. The problem is here with this
cfif. Session.Calendar.EventListingDate contains the above list
2,19,19,21,27 And Variables.CurrentDay is a single number between 1 and
30.  If CurrentDy is say 7 then this if evaluates true as 7 is in 27,
but I don't want that. I want the cfif to check for JUST 7 in the comma
delimited list. How would I do this. It seems like there should be a
list fucntion for this but I can't find it.

cfif Session.Calendar.EventListingDate contains Variables.CurrentDay


/cfif





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Capturing signature input from PDA

2003-07-03 Thread Andre Mohamed
Providing it was the PDA that was browsing the page then yes, this is
possible.

You could use an ActiveX component or a Java applet amongst other
possibilities to achieve this. The component would need to be able to
run on the PDA naturally and would be embedded in the particular web
page the PDA was browsing. 

A quick google brings up this as a basic example (without the save
functionality):

http://www.lawrencegoetz.com/programs/signature/


André

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED] 
Sent: 03 July 2003 14:31
To: CF-Talk
Subject: Capturing signature input from PDA

Is it possible to write a web component (perhaps ActiveX) that would
allow 
a signature to be entered from a WinCE PDA onto a webpage and saved as a

bmp/jpg on the server?

T

Tired of your bookmarks/favourites being limited to one computer?  Move 
them to the Net!
www.stuffbythane.com/webfavourites makes it easy to keep all your 
favourites in one place and
access them from any computer that's attached to the Internet. 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF Flash (crazy idea?)

2003-07-03 Thread Andre Mohamed
Is there a particular reason why Flash is being mandated or needs to be
used? 

If not, it would be just as possible to build using DHTML though that
doesn't mean Flash shouldn't be used after all you'll have to deal with
cross browser issues with the DHTML approach - however I believe the
database interaction would be slightly easier.

I would perhaps implement this as a two step process:

1) The user builds up a list of form elements - no wysiwyg involved -
just normal web application stuff selecting from a pre-defined set. Then
they would set properties for each element they add. You could allow the
ability of setting maximum and minimum sizes, mandatory/non-mandatory,
look up values etc. This list is then persisted - perhaps to a database
of some sort. You can also create a table which would be able to hold
the contents of the form.

2) Step 2 allows the user to arrange the elements they selected in
step 1 on the screen via drag and drop techniques. In addition, you
could allow the appropriate styling of the elements at this stage.
Once this is done, the co-ordinates and positioning can be persisted -
again perhaps to a database.

It should then be feasible to build the form dynamically on-demand -
including client-side and server-side validation and also perform the
database insert into the newly created table by automatically creating
the appropriate SQL provided you captured enough data initially.

There doesn't seem to be any reason why this can't be done and indeed it
has been done to varying degrees e.g. CommonSpot's simple form builder
etc.

André


-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: 03 July 2003 15:59
To: CF-Talk
Subject: CF  Flash (crazy idea?)

Hi everyone.

I have an idea and need to know if it is within the capabilities of
Flash and CF. What I would like to do is provide an interface for users
to come to, where they can create forms and position the form elements
and element labels wherever they wish (within a maximum area). How I
envision this working would be to provide within the interface an area
that contained a list of possible form elements to choose from (text
input, text area, radio, check). When a user dragged one of these into
the form area they could give it a label and fill in the attributes of
that element as well as position the element and its label wherever they
wanted (within the bounds of course). Now for the crazy part...

Would it be possible to take that Flash movie that the user interacted
with to create the initial form and process it into an HTML form where
the layout was almost identical if not exactly identical to how it was
created via the Flash interface (from a positioning and layout
standpoint)? I was thinking maybe there are some functions in flash to
get element coordinates, etc...

The idea would be that this form could be used within an HTML email or
website to gather user feedback. The second part would be to build some
kind of container on the backend whereas those results/responses could
be stored.

Obviously this is a complex idea, one in which is beyond the scope of my
abilities at this time. 

Anyone have thoughts, ideas, technologies to look at, etc... ?

Mike

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFUnit

2003-07-03 Thread Andre Mohamed
It is based on the XUnit testing framework originally developed by Kent
Beck along with Extreme Programming.

http://www.xprogramming.com/software.htm


I see no reason why Macromedia should charge for this though - it should
be submitted along with all the other XUnit tools for public use.

A good explanation (for JUnit) is here:

http://junit.sourceforge.net/doc/cookstour/cookstour.htm

It can quite easily be transferred to CFCs

You should also look at these extensions here:

http://www.junit.org/news/extension/index.htm


André
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 03 July 2003 17:38
To: CF-Talk
Subject: RE: CFUnit

not a dig...just curious on how the MM thought process is done.

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 17:36
To: CF-Talk
Subject: RE: CFUnit


Did he do it though?  Is it a total new development by MM or is it a
redevelopment of someone elses work





-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 17:33
To: CF-Talk
Subject: RE: CFUnit


Christian Cantrall. And it rocks. I _love_ the unit tester (and even
added some more stuff to it).


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Robertson-Ravo, Neil (RX) 
 [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, July 03, 2003 10:30 AM
 To: CF-Talk
 Subject: CFUnit
 
 
 Anyone got any ideas who came up with the CFUnit stuff on the 
 DRK3? 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFUnit

2003-07-03 Thread Andre Mohamed
I'm hoping it will be released separatelyor continue writing my own
version. It's not hard to do and have already developed a version for
unit testing custom tags. See the links I just posted to see how you
could implement your own (even more comprehensive) version.

Unfortunately, there are some of us that can't afford the DRKs!!


André
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED] 
Sent: 03 July 2003 17:49
To: CF-Talk
Subject: RE: CFUnit

Anyway to get this without the drk ?

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 17:33
To: CF-Talk
Subject: RE: CFUnit


Christian Cantrall. And it rocks. I _love_ the unit tester (and even
added some more stuff to it).


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Robertson-Ravo, Neil (RX)
 [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 03, 2003 10:30 AM
 To: CF-Talk
 Subject: CFUnit


 Anyone got any ideas who came up with the CFUnit stuff on the
 DRK3?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Upload a document?

2003-07-02 Thread Andre Mohamed
You can get cffile to create a unique file name if you set the
nameConflict attribute to makeUnique.

The name of the file as saved on the server is accessed in the variable:

Cffile.serverFile

See the ColdFusion Tag Reference for cffile action=upload for more
information.

Yes, Verity can index MS Word and RTF documents.

Here is a partial list of supported types:

Applix Words (v4.2, 4.3, 4.4, 4.41) 
ASCII Text (All versions)
ANSI Text (All versions)
Folio Flat File (v3.1)
HTML (Verity Zone Filter) 
Lotus AmiPro (v2.3) 
Lotus Ami Professional Write Plus (All versions)
Lotus Word Pro (v96, 97, R9) 
Maker Interchange Format (MIF) v5.5
Microsoft RTF (All versions)
Microsoft Word (v2, 6, 95, 97, 2000) 
Microsoft Word Mac (v4, 5, 6, 98) 
Microsoft Word PC (v4.,5, 6) 
Microsoft Works (v1.0, 2.0, 3.0, 4.0)
Microsoft Write (v1.0, 2.0, 3.0)
PDF (Verity PDF Filter) 
Text files (Verity Text Filter) 
Unicode Text (All versions)
WordPerfect (v5.x, 6, 7, 8) 
WordPerfect Mac (v2, 3) 
XyWrite (v4.12)

See the Verity documentation in your ColdFusion Help Files or online at
Live docs for more Verity information.

André

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED] 
Sent: 02 July 2003 15:22
To: CF-Talk
Subject: Re: Upload a document?

Mike,

Can verity search a MS Word document and or RTF? 

Also how would I address the naming of the document that I place in the
folder so there are no conflicts and the right name goes to the SQL
database? 


Thanks for the information!

Regards,

JB



Michael T. Tangorre wrote:

Upload the document into a reusme folder record the name of the doc
in
the DB.
Use verity to allow the search of those resumes in the resume folder?

Im not a huge fan of storing mass amounts of text in a DB, although it
is
necessary sometimes.

Mike


- Original Message - 
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 8:36 AM
Subject: Upload a document?


  

Hello All:

I have a job posting site I'm working on and wanted to know if there
is
a way to have a user upload their resume, possibly scan it for a
virus's
and make it a searchable document in a SQL server 7 database?

This may be a pipe dream.

Any suggestions are welcome or a best practice you might use already.

Regards,

James Blaha







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Active PDF?

2003-06-25 Thread Andre Mohamed
Have a look here:

http://www.cfcomet.com/pdf/

More specifically, look at solutions utilizing FDF files and not needing
COM.

These FDFs can be generated server-side allowing you to pre-populate
some of the form information from a database etc. before sending to the
user who can then fill in the rest online.

Have a look at the Adobe website for their form toolkit API. Depending
on your exact requirements it might be easier than you think and won't
require a third-party product like Active PDF.

André

-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED] 
Sent: 25 June 2003 05:10
To: CF-Talk
Subject: Active PDF?

Howdy -

I have a client who wanted to convert a number of Word-created forms to
PDF's and put them up on their site.  No sweat.  Then, they wanted the
user
to be able to fill out form fields and have Acrobat do all the math, and
they could print out a nice, cleanly filled-out form to sign and fax.
Again, no problem at all.

Now, however, they'd like to take the final step and have fully
interactive
PDF's - where certain dynamic fields are populated from database
information, and the user can submit the PDF like they would any other
web
form and have CF process it accordingly.

I've looked at ActivePDF, but before I dive into that, I wanted to send
out
some feelers to the group to see if anyone's worked with that with CF5
before.  Money's not an object (to a point), so if there's a
particularly
awesome package there I should look into, I'm open to some suggestions.
I
am fiddling with XSL:FO syntax right now, but it's not exactly what I'm
looking for, since I have to work off a previously-existing document
(and I
don't have a great deal of time to really get elbow-deep in *yet
another*
XML spec.)  :)

Thanks,

- Jim


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Active PDF?

2003-06-25 Thread Andre Mohamed
I couldn't agree more.

I have achieved a similar work flow using FDFs and ColdFusion without
problems (except some people not having Acrobat Reader installed) at a
rate of approximately 100 per hour. 

I also have used Active PDF and believe it to be overpriced and overkill
for the requirements outlined though for certain things relating to PDF
generation it is the most suitable solution on the market.

André

-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED] 
Sent: 25 June 2003 13:42
To: CF-Talk
Subject: RE: Active PDF?

Jim,
I'm using cfml to dynamically create fdf files. The link you supply to
your interface calls the fdf. Within the fdf are all your dynamic data.
The fdf itself hold a pointer to a blank pdf template. The template is
loaded and all the data goes in the right holes. Acrobat reader (free
version) supports form submission. Basically all the data comes back to
you via http and is in the form scope when you go to process it.

Overall there are many ways to do this , but this one is free.

Gl,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 {at} columbia [dot] edu


-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 25, 2003 12:10 AM
To: CF-Talk
Subject: Active PDF?


Howdy -

I have a client who wanted to convert a number of Word-created forms to
PDF's and put them up on their site.  No sweat.  Then, they wanted the
user to be able to fill out form fields and have Acrobat do all the
math, and they could print out a nice, cleanly filled-out form to sign
and fax. Again, no problem at all.

Now, however, they'd like to take the final step and have fully
interactive PDF's - where certain dynamic fields are populated from
database information, and the user can submit the PDF like they would
any other web form and have CF process it accordingly.

I've looked at ActivePDF, but before I dive into that, I wanted to send
out some feelers to the group to see if anyone's worked with that with
CF5 before.  Money's not an object (to a point), so if there's a
particularly awesome package there I should look into, I'm open to some
suggestions.  I am fiddling with XSL:FO syntax right now, but it's not
exactly what I'm looking for, since I have to work off a
previously-existing document (and I don't have a great deal of time to
really get elbow-deep in *yet another* XML spec.)  :)

Thanks,

- Jim



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Parse cfm templates stored in a variable?

2003-06-20 Thread Andre Mohamed
There is no alternative but to include the file.

However, if the code is all cfscript, it would technically be possible
to evaluate the whole lot at run time.

André

-Original Message-
From: Peter Mayer [mailto:[EMAIL PROTECTED] 
Sent: 20 June 2003 11:15
To: CF-Talk
Subject: Parse cfm templates stored in a variable?

Hello!

I am reading files using cffile and storing them in a application
variable 
(because they are very often accessed).

If the file is a cfm template I would like to execute it - is there a 
simple way to do that?

The only solution I've seen so far would be to save the application 
variable to a file and than do a cfinclude with that temporary file.

Best regards,

Peter

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Parse cfm templates stored in a variable?

2003-06-20 Thread Andre Mohamed
Mathew,

Actually you can evaluate functions too e.g.

#Evaluate(Len('foo'))#

Naturally, you can’t easily deal with loop constructs or conditional
logic.

When I said it would technically be possible - I meant it would be
possible by using a suitable mechanism e.g.

You could parse the file by semi-colon and then Evaluate each line
e.g.

If the file contained this:

Foo = 'bar';
Bar = 'foo';
Baz = Left(foo  bar,3);

Then you could turn that into:

Evaluate(foo = 'bar',Bar = 'foo',Baz = Left(foo  bar,3));

Or a separate Evaluate for each line. I have done this successfully in
the past when it was advantageous to allow a knowledgable user to enter
some scripting which could then get executed at run time - much like you
would do with VBScript/Javascript.

HOWEVER, this is all way too much for what the original question was.

It all depends on the context of why the include files are being put
into the application scope for in the first place.

If they are being held there to be used dynamically whereby the output
or result of the include is going to be different each time (this is
what I understood) then caching the output using cfsavecontent is not an
appropriate solution.

If, however, it is the output of the include that needs to be cached
then using cfsavecontent to save the output is obviously the way to go.

Under any circumstances it makes no sense to read the file in using
cffile only to have to write it out again when you want to include it!
The most suitable approach is just to cfinclude the file as needed.


Regards,

André

-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED] 
Sent: 20 June 2003 12:34
To: CF-Talk
Subject: Re: Parse cfm templates stored in a variable?

Actually you can only evaluate expressions, not whole chunks of cfscript
such as loops, functions, etc.

What's wrong with cfincluding them? Also BTW instead of using cffile why
not
simply use cfsavecontent and cfinclude?

Perhaps you might consider cfincluding the CF templates and caching the
result for a given period of time?


Regards,
Matthew Walker
Electric Sheep Web
http://www.electricsheep.co.nz/

- Original Message - 
From: Andre Mohamed [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 20, 2003 10:52 PM
Subject: RE: Parse cfm templates stored in a variable?


 There is no alternative but to include the file.

 However, if the code is all cfscript, it would technically be possible
 to evaluate the whole lot at run time.

 André

 -Original Message-
 From: Peter Mayer [mailto:[EMAIL PROTECTED]
 Sent: 20 June 2003 11:15
 To: CF-Talk
 Subject: Parse cfm templates stored in a variable?

 Hello!

 I am reading files using cffile and storing them in a application
 variable
 (because they are very often accessed).

 If the file is a cfm template I would like to execute it - is there
a
 simple way to do that?

 The only solution I've seen so far would be to save the application
 variable to a file and than do a cfinclude with that temporary file.

 Best regards,

 Peter

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Parse cfm templates stored in a variable?

2003-06-20 Thread Andre Mohamed
Yes, I realised during lunch - just now - that's probably what you
meant!

-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED] 
Sent: 20 June 2003 13:48
To: CF-Talk
Subject: Re: Parse cfm templates stored in a variable?

 Actually you can evaluate functions too e.g.

Right. I think I meant function declarations rather than invocations --
too
late on a Friday night for me. ;-)



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-12 Thread Andre Mohamed
This is a known issue and has I believe been acknowleged by various
parties.

It is the result of a limitation of the underlying Axis engine that
CFMX uses. 

I believe there were plans for Axis in the future (possibly the version
that is used in the next point release of MX - I haven't tried yet) to
mitigate problems concerning result set incompatibilities between .NET
and CFMX.

Since, the issue could be construed as lying with Axis it is somewhat
out of Macromedia's hands.

In the mean time, as suggested you could use an array of structs or
develop your own CFC to represent result sets.

André

-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED] 
Sent: 12 June 2003 01:22
To: CF-Talk
Subject: RE: Consuming CFMX Web Services in ASP.NET

Try returning an array of structs...should be a lot easier to work with
in .NET

-Stace

-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 3:21 AM
To: CF-Talk
Subject: Consuming CFMX Web Services in ASP.NET

My friend has a problem when calling a web service method which returns
CFMX query object.
 
When I return a query object from CFC function, .NET cannot get the
recordset object.
 
I'm using CFMX U3.
 
Any experiences?





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Prevent Refresh

2003-06-10 Thread Andre Mohamed
To avoid the refresh problem the best way to handle idempotent actions
i.e form submissions is to perform a redirection after the relevant
action has occurred.

Note: This requires a client-side redirect which cflocation will do
for you. So the page flow becomes this:

1) Form
2) Action Page - Database insert/update etc.
3) Redirect
4) End Page/Confirmation/Form again...

If a refresh is done once on step 4, the Action page will not be run
again.

Hope that helps,

André

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 10 June 2003 14:18
To: CF-Talk
Subject: Prevent Refresh

What is best way of preventing multiple entries in DB through form
submission when user clicks on REFRESH or BACK button of browser?
 
Thanks
Shaz


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFQUERY - cachedwithin

2003-06-06 Thread Andre Mohamed
Try this:

In your application.cfm 

cfif IsDefined(URL.refreshQueryCache)
cfset request.cachetimespan = CreateTimeSpan(0,0,0,0)
cfelse
cfset request.cachetimespan = CreateTimeSpan(1,0,0,0)
/cfif

Then...

cfquery name=query datasource=dsn
cachedwithin=#request.cachetimespan#
...BLAH...
/cfquery


For this to work you need to call the page with a URL parameter and it
needs to be the page that has the query on it.

Alternatively, for more granular control:

cfif isDefined(application.recache)
cfset request.cachetimespan = CreateTimeSpan(0,1,0,0)
!--- Remove the application variable so this doesn't get
re-cached   again next time until it is set again else where... ---
cfset StructDelete(application,recache)
cfelse
cfset request.cachetimespan = application.cachetimespan
/cfif


cfquery name=query datasource=dsn
cachedwithin=#request.cachetimespan#
...BLAH...
/cfquery

etc.

Hope that helps,

André
-Original Message-
From: Jim Banks [mailto:[EMAIL PROTECTED] 
Sent: 05 June 2003 13:19
To: CF-Talk
Subject: CFQUERY - cachedwithin

When you have used cachedwithin in CFQUERY, is it possible to override
that before the cachedtime is up? For example,
 
cfif not isdefined(application.recache)
cfquery name=query datasource=dsn
cachedwithin=#createtimespan(0,1,0,0)#
...BLAH...
/cfquery
cfelse
cfquery name=query datasource=dsn
...BLAH...
/cfquery
cfset temp = structdelete(application, recache)
/cfif
 
Here, it'd be great if I could 'reset' the query so that if I've defined
somewhere else on the site that the query has changed using the
application variable, I can get it to use the new query results and
cache that for next time, instead.
 
Thanks!





-
Yahoo! Plus - For a better Internet experience


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: how to share servlet's session with Cold Fusion MX template?

2003-06-06 Thread Andre Mohamed
Unfortunately it’s not quite as simple as being able to see each others
session or application variables in the same way. Request variables can
be seen as you would expect.

To put a variable into a ColdFusion session you have to do something
like this:

In your JSP/Servlet

(Map) session.getAttribute(yourCFApplicationName).put(foo,bar);

And then you can access it in a .cfm like this:

#session.foo#


Application variables are easier:

application.setAttribute(yourCFApplicationNam.foo,bar);

In you .cfm you access it like this:

#application.foo#


The key to remember is that it is all oriented around the application
name you defined for your ColdFusion app using cfapplication

I believe there is more comprehensive coverage in the cfdocs.

Regards,

André

-Original Message-
From: Steve [mailto:[EMAIL PROTECTED] 
Sent: 05 June 2003 15:07
To: CF-Talk
Subject: how to share servlet's session with Cold Fusion MX template?

Hello everyone,
 
I deployed ColdFusion MX as a web application to WebLogic7.0. 
I have a J2EE servlet that invokes a CFM page. This works. However, if I
try to set an attribute in the servlet's session, and try to pass that
session along to the CFM Page, in the CFM Page, it will NOT understand
that attribute. 

In the CFM page, i have

// test forwarding to cfm page.
String userArr[] = new String[1];

userArr[0] = Wednesday;
HttpSession session = request.getSession(true);
session.setAttribute(sess, userArr);

getServletConfig().getServletContext().getRequestDispatcher
(/test/UserResultForm.cfm).forward(request, response);

And in the invoked CFM page, I cfdump the session info with this line,

cfdump var=#session#

I don't see sess as a valid attribute! in fact, when I try to access
it with

!--- cfoutput debug : #session.sess#/cfoutput ---

ColdFusion would throw an error saying sess is NOT defined.

In the Cold fusion Adminstrator, i have certainly turned on Enable
Session Variables and Use J2EE session variables flags and restarted
the server.  and in my application.cfm, I already have the following
attributes set, as follows,
 
cfapplication name=form175 SESSIONMANAGEMENT=YES
SESSIONTIMEOUT=#CREATETIMESPAN(0,0,30,0)#

Thx a lot in advance for any suggestions/examples!

Steven




-
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Regex replacing whole words

2003-06-05 Thread Andre Mohamed
Standing on the shoulders of giants a very quick and dirty way of
dealing with the case issue:

cfset oldname=ben
cfset newname=mike
cfset
t=rereplace(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName#
\2,ALL)

cfset oldname=Ben
cfset newname=Mike
cfset
t=rereplace(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName#
\2,ALL)

i.e. not using REReplaceNoCase, just REReplace.

André


-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED] 
Sent: 04 June 2003 15:46
To: CF-Talk
Subject: Re: Regex replacing whole words

This gets you part of the way:

cfset oldname=ben
cfset str=Ben lives in benland. But ben is actually not called ben.
He's called ben-dabble.
cfset newname=mike

cfset
t=rereplaceNoCase(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#ne
wName#\2,ALL)

cfoutput#t#/cfoutput


Note that it does not retain the proper capitalization from the
original, but instead uses the name as supplied by newName.

To get the proper capitalization, I think you will either need to run
through every permutation of capitalization as different case-specific
regex, or do a find-and-replace instead.

Ninja, any ideas here?

Jerry Johnson

 [EMAIL PROTECTED] 06/04/03 10:34AM 
I can't get my head around regular expressions! Help me please before I
go mad!
 
I need to replace one word with another, matching cases (if possible),
but in a smart way. eg.
 
Ben lives in benland. But ben is actually not called ben. He's called
ben-dabble
 
Say I want to replace 'ben' (any case) with 'mike', I would like to get:

Mike lives in benland. But mike is actually not called mike. He's
called mike-dabble
 
Note the punctuation - I only want whole words, or words which are
surrounded by punctuation. Does that make sense?
 
I know I'm asking a lot but doing it using normal code and replace() is
a slow operation. Even a reg-ex which will just replace whole words
(including if they're at the beginning or end of a string) would be
fantastic. I could do 2 regexs to do the case-matching, if it's not
possible to do it in 1.
 
Many Thanks!




-
Yahoo! Plus - For a better Internet experience



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: JS help

2003-06-04 Thread Andre Mohamed
innerText is what you are after.

You'll need to locate the relevant anchor object using DOM and then once
you have that object it is just:

anchorObject.innerText;


That should set you on your way,

André
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED] 
Sent: 03 June 2003 16:25
To: CF-Talk
Subject: OT: JS help

Ok, this is an odd request but:

I was curiosu if it is possible with javascript to reference the value
of the text contained inbetween the a
href=mylink.htm?search=JavascripforMyValueThevalue/a

Any help would be awesome.

I need to do this with JS only

Thanks



Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Selecting form

2003-06-04 Thread Andre Mohamed
Try something like this:

select name=selectSystem size=1 class=inputfield
option value= cfif NOT Len(form.value)selected/cfifSelect
system.../option
option value= Nintendo GameCube cfif NOT CompareNoCase(Nintendo
GameCube,form.value)selected/cfif Nintendo GameCube/option
...
/select


If your drop down box is being populated from a query it becomes easier:

select name=selectSystem
cfloop query=systemSelect
option value=#value# cfif NOT
CompareNoCase(value,form.selectSystem)selected/cfif#display#/option

/cfloop
/select


André
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: 04 June 2003 13:07
To: CF-Talk
Subject: Selecting form

Hi,

I have a form where I'm storing all the input fields into FORM.variables
so if the user hits the refresh the form is reloaded and all the input
fields are retained.

I have a dropdown menu selection in my form. How can I have the below
code do the same. What am I doing wrong?


Consolenbsp;System:nbsp;
select name=selectSystem size=1 class=inputfield
cfif value is FORM.value
  cfset isSelected='selected'
cfelse
  cfset isSelected = ''
/cfif
option value= defaultSelect System.../option
option value=Nintendo GameCube #isSelected#Nintendo
GameCube/option
option value=Nintendo GameBoy #isSelected#Nintendo GameBoy/option
option value=Microsoft XBox #isSelected#Microsoft XBox/option
/select




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFCDEV List

2003-06-04 Thread Andre Mohamed
I still receive posts from there so yes, it does appear to still be
alive.

André

-Original Message-
From: D. Delcomminette [mailto:[EMAIL PROTECTED] 
Sent: 04 June 2003 13:23
To: CF-Talk
Subject: SOT: CFCDEV List

Is CFCDEV list still alive? I didn't receive any posts for more than a
week,
although I made 2 posts myself.
Thanks

Dominique



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: exporting DSN list

2003-06-03 Thread Andre Mohamed
Create a ColdFusion Archive (using the archive tool found in the
administrator) of the relevant bits and pieces you want to transfer.

André

-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED] 
Sent: 02 June 2003 14:38
To: CF-Talk
Subject: exporting DSN list

Is it possible to export a DSN list using Cold Fusion Server
Administrator or otherwise (CF 5) ... so that I don't have to manually
reenter the DSN's whenever I redo a box
Thanks in advance
Tim





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Can someone help me understand how to import com.allaire.cfx

2003-06-03 Thread Andre Mohamed
You need to make sure com.allaire.cfx is on your classpath by setting a
system variable.

Alternatively you can compile with the -c switch specifiying where the
library is e.g.

Javac -c c:/cfusionmx/lib/ SimpleMessage.java

Etc.

André

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED] 
Sent: 03 June 2003 11:10
To: CF-Talk
Subject: Can someone help me understand how to import com.allaire.cfx

Hi all,

Im trying to write a small java app with the view to pulling them in
with CF
for some
tasks suited to the job.
 

This app has been copied straight from Java for CF Developers,

//SimpleMessage.java

import com.allaire.cfx.*;
import java.util.*;
import java.text.DateFormat;

public class SimpleMessage implements CustomTag{
Date now=new Date();
DateFormat
f=DateFormat.getDateInstance(DateFormat.FULL,Local.US);

public void processRequest(Request request, Response response)
throws Exception

{
f.format(now);
String name=request.getAttribute(NAME);
response.write(Hello, +name+! Today is +f);
}
}

this file sits in c:/cfusionmx/wwwroot/web-inf/public/

obviously I want to implement this as a custom tag so Im trying to
import
the Allaire interfaces  - com.allaire.cfx,
this sits at c:\cfusionmx\lib\cfx.jar

The problem is I can't,

the classpath is set in administrator as c:\cfusionmx\lib\cfx.jar,

I tried putting the jar file in the same directory as my java file,
I also tried javac -classpath %classpath%;c:cfusionmx\lib\cfx.jar
c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java,

anyway this command gave this error,

C:\CFusionMX\wwwroot\WEB-INF\publicjavac -classpath
%classpath%;c:cfusionmx\lib
\cfx.jar c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java
c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java:1: package
com.allaire.cf
x does not exist
import com.allaire.cfx.*;
^ etc

The compiler just doesnt know where the jar file is,

I don't understand either how com.allaire is being called in the package
reference either,
I dont know where com.allaire is coming from, I know about designing
packages, and if i'm right packages are directories,
well cfx.jar is sitting in cfusionmx/lib/ not com/allaire/ 

overall error, I do understand the falling errors are caused due the tag
having not been inplemented, well some!

javac SimpleMessage.java
SimpleMessage.java:1: package com.allaire.cfx does not exist
import com.allaire.cfx.*;
^
SimpleMessage.java:5: cannot resolve symbol
symbol  : class CustomTag
location: class SimpleMessage
public class SimpleMessage implements CustomTag{
  ^
SimpleMessage.java:9: cannot resolve symbol
symbol  : class Request
location: class SimpleMessage
public void processRequest(Request request, Response response)
   ^
SimpleMessage.java:9: cannot resolve symbol
symbol  : class Response
location: class SimpleMessage
public void processRequest(Request request, Response response)
^
SimpleMessage.java:7: cannot resolve symbol
symbol  : variable Local
location: class SimpleMessage
DateFormat
f=DateFormat.getDateInstance(DateFormat.FULL,Local.US);
^
5 errors



J






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Can someone help me understand how to import com.allaire.cfx

2003-06-03 Thread Andre Mohamed
Err...

Just realized my last post wasn't very helpful.

Try this:

javac -c {Installation Path}\lib\cfx.jar SimpleMessage.java

André

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED] 
Sent: 03 June 2003 11:10
To: CF-Talk
Subject: Can someone help me understand how to import com.allaire.cfx

Hi all,

Im trying to write a small java app with the view to pulling them in
with CF
for some
tasks suited to the job.
 

This app has been copied straight from Java for CF Developers,

//SimpleMessage.java

import com.allaire.cfx.*;
import java.util.*;
import java.text.DateFormat;

public class SimpleMessage implements CustomTag{
Date now=new Date();
DateFormat
f=DateFormat.getDateInstance(DateFormat.FULL,Local.US);

public void processRequest(Request request, Response response)
throws Exception

{
f.format(now);
String name=request.getAttribute(NAME);
response.write(Hello, +name+! Today is +f);
}
}

this file sits in c:/cfusionmx/wwwroot/web-inf/public/

obviously I want to implement this as a custom tag so Im trying to
import
the Allaire interfaces  - com.allaire.cfx,
this sits at c:\cfusionmx\lib\cfx.jar

The problem is I can't,

the classpath is set in administrator as c:\cfusionmx\lib\cfx.jar,

I tried putting the jar file in the same directory as my java file,
I also tried javac -classpath %classpath%;c:cfusionmx\lib\cfx.jar
c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java,

anyway this command gave this error,

C:\CFusionMX\wwwroot\WEB-INF\publicjavac -classpath
%classpath%;c:cfusionmx\lib
\cfx.jar c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java
c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java:1: package
com.allaire.cf
x does not exist
import com.allaire.cfx.*;
^ etc

The compiler just doesnt know where the jar file is,

I don't understand either how com.allaire is being called in the package
reference either,
I dont know where com.allaire is coming from, I know about designing
packages, and if i'm right packages are directories,
well cfx.jar is sitting in cfusionmx/lib/ not com/allaire/ 

overall error, I do understand the falling errors are caused due the tag
having not been inplemented, well some!

javac SimpleMessage.java
SimpleMessage.java:1: package com.allaire.cfx does not exist
import com.allaire.cfx.*;
^
SimpleMessage.java:5: cannot resolve symbol
symbol  : class CustomTag
location: class SimpleMessage
public class SimpleMessage implements CustomTag{
  ^
SimpleMessage.java:9: cannot resolve symbol
symbol  : class Request
location: class SimpleMessage
public void processRequest(Request request, Response response)
   ^
SimpleMessage.java:9: cannot resolve symbol
symbol  : class Response
location: class SimpleMessage
public void processRequest(Request request, Response response)
^
SimpleMessage.java:7: cannot resolve symbol
symbol  : variable Local
location: class SimpleMessage
DateFormat
f=DateFormat.getDateInstance(DateFormat.FULL,Local.US);
^
5 errors



J






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Removing bad emails from newsletter db

2003-05-29 Thread Andre Mohamed
Blood,

It's fairly straight forward to code yourself.

You can access the undeliverables folder using CFDIRECTORY and then
parse the messages for the e-mail address that bounced and use that to
update the database.

If on MX I suggest using server.coldfusion.rootDir etc. to locate the
undeliverable folder etc.

On CF5 and Windows you can use CFREGISTRY etc.

Note: the .cfmail file formats are different from CF5 to CFMX.

Also, if you want to re-spool messages in CFMX you need to rename the
file and restart the CF's mail spool service...which is technically
possible to do programmatically using yet more undocumented functions.

André

-Original Message-
From: Blood Python [mailto:[EMAIL PROTECTED] 
Sent: 28 May 2003 16:40
To: CF-Talk
Subject: Removing bad emails from newsletter db

One of my client's has about 103k people in his mailing list. He's
running 
his website since 99 and many of these e-mails are bad ones.

He wants me to remove the bad e-mails from this list. I used to do that 
using a software called worldcast, from fairlogic (www.fairlogic.com).
It 
uses DNS to validate e-mails, pretending to send an e-mail and stopping
just 
after he got the 250 code (user exists) or 550 (unknow).

Unfortunatly, many networks are not allowing DNS sends, because of spam,
so 
it its not a good solution anymore. I will need to build a tool that 
interprets the returned e-mails from an actual send (those Undeliverable

e-mails) and delete the user based on this e-mail's content.

Do you guys knows any software or code that do such thing? Doesn't need
to 
be in cf... I will need to code it myself if i don't find something like

that to use, because client needs it very bad (he needs to reduce
bandwidth 
costs).

Thank you for your repplies in advance.

BP.

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: is an object with a lot of methods a memory buster?

2003-05-27 Thread Andre Mohamed
Dave,

Another possibility:

Perhaps all of the instances of the persisted CFC merely carry a
name/pointer pair which points to a singe stale copy of the method and
hence Sean's statement still holds partially true regarding not taking
up a great deal of space.

However, I'm merely making a similar conjecture.

André
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 27 May 2003 17:25
To: CF-Talk
Subject: RE: is an object with a lot of methods a memory buster?

  However, I believe that when you create a CFC instance, 
  you get (effectively) a Java Map (actually an implementation 
  of a Map) that has entries for each method. Each entry is
  merely a 'pointer' to the representation of the method. 
  I'm guessing that based on the fact that you can access 
  methods of a CFC instance as variables:
 
  fn.cfc:
  cfcomponent
  cffunction name=foo
  /cffunction
  /cfcomponent
 
  tfn.cfm:
  cfscript
  x = createObject(component,fn);
  y = x[foo];
  y = x.foo;
  /cfscript
 
  So, in each CFC instance you create, you will get entries 
  in the Map for every method (or, at least, every public 
  method) but those entries won't take up a great deal of 
  space (since they are just name, pointer pairs).
 
 Good answer; that's just what I wanted to hear. Thanks very 
 much!

While that may be what you wanted to hear, I have my doubts about it.
When
you create an instance from a CFC and put it in a persistent scope, then
change one of the methods within the CFC code, the instance doesn't use
the
new code, but rather the original code that was there when it was
instantiated. This leads me to believe that it carries its own copy of
the
method code with it.

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Using createUUID()

2003-03-17 Thread Andre Mohamed
If you only use 4 characters then there are only roughly (10+26) to the
power of 4 = 1679616 different combinations... this is a relatively low
number which may or may not be considered unique enough for your
purposes. 

With only 100,000 records you already have nearly a 6% chance of a
collision.

André

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:34
To: CF-Talk
Subject: RE: Using createUUID()

not sure what the odds could be : its not 1 in a thousand, I see your
point,
but in this instance, just include more chars or add your own rand
function...

though, Rand again but definition is not 'unique', there is a chance you
could get the same ID.

N

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()


but not the first four...the whole uuid in and of itself, would be,
however, you could conceivably
get the same striking everything but the first four

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:28 AM
To: CF-Talk
Subject: RE: Using createUUID()


erm... I would say that they are unique.  No UUID is the same by its
very
definition; thats the point...  

sic/
The mechanism used to guarantee that UUIDs are Unique is through
combinations of hardware addresses, time stamps and random seeds. 

No two comps can generate the same UUID.

AFAIK


-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:27
To: CF-Talk
Subject: RE: Using createUUID()


I wouldn't do that , first 4 chars of createuuid() are not unique. If
you cat that with something else than _maybe_ you are doing a bit
better. 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:18 AM
To: CF-Talk
Subject: RE: Using createUUID()


if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E-
etc...) then you may be able to use newid() within mySQL, though I am
not sure that it supports it.

In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
4 chars of a CF generated ID.

HTH

Neil

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:04
To: CF-Talk
Subject: RE: Using createUUID()


Use the current date and add random numbers to the end:

03172003nn where 'nnn' are the random numbers.

To be honest with you... UUID is the way to go though, but this should
work.

#DateFormat(now(),mmdd)##Rand()##Rand()#




-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:56 AM
To: CF-Talk
Subject: Using createUUID()


Hi,

I need to generate a unique ID for every form I submit. The createUUID #
generated is just too long for my needs. My ID only needs to be 10
characters in length. Something like:

CT-0001001

I'm using MySQL. Can I have mysql generate the unique ID? How could I do
this with CF?




---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---










~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Using createUUID()

2003-03-17 Thread Andre Mohamed
Ignore my last post...ASCII has more than 36 characters...the point
still holds though.

-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:48
To: CF-Talk
Subject: RE: Using createUUID()

If you only use 4 characters then there are only roughly (10+26) to the
power of 4 = 1679616 different combinations... this is a relatively low
number which may or may not be considered unique enough for your
purposes. 

With only 100,000 records you already have nearly a 6% chance of a
collision.

André

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:34
To: CF-Talk
Subject: RE: Using createUUID()

not sure what the odds could be : its not 1 in a thousand, I see your
point,
but in this instance, just include more chars or add your own rand
function...

though, Rand again but definition is not 'unique', there is a chance you
could get the same ID.

N

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()


but not the first four...the whole uuid in and of itself, would be,
however, you could conceivably
get the same striking everything but the first four

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:28 AM
To: CF-Talk
Subject: RE: Using createUUID()


erm... I would say that they are unique.  No UUID is the same by its
very
definition; thats the point...  

sic/
The mechanism used to guarantee that UUIDs are Unique is through
combinations of hardware addresses, time stamps and random seeds. 

No two comps can generate the same UUID.

AFAIK


-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:27
To: CF-Talk
Subject: RE: Using createUUID()


I wouldn't do that , first 4 chars of createuuid() are not unique. If
you cat that with something else than _maybe_ you are doing a bit
better. 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:18 AM
To: CF-Talk
Subject: RE: Using createUUID()


if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E-
etc...) then you may be able to use newid() within mySQL, though I am
not sure that it supports it.

In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
4 chars of a CF generated ID.

HTH

Neil

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:04
To: CF-Talk
Subject: RE: Using createUUID()


Use the current date and add random numbers to the end:

03172003nn where 'nnn' are the random numbers.

To be honest with you... UUID is the way to go though, but this should
work.

#DateFormat(now(),mmdd)##Rand()##Rand()#




-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:56 AM
To: CF-Talk
Subject: Using createUUID()


Hi,

I need to generate a unique ID for every form I submit. The createUUID #
generated is just too long for my needs. My ID only needs to be 10
characters in length. Something like:

CT-0001001

I'm using MySQL. Can I have mysql generate the unique ID? How could I do
this with CF?




---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---











~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Using createUUID()

2003-03-17 Thread Andre Mohamed
MySQL has an AUTO_INCREMENT column type (well it used to). It depends
what scope of uniqueness you need for the ID - if unique at the table
level is sufficient then this will do, though it does tie your code down
to MySQL.

André

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:48
To: CF-Talk
Subject: RE: Using createUUID()

yep, as noted in another post, if it fits your development, then you can
still use it; 

back on track : does and will mySQL support newid()

-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:51
To: CF-Talk
Subject: RE: Using createUUID()


Ignore my last post...ASCII has more than 36 characters...the point
still holds though.

-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:48
To: CF-Talk
Subject: RE: Using createUUID()

If you only use 4 characters then there are only roughly (10+26) to the
power of 4 = 1679616 different combinations... this is a relatively low
number which may or may not be considered unique enough for your
purposes. 

With only 100,000 records you already have nearly a 6% chance of a
collision.

André

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:34
To: CF-Talk
Subject: RE: Using createUUID()

not sure what the odds could be : its not 1 in a thousand, I see your
point,
but in this instance, just include more chars or add your own rand
function...

though, Rand again but definition is not 'unique', there is a chance you
could get the same ID.

N

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()


but not the first four...the whole uuid in and of itself, would be,
however, you could conceivably
get the same striking everything but the first four

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:28 AM
To: CF-Talk
Subject: RE: Using createUUID()


erm... I would say that they are unique.  No UUID is the same by its
very
definition; thats the point...  

sic/
The mechanism used to guarantee that UUIDs are Unique is through
combinations of hardware addresses, time stamps and random seeds. 

No two comps can generate the same UUID.

AFAIK


-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:27
To: CF-Talk
Subject: RE: Using createUUID()


I wouldn't do that , first 4 chars of createuuid() are not unique. If
you cat that with something else than _maybe_ you are doing a bit
better. 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:18 AM
To: CF-Talk
Subject: RE: Using createUUID()


if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E-
etc...) then you may be able to use newid() within mySQL, though I am
not sure that it supports it.

In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
4 chars of a CF generated ID.

HTH

Neil

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:04
To: CF-Talk
Subject: RE: Using createUUID()


Use the current date and add random numbers to the end:

03172003nn where 'nnn' are the random numbers.

To be honest with you... UUID is the way to go though, but this should
work.

#DateFormat(now(),mmdd)##Rand()##Rand()#




-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:56 AM
To: CF-Talk
Subject: Using createUUID()


Hi,

I need to generate a unique ID for every form I submit. The createUUID #
generated is just too long for my needs. My ID only needs to be 10
characters in length. Something like:

CT-0001001

I'm using MySQL. Can I have mysql generate the unique ID? How could I do
this with CF?




---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---













~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: RegEx Help!

2003-03-14 Thread Andre Mohamed
Oliver,

Try something like this:

cfset yourNewString = ReReplaceNoCase(yourOldString, [^]*, ,
ALL)

Thanks,

André

-Original Message-
From: Oliver Cookson [mailto:[EMAIL PROTECTED] 
Sent: 14 March 2003 11:13
To: CF-Talk
Subject: SOT: RegEx Help!

Any ninja's out there? ;)

Im having trouble with a regular expression i wonder if anyone could 
help?

Im looking for this string (see bottom) and want to remove EVERYTHING 
except the word a string here. This string could be any length or any 
combo of chars\integers.

Also the JS arg (14) is dynamic so that could be any number, everything 
else is static.

A class=jargon href=javascript:popUpJargonDefinition(14)a string 
here/A

Hope someone can help, mail me off list if preferred.

Thanks

Oliver


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Query of Queries w/ subquery in CF 5?

2003-03-13 Thread Andre Mohamed
Rob,

Not sure if CF5 query of queries can handling your sub-selects. Anyway,
try this as a possible alternative:

Select * from Query1 where Q1MachineName not in
(#QuotedValueList(Query2.Q2MachineName)#)
UNION
Select * from Query2 where Q2MachineName not in
(#QuotedValueList(Query1.Q1MachineName)#)


Thanks,

André

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] 
Sent: 13 March 2003 14:37
To: CF-Talk
Subject: Query of Queries w/ subquery in CF 5?

I am using ColdFusion 5 Enterprise Edition.  I have 2 separate oracle
databases that cannot communicate to each other, but the web server can
communicate to them individually.  I am pulling back data from to
queries as
such.

Query 1:

Machine1 null   Loc1 
Machine2 null   Loc2
Machine3 null   Loc3 
Machine4 null   Loc4



Query2
null   Machine1 Loc1 
null   Machine3 Loc3 
null   Machine4 Loc4
null   Machine5 Loc5

I am trying to get a union query with nested selects to work as such

Select * from Query1 where Q1MachineName not in (Select Q2MachineName
from
Query2)
UNION
Select * from Query2 where Q2MachineName not in (Select Q1MachineName
from
Query1)

So I end up with 

Machine2 null   Loc2
null   Machine5 Loc5

The problem is, when I run the union query above, I get the error Query
Manipulation Error Code = 0 
Can't find symbol: select

Any suggestions as to what I am doing wrong?

Thanks,
Rob Edwards



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF Talking to a EJB

2003-03-13 Thread Andre Mohamed
Michael,

You're right, you'll need to import javax.rmi.PortableRemoteObject or
perhaps cfobject one. This whole thing might be best written as a
Servlet or JSP which you then include or forward to. Just a thought.

André

-Original Message-
From: Michael Hoffman [mailto:[EMAIL PROTECTED] 
Sent: 13 March 2003 16:24
To: CF-Talk
Subject: RE: CF Talking to a EJB

How would I do this line?
PortableRemoteObject.narrow(o, TitleSessionEJBHome.class);

the .class is what I am not sure how to do.  Plus the constructor for 
PortableRemoteObject is protected.


Original Message Follows
From: webguy [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: CF Talking to a EJB
Date: Thu, 13 Mar 2003 15:44:39 -
Received: from houseoffusion.com ([64.118.64.245]) by 
mc6-f27.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 13
Mar 
2003 07:46:28 -0800
X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
Message-ID: [EMAIL PROTECTED]
Precedence: bulk
References: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 13 Mar 2003 15:46:29.0025 (UTC) 
FILETIME=[B6650910:01C2E977]

You might need to create a instance or

javax.rmi.PortableRemoteObject ??

WG

-Original Message-
From: Michael Hoffman [mailto:[EMAIL PROTECTED]
Sent: 13 March 2003 15:12
To: CF-Talk
Subject: CF Talking to a EJB


All the code that I have found for a CF page talking to a EJB it does
not
include the PortableRemoteObject.narrow call.  Any ideas on this?
Narrowing
is used on remote interfaces and not local interfaces?  Narrowing checks
to
ensure that an object of a remote or abstract interface type can be cast
to
a desired type.  Does anyone have any narrowing code that works within a
CF
page?

cfobject
action =create
type =java
class =javax.naming.InitialContext
name =ictx

cfscript
ictx.addToEnvironment(java.naming.provider.url,
w2k069.sysadmin.suny.edu:2908);
/cfscript

cfset ejbHome =ictx.lookup(TitleSessionEJB)
cfset bean =ejbHome.create()
cfset myString =javaCast(String,bean.getTitle())

Thanks!
Mike






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to access row in loop

2003-03-13 Thread Andre Mohamed
Depending on the impact you might want to reimplement your
cdjwebdoc.cdweb structure as a query using QueryNew etc. as long as each
row has the same columns...this certainly seems to be what you are
trying to achieve.

Then you can use cfloop query=... as normal. A little easier to read
and manage.

...but to answer your query...the currentrow variable isn't set when
looping over a structure as far as I know.

Thanks,

André

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 13 March 2003 17:22
To: CF-Talk
Subject: How to access row in loop

Here's my busted attempt to get certain items from a structure while
looping
through it...can someone tell me where I messed up?

(structure is like this:  cdjwebdoc.cdweb.1.sku
  cdjwebdoc.cdweb.1.unitcost
  cdjwebdoc.cdweb.2.sku and so on

heres my busted attempt:
 
cfloop collection=cdjwebdoc.cdweb
  !---Check for existence of SKU
  cfquery name=check datasource=#dsn#
  Select id from inventory where sku =
'#trim(cdjwebdoc.cdweb.[currentrow].sku)#'
  /cfquery
  cfif check.recordcount EQ 1
!--- IF SO, Update---
cfquery name=updateinv datasource=#dsn#
Update inventory set 
intcontent =
'#cdjwebdoc.cdweb.[currentrow].internetdescription#',
invtitle = '#cdjwebdoc.cdweb.[currentrow].invoicedescription#', 
sellprice = #cdjwebdoc.cdweb.[currentrow].internetsellfor#,
sale = #cdjwebdoc.cdweb.[currentrow].sale#, 
item_cost = #cdjwebdoc.cdweb.[currentrow].unitcost#,
inventory_minimum =
#cdjwebdoc.cdweb.[currentrow].minimuminventory#
 Where
sku = '#trim(cdjwebdoc.cdweb.[currentrow].sku)#'

/cfquery

How does a guy go about making that work??  Or am I in the wrong
ballpark? 

Regards,

Eric J. Hoffman
DataStream Connexion
www.datastreamconnexion.com





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Custom Tag Question

2003-03-11 Thread Andre Mohamed
Try something LIKE this inside of your custom tag:

cfset theQuery = caller.#attributes.queryname#

cfoutput query=theQuery
blah blah
/cfoutput


Thanks,

André


-Original Message-
From: John Stanley [mailto:[EMAIL PROTECTED] 
Sent: 11 March 2003 14:29
To: CF-Talk
Subject: Custom Tag Question

I am creating a custom tag that will display the results of a query. I
know
there are already some out there, but I wanna do it myself.

I have an attribute called queryname that i refer to in the call of the
custom tag.

cf_mytag queryname=get_users

inside the custom tag i refer to it as attributes.queryname as in the
following

cfoutput query=#attributes.queryname#
blah blah 
/cfoutput

I keep getting the following error.

Attribute validation error for tag cfoutput.  
The value of the attribute query, which is currently get_users, is
invalid.  
  
The error occurred in C:\CFusionMX\CustomTags\tabledata.cfm: line 20
 
18 :th/thnbsp;/th
19 :  /tr
20 :cfoutput query=#attributes.queryname#
 

I have called the custom tag after the query. Does the custom tag still
execute first? The custom tag appears before the query in debugging.

If so what is a competent work around for this problem.?
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: site wide error handling

2003-03-05 Thread Andre Mohamed
A few additions:

You don't really need the conditional logic around the cferror tag. 

It might be wise to also include a request error handler e.g.

cferror type=request...

Although you are restricted to the number of variables you can use in
this template (and you can't log/mail etc.) it provides a fallback in
case there happens to be an error in your exception handler defined by

cferror type=exception...

And thus you avoid being hosed.

If you want to replace try/catch for queries then the most appropriate
exception type to specify is database e.g.

cferror type=exception exception=database

Naturally, the most logical place to put these tags is in
Application.cfm though, as with cfapplication etc., you are not
restricted to doing so i.e. you can override the exception handler on
any given page as necessary or appropriate.

You also need to be aware that if an error or exception occurs before
you have called cferror e.g. somewhere high up in Application.cfm then
your error handlers won't run.

This contribution is purely for my own benefit as I wanted something to
type.


André

-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: 04 March 2003 18:05
To: CF-Talk
Subject: site wide error handling

Instead of using the try/catch blocks around each query, use a site-wide
error catcher that you set up in the Application.cfm file:

cfif (#CGI.SCRIPT_NAME# NEQ /includes/errorhandler.cfm)
cferror template=/includes/errorhandler.cfm  type=exception
exception=ANY
/cfif

The key is to use the type of exception and exception=any (I think
this came in to either v4.51 or v5).

So if an error is caught, the users is tossed to the errorhandler.cfm
page, where you display a Sorry, error occured or whatever message and
you set the following params:

cfparam name=error.template default=unknown
cfparam name=error.querystring default=unknown
cfparam name=error.remoteaddress default=unknown
cfparam name=error.HTTPreferer default/index.cfm
cfparam name=error.diagnostics default=unknown

You can use the error structure (error.[whatever]) to then send mail to
an admin and/or dump into a database (I do both).

Just make sure to CFPARAM everything that will be called, or you will
get an error in the error-handler page and you'll be hosed.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: New Macromedia.com launched!

2003-03-05 Thread Andre Mohamed
Pity the top toolbar on the home page doesn't work how it's supposed to
:)

Other than that, looks great. I wouldn't like to load it over a modem
though!

-Original Message-
From: Oliver Cookson [mailto:[EMAIL PROTECTED] 
Sent: 05 March 2003 09:45
To: CF-Talk
Subject: New Macromedia.com launched!

Maybe there has already been a post, if not there is now! :)

The new Macromedia.com has been launched and its looks excellent (if a 
little slow in places).

Well done MM.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Andre Mohamed
Ian,

Perhaps I can clarify/expand on what Adam suggested:

1) You do not stop the data entering the database when a story is
submitted. Instead, it is inserted as normal but you also set another
column probably in the same table, perhaps named status with a value
of P for pending when you perform the insert e.g.

insert into stories
(story_id, foo, bar, status)
values
(666,'Foo','Bar','P')

2) Only display stories on the website if the status column is not
P, perhaps only if the status column is A for approved e.g.

select foo, bar
from stories
where status = 'A'

3) When the approver approves a story to be published, the appropriate
row in the database gets updated and the status column is changed
appropriately.

e.g.

update stories
set status = 'A'
where story_id = 666


You could extend this model quite simply to allow for multi-level
approvals and multiple types of status.

It's important to note that this is not a ColdFusion specific problem.
It is merely a programming issue and there is more than one way to skin
a cat.

Thanks,

André


-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 11:02
To: CF-Talk
Subject: Re: Is it possible to achieve workflow in Coldfusion ???

Adam

There is only one administrator or approver.

How would you achieve this, do you have example code so I can see how it
may
function, how do you stop the data entering the database  ??

As part of the submit page, have it save the document away with a flag
'pending'.




- Original Message -
From: Adam Reynolds [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:46 AM
Subject: RE: Is it possible to achieve workflow in Coldfusion ???


 Ian,
 This is relatively simple. As part of the submit page, have it save
the
 document away with a flag 'pending'.

 Is there just one administrator? Do you want different admin for
different
 areas of the site? That is the real pain.

 You could have a pending approval page that admin can go to to see any
 pending pages. They could then view (AND edit) those pages before
accepting
 the content or rejecting the comment.

 Adam

  -Original Message-
  From: Ian Vaughan [mailto:[EMAIL PROTECTED]
  Sent: 03 March 2003 09:38
  To: CF-Talk
  Subject: Is it possible to achieve workflow in Coldfusion ???
 
 
  Hi
 
  I am trying to add a workflow element into a news application, and
would
  just like to hear if anybody else on the list have been able to
achieve
  this? or best practices on how to achieve this?
 
  I have an admin form that allows users to add news stories. At
  present when
  the form is submitted the data is entered into the database table.
 
  What I would like to achieve is when the user submits the form an
  e-mail is
  sent to the relevant approver.  They view their e-mail and click
  on the link
  which opens up their admin screen.
 
  From here they can see they have content to approve.  The approver
reads
  through the story and if they are happy they approve the data and it
is
  entered into the database and goes live on the site.
 
  If the approver declines the story it sends the user who created
  the content
  an e-mail with why the data was not approved and the changes needed
to
be
  made, and the story does not go live on the site.
 
 
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Andre Mohamed
Ian,

I see no flaws the logic you outlined; seems perfectly acceptable to me.
As for adding more features and or more advanced settings, that is
entirely dependent on whether they are justified, required or are likely
to be required - something which only you are in a position to judge at
present. If what you outlined is all that you need then I see no reason
to expand.

It is conceivable, as in other workflow systems, that you may in the
future need more than one level of approval i.e. the article/story may
go through a whole chain of people before it is finally ready to be
published e.g. author - editor - creative/formatting - publisher etc.
however, I don't know if that is appropriate for your circumstances but
it might be worth bearing in mind.

Hope you are successful in your endeavors.

Thanks,

André

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 11:54
To: CF-Talk
Subject: Re: Is it possible to achieve workflow in Coldfusion ???

Andre

Thanks for the explanation!!

Ok I understand how it is working -

A user fills in the fields and clicks submit the data in entered into
the db
with a 'status' field set to a default of 'Pending'

Ok

Then when the form is submitted I use CFMail to send an e-mail to the
approver informing them they have a story to approve. (Is this process
correct ?)

The approver clicks on the link in the e-mail and they are taken to the
'Pending Jobs' Screen.

The approver opens the relevant pending job.

At the bottom of this page there are two buttons 'Approve' and 'Decline'

If the aprrover clicks approve the 'status' field changes to 'approve'

However if the approver clicks decline then the 'status' field stays the
same and an e-mail is sent back to the content owner informing them that
the
content has been declined.

Does this make sense logically ??

Or would you add more features and or more advanced settings??


- Original Message -
From: Andre Mohamed [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 11:24 AM
Subject: RE: Is it possible to achieve workflow in Coldfusion ???


 Ian,

 Perhaps I can clarify/expand on what Adam suggested:

 1) You do not stop the data entering the database when a story is
 submitted. Instead, it is inserted as normal but you also set another
 column probably in the same table, perhaps named status with a value
 of P for pending when you perform the insert e.g.

 insert into stories
 (story_id, foo, bar, status)
 values
 (666,'Foo','Bar','P')

 2) Only display stories on the website if the status column is not
 P, perhaps only if the status column is A for approved e.g.

 select foo, bar
 from stories
 where status = 'A'

 3) When the approver approves a story to be published, the appropriate
 row in the database gets updated and the status column is changed
 appropriately.

 e.g.

 update stories
 set status = 'A'
 where story_id = 666


 You could extend this model quite simply to allow for multi-level
 approvals and multiple types of status.

 It's important to note that this is not a ColdFusion specific problem.
 It is merely a programming issue and there is more than one way to
skin
 a cat.

 Thanks,

 André


 -Original Message-
 From: Ian Vaughan [mailto:[EMAIL PROTECTED]
 Sent: 03 March 2003 11:02
 To: CF-Talk
 Subject: Re: Is it possible to achieve workflow in Coldfusion ???

 Adam

 There is only one administrator or approver.

 How would you achieve this, do you have example code so I can see how
it
 may
 function, how do you stop the data entering the database  ??

 As part of the submit page, have it save the document away with a
flag
 'pending'.




 - Original Message -
 From: Adam Reynolds [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 9:46 AM
 Subject: RE: Is it possible to achieve workflow in Coldfusion ???


  Ian,
  This is relatively simple. As part of the submit page, have it save
 the
  document away with a flag 'pending'.
 
  Is there just one administrator? Do you want different admin for
 different
  areas of the site? That is the real pain.
 
  You could have a pending approval page that admin can go to to see
any
  pending pages. They could then view (AND edit) those pages before
 accepting
  the content or rejecting the comment.
 
  Adam
 
   -Original Message-
   From: Ian Vaughan [mailto:[EMAIL PROTECTED]
   Sent: 03 March 2003 09:38
   To: CF-Talk
   Subject: Is it possible to achieve workflow in Coldfusion ???
  
  
   Hi
  
   I am trying to add a workflow element into a news application, and
 would
   just like to hear if anybody else on the list have been able to
 achieve
   this? or best practices on how to achieve this?
  
   I have an admin form that allows users to add news stories. At
   present when
   the form is submitted the data is entered into the database table.
  
   What I would like to achieve is when the user submits the form an
   e-mail is
   sent

RE: CFMX DSN woes

2003-03-03 Thread Andre Mohamed
Pete,

There is a patch floating around somewhere for CF's administrator which
gives you more meaningful error messages when connecting to data sources
other than the generic JDBC pool error. Search macromedia.com

For SQL Server:

1) Make sure you are using Mixed Mode Authentication (not Windows only).
2) Make sure your password is not more than 16 chars.
3) Do not use (local) as the server.

Hope this helps. Setting up a SQL data source should be a snap.

Thanks,

André

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 15:36
To: CF-Talk
Subject: CFMX DSN woes

I cannot for the life of me configure a DSN in the CF MX Administrator.
I have tried to configure both an Oracle Native DSN (on a remote server)
and an MS SQL Server 2000 DSN (on localhost) and get this error:

Connection verification failed for data source: cm
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password, URL, and other connectivity info.

Interestingly, I get the same error for both the Oracle DSN and the MS
SQL Server DSN.  I have updated the JET and MDAC, and have run Updater
2.  I am running MX Enterprise on localhost running the built-in web
server on port 8500.

Right now, I need to get the SQL Server DSN up and running.  It gives me
this error whether I have the database set up for no security or for a
DB User with appropriate rights, and a userid/password assigned.

I am using the following settings:
DSN: cm
database: cm (this is a database in my local instance of SQL Server)
server: (local)
port: 1433
username: system OR cm (system with only windows security set, cm with
SQL Server auth set)
password: [none] or password

Everything else is default except I have Unicode enabled in the String
Format checkbox and I have CLOB enabled.

Can someone help me?  Oddly, Access DSN's work fine.

Thanks,

Pete

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX Updater 2 to blame?

2003-03-03 Thread Andre Mohamed
Bryan,

Did you try the usual:

1) Make sure you're using mixed mode authentication on SQL server.
2) Make sure your passwords are not more than 16 chars.
3) Make sure you aren't using (local) as the server etc.

Thanks,

André

PS

Good luck with the dating web app!

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 17:59
To: CF-Talk
Subject: CFMX Updater 2 to blame?

Hey All,

I saw a few threads in Google Groups on this, but not enough to solve my
problem (Jochem if you're out thereyou helped someone else with the
same
problem).

I'm able to setup SQL2K datasources using Windows Datasource utility
just
fine, but they don't show in CF Admin.  If I try and add them through CF
Admin I get this:


Connection verification failed for data source: RightStuffDatingDB
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password,
URL, and other connectivity info.
-

The thread I saw referenced a file called jrpatch.jar, but doesn't say
where to get it or what to do with it (although I know it's installed
with
CFMX).

So any help would be great because not being able to add datasources is
a
tad limiting ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Converting a recordset to XML

2003-02-26 Thread Andre Mohamed
Taco,

The original post pointed out that they were still using SQL Server 7.0
which I don't believe has the XML publishing features of SQL Server 2000

Thanks,

André

-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED] 
Sent: 26 February 2003 08:56
To: CF-Talk
Subject: Re: Converting a recordset to XML

If you are using MS SQL you can convert the record set to XML with its
XML
publishing tools..

- Original Message -
From: Andre Mohamed [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 12:50 AM
Subject: RE: Converting a recordset to XML


 Brook,

 If you're going via CF, you could try using WDDX as long as wherever
you
 are sending it to can understand it. You'd this via the cfwddx tags
 passing in a CF variable e.g. a recordset. If converting a recordset
 into XML the quickest and EASIEST way is your MAIN criteria then this
is
 probably the way to go.

 If WDDX isn't what you want then there are a bunch of options,
including
 using a Servlet filters to transform the WDDX XML into another XML
 format if need be but that requires some knowledge of XSLT etc.

 You could also just loop through the recordset and manually create the
 XML document in CF but this probably isn't recommended if the number
of
 rows is large. Naturally, you could also do this inside of a stored
 procedure.

 Thanks,

 André

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: 25 February 2003 14:41
 To: CF-Talk
 Subject: Converting a recordset to XML

 Hello,

 I'm trying to figure out what is the best way to convert a recordset
in
 CFMX to XML. We're still using SQL 7.0, so we can not use the native
XML

 features of SQL Server 2000. Would it make sense to select the data
like
 this:

 Select 'title' + title + ',/title as title
 from movies

 Or is there a better way convert a record set to XML quickly? Are
there
 any
 plugins for SQL Server.

 Brook Davies
 logiforms.com







 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dsn on cfmx - can't create

2003-02-25 Thread Andre Mohamed
Rich,

A couple of things that might help:

1) Make sure you are using Mixed Mode authentication (not Windows only)
on your SQL server DBMS.

2) Make sure your password is not more than 16 chars otherwise it gets
truncated by the CF Administrator App!

3) There is a patch for the CF Administrator (can't find it just now)
which produces more accurate error messages when you are unable to
verify data sources...without the patch you get a generic JDBC Pool
Exception which although correct in some cases is not in others and can
be misleading. You'll have to locate this patch yourself because I'm
supposed to be working right now! (also, not sure if its included in the
updaters)

Thanks,

André

-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED] 
Sent: 25 February 2003 13:27
To: CF-Talk
Subject: dsn on cfmx - can't create

I've checked the archive on this + the forums + the technotes, but
haven't
been able to resolve it.

We cannot add a DSN to a SQL Server 2000 database through CFMX.

we have 2 cfmx machines and 3 sql server machines. 2 of these machines
are
sql server 2000, and 1 is SQL 7.

Each cfmx machine is win2000 with sp3 installed (mdac 2.7 etc). each
install
of cfmx is patched to updater 2. We can't add a DSN either via the type
4
drivers (SQL server) or via an ODBC socket to a DSN setup successfully
to
connect to the a database on a sql2000 machine.

We *can* add type 4 and type 3 DSNs that connect to any SQL server 7
machine.

Oddly, we also have some CF5 machines that can connect to the sql 2000
databases using exactly the same details that were used for the cfmx
machines' DSNs.

All machines have the same firewall configuration.

We also tried adding the ODBC Server service in CFMX to a new security
account in win2000, but this hasn't worked either.

We've now run out of options. Can anyone help?

Many thanks,

---
Rich Wild
Senior Web Developer

---
e-mango Tel: 01202 755 300
Gild House  Fax: 01202 755 301
74 Norwich Avenue West
Bournemouth   Mailto:[EMAIL PROTECTED]
BH2 6AW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Converting a recordset to XML

2003-02-25 Thread Andre Mohamed
Brook,

If you're going via CF, you could try using WDDX as long as wherever you
are sending it to can understand it. You'd this via the cfwddx tags
passing in a CF variable e.g. a recordset. If converting a recordset
into XML the quickest and EASIEST way is your MAIN criteria then this is
probably the way to go. 

If WDDX isn't what you want then there are a bunch of options, including
using a Servlet filters to transform the WDDX XML into another XML
format if need be but that requires some knowledge of XSLT etc.

You could also just loop through the recordset and manually create the
XML document in CF but this probably isn't recommended if the number of
rows is large. Naturally, you could also do this inside of a stored
procedure.

Thanks,

André

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 25 February 2003 14:41
To: CF-Talk
Subject: Converting a recordset to XML

Hello,

I'm trying to figure out what is the best way to convert a recordset in 
CFMX to XML. We're still using SQL 7.0, so we can not use the native XML

features of SQL Server 2000. Would it make sense to select the data like
this:

Select 'title' + title + ',/title as title
from movies

Or is there a better way convert a record set to XML quickly? Are there
any 
plugins for SQL Server.

Brook Davies
logiforms.com



  



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Correct Syntax for this piece of SQL ??

2003-02-25 Thread Andre Mohamed
Just a stab in the dark:

Is orgname always uppercase in your DB? If so, that might explain why
searching by orgname always works but searching by the others doesn't.

You might have to do this:

...AND UPPER(funding) LIKE UPPER('%#Form.funding#%')

or EVEN (the same):

...AND UPPER(funding) LIKE '%#UCase(Form.funding)#%'

etc.

Thanks,

André

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: 25 February 2003 14:49
To: CF-Talk
Subject: Correct Syntax for this piece of SQL ??

Hi

I have the following form which is being used to search against my
database
table.

When I search using the 'orgname' field and there are matches then
results
are returned.  However if I search in the other two fields then it
displays
no results found when it should bring back results ?

Is this because of my sql ??


CFQUERY datasource=liv8 name=funding
cachedwithin=#CreateTimeSpan(0,6,0,0)# blockfactor=100
select * from
funding

Where orgname LIKE UPPER('%#Form.orgname#%')
AND funding LIKE UPPER('%#Form.funding#%')
AND commapproval LIKE UPPER('%#Form.commapproval#%')

ORDER BY recordid
/CFQUERY

This is my search form

form method=POST action=/testpages/fundingresults.cfm
name=search
input type=Hidden name=MaxRows value=100
input type=hidden name=StartRow value=1

font color=#00 face=Verdanaspan class=black10

  p
input type=text class=mini  name=orgname size=22 style=WIDTH:
200pxb Organization Name/b
/p
input type=text class=mini  name=funding size=22 style=WIDTH:
200pxbSource of Funding/b
p
input type=text class=mini  name=commapproval size=22 style=WIDTH:
200pxbCommittee Approval Date/b
/p
p
input type=submit value=Search name=B1nbsp;nbsp;
input type=reset value=Reset Form name=B2
 p
 /form


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: anti-cfflush

2003-02-24 Thread Andre Mohamed
You probably want to refer to the JSP specs here:
http://java.sun.com/products/jsp/download.html#specs

to get the best understanding of full capabilities of the Page Context
object.

Thanks,

André

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: 24 February 2003 15:26
To: CF-Talk
Subject: Re: anti-cfflush

 cfset GetPageContext().getOut().clearBuffer()

i suppose i should know this but what else is hungoff of
getPageContext()?
its kind of lacking in terms of docs.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: anti-cfflush

2003-02-24 Thread Andre Mohamed
More specifically, see here:

http://java.sun.com/j2ee/sdk_1.3/techdocs/api/javax/servlet/jsp/PageCont
ext.html

Thanks,

André

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: 24 February 2003 15:26
To: CF-Talk
Subject: Re: anti-cfflush

 cfset GetPageContext().getOut().clearBuffer()

i suppose i should know this but what else is hungoff of
getPageContext()?
its kind of lacking in terms of docs.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: FBX3 AND CFMX

2003-02-20 Thread Andre Mohamed
One small note with FBX3 and CFMX - just need to make sure that in your
index.cfm you include the CF5 core file (even though you are running on
CFMX)

e.g. cfinclude template=fbx_fusebox30_CF50.cfm

Everything else works same as on 5. 

As for performance, no issues have arisen so far - debugging execution
times can be a little tricky as MX tends to accumulate execution times
into the core file rather than the separate includes and custom tags
that make up the page on some occasions.

André

-Original Message-
From: Adam Reynolds [mailto:[EMAIL PROTECTED]] 
Sent: 20 February 2003 11:37
To: CF-Talk
Subject: RE: FBX3 AND CFMX

Yes.

You deliver code in half the time, can hand it on easily to people,
working
out how to do updates is simpler and can estimate more precisely so you
can
come in under budget.

:)

As to performance issues. Not really had any that I am aware of.


 -Original Message-
 From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
 Sent: 20 February 2003 11:31
 To: CF-Talk
 Subject: RE: FBX3 AND CFMX


 Any performance issues?

 Kola

  -Original Message-
  From: John McCosker [mailto:[EMAIL PROTECTED]]
  Sent: 20 February 2003 11:16
  To: CF-Talk
  Subject: RE: FBX3 AND CFMX
 
  WhHo!!
  Right, lets Migrate this baby.
 
  -Original Message-
  From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
  Sent: 20 February 2003 11:19
  To: CF-Talk
  Subject: RE: FBX3 AND CFMX
 
 
  No problems. Running smoothly.
 
   -Original Message-
   From: John McCosker [mailto:[EMAIL PROTECTED]]
   Sent: 20 February 2003 10:44
   To: CF-Talk
   Subject: FBX3 AND CFMX
  
  
   Hi,
  
   just wondering, is there any issues with FBX3 and MX,
   our will it run fine as it does under 5.0,
  
   I know this is a topica question really, but I'm having problems
   sending to
   the list,
   I am recieving though, strange.
  
   Respectfully,
  
   J
  
 
 

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Should be easy :)

2003-02-20 Thread Andre Mohamed
Specify ONE as your scope.

e.g.

cfset temp = Replace(temp,.,,ONE)

The CF docs are quite comprehensive on tag use.

André

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] 
Sent: 20 February 2003 12:21
To: CF-Talk
Subject: Re: Should be easy :)

Will that not replace ALL periods ?
I just want the first...


On 20/2/03 12:17, Simon Whittaker [EMAIL PROTECTED] wrote:

 say that temp is your variable
 
 cfset temp = Replace(temp,.,)
 
 
 Cheers
 
 Simon
 - Original Message -
 From: Ryan Mitchell [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, February 20, 2003 12:14 PM
 Subject: Should be easy :)
 
 
 This should be an easy one.
 
 How do I remove the first fullstop/period in a string ?
 
 TIA
 Ryan
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Should be easy :)

2003-02-20 Thread Andre Mohamed
Btw...ONE is the default scope for replace!

André

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] 
Sent: 20 February 2003 12:21
To: CF-Talk
Subject: Re: Should be easy :)

Will that not replace ALL periods ?
I just want the first...


On 20/2/03 12:17, Simon Whittaker [EMAIL PROTECTED] wrote:

 say that temp is your variable
 
 cfset temp = Replace(temp,.,)
 
 
 Cheers
 
 Simon
 - Original Message -
 From: Ryan Mitchell [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, February 20, 2003 12:14 PM
 Subject: Should be easy :)
 
 
 This should be an easy one.
 
 How do I remove the first fullstop/period in a string ?
 
 TIA
 Ryan
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: astrological sign

2003-02-20 Thread Andre Mohamed
Luck for me I am a dragonno really :)

André

-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]] 
Sent: 20 February 2003 16:26
To: CF-Talk
Subject: Re: astrological sign

the placemats at the chinese restaurants arent always correct u know!
haha
sure...we all wanna be the dragon:)

i think im a pig

Dave


- Original Message -
From: Ben Arledge [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 10:49 AM
Subject: RE: astrological sign


 Doesn't the Chinese New Year start in late January or early February
 depending on the year? :) I think this script would make me a Snake
 whereas I'm really a Dragon.

 Cheers,
 Ben

 -Original Message-
 From: Dave Lyons [mailto:[EMAIL PROTECTED]]
 Sent: February 20, 2003 12:12 AM
 To: CF-Talk
 Subject: Re: astrological sign


 cfscript
 /**
  * Returns the Chinese Zodiac animal corresponding to the given year
of
 birth.
  *
  * @param    Year (in the format ) you want the Chinese Zodiac
 animal for.
  * @return Returns a string.
  * @author Sierra Bufe ([EMAIL PROTECTED])
  * @version 1, December 3, 2001
  */
 function ChineseZodiac() {
   var Animals =

ListToArray(Monkey,Chicken,Dog,Pig,Mouse,Ox,Tiger,Rabbit,Dragon,Snake,H
 orse
 ,Sheep);
   return Animals[( MOD 12) + 1];
 }
 /cfscript





 Dave

 - Original Message -
 From: Benjamin Rosenthal [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, February 19, 2003 10:47 PM
 Subject: astrological sign


  Took a look at CFLIB but didn't see anything there.
 
  I'm not what you would call a believer so I mistakenly assumed it
  HAD to
 be more complicated than date alone.  Go figure -- who knew figuring
out
 one's personality could be so simple?  ;)
 
  Here are the date ranges if someone wants to go to town.  Yes, I'd
be
 happy if anyone wants to post their UDF. (Michael T., tried to contact
 you but could't see your email anywhere.)
 
  Aries March 21-April 19
  Taurus April 20-May 20
  Gemini May 21-June 21
  Cancer June 22-July 22
  Leo July 23-August 22
  Virgo August 23-September 22
  Libra September 23-October 22
  Scorpio October 23 - November 21
  Sagittarius November 22-December 21
  Capricorn December 22-January 19
  Aquarius January 20-February 18
  Pisces February 19-March 20
 

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: CFTransaction and looping through multiple inserts

2003-02-18 Thread Andre Mohamed
Thane,

No need to have a separate CommitWrite variable. Just do this:

cftransaction!--- Begin is implied ---
cftry
cfloop
...DB Inserts here...
/cfloop
cfcatch type=Database
cftransaction action=rollback/
/cfcatch
/cftry

/cftransaction!--- Commit is implied ---

Provided you want all inserts to be performed or none at all...otherwise
you need to adjust where the loop is etc.

André

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]] 
Sent: 18 February 2003 14:43
To: CF-Talk
Subject: CFTransaction and looping through multiple inserts

I'm entering a series of answers into a table, so I have a loop like
this:

cfloop index=QuestionID list=#Form.SurveyQuestionIDList#
!--- Get the answer. ---
CFSET NumericAnswer=Form[AnswerQuestionID]
!--- Run the query. ---
cfquery datasource=#Datasource# name=InsertSurveyAnswers
INSERT INTO SurveyAnswers(QuestionID,
SurveySubjectID, 
NumericAnswer,  SurveyDate)
VALUES  (#QuestionID#, #Form.SubjectID#, 
#NumericAnswer#,#Form.DateSurveyEntered#)
/cfquery
/CFLOOP

If I want to use CFTransaction, would I set it up like this?

CFSET CommitWrite=True
cftransaction action=begin
cftry
cfloop index=QuestionID list=#Form.SurveyQuestionIDList#
!--- Get the answer. ---
CFSET NumericAnswer=Form[AnswerQuestionID]
!--- Run the query. ---
cfquery datasource=#Datasource#
name=InsertSurveyAnswers
INSERT INTO SurveyAnswers(QuestionID,
SurveySubjectID,NumericAnswer, 
SurveyDate)
VALUES  (#QuestionID#, #Form.SubjectID#,

#NumericAnswer#,#Form.DateSurveyEntered#)
/cfquery
/CFLOOP
cfcatch type='database'
cfset CommitWrite=FALSE
/cfcatch
   /cftry

cfif CommitWrite is 'TRUE'
 cftransaction action='Commit'
   cfelse
 cftransaction action='Rollback'
   /cfif

/cftransaction

Or like this?

CFSET CommitWrite=True
cftransaction action=begin
cfloop index=QuestionID list=#Form.SurveyQuestionIDList#
!--- Get the answer. ---
CFSET NumericAnswer=Form[AnswerQuestionID]
!--- Run the query. ---
cftry
cfquery datasource=#Datasource#
name=InsertSurveyAnswers
INSERT INTO SurveyAnswers(QuestionID,
SurveySubjectID,NumericAnswer, 
SurveyDate)
VALUES  (#QuestionID#, #Form.SubjectID#,

#NumericAnswer#,#Form.DateSurveyEntered#)
/cfquery
cfcatch type='database'
cfset CommitWrite=FALSE
/cfcatch
  /cftry
/CFLOOP


cfif CommitWrite is 'TRUE'
 cftransaction action='Commit'
   cfelse
 cftransaction action='Rollback'
   /cfif

/cftransaction

Or can CFTransaction be used in this situation?

T


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: CFTransaction and looping through multiple inserts

2003-02-18 Thread Andre Mohamed
Doh! That's true! Only need to explicitly rollback for example if there
is something else inside of the transaction tags that is NOT a db query
and hence won't necessarily exit the transaction automatically e.g.

cftransaction
...DB Queries

cf_chargecreditcard
cfif chargeError
cftransaction action=rollback/
/cfif 
/cftransaction

...but...this was not what the original question was so I'll shut up
now!

André

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: 18 February 2003 16:00
To: CF-Talk
Subject: RE: CFTransaction and looping through multiple inserts

 No need to have a separate CommitWrite variable. Just do 
 this:
 
 cftransaction!--- Begin is implied ---
 cftry
   cfloop
   ...DB Inserts here...
   /cfloop
 cfcatch type=Database
   cftransaction action=rollback/
 /cfcatch
 /cftry
 
 /cftransaction!--- Commit is implied ---
 
 Provided you want all inserts to be performed or none at 
 all...otherwise you need to adjust where the loop is etc.

There's no need to have a CFTRY/CFCATCH just to rollback, either - if
any
query fails, the entire transaction will rollback automatically. You
only
need to use ACTION=COMMIT or ACTION=ROLLBACK within a CFTRANSACTION
tag
if you want a partial commit or rollback.

cftransaction
isolation=a_level_that_will_be_safe_for_your_transaction
cfloop
... DB inserts here ...
/cfloop
/cftransaction

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Set HTTP Headers

2003-02-18 Thread Andre Mohamed
Jeff,

You could also do a CFHTTP call to the page you are setting the headers
on. Then cfdump cfhttp.header for the raw response header you get back
from your page or cfdump cfhttp.responseHeader (which is a Structure) or
use cfhttp.responseHeader[testVar] to see if you get testVarValue as
expected etc.

André
-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]] 
Sent: 18 February 2003 16:31
To: CF-Talk
Subject: RE: Set HTTP Headers

Hi Jeff,

 I am working on a project where I need to create a new HTTP Header
variable.
I thought this was what the cfheader tag was for, but I am not being
able to
make it work.  What am I missing here?

cfheader name=testVar value=testVarValue
 -- A header is something you send to the client in the response stream.
So
doing getHTTPRequestDate() like you do below is getting the request
stream
(what the client is sending to you).  If you want to see the headers
you're
sending back to the client, there are a couple tools that plug into IE
that
let you see that kinda thing, or, if you want to get really geeky, break
out
Network Monitor in Windows 2000 and view the TCP/IP packets and filter
for
HTTP data.

AJ

Aaron Johnson
[EMAIL PROTECTED]
http://cephas.net/blog/


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Set HTTP Headers

2003-02-18 Thread Andre Mohamed
Jeff,

Are you trying to read request headers i.e. those set by the browser
when requesting one of your pages, or are you trying to read response
headers set by another server e.g. when you request a resource/page
programmatically via cfhttp?

André

-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]] 
Sent: 18 February 2003 16:42
To: CF-Talk
Subject: RE: Set HTTP Headers

Okay, that makes since.  Now let me explain the problem better.

I am building some functionality to read a set of header variables and
do
some processing on them.  As a test, I was trying to insert certain
values
into the header and then call my functions to make sure they work
correctly.

So basically you are saying that I need to set the header variables and
then
somehow call or go to another page that runs the function in question?

Thanks
-- Jeff


-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 18, 2003 10:31 AM
To: CF-Talk
Subject: RE: Set HTTP Headers


Hi Jeff,

 I am working on a project where I need to create a new HTTP Header
variable.
I thought this was what the cfheader tag was for, but I am not being
able to
make it work.  What am I missing here?

cfheader name=testVar value=testVarValue
 -- A header is something you send to the client in the response stream.
So
doing getHTTPRequestDate() like you do below is getting the request
stream
(what the client is sending to you).  If you want to see the headers
you're
sending back to the client, there are a couple tools that plug into IE
that
let you see that kinda thing, or, if you want to get really geeky, break
out
Network Monitor in Windows 2000 and view the TCP/IP packets and filter
for
HTTP data.

AJ

Aaron Johnson
[EMAIL PROTECTED]
http://cephas.net/blog/



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Set HTTP Headers

2003-02-18 Thread Andre Mohamed
Jeff,

If you want to pass in some test data you need some kind of custom
browser or HTTP client that lets you set some headers when making
requests to your page. There are a few of these around, or you could
write a simple Java/VB app to do it. Alternatively, a load testing tool
(probably overkill) e.g. MS WAS lets you set some headers.

André

-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]] 
Sent: 18 February 2003 16:50
To: CF-Talk
Subject: RE: Set HTTP Headers

The headers that are sent by the browser are all that I am interested in
at
this point.  I am just trying to figure out how to pass in some test
data.

Thanks
-- Jeff

-Original Message-
From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 18, 2003 10:47 AM
To: CF-Talk
Subject: RE: Set HTTP Headers


Jeff,
You might want to try a tool like HTTP Analyzer (www.coolfusion.com) It
will
easily let you see what you are sending down to the browser.
getHTTPRequestData() will only show you what the browser sends you when
it
makes its request.

Matt

-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 18, 2003 11:27 AM
To: CF-Talk
Subject: Set HTTP Headers


I am working on a project where I need to create a new HTTP Header
variable.
I thought this was what the cfheader tag was for, but I am not being
able to
make it work.  What am I missing here?
 
cfheader name=testVar value=testVarValue
 
When I do 
 
cfset x = getHTTPRequestData()
cfdump var=#x#
 
... I do not see the testVar header.
 
Thanks
-- Jeff




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Set HTTP Headers

2003-02-18 Thread Andre Mohamed
Jeff,

It may well be that PlumTree is manipulating the headers before calling
third party  pages but that doesn't necessarily mean it is doing it via
CF code.

You can do v.limited header manipulation using CFHTTP...well, you can
set the user-agent header, and you can set some cookies but other than
that I'm not aware of another way using purely CF.

It is not that difficult to write a CFX or JSP Custom Tag...or indeed
access java.net.URL class to open a connection to port 80 or whatever
and then manually/programmatically create an HTTP request (including the
desired headers) to another resource...well, its not that difficult if
you know some Java, but may be you don't!

As other people have suggested, a quick and dirty way of testing is to
use Telnet and manually create the requests- headers included.

How much work do you want to do?

André

-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]] 
Sent: 18 February 2003 17:43
To: CF-Talk
Subject: RE: Set HTTP Headers

Okay, let me clear this up then, because setting http header variables
can
be done.

I have an instance of a PlumTree portal sitting on a set of production
servers.  I am trying to put together another application that PlumTree
can
be nice and talk to.

Now, PlumTree passes information from the portal itself to third party
applications via the http header.  So somehow the PlumTree portal is
manipulating the http header before it calls my function.

The http header when I receive it (i.e. I can dump the header variables
and
see the values) includes things like ...

CSP-CAN-SET = 'Gadget,User'
CSP-GATEWAY-TYPE = 'PlumTree'
CSP-PROTOCOL-VERSION = '1.1'

My function can then, through the use of getHttpRequestData,
see/read/use
these header values.

I am attempting to test my function on a development box - separate from
the
PlumTree system - and was trying to figure out how to set these
variables
before calling my function - i.e. make it look like PlumTree is doing
the
calling.

Hopefully this is more clear.

Thanks
-- Jeff


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 18, 2003 11:23 AM
To: CF-Talk
Subject: Re: Set HTTP Headers


Jeff Chastain wrote:
 The headers that are sent by the browser are all that I am interested 
 in at this point.  I am just trying to figure out how to pass in some 
 test data.

You need a custom browser for that. Telnet is a nice one ;-)

The reason for this is quite simple actually. Suppose that just any 
website could tell any browser from now on you will send this header, 
with 'this' being a unique identification. Sounds like something the EFF

and the /. crowd would go rather nuts about, wouldn't they?

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: changing mx serial number from developer to professional

2003-02-17 Thread Andre Mohamed
Craig,

Not sure if the license file is in the same location/format on nix
versions of CF but on Win versions the license file is located here:

installation_root\lib\license.properties

e.g.

C:\CFusionMX\lib\license.properties

You might like to try doing a find for this file when you SSH
providing you have permissions for the relevant directory etc.

André

-Original Message-
From: Craig Zingerline [mailto:[EMAIL PROTECTED]] 
Sent: 17 February 2003 19:00
To: CF-Talk
Subject: RE: changing mx serial number from developer to professional

Matt, thanks for the reply.

The problem is that my box is at a co-location provider so I don't have
direct access to the box other than through SSH.  Any ideas?  Thanks!

Craig
UP:Thought

-Original Message-
From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 7:28 AM
To: CF-Talk
Subject: RE: changing mx serial number from developer to professional


Craig:
I believe the developer version will allow connections from the local
box
and one additional IP. Not sure how you are connected to the server, but
are
you able to open a browser on it? If so, you should be able to get into
the
cfadmin from there without worrying about the IP restrictions.

Matt

 -Original Message-
 From: Craig Zingerline [mailto:[EMAIL PROTECTED]]
 Sent: Monday, February 17, 2003 1:04 PM
 To: CF-Talk
 Subject: changing mx serial number from developer to professional


 Hello,
 I have a dedicated Linux box and I installed Coldfusion MX a
 month ago on it
 and was using as the 1 IP development version. Since then I bought MX
 Professional and I want to update my serial number so I have unlimited
 users. However, I cannot log into the administrator because
 my IP is not the
 IP that is allowed by ColdFusion on my server.  Someone else
 must have been
 on the site when the 30 day trial timed out, and their IP is
 locked in.
 I've tried shutting down and restarting ColdFusion to no
 avail. Does anyone
 know how to change the serial number through SSH, or without
 having to be in
 the CF administrator?? Help would be greatly appreciated! Thanks,

 Craig
 Up:Thought




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




  1   2   >