Re: image effects

[Dave l]

I come here just to pick on Will ;)~

>I'm surprised.  This is such a valuable list, especially
>for those of us not so advanced, but I would assume that even
>advanced programmers would get good ideas, too.
>
>Rick
>
>
>> > What other major lists are there?
>> 
>> None that I'm aware of. I'm fairly certain that most CF programmers don't
>> subscribe to any CF list.
>> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Re: How good is cfreport?

[David Mineer]

I have been using crystal reports for years, but not with cfreport.  I
use an asp page to render the Crystal Report in a .pdf format.  I pass
the variables I need from coldfusion to the .asp page, which then
calls the Crystal report, and exports it to .pdf, then displays the
..pdf to the user.

More recently I have written code to use .net to do ths.  It should be
easy with .net, but it aint for me, although it does work.

But it is a major pain and not very portable between machines. I am
really hoping that I will be able to convert this to the CF report
builder, although I have not been able to convert our detailed, multi
column report to the cf report builder copying the functionality and
design.

Recreating your reports with cfreport builder may be quicker.  People
probably hate this option.


On Nov 26, 2007 3:28 PM, Billy Cox <[EMAIL PROTECTED]> wrote:
> Does anyone have experience with outputting Crystal Reports using
> ColdFusion? We have a number of existing Crystal Reports that I would like
> to leverage if possible. I am also making a purchase decision between Blue
> Dragon Server JX and CF Server 8.0, so I want to know whether CF Server
> (cfreport tag) is worth the extra bucks.
>
>
> Thanks,
>
> Billy Cox
> Old World Spices
> [EMAIL PROTECTED]
>
>
>
>
>
>
>
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: image effects

[Rick Faircloth]

I'm surprised.  This is such a valuable list, especially
for those of us not so advanced, but I would assume that even
advanced programmers would get good ideas, too.

Rick


> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 11:01 PM
> To: CF-Talk
> Subject: RE: image effects
> 
> > What other major lists are there?
> 
> None that I'm aware of. I'm fairly certain that most CF programmers don't
> subscribe to any CF list.
> 




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: image effects

[Dave Watts]

> What other major lists are there?

None that I'm aware of. I'm fairly certain that most CF programmers don't
subscribe to any CF list.

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!


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: image effects

[Rick Faircloth]

> I'd find it
> hard to believe you wouldn't just contact him.

Again, it's not a knock against Pete personally,
I've never even communicated with him.

I'm just not interested enough in the product to
engage in a dialogue about it... too much to do.

But am I (and Claude) the only one who finds it strange
that Pete would put up a component for sale and
put up demos that don't even utilize the component?

I may have to contact him to ask him what's up with that?

Rick


> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 12:12 PM
> To: CF-Talk
> Subject: Re: image effects
> 
> I just want to +1 this. I read this list - but not very often. I try
> to keep an eye out for support requests for my products, but I can't
> monitor this VERY busy list all the time.
> 
> Just as you might find it hard to believe he isn't here - I'd find it
> hard to believe you wouldn't just contact him.
> 
> http://foundeo.com/contact/
> 
> Pete is very much a stand up guy.
> 
> On Nov 26, 2007 10:00 AM, Todd <[EMAIL PROTECTED]> wrote:
> > There are other communities other than just this list.  The blogging
> > community, the adobe forums, etc.  Not everyone has every hour of the day to
> > read cf-talk due to the sheer volume of emails it pumps out.  I know I skim
> > topics myself.
> >
> > Why don't you just email Pete yourself and ask him what's up?  He's a pretty
> > stand-up guy.
> >
> > On Nov 26, 2007 10:48 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> >
> > > He must not be as interested in supporting the community as the
> > > some of us in the community are interested in supporting him
> > > if he's not on this list... probably the main list for all CF.
> > >
> > > I can't imagine being a developer, especially a developer of products
> > > for sale, and not being on this list.
> > >
> > > Rick
> >
> >
> >
> 
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: image effects

[Rick Faircloth]

What other major lists are there?
I must be leading a *very* sheltered life.
And I'm asking a serious question.  I may be
missing some other great resources for learning.
(And helping when I can... but just coming from CF 4.5,
I'm afraid I've little to offer.  I do subscribe to
CF Newbie just in case I might help someone just
getting started)

Rick


> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 11:28 AM
> To: CF-Talk
> Subject: RE: image effects
> 
> > He must not be as interested in supporting the community as
> > the some of us in the community are interested in supporting
> > him if he's not on this list... probably the main list for all
> > CF.
> >
> > I can't imagine being a developer, especially a developer of
> > products for sale, and not being on this list.
> 
> I am quite certain that the vast majority of CF programmers are either
> unaware of or uninterested in this list.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Re: CFLDAP and Sun One Directory Service

[Steve Metzger]

thanks,
we'll try it out... otherwise we will filter with CF 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Oracle RAW(50) - string conversion

[Matt Barfoot]

When I cfquery a Oracle database row with a RAW column in it, it is returned
as a ByteArray. 

If I view the column in a SQLNet client like Toad you see a string, probably
hex I'm guessing. 

I'm wondering how I correctly detect it and convert it to a string
afterwards?

I want to avoid doing it within the select statement with cast or convert,
because I'm generating dynamic "select * from mytable" statements and the
code doesn't know it will end up with a raw (ByteArray). 

Any ideas?
Thanks,
Matt



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: error caused by cfqueryparam inside cfif

[Brad Wood]

Could the error be caused by scoping issues for the variables you using
in the CFC?

What scope is the variable "value" in, and is your cfif really
evaluating the Boolean "true", or is it a real cfif with a variable in
there? If so, what scope is it in?  Arguments?  Variables?  Local Scope
(var)?

~Brad


Can anybody help me figure out this error?

I'm struggling with a really confusing error. It occurs when I put a 
cfqueryparam tag nested inside a cfif tag. 

More interesting data: This error only occurs on CF8. And only when the 
code is located in a .cfc file. It doesn't happen if the query is on a 
...cfm page, or using CF7.


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: IE7 blocking CF Administrator 'browse' java applet

[Al Musella, DPM]

First make sure you have java installed.. go to java.com and install 
the latest version..
If that doesn't work, go into IE's tool menu, then internet options, 
then advanced and allow the java stuff!


At 05:03 PM 11/26/2007, you wrote:

>How can I get IE7 to stop protecting me from my CF administrator's evil
>attempts to allow me to browse the file system to set up mappings, ect.
>with Java applets.
>
>Thank You
>Ian




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Re: error caused by cfqueryparam inside cfif

[Barney Boisvert]

What happens if you change the variable name used to populate the
value attribute of CFQUERYPARAM?

If that fixes it, my money would be on a variable leak in the CFIF
implementation.

cheers,
barneyb

On Nov 26, 2007 12:58 PM, Nicholas Vacek <[EMAIL PROTECTED]> wrote:
> Can anybody help me figure out this error?
>
> I'm struggling with a really confusing error. It occurs when I put a
> cfqueryparam tag nested inside a cfif tag. For example, here's a query:
>
> 
>SELECT *
>FROM TableName
>WHERE 0=0
>
>  AND fieldName =  cfsqltype="cf_sql_integer" />
>
> 
>
> The relevant lines of code that causes the error:
>
> 
> AND fieldName = 
> 
>
> However, if I leave off the cfif wrapper, the following works:
> AND fieldName = 
>
> Alternatively, if I don't use a cfqueryparam, then this code works
> without errors too:
> 
> AND fieldName = #value#
> 
>
> Here's the error message:
> The system has attempted to use an undefined value, which usually
> indicates a programming error, either in your code or some system code
>
> When I wrap the query it in a try-catch and dump the catch scope, I see
> an empty error - no message, no stackTrace, nothing.
>
> More interesting data: This error only occurs on CF8. And only when the
> code is located in a .cfc file. It doesn't happen if the query is on a
> ..cfm page, or using CF7.
>
> What's going on?!?
>
>
> --
> Nicholas Vacek
> Vivid Image - Programmer
> 320-587-8974 ext. 111
> [EMAIL PROTECTED]
> http://www.vimm.com
>
>
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: error caused by cfqueryparam inside cfif

[Claude Schneegans]

 >>What's going on?!?
 >>either in your code or some system code

IMHO it is more like in the "system code" ;-/

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


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: IE7 blocking CF Administrator 'browse' java applet

[Dave Watts]

> How can I get IE7 to stop protecting me from my CF 
> administrator's evil attempts to allow me to browse the file 
> system to set up mappings, ect. 
> with Java applets.

Add your CF Administrator URL to IE's "Trusted Sites" zone? I think that'll
do it.

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!


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: error caused by cfqueryparam inside cfif

[Alan Rother]

This is all I can think of... assuming you literally are using the
boolean true and not some real code evaluation...



AND fieldName = 


The thought behind this is that CF is mis interpreting true to be a
variable name and not a boolean...


=]

-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: Updating to Eclipse 3.3...

[Dave Watts]

> I currently use 3.2.2 and I'd like to upgrade to 3.3 so that 
> I can start using the CF 8 debugger. But when I go to Help > 
> Software Updates > Find & Instal > Current installs (or new 
> features), I only see updates to the 3.2 branch.

I think it'll work fine with Eclipse 3.2. I don't think you can upgrade from
3.2 to 3.3; I think you have to simpy install 3.3. Unfortunately, I don't
know how to preserve or import settings.

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!


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

How good is cfreport?

[Billy Cox]

Does anyone have experience with outputting Crystal Reports using
ColdFusion? We have a number of existing Crystal Reports that I would like
to leverage if possible. I am also making a purchase decision between Blue
Dragon Server JX and CF Server 8.0, so I want to know whether CF Server
(cfreport tag) is worth the extra bucks.
 
 
Thanks,
 
Billy Cox
Old World Spices
[EMAIL PROTECTED]
 
 
 




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: cfswitch in cf8

[Brad Wood]

Interesting-- Thanks for sharing.

Sometimes I wish Adobe ColdFusion was open-source so one could easily
compare your tests with what was really going on "under the hood".

~Brad

-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 26, 2007 2:01 PM
To: CF-Talk
Subject: RE: cfswitch in cf8

A bit off of this particular topic but this got me working with
JavaCast( )
trying to influence the way CF handles the comparison operater. I wrote
a
blog post about it. 

http://www.coldfusionmuse.com/index.cfm/2007/11/26/javacast.iterations

The summary is that fiddling with the way CF handles comparisons doesn't
offer much hope for appreciable gains. 

-Mark
 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: Flex 2 books for CF/AS3

[Dave Watts]

> Is this the one you're talking about?
> 
> http://www.adobepress.com/bookstore/product.asp?isbn=032142316X

Yes, that's it.

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!


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Re: Updating to Eclipse 3.3...

[Crow T. Robot]

No need to uninstall at alljust install 3.3 to a new folder and copy
your setting over.  That way you have the best of both worlds - both
installs are there for you if you need one or the other.

On Nov 26, 2007 3:09 PM, Andy Matthews <[EMAIL PROTECTED]> wrote:

> I currently use 3.2.2 and I'd like to upgrade to 3.3 so that I can start
> using the CF 8 debugger. But when I go to Help > Software Updates > Find &
> Instal > Current installs (or new features), I only see updates to the 3.2
> branch.
>
> Is it possible to upgrade to 3.3 without uninstalling my current build?
>
> If it's not, how can I back up my files so that I don't lose my
> preferences
> and settings? I'd rather not even bother upgrading if it might lose my
> settings.
>
> Thanks in advance.
>
> 
>
> Andy Matthews
> Senior ColdFusion Developer
>
> Office:  877.707.5467 x747
> Direct:  615.627.9747
> Fax:  615.467.6249
> [EMAIL PROTECTED]
> www.dealerskins.com 
>
>
>
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: error caused by cfqueryparam inside cfif

[Ben Nadel]

Get rid of the "*" in the SELECT *. Using CFQueryParam causes the
structure to be cached. Then, if the underlying DB changes, the
structure no longer applies, but since CF sees it as the same thing,
weirdness ensues. In general get rid of all SELECT *'s in your code.
They are evil and cause headaches like this. 


..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Nicholas Vacek [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 26, 2007 3:58 PM
To: CF-Talk
Subject: error caused by cfqueryparam inside cfif

Can anybody help me figure out this error?

I'm struggling with a really confusing error. It occurs when I put a
cfqueryparam tag nested inside a cfif tag. For example, here's a query:


   SELECT *
   FROM TableName
   WHERE 0=0
   
 AND fieldName = 
   


The relevant lines of code that causes the error:


AND fieldName =  

However, if I leave off the cfif wrapper, the following works:
AND fieldName = 

Alternatively, if I don't use a cfqueryparam, then this code works
without errors too:

AND fieldName = #value#


Here's the error message:
The system has attempted to use an undefined value, which usually
indicates a programming error, either in your code or some system code

When I wrap the query it in a try-catch and dump the catch scope, I see
an empty error - no message, no stackTrace, nothing.

More interesting data: This error only occurs on CF8. And only when the
code is located in a .cfc file. It doesn't happen if the query is on a
...cfm page, or using CF7.

What's going on?!?


--
Nicholas Vacek
Vivid Image - Programmer
320-587-8974 ext. 111
[EMAIL PROTECTED]
http://www.vimm.com




~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

IE7 blocking CF Administrator 'browse' java applet

[Ian Skinner]

How can I get IE7 to stop protecting me from my CF administrator's evil 
attempts to allow me to browse the file system to set up mappings, ect. 
with Java applets.

Thank You
Ian


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Re: Flex 2 books for CF/AS3

[Mike Chabot]

"Adobe Flex 2: Training from the Source" is a good book to read. One
of the authors of that book, James Talbot, also did the Adobe Flex 2
Rich Internet Applications DVD from Total Training. The DVD is a great
way to get introduced to Flex.

-Mike Chabot

On Nov 26, 2007 1:54 PM, Andy Matthews <[EMAIL PROTECTED]> wrote:
> Dave...
>
> Is this the one you're talking about?
>
> http://www.adobepress.com/bookstore/product.asp?isbn=032142316X
>
>
> andy
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 10:24 AM
> To: CF-Talk
> Subject: RE: Flex 2 books for CF/AS3
>
> > I'm reading through Programming Flex by Joey Latoun and I have to say,
> > I don't like it much at all. I'm a complete beginner at Flex and by
> > chapter 4 they were already deep into the technical aspects of Flex. I
> > just don't think that it's written well at all. It makes me want to
> > return it and get my money back.
>
> In that case, you might check out the Adobe Press book on Flex 2, which
> takes things a bit more slowly.
>
> 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!
>
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

error caused by cfqueryparam inside cfif

[Nicholas Vacek]

Can anybody help me figure out this error?

I'm struggling with a really confusing error. It occurs when I put a 
cfqueryparam tag nested inside a cfif tag. For example, here's a query:


   SELECT *
   FROM TableName
   WHERE 0=0
   
 AND fieldName = 
   


The relevant lines of code that causes the error:


AND fieldName = 


However, if I leave off the cfif wrapper, the following works:
AND fieldName = 

Alternatively, if I don't use a cfqueryparam, then this code works 
without errors too:

AND fieldName = #value#


Here's the error message:
The system has attempted to use an undefined value, which usually 
indicates a programming error, either in your code or some system code

When I wrap the query it in a try-catch and dump the catch scope, I see 
an empty error - no message, no stackTrace, nothing.

More interesting data: This error only occurs on CF8. And only when the 
code is located in a .cfc file. It doesn't happen if the query is on a 
..cfm page, or using CF7.

What's going on?!?


-- 
Nicholas Vacek
Vivid Image - Programmer
320-587-8974 ext. 111
[EMAIL PROTECTED]
http://www.vimm.com


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Re: image effects

[Dave l]

He used to be on the list and and is a well respected guy which is why i forked 
out the cash for it.

My comments weren't meant as a knock either, I just found it weird that his 
examples were using the component. 

When I get the time to mess with them and if I still have issue's I will 
contact him but I really don't feel like I "should" have to contact him for 
assistance with something I bought that shouldn't be to difficult to figure out 
or be better documented in the purchase. It's not like it was a fortune to pay 
but still it's a pretty high price for what it does. 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Updating to Eclipse 3.3...

[Andy Matthews]

I currently use 3.2.2 and I'd like to upgrade to 3.3 so that I can start
using the CF 8 debugger. But when I go to Help > Software Updates > Find &
Instal > Current installs (or new features), I only see updates to the 3.2
branch.
 
Is it possible to upgrade to 3.3 without uninstalling my current build?
 
If it's not, how can I back up my files so that I don't lose my preferences
and settings? I'd rather not even bother upgrading if it might lose my
settings.
 
Thanks in advance.
 

 
Andy Matthews
Senior ColdFusion Developer

Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com  
 


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: cfswitch in cf8

[Mark A Kruger]

A bit off of this particular topic but this got me working with JavaCast( )
trying to influence the way CF handles the comparison operater. I wrote a
blog post about it. 

http://www.coldfusionmuse.com/index.cfm/2007/11/26/javacast.iterations

The summary is that fiddling with the way CF handles comparisons doesn't
offer much hope for appreciable gains. 

-Mark
 

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 26, 2007 10:14 AM
To: CF-Talk
Subject: RE: cfswitch in cf8

> In any case, I don't really care about the "original topic". I was 
> responding to your response to Sean, which I thought was off-base.

You had very good things to say about general performance tuning.
Unfortunately my reply to Sean was specifically in the context of the
original thread so general performance tuning tips were a little immaterial.

> And, of course, the specific numbers you quoted to Sean were from your 
> iterative test. I think it's perfectly OK to critique the process by
which
> you gained those numbers, if you're going to use them as justification
for
> doing something one way or another.

That's fair enough, and I do appreciate the critique.  I do however feel
that I've shown an iterative test to be a very good assessment for the
specific bit of code that prompted my original post.  

If it helps, I did run the test originally for 10,000 iterations which,
given my application, is a very realistic number to consider.  While the
comparison is less dramatic the cfswitch is still a full second slower which
is significant enough to me not to use it in this specific situation.  (47
ms / 1141 ms) My CIO has requested that the average page load time in our
app be 3 seconds or less.  Now I am being told to burn 1/3 of that time
purely because a switch is more readable and it would be "dumb" to use a
conditional structure known to be faster in CF7.   Personally I think
that advice stinks.   :)


> I would recommend that you investigate doing that conditional
processing > > in a stored procedure if you can.

I was waiting for that.  :)  What I am working on happens to be the
interface for a generic reporting tool where we define dynamic criteria and
write custom SQL in a proc for each report.  It's very handy because only
the SQL required to produce the results is all that's necessary to build a
new report.  The CF code in question displays results in a dynamic way
formatting each value and aligning it with appropriate HTML etc as necessary
based on the meta data available from the result set and the column types.
I am always open to suggestions, but I would hard hardly call it the job of
my SQL server to apply formatting and HTML to my data for obvious reasons--
the largest of which would be separation of data layer from display layer.
Of course I could write an intermediate and generic proc which would format
the result set before handing it to ColdFusion, but that would take more
obfuscated dynamic SQL than I care to deal with.  
I would only resort to another language if what I wanted could not be
accomplished quickly and easily in ColdFusion 7, and in this case it
can-- with the cfif tag.  :)

~Brad



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: Flex 2 books for CF/AS3

[Andy Matthews]

Dave...

Is this the one you're talking about?

http://www.adobepress.com/bookstore/product.asp?isbn=032142316X


andy 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 26, 2007 10:24 AM
To: CF-Talk
Subject: RE: Flex 2 books for CF/AS3

> I'm reading through Programming Flex by Joey Latoun and I have to say, 
> I don't like it much at all. I'm a complete beginner at Flex and by 
> chapter 4 they were already deep into the technical aspects of Flex. I 
> just don't think that it's written well at all. It makes me want to 
> return it and get my money back.

In that case, you might check out the Adobe Press book on Flex 2, which
takes things a bit more slowly.

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!




~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Re: Showing dynamic data in two side by side groups

[Ali Majdzadeh]

>Not sure what you mean by side by side... This?
>
>  SELECT ID, firstName, 
> lastName, email FROM Membership 
>
> 
>   
>   
> First Name
>  #firstName#
>   
>   
>   
> Last Name
> #lastName#
>   
>   
>   
> Email
> #email#
>   
>   
>   
> 
>
>OR do you mean...
>
>
>
>FirstName:
>index="f">#members['firstname'][f]#
>
>
>
>LastName:
>index="l">#members['lastname'][l]#
>
>
>
>Email:
>index="e">#members['email'][e]#
>
>
>
>Or do you mean something else entirely?
>
>.:.:.:.:.:.:.:.:.:.:.:.:.
>Bobby Hartsfield
>http://acoderslife.com


As a matter of fact non of them. I found a way to do that. 
I write the code down:



SELECT *
FROM Membership






   


  #Recordset1.firstName#
  #Recordset1.lastName#
  #Recordset1.email#



  if (NOT Recordset1.CurrentRow eq Recordset1.RecordCount AND 
Recordset1.CurrentRow mod 2 eq 0) {
writeoutput("");
  }
  
   
 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

Coldfusion's founder - Brightcove.com

[coldfusion . developer]

All,

I love the service that Brightcove.com has put together.  However, we're not 
sure
it's within our budget, does anyone know of a similar hosting/solution service 
with 
the viral distribution component?

Thanks

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: cfswitch in cf8

[Dave Watts]

> If it helps, I did run the test originally for 10,000 
> iterations which, given my application, is a very realistic 
> number to consider.  While the comparison is less dramatic 
> the cfswitch is still a full second slower which is 
> significant enough to me not to use it in this specific 
> situation.  (47 ms / 1141 ms) My CIO has requested that the 
> average page load time in our app be 3 seconds or less.  Now 
> I am being told to burn 1/3 of that time purely because a 
> switch is more readable and it would be "dumb" to use a
> conditional structure known to be faster in CF7. Personally I 
> think that advice stinks.   :)

Sure, I can see that. Although, you're not really burning 1/3rd of that time
unless that's the only page everyone's running, you're just dragging down
the average. So, your boss is taking the long view that the specific
performance degradation isn't going to make enough of a difference to
outweigh the improvement in readability that CFSWITCH is providing in this
case. When you upgrade to CF8, this long view is arguably justified, isn't
it?

> I was waiting for that.  :)

Well, given what little I knew about your application, it was the obvious
answer. I agree that it may not be the appropriate choice for your
application, though.

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!


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: Flex 2 books for CF/AS3

[Andy Matthews]

Thanks Dave...

I'll check those out. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 26, 2007 10:24 AM
To: CF-Talk
Subject: RE: Flex 2 books for CF/AS3

> I'm reading through Programming Flex by Joey Latoun and I have to say, 
> I don't like it much at all. I'm a complete beginner at Flex and by 
> chapter 4 they were already deep into the technical aspects of Flex. I 
> just don't think that it's written well at all. It makes me want to 
> return it and get my money back.

In that case, you might check out the Adobe Press book on Flex 2, which
takes things a bit more slowly.

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 to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: image effects

[Raymond Camden]

I just want to +1 this. I read this list - but not very often. I try
to keep an eye out for support requests for my products, but I can't
monitor this VERY busy list all the time.

Just as you might find it hard to believe he isn't here - I'd find it
hard to believe you wouldn't just contact him.

http://foundeo.com/contact/

Pete is very much a stand up guy.

On Nov 26, 2007 10:00 AM, Todd <[EMAIL PROTECTED]> wrote:
> There are other communities other than just this list.  The blogging
> community, the adobe forums, etc.  Not everyone has every hour of the day to
> read cf-talk due to the sheer volume of emails it pumps out.  I know I skim
> topics myself.
>
> Why don't you just email Pete yourself and ask him what's up?  He's a pretty
> stand-up guy.
>
> On Nov 26, 2007 10:48 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> > He must not be as interested in supporting the community as the
> > some of us in the community are interested in supporting him
> > if he's not on this list... probably the main list for all CF.
> >
> > I can't imagine being a developer, especially a developer of products
> > for sale, and not being on this list.
> >
> > Rick
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

ColdFusion 7 MX - Oracle Stored Proc Calls

[Mike Garner]

We've been experiencing this issue for some time and I thought I'd throw it out 
there to see if anyone else has had this problem.

When a user logs into our site, we call an Oracle stored proc, which validates 
the login, and if success inserts an audit record.  Occasionally we are seeing 
that ColdFusion is issuing the stored proc call twice for a single transaction 
and have verified it is not due to multiple clicks on the login button.  We 
have noticed similar behavior in submitting a registation type form where a 
user is created.  The issue goes away if we remove the stored proc call and use 
cfquery's instead to do the insert.

Just curious if there are any known threading issues with CF and Oracle stored 
proc calls in Oracle that anyone has come across.  We are using the 3.5 jdbc 
driver.  We allow up to 5 connections, and CF holds the connection.  If there's 
any additional information I can provide that would be helpful, let me know.

thanks,
Mike 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: Flex 2 books for CF/AS3

[Dave Watts]

> I'm reading through Programming Flex by Joey Latoun and I 
> have to say, I don't like it much at all. I'm a complete 
> beginner at Flex and by chapter 4 they were already deep into 
> the technical aspects of Flex. I just don't think that it's 
> written well at all. It makes me want to return it and get my 
> money back.

In that case, you might check out the Adobe Press book on Flex 2, which
takes things a bit more slowly.

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 to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: cfswitch in cf8

[Brian Kotek]

On Nov 26, 2007 11:14 AM, Brad Wood <[EMAIL PROTECTED]> wrote:

>
> If it helps, I did run the test originally for 10,000 iterations which,
> given my application, is a very realistic number to consider.  While the
> comparison is less dramatic the cfswitch is still a full second slower
> which is significant enough to me not to use it in this specific
> situation.  (47 ms / 1141 ms)
>


>
> My CIO has requested that the average page load time in our app be 3
> seconds or less.  Now I am being told to burn 1/3 of that time purely
> because a switch is more readable and it would be "dumb" to use a
> conditional structure known to be faster in CF7.   Personally I think
> that advice stinks.   :)
>
>
The issue is not whether cfif is faster than cfswitch, since it easily could
be. And clearly you should use whatever meets your needs, so wanting to use
the faster of the two is not a crazy thing to want. The point is that until
you test the code under the actual target load, this simple iterative test
is virtually meaningless.


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293818
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 8 & JDBC Driver ?

[Dave Watts]

> We have recently built a new Linux Intranet server with 
> Coldfusion 8 on it, but i am having problems with our 
> Informix JDBC Driver on it.
> 
> I have unpacked the driver to the server to the following 
> path - /opt/Informix_JDBC_Driver_310/lib/ifxjdbc.jar
> 
> I have then included that path in the administrator as the - 
> ColdFusion Class Path under the Java and JVM section.
> 
> Then if i try to create a data source using the Informix 
> driver - details as follows
> 
> ...
> 
> Connection verification failed for data source: Arista
> java.sql.SQLException: Can't load driver 
> java.lang.reflect.InvocationTargetException
> The root cause was that: java.sql.SQLException: Can't load 
> driver java.lang.reflect.InvocationTargetException
> 
> ... 
>
> the driver (and same details) work fine with Coldfusion 7, 
> but not with 8 ! Have installed the hotfix for Coldfusion 8 
> too but the problem remains !! 

Maybe it's a permissions problem on that directory? I would just put it in
the appropriate lib directory for CF, I think.

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 to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: image effects

[Dave Watts]

> He must not be as interested in supporting the community as 
> the some of us in the community are interested in supporting 
> him if he's not on this list... probably the main list for all 
> CF.
> 
> I can't imagine being a developer, especially a developer of 
> products for sale, and not being on this list.

I am quite certain that the vast majority of CF programmers are either
unaware of or uninterested in this list.

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!


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: cfswitch in cf8

[Brad Wood]

> In any case, I don't really care about the "original topic". I was
> responding to your response to Sean, which I thought was off-base. 

You had very good things to say about general performance tuning.
Unfortunately my reply to Sean was specifically in the context of the
original thread so general performance tuning tips were a little
immaterial.

> And, of course, the specific numbers you quoted to Sean were from your
> iterative test. I think it's perfectly OK to critique the process by
which
> you gained those numbers, if you're going to use them as justification
for
> doing something one way or another.

That's fair enough, and I do appreciate the critique.  I do however feel
that I've shown an iterative test to be a very good assessment for the
specific bit of code that prompted my original post.  

If it helps, I did run the test originally for 10,000 iterations which,
given my application, is a very realistic number to consider.  While the
comparison is less dramatic the cfswitch is still a full second slower
which is significant enough to me not to use it in this specific
situation.  (47 ms / 1141 ms)
My CIO has requested that the average page load time in our app be 3
seconds or less.  Now I am being told to burn 1/3 of that time purely
because a switch is more readable and it would be "dumb" to use a
conditional structure known to be faster in CF7.   Personally I think
that advice stinks.   :)


> I would recommend that you investigate doing that conditional
processing > > in a stored procedure if you can.

I was waiting for that.  :)  What I am working on happens to be the
interface for a generic reporting tool where we define dynamic criteria
and write custom SQL in a proc for each report.  It's very handy because
only the SQL required to produce the results is all that's necessary to
build a new report.  The CF code in question displays results in a
dynamic way formatting each value and aligning it with appropriate HTML
etc as necessary based on the meta data available from the result set
and the column types.  I am always open to suggestions, but I would hard
hardly call it the job of my SQL server to apply formatting and HTML to
my data for obvious reasons-- the largest of which would be separation
of data layer from display layer.  Of course I could write an
intermediate and generic proc which would format the result set before
handing it to ColdFusion, but that would take more obfuscated dynamic
SQL than I care to deal with.  
I would only resort to another language if what I wanted could not be
accomplished quickly and easily in ColdFusion 7, and in this case it
can-- with the cfif tag.  :)

~Brad

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: image effects

[Rick Faircloth]

Hi, Todd...

My remarks weren't meant to be a knock on Pete as much to express
my surpise that someone with something to sell to the CF community
as a whole, wouldn't be on every major list.

I know this list is not the be all and end all of the CF community,
but, if I had something to sell, I'd at least be a subscriber and
minimal participant.

But, I won't judge his participation.  He may be way too busy with
other parts of the community and just can't afford the time... (or space
in his inbox!)

Anyway, he does need some marketing guidance if he's serious about
selling that component.

I'm not really interested enough in the product to contact Pete.
He's probably aware of the issues anyway.

Rick


> -Original Message-
> From: Todd [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 11:00 AM
> To: CF-Talk
> Subject: Re: image effects
> 
> There are other communities other than just this list.  The blogging
> community, the adobe forums, etc.  Not everyone has every hour of the day to
> read cf-talk due to the sheer volume of emails it pumps out.  I know I skim
> topics myself.
> 
> Why don't you just email Pete yourself and ask him what's up?  He's a pretty
> stand-up guy.
> 
> On Nov 26, 2007 10:48 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> 
> > He must not be as interested in supporting the community as the
> > some of us in the community are interested in supporting him
> > if he's not on this list... probably the main list for all CF.
> >
> > I can't imagine being a developer, especially a developer of products
> > for sale, and not being on this list.
> >
> > Rick
> 
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: security and remote datasources

[Dave Watts]

> Aren't there the same security risks when using SQL Server 
> Management Studio Express to login to a remote SQL Server?

I would think so, yes.

> Doesn't just about everyone use this when logging into a 
> hosted SQL Server?

I have no idea what goes on in the crazy world of shared hosting, and I
don't want to know. I do know that, generally, security is not the highest
priority in a shared hosting environment. I think that the presumption is,
if you're using shared hosting, security is not all that important to you.
If it is, you should probably reconsider what you're doing.

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!


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: Showing dynamic data in two side by side groups

[Bobby Hartsfield]

Not sure what you mean by side by side... This?

  SELECT ID, firstName, 
 lastName, email FROM Membership 

 
   
   
 First Name
  #firstName#
   
   
   
 Last Name
 #lastName#
   
   
   
 Email
 #email#
   
   
   
 

OR do you mean...



FirstName:
#members['firstname'][f]#



LastName:
#members['lastname'][l]#



Email:
#members['email'][e]#



Or do you mean something else entirely?

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com




~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: image effects

[Todd]

There are other communities other than just this list.  The blogging
community, the adobe forums, etc.  Not everyone has every hour of the day to
read cf-talk due to the sheer volume of emails it pumps out.  I know I skim
topics myself.

Why don't you just email Pete yourself and ask him what's up?  He's a pretty
stand-up guy.

On Nov 26, 2007 10:48 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote:

> He must not be as interested in supporting the community as the
> some of us in the community are interested in supporting him
> if he's not on this list... probably the main list for all CF.
>
> I can't imagine being a developer, especially a developer of products
> for sale, and not being on this list.
>
> Rick


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: image effects

[Claude Schneegans]

 >>I can't imagine being a developer, especially a developer of products
for sale, and not being on this list.

Good point ;-)

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


~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: image effects

[Rick Faircloth]

He must not be as interested in supporting the community as the
some of us in the community are interested in supporting him
if he's not on this list... probably the main list for all CF.

I can't imagine being a developer, especially a developer of products
for sale, and not being on this list.

Rick


> -Original Message-
> From: Andy Matthews [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 10:08 AM
> To: CF-Talk
> Subject: RE: image effects
> 
> I'm not sure that Pete is on this list.
> 
> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 8:53 AM
> To: CF-Talk
> Subject: RE: image effects
> 
> I understand... I like to pay a reasonable price for reasonable service.
> And I like to use as few technologies as possible just to keep thing simple.
> But there's something very wrong when even the demos on the page aren't
> demos, but facsimiles.
> 
> I hope the developer is listening...
> 
> Rick
> 
> > -Original Message-
> > From: Dave l [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, November 25, 2007 10:44 PM
> > To: CF-Talk
> > Subject: Re: image effects
> >
> > sure:)
> >
> > I was hoping I would like them and they would be useful and it would
> > support another cfm guy but.
> >
> > >Thanks for the feedback, Dave, and the work.
> > >
> > >I know there are some jQuery plug-ins that do things now like add
> > >shadows dynamically, but I thought I'd try it in CF first.
> > >
> > >jQuery is *free*, however... :o)  Always a nice bonus!
> > >
> > >Rick
> >
> >
> 
> 
> 
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

OT:Flex image manipulator

[Andy Matthews]

Hey guys...
 
Have any of you seen some sort of image manipulator for Flex? I'm just
looking for really basic stuff like scaling and rotating (then saving). I
have code for Javascript that does all of this, but a client wants to use
Flash. So I want to show him a Flex version and a JS version and let him
pick.

 
 
andy matthews


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: image effects

[Andy Matthews]

I'm not sure that Pete is on this list.

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 26, 2007 8:53 AM
To: CF-Talk
Subject: RE: image effects

I understand... I like to pay a reasonable price for reasonable service.
And I like to use as few technologies as possible just to keep thing simple.
But there's something very wrong when even the demos on the page aren't
demos, but facsimiles.

I hope the developer is listening... 

Rick

> -Original Message-
> From: Dave l [mailto:[EMAIL PROTECTED]
> Sent: Sunday, November 25, 2007 10:44 PM
> To: CF-Talk
> Subject: Re: image effects
> 
> sure:)
> 
> I was hoping I would like them and they would be useful and it would 
> support another cfm guy but.
> 
> >Thanks for the feedback, Dave, and the work.
> >
> >I know there are some jQuery plug-ins that do things now like add 
> >shadows dynamically, but I thought I'd try it in CF first.
> >
> >jQuery is *free*, however... :o)  Always a nice bonus!
> >
> >Rick
> 
> 



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: image effects

[Rick Faircloth]

I understand... I like to pay a reasonable price for reasonable service.
And I like to use as few technologies as possible just to keep thing simple.
But there's something very wrong when even the demos on the page aren't demos,
but facsimiles.

I hope the developer is listening... 

Rick

> -Original Message-
> From: Dave l [mailto:[EMAIL PROTECTED]
> Sent: Sunday, November 25, 2007 10:44 PM
> To: CF-Talk
> Subject: Re: image effects
> 
> sure:)
> 
> I was hoping I would like them and they would be useful and it would support 
> another cfm guy
> but.
> 
> >Thanks for the feedback, Dave, and the work.
> >
> >I know there are some jQuery plug-ins that do things now
> >like add shadows dynamically, but I thought I'd try it in CF first.
> >
> >jQuery is *free*, however... :o)  Always a nice bonus!
> >
> >Rick
> 
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: Flex 2 books for CF/AS3

[Andy Matthews]

I'm reading through Programming Flex by Joey Latoun and I have to say, I
don't like it much at all. I'm a complete beginner at Flex and by chapter 4
they were already deep into the technical aspects of Flex. I just don't
think that it's written well at all. It makes me want to return it and get
my money back. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 23, 2007 10:31 AM
To: CF-Talk
Subject: RE: Flex 2 books for CF/AS3

> Can anyone recommend some titles on Flex 2 with focus on CF and AS3.  
> Looked at a couple of titles but Amazon doesn't seem to offer "look 
> inside" for those titles.  Hate to purchase something with a brief 
> overview of CF integration.

I doubt you'll find any Flex 2 book that has any significant CF stuff,
because there isn't all that much to say about CF in a Flex book. Any Flex 2
book will cover the basics of AS3. There are a couple of books about AS3
available now from O'Reilly.

Dave Watts, CTO, Fig Leaf Software 




~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: quik components question

[Scott Stewart]

That makes sense... this was more of a late night brain fart.

So I'll post to an action page and call what I need to from there...

Thanks Dave

-- 
Scott Stewart
ColdFusion Developer
 
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(703) 220-2835
 
http://www.sstwebworks.com
http://www.linkedin.com/in/sstwebworks
 
Boycott Sys-Con
http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon
 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 25, 2007 9:25 PM
To: CF-Talk
Subject: RE: quik components question

> Can you pass form variables directly to a ColdFusion function 
> without calling the entire cfc path in the form action
> 
> (blah/blah/yadda.cfc)

What exactly do you mean?

If you want to post data from the browser to a CFC function directly,
instead of posting to a CFM that invokes a function, yes, you have to put
the CFC path in the form action. But that's not what most people do.
Instead, they post to a CFM, and that CFM does whatever you want it to do;
this could of course include calling functions, invoking CFCs, etc.

 ...

.




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!




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Re: Showing dynamic data in two side by side groups

[C. Hatton Humphrey]

You need to make use of the STARTROW and MAXROWS attributes of the
CFOUTPUT tag to do this.

Hatton

On Nov 26, 2007 4:15 AM, Ali Majdzadeh <[EMAIL PROTECTED]> wrote:
> Hi:
> I'm trying to make a show dynamic data (dynamic table) using dw/cf8. I works 
> fine but it shows data down the page while I need them in two side by side 
> groups (columns). I write down the code :
>
> 
> SELECT ID, firstName, lastName, email
> FROM Membership
> 
>
> 
>   
> First Name
> Last Name
> Email
>   
>   
> 
>   #members.firstName#
>   #members.lastName#
>   #members.email#
> 
>   
> 
>
>
> I found a DW extension after some googling made by Tom Muck named 
> Horizontal/Vertical Looper which does the job but it is for php/sql not CF. 
> Can you please help me find out a way to show dynamic data in two groups 
> instead of one that goes down the page using CF8? Please?
> Thanks
> Benign
>
> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

Coldfusion 8 & JDBC Driver ?

[Richard Giles]

We have recently built a new Linux Intranet server with Coldfusion 8 on it, but 
i am having problems with our Informix JDBC Driver on it.

I have unpacked the driver to the server to the following path - 
/opt/Informix_JDBC_Driver_310/lib/ifxjdbc.jar

I have then included that path in the administrator as the - ColdFusion Class 
Path under the Java and JVM section.

Then if i try to create a data source using the Informix driver - details as 
follows

---
name = Arista

JDBC URL = jdbc:informix-sqli://[my server]:1526/arista:informixserver=online

Driver Class = com.informix.jdbc.IfxDriver

Driver Name = informix_v310

+ username & password info !

---

i just get an error - 

Connection verification failed for data source: Arista
java.sql.SQLException: Can't load driver 
java.lang.reflect.InvocationTargetException
The root cause was that: java.sql.SQLException: Can't load driver 
java.lang.reflect.InvocationTargetException

Anyone know why this is happing or how to fix it, as it is doing my head in !

the driver (and same details) work fine with Coldfusion 7, but not with 8 ! 
Have installed the hotfix for Coldfusion 8 too but the problem remains !! 




~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: security and remote datasources

[Richard Steele]

>> What are the security risks for using a datasource that 
>> connects to that remote database? Isn't the username and 
>> password passed to that database unencrypted? Wouldn't this 
>> be a huge security risk?
>
>Generally, yes, this could be a very large security risk. Most database
>connections are unencrypted by default, so it would be fairly trivial to
>pluck logins from the traffic if you had access to either endpoint, or to a
>network used by either endpoint.
>
>The way you deal with this is the way you deal with any similar problem -
>use adequate encryption. This may range from SSL (which is supported by SQL
>Server, but I haven't set that up with CF) to a VPN tunnel.
>
>> Are there any documented cases in which the username and 
>> password have been sniffed allowing the hacker to login in to 
>> the remote database?
>
>I can't point to any offhand, but I would certainly assume that it's been
>done, since it's simple to do. I would also argue that the knowledge that
>this is easy to do would require you to use encryption simply to meet due
>diligence requirements.
>
>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!

Hi Dave, Thanks for your reply.

Aren't there the same security risks when using SQL Server Management Studio 
Express to login to a remote SQL Server? Doesn't just about everyone use this 
when logging into a hosted SQL Server? 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Combine Documents and Databse Records in a Verity Index

[Peter Shaw]

Thanks for that Jaime, I can see how your idea would work.

In this case, as a single search result (user profile) is made up of both 
database records and files it would be great if they could be 'linked' so that 
Verity could calculate the relevance for a single user based on the contents of 
both their database *and* their optional attached document.

With your method, passing a userID in a custom field when we index each 
resource for a user would then allow us to'add up' results for the same user 
from different sources in our results set - which might be some kind of 
solution. Seems clunky though.

The amount of text in the attached documents isn't huge and is stored in 
attached file form as a matter of convenience. Could the text be stripped out 
from the documents and added to a database field. Allowing us to index all 
information for searching with a single 'key'.

Peter



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: Combine Documents and Databse Records in a Verity Index

[Jaime Metcher]

Peter,

It's certainly possible.  The key is to use multiple CFINDEX tags to build
the collection.  When you execute a search, you then need to do some sort of
parsing on the result query to determine how to build the link to the
appropriate resource.

With the use of the custom fields available in Verity, we've successfully
integrated half-a-dozen different database tables and 2-3 file system trees
into the one collection.  For example, we might have a website with a
calendar system, a library of FAQs and a document library.  Depending on the
contents of the search query, a line in the list of search hits might link
to a calendar event, a particular FAQ, a document or just a plain old web
page.

Jaime Metcher

> -Original Message-
> From: Peter Shaw [mailto:[EMAIL PROTECTED]
> Sent: Monday, 26 November 2007 9:18 PM
> To: CF-Talk
> Subject: Combine Documents and Databse Records in a Verity Index
>
>
> We're exploring Verity to use on a new project. Our user profiles
> are made up of several database fields and an optional uploaded
> document (word / pdf). Is it possible to combine both file and
> database data in a Verity index so that we can search both with a
> single CF_Search? Ideally we only want to get one ranked result
> set back to work with.
>
> Our work around would be to create two collections, one for
> files, one for database records and merge the two results sets -
> but this seems an inferior path.
>
> Peter
>
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Combine Documents and Databse Records in a Verity Index

[Peter Shaw]

We're exploring Verity to use on a new project. Our user profiles are made up 
of several database fields and an optional uploaded document (word / pdf). Is 
it possible to combine both file and database data in a Verity index so that we 
can search both with a single CF_Search? Ideally we only want to get one ranked 
result set back to work with.

Our work around would be to create two collections, one for files, one for 
database records and merge the two results sets - but this seems an inferior 
path.

Peter 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

Showing dynamic data in two side by side groups

[Ali Majdzadeh]

Hi:
I'm trying to make a show dynamic data (dynamic table) using dw/cf8. I works 
fine but it shows data down the page while I need them in two side by side 
groups (columns). I write down the code :


SELECT ID, firstName, lastName, email
FROM Membership



  
First Name
Last Name
Email
  
  

  #members.firstName#
  #members.lastName#
  #members.email#

  



I found a DW extension after some googling made by Tom Muck named 
Horizontal/Vertical Looper which does the job but it is for php/sql not CF. Can 
you please help me find out a way to show dynamic data in two groups instead of 
one that goes down the page using CF8? Please?
Thanks
Benign 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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