date:20070105

AJ Mercer wrote:
 I have an idea for a free ColdFusion server product that would I like to put
 out there for discussion : A CF runtime server
 
 The runtime server is like the CF server, but with no compiler.
 You develop and compile your web application on a licensed product, and then
 package it up as a sourceless deploy. This could then be put on a server
 with the CF runtime product.

Your runtime server already exists. Just compile your application into an EAR 
file in your development environment and deploy it to any J2EE server.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Issue with not of type numeric when sending value to CFC

Daniel Short wrote:

 http://www.dansshorts.com/?day=1/4/2007#blog360
 
 What's happening is that if I take a recordset row, and build a structure
 based on it's columns, and then pass that structure as an ArgumentCollection
 to a CFC, the method tosses a not of type numeric on a value that is
 indeed numeric.

Seen it before with a webservice. IsNumeric() returned true on the argument, 
yet when I passed it in I got the not of type numeric error. I'm still 
supposed to file a bug for it, but I don't have access to the code with this 
problem anymore.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RFC: CFMX Runtime Server

2007-01-05 Thread AJ Mercer

you mean something like tomcat or jBoss?

I was wonder if that was possible.

On 1/5/07, Jochem van Dieten [EMAIL PROTECTED] wrote:

 AJ Mercer wrote:
  I have an idea for a free ColdFusion server product that would I like to
 put
  out there for discussion : A CF runtime server
 
  The runtime server is like the CF server, but with no compiler.
  You develop and compile your web application on a licensed product, and
 then
  package it up as a sourceless deploy. This could then be put on a server
  with the CF runtime product.

 Your runtime server already exists. Just compile your application into an
 EAR file in your development environment and deploy it to any J2EE server.

 Jochem

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RFC: CFMX Runtime Server

AJ Mercer wrote:
 you mean something like tomcat or jBoss?

Yes.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RFC: CFMX Runtime Server

2007-01-05 Thread Neil Middleton

OK, well working on that basis - what is to stop me from buying only one
server for building my WAR files and deploying them to a whole host of j2ee
containers in my test and production environments?  Even more than that, do
I even have to pay for CFMX is dev edition is free (assuming it can also do
WAR deployment - haven't got a copy to hand)?

Neil

On 1/5/07, Jochem van Dieten [EMAIL PROTECTED] wrote:

 AJ Mercer wrote:
  I have an idea for a free ColdFusion server product that would I like to
 put
  out there for discussion : A CF runtime server
 
  The runtime server is like the CF server, but with no compiler.
  You develop and compile your web application on a licensed product, and
 then
  package it up as a sourceless deploy. This could then be put on a server
  with the CF runtime product.

 Your runtime server already exists. Just compile your application into an
 EAR file in your development environment and deploy it to any J2EE server.

 Jochem

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RDS in CFECLIPSE. What's Wrong?

On Thursday 04 January 2007 17:15, Dwayne Cole wrote:
Frankly, I don't want to remove it. I just want it to work. I was going to
remove the RDS plugin, then reinstall it, hoping that that would work.

Can it wait till next week ?

--
Tom Chiverton
Helping to proactively harvest scalable functionalities

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at St
James's Court Brown Street Manchester M2 2JF. A list of members is available
for inspection at the registered office. Any reference to a partner in relation
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be
confidential or legally privileged. If you are not the addressee you must not
read it and must not use any information contained in nor copy it nor inform
any person other than Halliwells LLP or the addressee of its existence or
contents. If you have received this email in error please delete it and notify
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

On Thursday 04 January 2007 18:23, Keith McGee wrote:
We are using the Cingular 8125.

What O/S and web browser is this ?
How is the printer attached ?
Is this a there and then print, or a save of the results to print later ?

--
Tom Chiverton
Helping to vitalistically compete sticky initiatives

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Richest ColdFusion E-Commerce Site

2007-01-05 Thread Will Tomlinson

The site I am currently working on is pretty good.

www.uwish.co.uk

Goodness gracious James! Talkin' bout sexy CF apps, Tone  Tease with Abi 
Titmus?? You got me hooked on this one!  :)

Will

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RFC: CFMX Runtime Server

Neil Middleton wrote:
 OK, well working on that basis - what is to stop me from buying only one
 server for building my WAR files and deploying them to a whole host of j2ee
 containers in my test and production environments?

Your professional ethic. Just like your professional ethic is stopping you from 
using the same license key on more servers then it is valid for.


  Even more than that, do
 I even have to pay for CFMX is dev edition is free (assuming it can also do
 WAR deployment - haven't got a copy to hand)?

It can, but everything you build will have the IP address limit.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

What O/S and web browser is this?
Microsoft Windows Mobil ver. 5.0. OS 5.1.195, The Platform is pocketPC, 
Internet Explorer is the browser.

How is the printer attached?
The Printer is Blue Tooth. 

Is this a there and then print, or a save of the results to print later?
Can program it either way. There and then would be more convenient when the 
algorithms are completed and the results a displayed. But I can send the 
results to the local dive if necessary.

Thanks
Keith

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Richest ColdFusion E-Commerce Site

2007-01-05 Thread James Smith

 Goodness gracious James! Talkin' bout sexy CF apps, Tone  
 Tease with Abi Titmus?? You got me hooked on this one!  :)

It's a bargain at £4.99 as well! ;-)

--
James Smith - IT Director
uWish Ltd - http://www.uWish.co.uk 


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Richest ColdFusion E-Commerce Site

2007-01-05 Thread Adrian Lynch

Has Abi made an impact over the ocean? Next you'll be telling me you know
who Harry Potter is! :OD

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 05 January 2007 10:39
To: CF-Talk
Subject: Re: Richest ColdFusion E-Commerce Site

The site I am currently working on is pretty good.

www.uwish.co.uk

Goodness gracious James! Talkin' bout sexy CF apps, Tone  Tease with Abi
Titmus?? You got me hooked on this one!  :)

Will

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

X Forms like X Files...

2007-01-05 Thread Will Tomlinson

I just ran into a strange bug in cfform/x-forms. 

There's a textarea in mine, and it started throwing  the ol' SQL Server 
binary/string data would be truncated error. 

After viewing the source in the form, I noticed everytime you saved the data, 
it repopulated the textarea with a bunch of #13; in it.

The only way I can totally make it stop is by doing this:

 cftextarea name=shipperdesc label=Description cols=50 rows=5 
required=yes
  message=Enter a 
descriptioncfoutput#getshipperbyID.shipperdesc#/cfoutputcfsilent/cfsilent/cftextarea

It seems to work, but am I missing somethin? 

Thanks,
Will

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

ColdFusion OOP Security Framework

II have some notes on a new security model I am working on. Any feedback is
welcome.

http://docs.google.com/View?docid=ajb78vhj5x82_4gwc93c

Thank you,
Dan Vega
http://www.danvega.org/blog/


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

On Friday 05 January 2007 10:45, Keith McGee wrote:
Microsoft Windows Mobil ver. 5.0. OS 5.1.195, The Platform is pocketPC,
Internet Explorer is the browser.

Do the normal 'print this page' things not work ?

--
Tom Chiverton
Helping to appropriately scale leading-edge deliverables

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Using a tag system like del.icio.us(sort of)

On Thursday 04 January 2007 18:49, Jack Morgan wrote:
kind of cool to have the author replay to my question :)

Welcome to the internet in general, and a fairly fab. set of people in
general :-)

--
Tom Chiverton
Helping to heterogeneously develop virtual partnerships

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

OT: Easy SQL Question

I have a column in a db with a list of dates called emaildates. (i.e.:
1/10/2007,1/17/2007,1/24/2007)
I also define today's date as cfset todaysDate = DateFormat(Now(),
M/D/) / before the cfquery.

I am trying to find all entries where todaysDate is part of the list of
dates. My query is below, but does not work. Any idea what I might be doing
wrong? Thanks, Che


cfquery name=getScheduledEmails datasource=#DSN#
SELECT esid, emailtype, emaildates, filterdomains, emailsubject, emailbody,
timessent
FROM EmailScheduler
WHERE #todaysDate# IN emaildates
ORDER BY esid
/cfquery


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

^There is no print this page option. If there was that would solve my issue.

Here is my Internet Explorer menu on the PDA

Home
Favorites
add to favorites
foward
refresh history

veiw
zoom
tools
 ~send link via e-mail
 ~properties...
 ~options
edit
 ~cut
 ~copy
 ~past
 ~select all test

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

edit
 ~cut
 ~copy
 ~paste
 ~select all text

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: OT: Easy SQL Question

2007-01-05 Thread Damien McKenna

On 1/5/07 9:01 AM, Che Vilnonis wrote:
cfquery name=getScheduledEmails datasource=#DSN#
SELECT esid, emailtype, emaildates, filterdomains, emailsubject, emailbody,
timessent
FROM EmailScheduler
WHERE
emaildates like '%,#todaysDate#,%'
or emaildates like '#todaysDate#,%'
or emaildates like '%,#todaysDate#'
ORDER BY esid
/cfquery

Because you don't have commas on both sides of each date you have to search
for entries that don't have a comma on one side or the other, hence three
WHERE clauses.

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




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

slow query in cf but fast in Sql2k5 management studio.

2007-01-05 Thread Sicular, Alexander

Hello Gang,
I have a query that is running slow when processed by coldfusion but
fast via the sql2k5 management studio (on the order of 15 to 1). Are
there any connection specific issues between cfmx 6.1 (I know, I know)
and sql2k5 I should be aware of?

I downloaded the latest jdbc drivers from microsoft and am using them
via the 'other' driver settings when selecting a driver in the data
sources administrator. Just wondering if im missing something obvious or
otherwise.

Overall, my cf app is working fine against the sql2k5 database.

Tia, alex

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: OT: Easy SQL Question

Thanks Damien. I was stuck on using the IN clause which was not working. I
switched to LIKE and it works. Actually, it works w/o the commas and only
one where clause.

i.e. - WHERE emaildates like '%#todaysDate#%'

-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 9:22 AM
To: CF-Talk
Subject: Re: OT: Easy SQL Question

On 1/5/07 9:01 AM, Che Vilnonis wrote:
cfquery name=getScheduledEmails datasource=#DSN#
SELECT esid, emailtype, emaildates, filterdomains, emailsubject, emailbody,
timessent FROM EmailScheduler WHERE
emaildates like '%,#todaysDate#,%'
or emaildates like '#todaysDate#,%'
or emaildates like '%,#todaysDate#'
ORDER BY esid
/cfquery

Because you don't have commas on both sides of each date you have to search
for entries that don't have a comma on one side or the other, hence three
WHERE clauses.

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

2007-01-05 Thread Doug Brown

Can you post the query? That would help alot.

Doug B.
- Original Message - 
From: Sicular, Alexander [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 05, 2007 7:24 AM
Subject: slow query in cf but fast in Sql2k5 management studio.

 Hello Gang,
 I have a query that is running slow when processed by coldfusion but
 fast via the sql2k5 management studio (on the order of 15 to 1). Are
 there any connection specific issues between cfmx 6.1 (I know, I know)
 and sql2k5 I should be aware of?

 I downloaded the latest jdbc drivers from microsoft and am using them
 via the 'other' driver settings when selecting a driver in the data
 sources administrator. Just wondering if im missing something obvious or
 otherwise.

 Overall, my cf app is working fine against the sql2k5 database.

 Tia, alex

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Weird formatting problem

2007-01-05 Thread Doug Brown

I cannot look at this anymore. I have the following include that has a table 
with no cellpadding or cellspacing, but still shows spacing. Can anyone see why?

inc_navleftside_b.cfm


table cellpadding=0 cellspacing=0 bgcolor=#99
 tr
  td
table width=100% border=0 cellpadding=0 cellpsacing=0
  CFOUTPUT query = ResState
  tr
   td bgcolor=##CC width=100%a 
href=index.cfm?stateAbbrev=#resState.StateAbbrev##Trim(resState.StateName)#/a/td
  /tr
  /CFOUTPUT
 /table
 /td
/tr
/table


Where included...

   table border=0 cellspacing=0 cellpadding=0 width=100%
 !--- DISPLAY SUBCATS ---
 CFIF IsDefined(url.qcid)
  tr
   td valign=TOPCFINCLUDE template=inc_navleftside_a.cfm
   /td
  /tr
  tr
   td height=20nbsp;/td
  /tr
 /CFIF
 tr
  td valign=TOPCFINCLUDE template=inc_navleftside_b.cfm
  /td
 /tr
/table

Doug B.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: RFC: CFMX Runtime Server

They already have something to complete with Railo/Smith/BD
Its called ColdFusion MX

Russ 

-Original Message-
From: AJ Mercer [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 03:01
To: CF-Talk
Subject: Re: RFC: CFMX Runtime Server

Yep - something for Adobe to release - to compete with Railo/smith/BD.

On 1/5/07, Claude Schneegans [EMAIL PROTECTED] wrote:

 I guess the free/trail developer edition should not be able to
 produce the
 package that can be deployed to the runtime version.

 Oh, your idea is that Adobe would develop this tool? I thought you had 
 this idea for yourself ;-)

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

On Friday 05 January 2007 13:05, Keith McGee wrote:
^There is no print this page option. If there was that would solve my
issue.

I meant things like http://www.hypergurl.com/printpage.html

--
Tom Chiverton
Helping to paradigmatically integrate enterprise systems

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: RFC: CFMX Runtime Server

Nothing would stop you doing that, and I presume that is why CF has this
feature.
I believe you need CFMX Enterprise to actually do the sourceless deployment
though.

Russ 

-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 10:02
To: CF-Talk
Subject: Re: RFC: CFMX Runtime Server

OK, well working on that basis - what is to stop me from buying only one
server for building my WAR files and deploying them to a whole host of j2ee
containers in my test and production environments?  Even more than that, do
I even have to pay for CFMX is dev edition is free (assuming it can also do
WAR deployment - haven't got a copy to hand)?

Neil

On 1/5/07, Jochem van Dieten [EMAIL PROTECTED] wrote:

 AJ Mercer wrote:
  I have an idea for a free ColdFusion server product that would I 
  like to
 put
  out there for discussion : A CF runtime server
 
  The runtime server is like the CF server, but with no compiler.
  You develop and compile your web application on a licensed product, 
  and
 then
  package it up as a sourceless deploy. This could then be put on a 
  server with the CF runtime product.

 Your runtime server already exists. Just compile your application into 
 an EAR file in your development environment and deploy it to any J2EE
server.

 Jochem

 



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Richest ColdFusion E-Commerce Site

Perhaps the best solution would be to develop it in the way you are most
comfortable with, and provide an API for everyone else to make
modifications.

Russ 

-Original Message-
From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 01:50
To: CF-Talk
Subject: Re: Richest ColdFusion E-Commerce Site

Port it to FB 4 or 5 and it'll be the sexiest EVER! Is it in an MVC 
pattern in FB3?

No way! A large percentage of my users struggle with just the FB, MVC would
shatter their brains. LOL Seriously, the number of people that buy my
software that even have a clue about stuff like MVC and OO is so low that it
just isn't even a consideration to go there. That's assuming I had a year or
more to kill and completely reprogram it that way. Ecommerce buyers
generally care about two main things...the features the software has, and
how easy it will be for them to go in and make modifications. I try very
hard to cover both bases well, and moving to MVC really would not serve
either. Honestly, I do get far more people that complain that FB is too
confusing than ones that want something like MVC. Granted, there are
*definitely* some users that would like this, but it's a very small
minority. In a recent survey of my users, less than 20% even cared about
converting the software from FB3 to 4. They cared *way* more about the
actual feature set. So I've spent over a year making it the best, most
feature-rich software that I could. And I do believe I have that...I just
have to get all the last bits of code completed, everything beta-tested,
update all the docs, write all those complicated update scripts, etc. No
problem, I just won't sleep this month. ;-) And even after this release is
done, I have a pretty long list of even more feature and code improvements I
want to make and I hope to do another major release in a relatively short
time (1 year as opposed to typically several years.) E-commerce is still a
rapidly growing field and everytime people see something cool on Amazon.com,
they want it too. ;-) 

I think there are some experts around with alot of experience porting 
apps from FB3 to 4 or 5.

Sure, if I had thousands of dollars to pay them for it. Believe me, it would
be a pretty big undertaking to do, because it's not just a matter of
converting the basic code (which is difficult enough.) It has to be done in
a way that I don't have to make my current users completely redo all their
store layouts (the current system for product/category/store pages, etc. is
very tied into a FB3 layout system) and it has to deal with converting my
entire role permissions and content access system that is based on the Hal
Helms security model for FB3. The security system has been extended to do
all kinds of things in the software, from selling memberships to the store
to controlling which products an admin can edit, so it's going to be very
tricky to deal with and to update existing sites as well. It's a very
different matter to take an off-the-shelf software product and convert from
FB3 to FB5 than it is to take an individual site and do it, because I can't
leave all my current customers in the dust.

I bet if you gave a few licenses away to some Fuseboxers you'd get all 
the help you need. I would help out.

Oh, I have offered, to the ones that have bought my software. And a number
have offered to help in the past, but once they look at what *really* is
involved and the hurdles that have to be cleared, it usually scares them
off. After all, even a couple licenses doesn't go far in paying a
developer's salary. ;-) 

Still, if the CF community continues to grow and my new version is as
successful as I hope it will be, it may be more feasible for me to pay a
really top-notch Fuseboxer to help convert the code. I agree that the
improvements in FB4/5 are nothing to sneer at, and even though I do believe
it's a fair amount harder for newcomers to understand than 3, it's still a
goal of mine to get there at some point. But I still am proud of having one
of the few e-commerce products out there that follows *any* kind of
framework. It may not be the latest and greatest framework...but even if I
did get it converted, it would just be out-of-date again in a few years any
way! 

Mary Jo Sminkey
http://www.cfwebstore.com
CFWebstore, ColdFusion E-commerce

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: OT: Easy SQL Question

2007-01-05 Thread Adkins, Randy

Why not just one WHERE clause without the commas? It would still catch any item 
within the delimited list:


emaildates like '%#todaysDate#%'

That would catch any of the dates


 

-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 9:22 AM
To: CF-Talk
Subject: Re: OT: Easy SQL Question

On 1/5/07 9:01 AM, Che Vilnonis wrote:
cfquery name=getScheduledEmails datasource=#DSN# SELECT esid, emailtype, 
emaildates, filterdomains, emailsubject, emailbody, timessent FROM 
EmailScheduler WHERE
emaildates like '%,#todaysDate#,%'
or emaildates like '#todaysDate#,%'
or emaildates like '%,#todaysDate#'
ORDER BY esid
/cfquery

Because you don't have commas on both sides of each date you have to search for 
entries that don't have a comma on one side or the other, hence three WHERE 
clauses.

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






~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: ColdFusion OOP Security Framework

What does your security manager need from your generic Authenticator? Got a
quick uml of methods and variables from each? Im not sure what side of the
fence im on yet as far as cf needing interfaces. I am testing bd out right
now because their beta has interfaces.

On 1/5/07, Tom Chiverton [EMAIL PROTECTED] wrote:

On Friday 05 January 2007 13:28, Dan Vega wrote:
II have some notes on a new security model I am working on. Any feedback
is
welcome.

We inject a project specific 'Authenticator' CFC into a
generic 'SecurityManager' using ColdSpring.
And it'd look a lot nicer with cfinterface too :-)

--
Tom Chiverton
Helping to apprehensively mesh viral initiatives

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England
and Wales under registered number OC307980 whose registered office address
is at St James's Court Brown Street Manchester M2 2JF. A list of members is
available for inspection at the registered office. Any reference to a
partner in relation to Halliwells LLP means a member of Halliwells LLP.
Regulated by the Law Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and
may be confidential or legally privileged. If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents. If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Richest ColdFusion E-Commerce Site

2007-01-05 Thread Greg Luce

I get a js error on the homepage, but the ad is nice. :-)

On 1/5/07, Will Tomlinson [EMAIL PROTECTED] wrote:

 The site I am currently working on is pretty good.
 
 www.uwish.co.uk

 Goodness gracious James! Talkin' bout sexy CF apps, Tone  Tease with Abi
 Titmus?? You got me hooked on this one!  :)

 Will

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Richest ColdFusion E-Commerce Site

2007-01-05 Thread mjs

Take a look at Admin Pro Tools  E-Commerce Enterprise.  Very rich in features 
and very easy to customize.  
http://www.adminprotools.com/detail/index.cfm?nPID=18cid=3cdesc=Business%20Applications

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: OT: Easy SQL Question

2007-01-05 Thread Jim Wright

Che Vilnonis wrote:
 Thanks Damien. I was stuck on using the IN clause which was not working. I
 switched to LIKE and it works. Actually, it works w/o the commas and only
 one where clause.
 
 i.e. - WHERE emaildates like '%#todaysDate#%'
 

Be careful with that, because if your data is... 
'12/1/2006,11/1/2006,10/1/2006'
then
LIKE '%1/1/2006%' will be true and
LIKE '%2/1/2006%' will be true

Stay away from the delimited lists in columns...that data should be in a 
separate table where you can actually have a date datatype that doesn't 
allow invalid dates to be input, as well as making the comparisons very 
clear cut.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Richest ColdFusion E-Commerce Site

2007-01-05 Thread Greg Luce

That's impressive from the little bit of poking around I did.

On 1/4/07, Jon Clausen [EMAIL PROTECTED] wrote:

 Clark,

 I'm not sure if it's the richest or what bells and whistles you're
 looking for but my personal site and pet project is a highly-
 customized version of Cartweaver (EDI, Discounting, Accounting
 Exports to Quickbooks, Google Base, Pricegrabber, Geo-referenced
 Products,Downloads, etc.) running within the FarCry CMS:  http://
 www.ezods.com.

 My availability is pretty tight these days on the development front,
 but you can feel free to e-mail me off-list if any of the
 enhancements for CW (you would have to purchase the license) would be
 of interest to you.

 Regards,
 Jon

 On Jan 4, 2007, at 12:43 PM, Clark Valberg wrote:

  In preparation for an upcoming project my company is in search of
  the absolute richest (most features, best UI, smoothest user-
  experience) ColdFusion based e-commerce site (and its developer).
  Anyone have any opinions? personal plugs are welcome.



 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

thanks doug,

SELECT a,b,c,d,e,f
FROM tbl1
WHERE 1=1

AND 
( b = txt1
AND c = int1 )
OR 
( d IN (txt2,txt3)
AND e = txt4) 

ORDER BY f

the only thing specific that i can think of regarding this query is that 
columns d and e return long text (type text in sql2k5). 

Can you post the query? That would help alot.



Doug B.
- Original Message - 
From: Sicular, Alexander [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 05, 2007 7:24 AM
Subject: slow query in cf but fast in Sql2k5 management studio.




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Issue with not of type numeric when sending value to CFC

2007-01-05 Thread Daniel Short

Hi Jochem,

Yep, that's the problem I was seeing as well. I could do an isNumeric
outside the method call, and change the argument to type=any and do an
isNumeric inside the method call, but putting the type=numeric on the
cfargument caused it to choke every time. I'm going to be going back through
the code we've already written and make sure that I'm generating all of
these ArgumentCollection structs appropriately. If I find another case where
the code is correct, and the cfc still barks at it I'll post to the list
again.

Thanks all for your help.

Dan

On 1/5/07 2:40 AM, Jochem van Dieten [EMAIL PROTECTED] wrote:

Daniel Short wrote:

http://www.dansshorts.com/?day=1/4/2007#blog360

What's happening is that if I take a recordset row, and build a structure
based on it's columns, and then pass that structure as an ArgumentCollection
to a CFC, the method tosses a not of type numeric on a value that is
indeed numeric.

Seen it before with a webservice. IsNumeric() returned true on the argument,
yet when I passed it in I got the not of type numeric error. I'm still
supposed to file a bug for it, but I don't have access to the code with this
problem anymore.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: OT: Easy SQL Question

Jim, that is a very good point. I can see where 1/1/2006 and 11/1/2006 could
be a problem. Luckily, I am the one inputting the dates (so I know they'll
be valid) and the dates are only entered for a one month range. Once the
month is over, the entries are auto deleted from the db.

Thanks, Che



-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 9:41 AM
To: CF-Talk
Subject: Re: OT: Easy SQL Question


Che Vilnonis wrote:
 Thanks Damien. I was stuck on using the IN clause which was not 
 working. I switched to LIKE and it works. Actually, it works w/o the 
 commas and only one where clause.
 
 i.e. - WHERE emaildates like '%#todaysDate#%'
 

Be careful with that, because if your data is... 
'12/1/2006,11/1/2006,10/1/2006'
then
LIKE '%1/1/2006%' will be true and
LIKE '%2/1/2006%' will be true

Stay away from the delimited lists in columns...that data should be in a 
separate table where you can actually have a date datatype that doesn't 
allow invalid dates to be input, as well as making the comparisons very 
clear cut.



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: ColdFusion OOP Security Framework

I have the following roles based security model.

Every resource in my applications have a permission. Use use actual plain
text permission names so they are easy to remember, but a unique UUID can be
generated instead.

E.G.

USERS
 -View Users
 -Edit Users
 -Delete Users
 -Create users

I have a permission configuration tool that is part of my framework admin
interface.
I create my resources and then create all the permissions.

I then Create Groups (roles), and assign resources/permissions to those
groups.
A user is then assigned to a group.

When a user logs in, all their permissions are read in and stored in their
session.

I then have a UDF that checks permissions for each page for each user.

E.g.

cfif request.HasPermissions('permission required')
 process as normal
cfelse
 call my access denied module
/cfif

The UDF can easily be replaced by a CFC for your OOP type application.

--
Russ
 
 

-Original Message-
From: Dan Vega [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 14:33
To: CF-Talk
Subject: Re: ColdFusion OOP Security Framework

What does your security manager need from your generic Authenticator? Got a
quick uml of methods and variables from each? Im not sure what side of the
fence im on yet as far as cf needing interfaces. I am testing bd out right
now because their beta has interfaces.

On 1/5/07, Tom Chiverton [EMAIL PROTECTED] wrote:

 On Friday 05 January 2007 13:28, Dan Vega wrote:
  II have some notes on a new security model I am working on. Any 
  feedback
 is
  welcome.

 We inject a project specific 'Authenticator' CFC into a generic 
 'SecurityManager' using ColdSpring.
 And it'd look a lot nicer with cfinterface too :-)

 --
 Tom Chiverton
 Helping to apprehensively mesh viral initiatives

 

 This email is sent for and on behalf of Halliwells LLP.

 Halliwells LLP is a limited liability partnership registered in 
 England and Wales under registered number OC307980 whose registered 
 office address is at St James's Court Brown Street Manchester M2 2JF.  
 A list of members is available for inspection at the registered 
 office. Any reference to a partner in relation to Halliwells LLP means a
member of Halliwells LLP.
 Regulated by the Law Society.

 CONFIDENTIALITY

 This email is intended only for the use of the addressee named above 
 and may be confidential or legally privileged.  If you are not the 
 addressee you must not read it and must not use any information 
 contained in nor copy it nor inform any person other than Halliwells 
 LLP or the addressee of its existence or contents.  If you have 
 received this email in error please delete it and notify Halliwells LLP IT
Department on 0870 365 8008.

 For more information about Halliwells LLP visit www.halliwells.com.


 



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

init a cfc

Now this is something that really bugs me and I have never managed to
get working with CFCs.

 

What I have is a cfc like this:

 

cfcomponent name=QRY_financial displayname=financial stuff
hint=get common financial data

cfproperty name=dsn displayname=datasource hint=the
datasource name type=string /

cffunction name=init access=public output=false
returntype=void
   cfargument name=dsn type=string required=true
   cfscript
  setDsn(arguments.dsn);
   /cfscript
/cffunction

cffunction name=getDsn access=public output=false
returntype=string
   cfreturn dsn /
/cffunction

cffunction name=setDsn access=public output=false
returntype=void
   cfargument name=dsn type=string required=true /
   cfset dsn = arguments.dsn /
   cfreturn /
/cffunction

..more stuff

 

 

Which I think I should be able to call like this as I have seen all over
the web.

cfset finObj =
createObject(component,queries.QRY_financial).init(myDsn)

cfdump var=#finObj.getDsn()#

 

But when I do this I get an error from the Cfdump that:

Variable finObj is undefined

 

Now I have tried it a number of ways, without the specific init function
and calling the setDsn like this

cfset finObj =
createObject(component,queries.QRY_financial).setDsn(myDsn)

 

No joy here just the same thing.  I feel that I am missing out on
something fundamental here, can someone give me a tip or a hint as to
what I am doing wrong.

 

Thanks for reading.

 

Cheers

Martin 




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

just to add that if I do this:

cfset finObj = createObject(component,queries.QRY_financial)
cfset t = finObj.setDsn(myDsn)
cfdump var=#finObj.getDsn()#

it works fine and I get the correct string back.

P.S. I had forgot to scope the dsn in the variables scope in the original post


cffunction name=getDsn access=public output=false
returntype=string
   cfreturn variables.dsn /
/cffunction

cffunction name=setDsn access=public output=false
returntype=void
   cfargument name=dsn type=string required=true /
   cfset variables.dsn = arguments.dsn /
   cfreturn /
/cffunction


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

This also works fine, I just can't do it in a single call, I know it is only 2 
lines but I quite fancy doing it like this and it gets to me when something 
does not work as I feel it should.

This also works
cfset finObj = createObject(component,queries.QRY_financial)
cfset t = finObj.init(myDsn)

cfdump var=#finObj.getDsn()#

I am running 7.01

Now this is something that really bugs me and I have never managed to
get working with CFCs.

 

What I have is a cfc like this:

 

cfcomponent name=QRY_financial displayname=financial stuff
hint=get common financial data

cfproperty name=dsn displayname=datasource hint=the
datasource name type=string /

cffunction name=init access=public output=false
returntype=void
   cfargument name=dsn type=string required=true
   cfscript
  setDsn(arguments.dsn);
   /cfscript
/cffunction

cffunction name=getDsn access=public output=false
returntype=string
   cfreturn dsn /
/cffunction

cffunction name=setDsn access=public output=false
returntype=void
   cfargument name=dsn type=string required=true /
   cfset dsn = arguments.dsn /
   cfreturn /
/cffunction

.more stuff

 

 

Which I think I should be able to call like this as I have seen all over
the web.

cfset finObj =
createObject(component,queries.QRY_financial).init(myDsn)

cfdump var=#finObj.getDsn()#

 

But when I do this I get an error from the Cfdump that:

Variable finObj is undefined

 

Now I have tried it a number of ways, without the specific init function
and calling the setDsn like this

cfset finObj =
createObject(component,queries.QRY_financial).setDsn(myDsn)

 

No joy here just the same thing.  I feel that I am missing out on
something fundamental here, can someone give me a tip or a hint as to
what I am doing wrong.

 

Thanks for reading.

 

Cheers

Martin

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

Your init method is not returning anything back. When you say this

cfset finObj =
createObject(component,queries.QRY_financial).init(myDsn)

You are saying return to me what the init method returns. Usually this is an
instance of the component such as


cffunction name=init access=public output=false
returntype=Financial
   cfargument name=dsn type=string required=true
   cfscript
  setDsn(arguments.dsn);
   /cfscript
   cfreturn this
/cffunction

Also I would look into some naming conventions and uses for cfcs. A cfc is
not really meant to be used as a query collection but more as a represention
of real world objects. If you are new to cfc's this is completely
understandable but other than that looks great. Change the return and that
finObj should now have access to your methods.

Dan Vega
http://www.danvega.org



On 1/5/07, Martin Thorpe [EMAIL PROTECTED] wrote:

 Now this is something that really bugs me and I have never managed to
 get working with CFCs.



 What I have is a cfc like this:



 cfcomponent name=QRY_financial displayname=financial stuff
 hint=get common financial data

 cfproperty name=dsn displayname=datasource hint=the
 datasource name type=string /

 cffunction name=init access=public output=false
 returntype=void
cfargument name=dsn type=string required=true
cfscript
   setDsn(arguments.dsn);
/cfscript
 /cffunction

 cffunction name=getDsn access=public output=false
 returntype=string
cfreturn dsn /
 /cffunction

 cffunction name=setDsn access=public output=false
 returntype=void
cfargument name=dsn type=string required=true /
cfset dsn = arguments.dsn /
cfreturn /
 /cffunction

 ..more stuff





 Which I think I should be able to call like this as I have seen all over
 the web.

 cfset finObj =
 createObject(component,queries.QRY_financial).init(myDsn)

 cfdump var=#finObj.getDsn()#



 But when I do this I get an error from the Cfdump that:

 Variable finObj is undefined



 Now I have tried it a number of ways, without the specific init function
 and calling the setDsn like this

 cfset finObj =
 createObject(component,queries.QRY_financial).setDsn(myDsn)



 No joy here just the same thing.  I feel that I am missing out on
 something fundamental here, can someone give me a tip or a hint as to
 what I am doing wrong.



 Thanks for reading.



 Cheers

 Martin




 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

I Tried This and it didn't work

script language=Javascript

var message = Print this Page;

function printpage() {
window.print();  
}

document.write(forminput type=button 
+value=\+message+\ onClick=\printpage()\/form);

/script

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

 Your init method is not returning anything back. When you say this

cfset finObj =
createObject(component,queries.QRY_financial).init(myDsn)

You are saying return to me what the init method returns. Usually this is an
instance of the component such as


   cffunction name=init access=public output=false
returntype=Financial
  cfargument name=dsn type=string required=true
  cfscript
 setDsn(arguments.dsn);
  /cfscript
  cfreturn this
   /cffunction

Also I would look into some naming conventions and uses for cfcs. A cfc is
not really meant to be used as a query collection but more as a represention
of real world objects. If you are new to cfc's this is completely
understandable but other than that looks great. Change the return and that
finObj should now have access to your methods.

Dan Vega
http://www.danvega.org


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: ColdFusion OOP Security Framework

On Friday 05 January 2007 14:33, Dan Vega wrote:
What does your security manager need from your generic Authenticator?

Authenticator has one method:
checkLogin(user,pass)

You could go the whole hog and also have a Authoriser, with a signature like
canAccess(user,object,method)

--
Tom Chiverton
Helping to conveniently grow advanced relationships

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

On Friday 05 January 2007 14:49, Martin Thorpe wrote:
No joy here just the same thing. I feel that I am missing out on
something fundamental here, can someone give me a tip or a hint as to

A cfreturn this at the end of init() :-)

--
Tom Chiverton
Helping to confidentially implement virtual e-commerce

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

2007-01-05 Thread Teddy Payne

Martin,
You need to use the variables scope to be able to reference set values.  Try
this:

cfcomponent name=QRY_financial displayname=financial stuff hint=get
common financial data
cffunction name=init access=public output=false
returntype=void
cfargument name=dsn type=string required=true
cfset variables.dsn = arguments.dsn
/cffunction

cffunction name=setDsn access=public output=false
returntype=string
cfargument name=dsn type=string required=true

cfset variables.dsn = arguments.dsn
/cffunction

cffunction name=getDsn access=public output=false
returntype=string
cfreturn variables.dsn /
/cffunction
/cfcomponent
The variables scope is local to the CFC and all shared public and private
functions of the CFC.

If you always init this object, having a setDSN may be duplicate.  You will
typically either use an init to set the dsn or use the set method to put the
data in.  It depends on how to invoke the object.  This is refered to
constructor arguments versus setter injection arguments.  ColdSpring
framework uses these effectively to manage object invocation.

Cheers,
Teddy


On 1/5/07, Martin Thorpe [EMAIL PROTECTED] wrote:

 This also works fine, I just can't do it in a single call, I know it is
 only 2 lines but I quite fancy doing it like this and it gets to me when
 something does not work as I feel it should.

 This also works
 cfset finObj = createObject(component,queries.QRY_financial)
 cfset t = finObj.init(myDsn)

 cfdump var=#finObj.getDsn()#

 I am running 7.01

 Now this is something that really bugs me and I have never managed to
 get working with CFCs.
 
 
 
 What I have is a cfc like this:
 
 
 
 cfcomponent name=QRY_financial displayname=financial stuff
 hint=get common financial data
 
 cfproperty name=dsn displayname=datasource hint=the
 datasource name type=string /
 
 cffunction name=init access=public output=false
 returntype=void
cfargument name=dsn type=string required=true
cfscript
   setDsn(arguments.dsn);
/cfscript
 /cffunction
 
 cffunction name=getDsn access=public output=false
 returntype=string
cfreturn dsn /
 /cffunction
 
 cffunction name=setDsn access=public output=false
 returntype=void
cfargument name=dsn type=string required=true /
cfset dsn = arguments.dsn /
cfreturn /
 /cffunction
 
 .more stuff
 
 
 
 
 
 Which I think I should be able to call like this as I have seen all over
 the web.
 
 cfset finObj =
 createObject(component,queries.QRY_financial).init(myDsn)
 
 cfdump var=#finObj.getDsn()#
 
 
 
 But when I do this I get an error from the Cfdump that:
 
 Variable finObj is undefined
 
 
 
 Now I have tried it a number of ways, without the specific init function
 and calling the setDsn like this
 
 cfset finObj =
 createObject(component,queries.QRY_financial).setDsn(myDsn)
 
 
 
 No joy here just the same thing.  I feel that I am missing out on
 something fundamental here, can someone give me a tip or a hint as to
 what I am doing wrong.
 
 
 
 Thanks for reading.
 
 
 
 Cheers
 
 Martin

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

On Friday 05 January 2007 13:53, Keith McGee wrote:
I Tried This and it didn't work

Nothing happened ? JS error ? Does it work in a normal web browser ? ... ?

--
Tom Chiverton
Helping to collaboratively brand total models

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: OT: Easy SQL Question

2007-01-05 Thread Damien McKenna

On 1/5/07 9:25 AM, Che Vilnonis wrote:
 Thanks Damien.

No problem.

 Actually, it works w/o the commas and only one where clause.
 i.e. - WHERE emaildates like '%#todaysDate#%'

I wrote the query to prevent problems where you query previous dates, e.g.
where you are querying for e.g. 1/15/06 and have 11/15/06 in the database.
If you're sure you won't run into that scenario then the single would be
fine.

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




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Weird formatting problem

2007-01-05 Thread Teddy Payne

You have a table within a table within yet another table.  Why not remove
the last two tables and use CSS to format your links?  CSS is not that hard
to set the width, height, background color and text color.You could span
tags or some sort of container other than another table to set the CSS
formatting on.

Teddy

On 1/5/07, Doug Brown [EMAIL PROTECTED] wrote:

 I cannot look at this anymore. I have the following include that has a
 table with no cellpadding or cellspacing, but still shows spacing. Can
 anyone see why?

 inc_navleftside_b.cfm


 table cellpadding=0 cellspacing=0 bgcolor=#99
 tr
 td
table width=100% border=0 cellpadding=0 cellpsacing=0
  CFOUTPUT query = ResState
 tr
   td bgcolor=##CC width=100%a href=index.cfm
 ?stateAbbrev=#resState.StateAbbrev##Trim(resState.StateName)#/a/td
 /tr
 /CFOUTPUT
 /table
 /td
 /tr
 /table


 Where included...

   table border=0 cellspacing=0 cellpadding=0 width=100%
 !--- DISPLAY SUBCATS ---
 CFIF IsDefined(url.qcid)
  tr
   td valign=TOPCFINCLUDE template=inc_navleftside_a.cfm
   /td
  /tr
  tr
   td height=20nbsp;/td
  /tr
 /CFIF
 tr
  td valign=TOPCFINCLUDE template=inc_navleftside_b.cfm
  /td
 /tr
/table

 Doug B.

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

2007-01-05 Thread Dave Ferguson

One thing you have to remember is that sql management studio does not retrieve 
all the long text.  The amount of data returned to sql management studio vs CF 
will be considerably different.  Also, you are doing where clauses against the 
long text fields.  The way this query is written I would expect it to take a 
while.  If it is not a stored procedure it will take even longer.

--Dave
dfoncf.blogspot.com

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: init a cfc

Hello Dan, thanks for the reply.

Of course... I should have got that one myself.  A couple of queries is just 
the beginning of the object and will be used at the package level ultimately.

Thanks for the advice.

Your init method is not returning anything back. When you say this

cfset finObj =
createObject(component,queries.QRY_financial).init(myDsn)

You are saying return to me what the init method returns. Usually this is an
instance of the component such as

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

Nothing happens, Yes it works fine in a normal browser.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

searching xml

2007-01-05 Thread Phill B

I have this XML
root
  colors
color
  cname24K/cname
  typeflek/type
  value0xfbe680/value
  price0/price
  cid1/cid  
/color
color
  cnameBlack Mist/cname
  typeflek/type
  value0x22/value
  price0cid  
/color
  /colors
/root

I need to query the cname for the value Black Mist. Then I need to
get the index of its parent color. How the heck do I go about this?
I found that I can search for the cname value using this
XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
how do I get the parent position so that I can display all the nodes
in color ?

-- 
Phil

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

On Friday 05 January 2007 14:20, Keith McGee wrote:
Nothing happens, Yes it works fine in a normal browser.

Do you need something like
http://h2.www2.hp.com/bizsupport/TechSupport/DriverDownload.jsp?pnameOID=235049prodName=hp+mobile+printing+for+Pocket+PClocale=en_UStaskId=135prodTypeId=18972prodSeriesId=242184;
then ?

Disclaimer: I've no idea how broken Mobile IE is. Sounds like 'very'.
--
Tom Chiverton
Helping to advantageously embrace advanced e-markets

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Weird formatting problem

2007-01-05 Thread Dave Francis

I agree with Teddy. But even so, this code works OK in FF2 and IE7. Are 
you
sure you're not just seeing spaces where one table cell content is shorter
than another? Or possibly have td padding set in a stylesheet somewhere?

-Original Message-
From: Teddy Payne [mailto:[EMAIL PROTECTED]
Sent: Friday, January 05, 2007 10:21 AM
To: CF-Talk
Subject: Re: Weird formatting problem

You have a table within a table within yet another table.  Why not remove
the last two tables and use CSS to format your links?  CSS is not that hard
to set the width, height, background color and text color.You could span
tags or some sort of container other than another table to set the CSS
formatting on.

Teddy

On 1/5/07, Doug Brown [EMAIL PROTECTED] wrote:

 I cannot look at this anymore. I have the following include that has a
 table with no cellpadding or cellspacing, but still shows spacing. Can
 anyone see why?

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RDS in CFECLIPSE. What's Wrong?

2007-01-05 Thread Dwayne Cole

Well yes.  I can waite but you know how it is when you the brand new feature 
only keystrokes away. You end up waisting a bunch of time looking for a 
solution, and with eclipse, possible creating a real hair ball. 

Thanks Tom for what ever help you can give. 


-- Original Message --
From: Tom Chiverton [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date:  Fri, 5 Jan 2007 10:19:45 +


On Thursday 04 January 2007 17:15, Dwayne Cole wrote:
 Frankly, I don't want to remove it. I just want it to work.  I was going to
 remove the RDS plugin, then reinstall it, hoping that that would work.

Can it wait till next week ?

-- 
Tom Chiverton
Helping to proactively harvest scalable functionalities



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
St James's Court Brown Street Manchester M2 2JF.  A list of members is 
available for inspection at the registered office. Any reference to a partner 
in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by 
the Law Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may 
be confidential or legally privileged.  If you are not the addressee you must 
not read it and must not use any information contained in nor copy it nor 
inform any person other than Halliwells LLP or the addressee of its existence 
or contents.  If you have received this email in error please delete it and 
notify Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Print function for PDA

 Disclaimer: I've no idea how broken Mobile IE is. Sounds like 'very'.

It's not broken, but Windows Mobile is not Windows XP, and Pocket IE isn't
IE 7 (or 6, or 4). Windows Mobile is not a replacement for a general-purpose
X86 OS.

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

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Print function for PDA

 Nothing happens, Yes it works fine in a normal browser.

Pocket IE doesn't have a print option, because Windows Mobile devices
generally don't have printers. I suspect your best bet is to write a custom
..NET CF (Compact Framework, not ColdFusion) application that contains the
WebBrowser control:

http://msdn2.microsoft.com/en-us/library/ms229657.aspx

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

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: slow query in cf but fast in Sql2k5 management studio.

 SELECT a,b,c,d,e,f
 FROM tbl1
 WHERE 1=1
 
 AND
 ( b = txt1
 AND c = int1 )
 OR
 ( d IN (txt2,txt3)
 AND e = txt4) 
 
 ORDER BY f
 
 the only thing specific that i can think of regarding this 
 query is that columns d and e return long text (type text in sql2k5).

What happens if you only select the other columns? Do you see a difference
in execution speed then?

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

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: searching xml

2007-01-05 Thread Phill B

Never mind. I figured it out.

On 1/5/07, Phill B [EMAIL PROTECTED] wrote:
 I have this XML
 root
   colors
 color
   cname24K/cname
   typeflek/type
   value0xfbe680/value
   price0/price
   cid1/cid
 /color
 color
   cnameBlack Mist/cname
   typeflek/type
   value0x22/value
   price0cid
 /color
   /colors
 /root

 I need to query the cname for the value Black Mist. Then I need to
 get the index of its parent color. How the heck do I go about this?
 I found that I can search for the cname value using this
 XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
 how do I get the parent position so that I can display all the nodes
 in color ?

 --
 Phil



-- 
Phil

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

2007-01-05 Thread Jim Wright

Keith McGee wrote:
 Does anyone know of a way to print a web page or create a output file
 from a PDA using windows Mobil? I am writing a program in cold fusion
 where service guys need to print out the results of a test. I have
 tried to create .xls, .pdf, and .doc file outputs, (they work on the
 pc not on the pda) but I can't format them correctly for the PDA to
 open and print them. We are using the Cingular 8125.
 

Perhaps you could deliver your page as a PDF and use the Adobe reader to
print it (which does have a print option on Windows Mobile, I believe).


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: searching xml

2007-01-05 Thread Dawson, Michael

There should be a parent method to return that object.

Check this site: http://www.w3schools.com/xpath/xpath_syntax.asp 

-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 9:38 AM
To: CF-Talk
Subject: searching xml

I have this XML
root
  colors
color
  cname24K/cname
  typeflek/type
  value0xfbe680/value
  price0/price
  cid1/cid  
/color
color
  cnameBlack Mist/cname
  typeflek/type
  value0x22/value
  price0cid  
/color
  /colors
/root

I need to query the cname for the value Black Mist. Then I need to
get the index of its parent color. How the heck do I go about this?
I found that I can search for the cname value using this
XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now how
do I get the parent position so that I can display all the nodes in
color ?

--
Phil

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: searching xml

2007-01-05 Thread Teddy Payne

cfxml variable=myXML
root
 colors
   color
 cname24K/cname
 typeflek/type
 value0xfbe680/value
 price0/price
 cid1/cid
   /color
   color
 cnameBlack Mist/cname
 typeflek/type
 value0x22/value
 price0/price
 cid1/cid
   /color
 /colors
/root
/cfxml

!--- Search String ---
cfset sSearch = Black Mist

!--- Location of the color found  ---
cfset indexLocation = 0

!--- Root ---
cfset nRoot = myXML.XMLRoot

!--- Colors Root ---
cfset nColors = nRoot.XMLChildren[1]

cfloop from=1 to=#ArrayLen(nColors.XMLChildren)# index=i

!--- Color node currently looping through ---
cfset nColor = nColors.XMlChildren[i]

cfset nCname = nColor[cname]

cfif Trim(nCname.xmlText) eq sSearch
cfset indexLocation = i
/cfif

/cfloop

cfoutput#indexLocation#/cfoutput


On 1/5/07, Phill B [EMAIL PROTECTED] wrote:

 I have this XML
 root
 colors
color
  cname24K/cname
  typeflek/type
  value0xfbe680/value
  price0/price
  cid1/cid
/color
color
  cnameBlack Mist/cname
  typeflek/type
  value0x22/value
  price0cid
/color
 /colors
 /root

 I need to query the cname for the value Black Mist. Then I need to
 get the index of its parent color. How the heck do I go about this?
 I found that I can search for the cname value using this
 XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
 how do I get the parent position so that I can display all the nodes
 in color ?

 --
 Phil

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: RFC: CFMX Runtime Server

Snake wrote:
 I believe you need CFMX Enterprise to actually do the sourceless deployment
 though.

No, you need a J2EE server (like the free JBoss and Glassfish) or a Servlet 
engine (like Tomcat).

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: slow query in cf but fast in Sql2k5 management studio.

2007-01-05 Thread Porter, Benjamin L.

How much data is it returning?  A few rows, a few dozen, thousands,
hundreds of thousands, millions. Sql2k5 just displays the results of the
query. CF transforms the query into a java.util.Map which results in
processing time on the CF server in addition to the processing time on
the SQL server for each query. Also adding an appropriate blockfactor
may speed this up as the driver may be sending one row at a time back to
CF instead of as much as it can. 
Are you sure it is the query that is taking a long time or is it the
transformation of the query into whatever view you are making out of it?
Create a template with nothing in it but a cfquery call with the sql. Do
not dump it or anything and see whether the code that renders the query
results into something else is the culprit.

If you can rule out CF processing as the issue, post the execution plan
created. Maybe you are missing indexes etc. Try running the query with
out using cfqueryparam if you are and compare the timing.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 10:17 AM
To: CF-Talk
Subject: RE: slow query in cf but fast in Sql2k5 management studio.

 SELECT a,b,c,d,e,f
 FROM tbl1
 WHERE 1=1
 
 AND
 ( b = txt1
 AND c = int1 )
 OR
 ( d IN (txt2,txt3)
 AND e = txt4) 
 
 ORDER BY f
 
 the only thing specific that i can think of regarding this 
 query is that columns d and e return long text (type text in sql2k5).

What happens if you only select the other columns? Do you see a
difference
in execution speed then?

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

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



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Query of Queries question

2007-01-05 Thread Dave Phillips

Does anyone know if it's possible to extract a 'subset' of records in a query 
utilizing Query of Queries?  Basically I want to do something like this:

cfquery name=qMyQuery dbtype=query
SELECT * 
FROM qSomeQuery 
WHERE currentRow = 21 AND currentRow  41
ORDERY BY LastName
/cfquery

Of course, this doesn't work because currentrow does not specify the row number 
inside of a Query, only when you are working with the query results directly 
(like qSomeQuery.currentRow).

Anyone know how this is possible?  The only thing I can think of doing is 
something like this:

cfoutput name=qSomeQuery startRow=21 maxrows=40
   *** In here I would build a new query with only the rows available as I loop 
through with functions like queryAddRow() and querySetCell(). 
/cfoutput

This idea would not be very efficient, so I'm looking for an alternative method.

Thanks for your help in advance!

Dave

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

OT: Search Engines the indexing of javascript popup windows

Example URL:
http://www.karatekorner.com/dsp_LargeImage.cfm?imagename=217272lproducttitl
e=Adidas%20Merrit%20Sling

I have popup windows on my site that display large product photos that have
been indexed by search engines. The thing is, when a customer is refered by
a search engine by one of these indexed popup windows pages, the page does
not 'render' like a pop up window if the customer was already browsing my
site. It renders like a regular HTML page with a 'close window' button. The
user cannot click anywhere and if he/she clicks the 'close window' button,
I've lost the user from my site.

How can I determine where the user comes from? The CGI.HTTP_REFERER variable
works for Firefox, but not always from IE (basically, the CGI.HTTP_REFERER
sometimes has no value using IE).

Is there logic that can determine whether a page is rendered as a Javascript
popup window (with no page controls) vs. a regular html page? Perhaps that
would work???

I hope this makes sense.

Thanks, Che


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Query of Queries question

2007-01-05 Thread Jacob Munson

Does the result /have/ to be a query? Could you make a structure
instead, using your cfoutput method? That should be pretty quick.

On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote:
Does anyone know if it's possible to extract a 'subset' of records in a query
utilizing Query of Queries? Basically I want to do something like this:

cfquery name=qMyQuery dbtype=query
SELECT *
FROM qSomeQuery
WHERE currentRow = 21 AND currentRow 41
ORDERY BY LastName
/cfquery

Of course, this doesn't work because currentrow does not specify the row
number inside of a Query, only when you are working with the query results
directly (like qSomeQuery.currentRow).

Anyone know how this is possible? The only thing I can think of doing is
something like this:

cfoutput name=qSomeQuery startRow=21 maxrows=40
*** In here I would build a new query with only the rows available as I
loop through with functions like queryAddRow() and querySetCell().
/cfoutput

This idea would not be very efficient, so I'm looking for an alternative
method.

Thanks for your help in advance!

Dave

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

thanks porter, i took your advice and just set up a plain cfm page with four
versions
of that query.

1. no cfqueryparam all columns
Time=31ms, Records=210

2. no cfqueryparam no txt columns
Time=31ms, Records=210

3. cfqueryparam all columns
Time=17297ms, Records=210

4. cfqueryparam no txt columns
Time=16359ms, Records=210

turns out the cfqueryparam is giving me the problem here. any thoughts? i use
cfqueryparam mostly everywhere as a rule and never ran into this problem. like,
why here, why now?

-alex

How much data is it returning? A few rows, a few dozen, thousands,
hundreds of thousands, millions. Sql2k5 just displays the results of the
query. CF transforms the query into a java.util.Map which results in
processing time on the CF server in addition to the processing time on
the SQL server for each query. Also adding an appropriate blockfactor
may speed this up as the driver may be sending one row at a time back to
CF instead of as much as it can.
Are you sure it is the query that is taking a long time or is it the
transformation of the query into whatever view you are making out of it?
Create a template with nothing in it but a cfquery call with the sql. Do
not dump it or anything and see whether the code that renders the query
results into something else is the culprit.

If you can rule out CF processing as the issue, post the execution plan
created. Maybe you are missing indexes etc. Try running the query with
out using cfqueryparam if you are and compare the timing.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Query of Queries question

2007-01-05 Thread Greg Morphis

not sure what DB you're using.. but with Oracle you can do this in a subquery
select * from
(
select rownum as rn, n.*
From navmenu n
)
where rn = 5 and rn = 7



On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote:
 Does anyone know if it's possible to extract a 'subset' of records in a query 
 utilizing Query of Queries?  Basically I want to do something like this:

 cfquery name=qMyQuery dbtype=query
 SELECT *
 FROM qSomeQuery
 WHERE currentRow = 21 AND currentRow  41
 ORDERY BY LastName
 /cfquery

 Of course, this doesn't work because currentrow does not specify the row 
 number inside of a Query, only when you are working with the query results 
 directly (like qSomeQuery.currentRow).

 Anyone know how this is possible?  The only thing I can think of doing is 
 something like this:

 cfoutput name=qSomeQuery startRow=21 maxrows=40
*** In here I would build a new query with only the rows available as I 
 loop through with functions like queryAddRow() and querySetCell().
 /cfoutput

 This idea would not be very efficient, so I'm looking for an alternative 
 method.

 Thanks for your help in advance!

 Dave

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Search Engines the indexing of javascript popup windows

I have popup windows on my site that display large product
photos that have been indexed by search engines. The thing
is, when a customer is refered by a search engine by one of
these indexed popup windows pages, the page does not 'render'
like a pop up window if the customer was already browsing my
site. It renders like a regular HTML page with a 'close
window' button. The user cannot click anywhere and if he/she
clicks the 'close window' button, I've lost the user from my site.

How can I determine where the user comes from? The
CGI.HTTP_REFERER variable works for Firefox, but not always
from IE (basically, the CGI.HTTP_REFERER sometimes has no
value using IE).

Is there logic that can determine whether a page is rendered
as a Javascript popup window (with no page controls) vs. a
regular html page? Perhaps that would work???

Using JavaScript, you can determine whether the window was opened by another
window - if you used window.open() to create the window, you can use
window.opener within the child window to identify the parent. With that
information, you could control the display of the contents, or force the
creation of the parent window and subsequently trigger the redisplay of the
child window.

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

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

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: slow query in cf but fast in Sql2k5 management studio.

 turns out the cfqueryparam is giving me the problem here. any 
 thoughts? i use cfqueryparam mostly everywhere as a rule and 
 never ran into this problem. like, why here, why now?

I don't know. However, there are a couple of approaches you can use to find
out more.

First, you might see if it's one specific CFQUERYPARAM that's causing the
problem.

Second, you might use SQL Profiler to capture your queries. You could then
compare their execution plans.

http://www.sqlservercentral.com/columnists/RDyess/obtainingqueryexecutionpla
nsthroughsqlprofilertrac.asp

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

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

pageEncoding - which one to pick.

2007-01-05 Thread Ian Skinner

So can anybody point me to a good for dummies description of the common 
encodings.  When and why one would choose a specific encoding over another?

The following list includes commonly used values:

utf-8 
iso-8859-1 
windows-1252 
us-ascii 
shift_jis 
iso-2022-jp 
euc-jp 
euc-kr 
big5 
euc-cn 
utf-16




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

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

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Search Engines the indexing of javascript popup windows

Dave, the JS function to launch the new window is below. Would might code
look like on the popup (child) page to do this? I'm not a JS pro by any
means. Thanks, Che.

script language=JavaScript
function NewWindow(mypage, myname, w, h, scroll) {
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
self.name = mainWin;
winprops =
'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+',r
esizable'
win = window.open(mypage, myname, winprops)
if (parseInt(navigator.appVersion) = 4) { win.window.focus(); }
}
/script

Using JavaScript, you can determine whether the window was opened by another
window - if you used window.open() to create the window, you can use
window.opener within the child window to identify the parent. With that
information, you could control the display of the contents, or force the
creation of the parent window and subsequently trigger the redisplay of the
child window.

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


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: pageEncoding - which one to pick.

2007-01-05 Thread Jacob Munson

This article is kind of long, but it's what I used to learn about this stuff:
http://www.joelonsoftware.com/articles/Unicode.html

On 1/5/07, Ian Skinner [EMAIL PROTECTED] wrote:
 So can anybody point me to a good for dummies description of the common 
 encodings.  When and why one would choose a specific encoding over another?

 The following list includes commonly used values:

 utf-8
 iso-8859-1
 windows-1252
 us-ascii
 shift_jis
 iso-2022-jp
 euc-jp
 euc-kr
 big5
 euc-cn
 utf-16




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

 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.



 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

 
 1. no cfqueryparam all columns
 Time=31ms, Records=210
 
 2. no cfqueryparam no txt columns
 Time=31ms, Records=210
 
 3. cfqueryparam all columns
 Time=17297ms, Records=210
 
 4. cfqueryparam no txt columns
 Time=16359ms, Records=210
 
 
 turns out the cfqueryparam is giving me the problem here. any 
 thoughts? i use cfqueryparam mostly everywhere as a rule and never ran 
 into this problem. like, why here, why now?

Are you using any 'N' fields in your database? Have you set 
sendStringParametersAsUnicode in your JDBC URL? If not, set it to false and try 
again.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Search Engines the indexing of javascript popup windows

 Dave, the JS function to launch the new window is below. 
 Would might code look like on the popup (child) page to do 
 this? I'm not a JS pro by any means. Thanks, Che.

The code would depend on what exactly you want as a result, of course, but
if you just wanted to conditionally hide the close window button, it might
look like this:

if (!window.opener) {
document.getElementById('mybuttonname').style.visibility = 'hidden';
}

You could put this in a function, and call it using the onload event handler
of the body tag.

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

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: pageEncoding - which one to pick.

2007-01-05 Thread Paul Hastings

Ian Skinner wrote:
 So can anybody point me to a good for dummies description of the common
 encodings.  When and why one would choose a specific encoding over another?

unicode, because it handles pretty much all the languages on earth.

 The following list includes commonly used values:
 
 utf-8

this is the only one you'll ever need. keep repeating just use unicode it 
will 
become clear eventually ;-)

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Search Engines the indexing of javascript popup windows

Hmmm, I should have been more specific. How about...
if window opener is defined
show page as a normal popup
if not
redirect to a a specific page. say www.domain.com

Thanks. :)

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 12:42 PM
To: CF-Talk
Subject: RE: Search Engines  the indexing of javascript popup windows


 Dave, the JS function to launch the new window is below.
 Would might code look like on the popup (child) page to do 
 this? I'm not a JS pro by any means. Thanks, Che.

The code would depend on what exactly you want as a result, of course, but
if you just wanted to conditionally hide the close window button, it might
look like this:

if (!window.opener) {
document.getElementById('mybuttonname').style.visibility = 'hidden';
}

You could put this in a function, and call it using the onload event handler
of the body tag.

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

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



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

hi jochem,
yes, i am using nvarchar. column types are: 

a int
b nvarchar
c int
d text
e text 
f datetime


fyi, how would i set that param in the jdbc url? here is my current:
jdbc:sqlserver:// server1 : 1433 ;DatabaseName=db1


-alex

  
  1. no cfqueryparam all columns
  Time=31ms, Records=210
  
  2. no cfqueryparam no txt columns
  Time=31ms, Records=210
  
  3. cfqueryparam all columns
  Time=17297ms, Records=210
  
  4. cfqueryparam no txt columns
  Time=16359ms, Records=210
  
  
  turns out the cfqueryparam is giving me the problem here. any 
  thoughts? i use cfqueryparam mostly everywhere as a rule and never 
 ran 
  into this problem. like, why here, why now?
 
 Are you using any 'N' fields in your database? Have you set 
 sendStringParametersAsUnicode in your JDBC URL? If not, set it to 
 false and try again.
 
Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: pageEncoding - which one to pick.

2007-01-05 Thread Ian Skinner

this is the only one you'll ever need. keep repeating just use unicode it 
will become clear eventually ;-)


Then, why do I get question marks (?) for special characters such as accents, 
umlauts and tildes?  When I've experimented with the utf-8 encoding?  Which is 
what sent me on this quest in the first place.


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

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

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: slow query in cf but fast in Sql2k5 management studio.

thanks dave,
i tried various combinations of cfqueryparam usage to no avail. seems to be all 
or nothing. will try the profiler later tonight.

thanks for the link...
-alex

 turns out the cfqueryparam is giving me the problem here. any 
 thoughts? i use cfqueryparam mostly everywhere as a rule and 
 never ran into this problem. like, why here, why now?

I don't know. However, there are a couple of approaches you can use to find
out more.

First, you might see if it's one specific CFQUERYPARAM that's causing the
problem.

Second, you might use SQL Profiler to capture your queries. You could then
compare their execution plans.

http://www.sqlservercentral.com/columnists/RDyess/obtainingqueryexecutionpla
nsthroughsqlprofilertrac.asp

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

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

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Possible to fill in areas in a word document?

2007-01-05 Thread Bruce Sorge

If I have a word document as a template, can I use CFFILE to fill in blank
spots in it? I know that I can append to a document, but that is not what I
want to do, I want to fill in certain areas of the document.

 

Thanks,

 

Bruce Sorge

Contractor

City of Los Angeles

Department of Neighborhood Empowerment

 



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

TinyMCE editor problem

2007-01-05 Thread Chad McCue

I am using TinyMCE theme Simple on some of my pages, but when I submit
the form (Using ColdFusion MX 7) the textarea the TinyMCE is attached to
clears out. 
 
The correct information in the textbox before I click the Submit
button is sent to the submit page. I can't have the textbox clear out
because people are thinking the text they enter is being erased and not
saved.


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: pageEncoding - which one to pick.

2007-01-05 Thread Paul Hastings

Ian Skinner wrote:

 Then, why do I get question marks (?) for special characters such as accents,
 umlauts and tildes?  When I've experimented with the utf-8 encoding?  Which
 is what sent me on this quest in the first place.

because your data isn't unicode but you're telling the browser it is. it's like 
being told your blind date is an english speaking russian ballerina but she 
turns out to be a nose guard who can only converse in pig-latin. wouldn't you 
be 
confused?

one single encoding for all your data end-to-end is a lot simpler than trying 
to 
juggle dozens of page encodings. there's articles on cf dev center  cfdj about 
this. also chapters in the advanced cf books as well.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Print function for PDA

cfdocument will output the data on to the local drive, not in the right format. 
It is an xls file just not one the PDA can read. If I active sync the output 
over from my PC I can print it from the PDA.

Is there not a cfdocument or similar command to out put an xls or pdf in the 
proper format for Windows Mobil to read? There has to be a way to output the 
data into the proper format.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

CFcache how to clear browser cache

2007-01-05 Thread coldfusion . developer

All,

I've got an application that changes images and when the page refreshes, the
image change doesn't replace the original and show up until I refresh the page.

So I'm trying to clear the browser cache with cfcache, but it's not working.

Any ideas?

cfcache  
 action=flush 
 timespan=#CreateTimeSpan(0, 0, 0, 0)# 
 expireURL = *rotating_baby_image_preview.cfm?*


Thanks

D

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Possible to fill in areas in a word document?

2007-01-05 Thread Terry Schmitt

You can put an easily found place holder in the document, save the doc as 
RTF,(straight text) and then easily replace the place holder text with a value 
from your database or other source.

T

If I have a word document as a template, can I use CFFILE to fill in blank
spots in it? I know that I can append to a document, but that is not what I
want to do, I want to fill in certain areas of the document.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: CFcache how to clear browser cache

2007-01-05 Thread Pete Ruckelshaus

CFCACHE is server-side.  There is nothing that can be done to
explicitly clear the client browser cache via a web page.

Try using something like this:

cfheader name=Expires value=#Now()#
cfheader name=Pragma value=no-cache

which will force the browser to go to the server to get the page,
rather than drawing from the browser cache.

On 1/5/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 All,

 I've got an application that changes images and when the page refreshes, the
 image change doesn't replace the original and show up until I refresh the 
 page.

 So I'm trying to clear the browser cache with cfcache, but it's not working.

 Any ideas?

 cfcache
  action=flush
  timespan=#CreateTimeSpan(0, 0, 0, 0)#
  expireURL = *rotating_baby_image_preview.cfm?*


 Thanks

 D

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Possible to fill in areas in a word document?

2007-01-05 Thread Bruce Sorge

What about formatting? Like for instance, if they want to make certain text
bold, put in line breaks and paragraph formatting and the like (just basic
HTML), how will the document handle that? Will it retain the formatting or
just insert the HTML and ignore formatting? If this cannot be done then I
suppose I can put everything into a database and generate an electronic HTML
version suitable for printing.

Also, has anyone done any research on digital signatures? These forms need
to be signed by someone. I know that I can get each person that is going to
use the app to give me a scanned signature in PDF format or whatever, and
then I can append that person's signature to the doc, but if I can just have
the user click on a button saying it is them doing the work and such, I
would rather do that.

Thanks
Bruce

-Original Message-
From: Terry Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 9:31 AM
To: CF-Talk
Subject: Re: Possible to fill in areas in a word document?

You can put an easily found place holder in the document, save the doc as
RTF,(straight text) and then easily replace the place holder text with a
value from your database or other source.

T

If I have a word document as a template, can I use CFFILE to fill in blank
spots in it? I know that I can append to a document, but that is not what I
want to do, I want to fill in certain areas of the document.



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: RFC: CFMX Runtime Server

And how would they compile your CFML pages into Java ?
You need ColdFusion server for that. 

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 15:24
To: CF-Talk
Subject: Re: RFC: CFMX Runtime Server

Snake wrote:
 I believe you need CFMX Enterprise to actually do the sourceless 
 deployment though.

No, you need a J2EE server (like the free JBoss and Glassfish) or a Servlet
engine (like Tomcat).

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: TinyMCE editor problem

I guess this is normal, cozz it happens on mine too. 

-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 18:01
To: CF-Talk
Subject: TinyMCE editor problem

I am using TinyMCE theme Simple on some of my pages, but when I submit the
form (Using ColdFusion MX 7) the textarea the TinyMCE is attached to clears
out. 

The correct information in the textbox before I click the Submit
button is sent to the submit page. I can't have the textbox clear out
because people are thinking the text they enter is being erased and not
saved.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Possible to fill in areas in a word document?

2007-01-05 Thread Deanna Schneider

Sure. You can do all that stuff in RTF. Create a sample word doc and
save it as an rtf. Open it in a text editor and you'll see. It takes
some finagling to get formating the way you want. (RTF isn't exactly
an intuitive language). But, it's totally doable.

On 1/5/07, Bruce Sorge [EMAIL PROTECTED] wrote:
What about formatting? Like for instance, if they want to make certain text
bold, put in line breaks and paragraph formatting and the like (just basic
HTML), how will the document handle that? Will it retain the formatting or
just insert the HTML and ignore formatting? If this cannot be done then I
suppose I can put everything into a database and generate an electronic HTML
version suitable for printing.

Also, has anyone done any research on digital signatures? These forms need
to be signed by someone. I know that I can get each person that is going to
use the app to give me a scanned signature in PDF format or whatever, and
then I can append that person's signature to the doc, but if I can just have
the user click on a button saying it is them doing the work and such, I
would rather do that.

Thanks
Bruce

-Original Message-
From: Terry Schmitt [mailto:[EMAIL PROTECTED]
Sent: Friday, January 05, 2007 9:31 AM
To: CF-Talk
Subject: Re: Possible to fill in areas in a word document?

You can put an easily found place holder in the document, save the doc as
RTF,(straight text) and then easily replace the place holder text with a
value from your database or other source.

If I have a word document as a template, can I use CFFILE to fill in blank
spots in it? I know that I can append to a document, but that is not what I
want to do, I want to fill in certain areas of the document.

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: RFC: CFMX Runtime Server