query-based Verity collection with Ctegories?

2008-03-31 Thread Azadi Saryev
1) does a database query-based Verity collection support Categories? or
is it supported only for document/directory based collections?

2) i am creating a collection and search interface for a multi-faceted
photo database, where each photo has multiple facets, categories and
keywords assigned to it.
while i can create a collection that combines all the
facets/categories/keywords in the collection's body (together with title
and description), i think it will work better with facets and categories
stored as collection/photo categories...
i am using custom fields to store photo properties, photographer name
and pre-set galleries a photo is assigned to, which takes up all 4
allowed custom fields...

maybe someone has done something like this before and can share the
insight?...

here's the collection index code:



the facets, cats, keywords and galleries are comma-delimited lists of
each photo's facets, cats, keywords, galleries and their respective
descriptions [created with mysql's group_concat() function - gotta love
that thing!] for the prupose of being searchable for user-entered search
phrase.

any thoughts/suggestions?

tia,

-- 

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302409
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Issues with cfhttp and redirect

2008-03-31 Thread William Seiter
If you are on a windows server you can get the cfx_http tag.  It does pretty
much the same things as cfhttp, except it uses the built-in browser on
windows server (not ie), which can hold sessions and cookies.  I am guessing
that it probably doesn't have the redirect issue.



::-Original Message-
::From: Steve Sequenzia [mailto:[EMAIL PROTECTED]
::Sent: Monday, March 31, 2008 11:56 PM
::To: CF-Talk
::Subject: Issues with cfhttp and redirect
::
::I am having issues with cfhttp returning "302 Moved Temporarily" on some
::of the pages that I am hitting. I know that there are redirects happening
::and I am assuming that it is going past the threshold of 4 redirects.
::
::Does anyone know a way around this?
::
::Any help would be great.
::
::Thanks!
::
::

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302408
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Issues with cfhttp and redirect

2008-03-31 Thread Steve Sequenzia
I am having issues with cfhttp returning "302 Moved Temporarily" on some of the 
pages that I am hitting. I know that there are redirects happening and I am 
assuming that it is going past the threshold of 4 redirects.

Does anyone know a way around this?

Any help would be great.

Thanks! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302407
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 cluster testing for load balancing and failover

2008-03-31 Thread George Lu
Yes! I can see them now when I continue to hit different pages. Thank you
James for your help.

On 01/04/2008, George Lu <[EMAIL PROTECTED]> wrote:
>
> I restarted both instances and tried to hit same page from another PC and
> my PC. I can see entries under 'Active Sessions' (see attached) but nothing
> under 'Highest Hit Counts'. What have I done wrong?
>
> On 01/04/2008, James Holmes <[EMAIL PROTECTED]> wrote:
> >
> > Go to Highest Hit Counts (after restarting the server instances to
> > clear it out) and hit a specific page only. That way it will the the
> > only page to show and you can check the number of hits.
> >
> >
> > On Tue, Apr 1, 2008 at 11:24 AM, George Lu <[EMAIL PROTECTED]> wrote:
> > > Well, I can still access the cfusion instance from here:
> > >  servername:8300/cfide/administrator.
> > >
> > >  I've launched the server monitor from each instance. I hit the index
> > page.
> > >  What I can see is it created a session under "Active sessions" and
> > nothing
> > >  under other stats items.
> > >
> > >
> > >
> > >  On 01/04/2008, James Holmes <[EMAIL PROTECTED]> wrote:
> > >  >
> > >  > The multiserver monitor is in the cfusion instance you removed from
> > IIS.
> > >  >
> > >  > Regardless, you probably want to look in the individual server
> > >  > monitors to see how many requests each is handling. hit a page on
> > the
> > >  > site, see which server is shows in, hit it again, it should show in
> > >  > the other server. Take one instance down, all the requests should
> > come
> > >  > from one instance. Bring it back, you should see both serving
> > requests
> > >  > again.
> > >  >
> > >  >
> > >  > On Tue, Apr 1, 2008 at 10:01 AM, George Lu <[EMAIL PROTECTED]>
> > wrote:
> > >  > > I've installed CF8 using multiserver configuration and created a
> > cluster
> > >  > and
> > >  > >  added two instances on the same physical box. Then I've used
> > >  > wsconfig.exe to
> > >  > >  connect the cluster to IIS and remove 'cfusion' from IIS (with
> > help
> > >  > from
> > >  > >  MrBuzzy).
> > >  > >
> > >  > >  Now I can consider the cluster is successfully installed.
> > However, how
> > >  > can I
> > >  > >  test the load balancing and failover? If I run CF Admin on one
> > of the
> > >  > >  instances, how can I add servers (server name? port?) in
> > Multiserver
> > >  > >  Monitor?
> > >  >
> > >  >
> > >  > --
> > >  > mxAjax / CFAjax docs and other useful articles:
> > >  > http://www.bifrost.com.au/blog/
> > >  >
> > >  >
> > >
> > >
> > >
> >
> > 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302406
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Mike Little
ok guys, i think all is resolved quite nicely. am now inputting all stock 
levels in just the product_to_product_options (thank god for those table 
aliases!!) table.

this has made is so much easier. simply doing a SUM of the stock levels to see 
if a product has positive stock levels.

thanks all for your help. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302405
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 cluster testing for load balancing and failover

2008-03-31 Thread James Holmes
Go to Highest Hit Counts (after restarting the server instances to
clear it out) and hit a specific page only. That way it will the the
only page to show and you can check the number of hits.

On Tue, Apr 1, 2008 at 11:24 AM, George Lu <[EMAIL PROTECTED]> wrote:
> Well, I can still access the cfusion instance from here:
>  servername:8300/cfide/administrator.
>
>  I've launched the server monitor from each instance. I hit the index page.
>  What I can see is it created a session under "Active sessions" and nothing
>  under other stats items.
>
>
>
>  On 01/04/2008, James Holmes <[EMAIL PROTECTED]> wrote:
>  >
>  > The multiserver monitor is in the cfusion instance you removed from IIS.
>  >
>  > Regardless, you probably want to look in the individual server
>  > monitors to see how many requests each is handling. hit a page on the
>  > site, see which server is shows in, hit it again, it should show in
>  > the other server. Take one instance down, all the requests should come
>  > from one instance. Bring it back, you should see both serving requests
>  > again.
>  >
>  >
>  > On Tue, Apr 1, 2008 at 10:01 AM, George Lu <[EMAIL PROTECTED]> wrote:
>  > > I've installed CF8 using multiserver configuration and created a cluster
>  > and
>  > >  added two instances on the same physical box. Then I've used
>  > wsconfig.exe to
>  > >  connect the cluster to IIS and remove 'cfusion' from IIS (with help
>  > from
>  > >  MrBuzzy).
>  > >
>  > >  Now I can consider the cluster is successfully installed. However, how
>  > can I
>  > >  test the load balancing and failover? If I run CF Admin on one of the
>  > >  instances, how can I add servers (server name? port?) in Multiserver
>  > >  Monitor?
>  >
>  >
>  > --
>  > mxAjax / CFAjax docs and other useful articles:
>  > http://www.bifrost.com.au/blog/
>  >
>  >
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302404
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF8 cluster testing for load balancing and failover

2008-03-31 Thread George Lu
Well, I can still access the cfusion instance from here:
servername:8300/cfide/administrator.

I've launched the server monitor from each instance. I hit the index page.
What I can see is it created a session under "Active sessions" and nothing
under other stats items.

On 01/04/2008, James Holmes <[EMAIL PROTECTED]> wrote:
>
> The multiserver monitor is in the cfusion instance you removed from IIS.
>
> Regardless, you probably want to look in the individual server
> monitors to see how many requests each is handling. hit a page on the
> site, see which server is shows in, hit it again, it should show in
> the other server. Take one instance down, all the requests should come
> from one instance. Bring it back, you should see both serving requests
> again.
>
>
> On Tue, Apr 1, 2008 at 10:01 AM, George Lu <[EMAIL PROTECTED]> wrote:
> > I've installed CF8 using multiserver configuration and created a cluster
> and
> >  added two instances on the same physical box. Then I've used
> wsconfig.exe to
> >  connect the cluster to IIS and remove 'cfusion' from IIS (with help
> from
> >  MrBuzzy).
> >
> >  Now I can consider the cluster is successfully installed. However, how
> can I
> >  test the load balancing and failover? If I run CF Admin on one of the
> >  instances, how can I add servers (server name? port?) in Multiserver
> >  Monitor?
>
>
> --
> mxAjax / CFAjax docs and other useful articles:
> http://www.bifrost.com.au/blog/
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302403
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 cluster testing for load balancing and failover

2008-03-31 Thread James Holmes
The multiserver monitor is in the cfusion instance you removed from IIS.

Regardless, you probably want to look in the individual server
monitors to see how many requests each is handling. hit a page on the
site, see which server is shows in, hit it again, it should show in
the other server. Take one instance down, all the requests should come
from one instance. Bring it back, you should see both serving requests
again.

On Tue, Apr 1, 2008 at 10:01 AM, George Lu <[EMAIL PROTECTED]> wrote:
> I've installed CF8 using multiserver configuration and created a cluster and
>  added two instances on the same physical box. Then I've used wsconfig.exe to
>  connect the cluster to IIS and remove 'cfusion' from IIS (with help from
>  MrBuzzy).
>
>  Now I can consider the cluster is successfully installed. However, how can I
>  test the load balancing and failover? If I run CF Admin on one of the
>  instances, how can I add servers (server name? port?) in Multiserver
>  Monitor?

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302402
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8 cluster testing for load balancing and failover

2008-03-31 Thread George Lu
I've installed CF8 using multiserver configuration and created a cluster and
added two instances on the same physical box. Then I've used wsconfig.exe to
connect the cluster to IIS and remove 'cfusion' from IIS (with help from
MrBuzzy).

Now I can consider the cluster is successfully installed. However, how can I
test the load balancing and failover? If I run CF Admin on one of the
instances, how can I add servers (server name? port?) in Multiserver
Monitor?

Can someone please help?

George


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302401
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Azadi Saryev
something like:

[note: something quick before my first cup of Lao Mountain Coffee...
beware...]


SELECT p.product_id, p.stock_level, ptop.product_options_id,
ptop.stock_level AS o_stock_level, po.product_option_title
FROM products p LEFT JOIN (product_options po INNER JOIN
product_to_product_options ptop ON po.product_options_id =
ptop.product_options_id) ON p.product_id = ptop.product_id
ORDER BY p.product_id



#product_id#


#product_option_title# : in
stocksorry, out of stock


#stock_level# in stocksorry, out of
stock




Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mike Little wrote:
> good question, at this stage being able to display all with like you said - a 
> availability flag would be quite good.
>
>   
>> do you want to display on your summary page only products that are in
>> stock, or all products with 'unavailable' for those out of stock?
>>
>> Azadi Saryev
>> Sabai-dee.com
>> http://www.sabai-dee.com/
>>
>>
>>
>> Mike Little wrote:
>> 
>>> i need to develop a system for displaying products on a summary page.
>>>
>>>
>>>   
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302400
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF7 - Reset JDBC connection

2008-03-31 Thread AJ Mercer
we have a JDBC connection to an Oracle cluster (RAC)
and one of the servers went off-line for a while
Now that it is back, it is not getting any hits.

What I think has happened is that CF has got all of its connections to the
other server and has them kept open
and therefore got do reason to connect to the this server.

Is there a way to reset the JDBC connection?
I bounced one of the CF instances and that did the trick - but that is a bit
drastic.

-- 

AJ Mercer
Web Log: http://webonix.net


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302399
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Azadi Saryev
i suppose then left joining your tables and using
cfif|cfelse/cfswitch|cfcase logic at output can do the trick?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mike Little wrote:
> good question, at this stage being able to display all with like you said - a 
> availability flag would be quite good.
>
>   
>> do you want to display on your summary page only products that are in
>> stock, or all products with 'unavailable' for those out of stock?
>>
>> Azadi Saryev
>> Sabai-dee.com
>> http://www.sabai-dee.com/
>>
>>
>>
>> Mike Little wrote:
>> 
>>> i need to develop a system for displaying products on a summary page.
>>>
>>>
>>>   
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: product query - need an expert

2008-03-31 Thread Azadi Saryev
not if you ant to be able to display product groups with various options
(i.e. size, colour, etc)...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mark Fuqua wrote:
> Not an expert and this might be really stupid, but what is the advantage of
> making products with options...why not make each product option a different
> product?  Seems it would simplify what you need to do.
>
> Mark
>
> -Original Message-
> From: Mike Little [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 8:46 PM
> To: CF-Talk
> Subject: product query - need an expert
>
>
> help! i am stuck...
>
> ok, for my product catalogue i have included a basic inventory system.
>
> product
> -
> product_id
> track_stock BIT
> stock_level INT
> reorder_level INT
>
> product_to_product_options
> --
> product_id
> product_options_id
> stock_level INT
> reorder_level INT
>
> product_options
> -
> product_options_id
> product_option_title
>
> basically, if a product has options (eg. small, medium, large) then the
> stock is tracked at the option level. if not then it is tracked at the
> product level.
>
> my big problem is, how do i determine if a product is available for purchase
> eg. it has a stock level of zero - either at the product level or for a
> particular option?
>
> i need to develop a system for displaying products on a summary page.
>
> any help would truly be appreciated.
>
> mike
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302397
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: product query - need an expert

2008-03-31 Thread Mark Fuqua
Not an expert and this might be really stupid, but what is the advantage of
making products with options...why not make each product option a different
product?  Seems it would simplify what you need to do.

Mark

-Original Message-
From: Mike Little [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2008 8:46 PM
To: CF-Talk
Subject: product query - need an expert


help! i am stuck...

ok, for my product catalogue i have included a basic inventory system.

product
-
product_id
track_stock BIT
stock_level INT
reorder_level INT

product_to_product_options
--
product_id
product_options_id
stock_level INT
reorder_level INT

product_options
-
product_options_id
product_option_title

basically, if a product has options (eg. small, medium, large) then the
stock is tracked at the option level. if not then it is tracked at the
product level.

my big problem is, how do i determine if a product is available for purchase
eg. it has a stock level of zero - either at the product level or for a
particular option?

i need to develop a system for displaying products on a summary page.

any help would truly be appreciated.

mike



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302396
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Mike Little
good question, at this stage being able to display all with like you said - a 
availability flag would be quite good.

>do you want to display on your summary page only products that are in
>stock, or all products with 'unavailable' for those out of stock?
>
>Azadi Saryev
>Sabai-dee.com
>http://www.sabai-dee.com/
>
>
>
>Mike Little wrote:
>>
>> i need to develop a system for displaying products on a summary page.
>>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302395
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Azadi Saryev
do you want to display on your summary page only products that are in
stock, or all products with 'unavailable' for those out of stock?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mike Little wrote:
>
> i need to develop a system for displaying products on a summary page.
>
>   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302394
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: product query - need an expert

2008-03-31 Thread Greg Morphis
It wouldn't be null you could make it "0".
Having the product stock in one table would make it easier to maintain also

On Mon, Mar 31, 2008 at 8:12 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> hmmm... yes this could be an option. i was a little unsure of the default 
> record for the ptpo table eg. would it be a good idea to have a null 
> product_options_id?
>
> >Maybe have a default or generic "option", set the id to 0.. That way
> >ALL stock totals will be in one table instead of 2.
> >It'd make it easier to query also.
> >
> >
> >
> >On Mon, Mar 31, 2008 at 7:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> >>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302393
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Mike Little
hmmm... yes this could be an option. i was a little unsure of the default 
record for the ptpo table eg. would it be a good idea to have a null 
product_options_id?

>Maybe have a default or generic "option", set the id to 0.. That way
>ALL stock totals will be in one table instead of 2.
>It'd make it easier to query also.
>
>
>
>On Mon, Mar 31, 2008 at 7:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: product query - need an expert

2008-03-31 Thread Mike Little
SQL server mike.

>It might help to know which database you are using (SQL Server?).
>There are many ways to do this, but I don't think you provided enough
>detail to identify the best method. Below is one method.
>
>SELECT 1
>FROM product p
>WHERE product_id  = #id#
>AND
>(stock_level > 0
>OR EXISTS (
>  SELECT 1
>  FROM product_to_product_options ptpo
>  WHERE ptpo.product_id = p.product_id
>  AND ptpo.stock_level > 0
>)
>)
>
>If the query returns a row, then the product is in stock.
>
>Good luck,
>Mike Chabot
>
>On Mon, Mar 31, 2008 at 8:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302391
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: product query - need an expert

2008-03-31 Thread Greg Morphis
Maybe have a default or generic "option", set the id to 0.. That way
ALL stock totals will be in one table instead of 2.
It'd make it easier to query also.



On Mon, Mar 31, 2008 at 7:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> help! i am stuck...
>
> ok, for my product catalogue i have included a basic inventory system.
>
> product
> -
> product_id
> track_stock BIT
> stock_level INT
> reorder_level INT
>
> product_to_product_options
> --
> product_id
> product_options_id
> stock_level INT
> reorder_level INT
>
> product_options
> -
> product_options_id
> product_option_title
>
> basically, if a product has options (eg. small, medium, large) then the stock 
> is tracked at the option level. if not then it is tracked at the product 
> level.
>
> my big problem is, how do i determine if a product is available for purchase 
> eg. it has a stock level of zero - either at the product level or for a 
> particular option?
>
> i need to develop a system for displaying products on a summary page.
>
> any help would truly be appreciated.
>
> mike
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302390
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: product query - need an expert

2008-03-31 Thread Mike Chabot
It might help to know which database you are using (SQL Server?).
There are many ways to do this, but I don't think you provided enough
detail to identify the best method. Below is one method.

SELECT 1
FROM product p
WHERE product_id  = #id#
AND
(stock_level > 0
OR EXISTS (
  SELECT 1
  FROM product_to_product_options ptpo
  WHERE ptpo.product_id = p.product_id
  AND ptpo.stock_level > 0
)
)

If the query returns a row, then the product is in stock.

Good luck,
Mike Chabot

On Mon, Mar 31, 2008 at 8:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> help! i am stuck...
>
> ok, for my product catalogue i have included a basic inventory system.
>
> product
> -
> product_id
> track_stock BIT
> stock_level INT
> reorder_level INT
>
> product_to_product_options
> --
> product_id
> product_options_id
> stock_level INT
> reorder_level INT
>
> product_options
> -
> product_options_id
> product_option_title
>
> basically, if a product has options (eg. small, medium, large) then the stock 
> is tracked at the option level. if not then it is tracked at the product 
> level.
>
> my big problem is, how do i determine if a product is available for purchase 
> eg. it has a stock level of zero - either at the product level or for a 
> particular option?
>
> i need to develop a system for displaying products on a summary page.
>
> any help would truly be appreciated.
>
> mike
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302389
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


product query - need an expert

2008-03-31 Thread Mike Little
help! i am stuck...

ok, for my product catalogue i have included a basic inventory system.

product
-
product_id
track_stock BIT
stock_level INT
reorder_level INT

product_to_product_options
--
product_id
product_options_id
stock_level INT
reorder_level INT

product_options
-
product_options_id
product_option_title

basically, if a product has options (eg. small, medium, large) then the stock 
is tracked at the option level. if not then it is tracked at the product level.

my big problem is, how do i determine if a product is available for purchase 
eg. it has a stock level of zero - either at the product level or for a 
particular option?

i need to develop a system for displaying products on a summary page.

any help would truly be appreciated.

mike 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302388
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Windows CF8 VPS?

2008-03-31 Thread Gerald Guido
>> What about Amazon?  They finally have static IPs,

I saw that too. Amazon EC2 is starting to look like a viable alternative to
VPS's and dedicated servers. If you are comfortable with Linux that is.

Managing a Windows server is one thing. Linux? TThat is a whole nother ball
of wax. And on top of that, managing EC2 instances is a learning curve in
and of itself. So much so that there is a cottage industry growing around
managing EC2 instances.

But for the intrepid, EC2 and BD J2EE will start looking very attractive.

G


On Mon, Mar 31, 2008 at 5:59 PM, Russ <[EMAIL PROTECTED]> wrote:

> What about Amazon?  They finally have static IPs,  and I think you should
> be
> able to have multiple CF instances running on a single license.
>
> Russ
>
>
-- 
"Education is a progressive discovery of our own ignorance."
- Will Durant


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302387
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfgrid and binding

2008-03-31 Thread Azadi Saryev
like this:

bind="cfc:com.server.jobNotes.getSteps(
{cfgridpage},
{cfgridpagesize},
{cfgridsortcolumn},
{cfgridsortdirection},
#somecfvariable#,
'#anothercfvariable#',
[EMAIL PROTECTED])"


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Chad Gray wrote:
> I am binding a CFC to a grid.
>
> I need to pass a variable to the CFC so it can return a query.
>
> How do you pass a variable to the CFC when binding?
>
> bind="cfc:com.server.jobNotes.getSteps({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302386
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jim Davis
> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:57 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> I considered VPS mainly because of cost.  It was an easy sale to the
> people who write checks around here.  We have several shared accounts
> with HMS which we intended to combine on the VPS.

Your only additional cost will be the CF license - and it's not
inconsequential.  Although note that you can often find older versions or
used copies for significant savings.

You'll need to determine the initial investment: for example "real" Adobe CF
or an alternative engine?  Standard or Enterprise?  Then plan for the
lifetime of that investment (for software like this three years is pretty
standard).

Divide your investment by the lifetime and figure out the premium you'll be
paying. For example CF Standard over three years is about $33 a month.  My
dedicated box costs $85 a month and I pay an additional $5 a month for a
block of 5 additional IPs.  So my monthly cost is about $123.

You'd have to add any additional software you need in there as well of
course - but often the total cost of ownership for dedicated is less than
VPS depending on your needs.

It's harder to calculate but also consider the risks involved.  VPS does,
inherently, contain more risk than a dedicated box.  Runaway processes on
one VM can overrun shared resources (especially network resources and disc
access).

Since you're looking for colo at this point it's pretty clear that you've
already done this.  ;^)  I just see a lot of people making the assumption
that a VPS will be more economical when the real answer is more complex.

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302385
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jim Davis
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:49 PM
> To: CF-Talk
> Subject: Re: Windows CF8 VPS?
> 
> On Mon, Mar 31, 2008 at 2:44 PM, Jim Davis
> <[EMAIL PROTECTED]> wrote:
> >  I'm curious tho' - why consider only VPS and not dedicated?
> >
> >  I was under the impression that VPS was, mostly, just a way to
> provide
> >  dedicated-like features at a cost savings.  Am I missing something?
> >
> >  And not really worth it in my opinion since their dedicated boxes
> are so
> >  competitive... of course if you can't amortize your CF license over
> several
> >  years then it may be attractive I guess.
> 
> yeah, for me it's the cost of the software (windows and CF
> specifically).  my VPS with AHP comes with windows 2k3 server, cf8,
> smartermail, smarterstats, and smarterticket.  but again, it was
> specifically Windows and CF.

Yeah - the OS is included on most hosts I've seen, but CF is another story.

With standard still costing $1200 it's not a bad deal if you can amortize it
over three years (about $33 a month in addition to hosting) but if you need
enterprise or need to upgrade with each new version then costs will increase
a lot.

BlueDragon might be an attractive option for dedicated customers as well.

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302384
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8: read a PDF and list its form fields type and options

2008-03-31 Thread Brook Davies
I know its possible to get a list of the fields within a PDF but what about a 
list of PDF field type s(radio,text etc) and options used in radios,checkboxes 
and combo-boxes. Is it possible to get this data from a PDF in CF8? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302383
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: inefficient query

2008-03-31 Thread Gerald Guido
>> but am now using sql manager 2005 lite which does not seem to be able to
do it.

EMS sql manager 2005 lite? Excellent tool.

Here, try this. Even faster way to write a select query.

Open up a new editor window and drag/drop a table into the editor window.
Poof. There is your select query.

J


On Mon, Mar 31, 2008 at 4:20 PM, Mike Little <[EMAIL PROTECTED]> wrote:

> Awesome tip that! usually i have enterprise manager to construct my
> queries but am now using sql manager 2005 lite which does not seem to be
> able to do it.
>
> >First thing I would do is get rid of the get all the SELECT *.
> >
> >product.*, product_description.*, product_options.*,
> >
> >This will save you three trips to the database. A quick way to grab the
> >fields of a table with out typing them is
> >
> >Run a Select * FROM YourTable
> >
> >And dump the list of Columns using
> #Myquery.ColumnList#
> >
> >
> >
> >On Sun, Mar 30, 2008 at 9:31 PM, Mike Little <[EMAIL PROTECTED]>
> wrote:
> >
> >>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302382
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFX_CSVToQuery does not work with CF8

2008-03-31 Thread Brook Davies
CF8 crashes when I try to run  this cfx which I have been using for about 5 
years or so . It works fine on CF7 and all previous releases. I'm using the 
default JVM, the log does not say much - anybody else have this problem or am I 
the only person using this tag still??

#
# An unexpected error has been detected by Java Runtime Environment:
#
#  EXCEPTION_FLT_STACK_CHECK (0xc092) at pc=0x007dcf79, pid=1776, tid=5724
#
# Java VM: Java HotSpot(TM) Server VM (1.6.0_01-b06 mixed mode)
# Problematic frame:
# v  ~RuntimeStub::resolve_opt_virtual_call
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
# 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302381
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Russ
What about Amazon?  They finally have static IPs,  and I think you should be
able to have multiple CF instances running on a single license.  

Russ

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:55 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> I'm in St. Louis, Missouri. :)
> 
> 
> -Original Message-
> From: Jim Davis [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:48 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> > -Original Message-
> > From: Jason Durham [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 31, 2008 5:05 PM
> > To: CF-Talk
> > Subject: RE: Windows CF8 VPS?
> >
> > FWIW, I was talking about a local colo. :-)
> 
> What's "local"?
> 
> I had lots of options in Boston for local colo, but there aren't that
> many
> in Scranton.  ;^)
> 
> Jim Davis
> 
> 
> 
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302380
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jason Durham
I considered VPS mainly because of cost.  It was an easy sale to the
people who write checks around here.  We have several shared accounts
with HMS which we intended to combine on the VPS.



-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 4:45 PM
To: CF-Talk
Subject: RE: Windows CF8 VPS?

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:48 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> BTW, CrystalTech doesn't offer VPS so the point is moot. :-)

I'm curious tho' - why consider only VPS and not dedicated?

I was under the impression that VPS was, mostly, just a way to provide
dedicated-like features at a cost savings.  Am I missing something?

> Their 'semi-dedicated' is just a shared box.

And not really worth it in my opinion since their dedicated boxes are so
competitive... of course if you can't amortize your CF license over
several
years then it may be attractive I guess.

Jim Davsi 




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302379
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jason Durham
I'm in St. Louis, Missouri. :)


-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 4:48 PM
To: CF-Talk
Subject: RE: Windows CF8 VPS?

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:05 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> FWIW, I was talking about a local colo. :-)

What's "local"?

I had lots of options in Boston for local colo, but there aren't that
many
in Scranton.  ;^)

Jim Davis




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302378
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Windows CF8 VPS?

2008-03-31 Thread Charlie Griefer
On Mon, Mar 31, 2008 at 2:44 PM, Jim Davis <[EMAIL PROTECTED]> wrote:
>  I'm curious tho' - why consider only VPS and not dedicated?
>
>  I was under the impression that VPS was, mostly, just a way to provide
>  dedicated-like features at a cost savings.  Am I missing something?
>
>  And not really worth it in my opinion since their dedicated boxes are so
>  competitive... of course if you can't amortize your CF license over several
>  years then it may be attractive I guess.

yeah, for me it's the cost of the software (windows and CF
specifically).  my VPS with AHP comes with windows 2k3 server, cf8,
smartermail, smarterstats, and smarterticket.  but again, it was
specifically Windows and CF.

-- 
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. "Arf," she
said.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302377
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jim Davis
> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:05 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> FWIW, I was talking about a local colo. :-)

What's "local"?

I had lots of options in Boston for local colo, but there aren't that many
in Scranton.  ;^)

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302376
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jim Davis
> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:48 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> BTW, CrystalTech doesn't offer VPS so the point is moot. :-)

I'm curious tho' - why consider only VPS and not dedicated?

I was under the impression that VPS was, mostly, just a way to provide
dedicated-like features at a cost savings.  Am I missing something?

> Their 'semi-dedicated' is just a shared box.

And not really worth it in my opinion since their dedicated boxes are so
competitive... of course if you can't amortize your CF license over several
years then it may be attractive I guess.

Jim Davsi 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302375
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jason Durham
I work for a telecommunications company.  We're just looking for some
rack space and redundant power/internet.  The only support we'd ever ask
of them is a hard power off/on.

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 4:12 PM
To: CF-Talk
Subject: RE: Windows CF8 VPS?

Not sure what you mean by a local colo.  Do you mean at a local hosting
company?  Are they reliable?  Do they have good support?  

While HMS has had downtime, it has been minimal, at least for us, and
from
my limited experience, I would say that they're coming in at a close
second
behind rackspace in both terms of uptime and support. 

The colo there shouldn't run you a lot more then $1500 a year, excluding
the
cost of the hardware.  

Russ

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:05 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> FWIW, I was talking about a local colo. :-)
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:04 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> The colo @ HMS sounds right for you.  We've been doing that for some
of
> our
> servers (as well as doing managed hosting for other servers), and been
> fairly happy with the pricing and support.
> 
> Russ
> 
> > -Original Message-
> > From: Jason Durham [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 31, 2008 4:46 PM
> > To: CF-Talk
> > Subject: RE: Windows CF8 VPS?
> >
> > Seems like I've sparked a bit of a debate. Heh
> >
> > I'm not afraid of being responsible for the box.  The company I work
> for
> > is a Microsoft partner and we have several technicians versed in
> > Winders.
> >
> > I have considered everyone's suggestions and spoke with many of the
> > hosts mentioned.  I'm trying to make the dollars make sense with a
> > dedicated box at a colo.  We have other applications that would
> benefit
> > from being offsite.
> >
> >
> >
> >
> >
> 
> 
> 
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302374
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: inefficient query

2008-03-31 Thread Mike Little
got it. thanks heaps mark.

>Mike,
>
>You would only need to validate it if you were accepting it as user input.
>In that case you would need to compare it to a list or array of valid
>values... Or perhaps pass in something that you compare to derive this value
>as in.
>
>
>
>   
>
>   
>
>   
>
>
>In this way - you are comparing for an exact match and explicitely setting
>the value. It would be impossible for a malicious user to sneak something
>into the args.orderby variable. You would use args.order_keyin your
>function 
>
>application.product.get_product(cat_id=URL.cat_id,order_key=args.order_key)/
>>
>
>Or you could set your other arguments like so...
>
> 
>
>
>
>Or perhaps more symantic...
>
>application.product.get_product(argumentcollection=args)/>
>
>
>Mark A. Kruger, CFG, MCSE
>(402) 408-3733 ext 105
>www.cfwebtools.com
>www.coldfusionmuse.com
>www.necfug.com
>
>mark, the order_key is only defined in my code eg.
>
>getProducts =
>application.product.get_product(cat_id=URL.cat_id,order_key="product.order_k
>ey ASC");
>
>i would be interested however in how to validate this at the server side?
>
>thanks
>mike 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302373
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Russ
Not sure what you mean by a local colo.  Do you mean at a local hosting
company?  Are they reliable?  Do they have good support?  

While HMS has had downtime, it has been minimal, at least for us, and from
my limited experience, I would say that they're coming in at a close second
behind rackspace in both terms of uptime and support. 

The colo there shouldn't run you a lot more then $1500 a year, excluding the
cost of the hardware.  

Russ

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 5:05 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> FWIW, I was talking about a local colo. :-)
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:04 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> The colo @ HMS sounds right for you.  We've been doing that for some of
> our
> servers (as well as doing managed hosting for other servers), and been
> fairly happy with the pricing and support.
> 
> Russ
> 
> > -Original Message-
> > From: Jason Durham [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 31, 2008 4:46 PM
> > To: CF-Talk
> > Subject: RE: Windows CF8 VPS?
> >
> > Seems like I've sparked a bit of a debate. Heh
> >
> > I'm not afraid of being responsible for the box.  The company I work
> for
> > is a Microsoft partner and we have several technicians versed in
> > Winders.
> >
> > I have considered everyone's suggestions and spoke with many of the
> > hosts mentioned.  I'm trying to make the dollars make sense with a
> > dedicated box at a colo.  We have other applications that would
> benefit
> > from being offsite.
> >
> >
> >
> >
> >
> 
> 
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302372
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jason Durham
FWIW, I was talking about a local colo. :-)

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 4:04 PM
To: CF-Talk
Subject: RE: Windows CF8 VPS?

The colo @ HMS sounds right for you.  We've been doing that for some of
our
servers (as well as doing managed hosting for other servers), and been
fairly happy with the pricing and support. 

Russ

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:46 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> Seems like I've sparked a bit of a debate. Heh
> 
> I'm not afraid of being responsible for the box.  The company I work
for
> is a Microsoft partner and we have several technicians versed in
> Winders.
> 
> I have considered everyone's suggestions and spoke with many of the
> hosts mentioned.  I'm trying to make the dollars make sense with a
> dedicated box at a colo.  We have other applications that would
benefit
> from being offsite.
> 
> 
> 
> 
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302371
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Windows CF8 VPS?

2008-03-31 Thread Russ
The colo @ HMS sounds right for you.  We've been doing that for some of our
servers (as well as doing managed hosting for other servers), and been
fairly happy with the pricing and support. 

Russ

> -Original Message-
> From: Jason Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:46 PM
> To: CF-Talk
> Subject: RE: Windows CF8 VPS?
> 
> Seems like I've sparked a bit of a debate. Heh
> 
> I'm not afraid of being responsible for the box.  The company I work for
> is a Microsoft partner and we have several technicians versed in
> Winders.
> 
> I have considered everyone's suggestions and spoke with many of the
> hosts mentioned.  I'm trying to make the dollars make sense with a
> dedicated box at a colo.  We have other applications that would benefit
> from being offsite.
> 
> 
> 
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302370
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Examples of BlazeDS with ColdFusion CFCs?

2008-03-31 Thread Andy Matthews
João...

I'm having trouble walking through the examples on your site. I'm thinking it 
has something to do with my setup, but could you take a look at my most recent 
comment on your site?

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302369
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jim Davis
> -Original Message-
> From: Dave l [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 4:15 PM
> To: CF-Talk
> Subject: Re: Windows CF8 VPS?
> 
> "Calling a hosting provider to set a mapping on YOUR box should cost
> you. Having that host install CF ON HIS BOX should cost him.  IT'S HIS
> BOX."
> 
> ok so they should have charged him $300 or whatever it was for what
> should have been 1 minute of their time... yeah thats a great deal
> jim!! SIGN ME UP!

It doesn't matter what it is or how easy it is.  The cost structure is
specifically designed to be forbidding so that people DON'T ask for
application-level support.

CF is an application on YOUR BOX.

How much should they charge if I call them and ask for macro to be created
in Word?  How much to add a new email account to SmarterMail?  How much to
change my desktop wallpaper? 

The answer for all of these is: a huge, unreasonable amount that will prompt
you not to call for work you should be doing.

> "None of these assertions can be backed up by the original request.
> The requestor only said that he didn't like the performance or support.
> No assumptions can be made about his skill level."
> Ok so he says basically that he needs support, you don't need a zune
> manual to figure that part out. If he knew enough about running his own

Your assumptions are faulty.  Needing support doesn't say anything: every
level of service needs support.  You're assuming however that he need an
unreasonable level of support for his chosen service.

CT provides appropriate service and provides it well.  When I opened my
account I needed "support" to set up DNS. I opened a ticket and was promptly
pointed to a well-written document in the knowledge base covering that
process.  When I need to upgrade RAM on a box I need support. 

Since no details were given no clear assumptions can be made.  I prefer to
assume that the poster is asking for a level of service that they
understand, you treat everybody like an idiot.  Different strokes.

Damn I'm so consistently amazing by the warped lens through which you view
life.

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302368
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jason Durham
BTW, CrystalTech doesn't offer VPS so the point is moot. :-)

Their 'semi-dedicated' is just a shared box.

-Original Message-
From: Jason Durham [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 3:46 PM
To: CF-Talk
Subject: RE: Windows CF8 VPS?

Seems like I've sparked a bit of a debate. Heh

I'm not afraid of being responsible for the box.  The company I work for
is a Microsoft partner and we have several technicians versed in
Winders.
  
I have considered everyone's suggestions and spoke with many of the
hosts mentioned.  I'm trying to make the dollars make sense with a
dedicated box at a colo.  We have other applications that would benefit
from being offsite.






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302367
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Windows CF8 VPS?

2008-03-31 Thread Jason Durham
Seems like I've sparked a bit of a debate. Heh

I'm not afraid of being responsible for the box.  The company I work for
is a Microsoft partner and we have several technicians versed in
Winders.
  
I have considered everyone's suggestions and spoke with many of the
hosts mentioned.  I'm trying to make the dollars make sense with a
dedicated box at a colo.  We have other applications that would benefit
from being offsite.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302366
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: inefficient query

2008-03-31 Thread Mark Kruger
Mike,

You would only need to validate it if you were accepting it as user input.
In that case you would need to compare it to a list or array of valid
values... Or perhaps pass in something that you compare to derive this value
as in.










In this way - you are comparing for an exact match and explicitely setting
the value. It would be impossible for a malicious user to sneak something
into the args.orderby variable. You would use args.order_keyin your
function 



Or you could set your other arguments like so...

 



Or perhaps more symantic...




Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Mike Little [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 3:23 PM
To: CF-Talk
Subject: Re: inefficient query

mark, the order_key is only defined in my code eg.

getProducts =
application.product.get_product(cat_id=URL.cat_id,order_key="product.order_k
ey ASC");

i would be interested however in how to validate this at the server side?

thanks
mike 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302365
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: inefficient query

2008-03-31 Thread Mike Little
mark, the order_key is only defined in my code eg.

getProducts = 
application.product.get_product(cat_id=URL.cat_id,order_key="product.order_key 
ASC");

i would be interested however in how to validate this at the server side?

thanks
mike 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302364
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: inefficient query

2008-03-31 Thread Mike Little
Awesome tip that! usually i have enterprise manager to construct my queries but 
am now using sql manager 2005 lite which does not seem to be able to do it.

>First thing I would do is get rid of the get all the SELECT *.
>
>product.*, product_description.*, product_options.*,
>
>This will save you three trips to the database. A quick way to grab the
>fields of a table with out typing them is
>
>Run a Select * FROM YourTable
>
>And dump the list of Columns using #Myquery.ColumnList#
>
>
>
>On Sun, Mar 30, 2008 at 9:31 PM, Mike Little <[EMAIL PROTECTED]> wrote:
>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302363
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Windows CF8 VPS?

2008-03-31 Thread Dave l
"Calling a hosting provider to set a mapping on YOUR box should cost you. 
Having that host install CF ON HIS BOX should cost him.  IT'S HIS BOX."

ok so they should have charged him $300 or whatever it was for what should have 
been 1 minute of their time... yeah thats a great deal jim!! SIGN ME UP!
Coldfusion was already installed, they just didn't apparently read that 1 page 
in the manual either and since they didn't know how to do it they blamed it on 
coldfusion.
And they couldn't even do the mapping right and THEY (as in ct) said cf needed 
to be re-installed (which of course it didn't) because they didn't know how to 
do it.. so I guess THEY should be reading that 1 page of the manual which you 
would assume they should already know but instead they took his money and the 
simple job still didnt get done, pretty damn ridiculous if you ask me. But then 
again any given person can have a problem with any host.

"If you're that fundamentally illiterate about the technologies involved you've 
no business running a server."
You are right jim and he shouldn't be running a server. His old partner ran the 
server before and left him hanging with it. But he understands that and doesn't 
mind paying for something to get done but consistently ct does just what it did 
in the previous example and take his money and not get the request done. In the 
meantime when his contract with them is up he is leaving and going to a managed 
server which is where he should be.

"That's an outright lie. CT servers are behind very good, industrial HARDWARE 
firewalls"
That's NOT what they told me and thats NOT what they told him. Actually they 
told him that there is ZERO protection and that his server was full of Trojans 
and all that crap and so he called me on other line and we 3 way called and he 
flat out told me there is no protection whatsoever on their system and of 
course they talked him into letting them "clean" his server for $500 (which was 
probably a scam). But again he shouldn't be on his own server but what you are 
saying and what they said are 2 different things. So if that is the case then 
they purposely duped him outta $500 and I dunno which way is worse.

"None of these assertions can be backed up by the original request.  The 
requestor only said that he didn't like the performance or support.  No 
assumptions can be made about his skill level."
Ok so he says basically that he needs support, you don't need a zune manual to 
figure that part out. If he knew enough about running his own server then he 
could have tweaked the vps to increase the performance since he has quite a bit 
of control of the machine which is a pretty good indicator that he'd have a 
hard time with a self-serve ded box & if he didn't like the support he got then 
don't you think he just might need support on a ded box because he quite 
clearly states that support is one of the reasons he is leaving, which would 
mean he is needing it.

"I assume that anybody looking for a VPS or dedicated box has the basic skills 
required to actually use that service."
Well that's cause you assume instead of actually reading what they ask or say. 
What is funny is that when someone who can run their own server posts this 
question you don't throw out your $85 server.. go figure


"continue to bitch EVERY TIME I CONFER MY OPINION."
Yes I do BITCH Jim because every time someone comes on who say they NEED 
SUPPORT and COLDFUSION you throw out this $85 server which does NOT include 
neither SUPPORT OR COLDFUSION which very very much mis-leads the people into 
thinking it's an option when 98% of the time it ends up not being a real option 
for them. If you want to CONFER YOUR OPINION then at least state the facts that 
it does NOT include support or coldfusion so that the poster understands that 
there are different types of dedicated boxes and services offered because most 
people just don't know that a dedicated plan at host a is very different then 
dedicated plan at host b. I think it would be pretty rare for someone who is 
actually able or qualified to run their own server to come on here and ask for 
info on hosting. Would it be so hard for you just to say "hey I got a ded box 
at ct for $85 a month and I love it but do understand that price does not 
include support or coldfusion." Because at least then it wouldn't get their 
hopes up.
If it was me and I listened to you and went and got the server and then found 
out there is no support, there is no coldfusion, there is no av, there is no 
backups and on and on... i'd be frickin pissed as hell and by the time i added 
all that I would be right back up to a managed server, lol


To the poster, IMO you should at first start with a managed dedicated box until 
you learn how to run and use it then go to unmanaged. I personally keep my 
dedicated box on a managed plan because I would rather have hms help deal with 
any issues or be there for my customers if there is a problem without getting 
r

RE: Live Chat

2008-03-31 Thread Rick Sanders
Thanks!

-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED] 
Sent: March-31-08 3:59 PM
To: CF-Talk
Subject: Re: Live Chat

http://cfopenchat.riaforge.org/

On Mon, Mar 31, 2008 at 2:49 PM, Rick Sanders <[EMAIL PROTECTED]> wrote:

> Hello helpful people!
>
>
>
> I'm just wondering if there's a chat module anywhere that's been built
> already?
>
>
>
> Thanks,
>
>
>
> Rick
>
>
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302361
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Smarty for CF

2008-03-31 Thread Kevin Aebig
I'll look into it... Thanks.

!k

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 11:49 AM
To: CF-Talk
Subject: Re: Smarty for CF

You can very easily use any of the Java-based template engines (e.g.
Velocity) with CF, since CF is just Java.  Or you could use the Java 6
scripting engine support and run PHP inside your CF (check Sean
Corfield's blog) and use Smarty itself, though I don't know what kind
of performance implications that would have.

cheers,
barneyb

On Mon, Mar 31, 2008 at 10:18 AM, Kevin Aebig <[EMAIL PROTECTED]> wrote:
> Hey all,
>
>
>
>  Has anyone implemented a simple replacement template system like smarty?
>
>
>
>  Thanks,
>
>
>
>  !k
>
>
>
>
>  



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302360
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: MS SQL 05 Express + CF8 + Vista, DSN setup failed (LCID 3076?)

2008-03-31 Thread henry ho
I've fixed the problem by changing the Collation settings to one that gets 
recongnized by the MS SQL JDBC driver.

Thanks.


>LCID = Locale Identifier... is your SQL installation the same locale as your
>windows and jvm? I don't know that it matters, but you could check.
>
>I really don't know about the LCID error, but I can offer a few of my own
>troubleshooting tips for getting CF to talk to SQL express on localhost.
>
>1 - make sure TCP/IP is turned on - this is in the sql server configuration
>manager
>2 - same tool, check the TCP port your SQL server is listening on - it's
>usually not the standard one
>3 - paste that port number into your CF admin
>4 - make a sql server user account for CF to log into your database - make
>sure to assign a password
>5 - make sure the cf user account has appropriate access granted - for dev
>work, I would just make it dba
>6 - make sure you use the right database name & password in your cf admin
>
>And if that doesn't work check your windows firewall or other firewall
>apps. Turn off other applications like Skype, restart the sql & cf services.
>That's about all I know off the top of my head.
>
>-- 
>nathan strutz
>http://www.dopefly.com/
>
>
>
>On Mon, Mar 31, 2008 at 11:30 AM, henry ho <[EMAIL PROTECTED]> wrote:
>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302359
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Displaying POI output in a browser on CFMX 6

2008-03-31 Thread Eric Roberts
That did the trick (setting it to inline)...thanks.  

Eric


/*-Original Message-
/*From: C S [mailto:[EMAIL PROTECTED]
/*Sent: Monday, March 31, 2008 1:19 AM
/*To: CF-Talk
/*Subject: Re: Displaying POI output in a browser on CFMX 6
/*
/*>
/*> ..
/*>Obviously this is because 6 doesn't have this attribute.
/*
/*Assuming you do not wish to write the bytes to disk, you could write to
/*the response outputstream. Here is an example. It uses batik, but it is
/*the same idea.
/*http://www.barneyb.com/barneyblog/2006/05/04/more-batik-goodness/
/*
/*
/*>Any better ideas on how to display this?  Ideally, if someone knows how
/*to
/*>cause it to just display in the browser
/*
/*Try value="inline; ..." instead of attachment. That should work, if the
/*browser is configured to open excel files.
/*
/*
/*
/*

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302358
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Live Chat

2008-03-31 Thread Gerald Guido
http://cfopenchat.riaforge.org/

On Mon, Mar 31, 2008 at 2:49 PM, Rick Sanders <[EMAIL PROTECTED]> wrote:

> Hello helpful people!
>
>
>
> I'm just wondering if there's a chat module anywhere that's been built
> already?
>
>
>
> Thanks,
>
>
>
> Rick
>
>
>
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302357
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF8: Class not found: coldfusion.sql.QueryTable - RESOLVED (sort of)

2008-03-31 Thread Gaulin, Mark
It looks like the issue is caused by me trying to use a servlet to boot
my system up, so I think this is a change to the way the servlet
classloader is managed vs prior versions of CF, and I posted this to
Adobe as a bug.

If I change my boot process (which creates and starts a java class of
mine) to not use a servlet, but to wait for a request from a CF page,
then the QueryTable class is found by my java code. 

My understanding of java classloading is limited, but I can see why CF
would use a custom classloader to handle a servlet, since it could
change "at any time" and so would require reloading, but something must
have changed with CF8's classpath that makes cfusion.jar not available
to servlets.  

Thanks
Mark

-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 28, 2008 3:49 PM
To: CF-Talk
Subject: CF8: Class not found: coldfusion.sql.QueryTable

Hi
I use java code to create a Query to be returned to a CF page, but with
CF8 my java code throws this error:

java.lang.NoClassDefFoundError: coldfusion/sql/QueryTable

I can create this class with CreateObject("Java",
"coldfusion.sql.QueryTable") from a CF page, but my java code (running
in the same JVM, configured as a servlet) apparently cannot.

BTW, I compile the java code using a reference to the cfusion.jar file
on my local machine; the code only runs inside a real CF JVM (at least
it used to on CF7).  


So, anyone have any idea why this might be happening?  Could my servlet
somehow have a different classpath than a cf page itself?

Thanks
Mark




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302356
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Live Chat

2008-03-31 Thread Rick Sanders
Hello helpful people!

 

I'm just wondering if there's a chat module anywhere that's been built
already?

 

Thanks,

 

Rick

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302355
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfgrid and binding

2008-03-31 Thread Chad Gray
I am binding a CFC to a grid.

I need to pass a variable to the CFC so it can return a query.

How do you pass a variable to the CFC when binding?

bind="cfc:com.server.jobNotes.getSteps({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302354
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: MS SQL 05 Express + CF8 + Vista, DSN setup failed (LCID 3076?)

2008-03-31 Thread Nathan Strutz
LCID = Locale Identifier... is your SQL installation the same locale as your
windows and jvm? I don't know that it matters, but you could check.

I really don't know about the LCID error, but I can offer a few of my own
troubleshooting tips for getting CF to talk to SQL express on localhost.

1 - make sure TCP/IP is turned on - this is in the sql server configuration
manager
2 - same tool, check the TCP port your SQL server is listening on - it's
usually not the standard one
3 - paste that port number into your CF admin
4 - make a sql server user account for CF to log into your database - make
sure to assign a password
5 - make sure the cf user account has appropriate access granted - for dev
work, I would just make it dba
6 - make sure you use the right database name & password in your cf admin

And if that doesn't work check your windows firewall or other firewall
apps. Turn off other applications like Skype, restart the sql & cf services.
That's about all I know off the top of my head.

-- 
nathan strutz
http://www.dopefly.com/



On Mon, Mar 31, 2008 at 11:30 AM, henry ho <[EMAIL PROTECTED]> wrote:

> MS SQL 05 Express + CF8 + Vista
>
> I've already enabled TCP/IP, and open for 127.0.0.1 (localhost).  I can
> connect that account through tcp/ip no problem using management studio
> express, but CF8 (with built-in Microsoft SQL Server JDBC driver) just gives
> me this error message:
>
> Connection verification failed for data source: 
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Unexpected LCID:
> 3076
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer
> JDBC Driver]Unexpected LCID: 3076
>
>
> I purposely try a wrong password just to see what happen:
>
> Connection verification failed for data source: 
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login
> failed for user 'cf'.
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer
> JDBC Driver][SQLServer]Login failed for user 'cf'.
>
>
> So this means the connection works, but what the hell is LCID 3076?
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302353
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Matt Williams
Adam,

I'm just now checking out Pulse. It looks pretty slick. Do you have a
shared profile I can check out?

On Mon, Mar 31, 2008 at 1:01 PM, Adam Haskell <[EMAIL PROTECTED]> wrote:
> Most of the plugins in MyEclipse are proprietary, developed by Genuitec,
>  though it does base some of the plugins on OS projects.  A couple of years
>  ago I would have agreed hands down with Barney. These days i am tending to
>  lean the other way. I have found more and more that I can setup a more
>  productive environment on my own. MyEclipse has become heavier and slow and
>  in all honesty I find myself more productive with other plugins. With 100
>  developers and quite a few contractors coming in and out It is well worth
>  our time as a company to evaluate the plugins on the market find the best of
>  breed and distribute them, tools like pulse and yoxos make it tremendously
>  easy. Aside from Apanta, which is abit of hog, all the plugins I listed
>  previously are quick and nimble. To each his/her own though if you evaluate
>  myEclipse and like it, go for it like Barney said to him it is worth it and
>  I think many would agree.
>
>  Adam Haskell
>
>

-- 
Matt Williams
"It's the question that drives us."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302352
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Adam Haskell
Most of the plugins in MyEclipse are proprietary, developed by Genuitec,
though it does base some of the plugins on OS projects.  A couple of years
ago I would have agreed hands down with Barney. These days i am tending to
lean the other way. I have found more and more that I can setup a more
productive environment on my own. MyEclipse has become heavier and slow and
in all honesty I find myself more productive with other plugins. With 100
developers and quite a few contractors coming in and out It is well worth
our time as a company to evaluate the plugins on the market find the best of
breed and distribute them, tools like pulse and yoxos make it tremendously
easy. Aside from Apanta, which is abit of hog, all the plugins I listed
previously are quick and nimble. To each his/her own though if you evaluate
myEclipse and like it, go for it like Barney said to him it is worth it and
I think many would agree.

Adam Haskell


On Mon, Mar 31, 2008 at 11:37 AM, Barney Boisvert <[EMAIL PROTECTED]>
wrote:

> I have to chime in here and say that MyEclipse isn't about saving
> money on plugins.  I can't say with absolute certainty, but I'm pretty
> sure that ever plugin MyEclipse comes with is freely available.  What
> MyEclipse does is pre-integrate them.  I pay my $50/yr and never have
> to worry about finding all that crap and it's dependencies.  I could
> set up a similar environment myself, no question, but it'd take at
> least an hour or three, which means it's more expensive than
> MyEclipse.
>
> If you look at TCO, MyEclipse is still an amazingly good deal.
>
> cheers,
> barneyb
>
> On Sun, Mar 30, 2008 at 8:19 PM, Adam Haskell <[EMAIL PROTECTED]> wrote:
> > MyEclipse is not worth the price, especially with the onset of WTP from
> >  eclipse foundation, and some other nice plugins. Check my blog entry
> out
> >  about setting up WTP,
> >  http://cfrant.blogspot.com/2008/03/jboss-eclipse-and-bluedragon.html .
> >  Beyond that here are some other eclipse plugins that are free:
> >
> >  xmlbuddy - http://xmlbuddy.com/2.0/products.html - the free edition is
> good
> >  enough for my uses and honestly comes close to matching MyEclispe
> >
> >  quantumDB - http://quantum.sourceforge.net/ - just as good as myeclipse
> >
> >  Aptanta - http://www.aptana.com/ - it is sort of heavy but a really
> robust
> >  JS, CSS and XML editor, once again the free edition is good enough.
> >
> >  Spket  - http://www.spket.com/ - an alternative to Aptana and very
> >  nice.Ihave not looked at XML in it but it does support Flex
> >  development too.
> >
> >  Fujaba - http://wwwcs.uni-paderborn.de/cs/fujaba/ - a bit flakey
> eclipse
> >  support but a nice free UML editor none the less. If i recall there is
> an
> >  eclipse project now for UML...I know there is an IBM product which is
> what
> >  we are evaluating at work.
> >
> >
> >  A few years ago I would have said MyEclipse is a no brainer, these days
> I
> >  don't believe that anymore. Even in java development it has become
> harder
> >  and harder to justify the cost. I know the cost difference is
> substantial
> >  but if I am going to spend money on an IDE these days for Java it will
> be
> >  spent on IntelliJ.
> >
> >  Adam Haskell
> >
>
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> http://www.barneyb.com/
>
> Got Gmail? I have 100 invites.
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302351
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: eclipse tutorials

2008-03-31 Thread Judith Dinowitz
Have you ever read our CFEclipse tutorials, by Robert Blackburn?

CFEclipse CFExplained Parts 1 and 2:
http://www.fusionauthority.com/techniques/4599-cfeclipse-cfexplained-part-i.htm
http://www.fusionauthority.com/Techniques/4607-CFEclipse-CFExplained-Part-II.htm

CFEclipse Features Series
Task List
http://www.fusionauthority.com/reviews/4619-cfeclipse-features-task-list.htm
Code Folding
http://www.fusionauthority.com/reviews/4631-cfeclipse-features-code-folding.htm
Tag Insight
http://www.fusionauthority.com/reviews/4633-cfeclipse-features-tag-insight.htm
Local History
http://www.fusionauthority.com/reviews/4648-cfeclipse-features-local-history.htm

Test Driven Development with ColdFusion part III (Integrating your tests into 
CFEclipse)
http://www.fusionauthority.com/techniques/4583-test-driven-development-with-coldfusion-part-iii.htm

We have also had a tutorial on using Flex Builder in Volume 2 Issue 2 of the 
Fusion Authority Quarterly Update that covered a lot of Eclipse issues. I know 
this is not online, but I figured it may help as well:

https://secure.houseoffusion.com/Vol2Issue2.cfm

Judith Dinowitz
Editor-in-Chief
Fusion Authority



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302350
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Larry Lyons
I agree. The plugins that come with MyEclipse make it very worth the $50 a 
year. The UML module alone is worth about that much, especially when compared 
to such behemoths as Magic Draw. The servers tab for controlling J2EE app 
servers, like JBoss or JRun, are incredibly useful. 

regards,
larry

>I have to chime in here and say that MyEclipse isn't about saving
>money on plugins.  I can't say with absolute certainty, but I'm pretty
>sure that ever plugin MyEclipse comes with is freely available.  What
>MyEclipse does is pre-integrate them.  I pay my $50/yr and never have
>to worry about finding all that crap and it's dependencies.  I could
>set up a similar environment myself, no question, but it'd take at
>least an hour or three, which means it's more expensive than
>MyEclipse.
>
>If you look at TCO, MyEclipse is still an amazingly good deal.
>
>cheers,
>barneyb
>
>On Sun, Mar 30, 2008 at 8:19 PM, Adam Haskell <[EMAIL PROTECTED]> wrote:
>
>-- 
>Barney Boisvert
>[EMAIL PROTECTED]
>http://www.barneyb.com/
>
>Got Gmail? I have 100 invites. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302349
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Smarty for CF

2008-03-31 Thread Barney Boisvert
You can very easily use any of the Java-based template engines (e.g.
Velocity) with CF, since CF is just Java.  Or you could use the Java 6
scripting engine support and run PHP inside your CF (check Sean
Corfield's blog) and use Smarty itself, though I don't know what kind
of performance implications that would have.

cheers,
barneyb

On Mon, Mar 31, 2008 at 10:18 AM, Kevin Aebig <[EMAIL PROTECTED]> wrote:
> Hey all,
>
>
>
>  Has anyone implemented a simple replacement template system like smarty?
>
>
>
>  Thanks,
>
>
>
>  !k
>
>
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302348
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 500 The ClientScope service is not available.

2008-03-31 Thread Mike Kear
I have never understood why a default CF installation has Client
variables stored in the registry.   I dont know anyone who uses them
stored there,  almost everyone i know  says it's a disaster waiting to
happen if you store them there ...

Does anyone konw the reason why that's the default?   OR even why it's
provided for in the first place?   Is there a reason why you'd store
them there thats better than other places?What circumstances might
those be - I can't think of any.


Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On 4/1/08, Brad Wood <[EMAIL PROTECTED]> wrote:
> Where are client variables stored on that server?
> Cookies?  Registry? *shudder* Database?
>
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302347
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


MS SQL 05 Express + CF8 + Vista, DSN setup failed (LCID 3076?)

2008-03-31 Thread henry ho
MS SQL 05 Express + CF8 + Vista

I've already enabled TCP/IP, and open for 127.0.0.1 (localhost).  I can connect 
that account through tcp/ip no problem using management studio express, but CF8 
(with built-in Microsoft SQL Server JDBC driver) just gives me this error 
message:

Connection verification failed for data source: 
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Unexpected LCID: 3076
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC 
Driver]Unexpected LCID: 3076


I purposely try a wrong password just to see what happen:

Connection verification failed for data source: 
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login 
failed for user 'cf'.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC 
Driver][SQLServer]Login failed for user 'cf'.


So this means the connection works, but what the hell is LCID 3076? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302346
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: FCKeditor

2008-03-31 Thread Mike Kear
Point of clarification ..   normally in a default ilnstallation of
fckeditor,   the file you want is in the 'editor' folder.

Also you didnt say, and I assumed you're not using CF8.  If you have
ColdFusion 8 FCKEditor is part of the core code and you can use a CF
tag to use it if you want (it's got a parameter in the CFTEXTAREA tag)
 but you can still set it up yourself if you want.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On 4/1/08, Mike Kear <[EMAIL PROTECTED]> wrote:
> Yes.  The "editorbasepath" parameter is pointing to the wrong place.
>
> It should point to the location of a file called fckkeditor.html.  in
> a default installation its in the same folder as the editor
>
> I normally have mine installed in a folder called fckeditor, which is
> located at /cfforms/scripts/fckeditorunder the root of the site.
>
> If you use the scripting/ cfc way of using the editor you should ahve
> something like this:
>
>  
> fckEditor =  createobject("component","cfforms.scripts.fckeditor.fckeditor");
> fckEditor.instanceName = "fieldname";
> fckEditor.value = '#ContentsOfFieldnamewhenitLoads';
> fckEditor.basePath = "/cfform/scripts/fckeditor/";
> fckEditor.toolbarset = "Default"; // or Basic for less functionality
> fckEditor.width = "90%";
> fckEditor.height = 500;
> fckEditor.create(); // create the editor.
> 
>
>
> HTH.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On 4/1/08, Rob Parkhill <[EMAIL PROTECTED]> wrote:
> > Good afternoon (or morning, or night),
> >
> > I have installed FCKeditor on my dev machine and have it working fine, but 
> > when I go to install to my hosted site, I get a 'page not found' error 
> > where the input box should be.  I haven't done anything special to the 
> > code.  It is a CF7 Server.
> >
> > Any thoughts?
> >
> > Thanks,
> >
> > Rob
> >
> > 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302345
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: FCKeditor

2008-03-31 Thread Mike Kear
Yes.  The "editorbasepath" parameter is pointing to the wrong place.

It should point to the location of a file called fckkeditor.html.  in
a default installation its in the same folder as the editor

I normally have mine installed in a folder called fckeditor, which is
located at /cfforms/scripts/fckeditorunder the root of the site.

If you use the scripting/ cfc way of using the editor you should ahve
something like this:

  
fckEditor =  createobject("component","cfforms.scripts.fckeditor.fckeditor");
fckEditor.instanceName = "fieldname";
fckEditor.value = '#ContentsOfFieldnamewhenitLoads';
fckEditor.basePath = "/cfform/scripts/fckeditor/";
fckEditor.toolbarset = "Default"; // or Basic for less functionality
fckEditor.width = "90%";
fckEditor.height = 500;
fckEditor.create(); // create the editor.



HTH.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On 4/1/08, Rob Parkhill <[EMAIL PROTECTED]> wrote:
> Good afternoon (or morning, or night),
>
> I have installed FCKeditor on my dev machine and have it working fine, but 
> when I go to install to my hosted site, I get a 'page not found' error where 
> the input box should be.  I haven't done anything special to the code.  It is 
> a CF7 Server.
>
> Any thoughts?
>
> Thanks,
>
> Rob
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302344
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: FCKeditor

2008-03-31 Thread Cutter (CFRelated)
Absolute pathing issue, guaranteed

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Rob Parkhill wrote:
> Good afternoon (or morning, or night),
> 
> I have installed FCKeditor on my dev machine and have it working fine, but 
> when I go to install to my hosted site, I get a 'page not found' error where 
> the input box should be.  I haven't done anything special to the code.  It is 
> a CF7 Server.
> 
> Any thoughts?
> 
> Thanks,
> 
> Rob 
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302343
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Smarty for CF

2008-03-31 Thread Kevin Aebig
Hey all,

 

Has anyone implemented a simple replacement template system like smarty? 

 

Thanks,

 

!k




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302342
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF RDS Capability question

2008-03-31 Thread Dave Watts
> Been pondering a very odd thing and wondered, I know that CF 
> can FTP to another server, but can one CF instance connect to 
> another via RDS?

RDS is just HTTP, so theoretically, yes.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302341
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfgrid

2008-03-31 Thread Chad Gray
I would like to use CFGrid to display some data from a database.

My database has one field that contains some XML data that I need to parse and 
get some information out of to place it in the CFGrid.  Right now I am looping 
over my query and parsing the XML so I can insert it into the CFGridRow tag.

I would like to instead bind the CFGrid to a CFC and I don't see a way to parse 
the XML before it gets to my CFGrid.

The only way I can think of is to query the database in the CFC then parse the 
XML and re-build the query using QueryNew() and the other Query functions then 
return it.

Can anyone think of a better way of binding the XML data to the CFGrid?


Example XML inside of the "JobNote" field in the database:



A
Archive
FTPed the files




Current Code that I am manually populating my cfgridrow:















 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302340
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: javascript and cfinput manipulation

2008-03-31 Thread Azadi Saryev
"required" attribute is purely cf attribute. there is no HTML 'required'
attrib in  fields.
if you look at the generated source code of your page you will not see
any 'required' attributes in the generated input fields.
when cf compiles the page, it replaces the required attribute with
necessary js to perform form validation.

bottom line: there is nothing to manipulate.
you should write your own form validation js based on ids/classes, which
can then be changed with an onlick events and will either trigger
validation or not.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Uwe Degenhardt wrote:
> Hi list,
> I cant get to a solution
> of the following problem.
>
> I have a cfinput-field like:
> a)  or
> b) 
>
> A javascript should manipulate the cfinput either like:
> required="yes" or
> required="no"
>
> How can I do this ? With the onclick-attribut ?
> But this doesn't influence the required-attribut.
>
> Uwe
>
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302339
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF 4.5 Custom Tag directory on Solaris.

2008-03-31 Thread Dave Watts
> Anybody care to recall where the custom tag directory might 
> reside on a Solaris installation of ColdFusion 4.5?

I'm guessing /opt/coldfusion/customtags. But you can find this in the
Registry (!) using the Registry Editor (!!). CF 4.5 on Solaris uses an
emulation layer to support the Windows Registry, if I recall correctly.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302338
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: javascript and cfinput manipulation

2008-03-31 Thread RICHARD SIMPSON
>Hi list,
>I cant get to a solution
>of the following problem.
>
>I have a cfinput-field like:
>a)  or
>b) 
>
>A javascript should manipulate the cfinput either like:
>required="yes" or
>required="no"
>
>How can I do this ? With the onclick-attribut ?
>But this doesn't influence the required-attribut.
>
>Uwe


Use  around this. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302337
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: eclipse tutorials

2008-03-31 Thread Bobby Hartsfield
That's the one I was thinking of...
http://cfeclipse.org/cfeclipsetv.cfm

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 31, 2008 10:29 AM
To: CF-Talk
Subject: Re: eclipse tutorials

On Mon, Mar 31, 2008 at 3:44 AM, Scott Raley -ITC <[EMAIL PROTECTED]>
wrote:
> using

any specific aspect of using Eclipse?

Mark's put together a series of video tutorials on CFEclipse...
http://cfeclipse.org/cfeclipsetv.cfm

There's the wiki on the CFeclipse.org site...
http://trac.cfeclipse.org/cfeclipse/

there's also the cfeclipse mailing list (not a tutorial per se, but
well, y'know)...
http://groups.google.com/group/cfeclipse-users

yeah, i know.  these are all CFEclipse resources, but they do touch on
parts of Eclipse itself.  hopefully that helps.

-- 
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. "Arf," she
said.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302336
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


FCKeditor

2008-03-31 Thread Rob Parkhill
Good afternoon (or morning, or night),

I have installed FCKeditor on my dev machine and have it working fine, but when 
I go to install to my hosted site, I get a 'page not found' error where the 
input box should be.  I haven't done anything special to the code.  It is a CF7 
Server.

Any thoughts?

Thanks,

Rob 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302335
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


FCKeditor

2008-03-31 Thread Rob Parkhill
Good afternoon (or morning, or night) 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302334
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Barney Boisvert
I have to chime in here and say that MyEclipse isn't about saving
money on plugins.  I can't say with absolute certainty, but I'm pretty
sure that ever plugin MyEclipse comes with is freely available.  What
MyEclipse does is pre-integrate them.  I pay my $50/yr and never have
to worry about finding all that crap and it's dependencies.  I could
set up a similar environment myself, no question, but it'd take at
least an hour or three, which means it's more expensive than
MyEclipse.

If you look at TCO, MyEclipse is still an amazingly good deal.

cheers,
barneyb

On Sun, Mar 30, 2008 at 8:19 PM, Adam Haskell <[EMAIL PROTECTED]> wrote:
> MyEclipse is not worth the price, especially with the onset of WTP from
>  eclipse foundation, and some other nice plugins. Check my blog entry out
>  about setting up WTP,
>  http://cfrant.blogspot.com/2008/03/jboss-eclipse-and-bluedragon.html .
>  Beyond that here are some other eclipse plugins that are free:
>
>  xmlbuddy - http://xmlbuddy.com/2.0/products.html - the free edition is good
>  enough for my uses and honestly comes close to matching MyEclispe
>
>  quantumDB - http://quantum.sourceforge.net/ - just as good as myeclipse
>
>  Aptanta - http://www.aptana.com/ - it is sort of heavy but a really robust
>  JS, CSS and XML editor, once again the free edition is good enough.
>
>  Spket  - http://www.spket.com/ - an alternative to Aptana and very
>  nice.Ihave not looked at XML in it but it does support Flex
>  development too.
>
>  Fujaba - http://wwwcs.uni-paderborn.de/cs/fujaba/ - a bit flakey eclipse
>  support but a nice free UML editor none the less. If i recall there is an
>  eclipse project now for UML...I know there is an IBM product which is what
>  we are evaluating at work.
>
>
>  A few years ago I would have said MyEclipse is a no brainer, these days I
>  don't believe that anymore. Even in java development it has become harder
>  and harder to justify the cost. I know the cost difference is substantial
>  but if I am going to spend money on an IDE these days for Java it will be
>  spent on IntelliJ.
>
>  Adam Haskell
>

-- 
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302333
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: inefficient query

2008-03-31 Thread Mark Kruger
Mike,

Are you making sure that either product_id or cat_id is required? If not
then this query has the potential to select all the records from your DB.
You also need to specify actual columns rather than the asterisk.

As for complexity - I've seen far worse :)

I would use aliases instead of full table qualifiers (saves typing).

Finally you are allowing arguments.order_key through the function. This will
be (I assume) a string like "cat_id DESC"  My caution would be that you
make sure this string is properly validated at the server to insure it is
indeed a column. If this argument comes from user input (like a drop down
box) then it beomes an excellent candidate for SQL injection. Lot's of folks
forget about "order by" clauses... It's pretty common to use user input to
allow a user to order a column in this way.

-Mark


Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Mike Little [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 30, 2008 8:32 PM
To: CF-Talk
Subject: Re: inefficient query

the following being my query...

am i trying to do too much with one query?


SELECT product.*, product_description.*, product_options.*,
categories_description.cat_title
FROM product 
INNER JOIN product_description ON product.product_id =
product_description.product_id
INNER JOIN categories ON product.cat_id = categories.cat_id
INNER JOIN categories_description ON categories.cat_id =
categories_description.cat_id
LEFT OUTER JOIN artist ON product.artist_id =
artist.artist_id
LEFT OUTER JOIN product_to_product_options ON
product.product_id = product_to_product_options.product_id
LEFT OUTER JOIN product_options ON
product_to_product_options.product_options_id =
product_options.product_options_id
WHERE 1=1

AND product.product_id = 


AND product.cat_id = 

ORDER BY #arguments.order_key#
 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302332
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: 500 The ClientScope service is not available.

2008-03-31 Thread Brad Wood
Where are client variables stored on that server?
Cookies?  Registry? *shudder* Database?

Check your cfserver.log file at the time he received the error.  Chances
are there was a client variable purge going on, or a connectivity issue
with the client storage database.

~Brad

-Original Message-
From: Rob O'Brien [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 28, 2008 5:48 PM
To: CF-Talk
Subject: 500 The ClientScope service is not available.

Fellow CF Junkies:

 

A client has just reported an error he received while running a monthly
task, using a CF script I wrote over 6 months ago and has never produced
any
trouble.

 

"500 The ClientScope service is not available."

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302331
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: eclipse tutorials

2008-03-31 Thread Charlie Griefer
On Mon, Mar 31, 2008 at 3:44 AM, Scott Raley -ITC <[EMAIL PROTECTED]> wrote:
> using

any specific aspect of using Eclipse?

Mark's put together a series of video tutorials on CFEclipse...
http://cfeclipse.org/cfeclipsetv.cfm

There's the wiki on the CFeclipse.org site...
http://trac.cfeclipse.org/cfeclipse/

there's also the cfeclipse mailing list (not a tutorial per se, but
well, y'know)...
http://groups.google.com/group/cfeclipse-users

yeah, i know.  these are all CFEclipse resources, but they do touch on
parts of Eclipse itself.  hopefully that helps.

-- 
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. "Arf," she
said.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302330
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Gerald Guido
Adam... Thanks for turning me on to ondemand.yoxos.com. Wow.

Very few web apps leave me with a loss of words. That has to be one of the
coolest apps I have ever seen. Evar.

I did a search for Aptana and it was listed under OMFG Rather
appropriate.

G

On Mon, Mar 31, 2008 at 9:38 AM, Adam Haskell <[EMAIL PROTECTED]> wrote:

> Thanks for reminding me. I ment to post a link to Yoxos,
> http://ondemand.yoxos.com/geteclipse/start . I am working on a profile to
> open up to everyone, but I am waiting for BlueDragon to release so I can
> get
> that in there, so May 4th.
>
> Adam Haskell
>
> On Mon, Mar 31, 2008 at 9:25 AM, Gerald Guido <[EMAIL PROTECTED]>
> wrote:
>
> > You can get all of these plugins (I think) with out having to install
> them
> > one at a time by using Pulse. Except for XML buddy (I think).
> >
> > http://www.poweredbypulse.com/
> >
> > Basically you can make custom eclipse builds and Pulse manages all the
> > dependencies for you. Including a couple CFEclipse builds and Aptana. It
> > is
> > a very slick tool.
> >
> > V 2 didn't have all the kinks worked out last time I tried it. It takes
> a
> > lot of the grief out of creating custom eclipse builds. Kinda like how
> > Linux
> > package managers manage all your dependencies.
> >
> > You can try out MyEclipse with Pulse as well.
> >
> > hth,
> > G
> >
> >
> > On Sun, Mar 30, 2008 at 11:19 PM, Adam Haskell <[EMAIL PROTECTED]>
> > wrote:
> >
> > > MyEclipse is not worth the price, especially with the onset of WTP
> from
> > > eclipse foundation, and some other nice plugins. Check my blog entry
> out
> > > about setting up WTP,
> > > http://cfrant.blogspot.com/2008/03/jboss-eclipse-and-bluedragon.html .
> > > Beyond that here are some other eclipse plugins that are free:
> > >
> > > xmlbuddy - http://xmlbuddy.com/2.0/products.html - the free edition is
> > > good
> > > enough for my uses and honestly comes close to matching MyEclispe
> > >
> > > quantumDB - http://quantum.sourceforge.net/ - just as good as
> myeclipse
> > >
> > > Aptanta - http://www.aptana.com/ - it is sort of heavy but a really
> > robust
> > > JS, CSS and XML editor, once again the free edition is good enough.
> > >
> > > Spket  - http://www.spket.com/ - an alternative to Aptana and very
> > > nice.Ihave not looked at XML in it but it does support Flex
> > > development too.
> > >
> > > Fujaba - http://wwwcs.uni-paderborn.de/cs/fujaba/ - a bit flakey
> eclipse
> > > support but a nice free UML editor none the less. If i recall there is
> > an
> > > eclipse project now for UML...I know there is an IBM product which is
> > what
> > > we are evaluating at work.
> > >
> > >
> > > A few years ago I would have said MyEclipse is a no brainer, these
> days
> > I
> > > don't believe that anymore. Even in java development it has become
> > harder
> > > and harder to justify the cost. I know the cost difference is
> > substantial
> > > but if I am going to spend money on an IDE these days for Java it will
> > be
> > > spent on IntelliJ.
> > >
> > > Adam Haskell
> > >
> > >
> > >
> >
> >
> > --
> > "Education is a progressive discovery of our own ignorance."
> > - Will Durant
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302329
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF8: Class not found: coldfusion.sql.QueryTable

2008-03-31 Thread Gaulin, Mark
I just tried compiling both ways and my classes compile to the exact
same bytecode no matter which version of the cfusion jar I compile with,
so that's not it.  

Thanks for the idea though.

Thanks
Mark

-Original Message-
From: C S [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 28, 2008 7:21 PM
To: CF-Talk
Subject: Re: CF8: Class not found: coldfusion.sql.QueryTable

>I can create this class with CreateObject("Java",
>"coldfusion.sql.QueryTable") from a CF page, but my java code (running 
>in the same JVM, configured as a servlet) apparently cannot.
>
>BTW, I compile the java code using a reference to the cfusion.jar file 
>on my local machine; the code only runs inside a real CF JVM (at least 
>it used to on CF7).

I do not have an answer, but are you compiling with the CF8 cfusion.jar
or MX7? I am wondering if it makes a difference.  




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302328
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: inefficient query

2008-03-31 Thread Gerald Guido
First thing I would do is get rid of the get all the SELECT *.

product.*, product_description.*, product_options.*,

This will save you three trips to the database. A quick way to grab the
fields of a table with out typing them is

Run a Select * FROM YourTable

And dump the list of Columns using #Myquery.ColumnList#



On Sun, Mar 30, 2008 at 9:31 PM, Mike Little <[EMAIL PROTECTED]> wrote:

> the following being my query...
>
> am i trying to do too much with one query?
>
>  password="#variables.DBpassword#" username="#variables.DBusername#">
>SELECT product.*, product_description.*, product_options.*,
> categories_description.cat_title
> FROM product
>INNER JOIN product_description ON product.product_id =
> product_description.product_id
> INNER JOIN categories ON product.cat_id =
> categories.cat_id
>INNER JOIN categories_description ON categories.cat_id =
> categories_description.cat_id
>LEFT OUTER JOIN artist ON product.artist_id =
> artist.artist_id
>LEFT OUTER JOIN product_to_product_options ON
> product.product_id = product_to_product_options.product_id
>LEFT OUTER JOIN product_options ON
> product_to_product_options.product_options_id =
> product_options.product_options_id
>WHERE 1=1
>
> AND product.product_id =  cfsqltype="cf_sql_integer" value="#arguments.product_id#">
> 
>
>AND product.cat_id =  cfsqltype="cf_sql_integer" value="#arguments.cat_id#">
>
>ORDER BY #arguments.order_key#
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302327
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Adam Haskell
Thanks for reminding me. I ment to post a link to Yoxos,
http://ondemand.yoxos.com/geteclipse/start . I am working on a profile to
open up to everyone, but I am waiting for BlueDragon to release so I can get
that in there, so May 4th.

Adam Haskell

On Mon, Mar 31, 2008 at 9:25 AM, Gerald Guido <[EMAIL PROTECTED]>
wrote:

> You can get all of these plugins (I think) with out having to install them
> one at a time by using Pulse. Except for XML buddy (I think).
>
> http://www.poweredbypulse.com/
>
> Basically you can make custom eclipse builds and Pulse manages all the
> dependencies for you. Including a couple CFEclipse builds and Aptana. It
> is
> a very slick tool.
>
> V 2 didn't have all the kinks worked out last time I tried it. It takes a
> lot of the grief out of creating custom eclipse builds. Kinda like how
> Linux
> package managers manage all your dependencies.
>
> You can try out MyEclipse with Pulse as well.
>
> hth,
> G
>
>
> On Sun, Mar 30, 2008 at 11:19 PM, Adam Haskell <[EMAIL PROTECTED]>
> wrote:
>
> > MyEclipse is not worth the price, especially with the onset of WTP from
> > eclipse foundation, and some other nice plugins. Check my blog entry out
> > about setting up WTP,
> > http://cfrant.blogspot.com/2008/03/jboss-eclipse-and-bluedragon.html .
> > Beyond that here are some other eclipse plugins that are free:
> >
> > xmlbuddy - http://xmlbuddy.com/2.0/products.html - the free edition is
> > good
> > enough for my uses and honestly comes close to matching MyEclispe
> >
> > quantumDB - http://quantum.sourceforge.net/ - just as good as myeclipse
> >
> > Aptanta - http://www.aptana.com/ - it is sort of heavy but a really
> robust
> > JS, CSS and XML editor, once again the free edition is good enough.
> >
> > Spket  - http://www.spket.com/ - an alternative to Aptana and very
> > nice.Ihave not looked at XML in it but it does support Flex
> > development too.
> >
> > Fujaba - http://wwwcs.uni-paderborn.de/cs/fujaba/ - a bit flakey eclipse
> > support but a nice free UML editor none the less. If i recall there is
> an
> > eclipse project now for UML...I know there is an IBM product which is
> what
> > we are evaluating at work.
> >
> >
> > A few years ago I would have said MyEclipse is a no brainer, these days
> I
> > don't believe that anymore. Even in java development it has become
> harder
> > and harder to justify the cost. I know the cost difference is
> substantial
> > but if I am going to spend money on an IDE these days for Java it will
> be
> > spent on IntelliJ.
> >
> > Adam Haskell
> >
> >
> >
>
>
> --
> "Education is a progressive discovery of our own ignorance."
> - Will Durant
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302326
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Anyone using a Web Application Firewall (WAF)??

2008-03-31 Thread Brian Love
Hello:
  I am just trying to poll the CF community to determine if anyone else has 
implemented a Web Application Firewall before.  We are currently looking into 
purchasing one, perhaps from Breach, Barracuda, or Imperva.  I am looking for 
any suggestions or comments on:

- Brand or product that was purchased and installed
- Ease of implementation
- Maintenance
- Any other experience or suggestions.

  Also, feel free to comment on any other solutions you might be using, such as 
the open source projects: mod_security for Apache or AQTronix for IIS

TIA,
Brian 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302325
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Eclipse vs MyEclipse

2008-03-31 Thread Gerald Guido
You can get all of these plugins (I think) with out having to install them
one at a time by using Pulse. Except for XML buddy (I think).

http://www.poweredbypulse.com/

Basically you can make custom eclipse builds and Pulse manages all the
dependencies for you. Including a couple CFEclipse builds and Aptana. It is
a very slick tool.

V 2 didn't have all the kinks worked out last time I tried it. It takes a
lot of the grief out of creating custom eclipse builds. Kinda like how Linux
package managers manage all your dependencies.

You can try out MyEclipse with Pulse as well.

hth,
G


On Sun, Mar 30, 2008 at 11:19 PM, Adam Haskell <[EMAIL PROTECTED]> wrote:

> MyEclipse is not worth the price, especially with the onset of WTP from
> eclipse foundation, and some other nice plugins. Check my blog entry out
> about setting up WTP,
> http://cfrant.blogspot.com/2008/03/jboss-eclipse-and-bluedragon.html .
> Beyond that here are some other eclipse plugins that are free:
>
> xmlbuddy - http://xmlbuddy.com/2.0/products.html - the free edition is
> good
> enough for my uses and honestly comes close to matching MyEclispe
>
> quantumDB - http://quantum.sourceforge.net/ - just as good as myeclipse
>
> Aptanta - http://www.aptana.com/ - it is sort of heavy but a really robust
> JS, CSS and XML editor, once again the free edition is good enough.
>
> Spket  - http://www.spket.com/ - an alternative to Aptana and very
> nice.Ihave not looked at XML in it but it does support Flex
> development too.
>
> Fujaba - http://wwwcs.uni-paderborn.de/cs/fujaba/ - a bit flakey eclipse
> support but a nice free UML editor none the less. If i recall there is an
> eclipse project now for UML...I know there is an IBM product which is what
> we are evaluating at work.
>
>
> A few years ago I would have said MyEclipse is a no brainer, these days I
> don't believe that anymore. Even in java development it has become harder
> and harder to justify the cost. I know the cost difference is substantial
> but if I am going to spend money on an IDE these days for Java it will be
> spent on IntelliJ.
>
> Adam Haskell
>
>
>


-- 
"Education is a progressive discovery of our own ignorance."
- Will Durant


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302324
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Tough nuts! -- possible bug with cfajaxproxy

2008-03-31 Thread Don L
>it should.
>
>Azadi Saryev
>Sabai-dee.com
>http://www.sabai-dee.com/

"shouldn't d.setCallbackHandler(passIdOn) be BEFORE d.doSave()?"

Yes, Azadi, I did change the order to no avail.  The b) possibility is very 
strong, another sign, when I clear the browser cache, a tiny tab showed up in 
the status bar, which never happened before or MS has changed the IE7.

Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302323
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: eclipse tutorials

2008-03-31 Thread Gerald Guido
Nathan Strutz has a bunch of stuff on his site. Some is a bit dated but
still pertinent.

http://www.dopefly.com/projects/cfeclipse.cfm
http://www.dopefly.com/techblog/?bycategory=5


On Mon, Mar 31, 2008 at 6:44 AM, Scott Raley -ITC <[EMAIL PROTECTED]>
wrote:

> using
>
> -Original Message-
> From: Mark Mandel [mailto:[EMAIL PROTECTED]
> Sent: Sunday, March 30, 2008 8:27 PM
> To: CF-Talk
> Subject: Re: eclipse tutorials
>
> Scott, for using eclipse, or for building plugins?
>
> Mark
>
> On Mon, Mar 31, 2008 at 11:22 AM, Scott Raley -ITC <[EMAIL PROTECTED]>
> wrote:
> > Can anyone recommend any online eclipse tutorials. I see there are a
> > few  books on the market, just wondering if there is anything free
> > online worth  taking a look at before purchasing a book.
> >
> >  Thanks
> >
> >
> >
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302322
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: eclipse tutorials

2008-03-31 Thread Scott Raley -ITC
using 

-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 30, 2008 8:27 PM
To: CF-Talk
Subject: Re: eclipse tutorials

Scott, for using eclipse, or for building plugins?

Mark

On Mon, Mar 31, 2008 at 11:22 AM, Scott Raley -ITC <[EMAIL PROTECTED]>
wrote:
> Can anyone recommend any online eclipse tutorials. I see there are a 
> few  books on the market, just wondering if there is anything free 
> online worth  taking a look at before purchasing a book.
>
>  Thanks
>
>
>  



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302321
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4