Re: CFMX 7 on Linux

2006-02-02 Thread mac jordan
On 2/1/06, Anne Girardeau [EMAIL PROTECTED] wrote:

 Has anyone ever run across instability issues with CFMX 7 running on a
 Linux/Apache box?  Is it better to run CF in Windows vs Linux?



we're in the process of migrating 100 odd sites from CF5 to CF7, both on
Linux.  The first, and busiest site has been running live since the
beginning of January, and is behaving flawlessly - much better than it was
on CF5, but the box is much better spec'd ( twin operon, 4Gb RAM).


--
mac jordan
home: www.kestrel.org
work: www.webhorus.net
them: www.jordan-cats.org


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231073
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


Dynamically creating fields

2006-02-02 Thread Mark Drew
Hi all
I have been searching for a method (and here is where I am stumped at
the terminology to search for!) to dynamically add properties to some
record.

Let me explain:

In a CRM system, where you have a number of contacts (people) you
would need the user to create new attributes for them (such as
daughter's name or some such). You dont want to create a table that
already has that column, but you want to design a database model that
can support dynamically (i.e. the user doing it not a developer)
adding columns.

I would prefer if the underlying database structure didnt change (as
FarCry does when you add new attributes)

There is also another issue that this would be a HUGE list of people
(lets say 1million records)   and we would be doing dynamic quieries
such as

SELECT * from bla where daugher = susan and birthday IN july and
hasboughtGift = false

(not real SQL)

Any pointers? This must be a problem that has been addressed a number
of times (I saw this in a shopping application called Intershop a
while ago, the problem was doing efficient searches on these fields
especially if you are looking for nulls) and also in spectra (that
sidestepped the issue and stored it all as WDDX which made it suck at
quieries)

Any help or pointers apreciated!


--
Mark Drew
http://www.markdrew.co.uk/blog/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231074
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: Bluedragon 6.1

2006-02-02 Thread cf
 Just so I understand better...Railo essentially 
 replaces
 the CF server itself and processes pages, etc., 
 like
 the server?

Correct.

 Also, I asked earlier about Railo's 
 pricing...Gert mentioned
 that the cost for the Professional version 
 would be
 100 euros which would handle one web...  I was 
 trying to
 find out if he ment one website or one web 
 server.

Actually I think it was EUR 200,- for the basic version including 1 web, and 
EUR 100,- for each additional web. But, I haven't looked at the prices for some 
time. ;-) 

As far as I understood it from discussions during a presentation here in 
Germany, you can translate 1 web to 1 web server document root directory. 
Could again be translated to 1 domain or 1 virtual host. 

Gert, please correct me, if I am wrong here!

 Can you provide an answer?  Not many details on 
 the
 Railo site... (hint, hint, Gert...)

True. Definitely. But, I know the guys are very busy with their software, and 
they have repeatedly postponed the relaunch of their own site in order to 
satisfy CFML developer requests. As long as I can get an answer vial email, I 
personally prefer it this way. ;-)

Best

Chris


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231075
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: Dynamically creating fields

2006-02-02 Thread Nick de Voil
 I have been searching for a method (and here is where I am stumped at
 the terminology to search for!) to dynamically add properties to some
 record.
snip
 Any pointers? This must be a problem that has been addressed a number
 of times

Yes, certainly have addressed it a number of times.

With a relational database the only options afaik are:

1. change the underlying structure
2. have a (huge) table containing the attribute values of each entity
separately, with a lookup table of attributes
3. have a finite number of extra user-definable columns in each table
(custom field 1, custom field 2 etc)

We use 2 in our CMS. I refer to this as soft metadata but I don't know
what anyone else calls it. It's the only solution that's generic enough for
our purposes, because we provide an object-oriented data model with a kind
of multiple inheritance.  The performance implications need an awful lot of
attention though. If solution 1 is an option, I'd consider it very
carefully.

Some software packages use option 3 rather successfully but it's basically a
kludge, isn't it.

Nick



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231076
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: looking for a hosting company to resell

2006-02-02 Thread ColdFusion
Mike,

Did you look at coldfusion-mx-hosting?
They offer CFMX 7, unlimited pop/webmail,
Plans include 10 or more domains for a single
Plan and can be increased.

 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 01, 2006 9:50 PM
To: CF-Talk
Subject: Re: looking for a hosting company to resell

Thanks for your suggestion, Casey.  I looked at their plans and they dont
offer CFMX7.  (Their site is working though, which is more than i can say
for MY site right now!)

We have quite a few sites using CFMX7 features so that's a minimum
requirement these days.

While I dont want to discuss my hosting selection process too much because
it's off topic and not in my commercial interests to do so, but I think
hosting companies who want to encourage resellers should adopt a pricing
strategy that allows them to do business on a rational basis.

For example.   If the plans you offer, have say 10 pop3 accounts,   i get
penalised if i have one site with 15xPop3 accounts, incurring extra charges
(the nickel and dime attitude) while i might well have 15 sites with only
2xPop3 accounts, using nowhere near their allocation.

I have to take this kind of thing into account when deciding whether the
hosting company really understands resellers or just give  a discount off
their normal plans and dont understand how resellers work.

Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com



On 2/2/06, Casey Dougall [EMAIL PROTECTED] wrote:

 I have very little to complain about viux except use of CF Directory 
 which i think is an addon But I normally just create a dummy set of 
 directorys and don't need that tag after.

 Everything is moving to CF 7 this month...

 Control pannel has everything you need for each site. You even have 
 access to the DNS record which is really cool if you need to setup 
 backup mail servers or something on the fly.

 http://hosting.viux.com/resellers/plan-reseller-30.asp
 Monthly Price: ($84.95) X 2 of course You could go dedicated route 
 but you will still run imostlikely run into licencing issue with 
 things like Mail Systems and of course a host control pannel system.

 Casey






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231077
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: Dynamically creating fields

2006-02-02 Thread Mark Drew
Thanks for that Nick

I think all of these are kludes really, I am looking at Hibernate so
which works with Java (the system we are developing is in Java  but
the same problem I am sure that has faced a llot of CF developers)

The other way is to have multiple tables that can hold these simple
values, but it starts getting messy with the joins etc

so you could have one table with the main details, then tables with
key/value pairs with the value being of a different type (int,
varchar, double etc)

But I think you are right and that performance degrades therearfter

MD



On 02/02/06, Nick de Voil [EMAIL PROTECTED] wrote:
  I have been searching for a method (and here is where I am stumped at
  the terminology to search for!) to dynamically add properties to some
  record.
 snip
  Any pointers? This must be a problem that has been addressed a number
  of times

 Yes, certainly have addressed it a number of times.

 With a relational database the only options afaik are:

 1. change the underlying structure
 2. have a (huge) table containing the attribute values of each entity
 separately, with a lookup table of attributes
 3. have a finite number of extra user-definable columns in each table
 (custom field 1, custom field 2 etc)

 We use 2 in our CMS. I refer to this as soft metadata but I don't know
 what anyone else calls it. It's the only solution that's generic enough for
 our purposes, because we provide an object-oriented data model with a kind
 of multiple inheritance.  The performance implications need an awful lot of
 attention though. If solution 1 is an option, I'd consider it very
 carefully.

 Some software packages use option 3 rather successfully but it's basically a
 kludge, isn't it.

 Nick



 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231078
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


Migrating app version 2.0

2006-02-02 Thread Baz
Hi,

We just finished V2.0 of one of our client's apps, which included a complete
re-factoring of code from procedural to CFC, upgraded functionality, and a
significantly modified DB.

Since the changes are major, we will be deploying the new app on a new
domain, and, once we're ready, we will switch the dns to there. (rather than
just overwriting existing files on the existing domain)

Everything seems easy enough except for the database part of it. Since it
was majorly changed, we will create a new MySQL5 DB on the new domain, and
migrate all the data from the current MS-SQL server.

Does anyone have any tips, suggestions, gotchas for doing this? Should I do
it through CF by creating scripts that query the old DB and insert in the
new?  How do I access a remote DB in CF? Are there better ways, tools?

Thanks for any help,

Baz





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231079
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


cfmail corrupt links exclamation mark

2006-02-02 Thread Odhran Hardy
I am having a problem with an email being sent using cfmail.  A link in
the email is getting corrupted.

An Exclamation mark and a number of spaces are being inserted into the link.


The strange thing is that the email is being cc'd to a number of people and
it is only getting corrupted for one of the recipients.  It is the same
recipient every time, but not every email is getting corrupted.

Any thoughts would be greatly appreciated.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231080
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


help! cgi.global

2006-02-02 Thread Jennifer Gavin-Wear
I've just moved a site to a new server and I've set up a separate database
for the client variable store.

I changed the value in my application.cfm, but I'm getting the following
error on some pages:

Error Executing Database Query.[Macromedia][SQLServer JDBC
Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific sequence
of files included or processed is:
C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm

So the application is still looking for the tables in the old location.

How do i solve this please?

Thanks, Jenny



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231081
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: help! cgi.global

2006-02-02 Thread DURETTE, STEVEN J \(AIT\)
Jennifer,

Looks like your database for client variables wasn't configured.  If you
go into the CF Administrator there should be an option to create the
tables you need.

Steve


-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 6:58 AM
To: CF-Talk
Subject: help! cgi.global


I've just moved a site to a new server and I've set up a separate
database
for the client variable store.

I changed the value in my application.cfm, but I'm getting the following
error on some pages:

Error Executing Database Query.[Macromedia][SQLServer JDBC
Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific
sequence
of files included or processed is:
C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm

So the application is still looking for the tables in the old location.

How do i solve this please?

Thanks, Jenny





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231082
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: help! cgi.global

2006-02-02 Thread Jennifer Gavin-Wear
Hi Steven,

I've configed another db and other sites are using it ok.

It's only on this site and with one query I'm seeing the error.

jenny


-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 12:06
To: CF-Talk
Subject: RE: help! cgi.global


Jennifer,

Looks like your database for client variables wasn't configured.  If you
go into the CF Administrator there should be an option to create the
tables you need.

Steve


-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 6:58 AM
To: CF-Talk
Subject: help! cgi.global


I've just moved a site to a new server and I've set up a separate
database
for the client variable store.

I changed the value in my application.cfm, but I'm getting the following
error on some pages:

Error Executing Database Query.[Macromedia][SQLServer JDBC
Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific
sequence
of files included or processed is:
C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm

So the application is still looking for the tables in the old location.

How do i solve this please?

Thanks, Jenny







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231083
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


ms sql - delete records where older than 6 months

2006-02-02 Thread Protoculture
How would I finish the following sql statement to delete all records older than 
6 months?

delete * from mytable_fav_cvs
where date_set 
..



cheers

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231084
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: ms sql - delete records where older than 6 months

2006-02-02 Thread DURETTE, STEVEN J \(AIT\)
Delete from mytable_fav_cvs
Where date_set  dateAdd(m, -6, getDate())

SHOULD delete every thing that is before 6 months from today.



-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 6:13 AM
To: CF-Talk
Subject: ms sql - delete records where older than 6 months


How would I finish the following sql statement to delete all records
older than 6 months?

delete * from mytable_fav_cvs
where date_set 
...



cheers



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231085
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: help! cgi.global

2006-02-02 Thread DURETTE, STEVEN J \(AIT\)
Is the default storage mechanism for Client sessions set to the right db
in the Administrator?

Or is this some other table named Cglobal?  I'm assuming it is dealing
with client sessions because of the name of the table.

Steve


-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 7:09 AM
To: CF-Talk
Subject: RE: help! cgi.global


Hi Steven,

I've configed another db and other sites are using it ok.

It's only on this site and with one query I'm seeing the error.

jenny


-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 12:06
To: CF-Talk
Subject: RE: help! cgi.global


Jennifer,

Looks like your database for client variables wasn't configured.  If
you
go into the CF Administrator there should be an option to create the
tables you need.

Steve


-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 6:58 AM
To: CF-Talk
Subject: help! cgi.global


I've just moved a site to a new server and I've set up a separate
database
for the client variable store.

I changed the value in my application.cfm, but I'm getting the
following
error on some pages:

Error Executing Database Query.[Macromedia][SQLServer JDBC
Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific
sequence
of files included or processed is:
C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm

So the application is still looking for the tables in the old
location.

How do i solve this please?

Thanks, Jenny









~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231086
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: ms sql - delete records where older than 6 months

2006-02-02 Thread Adrian Lynch
Something like:

WHERE DATEDIFF(m, date_set)  5

Test the boundary cases though, dates can get you in trouble :O)

Ade

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 11:13
To: CF-Talk
Subject: ms sql - delete records where older than 6 months


How would I finish the following sql statement to delete all records older
than 6 months?

delete * from mytable_fav_cvs
where date_set
...



cheers


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231087
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: ms sql - delete records where older than 6 months

2006-02-02 Thread Protoculture
great, guys thanks. 

Forgot I could use DateAdd to actually subtract.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231088
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: help! cgi.global

2006-02-02 Thread Jennifer Gavin-Wear
found the answer .. i'm stupid ;)

was calling on a ms sql query that referred to the cglobal table .. duh

thanks for the help :-)


-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 12:21
To: CF-Talk
Subject: RE: help! cgi.global


Is the default storage mechanism for Client sessions set to the right db
in the Administrator?

Or is this some other table named Cglobal?  I'm assuming it is dealing
with client sessions because of the name of the table.

Steve


-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 7:09 AM
To: CF-Talk
Subject: RE: help! cgi.global


Hi Steven,

I've configed another db and other sites are using it ok.

It's only on this site and with one query I'm seeing the error.

jenny


-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 12:06
To: CF-Talk
Subject: RE: help! cgi.global


Jennifer,

Looks like your database for client variables wasn't configured.  If
you
go into the CF Administrator there should be an option to create the
tables you need.

Steve


-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 6:58 AM
To: CF-Talk
Subject: help! cgi.global


I've just moved a site to a new server and I've set up a separate
database
for the client variable store.

I changed the value in my application.cfm, but I'm getting the
following
error on some pages:

Error Executing Database Query.[Macromedia][SQLServer JDBC
Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific
sequence
of files included or processed is:
C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm

So the application is still looking for the tables in the old
location.

How do i solve this please?

Thanks, Jenny











~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231089
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 Restarting itself

2006-02-02 Thread Robertson-Ravo, Neil (RX)
All,

Anyone had any strange behaviour where CF restarts (crashes) itself now and
again (which causes a windows DMP)? Can't seem to find anything within the
logs of either CF or Java.

This is on a CF Server Config with the following hotfixes;

hf45343_611.jar
hf55681_61.jar
hf56580_611.jar
hf56991_611.jar
hf59763_611.jar
hf59915_611.jar
hf59993_611.jar
jrun-hotfix-57510-updater4.jar

Thanks

..neil


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

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231090
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: Bluedragon 6.1

2006-02-02 Thread Adam Haskell
They used to have a nice graphic that explained how Railo could run. After a
quick run through the site I don't see it anywhere. I think I agree with
chirs: 1 web server document root directory.

I'll explain it how it would work where I work. We have a nice big box that
we use and it runs Jboss application server. Inside of that we run 10
instances of CFMX 7. This allows each department to use the same box, less
hardware and few MX licenses. Since each department has thier own instance
of CF running it keeps each department, theoretically, from messing up each
others websites.

So if we got the professional version:
200 Euro
+ 9 extra webs = 1,100 Euro

Enterprise Version:
1,600 Euro.

In USD that's about 250 for one instance + 125 per each additional instance
and about 2,000 for the enterprise. Remember though these figures could be a
bit lower or higher depending on how much the conversion over to euro was at
the time and the broker fee ect. I like to use XE.com to get my estimates.

The way they are licensing Railo is different than many j2ee apps. Most j2ee
apps are licensed per CPU. Railo seems to be going per instance. In
comparison since our servers are quad processors we have to have 2 licenses
per server from Adobe (but we can launch as many instances as we want).
Where as we would only need 1 license from Railo for the server but if we
wanted to deploy a bunch of instances we may go for the enterprise license
as opposed to the professional licence. At least that is my understanding
Gert, of course, could mean something completely different and I could be
completely wrong.

Adam

Adam H

On 2/1/06, Rick Faircloth [EMAIL PROTECTED] wrote:

 Just so I understand better...Railo essentially replaces
 the CF server itself and processes pages, etc., like
 the server?

 Also, I asked earlier about Railo's pricing...Gert mentioned
 that the cost for the Professional version would be
 100 euros which would handle one web...  I was trying to
 find out if he ment one website or one web server.

 Can you provide an answer?  Not many details on the
 Railo site... (hint, hint, Gert...)

 Thanks,

 Rick


  -Original Message-
  From: Adam Haskell [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, February 01, 2006 7:30 PM
  To: CF-Talk
  Subject: Re: Bluedragon 6.1
 
 
  I just want to give a thumbs up for Railo. I've been tinkering around
 with
  it since one of the alphas quite a while back. Its a great little
 engine.
  I've been working with Model-Glue in it for a little while runs
  like a champ
  from what I've seen.  I plan on putting reactor on it some time later
 this
  week and run some tests  I'll blog about it when I get some results back
  about it.
 
  Adam H
 
  On 2/1/06, Gert Franz [EMAIL PROTECTED] wrote:
  
   Hi Andy,
  
   Why don't you give Railo a try...
   The free community version can be redistributed.
  
   www.railo.ch
  
   cfgreetings name=Gert Franz from=[EMAIL PROTECTED]
   location=switzerland function=railo core developer
  
  
  
   -Ursprüngliche Nachricht-
   Von: Andy Jarrett [mailto:[EMAIL PROTECTED]
   Gesendet: Mittwoch, 1. Februar 2006 11:41
   An: CF-Talk
   Betreff: Re: Bluedragon 6.1
  
  
   I want to set up a cheap CF server, in a commercial enviorment, though
   the [internal] site won't acutally be generating any money. under the
   new 6.2 licence this will break the licence agreement
  
  
  
  
  
   On 31/01/06, Rick Root [EMAIL PROTECTED] wrote:
Andy Jarrett wrote:
 Hi,

 Does anybody have a copy of BD 6.1 (the free edition) which they
 could let me download please?
   
Technically speaking, that would be illegal because you cannot
redistribute the free edition.
   
That being said, why would you want 6.1?  Many bugs.
   
Rick
   
   
   
  
  
  
  
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231091
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: Migrating app version 2.0

2006-02-02 Thread Katz, Dov B \(IT\)
You might want to consider using the All Tasks-Export Data from the
Enterprise manager in MSSQL and send the data to an ODBC datasource you
can set up to point to your Mysql server.

 

-Original Message-
From: Baz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 6:01 AM
To: CF-Talk
Subject: Migrating app version 2.0

Hi,

We just finished V2.0 of one of our client's apps, which included a
complete re-factoring of code from procedural to CFC, upgraded
functionality, and a significantly modified DB.

Since the changes are major, we will be deploying the new app on a new
domain, and, once we're ready, we will switch the dns to there. (rather
than just overwriting existing files on the existing domain)

Everything seems easy enough except for the database part of it. Since
it was majorly changed, we will create a new MySQL5 DB on the new
domain, and migrate all the data from the current MS-SQL server.

Does anyone have any tips, suggestions, gotchas for doing this? Should I
do it through CF by creating scripts that query the old DB and insert in
the new?  How do I access a remote DB in CF? Are there better ways,
tools?

Thanks for any help,

Baz







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231092
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: looking for a hosting company to resell

2006-02-02 Thread Mike Kear
Yes thanks.  I did look at them and they're on my list of about 10 companies
to check into further.

Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com


On 2/2/06, ColdFusion [EMAIL PROTECTED] wrote:

 Mike,

 Did you look at coldfusion-mx-hosting?
 They offer CFMX 7, unlimited pop/webmail,
 Plans include 10 or more domains for a single
 Plan and can be increased.




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231093
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 Restarting itself

2006-02-02 Thread Robertson-Ravo, Neil (RX)
To note obviously this is happening at the Core system level such as JVM or
O/S itself, this is also on Java 1.4.2_08_b03

N





-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 12:38
To: CF-Talk
Subject: CF Restarting itself

All,

Anyone had any strange behaviour where CF restarts (crashes) itself now and
again (which causes a windows DMP)? Can't seem to find anything within the
logs of either CF or Java.

This is on a CF Server Config with the following hotfixes;

hf45343_611.jar
hf55681_61.jar
hf56580_611.jar
hf56991_611.jar
hf59763_611.jar
hf59915_611.jar
hf59993_611.jar
jrun-hotfix-57510-updater4.jar

Thanks

..neil


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



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231094
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: Bluedragon 6.1

2006-02-02 Thread Rick Faircloth
Thanks for the explanation, Adam...

So, for me, running a single webserver (1 processor) hosting
about 20 sites, only one instance of CF...I would only need
the professional version about $250 USD to host the 20 sites...

Right?


 -Original Message-
 From: Adam Haskell [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 7:58 AM
 To: CF-Talk
 Subject: Re: Bluedragon 6.1


 They used to have a nice graphic that explained how Railo could
 run. After a
 quick run through the site I don't see it anywhere. I think I agree with
 chirs: 1 web server document root directory.

 I'll explain it how it would work where I work. We have a nice
 big box that
 we use and it runs Jboss application server. Inside of that we run 10
 instances of CFMX 7. This allows each department to use the same box, less
 hardware and few MX licenses. Since each department has thier own instance
 of CF running it keeps each department, theoretically, from
 messing up each
 others websites.

 So if we got the professional version:
 200 Euro
 + 9 extra webs = 1,100 Euro

 Enterprise Version:
 1,600 Euro.

 In USD that's about 250 for one instance + 125 per each
 additional instance
 and about 2,000 for the enterprise. Remember though these figures
 could be a
 bit lower or higher depending on how much the conversion over to
 euro was at
 the time and the broker fee ect. I like to use XE.com to get my estimates.

 The way they are licensing Railo is different than many j2ee
 apps. Most j2ee
 apps are licensed per CPU. Railo seems to be going per instance. In
 comparison since our servers are quad processors we have to have
 2 licenses
 per server from Adobe (but we can launch as many instances as we want).
 Where as we would only need 1 license from Railo for the server but if we
 wanted to deploy a bunch of instances we may go for the enterprise license
 as opposed to the professional licence. At least that is my understanding
 Gert, of course, could mean something completely different and I could be
 completely wrong.

 Adam

 Adam H

 On 2/1/06, Rick Faircloth [EMAIL PROTECTED] wrote:
 
  Just so I understand better...Railo essentially replaces
  the CF server itself and processes pages, etc., like
  the server?
 
  Also, I asked earlier about Railo's pricing...Gert mentioned
  that the cost for the Professional version would be
  100 euros which would handle one web...  I was trying to
  find out if he ment one website or one web server.
 
  Can you provide an answer?  Not many details on the
  Railo site... (hint, hint, Gert...)
 
  Thanks,
 
  Rick
 
 
   -Original Message-
   From: Adam Haskell [mailto:[EMAIL PROTECTED]
   Sent: Wednesday, February 01, 2006 7:30 PM
   To: CF-Talk
   Subject: Re: Bluedragon 6.1
  
  
   I just want to give a thumbs up for Railo. I've been tinkering around
  with
   it since one of the alphas quite a while back. Its a great little
  engine.
   I've been working with Model-Glue in it for a little while runs
   like a champ
   from what I've seen.  I plan on putting reactor on it some time later
  this
   week and run some tests  I'll blog about it when I get some
 results back
   about it.
  
   Adam H
  
   On 2/1/06, Gert Franz [EMAIL PROTECTED] wrote:
   
Hi Andy,
   
Why don't you give Railo a try...
The free community version can be redistributed.
   
www.railo.ch
   
cfgreetings name=Gert Franz from=[EMAIL PROTECTED]
location=switzerland function=railo core developer
   
   
   
-Ursprüngliche Nachricht-
Von: Andy Jarrett [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 1. Februar 2006 11:41
An: CF-Talk
Betreff: Re: Bluedragon 6.1
   
   
I want to set up a cheap CF server, in a commercial
 enviorment, though
the [internal] site won't acutally be generating any money.
 under the
new 6.2 licence this will break the licence agreement
   
   
   
   
   
On 31/01/06, Rick Root [EMAIL PROTECTED] wrote:
 Andy Jarrett wrote:
  Hi,
 
  Does anybody have a copy of BD 6.1 (the free edition) which they
  could let me download please?

 Technically speaking, that would be illegal because you cannot
 redistribute the free edition.

 That being said, why would you want 6.1?  Many bugs.

 Rick



   
   
   
   
  
  
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231095
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: Bluedragon 6.1

2006-02-02 Thread Rick Faircloth
Thanks for the explanation, Chris!

I'll have to give Railo a try!

Rick


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 4:47 AM
 To: CF-Talk
 Subject: RE: Bluedragon 6.1


  Just so I understand better...Railo essentially
  replaces
  the CF server itself and processes pages, etc.,
  like
  the server?

 Correct.

  Also, I asked earlier about Railo's
  pricing...Gert mentioned
  that the cost for the Professional version
  would be
  100 euros which would handle one web...  I was
  trying to
  find out if he ment one website or one web
  server.

 Actually I think it was EUR 200,- for the basic version
 including 1 web, and
 EUR 100,- for each additional web. But, I haven't looked at the
 prices for some
 time. ;-)

 As far as I understood it from discussions during a presentation here in
 Germany, you can translate 1 web to 1 web server document root
 directory.
 Could again be translated to 1 domain or 1 virtual host.

 Gert, please correct me, if I am wrong here!

  Can you provide an answer?  Not many details on
  the
  Railo site... (hint, hint, Gert...)

 True. Definitely. But, I know the guys are very busy with their
 software, and
 they have repeatedly postponed the relaunch of their own site in order to
 satisfy CFML developer requests. As long as I can get an answer
 vial email, I
 personally prefer it this way. ;-)

 Best

 Chris


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231096
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


404 instead of 200 HTTP Header

2006-02-02 Thread Uwe Degenhardt
Hi list
on a test-environment
I want to change HTTP-Headers
(for search engine optimization).
When I access a page which
isn't there like:
http://193.110.7.61/lkjsdlfj.cfm
instead of getting a 404 HTTP header
we get a 200 header from IIS.
How can I force IIS to give
back the right http-header ?
We have Win2000/2003 and CFMX 6.1.

Thanks !

Uwe



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231097
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: 404 instead of 200 HTTP Header

2006-02-02 Thread James Holmes
Create a sitewide missing template handler and use CFHEADER in it.

On 2/2/06, Uwe Degenhardt [EMAIL PROTECTED] wrote:
 Hi list
 on a test-environment
 I want to change HTTP-Headers
 (for search engine optimization).

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231098
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: Disable Verity on Linux?

2006-02-02 Thread Thomas Chiverton
On Tuesday 31 January 2006 16:05, Jason wrote:
 2732(k2index)   /opt/coldfusionmx7/verity/k
 /opt/coldfusionmx7/verity/k2
 /opt/coldfusionmx7/verity/k2/_ilnx21/bin/k2index -ualias
   ColdFusionK2_indexserver1
 Any ideas?

Check the parent process ID.

-- 

Tom Chiverton 
Advanced ColdFusion Programmer

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231099
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: Ralio (was Re: Bluedragon 6.1)

2006-02-02 Thread Thomas Chiverton
On Thursday 02 February 2006 00:40, Jordan Michaels wrote:
 I look forward to seeing what Ralio is going for (in USD) when the new
 site is up.

I look forward to the Ralio guys configuring their web site correctly.
I just died with a timeout, and told me all about their code:

Message  Communication link failure: railo.runtime.exp.PageRuntimeException, 
request is run into a timeout and has been stopped
  Context  The Error Occurred in
/usr/virtual/railoch/public_html/jmuffin/data/struct/index.cfm: line 57
called from /usr/virtual/railoch/public_html/en/index.cfm: line 4
  Code  55: /cfscriptcfif url.treeID EQ 0cfquery name=tmp 
datasource=#application.datasource# username=#application.userName# 
password=#application.passWord#
 56: select treeID from area,tree 
 57: where area.code='#area#' 
 58: and tree.parentID=0
 59: and area.areaID=tree.areaID
 
  Java Stacktrace
  railo.runtime.exp.DatabaseException: Communication link failure: 
railo.runtime.exp.PageRuntimeException, request is run into a timeout and has 
been stopped
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1862)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1831)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:896)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
at com.mysql.jdbc.Connection.(Connection.java:432)
at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at railo.runtime.config.Config.getConnection(Unknown Source)
at railo.runtime.db.ConnectionPool.get(Unknown Source)
at railo.runtime.db.Manager.getConnection(Unknown Source)
at railo.runtime.tag.Query.a(Unknown Source)
at railo.runtime.tag.Query.doEndTag(Unknown Source)
at 
jmuffin.data.struct.index_cfm.call(jmuffin.data.struct.index_cfm:287)
at railo.runtime.PageContext.include(Unknown Source)
at railo.runtime.PageContext.include(Unknown Source)
at en.index_cfm.call(en.index_cfm:37)
at railo.runtime.PageContext.include(Unknown Source)
at railo.runtime.PageContext.execute(Unknown Source)
at railo.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source)
at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at 
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:578)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at 
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
at java.lang.Thread.run(Thread.java:534)

-- 

Tom Chiverton 
Advanced ColdFusion Programmer


SQL Encapsulation?

2006-02-02 Thread Baz
Like any other code, there are times when portions of your SQL queries need
to be re-used or duplicated. A common example is having a method that
returns a COUNT of a query based on some conditions, and having another
method that returns some rows from that query. For instance:

*** getCount() ***
SELECT 
Count(OrderID) as OrderIDCount
FROM 
OrderTable INNER JOIN 
StatusTable ON (OrderTable.OrderID= StatusTable.OrderID)
WHERE 
(whatever)

*** getRows() ***
SELECT TOP 50
   OrderID, StatusID
FROM 
OrderTable INNER JOIN 
StatusTable ON (OrderTable.OrderID= StatusTable.OrderID)
WHERE 
(whatever)

In the preceding code, the FROM clause is repeated in both methods, as is
the WHERE clause. 

Now in a real-world complex app, that FROM would actually be 10-15 lines
long, and the WHERE could have hundreds of lines of complex logic based on
passed in arguments. Plus you may need not 2, but 5, 10, 20 methods using
the same FROM and/or WHERE and/or SELECT.

So my question is how do people handle this? If you had 15 methods with
complex WHERE and FROM clauses that are repeated intermittently, and then
something changes, it's an error-prone hassle to copy paste all the affected
sections.

Thoughts?

Baz




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231101
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: Ralio (was Re: Bluedragon 6.1)

2006-02-02 Thread Ray Champagne
This probably would have been better sent to them first, dontcha think? 
  I mean, a site shouldn't be set up so that one can glean info from 
their error messages, but I think you should let them know about the 
problem before posting the info to a public forum.

Thomas Chiverton wrote:
 On Thursday 02 February 2006 00:40, Jordan Michaels wrote:
 I look forward to seeing what Ralio is going for (in USD) when the new
 site is up.
 
 I look forward to the Ralio guys configuring their web site correctly.
 I just died with a timeout, and told me all about their code:
 
 Message  Communication link failure: railo.runtime.exp.PageRuntimeException, 
 request is run into a timeout and has been stopped
   Context  The Error Occurred in
 /usr/virtual/railoch/public_html/jmuffin/data/struct/index.cfm: line 57
 called from /usr/virtual/railoch/public_html/en/index.cfm: line 4
   Code  55: /cfscriptcfif url.treeID EQ 0cfquery name=tmp 
 datasource=#application.datasource# username=#application.userName# 
 password=#application.passWord#
  56: select treeID from area,tree 
  57: where area.code='#area#' 
  58: and tree.parentID=0
  59: and area.areaID=tree.areaID
  
   Java Stacktrace
   railo.runtime.exp.DatabaseException: Communication link failure: 
 railo.runtime.exp.PageRuntimeException, request is run into a timeout and has 
 been stopped
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1862)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1831)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:896)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
 at com.mysql.jdbc.Connection.(Connection.java:432)
 at 
 com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171)
 at railo.runtime.config.Config.getConnection(Unknown Source)
 at railo.runtime.db.ConnectionPool.get(Unknown Source)
 at railo.runtime.db.Manager.getConnection(Unknown Source)
 at railo.runtime.tag.Query.a(Unknown Source)
 at railo.runtime.tag.Query.doEndTag(Unknown Source)
 at 
 jmuffin.data.struct.index_cfm.call(jmuffin.data.struct.index_cfm:287)
 at railo.runtime.PageContext.include(Unknown Source)
 at railo.runtime.PageContext.include(Unknown Source)
 at en.index_cfm.call(en.index_cfm:37)
 at railo.runtime.PageContext.include(Unknown Source)
 at railo.runtime.PageContext.execute(Unknown Source)
 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source)
 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
 at 
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
 at 
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
 at 
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
 at 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
 at 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
 at 
 org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
 at 
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
 at 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
 at 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
 at 
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
 at 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
 at 
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
 at 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
 at 
 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:578)
 at 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
 at 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
 at 
 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
 at 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
 at 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
 at 
 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
 at 
 org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
 at 
 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
 at 
 

RE: Coldfusion and Active Directory

2006-02-02 Thread Dawson, Michael
Yes, this can be done with CF and LDAP.  It seems that, even though some
fields are optional, the fields that *are* populated are *all* required,
right?  If so, then you need an AND filter.

So that means you can simply build a dynamic filter string like this:

cfset filter = ((objectClass=user)

cfset filter = filter  ([EMAIL PROTECTED])

cfset filter = filter  (sn=MyLastName)

cfset filter = filter  )

Of course, you would need some logic to decide how to build the actual
filter.  This should work great for you.  Just watch the nesting of the
parenthesis.

M!ke 

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 01, 2006 2:42 AM
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

All the fields are optional. 

E.G. 

A user could fill in the name and e-mail fields on their first search
and just the cn name field on their next search. 

That is the functionality that needs to be in the filter, just needed to
know if this can be done with LDAP and Coldfusion ?

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 31 January 2006 16:45
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

First, we need to know which fields are optional or required.  I don't
see anything wrong with this LDAP filter.

It says:
MUST BE
objectClass = user
AND
sAMAccountName = form.sAMAccountName
AND
cn = form.cn
AND
title = form.title
AND
email = form.email

For this filter to work, you must specify a valid value for each of
these attributes of or you will not get any results.

Are you sure you want to filter on the title?  What if someone doesn't
type the title correctly?  You may need to use a wildcard in your filter
and let them search for a partial match.

If you have optional fields, then you would need to dynamically build
your LDAP filter string and leave those fields out.

M!ke 

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 31, 2006 9:48 AM
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

I have a form to search the Active Diretory shown below, searching the
account name, name, title, e-mail and telephone number attributes for an
Intranet Phone Directory
 
How can I modify the filter query of the CFLDAP statement to cater for
this ?
 
filter=((objectClass=user)(sAMAccountName=#Form.sAMAccountName#)(cn=#F
orm.cn#)(title=#Form.title#)(email=#Form.email#))
 
I have tried using | instead of  but that just brings back all results
??
 
 
cfform method=POST action=cfldap1.cfm name=form 
 
cfinput type=text name=sAMAccountName size=22 br cfinput
type=text name=cn size=22 br cfinput type=text name=title
size=22 br cfinput type=text name=email size=22 br input
type=image src=search.gif border=0 style=cursor:hand
width=49 height=18
/cfform





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231103
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: Can you do this in SQL using CF?

2006-02-02 Thread Phill B
I have some processes that work on 100's of thousands of records
daily. What they do is important but only parts of the processes are
done in a way that needs logging. So, instead of filling my
transaction log with all of these events and requiring a large
transaction log, I would rather ignore some of the process.

One thing I have done is use the truncate command to delete all the
records in a temp table. It helps but I want to reduce the logging
even more.

Oh yeah, I'm also a bit of a freak. :-\

On 2/1/06, Jim Wright [EMAIL PROTECTED] wrote:
 There are certain operations with the bcp utility which can be minimally
 logged, but I don't know of any way to not log general database
 activityit kind of defeats the purpose of having the transaction log.
 Why would you want to do that?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231104
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


Verity titles

2006-02-02 Thread Ray Champagne
Where do the titles on the search results come from for non-html pages? 
  I'm seeing my pdfs, ppts, docs, etc all there, with weird titles that 
don't (seemingly) show up in the text anywhere.

Thanks,

Ray

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231105
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


SQL and IDArray

2006-02-02 Thread Charlie Hanlon
I rec'd an email regarding an error with one of my apps, here is the SQL error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 8: Incorrect syntax near 
'IDArray'. 


SQL = SELECT someFields

  FROM myTable i 

 WHERE i.uniqueID = '' IDArray[index] ''  

Data Source = myDSN



Was someone trying to tamper with my app and if so, what are the implications 
of IDArray.

thanks in advance for some insight into this.

charlie hanlon



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231106
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


CFDOCUMENT repeating table headers

2006-02-02 Thread Rich Ziade
Hi all:

 

I'd like to display a multi-page report that repeats the table headers in
PDF format. Is this possible? I've played around with cfdocumentitem 
cfdocumentsection and beyond simple headers  footers, it seems pretty
difficult.

 

The behavior looks like its perceiving each ITEM as it's own markup?

 

Thanks,
Rich



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231107
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: Ralio (was Re: Bluedragon 6.1)

2006-02-02 Thread Russ
You're right, they should have set up better error messages, but there isn't
anything really useful that you can glean from this error message... 

 -Original Message-
 From: Ray Champagne [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 9:31 AM
 To: CF-Talk
 Subject: Re: Ralio (was Re: Bluedragon 6.1)
 
 This probably would have been better sent to them first, dontcha think?
   I mean, a site shouldn't be set up so that one can glean info from
 their error messages, but I think you should let them know about the
 problem before posting the info to a public forum.
 
 Thomas Chiverton wrote:
  On Thursday 02 February 2006 00:40, Jordan Michaels wrote:
  I look forward to seeing what Ralio is going for (in USD) when the new
  site is up.
 
  I look forward to the Ralio guys configuring their web site correctly.
  I just died with a timeout, and told me all about their code:
 
  Message  Communication link failure:
 railo.runtime.exp.PageRuntimeException,
  request is run into a timeout and has been stopped
Context  The Error Occurred in
  /usr/virtual/railoch/public_html/jmuffin/data/struct/index.cfm: line 57
  called from /usr/virtual/railoch/public_html/en/index.cfm: line 4
Code  55: /cfscriptcfif url.treeID EQ 0cfquery name=tmp
  datasource=#application.datasource# username=#application.userName#
  password=#application.passWord#
   56: select treeID from area,tree
   57: where area.code='#area#'
   58: and tree.parentID=0
   59: and area.areaID=tree.areaID
 
Java Stacktrace
railo.runtime.exp.DatabaseException: Communication link failure:
  railo.runtime.exp.PageRuntimeException, request is run into a timeout
 and has
  been stopped
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1862)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1831)
  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:896)
  at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
  at com.mysql.jdbc.Connection.(Connection.java:432)
  at
 
 com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
  at java.sql.DriverManager.getConnection(DriverManager.java:512)
  at java.sql.DriverManager.getConnection(DriverManager.java:171)
  at railo.runtime.config.Config.getConnection(Unknown Source)
  at railo.runtime.db.ConnectionPool.get(Unknown Source)
  at railo.runtime.db.Manager.getConnection(Unknown Source)
  at railo.runtime.tag.Query.a(Unknown Source)
  at railo.runtime.tag.Query.doEndTag(Unknown Source)
  at
  jmuffin.data.struct.index_cfm.call(jmuffin.data.struct.index_cfm:287)
  at railo.runtime.PageContext.include(Unknown Source)
  at railo.runtime.PageContext.include(Unknown Source)
  at en.index_cfm.call(en.index_cfm:37)
  at railo.runtime.PageContext.include(Unknown Source)
  at railo.runtime.PageContext.execute(Unknown Source)
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown
 Source)
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
 
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
 onFilterChain.java:284)
  at
 
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
 Chain.java:204)
  at
 
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.
 java:257)
  at
 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCont
 ext.java:151)
  at
 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567
 )
  at
 
 org.apache.catalina.core.StandardContextValve.invokeInternal(StandardConte
 xtValve.java:245)
  at
 
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.
 java:199)
  at
 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCont
 ext.java:151)
  at
 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567
 )
  at
 
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1
 84)
  at
 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCont
 ext.java:151)
  at
 
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
 64)
  at
 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCont
 ext.java:149)
  at
 
 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:578)
  at
 
 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCont
 ext.java:149)
  at
 
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567
 )
  at
 
 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
 va:156)
  at
 
 

RE: Coldfusion and Active Directory

2006-02-02 Thread Ian Vaughan
That's correct, even though the fields are optional, when some of the
fields are populated fields all are required.

Could you explain what you mean by

you would need some logic to decide how to build the actual filter.

Do you mean setting variables called filter below

cfset filter = ((objectClass=user)
cfset filter = filter  (mail=#form.mail#)
cfset filter = filter  (sn=#form.sn#)
Etc..


Then in the ldap query in the filter field just have

cfldap action=query
...
filter=#filter#  
...
..




 

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 14:35
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

Yes, this can be done with CF and LDAP.  It seems that, even though some
fields are optional, the fields that *are* populated are *all* required,
right?  If so, then you need an AND filter.

So that means you can simply build a dynamic filter string like this:

cfset filter = ((objectClass=user)

cfset filter = filter  ([EMAIL PROTECTED])

cfset filter = filter  (sn=MyLastName)

cfset filter = filter  )

Of course, you would need some logic to decide how to build the actual
filter.  This should work great for you.  Just watch the nesting of the
parenthesis.

M!ke 

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 2:42 AM
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

All the fields are optional. 

E.G. 

A user could fill in the name and e-mail fields on their first search
and just the cn name field on their next search. 

That is the functionality that needs to be in the filter, just needed to
know if this can be done with LDAP and Coldfusion ?

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 31 January 2006 16:45
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

First, we need to know which fields are optional or required.  I don't
see anything wrong with this LDAP filter.

It says:
MUST BE
objectClass = user
AND
sAMAccountName = form.sAMAccountName
AND
cn = form.cn
AND
title = form.title
AND
email = form.email

For this filter to work, you must specify a valid value for each of
these attributes of or you will not get any results.

Are you sure you want to filter on the title?  What if someone doesn't
type the title correctly?  You may need to use a wildcard in your filter
and let them search for a partial match.

If you have optional fields, then you would need to dynamically build
your LDAP filter string and leave those fields out.

M!ke 

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 31, 2006 9:48 AM
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

I have a form to search the Active Diretory shown below, searching the
account name, name, title, e-mail and telephone number attributes for an
Intranet Phone Directory
 
How can I modify the filter query of the CFLDAP statement to cater for
this ?
 
filter=((objectClass=user)(sAMAccountName=#Form.sAMAccountName#)(cn=#F
orm.cn#)(title=#Form.title#)(email=#Form.email#))
 
I have tried using | instead of  but that just brings back all results
??
 
 
cfform method=POST action=cfldap1.cfm name=form 
 
cfinput type=text name=sAMAccountName size=22 br cfinput
type=text name=cn size=22 br cfinput type=text name=title
size=22 br cfinput type=text name=email size=22 br input
type=image src=search.gif border=0 style=cursor:hand
width=49 height=18
/cfform




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231109
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: Bluedragon 6.1

2006-02-02 Thread Jeff Peters
New Atlanta has always said Blue Dragon Server will always be free for
development and production.  Blue Dragon JX, J2EE, and .Net are their
pay-for-play CFML products.

David McCan wrote:
 Last time I looked, the free version of Blue Dragon was still available on 
 the New Atlanta ftp site:

 ftp://ftp.newatlanta.com

 For how long?

 David

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231110
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: Bluedragon 6.1

2006-02-02 Thread Robertson-Ravo, Neil (RX)
It is only free for non-commercial use (non-ssl).



-Original Message-
From: Jeff Peters [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 15:28
To: CF-Talk
Subject: Re: Bluedragon 6.1

New Atlanta has always said Blue Dragon Server will always be free for
development and production.  Blue Dragon JX, J2EE, and .Net are their
pay-for-play CFML products.

David McCan wrote:
 Last time I looked, the free version of Blue Dragon was still available on
the New Atlanta ftp site:

 ftp://ftp.newatlanta.com

 For how long?

 David

 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:23
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: Ralio (was Re: Bluedragon 6.1)

2006-02-02 Thread Thomas Chiverton
On Thursday 02 February 2006 00:40, Jordan Michaels wrote:
 I look forward to seeing what Ralio is going for (in USD) when the new
 site is up.

I look forward to the Ralio guys configuring their web site correctly.
I just died with a timeout, and told me all about their code:

Message  Communication link failure: railo.runtime.exp.PageRuntimeException, 
request is run into a timeout and has been stopped
  Context  The Error Occurred in
/usr/virtual/railoch/public_html/jmuffin/data/struct/index.cfm: line 57
called from /usr/virtual/railoch/public_html/en/index.cfm: line 4
  Code  55: /cfscriptcfif url.treeID EQ 0cfquery name=tmp 
datasource=#application.datasource# username=#application.userName# 
password=#application.passWord#
 56: select treeID from area,tree 
 57: where area.code='#area#' 
 58: and tree.parentID=0
 59: and area.areaID=tree.areaID 

-- 

Tom Chiverton 
Advanced ColdFusion Programmer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231112
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: Ralio (was Re: Bluedragon 6.1)

2006-02-02 Thread Robertson-Ravo, Neil (RX)
Yeah...it eats jmuffins




-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 15:34
To: CF-Talk
Subject: Re: Ralio (was Re: Bluedragon 6.1)

On Thursday 02 February 2006 00:40, Jordan Michaels wrote:
 I look forward to seeing what Ralio is going for (in USD) when the new
 site is up.

I look forward to the Ralio guys configuring their web site correctly.
I just died with a timeout, and told me all about their code:

Message  Communication link failure: railo.runtime.exp.PageRuntimeException,

request is run into a timeout and has been stopped
  Context  The Error Occurred in
/usr/virtual/railoch/public_html/jmuffin/data/struct/index.cfm: line 57
called from /usr/virtual/railoch/public_html/en/index.cfm: line 4
  Code  55: /cfscriptcfif url.treeID EQ 0cfquery name=tmp 
datasource=#application.datasource# username=#application.userName# 
password=#application.passWord#
 56: select treeID from area,tree 
 57: where area.code='#area#' 
 58: and tree.parentID=0
 59: and area.areaID=tree.areaID 

-- 

Tom Chiverton 
Advanced ColdFusion Programmer




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231113
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: Bluedragon 6.1

2006-02-02 Thread Robertson-Ravo, Neil (RX)
On a side, do we really need another CFML parsing engine? I mean what is the
MO here?






-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 15:19
To: CF-Talk
Subject: RE: Bluedragon 6.1

It is only free for non-commercial use (non-ssl).



-Original Message-
From: Jeff Peters [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 15:28
To: CF-Talk
Subject: Re: Bluedragon 6.1

New Atlanta has always said Blue Dragon Server will always be free for
development and production.  Blue Dragon JX, J2EE, and .Net are their
pay-for-play CFML products.

David McCan wrote:
 Last time I looked, the free version of Blue Dragon was still available on
the New Atlanta ftp site:

 ftp://ftp.newatlanta.com

 For how long?

 David

 





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231114
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: Coldfusion and Active Directory

2006-02-02 Thread Ian Vaughan
That's correct, even though the fields are optional, when some of the
fields are populated fields all are required.

Could you explain what you mean by

you would need some logic to decide how to build the actual filter.

Do you mean setting variables called filter below

cfset filter = ((objectClass=user)
cfset filter = filter  (mail=#form.mail#) 
cfset filter = filter  (sn=#form.sn#) 
Etc..


Then in the ldap query in the filter field just have

cfldap action=query

filter=#filter#  

...




-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2006 14:35
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

Yes, this can be done with CF and LDAP.  It seems that, even though some
fields are optional, the fields that *are* populated are *all* required,
right?  If so, then you need an AND filter.

So that means you can simply build a dynamic filter string like this:

cfset filter = ((objectClass=user)

cfset filter = filter  ([EMAIL PROTECTED])

cfset filter = filter  (sn=MyLastName)

cfset filter = filter  )

Of course, you would need some logic to decide how to build the actual
filter.  This should work great for you.  Just watch the nesting of the
parenthesis.

M!ke 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231115
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: Credit Card Merchant questions.

2006-02-02 Thread J W
I have have used Authorize.net in the past. I like it. I have no experience
with payflow. Although, for this client I am going to need a merchant
account and a gateway together. I have contacted verisign, who is now an
EBAY company and is being wrapped up into PAYPAL. They have a
merchant/gateway solution called Website Payments Pro. It seems like a good
substitute for Payflow pro.

Anyone had any experience with Website Payments Pro for PAypal/Verisign..

Jeff


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231116
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: Bluedragon 6.1

2006-02-02 Thread Rick Faircloth
Who not?  Competition seems good, especially if a competent
competitor has a price of $250 instead of $1250...

Why do you think it would be a negative to have another engine?

Rick

 -Original Message-
 From: Robertson-Ravo, Neil (RX)
 [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 10:25 AM
 To: CF-Talk
 Subject: RE: Bluedragon 6.1
 
 
 On a side, do we really need another CFML parsing engine? I mean 
 what is the
 MO here?
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231117
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: Migrating app version 2.0

2006-02-02 Thread David Livingston
Here is what has worked for me in the past when I migrate MS-SQL DBs  
to Postgres which is pretty similar to MySQL. Export out a script of  
your db structure using Enterprise Manager. Edit the script and  
remove any MS-SQL specific stuff. Find out which data types need to  
have different names (ex. int vs. integer) and do a find and replace  
on them then run the script on your MySQL box to create the table  
structures. Now go to your MS-SQL box and create an ODBC connection  
to your MySQL DB. Then use Enterprise Manager's export function (DTS)  
to push all of the data over to the new box.
That is a very basic explanation, there will be some other things  
that you will need to figure out like if you have stored procedures,  
dates are usually different, and auto-incrementing id's. I hope that  
at least gets you started in the right direction.

Dave



On Feb 2, 2006, at 7:01 AM, Katz, Dov B ((IT)) wrote:

 You might want to consider using the All Tasks-Export Data from the
 Enterprise manager in MSSQL and send the data to an ODBC datasource  
 you
 can set up to point to your Mysql server.



 -Original Message-
 From: Baz [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 6:01 AM
 To: CF-Talk
 Subject: Migrating app version 2.0

 Hi,

 We just finished V2.0 of one of our client's apps, which included a
 complete re-factoring of code from procedural to CFC, upgraded
 functionality, and a significantly modified DB.

 Since the changes are major, we will be deploying the new app on a new
 domain, and, once we're ready, we will switch the dns to there.  
 (rather
 than just overwriting existing files on the existing domain)

 Everything seems easy enough except for the database part of it. Since
 it was majorly changed, we will create a new MySQL5 DB on the new
 domain, and migrate all the data from the current MS-SQL server.

 Does anyone have any tips, suggestions, gotchas for doing this?  
 Should I
 do it through CF by creating scripts that query the old DB and  
 insert in
 the new?  How do I access a remote DB in CF? Are there better ways,
 tools?

 Thanks for any help,

 Baz







 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231118
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: Ralio (was Re: Bluedragon 6.1)

2006-02-02 Thread Munson, Jacob
 I just died with a timeout.

Hmm, you timed out...is that similar to a heart attack?  I guess you
can't answer that anyway if you're dead.


-


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231119
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: SQL and IDArray

2006-02-02 Thread Munson, Jacob
Why would someone try to hack your site and then email you the error
they received?  Seems counter productive.

 -Original Message-
 From: Charlie Hanlon [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 02, 2006 8:04 AM
 To: CF-Talk
 Subject: SQL and IDArray
 
 I rec'd an email regarding an error with one of my apps, here 
 is the SQL error:
 
 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 8: 
 Incorrect syntax near 'IDArray'. 
 
 
 SQL = SELECT someFields
 
   FROM myTable i 
 
  WHERE i.uniqueID = '' IDArray[index] ''  
 
 Data Source = myDSN
 
 
 
 Was someone trying to tamper with my app and if so, what are 
 the implications of IDArray.
 
 thanks in advance for some insight into this.

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231120
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


Anyone tried Ben Forta's CF/Flex Example?

2006-02-02 Thread Ryan Guill
Hey guys,

I installed all of the new flex beta stuff (except for the enterprise
services) and have tried Ben Forta's cf/flex example and cant get it
to work.

The example is here:

http://labs.macromedia.com/wiki/index.php/ColdFusion/Flex_Connectivity:Samples:Phone_Selector

At first I was getting this error:

Error: code:InvokeFailed string:'Error: Unknown destination
'ColdFusion'.' detail:'Couldn't establish a connection to
'ColdFusion''
   at 
mx.rpc::AbstractInvoker/http://www.macromedia.com/2005/flex/mx/internal::invoke()
   at 
mx.rpc.remoting.mxml::Operation/http://www.macromedia.com/2005/flex/mx/internal::invoke()
   at mx.rpc.remoting::Operation/send()
   at mx.rpc.remoting.mxml::Operation/send()
   at 
mx.rpc::AbstractService/http://www.macromedia.com/2005/actionscript/flash/proxy::callProperty()
   at Main/___Application1_creationComplete()
   at flash.events::EventDispatcher/dispatchEvent()
   at mx.core::UIComponent/mx.core:UIComponent::dispatchCreationCompleteEvent()
   at 
mx.core::UIComponent$/http://www.macromedia.com/2005/flex/mx/internal::dispatchCreationCompleteEvents()
   at 
mx.managers::LayoutManager/mx.managers:LayoutManager::doPhasedInstantiation()
   at mx.core::UIComponent/mx.core:UIComponent::callLaterDispatcher2()
   at mx.core::UIComponent/mx.core:UIComponent::callLaterDispatcher()

But I found this other article:

http://labs.macromedia.com/wiki/index.php/ColdFusion/Flex_Connectivity

Which told me to add this line to the compiler arguments:

--services=C:\CFusionMX7\wwwroot\WEB-INF\flex\flex-enterprise-services.xml

Doing so gets rid of the error, but it still doesnt work, the
busyCursor just sits there and nothing is ever loaded.

Has anyone got it to work at all, especially if you have seen this
error and got around it?

I followed the instructions to the letter as far as I can tell, twice now.

thanks,

--
Ryan Guill
BlueEyesDevelopment
[EMAIL PROTECTED]
www.ryanguill.com
(270) 217.2399
got google talk?  Chat me at [EMAIL PROTECTED]

The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com

Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/

www.ryanguill.com/
The Roman Empire: www.ryanguill.com/blog/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231121
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: Bluedragon 6.1

2006-02-02 Thread Aaron Roberson
Multiple CFML engines can become problematic when their creators begin
to introduce a plethora of new proprietary tags and lack support for
common tags. HTML would have seen it's demise a long time ago if the
W3C was never formed to create standards that browser companies are
practically obligated to conform to.

I don't know how or in what fashion, but I think a consortium should
be formed to govern the CFML tag base. Then it would be up to Adobe,
New Atlanta, and the folks from Railo to conform to the standards set
up by the CFML consortium.

What do you think?

-Aaron

On 2/2/06, Rick Faircloth [EMAIL PROTECTED] wrote:
 Who not?  Competition seems good, especially if a competent
 competitor has a price of $250 instead of $1250...

 Why do you think it would be a negative to have another engine?

 Rick

  -Original Message-
  From: Robertson-Ravo, Neil (RX)
  [mailto:[EMAIL PROTECTED]
  Sent: Thursday, February 02, 2006 10:25 AM
  To: CF-Talk
  Subject: RE: Bluedragon 6.1
 
 
  On a side, do we really need another CFML parsing engine? I mean
  what is the
  MO here?
 



 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231122
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: SQL and IDArray

2006-02-02 Thread Charlie Hanlon
I may not have been clear.  My global error handler sends the emails to my 
address.  My sites throw errors, I fix them.  In this case, I noticed the 
WHERE i.uniqueID = '' IDArray[index] '' within the error message that I 
rec'd.  I am assuming that the site visitor substituted IDArray[index] where 
the url.id would have been, something like

mypage.cfm?id=40

mypage.cfm?id=IDArray[index]

I have added a cfqueryparam to the sql statement, but am inquiring as to 
wheter this was an attempted hack

charlie



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231123
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] Spring br / Conference 2006

2006-02-02 Thread David Hannum
Spring br / Conference 2006
Thursday, March 23, 2006
Athens, Ohio

Well, it's that time of year again.  Spring br / Conference 2006 is ready
to rock-n-roll!  The Southeast Ohio Macromedia User Group (SEOMUG), in
partnership with the IT Alliance of Appalachian Ohio (ITAAO), Ohio
University and Adobe Systems is proud to present our fourth annual
conference.  And it's going to be the best yet.  Ed Sullivan, director of
User Group Relations for Adobe Systems states, Spring Break is one of the
better user group regional events in existence.  The speakers and sessions
are second to none and the conference price is unmatched in the industry.

This year's event will be held in the state of the art Walter Hall, on the
beautiful campus of Ohio University in Athens, Ohio.

Register Online: www.seomug.org/conference.cfm

This year's lineup includes 24 sessions in the following 4 tracks:
Designing  User Experience
Programming  Development
3D Gaming
Adobe  Related Products
(see complete session descriptions: www.seomug.org/sessions.cfm)

This year, we've added two Hands On sessions.  Something you'll usually
only find at the larger corporate conferences!

Presenters this year include:
Rob Gonda (Ajax Technology)
Carolyn Snyder (User Experience)
Brian Windsor (3D Gaming)
Glenda Vigoreaux (Dreamweaver)
Phillip Kerman (Flash/Author)
Joe Lowery (Dreamweaver/Author)
Neil Ross (ColdFusion)
Laura Kerbyson (Gaming/Flash)
Dan Dura (ActionScript)
John Cummings (ColdFusion)
Gary Kraeger(Enterprise Email)
More . . .
(see presenters bios:  www.seomug.org/bios.cfm)


Register Online: www.seomug.org/conference.cfm

This year's Key Note will be by Adobe Systems' Tim Buntel.  Tim is a
colorful Sr. Product Manager for Adobe.  He'll also be giving the
presentation at the Lunchtime session:

In addition, we'll have the Vendor Expo, were you can meet up with some of
the leading companies in the IT industry.

Upon your request, we'll provide you a free wireless account for the day.
Or, feel free to stop by the Wireless Cafe powered by Dell, and check your
email on some of the latest machines Dell is producing today!

As always, we'll have the Conference Bookstore powered by Folletts, where
you can purchase titles relating to the day's sessions for a whopping 30%
off!

Register Online: www.seomug.org/conference.cfm

The cost for all the day's activities is $25.  Yes, that's right - and that
cost includes your lunch!  Students are $15 with lunch and $5 without lunch
(valid Student ID required at check-in).

If you are traveling, we've worked out special rates at the Ohio University
Inn and Conference Center as well as the AmeriHost Inn  Suites  here in
Athens.  Just follow the Lodging Deals link on the conference website.
www.seomug.org/lodging.cfm

Complete maps and directions are also available on the website:
www.seomug.org/directions.cfm

The first 100 people to register will receive an 18oz. Spring br /
Conference 2006 Latte Mug!

If you have any questions, you may call our Frontline Help Desk at (740)
597-8000 for more information.

We hope to see you there!

Kind Regards,
Dave Hannum
SEOMUG Manager
Conference Chair
===
www.seomug.org

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231124
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: Bluedragon 6.1

2006-02-02 Thread Rick Faircloth
I certainly agree that it would great to have some standards.
However, I would be willing to work around some of the
differences to save 80% of the cost...but the added features
above the standards would be what separates the
new providers of CFML engines from the established.  The
new features (that should go above standards, no in place of)
and lower cost is what brings in the money.

I'd certainly give Railo a shot at earning my $250 to upgrade
from my current and happily functioning CF version 4.5.2
before I'd give Adobe another $750 or so for an upgrade...

Rick

 -Original Message-
 From: Aaron Roberson [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 11:12 AM
 To: CF-Talk
 Subject: Re: Bluedragon 6.1
 
 
 Multiple CFML engines can become problematic when their creators begin
 to introduce a plethora of new proprietary tags and lack support for
 common tags. HTML would have seen it's demise a long time ago if the
 W3C was never formed to create standards that browser companies are
 practically obligated to conform to.
 
 I don't know how or in what fashion, but I think a consortium should
 be formed to govern the CFML tag base. Then it would be up to Adobe,
 New Atlanta, and the folks from Railo to conform to the standards set
 up by the CFML consortium.
 
 What do you think?
 
 -Aaron
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231125
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


AW: Bluedragon 6.1

2006-02-02 Thread Gert Franz
Hi guys,

sorry I was ill the past couple of days. Well in fact you can use one
Webroot with the professional version of Railo. I'm sure you could
argue, that with the Coldfusion standard edition you can set up as many
Webroots as you like, but we can offer a Railo Administrator (with own
datasources, Custom Tags, Mappings, Security-Settings for each Web). So
on the same server you can use many different Railos, each configured
differently. Like the J2EE Version of CFMX.
With the Enterprise version of Railo you can configure as many webs as
you like.
Unlike CFMX Railo uses shared ressources, so that the ressource
consumption is much lower.

You can check our website for updates and documentation in the next few
weeks.

Regards

Gert Franz

Customer Support
[EMAIL PROTECTED]
www.railo.ch
Meet us at CeBIT 2006
Hall 3, Stand D39
March 09-15, 2006
Hannover Germany



-Ursprüngliche Nachricht-
Von: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Gesendet: Mittwoch, 1. Februar 2006 17:30
An: CF-Talk
Betreff: RE: Bluedragon 6.1


Gert,

When you write one Web for the Professional version, are you referring
to web servers or websites?

Rick


 -Original Message-
 From: Gert Franz [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 01, 2006 11:03 AM
 To: CF-Talk
 Subject: AW: Bluedragon 6.1


 Hi Andy,

 The File you downloaded is one of our last Betas. We will release 
 Railo in the next couple of Weeks. Railo Supports Fusebox up to 4.1, 
 Mach II and Model Glue Frameworks. Some CMS already have been tested 
 sucessfully.

 Pricing looks something like this:
 Developer, Community Version is free. (No CFX, No Search, 1 Datasource

 per Web) Professional Version 200€ including one Web. Every further 
 web 100€ Enterprise Version 1600€ unlimited webs.

 Check out www.railo.ch for the next two weeks to find out when we 
 release Railo.

 Regards

 Gert Franz

 Customer Support
 [EMAIL PROTECTED]
 www.railo.ch
 Meet us at CeBIT 2006
 Hall 3, Stand D39
 March 09-15, 2006
 Hannover Germany


 -Ursprüngliche Nachricht-
 Von: Andy Jarrett [mailto:[EMAIL PROTECTED]
 Gesendet: Mittwoch, 1. Februar 2006 16:42
 An: CF-Talk
 Betreff: Re: Bluedragon 6.1


 Cheers Gert. Im downloading now. My only hold up is that it seems to 
 be in beta still and im looking for a fully fledged engine. With that 
 said im still gonna give it a go :o)

 What are you future plans with railo in the way of pricing are you 
 planning on keeping this free?





 On 01/02/06, Gert Franz [EMAIL PROTECTED] wrote:
  Hi Andy,
 
  Why don't you give Railo a try...
  The free community version can be redistributed.
 
  www.railo.ch
 
  cfgreetings name=Gert Franz from=[EMAIL PROTECTED] 
  location=switzerland function=railo core developer
 
 
 
  -Ursprüngliche Nachricht-
  Von: Andy Jarrett [mailto:[EMAIL PROTECTED]
  Gesendet: Mittwoch, 1. Februar 2006 11:41
  An: CF-Talk
  Betreff: Re: Bluedragon 6.1
 
 
  I want to set up a cheap CF server, in a commercial enviorment, 
  though

  the [internal] site won't acutally be generating any money. under 
  the new 6.2 licence this will break the licence agreement
 
 
 
 
 
  On 31/01/06, Rick Root [EMAIL PROTECTED] wrote:
   Andy Jarrett wrote:
Hi,
   
Does anybody have a copy of BD 6.1 (the free edition) which they

could let me download please?
  
   Technically speaking, that would be illegal because you cannot 
   redistribute the free edition.
  
   That being said, why would you want 6.1?  Many bugs.
  
   Rick
  
  
  
 
 
 
 



 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231126
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: Possible to determine search engine rankings with CF?

2006-02-02 Thread Rick Faircloth
Hi, Brian...

Just thought I'd let you know that I did install the trial version
of Web CEO.  Generally good performance, but in a critical
area, I'm getting ranking reports for keywords that say the
site doesn't rank, when in fact it ranks 2nd and 12th for two
different keywords when manually searched.

Not good...that seems to be the general problem I've had
with automated ranking programs, which led me to the original
question of building something with CF that I could depend on.

btw, I've emailed Web CEO about the problem...

Rick

 -Original Message-
 From: Brian Peddle [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 01, 2006 1:59 PM
 To: CF-Talk
 Subject: RE: Possible to determine search engine rankings with CF?
 
 
 http://www.webceo.com/  offers a free tool that is really good.
 
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, February 01, 2006 1:50 PM
 To: CF-Talk
 Subject: Possible to determine search engine rankings with CF?
 
 Hi, all...
 
 Is there a way to use CF to determine what
 a particular website's ranking is on a search engine?
 In particular Google, Yahoo, and MSN?
 
 I'm starting to do a lot of search engine optimization work
 and would like an automated way to determine a website's
 rankings at any particular time, rather than having to
 type in a search phrase and look through the results...
 
 Thanks,
 
 Rick
 
 
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231127
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


AW: Bluedragon 6.1

2006-02-02 Thread Gert Franz
Yes

You can use the community version in any way you like with the
limitation of one datasource and no cfx-tags and no search.

Gert

-Ursprüngliche Nachricht-
Von: Andy Jarrett [mailto:[EMAIL PROTECTED] 
Gesendet: Mittwoch, 1. Februar 2006 19:33
An: CF-Talk
Betreff: Re: Bluedragon 6.1


Cheers Gert, I've been playing around and it looks good.

To echo's Rick's comments, when you say one web, is that one website or
one web server?

Also will the community edition be allowed to be used for commercial
purposes (keeping within the one datasource rule?)

Cheers

Andy J
On 01/02/06, Rick Faircloth [EMAIL PROTECTED] wrote:
 Gert,

 When you write one Web for the Professional version, are you 
 referring to web servers or websites?

 Rick




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231128
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: Coldfusion and Active Directory

2006-02-02 Thread Dawson, Michael
I was thinking something like:

cfset filter = ((objectClass=user)

cfif len(trim(form.email))
  cfset filter = filter  (mail=#form.email#)
/cfif

cfif len(trim(form.lastName))
  cfset filter = filter  (sn=#form.lastName#)
/cfif

cfset filter = filter  ) 

Then, cfldap ... filter=#filter# ...

M!ke

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 9:20 AM
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

That's correct, even though the fields are optional, when some of the
fields are populated fields all are required.

Could you explain what you mean by

you would need some logic to decide how to build the actual filter.

Do you mean setting variables called filter below

cfset filter = ((objectClass=user)
cfset filter = filter  (mail=#form.mail#) cfset filter = filter 
(sn=#form.sn#) Etc..


Then in the ldap query in the filter field just have

cfldap action=query

filter=#filter#  

...




 

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 14:35
To: CF-Talk
Subject: RE: Coldfusion and Active Directory

Yes, this can be done with CF and LDAP.  It seems that, even though some
fields are optional, the fields that *are* populated are *all* required,
right?  If so, then you need an AND filter.

So that means you can simply build a dynamic filter string like this:

cfset filter = ((objectClass=user)

cfset filter = filter  ([EMAIL PROTECTED])

cfset filter = filter  (sn=MyLastName)

cfset filter = filter  )

Of course, you would need some logic to decide how to build the actual
filter.  This should work great for you.  Just watch the nesting of the
parenthesis.

M!ke 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231129
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: File upload using AJAX

2006-02-02 Thread Doug Bedient
That's pretty cool. Have you tried converting yet?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231130
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


Comcast blacklisting solutions?

2006-02-02 Thread Ray Champagne
We have several clients that use our mail forwarding to simply send any 
mail that they get from their site to their Comcast account.  Lately, 
we've been getting LOTS of blacklisting problems.  Seems that Comcast 
doesn't like it when we forward email from, say [EMAIL PROTECTED] to 
[EMAIL PROTECTED]  The messages bounce back to the sender saying that 
they are blacklisted.  We then have to get the domain un-blacklisted 
through Comcast, which takes forever and a day.  Three days later, the 
domain is blacklisted again.  Anyone running into similar problems, 
and/or have any ideas on ho to fix this, other than stopping the 
forwarding?  We have over 100 clients using this forwarding feature, and 
it would be a logistical nightmare to change them all over to a full 
mail setup.

Thanks,

Ray

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231131
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


AW: Bluedragon 6.1

2006-02-02 Thread Gert Franz
Yes you're right,

We sell only J2EE versions running on any Java Application server. The
biggest advantage of the enterprise version is, that you have a server
administrator, where you can set up things like:
- global datasources for all railo-webs
- global mappings
- global custom tags
- global cfx tags
- global security settings or individual for each web

With every version of railo you can set up JSP and Railo Tag libraries
and Railo function libraries. You don't need to use the cfimport tag in
each cfm-file. Once globally defined, you can use it anywhere.

I would advise anyone who wants to run more than 5-10 different webs,
that he should buy the enterprise version, in order to manage all webs
from a central point (server administrator).
If you use the professional version, you only have for instance 9 single
railos... With no server administrator.

Hope this helps.

Regards

Gert Franz

Customer Support
[EMAIL PROTECTED]
www.railo.ch
Meet us at CeBIT 2006
Hall 3, Stand D39
March 09-15, 2006
Hannover Germany

-Ursprüngliche Nachricht-
Von: Adam Haskell [mailto:[EMAIL PROTECTED] 
Gesendet: Donnerstag, 2. Februar 2006 13:58
An: CF-Talk
Betreff: Re: Bluedragon 6.1


They used to have a nice graphic that explained how Railo could run.
After a quick run through the site I don't see it anywhere. I think I
agree with
chirs: 1 web server document root directory.

I'll explain it how it would work where I work. We have a nice big box
that we use and it runs Jboss application server. Inside of that we run
10 instances of CFMX 7. This allows each department to use the same box,
less hardware and few MX licenses. Since each department has thier own
instance of CF running it keeps each department, theoretically, from
messing up each others websites.

So if we got the professional version:
200 Euro
+ 9 extra webs = 1,100 Euro

Enterprise Version:
1,600 Euro.

In USD that's about 250 for one instance + 125 per each additional
instance and about 2,000 for the enterprise. Remember though these
figures could be a bit lower or higher depending on how much the
conversion over to euro was at the time and the broker fee ect. I like
to use XE.com to get my estimates.

The way they are licensing Railo is different than many j2ee apps. Most
j2ee apps are licensed per CPU. Railo seems to be going per instance. In
comparison since our servers are quad processors we have to have 2
licenses per server from Adobe (but we can launch as many instances as
we want). Where as we would only need 1 license from Railo for the
server but if we wanted to deploy a bunch of instances we may go for the
enterprise license as opposed to the professional licence. At least that
is my understanding Gert, of course, could mean something completely
different and I could be completely wrong.

Adam

Adam H


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231132
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


AW: Bluedragon 6.1

2006-02-02 Thread Gert Franz
In fact only, if they are below a certain webroot.

The problem with CFMX is, that you can see all the Customtags and
Databases if you use one global CF installation. To separate these from
another we use Railo webs, each one differently configurable.
In your case you could use a professional version with a switch in your
application.cfm having all your applications stored below your webroot,
or (the better way) you could use the enterprise version with as many
webroots as you like...

Cheers Gert

-Ursprüngliche Nachricht-
Von: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Gesendet: Donnerstag, 2. Februar 2006 14:18
An: CF-Talk
Betreff: RE: Bluedragon 6.1


Thanks for the explanation, Adam...

So, for me, running a single webserver (1 processor) hosting about 20
sites, only one instance of CF...I would only need the professional
version about $250 USD to host the 20 sites...

Right?


 -Original Message-
 From: Adam Haskell [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 7:58 AM
 To: CF-Talk
 Subject: Re: Bluedragon 6.1


 They used to have a nice graphic that explained how Railo could run. 
 After a quick run through the site I don't see it anywhere. I think I 
 agree with
 chirs: 1 web server document root directory.

 I'll explain it how it would work where I work. We have a nice big box

 that we use and it runs Jboss application server. Inside of that we 
 run 10 instances of CFMX 7. This allows each department to use the 
 same box, less hardware and few MX licenses. Since each department has

 thier own instance of CF running it keeps each department, 
 theoretically, from messing up each
 others websites.

 So if we got the professional version:
 200 Euro
 + 9 extra webs = 1,100 Euro

 Enterprise Version:
 1,600 Euro.

 In USD that's about 250 for one instance + 125 per each additional 
 instance and about 2,000 for the enterprise. Remember though these 
 figures could be a
 bit lower or higher depending on how much the conversion over to
 euro was at
 the time and the broker fee ect. I like to use XE.com to get my
estimates.

 The way they are licensing Railo is different than many j2ee apps. 
 Most j2ee apps are licensed per CPU. Railo seems to be going per 
 instance. In comparison since our servers are quad processors we have 
 to have 2 licenses
 per server from Adobe (but we can launch as many instances as we
want).
 Where as we would only need 1 license from Railo for the server but if
we
 wanted to deploy a bunch of instances we may go for the enterprise
license
 as opposed to the professional licence. At least that is my
understanding
 Gert, of course, could mean something completely different and I could
be
 completely wrong.

 Adam

 Adam H

 On 2/1/06, Rick Faircloth [EMAIL PROTECTED] wrote:
 
  Just so I understand better...Railo essentially replaces the CF 
  server itself and processes pages, etc., like the server?
 
  Also, I asked earlier about Railo's pricing...Gert mentioned that 
  the cost for the Professional version would be 100 euros which 
  would handle one web...  I was trying to find out if he ment one 
  website or one web server.
 
  Can you provide an answer?  Not many details on the
  Railo site... (hint, hint, Gert...)
 
  Thanks,
 
  Rick
 
 
   -Original Message-
   From: Adam Haskell [mailto:[EMAIL PROTECTED]
   Sent: Wednesday, February 01, 2006 7:30 PM
   To: CF-Talk
   Subject: Re: Bluedragon 6.1
  
  
   I just want to give a thumbs up for Railo. I've been tinkering 
   around
  with
   it since one of the alphas quite a while back. Its a great little
  engine.
   I've been working with Model-Glue in it for a little while runs 
   like a champ from what I've seen.  I plan on putting reactor on it

   some time later
  this
   week and run some tests  I'll blog about it when I get some
 results back
   about it.
  
   Adam H
  
   On 2/1/06, Gert Franz [EMAIL PROTECTED] wrote:
   
Hi Andy,
   
Why don't you give Railo a try...
The free community version can be redistributed.
   
www.railo.ch
   
cfgreetings name=Gert Franz from=[EMAIL PROTECTED] 
location=switzerland function=railo core developer
   
   
   
-Ursprüngliche Nachricht-
Von: Andy Jarrett [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 1. Februar 2006 11:41
An: CF-Talk
Betreff: Re: Bluedragon 6.1
   
   
I want to set up a cheap CF server, in a commercial
 enviorment, though
the [internal] site won't acutally be generating any money.
 under the
new 6.2 licence this will break the licence agreement
   
   
   
   
   
On 31/01/06, Rick Root [EMAIL PROTECTED] wrote:
 Andy Jarrett wrote:
  Hi,
 
  Does anybody have a copy of BD 6.1 (the free edition) which 
  they could let me download please?

 Technically speaking, that would be illegal because you cannot

 redistribute the free edition.

 That being said, why would you want 6.1?  Many bugs.

 Rick

Information leakage (was: RE: Ralio (was Re: Bluedragon 6.1))

2006-02-02 Thread Dave Watts
 You're right, they should have set up better error messages, 
 but there isn't anything really useful that you can glean 
 from this error message... 

That's not entirely true. The error message indicates file paths, and that
they're using JDBC and MySQL. That's none of our business, and along with
other information may indicate potential attack paths.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231134
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: Bluedragon 6.1

2006-02-02 Thread Yves Arsenault
That is kind of an interesting approach

A small CF engine for one website. I can see some people may be
interested in this approach.

Yves

On 2/2/06, Gert Franz [EMAIL PROTECTED] wrote:
 Yes you're right,

 We sell only J2EE versions running on any Java Application server. The
 biggest advantage of the enterprise version is, that you have a server
 administrator, where you can set up things like:
 - global datasources for all railo-webs
 - global mappings
 - global custom tags
 - global cfx tags
 - global security settings or individual for each web

 With every version of railo you can set up JSP and Railo Tag libraries
 and Railo function libraries. You don't need to use the cfimport tag in
 each cfm-file. Once globally defined, you can use it anywhere.

 I would advise anyone who wants to run more than 5-10 different webs,
 that he should buy the enterprise version, in order to manage all webs
 from a central point (server administrator).
 If you use the professional version, you only have for instance 9 single
 railos... With no server administrator.

 Hope this helps.

 Regards

 Gert Franz

 Customer Support
 [EMAIL PROTECTED]
 www.railo.ch
 Meet us at CeBIT 2006
 Hall 3, Stand D39
 March 09-15, 2006
 Hannover Germany


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231135
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


MySQL 5 and CFMX7

2006-02-02 Thread Adkins, Randy
Does anyone have problems running MySQL 5 with CFMX 7?
 
I have CMFX 7 and MySQL 4.1 but now the ODBC connections
bomb out for the following error:
 
 Connection verification failed for data source: DEV_THISSITE
java.sql.SQLException: Communication failure during handshake. Is there
a server running on localhost:3306?
The root cause was that: java.sql.SQLException: Communication failure
during handshake. Is there a server running on localhost:3306?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231136
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: Comcast blacklisting solutions?

2006-02-02 Thread Emmet McGovern
Have you asked Comcast what their blacklist policy is?  What puts a domain
on a blacklist?  We had a similar situation here where the ISP was
overriding their filter for any domain with an SPF.  It was an easy solution
compared to the whitelisting request nightmare.

-e

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 11:46 AM
To: CF-Talk
Subject: Comcast blacklisting solutions?

We have several clients that use our mail forwarding to simply send any 
mail that they get from their site to their Comcast account.  Lately, 
we've been getting LOTS of blacklisting problems.  Seems that Comcast 
doesn't like it when we forward email from, say [EMAIL PROTECTED] to 
[EMAIL PROTECTED]  The messages bounce back to the sender saying that 
they are blacklisted.  We then have to get the domain un-blacklisted 
through Comcast, which takes forever and a day.  Three days later, the 
domain is blacklisted again.  Anyone running into similar problems, 
and/or have any ideas on ho to fix this, other than stopping the 
forwarding?  We have over 100 clients using this forwarding feature, and 
it would be a logistical nightmare to change them all over to a full 
mail setup.

Thanks,

Ray



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231137
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: Possible to determine search engine rankings with CF?

2006-02-02 Thread Brian Peddle
I've not had that issue, so far, with that tool.  Hopefully they will
respond and it's just a bug.  I've been using the free version for over a
year now with no issues.



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 11:35 AM
To: CF-Talk
Subject: RE: Possible to determine search engine rankings with CF?

Hi, Brian...

Just thought I'd let you know that I did install the trial version
of Web CEO.  Generally good performance, but in a critical
area, I'm getting ranking reports for keywords that say the
site doesn't rank, when in fact it ranks 2nd and 12th for two
different keywords when manually searched.

Not good...that seems to be the general problem I've had
with automated ranking programs, which led me to the original
question of building something with CF that I could depend on.

btw, I've emailed Web CEO about the problem...

Rick

 -Original Message-
 From: Brian Peddle [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 01, 2006 1:59 PM
 To: CF-Talk
 Subject: RE: Possible to determine search engine rankings with CF?
 
 
 http://www.webceo.com/  offers a free tool that is really good.
 
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, February 01, 2006 1:50 PM
 To: CF-Talk
 Subject: Possible to determine search engine rankings with CF?
 
 Hi, all...
 
 Is there a way to use CF to determine what
 a particular website's ranking is on a search engine?
 In particular Google, Yahoo, and MSN?
 
 I'm starting to do a lot of search engine optimization work
 and would like an automated way to determine a website's
 rankings at any particular time, rather than having to
 type in a search phrase and look through the results...
 
 Thanks,
 
 Rick
 
 
 
 
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231138
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: SQL Encapsulation?

2006-02-02 Thread Brian Peddle
I just rewrote a query as a test a few weeks ago that replaced what you have
below.  The search would query for a count first then grab the 50/100 etc
records to be displayed for paging.

When someone queried the whole database it was taking upwards of 50 seconds
to run both queries.

I moved them into a stored proc.  Queried the information and inserting it
into a temp table with an auto id.  Then I would query records 1-50, 51-100,
101-150 etc. depending where on the page the user was.

I also am able to do a quick count of records on that temp table to get
total records which is much after than essentially running same query twice.

The total time dropped to 13-22 seconds for the query.

I haven't tested under heavy load to see how the temp table stuff will hold
up but it could be one path to follow for you.

Maybe others have some thoughts on the temp table method.

-Original Message-
From: Baz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 9:25 AM
To: CF-Talk
Subject: SQL Encapsulation?

Like any other code, there are times when portions of your SQL queries need
to be re-used or duplicated. A common example is having a method that
returns a COUNT of a query based on some conditions, and having another
method that returns some rows from that query. For instance:

*** getCount() ***
SELECT 
Count(OrderID) as OrderIDCount
FROM 
OrderTable INNER JOIN 
StatusTable ON (OrderTable.OrderID= StatusTable.OrderID)
WHERE 
(whatever)

*** getRows() ***
SELECT TOP 50
   OrderID, StatusID
FROM 
OrderTable INNER JOIN 
StatusTable ON (OrderTable.OrderID= StatusTable.OrderID)
WHERE 
(whatever)

In the preceding code, the FROM clause is repeated in both methods, as is
the WHERE clause. 

Now in a real-world complex app, that FROM would actually be 10-15 lines
long, and the WHERE could have hundreds of lines of complex logic based on
passed in arguments. Plus you may need not 2, but 5, 10, 20 methods using
the same FROM and/or WHERE and/or SELECT.

So my question is how do people handle this? If you had 15 methods with
complex WHERE and FROM clauses that are repeated intermittently, and then
something changes, it's an error-prone hassle to copy paste all the affected
sections.

Thoughts?

Baz






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231139
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: Possible to determine search engine rankings with CF?

2006-02-02 Thread Rick Faircloth
I do hope this gets resolved...it's got a lot of features that
can help with my SEO work...from initial optimization to reporting.

Rick

 -Original Message-
 From: Brian Peddle [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 12:14 PM
 To: CF-Talk
 Subject: RE: Possible to determine search engine rankings with CF?
 
 
 I've not had that issue, so far, with that tool.  Hopefully they will
 respond and it's just a bug.  I've been using the free version for over a
 year now with no issues.
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231140
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: Bluedragon 6.1

2006-02-02 Thread Rick Faircloth
The problem I see with this is that I'm able to run
as many sites as I want with Adobe's CF Professional version
with a central administrative interface  for about $1250
($750 or so upgrade)...if I go to Railo's Enterprise
version to run many websites, then I'm paying around $2000...

What, then, is the Railo benefit?

Rick


 -Original Message-
 From: Gert Franz [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 11:58 AM
 To: CF-Talk
 Subject: AW: Bluedragon 6.1
 
 
 In fact only, if they are below a certain webroot.
 
 The problem with CFMX is, that you can see all the Customtags and
 Databases if you use one global CF installation. To separate these from
 another we use Railo webs, each one differently configurable.
 In your case you could use a professional version with a switch in your
 application.cfm having all your applications stored below your webroot,
 or (the better way) you could use the enterprise version with as many
 webroots as you like...
 
 Cheers Gert



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231141
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


Empty CFSELECT not possible when using XML forms?

2006-02-02 Thread Wim
CFSELECT name=TEST/CFSELECT generates an empty OPTION tag in the final 
HTML when using XML forms. How can I override this? I presume I have to edit 
the XML or XSLT files in order to fix this...?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231142
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


Radio buttons do not get the correct value

2006-02-02 Thread Wim
I'm working on an application with lots of radio buttons, and I think I have 
discovered a bug.

Both rows have the SECOND radio button selected when executing the following 
script, even though the FIRST one needs to be selected in the second row. What 
am I doing wrong?

The workaround is to make all values unique, but that's not what I want.




cfform action=test.cfm method=POST format=XML id=formname

cfformgroup type=horizontal label=First choice:
cfinput type=Radio name=fieldname_a value=firstselection checked=No 
label=0
cfinput type=Radio name=fieldname_a value=secondselection checked=Yes 
label=1
cfinput type=Radio name=fieldname_a value=thirdselection checked=No 
label=2
cfinput type=Radio name=fieldname_a value=fourthselection checked=No 
label=3
/cfformgroup

cfformgroup type=horizontal label=Second choice:
cfinput type=Radio name=fieldname_b value=firstselection checked=Yes 
label=0
cfinput type=Radio name=fieldname_b value=secondselection checked=No 
label=1
cfinput type=Radio name=fieldname_b value=thirdselection checked=No 
label=2
cfinput type=Radio name=fieldname_b value=fourthselection checked=No 
label=3
/cfformgroup

/cfform


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231143
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: Comcast blacklisting solutions?

2006-02-02 Thread Russ
We had blacklisting problems with AOL, but if you talk to them, you can get
on the loop (whitelist) and we haven't had problems since.  

 -Original Message-
 From: Emmet McGovern [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 12:11 PM
 To: CF-Talk
 Subject: RE: Comcast blacklisting solutions?
 
 Have you asked Comcast what their blacklist policy is?  What puts a domain
 on a blacklist?  We had a similar situation here where the ISP was
 overriding their filter for any domain with an SPF.  It was an easy
 solution
 compared to the whitelisting request nightmare.
 
 -e
 
 -Original Message-
 From: Ray Champagne [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 11:46 AM
 To: CF-Talk
 Subject: Comcast blacklisting solutions?
 
 We have several clients that use our mail forwarding to simply send any
 mail that they get from their site to their Comcast account.  Lately,
 we've been getting LOTS of blacklisting problems.  Seems that Comcast
 doesn't like it when we forward email from, say [EMAIL PROTECTED] to
 [EMAIL PROTECTED]  The messages bounce back to the sender saying that
 they are blacklisted.  We then have to get the domain un-blacklisted
 through Comcast, which takes forever and a day.  Three days later, the
 domain is blacklisted again.  Anyone running into similar problems,
 and/or have any ideas on ho to fix this, other than stopping the
 forwarding?  We have over 100 clients using this forwarding feature, and
 it would be a logistical nightmare to change them all over to a full
 mail setup.
 
 Thanks,
 
 Ray
 
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231144
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: Comcast blacklisting solutions?

2006-02-02 Thread Claude Schneegans
These so called black list are maintained by amateurs and are a source 
of a lot of problems.

We should all black list any server using a black list.
I used to have my mail managed by my provider who could refuse any mail 
from my customers
just because his provider had been black listed.
Then try to explain to him that it is HIS fault if I didn't answer his mail.

Now I manage myself my mail server.
I can still get black listed, but I get all my messages, from black 
listed server as well.

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


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231145
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


Anyone using Webhost4Life

2006-02-02 Thread Jason Rogoz
Hello
 
I was curious if anyone out there is using Webhost4Life for their hosting 
services.  We are looking at using them and hosting multiple domains under 
their Premium package.  
 
Jason


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca http://www.zoomcom.ca/ 
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231146
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


AW: Bluedragon 6.1

2006-02-02 Thread Gert Franz
As i mentioned in a post before. 
If you use CFMX you can not separate Webs from another. Every web can
see all the datasources, mappings and cfx-tags, and all security
settings are globally. If a user knows the datasource of another web, he
can access it. The only possibility you have is to define all
datasources with a readonly user and use the username and password
attribute of the cfquery-tag in order to control it.

There is no local administrator for all webs you have. And every web has
all ist settings defined in its own web-inf/railo/railo-web.xml (usable
for instance for export).

But i must admit, if you don't care about these security issues, then
CFMX is from a pricely point of view definitely the better choice...

Gert

-Ursprüngliche Nachricht-
Von: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Gesendet: Donnerstag, 2. Februar 2006 18:18
An: CF-Talk
Betreff: RE: Bluedragon 6.1


The problem I see with this is that I'm able to run
as many sites as I want with Adobe's CF Professional version with a
central administrative interface  for about $1250 ($750 or so
upgrade)...if I go to Railo's Enterprise version to run many websites,
then I'm paying around $2000...

What, then, is the Railo benefit?

Rick


 -Original Message-
 From: Gert Franz [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 11:58 AM
 To: CF-Talk
 Subject: AW: Bluedragon 6.1
 
 
 In fact only, if they are below a certain webroot.
 
 The problem with CFMX is, that you can see all the Customtags and 
 Databases if you use one global CF installation. To separate these 
 from another we use Railo webs, each one differently configurable. In 
 your case you could use a professional version with a switch in your 
 application.cfm having all your applications stored below your 
 webroot, or (the better way) you could use the enterprise version with

 as many webroots as you like...
 
 Cheers Gert





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231147
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: MySQL 5 and CFMX7

2006-02-02 Thread David Livingston
Have you tried one of the newer Mysql JDBC or ODBC drivers?

http://www.mysql.com/products/connector/j/
http://dev.mysql.com/downloads/connector/odbc/

Also check to see if Mysql is actually running on port 3306.

Dave

On Feb 2, 2006, at 11:07 AM, Adkins, Randy wrote:

 Does anyone have problems running MySQL 5 with CFMX 7?

 I have CMFX 7 and MySQL 4.1 but now the ODBC connections
 bomb out for the following error:

  Connection verification failed for data source: DEV_THISSITE
 java.sql.SQLException: Communication failure during handshake. Is  
 there
 a server running on localhost:3306?
 The root cause was that: java.sql.SQLException: Communication failure
 during handshake. Is there a server running on localhost:3306?


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231148
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: Information leakage (was: RE: Ralio (was Re: Bluedragon 6.1))

2006-02-02 Thread Russ
True, but at least it doesn't show the username and password, mostly because
they were smart and kept it in the application.cfm or something... but the
fact that the debugger shows that to the public is an issue, if someone for
example wasn't as smart and hardcoded those values in the cfquery tag... 

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 12:04 PM
 To: CF-Talk
 Subject: Information leakage (was: RE: Ralio (was Re: Bluedragon 6.1))
 
  You're right, they should have set up better error messages,
  but there isn't anything really useful that you can glean
  from this error message...
 
 That's not entirely true. The error message indicates file paths, and that
 they're using JDBC and MySQL. That's none of our business, and along with
 other information may indicate potential attack paths.
 
 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!
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231149
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: Radio buttons do not get the correct value

2006-02-02 Thread Brad Wood
Hmmm, interesting...  I noticed when viewing the source, that the first
AND second radio of each group both have the checked=checked in their
tag.

I think that is in fact a bug.  It works correctly for HTML and Flash
forms.

~Brad

-Original Message-
From: Wim [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 11:26 AM
To: CF-Talk
Subject: Radio buttons do not get the correct value

I'm working on an application with lots of radio buttons, and I think I
have discovered a bug.

Both rows have the SECOND radio button selected when executing the
following script, even though the FIRST one needs to be selected in the
second row. What am I doing wrong?

The workaround is to make all values unique, but that's not what I want.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231150
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


Coldfusion hash-map

2006-02-02 Thread Oleg Gunkin
Could anyone translate this pseudo code to coldfusion for me please? 


HashMap map = new HashMap();

map[a] = 1;
map[b] = 2;

for each key in map {
print 'a href=' + key + '' + map[key] + '/a';
}

Thank you. 

PS: I am asking that because I am really new in CF, and my boss leaves me no 
time for the proper research. I would really appreciate any help.

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231151
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: Coldfusion hash-map

2006-02-02 Thread Ian Skinner
quote
HashMap map = new HashMap();

map[a] = 1;
map[b] = 2;

for each key in map {
print 'a href=' + key + '' + map[key] + '/a';
}
/quote


Not sure this is a true HashMap but it would replicate your example.

cfscript
map = structNew();

map[a] = 1;
map[b] = 2;
/cfscript

cfloop list=#structKeyList(map)# index=key
a href=#map[key]##map[key]#/a
/cfloop

Response just typed into this email, watch out for syntax omissions and errors 
and all the usual caviats. 


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231152
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: Coldfusion hash-map

2006-02-02 Thread Adrian Lynch
cfset map = StructNew()
cfset map[a] = 1
cfset map[b] = 2

cfoutput

cfloop collection=#map# item=i
a href=#i##map[i]#/abr /
/cfloop

/cfoutput

Give that a blast.

Adrian

-Original Message-
From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 17:56
To: CF-Talk
Subject: Coldfusion hash-map


Could anyone translate this pseudo code to coldfusion for me please?


HashMap map = new HashMap();

map[a] = 1;
map[b] = 2;

for each key in map {
print 'a href=' + key + '' + map[key] + '/a';
}

Thank you.

PS: I am asking that because I am really new in CF, and my boss leaves me no
time for the proper research. I would really appreciate any help.

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231153
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: Bluedragon 6.1

2006-02-02 Thread Rick Faircloth
Thanks for the further explanation, Gert...

Rick

 -Original Message-
 From: Gert Franz [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 02, 2006 12:40 PM
 To: CF-Talk
 Subject: AW: Bluedragon 6.1
 
 
 As i mentioned in a post before. 
 If you use CFMX you can not separate Webs from another. Every web can
 see all the datasources, mappings and cfx-tags, and all security
 settings are globally. If a user knows the datasource of another web, he
 can access it. The only possibility you have is to define all
 datasources with a readonly user and use the username and password
 attribute of the cfquery-tag in order to control it.
 
 There is no local administrator for all webs you have. And every web has
 all ist settings defined in its own web-inf/railo/railo-web.xml (usable
 for instance for export).
 
 But i must admit, if you don't care about these security issues, then
 CFMX is from a pricely point of view definitely the better choice...
 
 Gert




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231154
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: Coldfusion hash-map

2006-02-02 Thread Brad Wood
Not sure this is a true HashMap but it would replicate your example.
One caveat would be that your struct name would always have to be a
valid cold fusion variable.

If a and b are more likely to be http://www.yahoo.com; then this
approach won't work. 

I would recommend a two-dimensional array.

~Brad

cfscript
map = structNew();

map[a] = 1;
map[b] = 2;
/cfscript

cfloop list=#structKeyList(map)# index=key
a href=#map[key]##map[key]#/a
/cfloop

Response just typed into this email, watch out for syntax omissions and
errors and all the usual caviats. 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231155
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: Coldfusion hash-map

2006-02-02 Thread Ian Skinner
Oops, I knew I forgot something.

Need some cfoutputs in my example.

cfscript
map = structNew();

map[a] = 1;
map[b] = 2;
/cfscript

cfoutput
cfloop list=#structKeyList(map)# index=key
a href=#map[key]##map[key]#/a
/cfloop
/cfoutput

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231156
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: Coldfusion hash-map

2006-02-02 Thread Adrian Lynch
cfset map = StructNew()
cfset map[http://www.yahoo.com;] = Something

cfoutput#map[http://www.yahoo.com]#/cfoutput

Will work. You're just forced to use [] rather than . notation.

Adrian

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 18:12
To: CF-Talk
Subject: RE: Coldfusion hash-map


Not sure this is a true HashMap but it would replicate your example.
One caveat would be that your struct name would always have to be a
valid cold fusion variable.

If a and b are more likely to be http://www.yahoo.com; then this
approach won't work. 

I would recommend a two-dimensional array.

~Brad

cfscript
map = structNew();

map[a] = 1;
map[b] = 2;
/cfscript

cfloop list=#structKeyList(map)# index=key
a href=#map[key]##map[key]#/a
/cfloop

Response just typed into this email, watch out for syntax omissions and
errors and all the usual caviats. 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231157
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: Coldfusion hash-map

2006-02-02 Thread Ian Skinner
Not sure this is a true HashMap but it would replicate your example. One 
caveat would be that your struct name would always have to be a valid cold 
fusion variable.

If a and b are more likely to be http://www.yahoo.com; then this approach 
won't work. 

I would recommend a two-dimensional array.

~Brad

While your two-dimensional array may very well be a better solution, I just 
wanted to point out that structure keys do not HAVE to be valid ColdFusion 
variables, if they are quote[|'] escaped.

The following test case shows this.

cfsilent
cfscript
map = structNew();

map[http://www.google.com;] = 1;
map['http://www.yahoo.com'] = 2;
/cfscript

/cfsilent!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN 
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /
titleStruct test/title
/head

body
cfoutput
cfloop list=#structKeyList(map)# index=key
a href=#key##map[key]#/a
/cfloop
/cfoutput
/body
/html


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231158
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: Coldfusion hash-map

2006-02-02 Thread Brad Wood
Could anyone translate this pseudo code to coldfusion for me please? 

Here is two implementations.  One uses a two dimension array, the other
uses a struct.  The trick with a struct is, that each key must be a
valid cold fusion variable name, so you can't really count on your data
to produce the struct names.

!--- array ---
cfset arr_hashmap[1][1] = address1
cfset arr_hashmap[1][2] = display2
cfset arr_hashmap[2][1] = address2
cfset arr_hashmap[2][2] = display2
cfset arr_hashmap[3][1] = address3
cfset arr_hashmap[3][2] = display3

!--- struct ---
cfset struct_hashmap.linkone.address = address1
cfset struct_hashmap.linkone.display = display1
cfset struct_hashmap.linktwo.address = address2
cfset struct_hashmap.linktwo.display = display2
cfset struct_hashmap.linkthree.address = address3
cfset struct_hashmap.linkthree.display = display3

cfoutput
!--- array ---
cfloop index=i from=1 to=#arraylen(arr_hashmap)#
step=1
a
href=#arr_hashmap[i][1]##arr_hashmap[i][2]#/abr
/cfloop [key].address##struct_hashmap[key].display#/abr
br
br
!--- struct ---
cfloop list=#structKeyList(struct_hashmap)# index=key
a href=#struct_hashmap
/cfloop
/cfoutput




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231159
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: Coldfusion hash-map

2006-02-02 Thread Brad Wood
Will work. You're just forced to use [] rather than . notation.

I stand corrected.  :)  I try not to do that though for personal coding
preference-- I had almost forgotten it was actually possible.

~Brad


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231160
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


Where is my nullpointerexception??? CFMX 6.1

2006-02-02 Thread Rick Root
I'm trying to debug an application that uses some java stuff and I'm 
getting a nullpointerexception error SOMEWHERE.

But I can't tell where, since CFMX reports no code snippets or line 
numbers or anything.

What do I do?

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231161
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: Coldfusion hash-map

2006-02-02 Thread Ian Skinner
I stand corrected.  :)  I try not to do that though for personal coding
preference-- I had almost forgotten it was actually possible.

~Brad

Just remember this lesson whenever one goes for a ColdFusion 
certification|re-certification.  In my experience they just love to throw in 
these kinds of alternate methods for solving a problem.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231162
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: Anyone tried Ben Forta's CF/Flex Example?

2006-02-02 Thread Bill Sahlas
I've set this up and have had success in compiling and running it.  I didn't do 
anything more then unzip the files to CFIDE/samples leaving the dir structure 
in tact giving me CFIDE/samples/Phone/Flex and CFIDE/samples/Phone/CF  

From a browser test that the CFCs have been installed and work.  Go to 
http://locahost:8500/CFIDE/samples/Phones/CF/test.cfm  

Note: one Gotcha here, if you've installed CFMX to IIS you'll want to make sure 
to update the flex-enterprise-services.xml and set the PORT on the end point 
url to your port - if its 80 then you'll have lt;endpoint 
uri=http://localhost:80{context.root}/flex2gateway/; 
class=flex.messaging.endpoints.AMFEndpoint/gt;


It's important that you your compiler args are set (I see that you've set 
them).  It's also important to double check that you're flex project path 
points to CFIDE/samples/Phones/Flex - Look at the project's properties:

Info: Path /Phones, Location: C:\Inetpub\wwwroot\CFIDE\samples\Phones\Flex
Flex Compiler: Additional compiler arguments: 
--services=C:\CFusionMX7\wwwroot\WEB-INF\flex\flex-enterprise-services.xml

After you double check that you should do a clean and build.  Make sure 
that your bin file is completely cleaned out.  Once you've finished rebuilding 
run the Main.html right in the built-in browser of Flex Builder 2. 

If that is what you did and it still doesn't work then we should be looking 
into cf error logs.  Let me know how it goes.

Bill

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231163
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: SQL Encapsulation?

2006-02-02 Thread Deanna Schneider
I'd go the cfc route, where I would instantiate a single CFC that would run
your base query with all your where and from clauses. Then, I'd have
multiple functions that would do query of query against that base query.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231164
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: Coldfusion hash-map

2006-02-02 Thread Oleg Gunkin
Using structs is great, except for one little glitch: item come out in order 
different from the order these items were added in. Is there a way to fix that 
and still use structs?

cfset sidenav = StructNew()
cfset sidenav[Calendar of Events] = #RootDir# 
cfset sidenav[Yukon Council] = #RootDir#  
cfset sidenav[Pacific Council] = #RootDir#
cfset sidenav[Management Community] = #RootDir#

cfoutputimg src=#RootDir#images/sidenav_logo-e.gif width=132 alt=YFC 
Logo //cfoutput

ul
cfoutput
cfloop collection=#sidenav# item=title
lia href=#sidenav[title]##title#/a/li
/cfloop
/cfoutput
/ul


the result is :

ul
lia href=/yfc2/Pacific Council/a/li
lia href=/yfc2/Yukon Council/a/li
lia href=/yfc2/Calendar of Events/a/li
lia href=/yfc2/Management Community/a/li
/ul


--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231165
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: Coldfusion hash-map

2006-02-02 Thread Nathan Strutz
Ooh, I want to try something I didn't see anyone else do...


cfscript
  map = structNew(); // actually, this is optional
  map.a = 1;
  map.b = 2;

  for (i in map) {
writeOutput('a href='  map[i]  ''  map[i]  '/a');
  }
/cfscript


On 2/2/06, Oleg Gunkin [EMAIL PROTECTED] wrote:
 Could anyone translate this pseudo code to coldfusion for me please?


 HashMap map = new HashMap();

 map[a] = 1;
 map[b] = 2;

 for each key in map {
 print 'a href=' + key + '' + map[key] + '/a';
 }

 Thank you.

 PS: I am asking that because I am really new in CF, and my boss leaves me no 
 time for the proper research. I would really appreciate any help.

 --
 Oleg Gunkin
 Email: [EMAIL PROTECTED]
 Phone: (604) 666-9392
 Emerging Technologies / Pacific Web Services
 Information Technology Services
 Public Works and Government Services Canada (Pacific)

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231166
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: File upload using AJAX

2006-02-02 Thread Phill B
I tried but I got side tracked with work. I would like to see what
some one comes up with.


On 2/2/06, Doug Bedient [EMAIL PROTECTED] wrote:
 That's pretty cool. Have you tried converting yet?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231167
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: Where is my nullpointerexception??? CFMX 6.1

2006-02-02 Thread Adrian Lynch
Manually track it down with cfabort, cfdump, cfoutput. Put tracer code
throughout the app's execution path and you'll see what's happening.

Adrian

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 18:32
To: CF-Talk
Subject: Where is my nullpointerexception??? CFMX 6.1


I'm trying to debug an application that uses some java stuff and I'm
getting a nullpointerexception error SOMEWHERE.

But I can't tell where, since CFMX reports no code snippets or line
numbers or anything.

What do I do?

Rick


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231168
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: Coldfusion hash-map

2006-02-02 Thread Brad Wood
Well, I guess you could use a query object with an item_sort column or
something if order matters.

A list retains its order, but you would need two separate lists with
matching items for the address and display, or a list within a list, but
then you would have to deal with escaping your delimiters. 

~Brad

-Original Message-
From: Oleg Gunkin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 02, 2006 12:49 PM
To: CF-Talk
Subject: RE: Coldfusion hash-map

Using structs is great, except for one little glitch: item come out in
order different from the order these items were added in. Is there a way
to fix that and still use structs?

cfset sidenav = StructNew()
cfset sidenav[Calendar of Events] = #RootDir# 
cfset sidenav[Yukon Council] = #RootDir#  
cfset sidenav[Pacific Council] = #RootDir#
cfset sidenav[Management Community] = #RootDir#

cfoutputimg src=#RootDir#images/sidenav_logo-e.gif width=132
alt=YFC Logo //cfoutput

ul
cfoutput
cfloop collection=#sidenav# item=title
lia href=#sidenav[title]##title#/a/li
/cfloop
/cfoutput
/ul


the result is :

ul
lia href=/yfc2/Pacific Council/a/li
lia href=/yfc2/Yukon Council/a/li
lia href=/yfc2/Calendar of Events/a/li
lia href=/yfc2/Management Community/a/li
/ul


--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231169
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: Comcast blacklisting solutions?

2006-02-02 Thread Ray Champagne
We're doing that right now.  About 4 days from now, Comcast might decide 
to get an answer back to us. Gotta love 'em.

I'll report back if anyone else is interested.

Emmet McGovern wrote:
 Have you asked Comcast what their blacklist policy is?  What puts a domain
 on a blacklist?  We had a similar situation here where the ISP was
 overriding their filter for any domain with an SPF.  It was an easy solution
 compared to the whitelisting request nightmare.
 
 -e
 
 -Original Message-
 From: Ray Champagne [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 02, 2006 11:46 AM
 To: CF-Talk
 Subject: Comcast blacklisting solutions?
 
 We have several clients that use our mail forwarding to simply send any 
 mail that they get from their site to their Comcast account.  Lately, 
 we've been getting LOTS of blacklisting problems.  Seems that Comcast 
 doesn't like it when we forward email from, say [EMAIL PROTECTED] to 
 [EMAIL PROTECTED]  The messages bounce back to the sender saying that 
 they are blacklisted.  We then have to get the domain un-blacklisted 
 through Comcast, which takes forever and a day.  Three days later, the 
 domain is blacklisted again.  Anyone running into similar problems, 
 and/or have any ideas on ho to fix this, other than stopping the 
 forwarding?  We have over 100 clients using this forwarding feature, and 
 it would be a logistical nightmare to change them all over to a full 
 mail setup.
 
 Thanks,
 
 Ray
 
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231170
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: Where is my nullpointerexception??? CFMX 6.1

2006-02-02 Thread Rick Root
Adrian Lynch wrote:
 Manually track it down with cfabort, cfdump, cfoutput. Put tracer code
 throughout the app's execution path and you'll see what's happening.

Yeah that's what I ended up doing.  Kind of obnoxious that CF can't tell 
you where it happened.

Turned out I was creating a java HashMap object to pass as a parameter 
to another java object, but I did not initialize the HashMap object. 
That worked fine in CFMX7 but generated the nullpointerexception in CFMX 6.1

So I just added an .init() constructor to make everything happy.

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231171
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: Comcast blacklisting solutions?

2006-02-02 Thread Jerry Johnson
Yes, please.

On 2/2/06, Ray Champagne [EMAIL PROTECTED] wrote:
 We're doing that right now.  About 4 days from now, Comcast might decide
 to get an answer back to us. Gotta love 'em.

 I'll report back if anyone else is interested.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231172
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


  1   2   >