RE: cfobject and abcpdf

[Micha Schopman]

Well, I am gonna take a look at the product this weekend. We currently
use it on the .NET applications (with very good results looking at it's
speed and what it renders), and for ColdFusion we are using ActivePDF.

Micha Schopman
Project Manager

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



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: I DID IT!! Shameless Self-promotion

[Les Mizzell]

Mike Kear wrote:
> 
> I finally did it - I sat my Macromedia ColdFusion Developer exam today
> and not only passed, I bloody CREAMED it !!!


So how much of a raise are you going to ask for now?


-- 
Les Mizzell


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

RE: I DID IT!! Shameless Self-promotion

[Steve Kahn]

Well done Mike

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 10:17 PM
To: CF-Talk
Subject: I DID IT!! Shameless Self-promotion


I finally did it - I sat my Macromedia ColdFusion Developer exam today
and not only passed, I bloody CREAMED it !!!

In all four areas of the test, I scored 80% - Application Development,
Database Concepts, Client state management and Data exchange.  Which
means  

Mike Kear is now an Advanced Certified Coldfusion Developer!!!


As a work colleague said when I got back to the RTA today - So you got
20% of them wrong huh?


-- 
Cheers
Mike Kear
Advanced Certified ColdFusion Developer
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

RE: I DID IT!! Shameless Self-promotion

[Ben Forta]

Congrats mate!

And as soon as the Blackstone test comes out ... :-)



 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 10:17 PM
To: CF-Talk
Subject: I DID IT!! Shameless Self-promotion


I finally did it - I sat my Macromedia ColdFusion Developer exam today and
not only passed, I bloody CREAMED it !!!

In all four areas of the test, I scored 80% - Application Development,
Database Concepts, Client state management and Data exchange.  Which means


Mike Kear is now an Advanced Certified Coldfusion Developer!!!


As a work colleague said when I got back to the RTA today - So you got 20%
of them wrong huh?


--
Cheers
Mike Kear
Advanced Certified ColdFusion Developer
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

I DID IT!! Shameless Self-promotion

[Mike Kear]

I finally did it - I sat my Macromedia ColdFusion Developer exam today
and not only passed, I bloody CREAMED it !!!

In all four areas of the test, I scored 80% - Application Development,
Database Concepts, Client state management and Data exchange.  Which
means  

Mike Kear is now an Advanced Certified Coldfusion Developer!!!


As a work colleague said when I got back to the RTA today - So you got
20% of them wrong huh?


-- 
Cheers
Mike Kear
Advanced Certified ColdFusion Developer
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: cfobject and abcpdf

[David Fafard]

This product looks pretty cool.
Anyone use it a coldfusion solution yet ?

Dave


Eric McCormick wrote:

>>>i've never registered a com object on my cf server and i don't 
>>>know how to call it from the cfobject tag.
>>>  
>>>
>>You register COM DLLs using regsvr32.exe, which you can call from the
>>command line like so:
>>
>>regsvr32 mydll.dll
>>
>>As for the rest, the specifics will depend on the COM object in question.
>>
>>Dave Watts, CTO, Fig Leaf Software
>>http://www.figleaf.com/
>>phone: 202-797-5496
>>fax: 202-797-5444
>>
>>
>
>
>Thanks Dave -
>
>The COM object in question is ABCPDF (an HTML->PDF converter) from 
>websupergoo.com  I've had so many problems with htmldoc.exe (which can't 
>handle CSS) that I need to try something new only we can't afford expensive 
>solutions like activePDF. 
>
>If anyone has ever used ABCPDF and can lend any advice on calling it from 
>coldfusion, your advise would be greatly appreciated.
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

OT: Mac/Flash Video assistance requested

[Dennis Powers]

Hi,

I first have to confess my ignorance when it comes to the issues of Mac web
browsers and throw myself on the stake of the OS gods as supplication for my
shame!

Having said that, I am hoping that I could gain some assistance from a MAC
user who might spare some time to determine where we have gone wrong with a
particular Flash Video applet we created and why it won't run in a MAC
browser.

The flash video applet can be found at
http://www.halomaps.org/index.cfm?pg=15&sid=17 select any from the list.  We
pull the *.flv video file name from a database then append it to the URL
line to tell the flash applet to run it.  Mac users are reporting that they
can't see it.  I suspect it has to do with the Flash plug-in version
mismatch but I no longer have a MAC to test it with.   It appears to work
fine in Windows browsers with the Flash 7.x plug-in but MAC users are
complaining.

Any insight you can give to this lowly Windows programmer would be greatly
appreciated.

Best Regards,

Dennis Powers
UXB Internet- A Website Design and Hosting Company
690 Wolcott Road - P.O. Box 6028
Wolcott, CT 06716tel: (203)879-2844
http://www.uxbinternet.com
http://dennis.uxb.net



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: single quotes???

[Adam Howitt]

That approach will get around it but the issue is that you are defeating 
a mechanism designed to protect against SQL injection attacks.  I say 
update your CFMX per the hotfix:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108

Brian Meloche wrote:

>I was able to get it to work by using a CFQUERYPARAM with
>PreserveSingleQuotes around the string, as mentioned in a previous
>thread.
>
>On Wed, 22 Dec 2004 17:31:09 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
>  
>
>>Speaking of single quotes, Mike D needs to add a single quote in the title of 
>>this site. It says "CF-Talk Todays Thread".
>>
>>:)
>>
>>Will
>>
>>
>>
>>
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: single quotes???

[Brian Meloche]

I was able to get it to work by using a CFQUERYPARAM with
PreserveSingleQuotes around the string, as mentioned in a previous
thread.

On Wed, 22 Dec 2004 17:31:09 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Speaking of single quotes, Mike D needs to add a single quote in the title of 
> this site. It says "CF-Talk Todays Thread".
> 
> :)
> 
> Will
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Singleton Design Pattern

[Taco Fleur]

I am just playing with the singleton design pattern, and this is how I
imagine it implemented in ColdFusion, I am just looking after some feedback
on this, and most likely improvements. And maybe I am just way off!!?

 

If needed I can provide some more info on what's going on.

 

* Object.cfc



 



 



 





// 



 

 



 



// Return the instance of the Object

return getInstance();



 



 

 



 



 



 

 



 



evaluate( getSingletonScope() & "[ getMetaData( this
).name ] = this" );



 



 

 



 



return evaluate( getSingletonScope() & "[
getMetaData( this ).name ]" );



 



 

 



 



// Check if this object is a singleton

if ( isSingleton() )

{

// Check if the singleton is
instantiated

if ( isInstantiatedSingleton() )

{

// Get the singleton

this = getSingleton();

}

// Otherwise instantiate the singleton

else

{

setSingleton();

}

}

return this;



 



 

 



 



 



 

 



 



return structKeyExists( evaluate(
getSingletonScope() ), getMetaData( this ).name );



 



 

 



 

 

* Child.cfc



 



 



 





// 

this.instance.test = "";



 



 



super.init();

// Return the instance of the Object

return getInstance();



 



 

 



 



 



 

 



 



 



 

 



 





this.instance.test = arguments.test;



 



 

 



 

* test.cfm



//structDelete( server, "Child" );

obj = createObject( "component", "child" ).init();

// Uncomment the following line the first time this object is instantiated

//obj.test( "testing" );



 





 
-- 
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com  

 


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: single quotes???

[Will Tomlinson]

Speaking of single quotes, Mike D needs to add a single quote in the title of 
this site. It says "CF-Talk Todays Thread". 

:)

Will

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: single quotes???

[Will Tomlinson]

oh well! It displayed as a friggin single quote on this post. lol.  Guess I 
should've removed some of it. Anyway, I replaced the single quote with a html 
equivalent. "#8217"

That worked! 

Is it friggin christmas yet??? 

Will

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: single quotes???

[Will Tomlinson]

oh well! It displayed as a friggin single quote on this post. lol.  Guess I 
should've removed some of it. Anyway, I replaced the single quote with a html 
equivalent. "#8217"

That worked! 

Is it friggin christmas yet??? 

Will

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: CF_HappyHolidays

[Keith Gaughan]

Spike wrote:

> And to you too
> 
> http://www.spike.org.uk/funny/12days.cfm

Hmmm... a little derivative.

Frank Kelly (you might know him as Fr. Jack Hackett from "Father Ted"),
during the '70s, was one of the comedians on an Irish satirical show
called "Hall's Pictorial Weekly". On that, he performed the following
piece:

 http://www.msgr.ca/msgr-2/christmas_countdown.htm


Confusingly, Gobnait in the song is supposedly male, but Gobnait is
the feminine of the name Gob(h)án, meaning "smith", from the Celtic
god "Goibniu", who was a smith and brewer. Hmmm...


K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://digital-crew.com/



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.3 - Release Date: 21/12/2004


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: CF_HappyHolidays

[Keith Gaughan]

David Delbridge wrote:

> Hi all,
> 
> 
>   Merry Christmas!
>   Happy Hanukkah!
>   Happy Kwanzaa!
>   Happy Bodhi Day (belated, sorry)!
>   Yuletide Greetings!
>   
> 
>   Happy Holidays!
> 

Or even:



 
 Merry Christmas!
 
 
 Happy Hanukkah!
 
 
 Happy Kwanzaa!
 
 
 Happy Bodhi Day (belated, sorry)!
 
 
 Happy Holidays!
 


K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://digital-crew.com/


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.3 - Release Date: 21/12/2004


~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: OT: Best CF Blog 2004

[Roger Benningfield]

>Infact, what I specifically
>dont like about blogs is that eveyone has one.

Adam: Sadly, everyone *doesn't* have one... but we're getting there. Thanks to 
network effects, every new blog just broadens the base of my knowledge, 
enriches the online experience, and generally makes the world a better place.

--
Roger Benningfield
work: http://journurl.com/
blog: http://admin.support.journurl.com/

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: CF_HappyHolidays

[Spike]

done

Barney Boisvert wrote:
> Need to edit that.  The 25th is the first day of Christmas, and the
> 12th day is the 5th of January of the next year (the day before
> Epiphany, which is the 6th).  But funny none the less.
> 
> cheers,
> barneyb
> 
> On Wed, 22 Dec 2004 13:20:19 -0800, Spike <[EMAIL PROTECTED]> wrote:
> 
>>And to you too
>>
>>http://www.spike.org.uk/funny/12days.cfm
>>
>>:)
>>
>>Spike
>>
> 
> 

-- 


Stephen Milligan
Code poet for hire
http://www.spike.org.uk

Do you cfeclipse? http://cfeclipse.tigris.org

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: CF_HappyHolidays

[Richard Crawford]

Barney Boisvert wrote:

> Need to edit that.  The 25th is the first day of Christmas, and the
> 12th day is the 5th of January of the next year (the day before
> Epiphany, which is the 6th).  But funny none the less.

I always thought that Epiphany *was* the twelfth day of Christmas.  I 
guess I just never counted.  ;-)

> cheers,
> barneyb
> 
> On Wed, 22 Dec 2004 13:20:19 -0800, Spike <[EMAIL PROTECTED]> wrote:
> 
>>And to you too
>>
>>http://www.spike.org.uk/funny/12days.cfm
>>
>>:)
>>
>>Spike
>>
> 
> 


-- 
Richard S. Crawford
Programmer III
UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu)
2901 K Street, Suite 200C
Sacramento, CA  95816
(916)327-7793


~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: single quotes???

[Will Tomlinson]

Hate to chime in with not much help, but I've had the same problem. One 
application was fine, but another handgrenaded with single quote passing thru 
the insert. Weird!

I think I ended up doing a replace(yourvariable, "'", "’", 'ALL") to make 
it work. 

Would that help? 

Will

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: CF_HappyHolidays

[Barney Boisvert]

Need to edit that.  The 25th is the first day of Christmas, and the
12th day is the 5th of January of the next year (the day before
Epiphany, which is the 6th).  But funny none the less.

cheers,
barneyb

On Wed, 22 Dec 2004 13:20:19 -0800, Spike <[EMAIL PROTECTED]> wrote:
> And to you too
> 
> http://www.spike.org.uk/funny/12days.cfm
> 
> :)
> 
> Spike
> 

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

Got Gmail? I have 10 invites.

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: CF_HappyHolidays

[Joe Rinehart]

Invalid CFML construct found on line 2 at column 15.
ColdFusion was looking at the following text:

=


Dang operators get me all the time, too.  Happy holidays.

-Joe
-- 
For Tabs, Trees, and more, use the jComponents:
http://clearsoftware.net/client/jComponents.cfm

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: CF_HappyHolidays

[Spike]

And to you too

http://www.spike.org.uk/funny/12days.cfm

:)

Spike

David Delbridge wrote:
> Hi all,
> 
> 
>   Merry Christmas!
>   Happy Hanukkah!
>   Happy Kwanzaa!
>   Happy Bodhi Day (belated, sorry)!
>   Yuletide Greetings!
>   
> 
>   Happy Holidays!
> 
> 
> Dave
> 
> 

-- 


Stephen Milligan
Code poet for hire
http://www.spike.org.uk

Do you cfeclipse? http://cfeclipse.tigris.org

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

RE: ColdFusion built-in tags and permission-based security framework

[Micha Schopman]

I have put up the total diagram of the product I am working on and contains the 
security layer I mentioned. 
 
http://www.mschopman.demon.nl/diagram.gif
 
And a screenshot of the permission set screen in my cms app..
 
http://www.mschopman.demon.nl/set.gif
 
If you need any help figuring out what the heck it is .. (the diagram looks a 
bit abstract yes.. :P ) feel free to drop me an email or ask me through msn 
messenger.
 
Micha
 



From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Wed 12/22/2004 3:07 PM
To: CF-Talk
Subject: RE: ColdFusion built-in tags and permission-based security framework



Thanks

-Original Message-
From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED]
Sent: 22 December 2004 11:57
To: CF-Talk
Subject: Re: ColdFusion built-in tags and permission-based security
framework

Stephen Moretti (cfmaster) wrote:

>Ian Vaughan wrote:
>
> 
>
>>How could I display the correct menu options which are generated from
the correct cfquery based on the user logged in.
>>
>>So if the user logged in is from the personnel department the
following query populates the select boxes, but if the user logged in is
from the finance department then the finance query runs on the page to
populate the select box.
>>
>>Can anybody see any flaws with this approach ? Or how it can be
improved to make the solution more flexible?
>>
>>
>>   
>>
>Ian,
>
>Are you saying that you have a separate category table for each
department?
>
>>Yes, each department about 6 in total
>
Ok - you definately need to abstract the design of your database.  At
the minute, if you need to add a new department or remove a department
you have to get your hands dirty, create a new table or remove a table
from the database and make changes to the code to allow for this.

What you need to do is have one category table, one user/member of staff
table and a department table.  The departments table maintains the
complete list of departments along with a unique ID for each department.
The same is true for the users and categories tables.
You then need to relate these tables to one another, ie. have tables
that tell you which users belong in which department and which
departments have access to which categories.

Take a look at the ER diagram I've run up for you here
http://snipurl.com/bilm  It fairly simplified, but hopefully it should
help to make sense of what I'm describing above.

With a database structure like this you can add and remove departments
extremely easily, add new users to departments and change the categories
available to any given department as well as allow multiple departments
access to one category.

How does this work?  Your user logs in, so you get a unique identifier
for them by querying the users table during the login process.

SELECT UserID FROM Users
WHERE UserName='#form.loginname#' AND Password =
'#hash(form.loginpassword)#'

With that UserID you can identify the department(s) that that user is a
member of, by querying the link table between user and department.

SELECT Department.DepartmentID, Department.DepartmentName FROM
Department
INNER JOIN DeptMembers AS DM ON Department.DepartmentID =
DM.DepartmentID WHERE DM.UserID = #qryUser.UserID#

If you want to know what categories they can access you can get this
information by JOINing DepartmentMembers to Categories through
DepartmentCategories.

SELECT Categories.CategoryID, Categories.CategoryName FROM Categories
INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID =
DC.CategoryID
INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID =
DM.DeparmentID WHERE DM.UserID = #qryUser.UserID#

This doesn't take in to account handling your tree of categories, but as
you've more than likely got the code to manage this, it shouldn't be too
hard to integrate what is here with what you've got for the category
tree.

BTW : You should have a look at John Celko's nested set model
(http://snipurl.com/JoeCelko_NestedSets - you will need to register on
the site, but its free and I've not had any spam from them)

Hope this helps

Regards

Stephen






~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

CF_HappyHolidays

[David Delbridge]

Hi all,


Merry Christmas!
Happy Hanukkah!
Happy Kwanzaa!
Happy Bodhi Day (belated, sorry)!
Yuletide Greetings!


Happy Holidays!


Dave


-- 

David M. Delbridge
Circa 3000
ColdFusion Hosting
http://www.circa3k.com
866-CIRCA3K (247-2235)
Outside U.S: +1.775-832-2445


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: search for a string across columns

[Michael Traher]

I might be wrong but I would have thought that the DBMS will simply
expand the cancat syntax to the full version with the ORs in that you
started with.

In other words it may be useful shorthand but it will not
change/improve the actual query.


On Wed, 22 Dec 2004 14:43:09 -0400, daniel kessler <[EMAIL PROTECTED]> wrote:
> >Concatobate = Concatenate
> 
> ya I got that, but it's the kind of date that seemed like I wouldn't.
> 
> >And don't for get your wildcards on the like '%#search#%'
> 
> I did and just corrected it.  thanks.
> 
> I haven't been able to get this to search across multiple columns yet.  I 
> haven't checked it out for the space issue you mentioned though.  Right now 
> my line 1 is "in memory of" and line_2 is 'donald duck'.
> 
> I'll think about it.
> 
> >
> >
> >
> >Patrick McGeehan
> >Applications Developer
> >DIT
> >#mcg#
> >
> >
> >
> >
> >
> >-Original Message-
> >From: Patrick McGeehan [mailto:[EMAIL PROTECTED]
> >Sent: Wednesday, December 22, 2004 1:11 PM
> >To: CF-Talk
> >Subject: RE: search for a string across columns
> >
> >
> >Concatobate.  What type of db you are using says what the concat operator
> >is.  The below is for oracle.
> >
> >
> >   SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
> >   FROM giving_leaves
> >   WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE
> >'#s#' 
> >
> >
> >You would just have to worry about the spaces because in your example line_1
> >and line_2 would concat to "I need togo to the bathroom", so depending on
> >how it is set up over all maybe concat with a space between, like this
> >   WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || '
> >' || line_5  || ' ' || line_6 LIKE '#s#'
> >
> >
> >Patrick McGeehan
> >Applications Developer
> >DIT
> >#mcg#
> >
> >
> >
> >
> >
> >-Original Message-
> >From: Daniel Kessler [mailto:[EMAIL PROTECTED]
> >Sent: Wednesday, December 22, 2004 12:11 PM
> >To: CF-Talk
> >Subject: search for a string across columns
> >
> >
> >I have a db that contains 6 similar columns: line_1, line_2 , line_3
> >, line_4 , line_5 , line_6
> >I want to have a search that searches across columns.  While I can
> >search them individually, it would be better if they were combined
> >before the LIKE was done so that if I had:
> >line_1="I need to"
> >line_2="go to the bathroom"
> >and I searched  "need to go", it would return a hit.
> >
> >I'm not sure how to approach this but while I have a beginning, I
> >know that it is incorrect because it's the first type of search,
> >searching each line individually.
> >
> >
> >   SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
> >   FROM giving_leaves
> >   WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'
> >
> >
> >thanks for the help.
> >
> >--
> >Daniel Kessler
> >
> >Department of Public and Community Health
> >University of Maryland
> >Suite 2387 Valley Drive
> >College Park, MD  20742-2611
> >301-405-2545 Phone
> >www.phi.umd.edu
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: single quotes???

[Adam Howitt]

This is absolutely the build version you are using.  We rebuilt our dev 
and stage servers recently which meant our production server was on an 
older build.  It took me some time to realize that the duplicated 
apostrophe/single quote thing was due to the cfquery, cfqueryparam.  
Here is the technote on the issue:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108


Brian Meloche wrote:

>Tony, I am having the exact same problem on an application that we
>have just upgraded to MX.  We have never seen this problem in CF5.
>
>
>On Sat, 18 Dec 2004 10:44:03 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
>  
>
>>twas what i thought, but the same code, with an insert that has no '
>>in the value thats coming from the form, doesnt bomb, so i can single
>>that out.
>>
>>its the strangest effin thing ive seen :(
>>
>>--
>>tony
>>
>>Tony Weeg
>>
>>macromedia certified coldfusion mx developer
>>email: tonyweeg [at] gmail [dot] com
>>blog: http://www.revolutionwebdesign.com/blog/
>>cool tool: http://www.antiwrap.com
>>
>>
>>
>>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Setup datasource thru code?

[Sean Corfield]

On Wed, 22 Dec 2004 08:11:37 -, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Yeah, there is a factory method you can use :
> 
> http://www.petefreitag.com/item/152.cfm
> 
> I don't see how or why this isn't supported as isn't this what CF is using
> to create DSN's itself?

They are undocumented, unsupported and subject to change in every
release. In other words, you can't rely on them even if they happen to
work today. Why are they not supported? Because the product team
reserve the right to re-implement their admin code without having to
provide backward-compatibility for undocumented features I guess.
That's pretty standard in every product.
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 4 invites to give away!

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

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: OT: Best CF Blog 2004

[Adam Howitt]

It's okay, I feel the same way about Wikis.

Adrocknaphobia wrote:

>I know this off-topic, but sometimes I feel like I'm the only
>person in the world who doesnt like blogs. Infact, what I specifically
>dont like about blogs is that eveyone has one.
>
>-Adam
>
>
>On Wed, 22 Dec 2004 10:45:06 -0600, Adam Howitt <[EMAIL PROTECTED]> wrote:
>  
>
>  
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: OT: Best CF Blog 2004

[Burns, John D]

Adam,

At MAX, weren't you talking about setting up a blog? :-) 


John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer

-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 3:00 PM
To: CF-Talk
Subject: Re: OT: Best CF Blog 2004

I know this off-topic, but sometimes I feel like I'm the only
person in the world who doesnt like blogs. Infact, what I specifically
dont like about blogs is that eveyone has one.

-Adam


On Wed, 22 Dec 2004 10:45:06 -0600, Adam Howitt <[EMAIL PROTECTED]>
wrote:
> Which CF blog provides the best content in your opinion?  I have a 
> thread over at http://www.webdevref.com/blog/ for voting purposes.
> Nothing too scientific but I wanted to see if there are any essential 
> CF blogs I should be reading.  I'm looking for unique content vs the 
> prolific linker.
> 
> 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: Deleting Image

[Burns, John D]

Check the permissions on the folder.  Whatever account CF is running
under needs to have access to that directory. 


John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer

-Original Message-
From: Jason Smith [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 2:51 PM
To: CF-Talk
Subject: Deleting Image

Can anyone help with this error? I know the file exists in that location
however I'm not able to thumbnail pics that are uploaded nor am I able
to delete the images, This is the error when trying to remove an image.


The destination
"C:\Inetpub\voremarketing\zimages\uploadedItemImages\wyb.gif" specified
in the CFFILE tag is invalid.


The destination either does not exist or is not accessible by this tag.

The error occurred in
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory
_Images_action.cfm: 
line 76
Called from
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory
_Images_action.cfm: 
line 57
Called from
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory
_Images_action.cfm: 
line 1

 
 
 

 
 DELETE FROM tblItemImages
 WHERE itemImageID = #itemImageID#
 
 
 

Web Your Business Inc., - located in Loveland, Colorado; serving the
World!
http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/
Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: OT: Best CF Blog 2004

[Adrocknaphobia]

I know this off-topic, but sometimes I feel like I'm the only
person in the world who doesnt like blogs. Infact, what I specifically
dont like about blogs is that eveyone has one.

-Adam


On Wed, 22 Dec 2004 10:45:06 -0600, Adam Howitt <[EMAIL PROTECTED]> wrote:
> Which CF blog provides the best content in your opinion?  I have a
> thread over at http://www.webdevref.com/blog/ for voting purposes.
> Nothing too scientific but I wanted to see if there are any essential CF
> blogs I should be reading.  I'm looking for unique content vs the
> prolific linker.
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Deleting Image

[Jason Smith]

Can anyone help with this error? I know the file exists in that location 
however I'm not able to thumbnail pics that are uploaded nor am I able to 
delete the images, This is the error when trying to remove an image.


The destination 
"C:\Inetpub\voremarketing\zimages\uploadedItemImages\wyb.gif" specified in 
the CFFILE tag is invalid.


The destination either does not exist or is not accessible by this tag.

The error occurred in 
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm:
 
line 76
Called from 
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm:
 
line 57
Called from 
C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm:
 
line 1

 
 
 

 
 DELETE FROM tblItemImages
 WHERE itemImageID = #itemImageID#
 
 
 

Web Your Business Inc., - located in Loveland, Colorado; serving the World!
http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/
Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: single quotes???

[Brian Meloche]

Tony, I am having the exact same problem on an application that we
have just upgraded to MX.  We have never seen this problem in CF5.


On Sat, 18 Dec 2004 10:44:03 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> twas what i thought, but the same code, with an insert that has no '
> in the value thats coming from the form, doesnt bomb, so i can single
> that out.
> 
> its the strangest effin thing ive seen :(
> 
> --
> tony
> 
> Tony Weeg
> 
> macromedia certified coldfusion mx developer
> email: tonyweeg [at] gmail [dot] com
> blog: http://www.revolutionwebdesign.com/blog/
> cool tool: http://www.antiwrap.com
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: search for a string across columns

[daniel kessler]

>Concatobate = Concatenate

ya I got that, but it's the kind of date that seemed like I wouldn't.

>And don't for get your wildcards on the like '%#search#%'

I did and just corrected it.  thanks.

I haven't been able to get this to search across multiple columns yet.  I 
haven't checked it out for the space issue you mentioned though.  Right now my 
line 1 is "in memory of" and line_2 is 'donald duck'.

I'll think about it.

>
>
>
>Patrick McGeehan 
>Applications Developer
>DIT
>#mcg#
>
> 
>
>
>
>-Original Message-
>From: Patrick McGeehan [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, December 22, 2004 1:11 PM
>To: CF-Talk
>Subject: RE: search for a string across columns
>
>
>Concatobate.  What type of db you are using says what the concat operator
>is.  The below is for oracle.
>
>
>   SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
>   FROM giving_leaves
>   WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE
>'#s#' 
>
>
>You would just have to worry about the spaces because in your example line_1
>and line_2 would concat to "I need togo to the bathroom", so depending on
>how it is set up over all maybe concat with a space between, like this
>   WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || '
>' || line_5  || ' ' || line_6 LIKE '#s#'
>
>
>Patrick McGeehan 
>Applications Developer
>DIT
>#mcg#
>
> 
>
>
>
>-Original Message-
>From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
>Sent: Wednesday, December 22, 2004 12:11 PM
>To: CF-Talk
>Subject: search for a string across columns
>
>
>I have a db that contains 6 similar columns: line_1, line_2 , line_3 
>, line_4 , line_5 , line_6
>I want to have a search that searches across columns.  While I can 
>search them individually, it would be better if they were combined 
>before the LIKE was done so that if I had:
>line_1="I need to"
>line_2="go to the bathroom"
>and I searched  "need to go", it would return a hit.
>
>I'm not sure how to approach this but while I have a beginning, I 
>know that it is incorrect because it's the first type of search, 
>searching each line individually.
>
>
>   SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
>   FROM giving_leaves
>   WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'
>
>
>thanks for the help.
>
>-- 
>Daniel Kessler
>
>Department of Public and Community Health
>University of Maryland
>Suite 2387 Valley Drive
>College Park, MD  20742-2611
>301-405-2545 Phone
>www.phi.umd.edu

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: IsDefined with dynamic variable

[Asim Manzur]

Both options works,
Thanks Qasim and Raymond


> Change it to one of these two things:
> 
> 
> 
> or
> 
> 
> 
> 
> On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur <[EMAIL PROTECTED]> 
> wrote:
> > 
> > 
> > This is giving me the following error
> > 
> > Parameter 1 of function IsDefined, which is now 
> "form["Desc_ID1"]", must be a syntactically valid variable 
> name.
> > 
> > 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Fusebox 3 Layouts

[Mark Drew]

That will be my next plugin after this one if no one else is
developing it but I have a vested interest as my sites are fb3 :D


On Wed, 22 Dec 2004 11:01:54 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> I suspect you'll find that not many people are developing with Fusebox
> 3 any more.  There are definitely a lot of sites out there that are
> running it and will probably never be upgraded (I have several, along
> with some FB2 ones as well), but my impressions is that most
> Fuseboxers are pretty much using Fusebox 4 for new development.
> 
> That being said, i do something quite similar to that for my
> fbx_Layouts file.  I don't use a subdirectory, use a "lay" prefix for
> my fuse names, and hold the layout selection variable in the request
> scope rather than variables, but the idea is identical.  I also use a
> second variable 'attributes.suppressLayouts' which, if set to true',
> will cause layouts to be skipped.
> 
> cheers,
> barneyb
> 
> 
> On Wed, 22 Dec 2004 19:53:30 +0100, Mark Drew <[EMAIL PROTECTED]> wrote:
> > Hi there
> > as you might now I am trying to make a plugin for fusebox 3. what I
> > was wondering was how do people make their fbx_Layouts.cfm file?
> >
> > The reson I ask is that I have seen the demo and default but I wanted
> > to implement best practice.
> >
> > Personally I do something like:
> >
> > 
> > 
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > --
> > Mark Drew
> >
> > coldfusion and cfeclipse blogged:
> > http://cybersonic.blogspot.com/
> > \
> 
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/blog/
> 
> Got Gmail? I have 10 invites.
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: forms as arrays

[Michael Traher]

nothing wrong with it, but does it gain you anything?

What if you want to add a length or onclick attributes to some but not
all fields?

If you want to shorten the code you could do your form the standard
way but drop it in a separate file and cfinclude it.

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Fusebox 3 Layouts

[Barney Boisvert]

I suspect you'll find that not many people are developing with Fusebox
3 any more.  There are definitely a lot of sites out there that are
running it and will probably never be upgraded (I have several, along
with some FB2 ones as well), but my impressions is that most
Fuseboxers are pretty much using Fusebox 4 for new development.

That being said, i do something quite similar to that for my
fbx_Layouts file.  I don't use a subdirectory, use a "lay" prefix for
my fuse names, and hold the layout selection variable in the request
scope rather than variables, but the idea is identical.  I also use a
second variable 'attributes.suppressLayouts' which, if set to true',
will cause layouts to be skipped.

cheers,
barneyb


On Wed, 22 Dec 2004 19:53:30 +0100, Mark Drew <[EMAIL PROTECTED]> wrote:
> Hi there
> as you might now I am trying to make a plugin for fusebox 3. what I
> was wondering was how do people make their fbx_Layouts.cfm file?
> 
> The reson I ask is that I have seen the demo and default but I wanted
> to implement best practice.
> 
> Personally I do something like:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> Mark Drew
> 
> coldfusion and cfeclipse blogged:
> http://cybersonic.blogspot.com/
> \


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

Got Gmail? I have 10 invites.

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Fusebox 3 Layouts

[Mark Drew]

Hi there
as you might now I am trying to make a plugin for fusebox 3. what I
was wondering was how do people make their fbx_Layouts.cfm file?

The reson I ask is that I have seen the demo and default but I wanted
to implement best practice.

Personally I do something like:























--
Mark Drew

coldfusion and cfeclipse blogged:
http://cybersonic.blogspot.com/

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

RE: Seeing double?

[Katz, Dov B (IT)]

The base is an artifact of the CF_FormURL2Attributes tag, which runs
before any content is output. It's harmless, but yes, it does break some
standards. That being said, no browser I've ever seen failed to load a
page with that base tag there

My code is straight out cfmodule'd ...




The only other change is that I have j2ee sessions enabled on the  bad
machine -- 6,1,..83762

-Dov


-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 1:28 PM
To: CF-Talk
Subject: Re: Seeing double?

On Wed, 22 Dec 2004 08:53:47 -0500, Katz, Dov B (IT)
<[EMAIL PROTECTED]> wrote:
> Right. This much I know... The code switches on executionmode which is

> why it makes a good single cfmodule call for start-end use.  It works 
> perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but 
> when the code was copied to the other (quad 2.4ghz, 2gb ram, 
> 6,1,0,83762) it looks strange.

First off, looks like you have different versions of CFMX 6.1 on each
server yes? That hotfix dates from December 2003. I'm guessing the
83762 build number is the 6.1 Updater. It's possible that your code is
relying on a bug that got fixed by the updater...

Second, you are outputting a  tag *before* the page content which
means the DOCTYPE will not be read correctly by browsers (and your page
will not validate).
--
Sean A Corfield -- http://www.corfield.org/ Team Fusebox --
http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 4 invites to give away!

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



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: breaking a line of code to two lines

[Carlos Balacuit]

You could try:



--
Carlos Balacuit
Macromedia Certified ColdFusion MX Advanced Developer

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: Seeing double?

[Sean Corfield]

On Wed, 22 Dec 2004 08:53:47 -0500, Katz, Dov B (IT)
<[EMAIL PROTECTED]> wrote:
> Right. This much I know... The code switches on executionmode which is
> why it makes a good single cfmodule call for start-end use.  It works
> perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but when
> the code was copied to the other (quad 2.4ghz, 2gb ram, 6,1,0,83762) it
> looks strange.

First off, looks like you have different versions of CFMX 6.1 on each
server yes? That hotfix dates from December 2003. I'm guessing the
83762 build number is the 6.1 Updater. It's possible that your code is
relying on a bug that got fixed by the updater...

Second, you are outputting a  tag *before* the page content
which means the DOCTYPE will not be read correctly by browsers (and
your page will not validate).
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 4 invites to give away!

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

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

OT: SQL Server Disaster Recovery

[Qasim Rasheed]

For those who work as a DBA or has to manage a SQL Server,
sql-server-performance has a great link to an article from Brian
Knight that discusses Disaster recovery and is "A Survival Toolkit for
the DBA".  It even comes with a bunch of scripts already written. 
Here is the link to the article
http://www.lumigent.com/go/sd19/

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: Total Sales Menu

[Michael Traher]

try creating date objects first using 


then supply dates to your queries using  



This should make the sql db independant (probably!) 

HTH

On Wed, 22 Dec 2004 09:41:54 -0700, Jason Smith
<[EMAIL PROTECTED]> wrote:
> The following code is from a menu on a site that shows the
> monthly/quarterly/yearly goal and sales the goal part is working fine but
> since switching from access to mysql the currently month/quarter/year sales
> isn't being calulated.
> 
> 
>
>
>
> style="text-align: left;">
> datePart("m", now())>
> datePart("", now())>
> now())>
> name="getMonthlyPurchase" datasource="#DS#"
> cachedwithin="#CreateTimeSpan(0,4,35,0)#">
>SELECT 
> Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase
>FROM tblItemPurchase
>WHERE 
> tblItemPurchase.itemPurchaseDate >= '#theMonth#/#1#/#theYear#'
>
>
> getMonthlyPurchase.recordCount neq 0 and
> getMonthlyPurchase.recordCount neq "" and
> getMonthlyPurchase.totalMonthlyPurchase neq "">
> theGoal - getMonthlyPurchase.totalMonthlyPurchase>
>
> theGoal>
>
> bgcolor="#CC" style="font-size:
> 18px; font-weight: bold; text-align: center; padding: 2 3 2 3;
> border-right: black 1px solid; border-bottom:black 1px
> solid;">GOALS
> style="width:100%; ">
>THIS 
> MONTH:
> bgcolor="#B9E1F4" width="100%">
>
>   
>  
>   
>   class="voTitle">GOAL:#DollarFormat(theGoal)#. style="font-size: 2px;">
>   
>  SO
> FAR:#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)# style="font-size: 2px;">
>   
>  TO
> GO:#DollarFormat(amountLeft)#
>   
>  
>
>
>
>
>
> 
>
>
> 
> datePart("m", now())>
> datePart("", now())>
> expression="#theMonth#">
>
> startMonth = 1>
> endMonth = 3>
> = 31>
>
>
> startMonth = 4>
> endMonth = 6>
> = 30>
>
>
> startMonth = 7>
> endMonth = 9>
> = 30>
>
> value="10,11,12">
> startMonth = 10>
> 

RE: search for a string across columns

[Patrick McGeehan]

Concatobate = Concatenate

And don't for get your wildcards on the like '%#search#%'






Patrick McGeehan 
Applications Developer
DIT
#mcg#

 



-Original Message-
From: Patrick McGeehan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 1:11 PM
To: CF-Talk
Subject: RE: search for a string across columns


Concatobate.  What type of db you are using says what the concat operator
is.  The below is for oracle.


SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
FROM giving_leaves
WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE
'#s#' 


You would just have to worry about the spaces because in your example line_1
and line_2 would concat to "I need togo to the bathroom", so depending on
how it is set up over all maybe concat with a space between, like this
WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || '
' || line_5  || ' ' || line_6 LIKE '#s#'


Patrick McGeehan 
Applications Developer
DIT
#mcg#

 



-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 12:11 PM
To: CF-Talk
Subject: search for a string across columns


I have a db that contains 6 similar columns: line_1, line_2 , line_3 
, line_4 , line_5 , line_6
I want to have a search that searches across columns.  While I can 
search them individually, it would be better if they were combined 
before the LIKE was done so that if I had:
line_1="I need to"
line_2="go to the bathroom"
and I searched  "need to go", it would return a hit.

I'm not sure how to approach this but while I have a beginning, I 
know that it is incorrect because it's the first type of search, 
searching each line individually.


SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
FROM giving_leaves
WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'


thanks for the help.

-- 
Daniel Kessler

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





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: search for a string across columns

[daniel kessler]

ok, great.
I understand conceptually.  I've not done it beore but I'll give it a "college 
try" :-)
thanks for the guidance.

>I would do a sub-query where you union the same query on each column,
>and then query that.
>
>|I have a db that contains 6 similar columns: line_1, line_2 ,
>|line_3 , line_4 , line_5 , line_6 I want to have a search that
>|searches across columns.  While I can search them
>|individually, it would be better if they were combined before
>|the LIKE was done so that if I had:
>|line_1="I need to"
>|line_2="go to the bathroom"
>|and I searched  "need to go", it would return a hit.
>|
>|I'm not sure how to approach this but while I have a
>|beginning, I know that it is incorrect because it's the first
>|type of search, searching each line individually.
>|
>|
>|  SELECT
>|recipients_lname,recipients_fname,recipients_mi,leaf_number
>|  FROM giving_leaves
>|  WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'
>|
>|
>|thanks for the help.
>|
>|--
>|Daniel Kessler
>|
>|Department of Public and Community Health University of
>|Maryland Suite 2387 Valley Drive College Park, MD  20742-2611
>|301-405-2545 Phone
>|www.phi.umd.edu
>|
>|

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: search for a string across columns

[Patrick McGeehan]

Concatobate.  What type of db you are using says what the concat operator
is.  The below is for oracle.


SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
FROM giving_leaves
WHERE line_1 || line_2 || line_3 ||line_4 || line_5 || line_6 LIKE
'#s#'



You would just have to worry about the spaces because in your example line_1
and line_2 would concat to "I need togo to the bathroom", so depending on
how it is set up over all maybe concat with a space between, like this
WHERE line_1 || ' ' || line_2 || ' ' || line_3 || ' ' || line_4 || '
' || line_5  || ' ' || line_6 LIKE '#s#'


Patrick McGeehan 
Applications Developer
DIT
#mcg#

 



-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 12:11 PM
To: CF-Talk
Subject: search for a string across columns


I have a db that contains 6 similar columns: line_1, line_2 , line_3 
, line_4 , line_5 , line_6
I want to have a search that searches across columns.  While I can 
search them individually, it would be better if they were combined 
before the LIKE was done so that if I had:
line_1="I need to"
line_2="go to the bathroom"
and I searched  "need to go", it would return a hit.

I'm not sure how to approach this but while I have a beginning, I 
know that it is incorrect because it's the first type of search, 
searching each line individually.


SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
FROM giving_leaves
WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'


thanks for the help.

-- 
Daniel Kessler

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



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: 1st, 2nd, 3rd, 4th

[Nathan Strutz]

This reminds me of one of my favorite programming glitches.

http://www.google.com/search?q=11st
http://www.google.com/search?q=12nd
http://www.google.com/search?q=13rd

Seriously, though, I made a little number namer a while ago, and it's 
all tags and not cfscript, but here it is for ya.
































Rick Root wrote:
> Does anyone have a function that takes numbers and converts them to 1st, 
> 2nd, 3rd, ... 15th, .. 21st, etc?
> 
>   - Rick
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

RE: 1st, 2nd, 3rd, 4th

[Dave Watts]

> Does anyone have a function that takes numbers and converts them to 1st,
>
> 2nd, 3rd, ... 15th, .. 21st, etc?

http://www.cflib.org/udf.cfm?ID=349

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: 1st, 2nd, 3rd, 4th

[Paul]

I can't vouch for it, but this seems to be what you need.
http://www.cflib.org/udf.cfm?ID=805


-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 10:36 AM
To: CF-Talk
Subject: 1st, 2nd, 3rd, 4th

Does anyone have a function that takes numbers and converts them to 1st, 
2nd, 3rd, ... 15th, .. 21st, etc?

  - Rick



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

1st, 2nd, 3rd, 4th

[Rick Root]

Does anyone have a function that takes numbers and converts them to 1st, 
2nd, 3rd, ... 15th, .. 21st, etc?

  - Rick

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: search for a string across columns

[Hugo Ahlenius]

I would do a sub-query where you union the same query on each column,
and then query that.

|I have a db that contains 6 similar columns: line_1, line_2 ,
|line_3 , line_4 , line_5 , line_6 I want to have a search that
|searches across columns.  While I can search them
|individually, it would be better if they were combined before
|the LIKE was done so that if I had:
|line_1="I need to"
|line_2="go to the bathroom"
|and I searched  "need to go", it would return a hit.
|
|I'm not sure how to approach this but while I have a
|beginning, I know that it is incorrect because it's the first
|type of search, searching each line individually.
|
|
|   SELECT
|recipients_lname,recipients_fname,recipients_mi,leaf_number
|   FROM giving_leaves
|   WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'
|
|
|thanks for the help.
|
|--
|Daniel Kessler
|
|Department of Public and Community Health University of
|Maryland Suite 2387 Valley Drive College Park, MD  20742-2611
|301-405-2545 Phone
|www.phi.umd.edu
|
|

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

RE: Okay, stupid question time...

[Andy Ousterhout]

Try


aryNews.headline

-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 10:18 AM
To: CF-Talk
Subject: Okay, stupid question time...




myObject.getNews().headline

Naturally...only one displays, even though the query returns three...totally
cool so far...

Now, I want to loop over the Query object that getNews() returns...

so...um

myObject.getNews().headline





~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

search for a string across columns

[Daniel Kessler]

I have a db that contains 6 similar columns: line_1, line_2 , line_3 
, line_4 , line_5 , line_6
I want to have a search that searches across columns.  While I can 
search them individually, it would be better if they were combined 
before the LIKE was done so that if I had:
line_1="I need to"
line_2="go to the bathroom"
and I searched  "need to go", it would return a hit.

I'm not sure how to approach this but while I have a beginning, I 
know that it is incorrect because it's the first type of search, 
searching each line individually.


SELECT recipients_lname,recipients_fname,recipients_mi,leaf_number
FROM giving_leaves
WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#'


thanks for the help.

-- 
Daniel Kessler

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

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: CFStoredProc bug?

[Nathan Strutz]

Robertson-Ravo, Neil (RX) wrote:
> Based on the comments - I ran a quick test with an SP which basically ran
> the following (where iLanguageID and iEventID were @ variables passed in via
> dbvarname):


How did you call the procedure, with cfquery or with cfstoredproc? Did 
you use 's? That's actually what this part of the thread 
is about. I suggest you try ALL the possibilities.

> 
> Now, this is by no means a solid call as it can fluctuate between them both
> taking 0 duration but never the SP taking any more than that and shows its
> more efficient.
> 

That's not the point at all. We all know stored procedures are faster 
than plain vanilla sql statements. That's not in question, it's common 
sense.


> Client vars do perform updates internally using SP's for EVERY CALL if you
> do not switch that method off via the Client Vars section - maybe this is
> what your DBA was seeing?  This does indeed cause 3 SP's to run for every
> .CFM thread; turn the updates off if you don't need last visit and hit count
> updated constantly.

Yes, I know that, problem is the app was relying on these variables. 
After disabling these updates, there was still overhead and inefficency 
on the DB storage for client vars. Run SQL Profiler on your database and 
you'll see it compiling and removing procedures all the time, not very 
good practice.

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


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

OT: Best CF Blog 2004

[Adam Howitt]

Which CF blog provides the best content in your opinion?  I have a 
thread over at http://www.webdevref.com/blog/ for voting purposes.  
Nothing too scientific but I wanted to see if there are any essential CF 
blogs I should be reading.  I'm looking for unique content vs the 
prolific linker.


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Total Sales Menu

[Jason Smith]

The following code is from a menu on a site that shows the 
monthly/quarterly/yearly goal and sales the goal part is working fine but 
since switching from access to mysql the currently month/quarter/year sales 
isn't being calulated.










SELECT 
Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase
FROM tblItemPurchase
WHERE 
tblItemPurchase.itemPurchaseDate >= '#theMonth#/#1#/#theYear#'







GOALS

THIS 
MONTH:





GOAL:#DollarFormat(theGoal)#.

SO 
FAR:#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)#

TO 
GO:#DollarFormat(amountLeft)#   








 




   









 




 




 
   



SELECT 
Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase
FROM tblItemPurchase
WHERE 
tblItemPurchase.itemPurchaseDate >= '#startMonth#/1/#theYear#'
AND 
tblItemPurchase.itemPurchaseDate <= '#endMonth#/#endDay#/#theYear#'


  

Re: Okay, stupid question time...

[Jeff Small]

From: "Pascal Peters" <[EMAIL PROTECTED]>
> 
> http://www.ruwebby.com

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

Re: Okay, stupid question time...

[Keith Gaughan]

Jeff Small wrote:

> 
> 
> myObject.getNews().headline
> 
> Naturally...only one displays, even though the query returns three...totally 
> cool so far...
> 
> Now, I want to loop over the Query object that getNews() returns...
> 
> so...um
> 
> myObject.getNews().headline 



#headline

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://digital-crew.com/


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.3 - Release Date: 21/12/2004


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

RE: Okay, stupid question time...

[Pascal Peters]

 -Original Message-
> From: Jeff Small [mailto:[EMAIL PROTECTED]
> Sent: 22 December 2004 17:18
> To: CF-Talk
> Subject: Okay, stupid question time...
> 
> 
> 
> myObject.getNews().headline
> 
> Naturally...only one displays, even though the query returns
> three...totally
> cool so far...
> 
> Now, I want to loop over the Query object that getNews() returns...
> 
> so...um
> 
> myObject.getNews().headline
> 
> 
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Okay, stupid question time...

[Joe Rinehart]

Hey Jeff,

It'll work like any query created in your page with CFQuery...ie, if
getNews() returns a query...




  


-joe


On Wed, 22 Dec 2004 11:18:26 -0500, Jeff Small <[EMAIL PROTECTED]> wrote:
> 
> 
> myObject.getNews().headline
> 
> Naturally...only one displays, even though the query returns three...totally
> cool so far...
> 
> Now, I want to loop over the Query object that getNews() returns...
> 
> so...um
> 
> myObject.getNews().headline
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Okay, stupid question time...

[Jeff Small]

myObject.getNews().headline

Naturally...only one displays, even though the query returns three...totally 
cool so far...

Now, I want to loop over the Query object that getNews() returns...

so...um

myObject.getNews().headline 



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: IsDefined with dynamic variable

[Raymond Camden]

Change it to one of these two things:



or




On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote:
> 
> 
> This is giving me the following error
> 
> Parameter 1 of function IsDefined, which is now "form["Desc_ID1"]", 
> must be a syntactically valid variable name.
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: IsDefined with dynamic variable

[Qasim Rasheed]

try 




On Wed, 22 Dec 2004 11:08:50 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote:
>
> 
> This is giving me the following error
> 
> Parameter 1 of function IsDefined, which is now "form["Desc_ID1"]", 
> must be a syntactically valid variable name.
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

IsDefined with dynamic variable

[Asim Manzur]

This is giving me the following error

Parameter 1 of function IsDefined, which is now "form["Desc_ID1"]", 
must be a syntactically valid variable name. 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

RE: Searching for Spock

[Stuart Kidd]

Thanks Jim.  Actually, it just arrived an hour ago in a tattered box from 
Bytes. So i have loads of blue books now.

:)

I've often come across the livedocs on Google.

I've worked out the Verity search thingy now and it's pretty good.

Saturday



-- Original Message --
From: "Jim Davis" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Wed, 22 Dec 2004 10:24:56 -0500

>If you're saying that you don't have documentation, remember that ALL
>current MM documentation (with user comments) is available at
>livedocs.macromedia.com.
>
>Insanely useful.
>
>Jim Davis
>
>> -Original Message-
>> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, December 22, 2004 7:25 AM
>> To: CF-Talk
>> Subject: Re: Searching for Spock
>> 
>> Thanks Mark, i'll give that a go, i'll look into the doco.
>> 
>> I can't believe i have just ordered CF6.1 for my work and soon Blackstone
>> will be here (but i got them to get the 2 years upgrade option! - but that
>> doesn't mean the documentation!)
>
>
>
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: Advancement in programming efficiency previews today

[Adam Churvis]

> father / son?
> you two look like brothers...
> how old is the dad here?  david or adam? which is which?

You just made my day! :)

I'm father -- the one with the white shirt -- and I'm 43.

Respectfully,

Adam Phillip Churvis
Member of Team Macromedia
http://www.ProductivityEnhancement.com

Download Plum and other cool development tools, 
and get advanced intensive Master-level training:

* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000


~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

RE: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model

[Ben Rogers]

> I read that, and I know that issue, but I can't fathom myself where
> you'd take the extra height from if this rule wasn't there: the parent's
> parent, and if so, how much would you take, and what would the extra
> height be calculated relative to.

The easiest answer to that question is another question: where does the
space come from in HTML? As I understand it, the browser traverses up the
tree until it finds an element whose height it knows. As a result, it's more
complicated to render HTML than CSS. It's my understanding that this is the
reason why the spec doesn't allow for it: to keep rendering simple.

At a fundamental level, I think the folks who made the CSS spec made a bad
decision: I think you should make things easier on the people who use a
computer. The computer is there to serve the people after all. On a
practical level, the time it takes to render even a complex layout of nested
tables is trivial (well, it is in anything other than Netscape 4). Even if
this wasn't the case, Moore's law would have long since made it so.

> Went up to my retreat deep in the Ox Mountains and meditated on a
> solution. Then, just as it came to me in a flash of blinding light, I
> remembered somebody'd already solved this particular problem before:
> 
>  http://www.redmelon.net/tstme/3cols2/

That's a great example. That's far better than any I found (I must of looked
at 50 different examples before sending my last message). Nevertheless, it
still suffers from some of the issues we've been talking about.

Specifically, the widths of the left and right columns are specified in
several locations. They are specified as the border for the outer class
(similar to how margin was used in the example I posted). They are also
specified in negative margin values for the left and right columns
themselves.

The latter doesn't bother me so much because the left column already needs
to know its size. So, specifying the size as a width and negative margin
value isn't too bad. However, having to make other elements cognoscente of
the column's size is a more serious violation of the principle of
orthogonality. Nevertheless, it goes a long way towards mitigating those
issues.

There are also a few extra divs and classes in there (most notably the
separation between inner and outer). That's not a big deal since the tr's
and td's in the table example even that out. The style sheet code makes
their example at least 3 times as long as the one I posted (I actually
rewrote their example with as little code as possible before posting just so
I would better understand it), but it goes a long way towards separating
presentation from content.

All in all, that's a pretty good example. I still think CSS is screwy in
this regard, but at least there are workarounds.

Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: Searching for Spock

[Jim Davis]

If you're saying that you don't have documentation, remember that ALL
current MM documentation (with user comments) is available at
livedocs.macromedia.com.

Insanely useful.

Jim Davis

> -Original Message-
> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 22, 2004 7:25 AM
> To: CF-Talk
> Subject: Re: Searching for Spock
> 
> Thanks Mark, i'll give that a go, i'll look into the doco.
> 
> I can't believe i have just ordered CF6.1 for my work and soon Blackstone
> will be here (but i got them to get the 2 years upgrade option! - but that
> doesn't mean the documentation!)




~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: Advancement in programming efficiency previews today

[Tony Weeg]

father / son?

you two look like brothers...

how old is the dad here?  david or adam? which is which?

tw


On Wed, 22 Dec 2004 09:48:23 -0500, Dave Francis
<[EMAIL PROTECTED]> wrote:
> You can call it...
> 
>COBOL
> 
> 
> - Original Message -
> From: "Adam Churvis" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Tuesday, December 21, 2004 3:30 PM
> Subject: Advancement in programming efficiency previews today
> 
> > If you guys think Plum was cool, wait until you see what we've come up
> > with
> > *this* time.
> >
> > This will without a doubt be the single biggest boost to programming
> > efficiency in the history of computer technology:
> >
> > http://www.productivityenhancement.com/news.cfm?id=uxp
> >
> > Respectfully,
> >
> > Adam Phillip Churvis
> > Member of Team Macromedia
> > http://www.ProductivityEnhancement.com
> >
> > Download Plum and other cool development tools,
> > and get advanced intensive Master-level training:
> >
> > * C# & ASP.NET for ColdFusion Developers
> > * ColdFusion MX Master Class
> > * Advanced Development with CFMX and SQL Server 2000
> >
> >
> >
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Odd CF/network problem

[Ryan Emerle]

Have you checked that Jumbo Frames are disabled for the NIC?  This can
cause problems when an intermediate switch can handle the larger
frames, though you won't see a problem on an xover connection.

HTH
-Ryan


On Tue, 21 Dec 2004 15:24:18 -0500, Matthew Fusfield <[EMAIL PROTECTED]> wrote:
> I've just run into a rather strange network issue with CFMX and am
> hoping someone here might have an idea.
> 
> We are preparing to deploy an application on two web/CF servers and a
> separate MS SQL box. Each machine has two NICs. Until now, on the two
> CF servers, we've used one NIC to connect out to the network and the
> second NIC was connected via crossover cable to the other web server.
> (there is a decent amount of web services and other traffic between
> the two to warrant this)
> 
> This has worked well, until today when we installed a pretty basic
> network switch, replacing the crossover cable, to allow the database
> server to connect to this private network. Both CF servers can see and
> use the SQL box, and can ping each other. However, when I try to send
> HTTP traffic from web server 1 to web server 2, I get the HTTP headers
> and nothing else - it simply times out. Even stranger is that this
> only seems to apply to ColdFusion pages - if I request a static html
> file from one server, it transfers just fine. I replaced the switch
> with the crossover cable, and everything started working again.
> 
> I tried restarting services, reinstalling connectors, etc, etc to no
> avail. Anyone run into anything like this before?
> 
> Thanks,
> 
> Matt
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Advancement in programming efficiency previews today

[Dave Francis]

You can call it...

COBOL



- Original Message - 
From: "Adam Churvis" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, December 21, 2004 3:30 PM
Subject: Advancement in programming efficiency previews today


> If you guys think Plum was cool, wait until you see what we've come up 
> with
> *this* time.
>
> This will without a doubt be the single biggest boost to programming
> efficiency in the history of computer technology:
>
> http://www.productivityenhancement.com/news.cfm?id=uxp
>
> Respectfully,
>
> Adam Phillip Churvis
> Member of Team Macromedia
> http://www.ProductivityEnhancement.com
>
> Download Plum and other cool development tools,
> and get advanced intensive Master-level training:
>
> * C# & ASP.NET for ColdFusion Developers
> * ColdFusion MX Master Class
> * Advanced Development with CFMX and SQL Server 2000
>
>
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: Advancement in programming efficiency previews today

[Dan O'Keefe]

You guys might need a little individual time to yourselves.

Dan


On Tue, 21 Dec 2004 15:30:23 -0500, Adam Churvis
<[EMAIL PROTECTED]> wrote:
> If you guys think Plum was cool, wait until you see what we've come up with
> *this* time.
> 
> This will without a doubt be the single biggest boost to programming
> efficiency in the history of computer technology:
> 
> http://www.productivityenhancement.com/news.cfm?id=uxp
> 
> Respectfully,
> 
> Adam Phillip Churvis
> Member of Team Macromedia
> http://www.ProductivityEnhancement.com
> 
> Download Plum and other cool development tools,
> and get advanced intensive Master-level training:
> 
> * C# & ASP.NET for ColdFusion Developers
> * ColdFusion MX Master Class
> * Advanced Development with CFMX and SQL Server 2000
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Strange cfmail error

[Howie Hamlin]

It looks like the mail server that you are using is banning that domain.  I 
know for sure that some systems incorrectly reject mail from domains that begin 
with a number.  At any rate, you should check with the email administrator.  
They may just be able to add the IP address of your ColdFusion server to a 
whitelist.

HTH,

-- 
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
>>> Find out how iMS Stacks up to the competition: 
>>> http://www.coolfusion.com/imssecomparison.cfm


--- On Wednesday, December 22, 2004 9:01 AM, [EMAIL PROTECTED] scribed: ---
>
> Hello,
> 
> I just happened to look at my mail.log file in the CF Admin and there
> are a lot (5-6 every minute) of this error:
> 
> "Error","scheduler-1","12/22/04","05:23:35",,"550 Body From: of '@107'
> is banned "
> 
> Anyone seen this before, or have an idea of what it might be? Our
> domain 
> is 1079thelink.com, which is where the "@107" could come from, but why
> is it banned, who's banning it and why it it in the log so much?
> 
> Thanks,
> Jonathan
> _
> Jonathan Mauney
> Web Application Developer/Manager, Digital Media Properties
> News Talk 1110 WBT/107.9 the LINK/PersonalityAC(r) Radio Network
> Jefferson-Pilot Communications Co.
> One Julian Price Place
> Charlotte, North Carolina 28208
> 704.374.3862 voice
> 704.374.3543 fax
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Includes, paths, templates, directory path problems...and a philosophical Question

[Greg Stewart]

Or you could also simply use the base href tag () and then have all your images/style
sheets/javascript references do something like this:


And it will automatically resolves.

G


On Wed, 22 Dec 2004 05:38:44 -0800, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> Fusebox.
> 
> There's a lot of reasons to use Fusebox, but in this specific case,
> having everything go through a single index.cfm will solve your
> problem directly.  Mach-II has the same characteristic.  Your app is
> entirely behind that single template, so you never run into any
> relative pathing issues.  Very nice little side benefit to the way the
> framework is set up.
> 
> cheers,
> barneyb
> 
> On Tue, 21 Dec 2004 12:16:10 -0500, Jeff Small <[EMAIL PROTECTED]> wrote:
> > You've got a site. You've got content in the root. (index.cfm, let's say)
> > and you've got content in directories lower than the root (foo/content.cfm).
> > Let's say that you want "index.cfm" and "foo/content.cfm" to share the same
> > navigation as an include, naturally, because you only want to change one
> > copy of "include/navigation.cfm" and it will be updated in every page of the
> > site.
> >
> > But how do you resolve directory path problems?
> >
> > In "index.cfm", the navigation include (this code is in
> > "include/navigation.cfm" remember) refers to "images/image.jpg" which works
> > in the root index.cfm file...however, when you refer to this include in
> > "foo/content.cfm" it needs to instead refer to "../images/image.jpg". How to
> > resolve this? How do you work on this locally, with includes, and set it up
> > to mirror your development site, so all you need to do is push it over and
> > it's live and working? Our development server is just a smallish, in-house
> > box that we use like this, "testing.mydomain.com/client1/" and
> > "testing.mydomain.com/another_client/" and we're using relative paths in
> > development. It wasn't such a big problem until recently when we've just
> > sort of grown out of a mom and pop solution to development and have begun to
> > try and implement firmer coding methods and procedures. So we're stumbling
> > trying to figure out a solution besides "make a second copy of
> > navigation.cfm so that the paths work when it's one directory lower" etc...
> >
> > We're trying to figure out if Dreamweaver Templates can figure into the mix
> > somehow, giving us locked regions that can change depending on where you
> > save the file, then just edit the template to apply global changes to a
> > navigation, etc...but that doesn't *seem* to be working out very
> > well...Although one of the guys in the office just shouted that he thinks
> > "Nesting templates" might work...
> >
> > I just was wondering how you all are managing this kind of development thing
> > where you want to create includes and minimize coding, but have to make
> > paths in those includes work properly, no matter where they are in your
> > site...
> >
> > Does this make sense what I'm asking?
> >
> 
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/blog/
> 
> Got Gmail? I have 10 invites.
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Strange cfmail error

[jmauney]

Hello,
 
I just happened to look at my mail.log file in the CF Admin and there
are a lot (5-6 every minute) of this error:
 
"Error","scheduler-1","12/22/04","05:23:35",,"550 Body From: of '@107'
is banned "
 
Anyone seen this before, or have an idea of what it might be? Our domain
is 1079thelink.com, which is where the "@107" could come from, but why
is it banned, who's banning it and why it it in the log so much?
 
Thanks,
Jonathan
_
Jonathan Mauney
Web Application Developer/Manager, Digital Media Properties
News Talk 1110 WBT/107.9 the LINK/PersonalityAC(r) Radio Network
Jefferson-Pilot Communications Co.
One Julian Price Place
Charlotte, North Carolina 28208
704.374.3862 voice
704.374.3543 fax


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: ColdFusion built-in tags and permission-based security framework

[Ian Vaughan]

Thanks 

-Original Message-
From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2004 11:57
To: CF-Talk
Subject: Re: ColdFusion built-in tags and permission-based security
framework

Stephen Moretti (cfmaster) wrote:

>Ian Vaughan wrote:
>
>  
>
>>How could I display the correct menu options which are generated from
the correct cfquery based on the user logged in.
>>
>>So if the user logged in is from the personnel department the
following query populates the select boxes, but if the user logged in is
from the finance department then the finance query runs on the page to
populate the select box.
>>
>>Can anybody see any flaws with this approach ? Or how it can be
improved to make the solution more flexible?
>> 
>>
>>
>>
>Ian,
>
>Are you saying that you have a separate category table for each
department?
>
>>Yes, each department about 6 in total
>
Ok - you definately need to abstract the design of your database.  At
the minute, if you need to add a new department or remove a department
you have to get your hands dirty, create a new table or remove a table
from the database and make changes to the code to allow for this.

What you need to do is have one category table, one user/member of staff
table and a department table.  The departments table maintains the
complete list of departments along with a unique ID for each department.
The same is true for the users and categories tables.
You then need to relate these tables to one another, ie. have tables
that tell you which users belong in which department and which
departments have access to which categories. 

Take a look at the ER diagram I've run up for you here
http://snipurl.com/bilm  It fairly simplified, but hopefully it should
help to make sense of what I'm describing above.

With a database structure like this you can add and remove departments
extremely easily, add new users to departments and change the categories
available to any given department as well as allow multiple departments
access to one category.

How does this work?  Your user logs in, so you get a unique identifier
for them by querying the users table during the login process. 

SELECT UserID FROM Users
WHERE UserName='#form.loginname#' AND Password =
'#hash(form.loginpassword)#'

With that UserID you can identify the department(s) that that user is a
member of, by querying the link table between user and department.

SELECT Department.DepartmentID, Department.DepartmentName FROM
Department
INNER JOIN DeptMembers AS DM ON Department.DepartmentID =
DM.DepartmentID WHERE DM.UserID = #qryUser.UserID#

If you want to know what categories they can access you can get this
information by JOINing DepartmentMembers to Categories through
DepartmentCategories.

SELECT Categories.CategoryID, Categories.CategoryName FROM Categories
INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID =
DC.CategoryID
INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID =
DM.DeparmentID WHERE DM.UserID = #qryUser.UserID#

This doesn't take in to account handling your tree of categories, but as
you've more than likely got the code to manage this, it shouldn't be too
hard to integrate what is here with what you've got for the category
tree. 

BTW : You should have a look at John Celko's nested set model
(http://snipurl.com/JoeCelko_NestedSets - you will need to register on
the site, but its free and I've not had any spam from them)

Hope this helps

Regards

Stephen




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: Seeing double?

[Katz, Dov B (IT)]

Right. This much I know... The code switches on executionmode which is
why it makes a good single cfmodule call for start-end use.  It works
perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but when
the code was copied to the other (quad 2.4ghz, 2gb ram, 6,1,0,83762) it
looks strange.

I'm wondering if it has to do with race conditions, and compiling on 4
processors, etc...  The code has worked for 2 years flawlessly on the
previous server.

Thanks in advance for any further insight.

-dov

-Original Message-
From: Anthony Cooper [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 8:48 AM
To: CF-Talk
Subject: Re: Seeing double?

If you've closed the tag or used a /> at the end, it will get called
twice. You need to checkout the value of thisTag.executionMode, read
more here:

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec18.htm

On 22 Dec 2004, at 13:39, Katz, Dov B (IT) wrote:

> I have a dev machine (www.4simchas.com) which has quad 2.4 ghz 
> processors, running the latest 6.1 release
>
> I have an app (replica of my prod env) which is running there, and 
> most of my layout elements consist of custom tags ( args>content)
>
> What I'm finding is that the headers and footers respectively are 
> appearing twice... this seems to happen only with content being 
> brought into pages via CFMODULE.
>
> Any advice (check it out, it's very wierd).
>
> -Dov
> 
>
> NOTICE: If received in error, please destroy and notify sender.  
> Sender does not waive confidentiality or privilege, and use is 
> prohibited.
>
>
>
> 



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Setup datasource thru code?

[Jochem van Dieten]

Robertson-Ravo, Neil (RX) wrote:
> Yeah, there is a factory method you can use : 
> 
> http://www.petefreitag.com/item/152.cfm
> 
> I don't see how or why this isn't supported as isn't this what CF is using
> to create DSN's itself?

Because it provides way to much rope to hang yourself.

Jochem

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: Seeing double?

[Anthony Cooper]

If you've closed the tag or used a /> at the end, it will get called 
twice. You need to checkout the value of thisTag.executionMode, read 
more here:

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec18.htm

On 22 Dec 2004, at 13:39, Katz, Dov B (IT) wrote:

> I have a dev machine (www.4simchas.com) which has quad 2.4 ghz
> processors, running the latest 6.1 release
>
> I have an app (replica of my prod env) which is running there, and most
> of my layout elements consist of custom tags ( args>content)
>
> What I'm finding is that the headers and footers respectively are
> appearing twice... this seems to happen only with content being brought
> into pages via CFMODULE.
>
> Any advice (check it out, it's very wierd).
>
> -Dov
> 
>
> NOTICE: If received in error, please destroy and notify sender.  
> Sender does not waive confidentiality or privilege, and use is 
> prohibited.
>
>
>
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Seeing double?

[Katz, Dov B (IT)]

I have a dev machine (www.4simchas.com) which has quad 2.4 ghz
processors, running the latest 6.1 release
 
I have an app (replica of my prod env) which is running there, and most
of my layout elements consist of custom tags (content)
 
What I'm finding is that the headers and footers respectively are
appearing twice... this seems to happen only with content being brought
into pages via CFMODULE.
 
Any advice (check it out, it's very wierd).
 
-Dov 

 
NOTICE: If received in error, please destroy and notify sender.  Sender does 
not waive confidentiality or privilege, and use is prohibited. 
 


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Includes, paths, templates, directory path problems...and a philosophical Question

[Barney Boisvert]

Fusebox.

There's a lot of reasons to use Fusebox, but in this specific case,
having everything go through a single index.cfm will solve your
problem directly.  Mach-II has the same characteristic.  Your app is
entirely behind that single template, so you never run into any
relative pathing issues.  Very nice little side benefit to the way the
framework is set up.

cheers,
barneyb

On Tue, 21 Dec 2004 12:16:10 -0500, Jeff Small <[EMAIL PROTECTED]> wrote:
> You've got a site. You've got content in the root. (index.cfm, let's say)
> and you've got content in directories lower than the root (foo/content.cfm).
> Let's say that you want "index.cfm" and "foo/content.cfm" to share the same
> navigation as an include, naturally, because you only want to change one
> copy of "include/navigation.cfm" and it will be updated in every page of the
> site.
> 
> But how do you resolve directory path problems?
> 
> In "index.cfm", the navigation include (this code is in
> "include/navigation.cfm" remember) refers to "images/image.jpg" which works
> in the root index.cfm file...however, when you refer to this include in
> "foo/content.cfm" it needs to instead refer to "../images/image.jpg". How to
> resolve this? How do you work on this locally, with includes, and set it up
> to mirror your development site, so all you need to do is push it over and
> it's live and working? Our development server is just a smallish, in-house
> box that we use like this, "testing.mydomain.com/client1/" and
> "testing.mydomain.com/another_client/" and we're using relative paths in
> development. It wasn't such a big problem until recently when we've just
> sort of grown out of a mom and pop solution to development and have begun to
> try and implement firmer coding methods and procedures. So we're stumbling
> trying to figure out a solution besides "make a second copy of
> navigation.cfm so that the paths work when it's one directory lower" etc...
> 
> We're trying to figure out if Dreamweaver Templates can figure into the mix
> somehow, giving us locked regions that can change depending on where you
> save the file, then just edit the template to apply global changes to a
> navigation, etc...but that doesn't *seem* to be working out very
> well...Although one of the guys in the office just shouted that he thinks
> "Nesting templates" might work...
> 
> I just was wondering how you all are managing this kind of development thing
> where you want to create includes and minimize coding, but have to make
> paths in those includes work properly, no matter where they are in your
> site...
> 
> Does this make sense what I'm asking?
> 

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

Got Gmail? I have 10 invites.

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

Re: Verity 'caching' old docs

[Doug James]

Our indexing routine runs every night. It performs a purge first then performs 
the indexing the then 
the last thing is to optimize. It has been running this way for a couple of 
months now and seems to 
be effective.

Just my $0.02.

Doug James
Webmaster / IT Developer
MUSC - Hollings Cancer Center
http://hcc.musc.edu

Duncan I Loxton wrote:
> Hi all,
> 
> I have a verity collection of company policies that are divided up
> into folders.  IE -  is a folder and any policies that start with
> 0 would be placed into that folder - 1000 folder would contain any
> policies that began with 1 etc  My problem is - I delete a policy
> from lets say folder 4000 then re-index this Policy folder - which
> contains all the subfolders of , 1000 etc  (I have
> subdirectories selected).  I go to our web site and do a search for
> the specific policy number - 4526.1E1 and no files are found.  GREAT -
> well then I try doing a search for 4526.1 and poof its still there and
> showing up as page can't be displayed.  (That would be because its not
> there.)
> 
> What am I doing wrong in my indexing?  I though maybe it was just
> cached - but I cleared that and even checked on a couple other systems
> - same thing.
> 
> Thanks
> 
> Duncan
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

RE: regex question

[Pascal Peters]

It all depends what you want to do with the XXX. If you want to use it
as is, you can use backreferencing:

REReplaceNoCase(CONTENT,"",'\1',"ALL")

Where \1 will match XXX. 

If you need to transform it, you will need a loop:


start = 1;
while(true){
  stTmp = REFindNoCase("",content,start,true);
  if(stTmp.pos[1] IS 0) break;
  value = Mid(content,stTmp.pos[2],stTmp.len[2]);
  content = RemoveChars(content,stTmp.pos[1],stTmp.len[1]);
  newvalue = getSnippet(value);
  content = Insert(newvalue,content,stTmp.pos[1] - 1);
  start = stTmp.pos[1] + Len(newvalue);
}


I just wrote this code without testing, so it may need some tweaking.

Pascal

> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: 22 December 2004 13:52
> To: CF-Talk
> Subject: regex question
> 
> (I posted this once, and it didn't bounce but I didn't see it come
> through to the list...)
> 
> Question about regex (this never happens here, does it!)
> 
> I want to match 
> 
> where XXX could be any length of characters (but most likely a uuid)
> 
> And I want to know the matched string when I'm done...
> 
> Ie, some variable set to "XXX", whatever XXX is.
> 
> How do it do that?
> 
> Ultimately, I'd like to pass the matched result to a function and do a
> replace... ie, something like this:
> 
> REReplaceNoCase(CONTENT,"",getSnippet(XXX),"ALL")
> 
>   - rIck
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: Temporary Cache

[Katz, Dov B (IT)]

Here's a quick and dirty way to do this, and it should work without too
much extra coding in CF, and relies on java garbage collection.

Lets' say you have an instance of your object called SINGLEOBJ.

Assuming originally you probably have 

Then throughout your code you use various invocations of
application.SINGLEOBJ's methods.

Now we want to kill it off when no sessions are needing it.

Here's what I'd do... (this is untested, uncompiled pseudocode to
describe the idea). Make a java.lang.ref.WeakRerence and store that in
global application scope, so it "Doesn't count" as something keeping the
cfc around.  Use Strong references in sessions, since they get cleaned
up eventually.

1) instead of Application.SINGLEOBJ being the CFC do this kind of thing:











2) For each session needing this object, at login time, or session
creation time, retreive it and store a (Strong) Reference in the
session.



Now you have a copy of this in each session.  When there are sessions,
the CFC will stick around, since the garbage collector sees references
to it.  When the sessions get cleaned up, the only reference to the CFC
is a java WeakReference, which isn't cause for keeping it around, so the
garbage collector can mark it, queue it, and clean it up automatically.
You know when this happens when the weakreference (a variable you store
in the application) Returns null for get()...


Make sense?
-dov



If the idea works correctly (attack it if you disagree) your CFC will
get disposed of during regular natural garbage collection


-Original Message-
From: Chris Jensen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 21, 2004 8:40 PM
To: CF-Talk
Subject: Temporary Cache

Hi,
I need to cache a singleton type of component in the application scope
so that multiple sessions can make use of it. However the component
would be used rarely, and may take up significant resources, so I'd like
to remove it whenever it's not in use (ie when the last session thats
using it is destroyed).

ie, The seuqence of events would be something like this:

Two users come along, the user1 does something that uses my singleton
component, so I create it, and cache it in application scope.
User2 also starts using it while user1 is also using it.

User1 closes their browser, but user2 continues using the compionent for
a while.

Then user2 closes their browser, so noone is now using the component, so
remove it from the application scope.


I could write some Java classes to do this, but I'm guessing someone 
else has needed this before, so has it been written already?

Chris

-- 




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model

[Roger B.]

 > I
 > remembered somebody'd already solved this particular problem before:
 >
 >  http://www.redmelon.net/tstme/3cols2/ 


Keith: That example conveniently sums up why I'm abandoning CSS
positioning after a couple years of work in that area. CSS-P is so
incredibly fragile that any unpredictable event can mangle it and
render the page unusable.

For example, I dropped a large photo into that layout, and instead of
stretching the center column to accommodate it, Firefox let the image
overlap the right column. IE fared even worse, effectively blowing up
in my face... the content in the left and right columns jumped into
the center column and joined the flow.

But it gets worse. Just as a goof, I removed the image, leaving an
empty  element to the center column. Firefox didn't even blink,
but IE suddenly allowed the left column's content to leap into the
center column and actually overlap it. A single empty paragraph was
all it took to break the layout.

If you're designing for controlled content, CSS-P can be effective.
But if you're designing for content generated by mere mortals, it's a
disaster waiting to happen in every browser I've ever seen.

--
Roger Benningfield
work: http://journurl.com/
blog: http://admin.support.journurl.com/ 




~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

regex question

[Rick Root]

(I posted this once, and it didn't bounce but I didn't see it come 
through to the list...)

Question about regex (this never happens here, does it!)

I want to match 

where XXX could be any length of characters (but most likely a uuid)

And I want to know the matched string when I'm done...

Ie, some variable set to "XXX", whatever XXX is.

How do it do that?

Ultimately, I'd like to pass the matched result to a function and do a 
replace... ie, something like this:

REReplaceNoCase(CONTENT,"",getSnippet(XXX),"ALL")

  - rIck





~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

test pls ignore

[Rick Root]

Sorry, I seem to be having trouble sending mail to the list 
pleaseignore this (you probably won't get it!)

  - rick

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Searching for Spock

[Mark Drew]

I am sure you can upgrade for a nominal fee when it comes out.. not
sure at the moment..



On Wed, 22 Dec 2004 07:24:55 -0500, Stuart Kidd <[EMAIL PROTECTED]> wrote:
> Thanks Mark, i'll give that a go, i'll look into the doco.
> 
> I can't believe i have just ordered CF6.1 for my work and soon Blackstone 
> will be here (but i got them to get the 2 years upgrade option! - but that 
> doesn't mean the documentation!)
> 
> Saturday
> 
> 
> -- Original Message --
> From: Mark Drew <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date:  Wed, 22 Dec 2004 13:21:34 +0100
> 
> >You can use verity to search data bases quite easily by passing a
> >query to it and indexing that (with the ID as they key)
> >
> >Check the documentation.
> >
> >MD
> >
> >
> >On Wed, 22 Dec 2004 06:43:05 -0500, Stuart Kidd <[EMAIL PROTECTED]> wrote:
> >> Hi,
> >>
> >> I'm just about to embark on adding a search facility to my website.  I 
> >> have about 40 articles which are stored in a database with fields for the 
> >> content (articleMain), metaDescription (which i use to pull for 
> >> dynamically filling out my metaDescription in HTML and metaKeywords (also 
> >> dynamic for HTML). All these records are growing daily with more additions.
> >>
> >> I have my site hosted with HostMySite and they say i can use Verity 
> >> searches.
> >>
> >> HOWEVER, is Verity just for searching for documents (pdf, word etc)?
> >>
> >> I would like to return to the user something like Google results, should i 
> >> use just a simple SQL search? I am thinking that might be a bit heavy to 
> >> keep on doing.
> >>
> >> Any help would be appreciated.
> >>
> >> Thanks,
> >>
> >> Saturday
> >>
> >>
> >
> >
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Searching for Spock

[Stuart Kidd]

Thanks Mark, i'll give that a go, i'll look into the doco.

I can't believe i have just ordered CF6.1 for my work and soon Blackstone will 
be here (but i got them to get the 2 years upgrade option! - but that doesn't 
mean the documentation!)

Saturday


-- Original Message --
From: Mark Drew <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Wed, 22 Dec 2004 13:21:34 +0100

>You can use verity to search data bases quite easily by passing a
>query to it and indexing that (with the ID as they key)
>
>Check the documentation.
>
>MD
>
>
>On Wed, 22 Dec 2004 06:43:05 -0500, Stuart Kidd <[EMAIL PROTECTED]> wrote:
>> Hi,
>> 
>> I'm just about to embark on adding a search facility to my website.  I have 
>> about 40 articles which are stored in a database with fields for the content 
>> (articleMain), metaDescription (which i use to pull for dynamically filling 
>> out my metaDescription in HTML and metaKeywords (also dynamic for HTML). All 
>> these records are growing daily with more additions.
>> 
>> I have my site hosted with HostMySite and they say i can use Verity searches.
>> 
>> HOWEVER, is Verity just for searching for documents (pdf, word etc)?
>> 
>> I would like to return to the user something like Google results, should i 
>> use just a simple SQL search? I am thinking that might be a bit heavy to 
>> keep on doing.
>> 
>> Any help would be appreciated.
>> 
>> Thanks,
>> 
>> Saturday
>> 
>> 
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Re: Searching for Spock

[Mark Drew]

You can use verity to search data bases quite easily by passing a
query to it and indexing that (with the ID as they key)

Check the documentation.

MD


On Wed, 22 Dec 2004 06:43:05 -0500, Stuart Kidd <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I'm just about to embark on adding a search facility to my website.  I have 
> about 40 articles which are stored in a database with fields for the content 
> (articleMain), metaDescription (which i use to pull for dynamically filling 
> out my metaDescription in HTML and metaKeywords (also dynamic for HTML). All 
> these records are growing daily with more additions.
> 
> I have my site hosted with HostMySite and they say i can use Verity searches.
> 
> HOWEVER, is Verity just for searching for documents (pdf, word etc)?
> 
> I would like to return to the user something like Google results, should i 
> use just a simple SQL search? I am thinking that might be a bit heavy to keep 
> on doing.
> 
> Any help would be appreciated.
> 
> Thanks,
> 
> Saturday
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: ColdFusion built-in tags and permission-based security framework

[Stephen Moretti (cfmaster)]

Stephen Moretti (cfmaster) wrote:

>Ian Vaughan wrote:
>
>  
>
>>How could I display the correct menu options which are generated from the 
>>correct cfquery based on the user logged in.
>>
>>So if the user logged in is from the personnel department the following query 
>>populates the select boxes, but if the user logged in is from the finance 
>>department then the finance query runs on the page to populate the select box.
>>
>>Can anybody see any flaws with this approach ? Or how it can be improved to 
>>make the solution more flexible?
>> 
>>
>>
>>
>Ian,
>
>Are you saying that you have a separate category table for each department?
>
>>Yes, each department about 6 in total 
>
Ok - you definately need to abstract the design of your database.  At 
the minute, if you need to add a new department or remove a department 
you have to get your hands dirty, create a new table or remove a table 
from the database and make changes to the code to allow for this.

What you need to do is have one category table, one user/member of staff 
table and a department table.  The departments table maintains the 
complete list of departments along with a unique ID for each 
department.  The same is true for the users and categories tables.
You then need to relate these tables to one another, ie. have tables 
that tell you which users belong in which department and which 
departments have access to which categories. 

Take a look at the ER diagram I've run up for you here 
http://snipurl.com/bilm  It fairly simplified, but hopefully it should 
help to make sense of what I'm describing above.

With a database structure like this you can add and remove departments 
extremely easily, add new users to departments and change the categories 
available to any given department as well as allow multiple departments 
access to one category.

How does this work?  Your user logs in, so you get a unique identifier 
for them by querying the users table during the login process. 

SELECT UserID FROM Users
WHERE UserName='#form.loginname#' AND Password = 
'#hash(form.loginpassword)#'

With that UserID you can identify the department(s) that that user is a 
member of, by querying the link table between user and department.

SELECT Department.DepartmentID, Department.DepartmentName
FROM Department
INNER JOIN DeptMembers AS DM ON Department.DepartmentID = 
DM.DepartmentID
WHERE DM.UserID = #qryUser.UserID#

If you want to know what categories they can access you can get this 
information by JOINing DepartmentMembers to Categories through 
DepartmentCategories.

SELECT Categories.CategoryID, Categories.CategoryName
FROM Categories
INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID = 
DC.CategoryID
INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID = 
DM.DeparmentID
WHERE DM.UserID = #qryUser.UserID#

This doesn't take in to account handling your tree of categories, but as 
you've more than likely got the code to manage this, it shouldn't be too 
hard to integrate what is here with what you've got for the category tree. 

BTW : You should have a look at John Celko's nested set model 
(http://snipurl.com/JoeCelko_NestedSets - you will need to register on 
the site, but its free and I've not had any spam from them)

Hope this helps

Regards

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: breaking a line of code to two lines

[daniel kessler]

>>> Well, you could break on commas, and always trim().
>> I  do break on commas.  I didn't trim though.  I thought that was
>> just for spaces.  There none.  I'll try it.
>
>Ah, it must have been the wrap monster, then.  Trim() removes all 
>whitespace from the beginning and end of the string.

That's it; it's working now.  It seems odd to trim something that's not user 
entered, but here I am.

>If you are turning the list into an array, then using listappend() and 
>appending each line to the list will require as many lines of code as 
>the array declaration.

I thought listAppend() would take another list of several entries and then I 
could do 5 appends for 5 lines each line with several entries, but it doesn't 
appear to work that  way.

thanks for the help.

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

Searching for Spock

[Stuart Kidd]

Hi,

I'm just about to embark on adding a search facility to my website.  I have 
about 40 articles which are stored in a database with fields for the content 
(articleMain), metaDescription (which i use to pull for dynamically filling out 
my metaDescription in HTML and metaKeywords (also dynamic for HTML). All these 
records are growing daily with more additions.

I have my site hosted with HostMySite and they say i can use Verity searches.

HOWEVER, is Verity just for searching for documents (pdf, word etc)?

I would like to return to the user something like Google results, should i use 
just a simple SQL search? I am thinking that might be a bit heavy to keep on 
doing.

Any help would be appreciated.

Thanks,

Saturday 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

RE: ColdFusion built-in tags and permission-based security framework

[Ian Vaughan]

Yes, each department about 6 in total 

-Original Message-
From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2004 10:25
To: CF-Talk
Subject: Re: ColdFusion built-in tags and permission-based security
framework

Ian Vaughan wrote:

>How could I display the correct menu options which are generated from
the correct cfquery based on the user logged in.
>
>So if the user logged in is from the personnel department the following
query populates the select boxes, but if the user logged in is from the
finance department then the finance query runs on the page to populate
the select box.
>
>Can anybody see any flaws with this approach ? Or how it can be
improved to make the solution more flexible?
>  
>
Ian,

Are you saying that you have a separate category table for each
department?

Stephen





~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

Re: ColdFusion built-in tags and permission-based security framework

[Stephen Moretti (cfmaster)]

Ian Vaughan wrote:

>How could I display the correct menu options which are generated from the 
>correct cfquery based on the user logged in.
>
>So if the user logged in is from the personnel department the following query 
>populates the select boxes, but if the user logged in is from the finance 
>department then the finance query runs on the page to populate the select box.
>
>Can anybody see any flaws with this approach ? Or how it can be improved to 
>make the solution more flexible?
>  
>
Ian,

Are you saying that you have a separate category table for each department?

Stephen



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Re: Includes, paths, templates, directory path problems...and a philosophical Question

[Massimo Foti]

> I just was wondering how you all are managing this kind of development
thing
> where you want to create includes and minimize coding, but have to make
> paths in those includes work properly, no matter where they are in your
> site...

I wrote a UDF for similar tasks:
http://www.cflib.org/udf.cfm?ID=841

Then I put this in Application.cfm:





Hope it will help


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

RE: CFStoredProc bug?

[Robertson-Ravo, Neil (RX)]

>I've seen some strange behavior with , and our DBA has 
>requested that we don't use it. If you trace your database (tested on 
>sql2k), you will see cfstoredproc creates and compiles a procedure,

Hmm, I find this hard to swallow and I would question your 'DBA' without
seeing the facts.  We run daily extensive tests on speed etc and we have
found that SP's are as fast if not faster than CFQUERY in most cases.  We
use SP's not necessarily for the speed increase - mainly for abstraction,
security and the way we can pass back multiple SQL blocks and we can allow
the SQL Server to perform data manipulation over using CF/Inline SQL - which
is not as efficient.  For a simple SELECT name from TABLE, I think  you are
probably going to see no different and indeed a CFQUERY may even be faster
(head on block).

Based on the comments - I ran a quick test with an SP which basically ran
the following (where iLanguageID and iEventID were @ variables passed in via
dbvarname):


Inline Call:
SELECT  tblExAdminTextContent.vcContentName,
tblExAdminTextContentAlias.tContent 
FROM tblExAdminTextContentAlias
INNER JOIN tblExAdminTextContent
ON tblExAdminTextContentAlias.iContentID =
tblExAdminTextContent.iContentID
WHERE iEventID = 100306 
AND iLanguageID = 1
AND iLinkID IS NULL

Stored Procedure:
risp_ExAdminSiteLanguageDefaults 100306,1

The results were the duration were as following:

Inline SQL:
CPU: 16
Reads: 500 (fluctuates between 422-500)
Writes: 0
Duration: 13ms

Stored Procedure:
CPU: 0
Reads: 422 (fluctuates between 422-500)
Writes: 0
Duration: 0ms

Now, this is by no means a solid call as it can fluctuate between them both
taking 0 duration but never the SP taking any more than that and shows its
more efficient.

Obviously this is a test on a fairly simple proc but there is no way your
DBA can say that it's a performance killer and to be honest with you if he
is an MSCDBA then it's a shocking call to make.

Client vars do perform updates internally using SP's for EVERY CALL if you
do not switch that method off via the Client Vars section - maybe this is
what your DBA was seeing?  This does indeed cause 3 SP's to run for every
.CFM thread; turn the updates off if you don't need last visit and hit count
updated constantly.

HTH


Neil

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

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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

RE: CFStoredProc bug?

[Robertson-Ravo, Neil (RX)]

Hmm, I find this hard to swallow and I would question your 'DBA' without
seeing the facts.  We run daily extensive tests on speed etc and we have
found that SP's are as fast if not faster than CFQUERY in most cases.  We
use SP's not necessarily for the speed increase - mainly for abstraction,
security and the way we can pass back multiple SQL blocks and we can allow
the SQL Server to perform data manipulation over using CF/Inline SQL - which
is not as efficient.  For a simple SELECT name from TABLE, I think  you are
probably going to see no different and indeed a CFQUERY may even be faster
(head on block).

Based on the comments - I ran a quick test with an SP which basically ran
the following (where iLanguageID and iEventID were @ variables passed in via
dbvarname):


Inline Call:
SELECT  tblExAdminTextContent.vcContentName,
tblExAdminTextContentAlias.tContent 
FROM tblExAdminTextContentAlias
INNER JOIN tblExAdminTextContent
ON tblExAdminTextContentAlias.iContentID =
tblExAdminTextContent.iContentID
WHERE iEventID = 100306 
AND iLanguageID = 1
AND iLinkID IS NULL

Stored Procedure:
risp_ExAdminSiteLanguageDefaults 100306,1

The results were the duration were as following:

Inline SQL:
CPU: 16
Reads: 500 (fluctuates between 422-500)
Writes: 0
Duration: 13ms

Stored Procedure:
CPU: 0
Reads: 422 (fluctuates between 422-500)
Writes: 0
Duration: 0ms

Now, this is by no means a solid call as it can fluctuate between them both
taking 0 duration but never the SP taking any more than that and shows its
more efficient.

Obviously this is a test on a fairly simple proc but there is no way your
DBA can say that it's a performance killer and to be honest with you if he
is an MSCDBA then it's a shocking call to make.

Client vars do perform updates internally using SP's for EVERY CALL if you
do not switch that method off via the Client Vars section - maybe this is
what your DBA was seeing?  This does indeed cause 3 SP's to run for every
.CFM thread; turn the updates off if you don't need last visit and hit count
updated constantly.

HTH


Neil







-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED] 
Sent: 21 December 2004 20:32
To: CF-Talk
Subject: Re: CFStoredProc bug?

Michael Dinowitz wrote:
> Thank you for pointing that out. It looks like I missed that. So
basically,
> the order of cfprocparams being passed is all that matters and no
parameter
> can be missed when writing cfprocparam tags. 
> 
> Is there any performance (i.e. binding) savings to using the CFSTOREDPROC
> tag vs. a CFQUERY with CFQUERYPARAMs? Is the CFSTOREDPROC call as
efficient?
> Better? What's the advantage? Anyone from MM want to comment?
> Thanks
> 

I've seen some strange behavior with , and our DBA has 
requested that we don't use it. If you trace your database (tested on 
sql2k), you will see cfstoredproc creates and compiles a procedure, 
calls that procedure a number of times (depending on how many recordsets 
you are expecting), then destroys the temp proc. For this reason, you 
will have degraded performance on  than you will calling a 
stored procedure from a  block.

We've seen the same behavior with client variables, so we don't use them.

It's also my understanding that  with  values can 
be as fast as stored procedures. The benefit, of course, comes when the 
SQL statements you are running are large enough to effect bandwidth 
between the web and database servers. You'll get some delay when you 
have to write 200 lines of SQL to your DB, vs 3 or 4 using a stored 
procedure.


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




~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

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

RE: Setup datasource thru code?

[Robertson-Ravo, Neil (RX)]

Yeah, there is a factory method you can use : 

http://www.petefreitag.com/item/152.cfm

I don't see how or why this isn't supported as isn't this what CF is using
to create DSN's itself?





-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED] 
Sent: 21 December 2004 23:32
To: CF-Talk
Subject: Re: Setup datasource thru code?

On Tue, 21 Dec 2004 15:59:08 -0600, Donna French <[EMAIL PROTECTED]> wrote:
> Is there a way to setup a datasource thru code instead of using the CF
Admin?

Not in any supported way on CFMX (there is an unsupported way).

Ben Forta has talked about a CF Admin API in Blackstone so maybe you
should join the beta...
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 4 invites to give away!

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



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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