Re: Recommendations for a polling app

[Robert Munn]

Sweet, thanks for pointing that out, Sean.
 
 Something like Ray Camden's Soundings?
 
 http://ray.camdenfamily.com/downloads/soundings.zip
 -- 
 Sean A Corfield -- http://corfield.org/
 Team Fusebox -- http://fusebox.org/
 Got Gmail? -- I have 50, yes 50, invites to give away!
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208164
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Hugo Ahlenius]

|  Let's say you're building a data warehouse -- doubling the
| size of the
|  text columns in the fact tables (from varchar to nvarchar) to make 
|  them unicode as opposed to using the correct character set makes a

To add to Paul's informative post -- with the price of disk space today,
space shouldn't be such a big problem, and with a good RDBMS, it
shouldn't matter (as long as the indexes placed correctly).

/H.
###

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208165
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Logic requried

[Massimo Foti]

  Thanks for reply Jochem, thats exactly what I wanted, but in firefox its
not
  working, and in Java console it says that Security Error: content at
  http:// .cfm may not load or link to file://C:
   Is there anyway to resolve this issue, on some other way, some layer
  concept, which doesn't gives the security error?

 I don't know. I once used this when browsers didn't care about
 security yet but apparently something changed there. I'll see if
 the current maintainer has an answer.

Most recent versions of FireFox and Mozilla will raise a security exception.
It will works fine in IE and Safari.

I think it's quite a shame since this also prevents us to have client-side
image upload validation for those browsers...


Massimo Foti
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208166
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Clustering CFMX 6.1 (J2EE Session Sharing)

[Andy Allan]

Try registering the JRun Admin server of the remote machine also, and
*hopefully* you should be able to now stop/start the remote servers.

Andy

On 5/31/05, Jamie Jackson [EMAIL PROTECTED] wrote:
 I'm trying to cluster CFMX 6.1 on JRun 4, but I'm getting stuck early
 in the process.
 
 I'm trying to register a remote server, but after I input the
 parameters (remote JNDI port, host name, and server name), my server
 appears, as I would expect. However, I would expect the server to be
 running, since it is already running on the remote machine.
 
 When I try to start it remotely (from the JMC), the start (green
 arrow)
 button spawns a JS popup: To start or stop a remote server, another
 running server on the remote host must already be registered with the
 JMC.
 
 It *is* already running on the remote machine.
 
 Can anyone help me get past this one step? If I can get get a remote
 JRun instance registered properly, I think I'll be well on my way to
 J2EE session sharing in CFMX.
 
 Thanks,
 Jamie
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208167
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CFLDAP connection timeout with dead server

[James Holmes]

Through all CFMX versions, including our current CF 6.1 Updater
installation, we have had (and continue to have) trouble with the CFLDAP
connection tag's timeout and error behaviour when the LDAP server is
dead. Instead of providing a connection failed error as soon as it
tries to connect, CF waits (far longer than the maximum request timeout
set either in the CF Admin or in the template with cfsetting) and then
finally errors out. By then it's too late to do anything with the error
as the maximum request timeout has been exceeded and the whole template
errors out.

If the same tag tries to connect to a machine that is up but has no LDAP
server, the correct behaviour occurs (an instant connection failed
error). The problem occurs only if there is no machine at the
destination IP address (i.e. it is down for maintenance).

Has anyone come up with a way around this problem? Has anyone else even
seen it?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208168
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Calvin Ward]

Isn't that a self fulfilling process?

There's more developers for LAMP, therefore you should push/agree to LAMP.
That results in another potential loss of a client to a CFML based solution.

This in turn, results in the corollary argument that There's a much larger
client base for LAMP. I'd consider that a factor in where you spend your
time learning technology.

If indeed it was accurate to say that going with LAMP results in equivalent
applications that are developed and maintained as efficiently and cost
effectively (including software acquisition costs AND development/research
time) as with a CFML centric solution, then I suggest we close this mailing
list and all move over to some PHP/MySQL lists.

I don't really think that is the case though.

I think if the customer really did his homework as you suggested, he might
find that hundreds of thousands of developers, the most mature web
application platform (Remember this is the 10th anniversary of CF), and
record CF sales means that CF is a viable and sustainable investment, backed
by a significant company and in line to be backed by an even more
significant company (combined Adobe/Macromedia). I don't think finding
someone would ever be an issue, there's a good number of CF developers not
employed or looking for additional work all over the country/world.

And finally, the beauty of the CFML solution is its ease of use, even if you
could not find someone already versed in CFML, anyone with any decent web
application skills in any language can easily pick up and work on a CFML
app. Even folks without previous knowledge will make really fast progress on
coming up to speed.

- Calvin

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 31, 2005 6:24 PM
To: CF-Talk
Subject: Re: CF vs LAMP

There's a much larger developer base for LAMP.  I'd consider that a factor 
in selecting the environment - probably even in selecting the developer if 
a developer insists on using a particular environment.

If I were the customer I'd try to do my best to get a feel for the 
environment that the developer is proposing.  They may foresee dropping 
your company (or at least they should keep it in the back of their minds 
as a possibility) and then finding someone to continue site development or 
maintenance may become an issue.  While there are plenty of CF shops out 
there, going with LAMP gives them a lot more options.


- Original Message - 
From: Russ [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, May 31, 2005 11:25 AM
Subject: CF vs LAMP


 We have a client that is trying to decide whether to go with my company 
 or
 another company.  We are a CF/MS SQL shop, and the other company does 
 LAMP
 development (Linux, Apache, MySQL, Perl).

 I was wondering if anyone on this list can give some ideas of the pros 
 and
 cons of using CF/MS SQL vs LAMP.

 I know for a fact that perl code is harder to read and maintain, and 
 that's
 it's probably slower since it's interpreted every time instead of
 pre-compiled as CF is.  I know MS SQL has more features (such as stored
 procs) that MySQL lacks.

 What other pros does CF/MySQL have over LAMP that might sway a potential
 client?  Personally, except for the fact that LAMP is free, I don't see 
 any
 advantages of it at all.




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208169
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Micha Schopman]

I don't think finding someone would ever be an issue, there's a good
number of CF developers not employed or looking for additional work all
over the country/world.

This is definitely not the case. Maybe in the US, but certainly not
everywhere. 

As far as lamp concerned, PHP is a very mature platform, as well as
Apache. There is a lot of ignorance regarding PHP. PHP scales very well,
it runs cross platform, and direct access to resources for development
on the job market are very high. OO development is supported for a long
time, the community is immense, it has tailor made development software,
it has tailor made compression techniques, tailor made template engines,
and very large applications are not an issue. Don't let yourself be
blinded by your CF love, PHP is very much alive as a high end
development platform. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208170
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Keith Gaughan]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dave Watts wrote:

 Yup, and it'll give you the default value for that field. I 
 don't see how this is a criticism.
 
 You're kidding, right? That defeats the entire purpose of NULL. How would
 you differentiate between default values and NULLs?

I think that more points to a flaw in the concept of NULLs in SQL
(which, as it happens, is one of the most criticised aspects of the
language) than a flaw in MySQL per-se.

The real problem is that NULL is seriously overloaded in SQL. I wasn't
defending MySQL's behaviour--though I can see how you could infer
that--just pointing out that the real problem is elsewhere.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCnaDdmSWF0pzlQ04RAufZAJ9kTRt9nBg3rbHKyQ3tKbT/I8xAiACgpi7Z
gwq/w3bsPZ0nIAOOqT7B/QU=
=zucO
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208171
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Calvin Ward]

What I am observing is an increasing number of participants on this list (CF
list) advocating PHP instead of CF, without even the benefit of knowing the
total requirements of a given project. 

Which potentially results in the self fulfilling process that was the point
of my previous communication.

Is PHP a better, more cost effective solution? If so, we are wasting our
time here and need to move on.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 7:35 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I don't think finding someone would ever be an issue, there's a good
number of CF developers not employed or looking for additional work all
over the country/world.

This is definitely not the case. Maybe in the US, but certainly not
everywhere. 

As far as lamp concerned, PHP is a very mature platform, as well as
Apache. There is a lot of ignorance regarding PHP. PHP scales very well,
it runs cross platform, and direct access to resources for development
on the job market are very high. OO development is supported for a long
time, the community is immense, it has tailor made development software,
it has tailor made compression techniques, tailor made template engines,
and very large applications are not an issue. Don't let yourself be
blinded by your CF love, PHP is very much alive as a high end
development platform. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208172
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Micha Schopman]

Calvin,

As always, it not always depends on the requirements for a project, but
also on the strategy of business regarding sales, communication,
partnerships, certifications, etc.

Like others, we are not advocating, we are merely observing. We like CF,
we like PHP, we like Python, we like ASP.NET, we like everything which
we can build cool applications with. My cats have not been called cfdump
and cferror, and my personal library is full of books about a wide
variety of languages, software design. I need to, there aren't that many
CF books to fill room with. If the discussion involved ASP 3.0 I would
have said you are totally right. ;)

Do not take offence when people say good things about bad languages,
the goodness of them might depend on opinions. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 


-

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: woensdag 1 juni 2005 12:51
To: CF-Talk
Subject: RE: CF vs LAMP

What I am observing is an increasing number of participants on this list
(CF
list) advocating PHP instead of CF, without even the benefit of knowing
the
total requirements of a given project. 

Which potentially results in the self fulfilling process that was the
point
of my previous communication.

Is PHP a better, more cost effective solution? If so, we are wasting our
time here and need to move on.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 7:35 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I don't think finding someone would ever be an issue, there's a good
number of CF developers not employed or looking for additional work all
over the country/world.

This is definitely not the case. Maybe in the US, but certainly not
everywhere. 

As far as lamp concerned, PHP is a very mature platform, as well as
Apache. There is a lot of ignorance regarding PHP. PHP scales very well,
it runs cross platform, and direct access to resources for development
on the job market are very high. OO development is supported for a long
time, the community is immense, it has tailor made development software,
it has tailor made compression techniques, tailor made template engines,
and very large applications are not an issue. Don't let yourself be
blinded by your CF love, PHP is very much alive as a high end
development platform. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208173
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Scott Stroz]

I thought LAMP was Linux, Apache, MySQL and PHP?

On 5/31/05, Russ [EMAIL PROTECTED] wrote:
 
 We have a client that is trying to decide whether to go with my company or
 another company. We are a CF/MS SQL shop, and the other company does LAMP
 development (Linux, Apache, MySQL, Perl).
 
 
 
 I was wondering if anyone on this list can give some ideas of the pros and
 cons of using CF/MS SQL vs LAMP.
 
 
 
 I know for a fact that perl code is harder to read and maintain, and 
 that's
 it's probably slower since it's interpreted every time instead of
 pre-compiled as CF is. I know MS SQL has more features (such as stored
 procs) that MySQL lacks.
 
 
 
 What other pros does CF/MySQL have over LAMP that might sway a potential
 client? Personally, except for the fact that LAMP is free, I don't see any
 advantages of it at all.
 
 
 
 Thanks,
 
 
 
 Russ
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208174
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Calvin Ward]

I'm certainly not taking offense, I'm observing a pattern of behavour.

We also aren't entirely cognizant of the business strategy regarding the
below items either.

In this particular case, the OP requested ammunition to assist in overcoming
a potential LAMP bias in providing a solution.

A significant response has said that LAMP is the better solution based on a
number of generalities, that in theory, always hold true (such as number of
available developers).

And that begs the question, why bother with an inferior solution, if indeed
that is the case.

Is PHP in general a better solution than CF?

That's the underlying theme that I'm observing, that in some folk's opinions
on this list, it is.

Interesting, if my observation is true, as this is a CF list.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 8:04 AM
To: CF-Talk
Subject: RE: CF vs LAMP

Calvin,

As always, it not always depends on the requirements for a project, but
also on the strategy of business regarding sales, communication,
partnerships, certifications, etc.

Like others, we are not advocating, we are merely observing. We like CF,
we like PHP, we like Python, we like ASP.NET, we like everything which
we can build cool applications with. My cats have not been called cfdump
and cferror, and my personal library is full of books about a wide
variety of languages, software design. I need to, there aren't that many
CF books to fill room with. If the discussion involved ASP 3.0 I would
have said you are totally right. ;)

Do not take offence when people say good things about bad languages,
the goodness of them might depend on opinions. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 


-

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: woensdag 1 juni 2005 12:51
To: CF-Talk
Subject: RE: CF vs LAMP

What I am observing is an increasing number of participants on this list
(CF
list) advocating PHP instead of CF, without even the benefit of knowing
the
total requirements of a given project. 

Which potentially results in the self fulfilling process that was the
point
of my previous communication.

Is PHP a better, more cost effective solution? If so, we are wasting our
time here and need to move on.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 7:35 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I don't think finding someone would ever be an issue, there's a good
number of CF developers not employed or looking for additional work all
over the country/world.

This is definitely not the case. Maybe in the US, but certainly not
everywhere. 

As far as lamp concerned, PHP is a very mature platform, as well as
Apache. There is a lot of ignorance regarding PHP. PHP scales very well,
it runs cross platform, and direct access to resources for development
on the job market are very high. OO development is supported for a long
time, the community is immense, it has tailor made development software,
it has tailor made compression techniques, tailor made template engines,
and very large applications are not an issue. Don't let yourself be
blinded by your CF love, PHP is very much alive as a high end
development platform. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 









~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208176
Archives: 

RE: CF vs LAMP

[Robertson-Ravo, Neil (RX)]

 I believe LAMP on Windows is called WAMP.



-Original Message-
From: Scott Stroz [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 13:11
To: CF-Talk
Subject: Re: CF vs LAMP

I thought LAMP was Linux, Apache, MySQL and PHP?

On 5/31/05, Russ [EMAIL PROTECTED] wrote:
 
 We have a client that is trying to decide whether to go with my company or
 another company. We are a CF/MS SQL shop, and the other company does LAMP
 development (Linux, Apache, MySQL, Perl).
 
 
 
 I was wondering if anyone on this list can give some ideas of the pros and
 cons of using CF/MS SQL vs LAMP.
 
 
 
 I know for a fact that perl code is harder to read and maintain, and 
 that's
 it's probably slower since it's interpreted every time instead of
 pre-compiled as CF is. I know MS SQL has more features (such as stored
 procs) that MySQL lacks.
 
 
 
 What other pros does CF/MySQL have over LAMP that might sway a potential
 client? Personally, except for the fact that LAMP is free, I don't see any
 advantages of it at all.
 
 
 
 Thanks,
 
 
 
 Russ
 
 
 
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208175
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Matthew Small]

Does belonging to this list infer that I believe CF is the best web
programming language?  I hope not, and there are many reasons to use CF
beside the fact that it's the best.

 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 8:15 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I'm certainly not taking offense, I'm observing a pattern of behavour.

We also aren't entirely cognizant of the business strategy regarding the
below items either.

In this particular case, the OP requested ammunition to assist in overcoming
a potential LAMP bias in providing a solution.

A significant response has said that LAMP is the better solution based on a
number of generalities, that in theory, always hold true (such as number of
available developers).

And that begs the question, why bother with an inferior solution, if indeed
that is the case.

Is PHP in general a better solution than CF?

That's the underlying theme that I'm observing, that in some folk's opinions
on this list, it is.

Interesting, if my observation is true, as this is a CF list.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 8:04 AM
To: CF-Talk
Subject: RE: CF vs LAMP

Calvin,

As always, it not always depends on the requirements for a project, but
also on the strategy of business regarding sales, communication,
partnerships, certifications, etc.

Like others, we are not advocating, we are merely observing. We like CF,
we like PHP, we like Python, we like ASP.NET, we like everything which
we can build cool applications with. My cats have not been called cfdump
and cferror, and my personal library is full of books about a wide
variety of languages, software design. I need to, there aren't that many
CF books to fill room with. If the discussion involved ASP 3.0 I would
have said you are totally right. ;)

Do not take offence when people say good things about bad languages,
the goodness of them might depend on opinions. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 


-

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: woensdag 1 juni 2005 12:51
To: CF-Talk
Subject: RE: CF vs LAMP

What I am observing is an increasing number of participants on this list
(CF
list) advocating PHP instead of CF, without even the benefit of knowing
the
total requirements of a given project. 

Which potentially results in the self fulfilling process that was the
point
of my previous communication.

Is PHP a better, more cost effective solution? If so, we are wasting our
time here and need to move on.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 7:35 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I don't think finding someone would ever be an issue, there's a good
number of CF developers not employed or looking for additional work all
over the country/world.

This is definitely not the case. Maybe in the US, but certainly not
everywhere. 

As far as lamp concerned, PHP is a very mature platform, as well as
Apache. There is a lot of ignorance regarding PHP. PHP scales very well,
it runs cross platform, and direct access to resources for development
on the job market are very high. OO development is supported for a long
time, the community is immense, it has tailor made development software,
it has tailor made compression techniques, tailor made template engines,
and very large applications are not an issue. Don't let yourself be
blinded by your CF love, PHP is very much alive as a high end
development platform. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 

RE: CF vs LAMP

[Robertson-Ravo, Neil (RX)]

No, indeed it doesn'tin fact if you are using another technology as well
as CF - kudos to you ;-p



-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 13:21
To: CF-Talk
Subject: RE: CF vs LAMP

Does belonging to this list infer that I believe CF is the best web
programming language?  I hope not, and there are many reasons to use CF
beside the fact that it's the best.

 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 8:15 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I'm certainly not taking offense, I'm observing a pattern of behavour.

We also aren't entirely cognizant of the business strategy regarding the
below items either.

In this particular case, the OP requested ammunition to assist in overcoming
a potential LAMP bias in providing a solution.

A significant response has said that LAMP is the better solution based on a
number of generalities, that in theory, always hold true (such as number of
available developers).

And that begs the question, why bother with an inferior solution, if indeed
that is the case.

Is PHP in general a better solution than CF?

That's the underlying theme that I'm observing, that in some folk's opinions
on this list, it is.

Interesting, if my observation is true, as this is a CF list.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 8:04 AM
To: CF-Talk
Subject: RE: CF vs LAMP

Calvin,

As always, it not always depends on the requirements for a project, but
also on the strategy of business regarding sales, communication,
partnerships, certifications, etc.

Like others, we are not advocating, we are merely observing. We like CF,
we like PHP, we like Python, we like ASP.NET, we like everything which
we can build cool applications with. My cats have not been called cfdump
and cferror, and my personal library is full of books about a wide
variety of languages, software design. I need to, there aren't that many
CF books to fill room with. If the discussion involved ASP 3.0 I would
have said you are totally right. ;)

Do not take offence when people say good things about bad languages,
the goodness of them might depend on opinions. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 
Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer
informatie zie www.modernmedia.nl 


-

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: woensdag 1 juni 2005 12:51
To: CF-Talk
Subject: RE: CF vs LAMP

What I am observing is an increasing number of participants on this list
(CF
list) advocating PHP instead of CF, without even the benefit of knowing
the
total requirements of a given project. 

Which potentially results in the self fulfilling process that was the
point
of my previous communication.

Is PHP a better, more cost effective solution? If so, we are wasting our
time here and need to move on.

- Calvin

-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 7:35 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I don't think finding someone would ever be an issue, there's a good
number of CF developers not employed or looking for additional work all
over the country/world.

This is definitely not the case. Maybe in the US, but certainly not
everywhere. 

As far as lamp concerned, PHP is a very mature platform, as well as
Apache. There is a lot of ignorance regarding PHP. PHP scales very well,
it runs cross platform, and direct access to resources for development
on the job market are very high. OO development is supported for a long
time, the community is immense, it has tailor made development software,
it has tailor made compression techniques, tailor made template engines,
and very large applications are not an issue. Don't let yourself be
blinded by your CF love, PHP is very much alive as a high end
development platform. :)

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



-
Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren
de interactie met uw doelgroep. 

Re: CF vs LAMP

[Jochem van Dieten]

Keith Gaughan wrote:
 Dave Watts wrote:
 
 Yup, and it'll give you the default value for that field. I 
 don't see how this is a criticism.
 
 You're kidding, right? That defeats the entire purpose of NULL. How would
 you differentiate between default values and NULLs?
 
 I think that more points to a flaw in the concept of NULLs in SQL
 (which, as it happens, is one of the most criticised aspects of the
 language) than a flaw in MySQL per-se.
 
 The real problem is that NULL is seriously overloaded in SQL.

And the MySQL behaviour, whichs replaces NULL with the default 
value so the default value gets even worse overloaded then NULL 
is, helps?

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208179
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Robertson-Ravo, Neil (RX)]

No, indeed it doesn'tin fact if you are using another technology as well
as CF - kudos to you ;-p

-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 13:21
To: CF-Talk
Subject: RE: CF vs LAMP

Does belonging to this list infer that I believe CF is the best web
programming language?  I hope not, and there are many reasons to use CF
beside the fact that it's the best.

 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 8:15 AM
To: CF-Talk
Subject: RE: CF vs LAMP

I'm certainly not taking offense, I'm observing a pattern of behavour.

We also aren't entirely cognizant of the business strategy regarding the
below items either.

In this particular case, the OP requested ammunition to assist in overcoming
a potential LAMP bi
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208180
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Micha Schopman]

Is PHP in general a better solution than CF?

It depends on how the end user experiences it. On some points I think CF
excels and the same goes for PHP. Looking at things like cfgraph, report
builder, event gateway, those are all things you do not find in PHP.
There are possible yes, but requires you to buy separate components.
That is why CF still has its community, the full featureset.

If you look at coding style (c++ / ecma script alike), amount of
functions, and performance I do like PHP very much. Combined with ZEND,
PHP is very powerful and executing algorithms like Levensthein on PHP
takes place in milliseconds, whereas CF takes seconds and seconds on the
same box.

It is just where you are used to.

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208181
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

SFCommerce? Payment gateway? Stacy, are you around?

[Tony Weeg]

need a payment gateway for a new application for my wife

www.mydinnercompany.com

Stacy (Young?) still around?

thanks.

-- 
tony

Tony Weeg

macromedia certified coldfusion mx developer
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
cool tool: http://www.antiwrap.com

...straight cash homey
- randy moss, now a raider

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208182
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Flash SEO

[Robert Everland III]

We have been doing a lot of flash sites with very minimal HTML content. One of 
the things we have done is create a text only website so that we can have our 
sites indexed by search engines. The only issue with doing this is that the 
search engine indexes the text only site instead of my actual site. I have been 
toying with the idea of hiding the content inside my page where my flash is so 
that when a search engine spiders my site I have the plain text version of that 
site indexed, but when they click on it they are able to go to the site with 
the flash on it. Has anyone done anything like this or though about doing 
something like this?



Bob

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208183
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[John Paul Ashenfelter]

On 5/31/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
  What's the example of the situation you NULL issue -- a simple SQL
  example would help me figure out exactly what situation you're talking
  about.
 
 Simple...and there is no SQL behind it..the DB screwed the data

 Took over  a project using MySQL 4.1.x.  In trying to import the DB into
 MS-SQL 2000 I found errors which related to NULL values being in NOT NULL
 constrained columns.  So MS-SQL correctly found the constraint and would not
 allow the bad entries to be imported ;-)

There are scenarios where the same thing happens in MS-SQL. You can do
just about anything to a column constraint if you add it *after* data
is in the table using ALTER TABLE  WITH NOCHECK for example. If
the DBA is screwing up the data, there's not a lot *any* database can
do to help -- a constraint only works if it's in effect when the data
is being entered, which is definitely the case on a bulk import.

MySQL wouldn't import that data by default either :)

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208184
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Import/Export for PostgreSQL

[George Abraham]

All,
Anyone have a suggestion for a (preferably free) Import/Export tool
for PostgreSQL? I have to import/export from MS SQL Server and using
MS' DTS does not seem to be working due to this bug:
http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944

Thanks,
George

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208185
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[John Paul Ashenfelter]

On 5/31/05, Robert Munn [EMAIL PROTECTED] wrote:
 Hold on, now. Java is not exactly open source, is it? Don't they still call 
 it Community Source rather than open source? In other words, Java belongs 
 to Sun. You can't just go out and start offering your own Java, a la 
 Microsoft J++.

Ok, clarification is in order. I'm talking about open-source *Java
tools* -- things like Tomcat, Eclipse, Lucene, Log4J, Ant, etc.

And actually, Sun's Java *is* open source (the source comes bundled
with it in a complete installation). You're confusing open source and
licensing. Open source means, well, that the source is open
(available). It doesn't mean that someone doesn't own the software. It
doesn't mean it's free. It doesn't mean it doesn't have restrictions.
It simply means the source is available.

The Open Source Initiative (http://www.opensource.org/) manages and
certifies/approves the various open source licenses, of which the BSD,
Apache, and GPL licenses are the most common. Most arguments about
whether a project is truly open source are really about the
licensing model -- which is where Sun is with both Java and the new
OpenSolaris project.

Believe it or not, you can create your own Java. The Apache project is
sponsoring Harmony
(http://www.eweek.com/article2/0,1759,1814639,00.asp?kc=ewnws051105dtx1k599
or  http://developers.slashdot.org/article.pl?sid=05/05/15/2036234 for
example) which is an open source J2SE implementation. This is similar
to the Apache Geronimo project which is a J2EE server (like the open
source JBoss). The reason for both of these projects is to have a Java
implementation (J2SE and J2EE respectively) that is licensed using the
Apache license instead of the Sun licenses (J2SE) or the various
commercial licenses and the LGPL-licensed JBoss.
 
 shameless_plug
 I'll be talking about open source, especially Java, at CF-United. If
 you're attending, you might think about coming.
 /shameless_plug
 

Hey, I'll think we'll have to add a BOF on open source to CF-United as well :)

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208186
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[John Paul Ashenfelter]

On 5/31/05, Dave Watts [EMAIL PROTECTED] wrote:
  Ironically, it's also barely even germane since you can easily run
  the CF/MS-SQL combination with Apache. Or the MP part of the stack on
  Windows, at least as long as P is Perl or PHP (I can't speak to
  Python).
 
 You can certainly run Python on Windows. The ActiveState distribution
 provides an ISAPI module too, I think.

They sure did last I looked. (as they also provide an ISAPI for Perl).
Plus there's the obligatory mod_python.

I just don't like to speak too far outside my expertise -- I'm just
not a Python guy :)
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208187
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Joe Rinehart]

Hey Adrian,

 cfif form.foo IS 
 cfqueryparam value= cfsqltype=CF_SQL_VARCHAR null=Yes
 cfelse
 cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR 
 maxlength=20
 /cfif
 

Can probably be written:

NULLIF(cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
maxlength=20, '')

Cheers,

Joe

-- 
Get Glued!
The Model-Glue ColdFusion Framework
http://www.model-glue.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208188
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Damien McKenna]

 Can probably be written:
 NULLIF(cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
 maxlength=20, '')

Or better yet:
cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
maxlength=20 null=#yesNoFormat(form.foo IS ''#) /

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Charlie Griefer]

or 
cfqueryparam value=#form.foo# cfsqltype=cf_sql_varchar
null=#yesNoFormat(NOT len(trim(form.foo)))#

(if the null attribute evaluates to YES, it overrides whatever is
provided for the value attribute)

On 6/1/05, Joe Rinehart [EMAIL PROTECTED] wrote:
 Hey Adrian,
 
  cfif form.foo IS 
  cfqueryparam value= cfsqltype=CF_SQL_VARCHAR null=Yes
  cfelse
  cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR 
  maxlength=20
  /cfif
 
 
 Can probably be written:
 
 NULLIF(cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
 maxlength=20, '')
 
 Cheers,
 
 Joe
 
 --
 Get Glued!
 The Model-Glue ColdFusion Framework
 http://www.model-glue.com
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208190
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[John Paul Ashenfelter]

On 6/1/05, Hugo Ahlenius [EMAIL PROTECTED] wrote:
 |  Let's say you're building a data warehouse -- doubling the
 | size of the
 |  text columns in the fact tables (from varchar to nvarchar) to make
 |  them unicode as opposed to using the correct character set makes a
 
 To add to Paul's informative post -- with the price of disk space today,
 space shouldn't be such a big problem, and with a good RDBMS, it
 shouldn't matter (as long as the indexes placed correctly).

In a data warehouse, disk space *does* become an issue. Managing 2-8TB
is not all that easy. Indexes on the text field become correspondingly
larger as well. The math's not all that hard -- take 8 billion rows
(Cox Cable's MySQL customer database for example) and double the size
of a varchar(10) by making it nvarchar(10). Add in the increased size
on the index. A fair number of extra disks to buy...

And while disk space is *relatively* cheap, it gets worse from there
from a performance perspective -- the change will half the number of
pages the database can load into memory, which in the worst case
doubles the disk I/0 or requires double the memory. It halves the load
speed for disk I/O since the same record is twice as long. You start
adding up the performance degredation on a datawarehouse that operates
on billions of rows and ironically the bytes become important.

Similar things happen for MS-SQL or any database platform. Data
warehouses are a different animal from OLTP systems.

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208191
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLDAP connection timeout with dead server

[Douglas Knudsen]

have not seen that issue, we do have issues with CFLDAP under load though, 
it flakes out. I'm writing a Java POJO right now to replace it, this might 
help your situation also, dunno. After I get it working and tested I'll 
release it around here. 
 I do see this issue with cfquery though. If the DB server is down, in my 
case if the TNS listner is not listening, the tag gets all hung up. This is 
something I really wish they would get working better, wished this since 
like version 4. Luckly its a very rare case that our phat Oracle box has 
issues.
 DK

 On 6/1/05, James Holmes [EMAIL PROTECTED] wrote: 
 
 Through all CFMX versions, including our current CF 6.1 Updater
 installation, we have had (and continue to have) trouble with the CFLDAP
 connection tag's timeout and error behaviour when the LDAP server is
 dead. Instead of providing a connection failed error as soon as it
 tries to connect, CF waits (far longer than the maximum request timeout
 set either in the CF Admin or in the template with cfsetting) and then
 finally errors out. By then it's too late to do anything with the error
 as the maximum request timeout has been exceeded and the whole template
 errors out.
 
 If the same tag tries to connect to a machine that is up but has no LDAP
 server, the correct behaviour occurs (an instant connection failed
 error). The problem occurs only if there is no machine at the
 destination IP address (i.e. it is down for maintenance).
 
 Has anyone come up with a way around this problem? Has anyone else even
 seen it?
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208192
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Import/Export for PostgreSQL

[Mark Smyth]

I've used some of these before, very good and easy to setup/use
http://www.sqlmanager.net/products/postgresql

Not free, but you do get a free trial

Hth
mark 

-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 14:51
To: CF-Talk
Subject: OT: Import/Export for PostgreSQL

All,
Anyone have a suggestion for a (preferably free) Import/Export tool for
PostgreSQL? I have to import/export from MS SQL Server and using MS' DTS
does not seem to be working due to this bug:
http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944

Thanks,
George



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208193
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[John Paul Ashenfelter]

On 5/31/05, Dave Watts [EMAIL PROTECTED] wrote:
  Hold on, now. Java is not exactly open source, is it? Don't
  they still call it Community Source rather than open
  source? In other words, Java belongs to Sun. You can't just
  go out and start offering your own Java, a la Microsoft J++.
 
 I suspect that John is referring to all the third-party Java stuff like the
 Apache project has, which is open-source.

Thanks -- right you are. Ant, Lucene, plus non-Java tools like
Subversion are on the list. And I *won't* be talking about Apache
Harmony (the Apache J2SE clone).

The recent Richard Stallman stance (speaking out on Java in OpenOffice
2.0) that a project isn't really good open source if it has
dependencies that are not open source (ie Sun's Java) is really even a
little extreme for the bulk of the open source community. Just like
folks happily use the open source CFlib.org functions (one of CF's
biggest open source options, along with Fusebox, MachII, and FarCry)
despite the fact that they require a non-open platform (CF) to run,
I'm going to not get bent out of shape about Java being a dependency
for many of the tools I use :)
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208194
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Keith Gaughan]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Joe Rinehart wrote:

 Can probably be written:
 
 NULLIF(cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
 maxlength=20, '')

Or even:

cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#FORM.foo#
 null=#(FORM.foo eq '')#
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCncLfmSWF0pzlQ04RAmwWAKCi96L7LVanD2BKb437ZXrdHW1cJwCcDQoq
jh+mbzST+hW03/82kpaJqEc=
=x+Is
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208195
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfc confused

[Johnny Le]

So even when I use user.getAddress().getCity(), user.getAddress().getState(), 
user.getAddress().getZip(), I didn't make three separate calls to the database, 
just one?  That's great.


The answer to your second question about the address is to use composition 
and have the User object hold a reference to an Address object. So you are 
on track there. But you don't have to execute a query when you call 
getAddress(), the Address object is already there and populated (at the same 
time the User object is created) so you're just getting the state of the 
Address object by calling methods on it. Basically you don't need to run any 
queries beyond the first one that you use when you initialize the Address 
object.

Hope that helps.

Brian



On 6/1/05, Johnny Le [EMAIL PROTECTED] wrote:


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208196
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Import/Export for PostgreSQL

[Rob]

It's kind of a pain, and very slow with lots of data, but you can make
sql server generate sql for the schemas (you'll have to tweak the
sql a bit for it to work in postgres). You can then export the data
into sql statements using the all tasksexport data function in mssql,
and then run the script on postgres.

Very manual, very tedious, but I've done it before and it's worked. 

If you're going from postgres to mssql look at pgdump (man pgdump)

There is more than likely something better out there, but if it comes
down to it you can do it that way.

On 6/1/05, George Abraham [EMAIL PROTECTED] wrote:
 All,
 Anyone have a suggestion for a (preferably free) Import/Export tool
 for PostgreSQL? I have to import/export from MS SQL Server and using
 MS' DTS does not seem to be working due to this bug:
 http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944
 
 Thanks,
 George
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208197
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Import/Export for PostgreSQL

[George Abraham]

Mark,
Thanks for the suggestion, but none of them seem to have anything for
SQL Server.

George

On 6/1/05, Mark Smyth [EMAIL PROTECTED] wrote:
 I've used some of these before, very good and easy to setup/use
 http://www.sqlmanager.net/products/postgresql
 
 Not free, but you do get a free trial
 
 Hth
 mark
 
 -Original Message-
 From: George Abraham [mailto:[EMAIL PROTECTED]
 Sent: 01 June 2005 14:51
 To: CF-Talk
 Subject: OT: Import/Export for PostgreSQL
 
 All,
 Anyone have a suggestion for a (preferably free) Import/Export tool for
 PostgreSQL? I have to import/export from MS SQL Server and using MS' DTS
 does not seem to be working due to this bug:
 http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944
 
 Thanks,
 George
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208198
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Joe Rinehart]

Sorry, I should've pointed out that alternative - I think it comes
down to personal preference?

-Joe

On 6/1/05, Charlie Griefer [EMAIL PROTECTED] wrote:
 or
 cfqueryparam value=#form.foo# cfsqltype=cf_sql_varchar
 null=#yesNoFormat(NOT len(trim(form.foo)))#
 
 (if the null attribute evaluates to YES, it overrides whatever is
 provided for the value attribute)
 
 On 6/1/05, Joe Rinehart [EMAIL PROTECTED] wrote:
  Hey Adrian,
 
   cfif form.foo IS 
   cfqueryparam value= cfsqltype=CF_SQL_VARCHAR null=Yes
   cfelse
   cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR 
   maxlength=20
   /cfif
  
 
  Can probably be written:
 
  NULLIF(cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
  maxlength=20, '')
 
  Cheers,
 
  Joe
 
  --
  Get Glued!
  The Model-Glue ColdFusion Framework
  http://www.model-glue.com
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208199
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Dave Watts]

 Sorry, I should've pointed out that alternative - I think it 
 comes down to personal preference?

I would recommend the use of the NULL attribute of CFQUERYPARAM over the
NULLIF database function if for portability reasons.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208200
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Problems?

[James Holmes]

Is the list having problems at the moment? Posts are sporadically
arriving in batches and the post I just did at HOF didn't show up
online.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208201
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfc confused

[Dawson, Michael]

The way I understand Sean, you will need to make only two database
calls: 1. to get the master data.  2. To get all of the addresses.

M!ke 

-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 9:18 AM
To: CF-Talk
Subject: Re: cfc confused

So even when I use user.getAddress().getCity(),
user.getAddress().getState(), user.getAddress().getZip(), I didn't make
three separate calls to the database, just one?  That's great.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208202
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Dave Watts]

 I think that more points to a flaw in the concept of NULLs in SQL
 (which, as it happens, is one of the most criticised aspects of the
 language) than a flaw in MySQL per-se.

It's one thing to observe a flaw in a language. It's another to use that
flaw as justification for an application's failure to conform to that
language. I don't see at all how one has to do with the other.

On an unrelated note, I noticed that I can see better out of my right eye
than my left eye. So, to improve my driving, I started driving on the left
side of the road instead of the right side. I'm sure that will be a great
improvement.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208203
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Robertson-Ravo, Neil (RX)]

LOL..

You would be fine in the UK



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 15:53
To: CF-Talk
Subject: RE: CF vs LAMP

 I think that more points to a flaw in the concept of NULLs in SQL
 (which, as it happens, is one of the most criticised aspects of the
 language) than a flaw in MySQL per-se.

It's one thing to observe a flaw in a language. It's another to use that
flaw as justification for an application's failure to conform to that
language. I don't see at all how one has to do with the other.

On an unrelated note, I noticed that I can see better out of my right eye
than my left eye. So, to improve my driving, I started driving on the left
side of the road instead of the right side. I'm sure that will be a great
improvement.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208204
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Michael T. Tangorre]

 From: Dave Watts [mailto:[EMAIL PROTECTED] 
 On an unrelated note, I noticed that I can see better out of 
 my right eye than my left eye. So, to improve my driving, I 
 started driving on the left side of the road instead of the 
 right side. I'm sure that will be a great improvement.

Dave,

Please conform to the Dupont Circle rules of driving which clearly state
that both eyes must be closed! If you want to drive with one eye please
relocate to Rockville. :-)




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208205
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Import/Export for PostgreSQL

[Mark Smyth]

Yeah just relaised,

But if dts is the problem, dts to csv or access (for example), then the
import tools will work fine 

-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 15:23
To: CF-Talk
Subject: Re: Import/Export for PostgreSQL

Mark,
Thanks for the suggestion, but none of them seem to have anything for SQL
Server.

George

On 6/1/05, Mark Smyth [EMAIL PROTECTED] wrote:
 I've used some of these before, very good and easy to setup/use 
 http://www.sqlmanager.net/products/postgresql
 
 Not free, but you do get a free trial
 
 Hth
 mark
 
 -Original Message-
 From: George Abraham [mailto:[EMAIL PROTECTED]
 Sent: 01 June 2005 14:51
 To: CF-Talk
 Subject: OT: Import/Export for PostgreSQL
 
 All,
 Anyone have a suggestion for a (preferably free) Import/Export tool 
 for PostgreSQL? I have to import/export from MS SQL Server and using 
 MS' DTS does not seem to be working due to this bug:
 http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944
 
 Thanks,
 George
 
 
 
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208206
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF vs LAMP

[Simon Cornelius P . Umacob]

 
 Would you take your bmw to some cheap mechanic that only used free 
 tools or the new state of the art repair center?

I have a question to you, my dear friend: Would you buy a BMW with its hood 
welded shut?

 Did you fall for the dumb scam of we don't charge any closing fees 
 when you bought your new home?

But what if someone--or some group of people--were kind enough to give you a 
home?

 
 Nothin is really free...

The grace of God, perhaps? ;)

Seriously though, http://www.gnu.org/philosophy/free-sw.html tells us that 
free software is a matter of liberty, not price.

To understand the concept, you should think of 'free' as in 'free speech,' not 
as in 'free beer.'

I know I'm not an expert in business (nor do I have the experience as much as 
you do), but I believe that unless you're convincing a client who's very 
knowledgeable with web development, you can never convince him using esoteric 
technical arguments no matter how valid they are.  The fact is, a less 
competent person will probably get the job if he has better social skills than 
you do.  They will get the job even if they charge higher than you do.


[ simon.cpu ]
p.s.:
I love PHP because it's so beautiful, flexible, and intelligent.
PHP is like my girlfriend.

I somewhat love ColdFusion because it's the technology that brings food to my 
table.
ColdFusion is like my mom.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208207
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: (SOT) Joins aren't always better than subqueries (longish post)

[Jochem van Dieten]

James Holmes wrote:
 
 My quick query (800ms):
 
 SELECT STATEMENT Optimizer Mode=CHOOSE
   TABLE ACCESS BY INDEX ROWID DIVWEB.ESCUNITS
 INDEX UNIQUE SCAN DIVWEB.PK_ESCUNITS
   TABLE ACCESS FULL   DIVWEB.WRKENROLMENTS
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKPERIODS
 INDEX UNIQUE SCAN DIVWEB.PKWRKPERIODS
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS
 INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS
   SORT GROUP BY
 TABLE ACCESS FULL DIVWEB.WRKCALCS

Let's start with this one. What Oracle does here is first a full
table scan of the WRKCACLS table, then a sort and group by. Then
for each result of that it passes all the other tables to search
for matching rows. The obvious reason why this is so fast is that
many rows get discarded early on.

I wonder why the unique index on WRKENROLLMENTS (periodid, 
unitid) isn't used. Is the WRKENROLLMENTS table very small perhaps?


 Your query ran in 2.6 seconds. The explain plan for that is:
 
 SELECT STATEMENT Optimizer Mode=CHOOSE
   SORT GROUP BY
 NESTED LOOPS
   MERGE JOIN
 SORT JOIN
   NESTED LOOPS
 NESTED LOOPS
   TABLE ACCESS FULL   DIVWEB.WRKENROLMENTS
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKPERIODS
 INDEX UNIQUE SCAN DIVWEB.PKWRKPERIODS
 TABLE ACCESS BY INDEX ROWID   DIVWEB.ESCUNITS
   INDEX UNIQUE SCAN   DIVWEB.PK_ESCUNITS
 SORT JOIN
   TABLE ACCESS FULL   DIVWEB.WRKCALCS
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS
 INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS

 My slower query (4.3 secs):
 
 SELECT STATEMENT Optimizer Mode=CHOOSE
   SORT GROUP BY
 MERGE JOIN
   SORT JOIN
 NESTED LOOPS
   NESTED LOOPS
 MERGE JOIN
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS
 INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS
   FILTER
 TABLE ACCESS FULL DIVWEB.WRKCALCS
 TABLE ACCESS BY INDEX ROWID   DIVWEB.WRKPERIODS
   INDEX UNIQUE SCAN   DIVWEB.PKWRKPERIODS
   TABLE ACCESS BY INDEX ROWID DIVWEB.ESCUNITS
 INDEX UNIQUE SCAN DIVWEB.PK_ESCUNITS
   SORT JOIN
 TABLE ACCESS FULL DIVWEB.WRKENROLMENTS

As you can see in both of these the SORT GROUP BY is the last 
step. So in all intermediate steps the database has many more 
rows, which makes it slower.

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208208
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: FuseBuilder is awesome!

[Damien McKenna]

In my continued efforts to plan to migrate our FB3 sites to FB4 I've
started using FuseBuilder and its simply awesome!  I've passed on
details to my boss and he sounded interested, so here's hoping I'll be
able to put some money where my mouth is.
 
Excellent work, Mike!
 
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 
The Limu Company - http://www.thelimucompany.com/
http://www.thelimucompany.com/  - 407-804-1014
#include stdjoke.h
 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208209
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: (SOT) Joins aren't always better than subqueries (longish post)

[James Holmes]

Ah, the PK on wrkenrolments is actually a separate column (enrolmentid)
so there isn't an index to use. Maybe I should define a composite key
for that purpose instead?

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 1 June 2005 10:59 
To: CF-Talk
Subject: Re: (SOT) Joins aren't always better than subqueries (longish
post)

James Holmes wrote:
 
 My quick query (800ms):
 
 SELECT STATEMENT Optimizer Mode=CHOOSE
   TABLE ACCESS BY INDEX ROWID DIVWEB.ESCUNITS
 INDEX UNIQUE SCAN DIVWEB.PK_ESCUNITS
   TABLE ACCESS FULL   DIVWEB.WRKENROLMENTS
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKPERIODS
 INDEX UNIQUE SCAN DIVWEB.PKWRKPERIODS
   TABLE ACCESS BY INDEX ROWID DIVWEB.WRKLOCATIONS
 INDEX UNIQUE SCAN DIVWEB.PK_WRKLOCATIONS
   SORT GROUP BY
 TABLE ACCESS FULL DIVWEB.WRKCALCS

Let's start with this one. What Oracle does here is first a full table
scan of the WRKCACLS table, then a sort and group by. Then for each
result of that it passes all the other tables to search for matching
rows. The obvious reason why this is so fast is that many rows get
discarded early on.

I wonder why the unique index on WRKENROLLMENTS (periodid,
unitid) isn't used. Is the WRKENROLLMENTS table very small perhaps?

[snip]

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208210
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Import/Export for PostgreSQL

[Jochem van Dieten]

George Abraham wrote:
 
 Anyone have a suggestion for a (preferably free) Import/Export tool
 for PostgreSQL?

Export from MS SQL Server to CSV, import in PostgreSQL using 
COPY. Use pg_dump with full insert statements if you need to go 
the other way.

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208211
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: SSL Cert

[Robertson-Ravo, Neil (RX)]

Anyone got any links/tips etc for generating an SSL cert?  I just need one
for testing etc and don't really need to go to a CA to get one.  I can
install MS Certificate Server but ideally would like another option if
possible.

N
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208212
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: (SOT) Joins aren't always better than subqueries (longish post)

[Jochem van Dieten]

James Holmes wrote:
 Ah, the PK on wrkenrolments is actually a separate column (enrolmentid)
 so there isn't an index to use. Maybe I should define a composite key
 for that purpose instead?

Yes, you very, very much should so. And not for the purpose of 
speed, but for the purpose of data integrity. Your query with 
subselects will throw an exception if there are multiple rows 
with the same periodid and unitid in the WRKENROLLMENTS table.

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208213
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: (SOT) Joins aren't always better than subqueries (longish post)

[James Holmes]

Yes, I found that out the hard way (bad data import). I'll drop the
existing PK and create a composite key. I'll also see if that speeds
things up any more. Thanks muchly for the help too.

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 1 June 2005 11:13 
To: CF-Talk
Subject: Re: (SOT) Joins aren't always better than subqueries (longish
post)

James Holmes wrote:
 Ah, the PK on wrkenrolments is actually a separate column 
 (enrolmentid) so there isn't an index to use. Maybe I should define a 
 composite key for that purpose instead?

Yes, you very, very much should so. And not for the purpose of speed,
but for the purpose of data integrity. Your query with subselects will
throw an exception if there are multiple rows with the same periodid and
unitid in the WRKENROLLMENTS table.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208214
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Keith Gaughan]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dave Watts wrote:

I think that more points to a flaw in the concept of NULLs in SQL
(which, as it happens, is one of the most criticised aspects of the
language) than a flaw in MySQL per-se.
 
 It's one thing to observe a flaw in a language. It's another to use that
 flaw as justification for an application's failure to conform to that
 language. I don't see at all how one has to do with the other.

As I said, I'm not defending MySQL. I'm saying that the behaviour of
NULLs in SQL is, well, buggered. Attacking a DBMS, any DBMS on the way
it handles them in various situations is a bit like shooting fish that
are fastened to the barrel of your gun.

The thing is, the overloading of NULL in various DBMSs probably made
sense at the time. Just to taking the situation with MySQL, there are
times where you're inserting a new record and you may or may not want
the default value, but you'll only know at run time.

A better solution would be to have a USE_DEFAULT keyword for that
particular kind of null value or something like that, but extending the
DML like that can be argued against easily too. What overloading NULL
like that has in its favour is that if you're using the likes of
prepared statements, you don't need to mess about the API, it just drops
out of the implementation.

I'm not saying that it's good. I'm just saying that its behaviour is no
worse than that of any other DBMS when it comes to NULLs. There's things
far more annoying in its behaviour than that.

 On an unrelated note, I noticed that I can see better out of my right eye
 than my left eye. So, to improve my driving, I started driving on the left
 side of the road instead of the right side. I'm sure that will be a great
 improvement.

Yeah, depth perception of for the weak! :-)

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCndKOmSWF0pzlQ04RAnKJAJ0ajVfswfjBZ2z7R2lR/unBVtHfIQCfTQSD
NfAQbKbMNY3W1t2EAi8vEq4=
=IXRP
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208215
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SSL Cert

[Dave Watts]

 Anyone got any links/tips etc for generating an SSL cert?  I 
 just need one for testing etc and don't really need to go to a 
 CA to get one. I can install MS Certificate Server but ideally 
 would like another option if possible.

You can find a ton of information about this by Googling self-signed
certificate. OpenSSL is a very good toolset for these sorts of things, and
there's a very nice, easy-to-use, free Windows port of it here:

http://www.shininglightpro.com/products/Win32OpenSSL.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208216
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: (SOT) Joins aren't always better than subqueries (longish post)

[Jochem van Dieten]

James Holmes wrote:
 Yes, I found that out the hard way (bad data import). I'll drop the
 existing PK and create a composite key.

You don't have to drop the existing PK. Just add another unique 
index.

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208217
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SSL Cert

[Kristopher Pilles]

I think the godaddy cert is only 29 bucks


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 11:32 AM
To: CF-Talk
Subject: RE: SSL Cert


 Anyone got any links/tips etc for generating an SSL cert?  I
 just need one for testing etc and don't really need to go to a 
 CA to get one. I can install MS Certificate Server but ideally 
 would like another option if possible.

You can find a ton of information about this by Googling self-signed
certificate. OpenSSL is a very good toolset for these sorts of things,
and there's a very nice, easy-to-use, free Windows port of it here:

http://www.shininglightpro.com/products/Win32OpenSSL.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208218
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: SSL Cert

[Jordan Michaels]

Robertson-Ravo, Neil (RX) wrote:

Anyone got any links/tips etc for generating an SSL cert?  I just need one
for testing etc and don't really need to go to a CA to get one.  I can
install MS Certificate Server but ideally would like another option if
possible.

N
  

If you're using linux:

Generate a key file without a password:
[EMAIL PROTECTED] /etc/httpd/conf/ssl.key]# openssl genrsa -out 
mysite.com.key 1024

Then to generate the Certificate Signing Request (CSR) file: (This is 
the file that most SSL places ask for when getting an SSL certificate 
from them.)
[EMAIL PROTECTED] /etc/httpd/conf/ssl.csr]# openssl req -new -key 
mysite.com.key -out mysite.com.csr

Then copy and paste the contents of that file into your favorite SSL 
registrar's form (Verisign, Thawte, etc) and wait for them to send you 
your cert in an email. Pretty simple.

You can also self-sign your certs, but then you'll always get a message 
saying that the cert wasn't signed by a trusted authority.

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED] 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208219
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

DBase and coldfusion

[CFDEV]

Hi all,
 
I have a client with an old dbase application and I want to read some
information from that database to put in a new application online (mysql and
coldfusion).
 
His secretary is already inputing information on her dbase software and
sends only the update information in a .DBF file to the directory who then
append the main dbase file. I would like to let the secretary also upload
the .DBF file on a web page so I can read from that file and update the
mysql Database. 
 
Does anyone knows a way to do this? maybe a javaobject to go trought the
..DBF file?
 
Thanks
 
Pat


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208220
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: (SOT) Joins aren't always better than subqueries (longish post)

[James Holmes]

Of course, but I'm wondering if the overhead of an extra index on
inserts is worth it; I guess having a unique single ID for each
enrolment is still a Good Thing(tm). The amount of data is so small that
it the extra index will probably make little difference to inserts.

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 1 June 2005 11:25 
To: CF-Talk
Subject: Re: (SOT) Joins aren't always better than subqueries (longish
post)

James Holmes wrote:
 Yes, I found that out the hard way (bad data import). I'll drop the 
 existing PK and create a composite key.

You don't have to drop the existing PK. Just add another unique index.

Jochem



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208221
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF vs LAMP

[Jochem van Dieten]

Keith Gaughan wrote:
 
 As I said, I'm not defending MySQL. I'm saying that the behaviour of
 NULLs in SQL is, well, buggered. Attacking a DBMS, any DBMS on the way
 it handles them in various situations is a bit like shooting fish that
 are fastened to the barrel of your gun.
 
 The thing is, the overloading of NULL in various DBMSs probably made
 sense at the time. Just to taking the situation with MySQL, there are
 times where you're inserting a new record and you may or may not want
 the default value, but you'll only know at run time.
 
 A better solution would be to have a USE_DEFAULT keyword for that
 particular kind of null value or something like that, but extending the
 DML like that can be argued against easily too.

LOL

Did you know that SQL has a DEFAULT keyword exactly for that 
purpose? The problem is MySQLs implementation of DEFAULT, not the 
standard.


 I'm not saying that it's good. I'm just saying that its behaviour is no
 worse than that of any other DBMS when it comes to NULLs.

MySQLs behaviour is worse.

Jochem

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208222
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SSL Cert

[Damien McKenna]

There are really three levels of SSL certs, as I see it:

* Premium certificates from known companies, e.g. Verisign, Thawte.
These will cost $150 at an absolute minimum from Thawte, and IIRC about
$300 or more from Verisign.

* Discounted certificates from smaller certificate authorities (CAs),
e.g. QuickSSL (a subsidiary of Equifax) provides a rebranding service
than a large number of companies offer for as low as $20-ish.  These can
cause problems with some browsers but a good 80% of your market /should/
be ok with them.

* Self-signed certificates that you create yourself.  These will always
create an error for visitors until they add you to their browser's
trusted CA ring (if it is even possible).  You should only use these for
test/development sites.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208223
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Problems?

[Michael Dinowitz]

I haven't seen any problems but will look into it.

Is the list having problems at the moment? Posts are sporadically
arriving in batches and the post I just did at HOF didn't show up
online.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208224
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: (SOT) Joins aren't always better than subqueries (longish post)

[James Holmes]

Well, in addition to providing th data integrity I was after, adding the
composite index also halved the time the query took to run; now it's 400
ms. Thanks again.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208225
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Problems?

[James Holmes]

I think the mail arriving in blocks was a client issue - I restarted
Outlook (ugh) and all seems normal again. However the post I made online
didn't make it, as far as I can tell. 

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 2 June 2005 12:04 
To: CF-Talk
Subject: Problems?

I haven't seen any problems but will look into it.

Is the list having problems at the moment? Posts are sporadically 
arriving in batches and the post I just did at HOF didn't show up 
online.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208226
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CFLock inside CFFunction if a session variable is used as default argument value?

[Andrew Peterson]

Hi. I am cflocking the call to a component method because I'm passing in 
session variables, like so:

CFLOCK SCOPE=SESSION TIMEOUT=300 TYPE=exclusive
CFINVOKE COMPONENT=LHF METHOD=updateStatus 
RETURNVARIABLE=mmhmm 
ILASTACTIONUSER=#session.userName# ...
/CFINVOKE
/CFLOCK   

If I set a default session variable in the method itself, do I have to have a 
cflock inside the cffuntion too? I hope not, since the function does not seem 
to like cflocks in it:

CFFUNCTION NAME=updateStatus HINT=update the LHF_Header table with a new 
lastAction, lastActionDate, and lastActionUser ACCESS=PUBLIC OUTPUT=FALSE 
RETURNTYPE=STRING
cflock here? It throws an error
CFARGUMENT NAME=lastActionUser TYPE=STRING REQUIRED=YES 
DEFAULT=#SESSION.userName#

.

CFSTOREDPROC DATASOURCE=#request.dsn# PASSWORD= 
PROCEDURE=updateStatus USERNAME=
CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_varCHAR 
DBVARNAME=lastActionUser VALUE=#arguments.lastActionUser#
cfprocparam TYPE=Out  CFSQLTYPE=cf_sql_integer DBVARNAME=@RetVal 
VARIABLE=updateRetVal
cfprocparam TYPE=Out CFSQLTYPE=cf_sql_varchar DBVARNAME=@RetMsg 
VARIABLE=updateRetMsg 
cfprocresult NAME=myStatus  
/CFSTOREDPROC
cfif updateRetVal eq 0
  CFRETURN success
cfelse
 CFRETURN myStatus
/cfif
/cflock ?

/CFFUNCTION

Thanks in advance.

Andrew

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208227
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: DBase and coldfusion

[Claude Schneegans]

 Does anyone knows a way to do this?

Just create an ODBC datasource on the dbf file and use it as any other 
datasource.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208228
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLock inside CFFunction if a session variable is used as def ault argument value?

[Dave Watts]

 Hi. I am cflocking the call to a component method because I'm 
 passing in session variables, like so:
 
 CFLOCK SCOPE=SESSION TIMEOUT=300 TYPE=exclusive
   CFINVOKE COMPONENT=LHF METHOD=updateStatus 
   RETURNVARIABLE=mmhmm 
 ILASTACTIONUSER=#session.userName# ...
 /CFINVOKE
 /CFLOCK 
 
 If I set a default session variable in the method itself, do 
 I have to have a cflock inside the cffuntion too?

If you are locking the Session scope outside the component, there's no
reason you'd need to lock the Session scope within the component.

 I hope not, since the function does not seem to like cflocks in it

You should have no problem using CFLOCK within a CFFUNCTION tag. You would
probably want to rewrite it something like this, I think:

cffunction ...
cfargument ...
cfset var ...
cflock ...
...
/cflock
cfreturn ...
/cffunction

However, in this specific case, I would recommend that you perform your
locking in the calling page.

   CFARGUMENT NAME=lastActionUser TYPE=STRING 
 REQUIRED=YES DEFAULT=#SESSION.userName#

In general, I'd recommend that you avoid explicitly referring to the Session
scope (or any other external scope) within your components and functions. If
the argument is required, there's no need to specify a default value.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208229
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

SFCommerce? Payment gateway? Stacy, are you around?

[Michael Dinowitz]

What type of gateway or will any do?

need a payment gateway for a new application for my wife

www.mydinnercompany.com

Stacy (Young?) still around?

thanks.

-- 
tony

Tony Weeg

macromedia certified coldfusion mx developer
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
cool tool: http://www.antiwrap.com

...straight cash homey
- randy moss, now a raider

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208230
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SFCommerce? Payment gateway? Stacy, are you around?

[Tony Weeg]

need one that works VERY well with cfmx, has a custom tag or something
else i can make it VERY easy for the user to just type in their info,
send it off, wait for reply, and be done, show the receipt, and go on
their merry way :)

thanks.
tony

On 6/1/05, Michael Dinowitz [EMAIL PROTECTED] wrote:
 What type of gateway or will any do?
 
 need a payment gateway for a new application for my wife
 
 www.mydinnercompany.com
 
 Stacy (Young?) still around?
 
 thanks.
 
 --
 tony
 
 Tony Weeg
 
 macromedia certified coldfusion mx developer
 email: tonyweeg [at] gmail [dot] com
 blog: http://www.revolutionwebdesign.com/blog/
 cool tool: http://www.antiwrap.com
 
 ...straight cash homey
 - randy moss, now a raider
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208231
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfc confused

[Brian Kotek]

That is correct, assuming that you are dealing with one User object that is 
compositing an Address object. Sean already explained using a gateway to 
bring back multiple of users and their addresses together.

Assumign one User object, you could run one query to get the address for the 
single User, populate the Address object with that data, and then all of 
your method calls would just be reading the instance data from the Address 
object. There shouldn't need to be any additional queries for address 
information.

On 6/1/05, Johnny Le [EMAIL PROTECTED] wrote:
 
 So even when I use user.getAddress().getCity(), user.getAddress().getState(), 
 user.getAddress().getZip(), I didn't make three separate calls to the 
 database, just one? That's great.
 
 
 The answer to your second question about the address is to use 
 composition
 and have the User object hold a reference to an Address object. So you 
 are
 on track there. But you don't have to execute a query when you call
 getAddress(), the Address object is already there and populated (at the 
 same
 time the User object is created) so you're just getting the state of the
 Address object by calling methods on it. Basically you don't need to run 
 any
 queries beyond the first one that you use when you initialize the Address
 object.
 
 Hope that helps.
 
 Brian
 
 
 
 On 6/1/05, Johnny Le [EMAIL PROTECTED] wrote:
 
 
 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208232
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

inserting checkboxes into a db

[Daniel Kessler]

I have a single file that's supposed to enter form data from several 
pages into a database.  It checks to see if a form exists and if it 
does, then it enters it's value into the database.
The problem that I'm running into is that when checkboxes aren't 
checked, they don't exist with structKeyExists(form,'the_checkbox'). 
If I'm on a page that has a checkbox and it's not checked, I want to 
set the value to 0, but if I'm on a form without any checkboxes, I 
want to leave the value in the database alone.  I'm trying to use 
this UPDATE page for the several pages that make up a section because 
I'd rather not make a UPDATE page for each screen.

Here's the code that's not working:

CFQUERY NAME=makeEdit DATASOURCE=dpch
  UPDATE empower_project_data
  SET
  cfif structKeyExists(form,'politics')
   cfset session.politics = form.politics
   politics = cfqueryparam value=#session.politics# 
cfsqltype=CF_SQL_NUMERIC,
  /cfif
  cfif structKeyExists(form,'demand')
   cfset session.demand = form.demand
   form.demand:#form.demand#
   cfabort
   demand = cfqueryparam value=#session.demand# 
cfsqltype=CF_SQL_NUMERIC,
  /cfif
  cfif structKeyExists(form,'continuation')
   cfset session.continuation = form.continuation
   continuation = cfqueryparam value=#session.continuation# 
cfsqltype=CF_SQL_NUMERIC,
  /cfif
  date_modified = SYSDATE
  WHERE project_data_id = #session.project_data_id#
/CFQUERY

-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208233
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Stab in the dark, OT, ASP?

[Eric J. Hoffman]

Just a quick note to see if any CF gurus out here are also ASPheads...I 
inherited an ASP app and I simply need to know how to grab a URL variable and 
put it in global.asa in the application object.  If anyone can kindly lend a 
quick hand offlist to [EMAIL PROTECTED] that would be great!
 
Thanks again!
 
Eric Hoffman
Tired Geek

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208234
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: DBase and coldfusion

[CFDEV]

It's hosted on a linux box, I don't believe you can create a dbase
datasource...?

Pat 

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: June 1, 2005 12:23
To: CF-Talk
Subject: Re: DBase and coldfusion

 Does anyone knows a way to do this?

Just create an ODBC datasource on the dbf file and use it as any other
datasource.

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED]) Thanks.




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208235
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLDAP connection timeout with dead server

[James Holmes]

I have just developed a simple method to check if the LDAP server is
alive - using a java.net.Socket connection to a port that responds in a
known way. If it times out I know the server is dead. I can control the
timeout value myself and it works like a charm.

-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 1 June 2005 10:08 
To: CF-Talk
Subject: Re: CFLDAP connection timeout with dead server

have not seen that issue, we do have issues with CFLDAP under load
though, it flakes out. I'm writing a Java POJO right now to replace it,
this might help your situation also, dunno. After I get it working and
tested I'll release it around here. 
 I do see this issue with cfquery though. If the DB server is down, in
my case if the TNS listner is not listening, the tag gets all hung up.
This is something I really wish they would get working better, wished
this since like version 4. Luckly its a very rare case that our phat
Oracle box has issues.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208236
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: inserting checkboxes into a db

[Dave Watts]

 I have a single file that's supposed to enter form data from several 
 pages into a database.  It checks to see if a form exists and if it 
 does, then it enters it's value into the database.
 The problem that I'm running into is that when checkboxes aren't 
 checked, they don't exist with structKeyExists(form,'the_checkbox'). 
 If I'm on a page that has a checkbox and it's not checked, I want to 
 set the value to 0, but if I'm on a form without any checkboxes, I 
 want to leave the value in the database alone.  I'm trying to use 
 this UPDATE page for the several pages that make up a section because 
 I'd rather not make a UPDATE page for each screen.

You will have to have some way of tracking within your form data whether
there was originally a checkbox in the page. One easy way to do this is to
simply add a hidden form field within that page.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208237
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: inserting checkboxes into a db

[Dave Francis]

input type=hidden name=c1 value=0
input type=checkbox name=c1 value=a
input type=checkbox name=c1 value=b

-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 12:50 PM
To: CF-Talk
Subject: inserting checkboxes into a db


I have a single file that's supposed to enter form data from several
pages into a database.  It checks to see if a form exists and if it
does, then it enters it's value into the database.
The problem that I'm running into is that when checkboxes aren't
checked, they don't exist with structKeyExists(form,'the_checkbox').
If I'm on a page that has a checkbox and it's not checked, I want to
set the value to 0, but if I'm on a form without any checkboxes, I
want to leave the value in the database alone.  I'm trying to use
this UPDATE page for the several pages that make up a section because
I'd rather not make a UPDATE page for each screen.

Here's the code that's not working:

CFQUERY NAME=makeEdit DATASOURCE=dpch
  UPDATE empower_project_data
  SET
  cfif structKeyExists(form,'politics')
   cfset session.politics = form.politics
   politics = cfqueryparam value=#session.politics#
cfsqltype=CF_SQL_NUMERIC,
  /cfif
  cfif structKeyExists(form,'demand')
   cfset session.demand = form.demand
   form.demand:#form.demand#
   cfabort
   demand = cfqueryparam value=#session.demand#
cfsqltype=CF_SQL_NUMERIC,
  /cfif
  cfif structKeyExists(form,'continuation')
   cfset session.continuation = form.continuation
   continuation = cfqueryparam value=#session.continuation#
cfsqltype=CF_SQL_NUMERIC,
  /cfif
  date_modified = SYSDATE
  WHERE project_data_id = #session.project_data_id#
/CFQUERY

--
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208238
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Application.cfm

[Christian Watt]

Is there any way to tell a page in a directory or sub directory to not
run/inlcude the application.cfm

 

Christian



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208239
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: inserting checkboxes into a db

[daniel kessler]

You will have to have some way of tracking within your form data whether
there was originally a checkbox in the page. One easy way to do this is to
simply add a hidden form field within that page.

So, I guess the hidden field has to have a value that indicates the page, 
rather than just true and false.  Because if I have one page with checkboxes 
and it just sets the hidden field to true then it'd be true for other 
checkboxes on the update page.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208240
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Invalid precision value

[Mike Rogan]

 I am receiving the following CF error:

I don't have an answer for the question you asked, but I think you're asking
the wrong question.

First, instead of having a column which contains a comma-delimited list,
you'd probably be better off with a lookup table with those values instead,
and an intersection table between your table and the lookup table. Your
database doesn't appear to be in third normal form, and it should be.

Second, instead of doing a bunch of LIKE searches to find values within
database columns, you'd probably be better off using full-text indexing.
Searching for a string in the middle of a larger string using LIKE is very
expensive, since your database can't use indexes for such a search.
Fortunately, CF comes with Verity, which is ideal for these sorts of
searches. Of course, if you redesign the database properly you can avoid
this kind of search in this specific case, but you may run into future cases
where full-text indexing is the better approach.

Finally, you might try using the Access with Unicode driver instead. This
driver uses ADODB instead of ODBC, I think, so it may not suffer from the
same limitations. To see if it's an ODBC limitation, you could try running
the query from an ODBC client directly (like MS Query) rather than from CF.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!

Kevin/Dave:

Thanks for your feedback. Changing the driver to Access with Unicode returned 
the same error, although running the query outsdie CF is successful.

Kevin:

I removed the 0 = 0 portion as it is no longer needed.  Thanks for pointing 
that out.  The error reamins, however.  Could you describe the SQL I can use to 
perform the query another way?

Dave: 

I agree that the database structure should be modified.  Unfortunatley, I 
inherited the design and the DB is being used by another application.  Changing 
the architecture would have a definite impact in other areas.  I will look into 
the possibility of using Verity.

Thanks to both of you for your replies.

-Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208242
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[Adrian Lynch]

Not as such. But you can create a second App.cfm in a sub directory and it
will use that one instead.

Ade

-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED]
Sent: 01 June 2005 18:12
To: CF-Talk
Subject: Application.cfm


Is there any way to tell a page in a directory or sub directory to not
run/inlcude the application.cfm



Christian
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.3.3 - Release Date: 31/05/2005


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208241
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[CollicuttL]

Put a blank application.cfm in the subdirectory you want to exclude...then
it won't go looking for another one to run.

Lorne

-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED] 
Sent: June 1, 2005 10:12
To: CF-Talk
Subject: Application.cfm


Is there any way to tell a page in a directory or sub directory to not
run/inlcude the application.cfm

 

Christian





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208243
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Application.cfm

[Charlie Griefer]

you could include an empty Application.cfm in the subdirectory in
question.  a CF template looks in the current directory for an
Application.cfm, and if it finds one, it executes it.  If not, it
looks up one directory level (and continues until either it finds one
or hits the root directory).  But once it finds one, it will stop
looking up.

On 6/1/05, Christian Watt [EMAIL PROTECTED] wrote:
 Is there any way to tell a page in a directory or sub directory to not
 run/inlcude the application.cfm
 
 
 
 Christian
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208244
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Verity on Linux will not index PDFs

[chad gray]

Hello,

I am having more troubles with Linux verity.  I am using the following to index 
the files in a folder:

cfindex collection=test 
action=update
type=path 
key=/home/user/www/UserFiles/File/
urlpath=http://somesite/UserFiles/File/; 
extensions=.pdf, .doc 
custom1=pdf
recurse=yes
language=english 

This will index the word documents in the folder, but not the PDFs.

When i search i get no results for the PDFs.  I will get results for the Word 
documents.

If i run this exact same code on my windows box it indexes PDFs and Word docs 
just fine.

Any Ideas? 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208245
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: inserting checkboxes into a db

[daniel kessler]

input type=hidden name=c1 value=0
   input type=checkbox name=c1 value=a
   input type=checkbox name=c1 value=b

So the hidden sets the default value, right?  Here's what I did.

on the page:
input type=hidden name=#checkbox_name# value=0 
input name=#checkbox_name# #checked# type=checkbox id=#checkbox_name# 
value=#checkbox_value#

and on the UPDATE page, I left it as is:
cfif structKeyExists(form,'mandate')
 cfset session.mandate = form.mandate
mandate = cfqueryparam value=#session.mandate# cfsqltype=CF_SQL_NUMERIC,
/cfif

So, whenever the checkbox exists, it'll either input this the checkbox value or 
it's hidden field, because the checkbox won't overwrite it.  right?

oh, I just checked that and it sorta works.  If it's not checked, it works 
fine.  If it's checked, then it puts out 38352 in the value, rather than the 1 
it's supposed to be.  I suppose it's having problems with two fields being 
named the same.

While I don't know if this is how you meant for me to implement it, it seemed 
intriguing.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208246
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfc confused

[Sean Corfield]

On 6/1/05, Dawson, Michael [EMAIL PROTECTED] wrote:
 The way I understand Sean, you will need to make only two database
 calls: 1. to get the master data.  2. To get all of the addresses.

Essentially yes. One database query for the master data. And then
one more query for a detail page. A lot depends on the exact setup
of the objects but the thing to watch for is the temptation to
slavishly map each table to an object and then try to have a single
DAO for each table. Object models and relational models are different
for a reason!

For example, I have an application that has tasks and notes. Each task
can have multiple notes but a note can't exist without a task. My
system does have a DAO for the note but only for the creation of a new
note. All the read operations are handled in aggregate by the task DAO
and notes are maintained as a query, as a data member of the task
bean. My task (data) gateway reads just basic task information (to be
displayed on a task list page). My task DAO reads all the task
information *and* the notes for that task.

Does that help clarify?
-- 
Sean A Corfield -- http://corfield.org/
Team Fusebox -- http://fusebox.org/
Got Gmail? -- I have 50, yes 50, invites to give away!

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

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208247
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: inserting checkboxes into a db

[Dave Francis]

No. Fields with the same name name return a comma-delimited list when more
than 1 is checked. Also, a checkbox is not True or False, it is Undefined or
Value (of value=#checkbox_value#).

In your case, the hidden field should be present on forms with checkboxes
and provide, as you surmised, a defualt value of 0.
Use IsDefined('FORM.checkbox_name') in the UPDATE to determine whether to
updaytre the field.


-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 1:44 PM
To: CF-Talk
Subject: RE: inserting checkboxes into a db


input type=hidden name=c1 value=0
   input type=checkbox name=c1 value=a
   input type=checkbox name=c1 value=b

So the hidden sets the default value, right?  Here's what I did.

on the page:
input type=hidden name=#checkbox_name# value=0
input name=#checkbox_name# #checked# type=checkbox id=#checkbox_name#
value=#checkbox_value#

and on the UPDATE page, I left it as is:
cfif structKeyExists(form,'mandate')
 cfset session.mandate = form.mandate
mandate = cfqueryparam value=#session.mandate#
cfsqltype=CF_SQL_NUMERIC,
/cfif

So, whenever the checkbox exists, it'll either input this the checkbox value
or it's hidden field, because the checkbox won't overwrite it.  right?

oh, I just checked that and it sorta works.  If it's not checked, it works
fine.  If it's checked, then it puts out 38352 in the value, rather than the
1 it's supposed to be.  I suppose it's having problems with two fields being
named the same.

While I don't know if this is how you meant for me to implement it, it
seemed intriguing.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208248
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Verity on Linux will not index PDFs

[Gruss Gott]

 chad wrote:
 I am having more troubles with Linux verity.  I am using the following to 
 index the 

I've got a solaris box with CF on it and here's what my code looks like:

CFINDEX
ACTION=update
COLLECTION=some-name
KEY=some-key
TYPE=path
EXTENSIONS=.pdf,.PDF
URLPath=someurl

So you might want to try the PDF in caps which is the only difference
I can see.  I actually wrote an application to allow people to upload
PDFs to a directory, index them, and them provide an HTML interface to
search them.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208249
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CF and MS Word

[Charlie Griefer]

Hey all...

I have a word document from a client that contains a header and footer
(and some various body content).

I'm trying to create an app where they can go in thru a web interface,
enter data in a textarea, and have the action page populate this word
document with the content they enter.

Can't do any COM as Word is not (and cannot/will not be) installed on
the server.  I've tried saving the original .doc as a web page, saving
the trillions of lines of MS-word markup into a cfsavecontent var,
and using cffile to write a .doc, but I lose a lot of the
formatting, and there doesn't seem to be any way for me to retain the
headers/footers.

Any ideas, or am I SOL?

Thanks.
-- 
Charlie Griefer


...All the world shall be your enemy, Prince with a Thousand Enemies, 
and whenever they catch you, they will kill you. But first they must catch 
you, digger, listener, runner, prince with a swift warning. 
Be cunning and full of tricks and your people shall never be destroyed.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208250
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Connection closed due to session kill (SOLVED - Sort of)

[Mosh Teitelbaum]

All:

In case anyone was curious, I believe I've discovered the source of this
problem.  Apparently, at the same time the web host switched DB drivers,
they also began recycling one of the ODBC services every hour.  The
recycling appears to have been the culprit.  Ever since they stopped
recycling the service (this morning), I have yet to receive another
notification of this problem (and I was receiving several each hour).

So there you go.

Thanks for the help.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


Mosh Teitelbaum wrote:
 I was recently called in to troubleshoot a site that has been showing all
 kinds of problems.  One problem that just recently began showing
 up includes
 the following error message:

   Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]
Connection closed due to session kill.

 I've searched Google, HOF and Macromedia livedocs and forums without much
 luck.  The only thing even remotely useful I could find suggests that the
 error message is coming from the SequeLink driver (
 http://media.datadirect.com/download/docs/slnk/errmsgs/codes.html -- do a
 search for session kill).

 Has anyone seen this before?  Any idea what could be causing it
 and what can
 be done to fix it?

 The site is running on CFMX/SQL Server 2000 on Windows.  The DB connection
 was going through the JDBC-ODBC bridge but was recently switched over to
 ODBC Sockets.  These errors began around the same time as that switch but,
 for various reasons, the host is not willing to switch back.

 The files and line numbers indicated in the error messages
 suggest that this
 problem happens whether the code uses CFQUERY or CFSTOREDPROC.

 Any help would be greatly appreciated.

 TIA


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208251
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF and MS Word

[Matthew Small]

Crystal Reports.
 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 2:01 PM
To: CF-Talk
Subject: CF and MS Word

Hey all...

I have a word document from a client that contains a header and footer
(and some various body content).

I'm trying to create an app where they can go in thru a web interface,
enter data in a textarea, and have the action page populate this word
document with the content they enter.

Can't do any COM as Word is not (and cannot/will not be) installed on
the server.  I've tried saving the original .doc as a web page, saving
the trillions of lines of MS-word markup into a cfsavecontent var,
and using cffile to write a .doc, but I lose a lot of the
formatting, and there doesn't seem to be any way for me to retain the
headers/footers.

Any ideas, or am I SOL?

Thanks.
-- 
Charlie Griefer


...All the world shall be your enemy, Prince with a Thousand Enemies, 
and whenever they catch you, they will kill you. But first they must catch 
you, digger, listener, runner, prince with a swift warning. 
Be cunning and full of tricks and your people shall never be destroyed.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208252
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF and MS Word

[Kevin Penny]

Try a RTF file
Rich text instead.

Kevin Penny
HotGigs.com

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 1:00 PM
To: CF-Talk
Subject: CF and MS Word

Hey all...

I have a word document from a client that contains a header and footer
(and some various body content).

I'm trying to create an app where they can go in thru a web interface,
enter data in a textarea, and have the action page populate this word
document with the content they enter.

Can't do any COM as Word is not (and cannot/will not be) installed on
the server.  I've tried saving the original .doc as a web page, saving
the trillions of lines of MS-word markup into a cfsavecontent var,
and using cffile to write a .doc, but I lose a lot of the
formatting, and there doesn't seem to be any way for me to retain the
headers/footers.

Any ideas, or am I SOL?

Thanks.
-- 
Charlie Griefer


...All the world shall be your enemy, Prince with a Thousand Enemies, 
and whenever they catch you, they will kill you. But first they must catch 
you, digger, listener, runner, prince with a swift warning. 
Be cunning and full of tricks and your people shall never be destroyed.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208253
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Application.cfm

[Tony Weeg]

e, doesnt an EMPTY application.cfm file barf?

tony

On 6/1/05, Charlie Griefer [EMAIL PROTECTED] wrote:
 you could include an empty Application.cfm in the subdirectory in
 question.  a CF template looks in the current directory for an
 Application.cfm, and if it finds one, it executes it.  If not, it
 looks up one directory level (and continues until either it finds one
 or hits the root directory).  But once it finds one, it will stop
 looking up.
 
 On 6/1/05, Christian Watt [EMAIL PROTECTED] wrote:
  Is there any way to tell a page in a directory or sub directory to not
  run/inlcude the application.cfm
 
 
 
  Christian
 
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208254
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Application.cfm

[Claude Schneegans]

 e, doesnt an EMPTY application.cfm file barf?

Yes, it should contain at least one blank character.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208257
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Application.cfm

[Charlie Griefer]

ok, so in this specific Application.cfm do:

cfset barf = false /

:)

I'm sorry, i shouldn't have said 'empty'.  I meant an Application.cfm
that didn't necessarily do anything other than block access to
higher-level Application.cfm files.  Empty in the sense of usefulness.
 A Zen kind of empty :)

On 6/1/05, Tony Weeg [EMAIL PROTECTED] wrote:
 e, doesnt an EMPTY application.cfm file barf?
 
 tony
 
 On 6/1/05, Charlie Griefer [EMAIL PROTECTED] wrote:
  you could include an empty Application.cfm in the subdirectory in
  question.  a CF template looks in the current directory for an
  Application.cfm, and if it finds one, it executes it.  If not, it
  looks up one directory level (and continues until either it finds one
  or hits the root directory).  But once it finds one, it will stop
  looking up.
 
  On 6/1/05, Christian Watt [EMAIL PROTECTED] wrote:
   Is there any way to tell a page in a directory or sub directory to not
   run/inlcude the application.cfm
  
  
  
   Christian
  
  
  
  
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208258
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[Calvin Ward]

I think so, better throw a comment in there... 

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 2:15 PM
To: CF-Talk
Subject: Re: Application.cfm

e, doesnt an EMPTY application.cfm file barf?

tony

On 6/1/05, Charlie Griefer [EMAIL PROTECTED] wrote:
 you could include an empty Application.cfm in the subdirectory in 
 question.  a CF template looks in the current directory for an 
 Application.cfm, and if it finds one, it executes it.  If not, it 
 looks up one directory level (and continues until either it finds one 
 or hits the root directory).  But once it finds one, it will stop 
 looking up.
 
 On 6/1/05, Christian Watt [EMAIL PROTECTED] wrote:
  Is there any way to tell a page in a directory or sub directory to 
  not run/inlcude the application.cfm
 
 
 
  Christian
 
 
 
 
 
 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208256
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF and MS Word

[Dawson, Michael]

I have done this by outputting the file as a RTF and then adding CF code
where needed. 

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 1:01 PM
To: CF-Talk
Subject: CF and MS Word

Hey all...

I have a word document from a client that contains a header and footer
(and some various body content).

I'm trying to create an app where they can go in thru a web interface,
enter data in a textarea, and have the action page populate this word
document with the content they enter.

Can't do any COM as Word is not (and cannot/will not be) installed on
the server.  I've tried saving the original .doc as a web page, saving
the trillions of lines of MS-word markup into a cfsavecontent var, and
using cffile to write a .doc, but I lose a lot of the formatting, and
there doesn't seem to be any way for me to retain the headers/footers.

Any ideas, or am I SOL?

Thanks.
--
Charlie Griefer

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208259
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[Dawson, Michael]

Yeah, I use something like the following:

cfset variables.bogus = 
cfset structDelete(variables, bogus) 

M!ke

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 1:15 PM
To: CF-Talk
Subject: Re: Application.cfm

e, doesnt an EMPTY application.cfm file barf?

tony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208260
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF and MS Word

[Charlie Griefer]

crystal reports isn't an option, unfortunately.  the client has a word
document/template they use in all of their correspondences, and want
to be able to type into a web page to generate a letter using this
specific template :|

On 6/1/05, Matthew Small [EMAIL PROTECTED] wrote:
 Crystal Reports.
 
 Matthew Small
 Web Developer
 American City Business Journals
 704-973-1045
 [EMAIL PROTECTED]
 
 
 -Original Message-
 From: Charlie Griefer [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 01, 2005 2:01 PM
 To: CF-Talk
 Subject: CF and MS Word
 
 Hey all...
 
 I have a word document from a client that contains a header and footer
 (and some various body content).
 
 I'm trying to create an app where they can go in thru a web interface,
 enter data in a textarea, and have the action page populate this word
 document with the content they enter.
 
 Can't do any COM as Word is not (and cannot/will not be) installed on
 the server.  I've tried saving the original .doc as a web page, saving
 the trillions of lines of MS-word markup into a cfsavecontent var,
 and using cffile to write a .doc, but I lose a lot of the
 formatting, and there doesn't seem to be any way for me to retain the
 headers/footers.
 
 Any ideas, or am I SOL?
 
 Thanks.
 --
 Charlie Griefer
 
 
 ...All the world shall be your enemy, Prince with a Thousand Enemies,
 and whenever they catch you, they will kill you. But first they must catch
 you, digger, listener, runner, prince with a swift warning.
 Be cunning and full of tricks and your people shall never be destroyed.
 
 
 
 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208255
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: SSL Cert

[Robert Munn]

Are you using IIS or Apache? SSL support is in IIS by default. If you are using 
Apache, you need to compile Apache with SSL support using OpenSSL. I have a 
blog entry on doing just that here:

http://www.funkymojo.com/blog/index.cfm?mode=dayday=17month=5year=2005

The intstructions in the linked tutorial guide you through the whole thing, 
including generating a self-signed cert.

Rob

Anyone got any links/tips etc for generating an SSL cert?  I just need one
for testing etc and don't really need to go to a CA to get one.  I can
install MS Certificate Server but ideally would like another option if
possible.

N
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208261
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Application.cfm

[Adrian Lynch]

Not on 6.1 or 7 is doesn't.

Ade

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 01, 2005 1:15 PM
To: CF-Talk
Subject: Re: Application.cfm

e, doesnt an EMPTY application.cfm file barf?

tony
-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.3.3 - Release Date: 31/05/2005


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208262
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Rick Root or anyone (CFFM)

[Emmet McGovern]

I decided to implement cffm into a fck app we have running and now I see
cfopen.org is no more or down maybe.  Does anyone have a copy they can send?

Thanks,
Emmet





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208264
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54