Re: OT legal stuff

[Toby Tremayne]

Best thing you can do is store the data and time of the acceptance,  
plus a full copy of the terms they agreed to.  If the T&Cs on the site  
change at any point you need to know which ones people agreed to, and  
whether they need to be asked to agree to new ones.  This can be more  
or less important depending on the nature of the site but it's worth  
doing just in case.

Toby
On 12/06/2009, at 12:47 AM, Chad Gray wrote:

>
> Does anyone know how it is best legally to record that a user  
> clicked the check box "I agree to the terms and privacy policy of  
> this web site"?
>
> Is it sufficient to just mark a field in a database and record the  
> date time?  Or is there a more official way of recording that they  
> agreed to the terms?
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323395
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Railo 3.1 Open Source beta released

[Toby Tremayne]

Railo is a completely independent engine that can compile and execute  
cfml code.  Not everything is 100% exactly the same as in Adobe CF and  
there are extra features in Railo also, but essentially you can just  
write your apps using your CF skills and use Railo to run them.   
Nobody pays for anything as there is no use of the Adobe proprietary  
runtime.

Toby
On 01/04/2009, at 11:27 AM, Claude Schneegans wrote:

>
> In simple terms: can I install Railo on a server and use it to run CF
> apps for customers
> who will pay for it?
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Railo 3.1 Open Source beta released

[Toby Tremayne]

Sorry Barney you're absolutely right - there still are licenses, just  
no license fees.

Toby
On 01/04/2009, at 10:44 AM, Barney Boisvert wrote:

>
> Before we get WAY out of hand, reading and actually understanding the
> licenses in question would be a good thing to do.  Both the GPL and
> LGPL are "activated" by distribution.  What distribution means is a
> grey area, and I have no comment on that particular aspect.  But if
> you don't distribute (again subject to the grey definition), the viral
> nature of the licenses is irrelevant.
>
> Tony - there are definitely license involved.   You just don't have to
> pay money to Railo (or JBoss, or whomever) in order to get one.
> You're still subject to the terms of the license regardless of any
> money that changes hands.  That license (the LGPL) places restrictions
> on what you can and cannot do with the software.  It's not a orgy of
> freedom for everyone, it's just that there isn't a monetary component
> to the license agreements.
>
> cheers,
> barneyb
>
> On Tue, Mar 31, 2009 at 4:34 PM, Toby Tremayne  
>  wrote:
>>
>>  From here on railo is completely open source - it's free to download
>> and use for commercial or non commercial purposes.  There are no
>> licenses involved - you can even use railo to deploy your application
>> as a wrapped java app including the railo engine for single file
>> deployment, all without paying for anything :)
>>
>> Toby
>> On 01/04/2009, at 9:52 AM, Claude Schneegans wrote:
>>
>>>
>>> I think it wasn't free before.
>>>
>>> Can the free version be used commercially ?
>>> Or is the soft free, but you have to buy licenses? ;-)
>>>
>>>
>>
>>
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321147
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Railo 3.1 Open Source beta released

[Toby Tremayne]

 From here on railo is completely open source - it's free to download  
and use for commercial or non commercial purposes.  There are no  
licenses involved - you can even use railo to deploy your application  
as a wrapped java app including the railo engine for single file  
deployment, all without paying for anything :)

Toby
On 01/04/2009, at 9:52 AM, Claude Schneegans wrote:

>
> I think it wasn't free before.
>
> Can the free version be used commercially ?
> Or is the soft free, but you have to buy licenses? ;-)
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321144
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: How do you guys deploy databases to shared servers?

[Toby Tremayne]

I'll second that on  navicat - worth the very small fee for the pro  
version even.  The ability to just select a source and destination db  
and copy al structure and or data automatically is wonderful.  Doesn't  
matter whether the source or destination are local or remote or both.

Toby
On 05/01/2009, at 2:15 PM, Will Tomlinson wrote:

>> I'm heartily sick of the tedious way I have to spend half a day or
>> more EACH WEEK uploading and downloading databases from my
>> SQLServer2005 web sites.
>
>
> Not that it helps you any, but this is exactly the reason I've moved  
> most of my websites to MySQL. Navicat makes this kinda thing  
> completely brainless for me.
>
> Will
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317371
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: How do you guys deploy databases to shared servers?

[Toby Tremayne]

actually that may be a problem - sql litespeed works via a number of  
stored procedures you install, but I'm afraid I can't remember the  
permission requirements either for install or use.  There's a free  
demo though, so you can give it a try.

Toby
On 05/01/2009, at 11:48 AM, Mike Kear wrote:

> Thanks Toby.Does it allow you to back up and restore if you dont
> have administrator priveleges?   That's the problem with shared
> hosting - Microsoft dont seem to have made any provision for database
> owners to do any of these tasks,  only server administrators.
> Obviously, on a shared system where you might have hundreds of people
> creating and managing databases, you cant allow them all to have admin
> rights.A web site owner usually only has dbo rights.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On Mon, Jan 5, 2009 at 11:39 AM, Toby Tremayne  
>  wrote:
>> check out sql litespeed for very quick and powerful backup and
>> restore.  Can be a handy way to move them about - although I must
>> admit I'm out of date now as I tend to stick to postgresql and mysql
>> which have very simple porting methods.
>>
>> Toby
>>
> --
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317366
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: How do you guys deploy databases to shared servers?

[Toby Tremayne]

check out sql litespeed for very quick and powerful backup and  
restore.  Can be a handy way to move them about - although I must  
admit I'm out of date now as I tend to stick to postgresql and mysql  
which have very simple porting methods.

Toby

On 05/01/2009, at 11:30 AM, Mike Kear wrote:

> I'm heartily sick of the tedious way I have to spend half a day or
> more EACH WEEK uploading and downloading databases from my
> SQLServer2005 web sites.
> I'm going to have another go at learning the best way to do this . .
>
> Can someone please give me some help...IN the old days I used to  
> have a
> DTS task running overnight automatically, copying databases to and
> from my dev environment to the production web sites.
>
> Since SQLServer2005 there has been no way that I can find,  to create
> a DTS task and reuse it  EACH TIME I have to create it, and regardless
> of whether I save the DTS task or not,  it's not available next time
> for me to reuse.
> I have ot create it all over again.Needless to say it's really  
> PISSING
> ME OFF!
>
> Can someone please tell me how I can create a method of copying entire
> databases which might have 40tables or more with the indexes, and key
> relationships etc from remote servers to my local database server,  or
> conversely from my dev environment to my production server.
>
> And also how I can do this in a way that the task is repeatable
> without having to be created every time.
>
> I've tried using Visual Studio 2005 but that has finally defeated me.
> I can never find what I want to use,  and the MS Help files are total
> gobbldegook
> to me.   I cant make head nor tail of it.  After 3 years of  
> wrestling with
> Visual Studio I have had to give up.  There's no way to save any  
> file from
> that and reuse it.   Not that I've found anyway.The best I've ever
> managed to do is create a solution,  and run debug every time.   And  
> that
> takes 30 minutes to an hour to run a simple job of copying 3 tables,
> and ties up my machine completely for the duration.
>
> I'm sure my problem is that I'm trying to use the wrong tools,  or
> that I just don't know how to use the tools correctly,  but I'm
> despairing of ever getting back to the neat and tidy way I had to do
> this in the old SQLServer2000 days.
>
> Incidentally, just as an additional comment to my plea ...
>
> I cant use the copy database wizard, because it's a shared server and
> I don't have admin rights.So I cant create a database on the
> remote server using SQLServer management studio.
>
> For the same reason I cant create a backup and then restore it on the
> other server..
>
> For the same reason I cant use replication in any way.
>
> For the same reason, detaching, FTP then attach to the other server is
> out as well.
>
>
> I think Microsoft forgot entirely about the thousands of people using
> shared hosting servers when they developed SQLServer2005.   And I'm
> told there's no provision for it in the new 2008 version either.
> 
>
> So what do the rest of you people on shared hosts do??
> -- 
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Use Wordpress or BlogCFC?

[Toby Tremayne]

you'd be a bolshevik :)

On 09/12/2008, at 3:19 AM, Wil Genovese wrote:

> I use BlogCFC to host my own blogs on my servers.  If you have a CF  
> Host
> already and you have the space and DB connections there is nothing  
> wrong
> doing your own.
>
> And there are other Coldfusion based blogs available.
> http://www.riaforge.com will have most of them.  I hear Mango Blog  
> is pretty
> good as well.
>
> If you do not want the hassle of managing ANY of the server side or  
> code
> then just use any of the numerous free blogging services.
>
>
>
> BTW: So what am I?  Since I do use BlogCFC, but on Bluedragon JX  
> 64bit and
> with PostgreSQL 8.x all running on Centos5.x 64bit?
>
> Cheers,
> Wil Genovese
> Sr. Web Application Developer
>
>
>
>
> On Mon, Dec 8, 2008 at 9:59 AM, Paul Kukiel <[EMAIL PROTECTED]> wrote:
>
>> If you don't want to self host there is Instantspot it's Coldfusion
>> powered.
>>
>> www.instantspot.com
>>
>> Paul.
>>
>>
>>
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316454
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: email encryption

[Toby Tremayne]

If you're dead set on encryption, I have some code that will handle  
gpg encryption via a java wrapper in coldfusion, however I'd refer you  
to previous comments about the necessities of shared keys etc etc.

All in all I think you'd be better off just adding some logic to your  
application forcing a reset of the password when the user first logs  
in.  IE when a password is generated, put a flag against the user  
record and have your code force them to change their password before  
they can proceed.  This way emailing them a cleartext password doesn't  
make any difference because they're then changing it immediately (and  
you can use a one way encryption to store the password in the db.   
Look on cflib for the MD5 function or check out cf8's encryption  
routines).

Toby

On 02/03/2008, at 11:55 PM, Richard White wrote:

> hi
>
> thanks for your replies. your right it sounds like encryption is too  
> much work. it seems like this is a bit of a tricky spot for many  
> developers.
>
> there has also been some neat solutions on here although i am  
> thinking that if someone was to hack into the mail server, or  
> falsely receieve the email meant for someone else. they could easily  
> log on (as in our system the username is their email)so they would  
> have somone's username and password, can log on and cause alot of  
> havoc in the system.
>
> it is not so much ourselves that need not see the password as they  
> can change their password as soon as they logon. it is more of the  
> third party problems we are thinking about. so even the ssl or the  
> timer solutions will still allow someone to get in if they get hold  
> of the email.
>
> hmmm, this needs some creative thinking i think!!!
>
> does anyone have a similar situation to this and if so how do you  
> have yours setup?
>
> thanks for all your help and advice
>
> 

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

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

SOT: Andrew Price

[Toby Tremayne]

Hi all - does anyone know a cf / flex developer by the name of Andrew  
Price?  He submitted an app to the flex developers derby but the link  
goes to a site that's not around any more, and I was hoping to get in  
touch with him to ask him about it.  If Andrew or anyone who knows  
him is on this list could you drop me a line please?

cheers,
Toby

---

Life is poetry, write it in your own words

---

Toby Tremayne
Director
Code Poet and Zen Master of the Heavy Sleep
Lyricist Software
0416 048 090
ICQ: 13107913




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

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

Re: Is Parallel Processing Possible With CF?

[Toby Tremayne]

launch your sites using a programmatic call to cfschedule writing for
a once only task using action="" will make all of the
tasks run in seperate threads and at the same time...

Toby

Wednesday, March 24, 2004, 10:44:18 AM, you wrote:

NB> We are synchronizing DB's for multiple Web sites by having a master site 
NB> query satellite sites. Then distributing data back out to the satellite 
NB> sites. The fact that we cycle through the satellite sites one at a time in 
NB> series limits how often we can synchronize. Because of Internet delays this 
NB> can often string out as much as 15 minutes. We would like to reduce the 
NB> inherent cycle time by launching communications with each satellite in 
NB> parallel. Is there a technique for doing this in a parallel fashion using CF?

NB> Thanks,

NB> Nick

NB>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Add spaces to a text string

[Toby Tremayne]

Hi Les,

   you can use listChangeDelims(myList,",",", ")

cheers,
Toby

Monday, March 22, 2004, 3:38:08 PM, you wrote:

LI> How can I add a space after every comma in a list?  

 
LI> I'd like to change this: "Dog,Cat,Horse,Cow" 
LI> to this: "Dog, Cat, Horse, Cow"

 
LI> Thanks in advance for your help.

LI>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Easy String Question?

[Toby Tremayne]

Hi Eric,

   try listFirst(myString,"_")

Wednesday, February 25, 2004, 3:18:57 PM, you wrote:

E> I have a string and its late.  :)

E> I have a string 3_2_000 and what I need is the numbers before the first
E> underscorethey could be anywhere from 1 character to 7...so a simple
E> left doesn't work.  I think there is a function for it, but after some time
E> pounding the noggin and a book or two, I don't see it.

E> Any ideas?  Thanks!!

E> Regards,

E> Eric J. Hoffman
E> Managing Partner
E> Datastream Connexion, LLC
E> 1.888.690.2893 

E>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CF Start a process - don't wait for it to finish

[Toby Tremayne]

use cfschedule with action="" to create a task which runs once at
now() + the scheduler interval to make sure it gets picked up.  It
will be stored as a schedule and triggered under a different thread,
while your template goes about it's business.

Toby

Thursday, January 22, 2004, 3:06:44 PM, you wrote:

TF> What's the best way to start/call a process in CF and not wait for it to
TF> finish?

 
TF> I'm thinking cfhttp but not sure... 

 
TF> For example:

 
TF> A page is called, this page does a NSLOOKUP etc. which takes a bit of time,
TF> but I don;t want to user to have to wait for the process to finish, i.e.
TF> prevent unnecessary delay of the page loading time.

 
TF> Taco Fleur
TF> Blog  
TF> http://www.tacofleur.com/index/blog/
TF> Methodology http://www.tacofleur.com/index/methodology/
TF> 0421 851 786
TF> Tell me and I will forget
TF> Show me and I will remember
TF> Teach me and I will learn 

TF>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CF Start a process - don't wait for it to finish

[Toby Tremayne]

Hi Taco,

use cfschedule with action="" to create a task which runs once at
now() + the scheduler interval to make sure it gets picked up.  It
will be stored as a schedule and triggered under a different thread,
while your template goes about it's business.

Toby

Thursday, January 22, 2004, 3:06:44 PM, you wrote:

TF> What's the best way to start/call a process in CF and not wait for it to
TF> finish?

 
TF> I'm thinking cfhttp but not sure... 

 
TF> For example:

 
TF> A page is called, this page does a NSLOOKUP etc. which takes a bit of time,
TF> but I don;t want to user to have to wait for the process to finish, i.e.
TF> prevent unnecessary delay of the page loading time.

 
TF> Taco Fleur
TF> Blog  
TF> http://www.tacofleur.com/index/blog/
TF> Methodology http://www.tacofleur.com/index/methodology/
TF> 0421 851 786
TF> Tell me and I will forget
TF> Show me and I will remember
TF> Teach me and I will learn 

TF>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re[2]: real quick ot

[Toby Tremayne]

igloo works well with studio / homesite, very nice.

Wednesday, January 14, 2004, 5:25:56 PM, you wrote:

NN> I am currently using WinCVS as a client tool with CVSNT on my server and
NN> it works very well. It doesn't tie in with Homesite, but is very simple
NN> to use and runs smoothly.  There is also TortoiseCVS that I have noticed
NN> mentioned in this thread that works well too.  It ties in with Windows
NN> Explorer which is what Homesite uses.

 
NN> If anybody needs some great instructions on setting up cvsnt go here. 
NN> http://w1.858.telia.com/~u85831169/InstallCVSNT.html

NN> http://www.cvsnt.org/
NN> http://www.wincvs.org/
NN> http://www.tortoisecvs.org/

NN> -Original Message-
NN> From: Tony Weeg [mailto:[EMAIL PROTECTED] 
NN> Sent: Tuesday, January 13, 2004 2:22 PM
NN> To: CF-Talk
NN> Subject: RE: real quick ot

 
NN> is there a CVS type app that ties in well with homesite+ ?

NN> where does the program run? I assume a it runs on the server
NN> then I have a client version on my devbox?

NN> tw

NN> -Original Message-
NN> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
NN> Sent: Tuesday, January 13, 2004 4:20 PM
NN> To: CF-Talk
NN> Subject: RE: real quick ot

NN> I've used M$ Visual Source Safe, works fine for me.  I would not suggest
NN> using it with the CFStudio/HomeSite tie in though, that suckzors.  I am
NN> currently learning how to setup CVSNT with the win gui and/or Tortoise
NN> shell
NN> for it.  Its GPL'd and the world loves it.  

NN> Why use such a monster?  To track your changes and other developers in
NN> your
NN> groups changes.  If you are the only developer, it will track yours and
NN> you
NN> can roll back if needed and hey, you can see when something was chanegd
NN> too.
NN> Its nice...its a must have really.

NN> Doug

NN> -Original Message-
NN> From: Tony Weeg [mailto:[EMAIL PROTECTED]
NN> Sent: Tuesday, January 13, 2004 3:57 PM
NN> To: CF-Talk
NN> Subject: real quick ot

NN> does anyone here use version control for web apps?

NN> my CTO is dying for me to version control our company intranet and I
NN> cant
NN> explain to him enough that in the 10 freakin years ive been building web
NN> apps, that ive never heard of a VERSION.

NN> since web sites are a single point of distribution, and as soon as
NN> someone
NN> loads a page they have the new version, WHATS THE POINT?

NN> ...tony

NN> tony weeg
NN> senior web applications architect
NN> navtrak, inc.
NN> www.navtrak.net
NN> [EMAIL PROTECTED]
NN> 410.548.2337
NN>   _
NN>   _  

NN>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re[2]: Verifying an email address exists

[Toby Tremayne]

just to add my own monkey wrench to the proceedings - the new verisign
"site-finder" (#*&[EMAIL PROTECTED]) will mess up any systems that check
for an existing dns record / server for a domain, as all domains will
resolve...

Toby

Thursday, September 25, 2003, 12:52:56 PM, you wrote:

>>>If this ACTUALLY worked, then spam would be even worse than it currently is.

CS> I don't agree at all.
CS> If all servers were really responsible, they would easily develop a protocol that 
will enable
CS> email reader to validate the sender's address and delete the message if the test 
fails.

>>>All they can possibly do is check that a domain exists.

CS> Well, if we can eliminate all mail coming from a server that does not exist, that 
would already
CS> be something, and something with near 100% accuracy. What are the chance you 
receive a valuable
CS> mail from a server that does not exists?

>>>If you need to know if an email is valid, send it an email with a validation
CS> link which the end user has to click on when they receive the email to prove
CS> it's valid.

CS> No joke, I was thinking of something like this : send a email to the sender with 
some UUID
CS> in the header, just reply to it with an empty message and I will add your address 
in my database
CS> as a valid address and accept your messages from now.

CS> 
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138384
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ColdFusion MX 6.1, now 2.5 times faster. 
http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803

Re[2]: [ OT] Special security Alert!

[Toby Tremayne]

Hi Joshua,


JM> Again, saying that your email client is superior because it's not
JM> affected by a virus written specifically to exploit a vulnerability in 
JM> Outlook makes no sense.

actually KMail still has a long way to go, but it's nice to use -
TheBat however is by any stretch of the imagination far superior to
outlook as an email client, least of all because of the virus thing ;)

JM> Please don't take this as a defense of shoddy code now, I certainly hold
JM> MS somewhat responsible, but more than MS, the users are to blame for 
JM> not protecting themselves.

hehe I took that much as given already, but as for the users being to
blame, (bear in mind I'm playing devils advocate here) while I think
it would be great if all users could be forced to pay a little more
attention, what we're talking about is not so much users protecting
themselves from virii as protecting themselves from their email
client.  As fas as the avergae user is concerned, outlook express is part
of windows which is part of their computer, so why should they expect
to have to take precautions against it?  Anti virus software is a
precaution you employ to avoid inadvertantly downloading / copying a
file that has a virus and getting infected, however you should be able
to download your email safely without having to do anything major at
all.  If you're then dumb enough to go executing anything you receive
in your mail then you deserve everything you get, however you
shouldn't need to deal with protecting your machine from whatever
outlook think's is best for you ;)

cheers,
Toby

JM> Joshua Miller
JM> [EMAIL PROTECTED]

JM> 


~|
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re[2]: [ OT] Special security Alert!

[Toby Tremayne]

Hi Joshua,

   I agree it's unfair to blame a vendor for a user's lack of effort,
   but at the same time I think it's perfectly fair to apportion at
   least part of the blame on vendors who release product after
   product with the *same* vulnerabilities, and don't even provide
   their users with any info or help on how this is a problem.
   Outlook and it's variants have this problems because of a "feature"
   that's been there for quite some time now, and which is on by
   default - the vast majority of users don't know enough to even find
   out what these things mean.

   As for the email client test, I use kmail on linux at home, and
   theBat on windows at work - neither of them have any issues with
   these worms etc because none of them execute code within an email
   without my permission - even html etc ;)

cheers,
Toby

Tuesday, September 23, 2003, 12:51:24 PM, you wrote:

JM> I stopped using Outlook recently, but mainly because I finally found a 
JM> way to move all my old email over to my Mac.

JM> It's somewhat unfair to blame Microsoft for the virii being passed 
JM> around, although it's typical of society - if you don't properly educate 
JM> yourself on how to use your software and then you get infected it has to 
JM> be someone else' fault. If you stab yourself in the eye with a pencil 
JM> it's not Dixon Ticonderoga's fault because they didn't make your pencil 
JM> dull, it's your fault because you don't know how to safely use the tools 
JM> you're given to work with.

JM> You would think that after 3, 4, 5, 20 virii make their way to your 
JM> Outlook inbox and infect your machine that you would take the time 
JM> necessary to learn how to protect yourself, but alas, as we Americans 
JM> typically do, we go to the opposite extreme and demand that someone else 
JM> do something to shield us from having to learn something that may be 
JM> harder than making toast.

JM> Anyway, I'd challenge anyone out there to put their email client in the 
JM> hands of several million uninformed, novice users and see if it could 
JM> withstand the inevitable onslaught of virii that would be written 
JM> specifically to exploit its weaknesses.

JM> Just my opinion though,

JM> Joshua Miller
JM> [EMAIL PROTECTED]

JM> 


~|
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: MIME type question

[Toby Tremayne]

Hi Peter,

   try application/x-zip-compressed

cheers,
Toby

Monday, September 8, 2003, 4:17:45 PM, you wrote:

PT> Does anyone know wha the MIME type is for ZIP files (for a CFFIlE="UPLOAD"
PT> task using accept attribute). eg:

PT> accept="text/html,text/plain,application/pdf,application/msword,application/
PT> msexcel,application/mspowerpoint,application/rtf,application/x-shockwave-fla
PT> sh

PT> Peter Tilbrook
PT> ColdFusion Applications Developer
PT> ColdGen Internet Solutions
PT> 4/73 Tharwa Road
PT> Queanbeyan, NSW, 2620
PT> AUSTRALIA

PT> Telephone: +61-2-6284-2727
PT> Mobile: +61-0439-401-823
PT> E-mail: [EMAIL PROTECTED]

PT> World Wide Web: http:/www.coldgen.com/

PT> ==

PT> Analust - word meaning a Analyst (like myself) seeking work as an
PT> analyst/programmer.


PT> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Re[2]: DWMX 2004 - Whats new for us?

[Toby Tremayne]

just to jump in and stir the pot ;) one of the things that I like most
about the latest versions of CF is that you can deploy a war file to a
J2EE platform and completely skip the need for a CF license for the
client.  Now that there are even instructions kicking around on how to
get this going with tomcat (which is free) it's even better.

Of course it makes life a little annoying for regular updates but if
you've finished a site and are just handing it over it's perfect.

DISCLAIMER:  I'm yet to actually play with this so there could well be
horrific problems with it - but the idea is cool ;)

cheers,
Toby.

Tuesday, September 2, 2003, 4:16:18 PM, you wrote:

>> If your clients are small enough where the cost of CF is prohibitive it
>> may be likely that the cost of managing an Intranet is also prohibitive
>> (although they may be doing it anyway and have never done a cost
>> analysis).
>>
ML> I'll agree with that, but certainly the use of certain software e.g. CF 
ML> could be what tips the scale. If that is the case, then a cheaper 
ML> implementation of CFML (BlueDragon) can certainly help in that regard.

>> Many hosting companies are hosting their Intranet at "public" hosts for
>> this reason.  There are some hosts that do nothing but traditional
>> Intranet applications along with email (Exchange hosting, for example,
>> is pretty common due to the cost and complexity of managing an Exchange
>> server).
>>
ML> That may be, but there are serious issues with outsourcing internal IT 
ML> resources externally that many of these companies may not be aware of. 
ML> One example of this is that their WAN connection becomes a single point 
ML> of failure. Then of course there are legality issues related to giving 
ML> non-employees access to sensitive data that aren't under specific 
ML> consulting agreements, which is the case when your email is hosted by a 
ML> 3rd party.

>> No, consider an Intranet with is planned to contain, let's say, six
>> distinct applications (not at all uncommon).  My case now is that each
>> of these applications only has to save two hours of development time 
>> due
>> to CF for it to be just as cost effective as a "free" solution.
>>
ML> Of course, the case with BlueDragon would only need to save one hour 
ML> per application.

ML> Matt Liotta
ML> President & CEO
ML> Montara Software, Inc.
ML> http://www.MontaraSoftware.com
ML> (888) 408-0900 x901


ML> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Re[2]: CFMX 6.1 FreeBSD

[Toby Tremayne]

freeBSD has actually just gotten stable java 1.3.1 support:
http://bsd.slashdot.org/bsd/03/08/25/1834249.shtml?tid=108&tid=122&tid=126&tid=156&tid=162&tid=185&tid=190&tid=99

cheers,
Toby

Thursday, August 28, 2003, 10:26:47 AM, you wrote:

SY> Hhmm, I heard BSD isn't a huge fan of the Java platform in regards to
SY> support...anyone know otherwise?

SY> Stace


SY> -Original Message-
SY> From: Buddy [mailto:[EMAIL PROTECTED] 
SY> Sent: Wednesday, August 27, 2003 6:14 PM
SY> To: CF-Talk
SY> Subject: CFMX 6.1 FreeBSD

SY> Has anyone tried CFMX 6.1 with FreeBSD?
SY> Any luck?
SY> -Buddy

SY> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Re[2]: DWMX 2004 - Whats new for us?

[Toby Tremayne]

jEdit can also do multiple select (select several seperate
lines/paragraphs) which is fantastically useful.  I actually switched
to jEdit when I moved to a linux desktop and now I've ditched the MM
IDE's in favour of jedit permanently - tricked up to provide
everything cfstudio does, except for tag insight and F1 help, both of
which can be implemented but I haven't had the time to set it up ;)

cheers,
Toby

Tuesday, August 26, 2003, 3:50:45 PM, you wrote:

JM> jEdit also includes this feature (Vertical Select, Cut/Copy/Paste).

JM> www.jedit.org
JM> www.joshuasmiller.com/jedit/

JM> Joshua Miller
JM> Head Programmer / IT Manager
JM> Garrison Enterprises Inc.
JM> www.garrisonenterprises.net
JM> [EMAIL PROTECTED]
JM> (704) 569-0801 ext. 254
 
JM> 
JM> *
JM> Any views expressed in this message are those of the individual sender,
JM> except where the sender states them to be the views of 
JM> Garrison Enterprises Inc.
 
JM> This e-mail is intended only for the individual or entity to which it is
JM> addressed and contains information that is private and confidential. If
JM> you are not the intended recipient you are hereby notified that any
JM> dissemination, distribution or copying is strictly prohibited. If you 
JM> have received this e-mail in error please delete it immediately and
JM> advise us by return e-mail to [EMAIL PROTECTED]
JM> 
JM> *


JM> -Original Message-
JM> From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
JM> Sent: Monday, August 25, 2003 3:40 PM
JM> To: CF-Talk
JM> Subject: RE: DWMX 2004 - Whats new for us?


JM> I hate to do a "me too" but I keep Ultraedit 32 on my computer just for
JM> that Vertical select feature.  I use it at least 2-5  a week.

JM> Mark W. Breneman
JM> -Cold Fusion Developer
JM> -Network Administrator
JM>   Vivid Media
JM>   [EMAIL PROTECTED]
JM>   www.vividmedia.com
JM>   608.270.9770

JM> -Original Message-
JM> From: Jerry Barnes [mailto:[EMAIL PROTECTED] 
JM> Sent: Monday, August 25, 2003 2:27 PM
JM> To: CF-Talk
JM> Subject: RE: DWMX 2004 - Whats new for us?

JM> Vertical select would be a nice feature.  Also allowing the user to
JM> insert spaces for tabs and indicating the cursor column position in code
JM> view would make good additions.  

JM> J

JM> -Original Message-
JM> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
JM> Sent: Monday, August 25, 2003 2:32 PM
JM> To: CF-Talk
JM> Subject: Re: DWMX 2004 - Whats new for us?


JM> What I'd like to know is if they've finally added the ability to mark a
JM> column of text in "code view" mode just like UltraEdit32 can.  Until I
JM> see that feature added, UltraEdit will probably remain my editor of
JM> choice.

JM> That's not to say that I don't used DWMX at all.  I just find myself
JM> using UltraEdit more than DWMX.




JM> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Re: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

mmm perhaps you're right.  I'm going to try this http posting thing
and see if it works...



Wednesday, January 29, 2003, 8:01:18 PM, you wrote:

JvD> More likely that earlier versions didn't handle unicode right. Feel free
JvD> to copy-paste all the Word stuff you want at http://cfmx.oli.tudelft.nl/ 
JvD> and it shouldn't break (runs on a unicode PostgreSQL database).


 ---

 Life is poetry - 
   write it in your own words.

 ---

Toby Tremayne 
Technical Team Lead
Code Poet and Zen Master of the Heavy Sleep
Toll Solutions
154 Moray St
Sth Melbourne
VIC 3205
+61 3 9697 2317
0416 048 090
ICQ:  13107913

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

argh.  I had begun to think it might be something like this.  i'll
keep playing but I fear you're right, the only way to rectify this is
have an older version of CF pull it out and post it to cfmx on another
server.  What a nightmare.

I wonder though whether it's a CF thing or a copy/paste thing - can
encoding elements from word be pasted into a plain textarea on a
website?  Or is it more likely that the earlier version of CF stored
things incorrectly and cfmx finally does it right?

cheers,
Toby



Wednesday, January 29, 2003, 1:35:36 PM, you wrote:

JvD> Toby Tremayne wrote:
>> ok I've tried this again and have some interesting results.  I used
>> pgAdmin's migration tool to try to move the data across - I created
>> the pg database as unicode, and used the unicode option for the
>> migration - and ended up with an error:
>> 
>> An error occured at: 29/01/2003 11:11:54 AM:
>> -2147467259: ERROR:  Invalid UNICODE character sequence found (0xee7472)

JvD> That is the typical error when inserting high ASCII in a PostgreSQL 
JvD> database.


>> Any ideas?  I can only assume that either there's some weird character
>> gone in through a copy and paste from msword to the website textbox
>> used for input, as Paul suggested, or CF4/5 has saved bad unicode in
>> there and now I'm stuck with it.  how does one go about correcting
>> something like this?

JvD> There is the hard way. You need to extract the data from the database 
JvD> using CF 4.5, then cfhttp it to CF MX, use setEncoding() to fix the 
JvD> charset there and then insert it into the database.
JvD> And there is the uncertain way. It should be possible to import the data 
JvD> correctly in some PostgreSQL database with encoding ISO-xxx. Then you 
JvD> should be able to use the built-in Convert() function to convert to 
JvD> unicode, which would eliminate the cfhttp step. Haven't tried that though.

JvD> Jochem

JvD> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

ok I've tried this again and have some interesting results.  I used
pgAdmin's migration tool to try to move the data across - I created
the pg database as unicode, and used the unicode option for the
migration - and ended up with an error:

An error occured at: 29/01/2003 11:11:54 AM:
-2147467259: ERROR:  Invalid UNICODE character sequence found (0xee7472)

I had actually forgotten, as it happened late at night but I got this
same error when I tried on the weekend after creating a unicode
database...

Any ideas?  I can only assume that either there's some weird character
gone in through a copy and paste from msword to the website textbox
used for input, as Paul suggested, or CF4/5 has saved bad unicode in
there and now I'm stuck with it.  how does one go about correcting
something like this?

Toby



Wednesday, January 29, 2003, 10:35:31 AM, you wrote:

TT> Hi Jochem,

jotn>> What charset is this data using?

TT> ach - just whatever the default is for cf 4.0 /4.5 (UTF-8?)  There
TT> were no processing directives or locale settings in the app at all.
TT> It's been running on a windows machine (NT) up to now.

jotn>> If the data in Access is visible correctly when using Access it self it is not a
jotn>> normal unicode issue.

TT> that's what I figured - I can view the data in access, and cf 4.5 /
TT> 5.0 seems to pull it out of access fine (I haven't had the chance to
TT> try it on windows with cfmx yet).  And over the weekend I tried
TT> postgres Manager which pulled the data out fine as well (from the
TT> postgres DB on the linux machine).


jotn>> Which CF version did you use to move the data? Which client_encoding did you set
jotn>> in PostgreSQL during the migration? Did you set up the PostgreSQL database to
jotn>> use unicode (WITH ENCODING 'UNICODE')? Can't you use the pgAdmin database
jotn>> migration wizard to move the data from Access to PostreSQL and then use built-in
jotn>> functionality to transform the data?


TT> initially I used cf 5 on windows to move the data to the postgres db
TT> on the linux machine.  The linux box is running cfmx, and that's where
TT> I'm seeing the dodgy characters.  On the weekend I tried doing the
TT> same transfer with cfmx on windows instead of cf5 and strangely enough
TT> it didn't fix it completely but it did end up with LESS dodgy
TT> characters in the display on the linux machine.

TT> I initially hadn't done anything special with character encoding for
TT> postgreSQL, but in the above test I recreated the postgreSQL database
TT> using WITH ENCODING = 'UNICODE' and nothing changed.

TT> I haven't tried the pgAdmin migration wizard actually, last time I
TT> used pgAdmin I don't think it had the migration wizard.  I've been
TT> using a script as I also needed to transform a lot of the data to new
TT> table stuctures (the old one is a complete mess).  I'll try with
TT> pgAdmin and see how I go.

TT> Thanks for the tips Jochem, I'll test your advice and post back.

TT> cheers,
TT> Toby


jotn>> Jochem
jotn>> 
TT> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re[2]: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

Hi Jochem,

jotn> What charset is this data using?

ach - just whatever the default is for cf 4.0 /4.5 (UTF-8?)  There
were no processing directives or locale settings in the app at all.
It's been running on a windows machine (NT) up to now.

jotn> If the data in Access is visible correctly when using Access it self it is not a
jotn> normal unicode issue.

that's what I figured - I can view the data in access, and cf 4.5 /
5.0 seems to pull it out of access fine (I haven't had the chance to
try it on windows with cfmx yet).  And over the weekend I tried
postgres Manager which pulled the data out fine as well (from the
postgres DB on the linux machine).


jotn> Which CF version did you use to move the data? Which client_encoding did you set
jotn> in PostgreSQL during the migration? Did you set up the PostgreSQL database to
jotn> use unicode (WITH ENCODING 'UNICODE')? Can't you use the pgAdmin database
jotn> migration wizard to move the data from Access to PostreSQL and then use built-in
jotn> functionality to transform the data?


initially I used cf 5 on windows to move the data to the postgres db
on the linux machine.  The linux box is running cfmx, and that's where
I'm seeing the dodgy characters.  On the weekend I tried doing the
same transfer with cfmx on windows instead of cf5 and strangely enough
it didn't fix it completely but it did end up with LESS dodgy
characters in the display on the linux machine.

I initially hadn't done anything special with character encoding for
postgreSQL, but in the above test I recreated the postgreSQL database
using WITH ENCODING = 'UNICODE' and nothing changed.

I haven't tried the pgAdmin migration wizard actually, last time I
used pgAdmin I don't think it had the migration wizard.  I've been
using a script as I also needed to transform a lot of the data to new
table stuctures (the old one is a complete mess).  I'll try with
pgAdmin and see how I go.

Thanks for the tips Jochem, I'll test your advice and post back.

cheers,
Toby


jotn> Jochem
jotn> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re[6]: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

ach to be honest I'm just want it to pump out the data in whatever the
default is - there's a lot of data but it's not an enormous
application, and the content is all straight english text.



Friday, January 24, 2003, 5:29:16 PM, you wrote:

>> That's what's bothering me Paul - can I no longer just output the data
>> from my database reliably without forcing these directives?

PH> it, as usual, depends on what specifically you're doing. what encoding do
PH> you want to use? what encoding is your cf box's jvm? want i18n?

PH> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re[4]: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

PH> good practice for cfprocessingdirective on each page. setencoding, cfcontent
PH> can just go into the application.cfm

That's what's bothering me Paul - can I no longer just output the data
from my database reliably without forcing these directives?



Friday, January 24, 2003, 4:40:52 PM, you wrote:

>>thanks for that.  It's not going to be fun re-writing my scripts to
>>scrape all this data off a cfhttp call though

PH> well you might try cf4.5 to dump out text files & use native db tools to
PH> import these.

>>incidentally will I need to cfprocessingdirective, setencoding, etc

PH> good practice for cfprocessingdirective on each page. setencoding, cfcontent
PH> can just go into the application.cfm

PH> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re[2]: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

Hi Paul,

   thanks for that.  It's not going to be fun re-writing my scripts to
   scrape all this data off a cfhttp call though

   incidentally will I need to cfprocessingdirective, setencoding, etc
   on every page in my cfmx application from now on?  I saw something
   the other day mentioning that these couldn't be called just from
   application.cfm or similar...

   At the end of the day all I want to do is get the data into
   PostGreSQL and have it display properly hehe.  What a nightmare.

cheers,
Toby

Friday, January 24, 2003, 4:20:15 PM, you wrote:

>>Has anyone got any suggestions?

PH> setup a template on the cf4.5 box that dumps out your data, that should get
PH> the mangled unicode out ok. cfhttp from the mx box to that template, that
PH> should get it into real unicode format. make sure the mx dsn has unicode
PH> option turned on & you've added cfprocessingdirective, setencoding, etc. to
PH> that cfhttp page.

PH> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

Hi all,

   I've been searching through the online forums and docs but can't
   find anything that actually tells me how to do this.  I have a
   database (msaccess) full of data stored by a cf application being
   run under 4.5 for most of it's life then cf 5.0 for a while.

   When I transport the data from the access DB to my new postgres DB
   on a linux server I use a CF script, as the table structure has
   changed - that script is run on the windows machine.  All runs
   fine, but when I go to view the application from the new
   installation it's full of junk characters (square symbols and
   questrion marks).  I'm assuming this is something to do with the
   fact that earlier versions of cf screwed up the unicode encoding
   and cfmx apparently has gotten it right - but I can't find anything
   on a method for fixing this!

   Has anyone got any suggestions?

cheers,
Toby



 ---

 Life is poetry - 
   write it in your own words.

 -------

Toby Tremayne 
Technical Team Lead
Code Poet and Zen Master of the Heavy Sleep
Toll Solutions
154 Moray St
Sth Melbourne
VIC 3205
+61 3 9697 2317
0416 048 090
ICQ:  13107913

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Suggestion for a good message forum to add to our CF SITE

[Toby Tremayne]

Fusebox openForums is completely free, and will work happily with
oracle, sql server, postgreSQL or msaccess at the moment.  you can
find a copy at http://fbopenforums.sourceforge.net

Toby



Thursday, April 11, 2002, 12:40:59 PM, you wrote:

hj> I've searched around and have found a large number of message forums that 
hj> we can add to our CF web site and integrate well with our MS SQL DB. 
hj> However I'd like to read some reviews or get some first hand opinions on 
hj> which products are well recommend and people have had good experiences 
hj> using. Some of the products I've short listed include: IKONBOARD, 
hj> Vbulletin, CFFORUM, SIMPLE MESSAGE BOARD, FUSETALK, FORUMSPOT or WWWTHREADS.

hj> Can anyone suggest a good, free (or low cost product) that we can use to 
hj> add a discussion forum to our web site? Any first hand recommendations 
hj> would be really appreciated.

hj> Thanks.




hj> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Source Controlled Web Development - help needed

[Toby Tremayne]

Thanks Andrew,

the problem is however that we have absolutely no option of running
spectra on each workstation...

Toby


 Life is poetry, write it in your own words



Toby Tremayne
Architect / Developer
Code Poet and Zen Master of the Heavy Sleep
MercuryRed
Lvl 9, 123 Queen st
Melbourne
VIC 3000
p: +61 3 9605 5035
m: +61 416 048 090
ICQ: 13107913



DISCLAIMER - All errors and omissions excepted. This message contains
privileged and confidential information intended only for the use of the
addressee named above. If you are not the intended recipient of this
message you are hereby notified that you must not disseminate, copy or
take any action in reliance on it. If you have received this message in
error, please notify Mercury Red immediately
- Original Message -
From: Andrew Scott <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 1:13 PM
Subject: RE: Source Controlled Web Development - help needed


> Allaire do make recommendations in the KB articles!
>
> When I have done this it has always been wit Source Safe!
>
> Ideally you need to do something like this.
>
> 1) Source Repository Server
> 2) Web Server
> 3) Work Station for each user.
>
> Now the source repository doesn't need to be its own server, but it just
> more convenient if it is!
>
> The web server is setup for developing and seeing the final picture of
> the site, now each workstation should have a local copy of CF & Spectra
> and when checking the files out they get stored locally and can be
> manipulated until returned/checked in.
>
> This is based on the allaire recommendation that can be found in the KB
> articles.
>
>
> Regards,
> Andrew Scott
>
>
> -Original Message-
> From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 27 September 2001 12:53 PM
> To: CF-Talk
> Subject: OT: Source Controlled Web Development - help needed
>
> Apologies for the OT post, but I  really need some input here...
>
> We're trying to set up a new dev/staging/production environment with
> source
> control.  One of our major problems / decisions is based aorund the
> development cycle and how it works with source control.  Obviously the
> maxim
> "work locally, store globally" is the perfect ideal.  When you're
> talking
> about something like C development this is simple - you just need a
> local
> compiler.  But we're running CF and Spectra, and several of the
> developer's
> boxes are not capable of running local copies of spectra.
>
> I don't want a situation where I have to check out a file locally, edit
> it
> blind, check it back in again, somehow move it to a browseable directory
> then refresh the page and see my changes.  When I'm trying to debug
> something that's going to be a nightmare.  Especially if we use CVS
> instead
> of MS Source Safe (and we'd prefer to implement CVS), because then we
> have
> an extra client to deal with, thus more alt tabbing all over the place.
>
> So I'm trying to work out the best solutions - how to handle the serving
> of
> these pages, where to check out to,(working directories) etc.  Can
> anyone
> lend some insight as to how their company does things, or how best they
> might implement something?  We can't do away with spectra as we have
> several
> large jobs requiring it, and we're pretty much stuck with not being able
> to
> run a local copy of spectra on everyone's box.
>
> any help at all would be appreciated...
>
> cheers
> Toby
>
> 
>
>  Life is poetry, write it in your own words
>
> 
>
> Toby Tremayne
> Architect / Developer
> Code Poet and Zen Master of the Heavy Sleep
> MercuryRed
> Lvl 9, 123 Queen st
> Melbourne
> VIC 3000
> p: +61 3 9605 5035
> m: +61 416 048 090
> ICQ: 13107913
>
> 
> 
> DISCLAIMER - All errors and omissions excepted. This message contains
> privileged and confidential information intended only for the use of the
> addressee named above. If you are not the intended recipient of this
> message you are hereby notified that you must not disseminate, copy or
> take

OT: Source Controlled Web Development - help needed

[Toby Tremayne]

Apologies for the OT post, but I  really need some input here...

We're trying to set up a new dev/staging/production environment with source
control.  One of our major problems / decisions is based aorund the
development cycle and how it works with source control.  Obviously the maxim
"work locally, store globally" is the perfect ideal.  When you're talking
about something like C development this is simple - you just need a local
compiler.  But we're running CF and Spectra, and several of the developer's
boxes are not capable of running local copies of spectra.

I don't want a situation where I have to check out a file locally, edit it
blind, check it back in again, somehow move it to a browseable directory
then refresh the page and see my changes.  When I'm trying to debug
something that's going to be a nightmare.  Especially if we use CVS instead
of MS Source Safe (and we'd prefer to implement CVS), because then we have
an extra client to deal with, thus more alt tabbing all over the place.

So I'm trying to work out the best solutions - how to handle the serving of
these pages, where to check out to,(working directories) etc.  Can anyone
lend some insight as to how their company does things, or how best they
might implement something?  We can't do away with spectra as we have several
large jobs requiring it, and we're pretty much stuck with not being able to
run a local copy of spectra on everyone's box.

any help at all would be appreciated...

cheers
Toby



 Life is poetry, write it in your own words

----

Toby Tremayne
Architect / Developer
Code Poet and Zen Master of the Heavy Sleep
MercuryRed
Lvl 9, 123 Queen st
Melbourne
VIC 3000
p: +61 3 9605 5035
m: +61 416 048 090
ICQ: 13107913



DISCLAIMER - All errors and omissions excepted. This message contains
privileged and confidential information intended only for the use of the
addressee named above. If you are not the intended recipient of this
message you are hereby notified that you must not disseminate, copy or
take any action in reliance on it. If you have received this message in
error, please notify Mercury Red immediately

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Check out what Gartner is recommending. Drop IIS!

[Toby Tremayne]

I'm sorry - I've been avoiding it but I have to jump in here...

I keep reading on this list and others, and in so many news articles about
windows only being targeted because it's the most popular, and about it
being down to irresponsible admins etc etc.  Both of these points are in
some ways valid, but to me these people seem to be missing the point.

   Yes, less of this would happen if admins were responsible and used all
the latest patches etc etc.  But what am I missing here -why is it nobody
seems to see that the entire concept of windows and iis patches is the
problem in the first place - we need to patch our servers because they are
a)in some places so pathetically coded and/or untested that they break down
and let all kinds of nonsecure access through and b)at development time it
is obviously decided that security is not cost effective to implement.

These worms are all aimed at the fact that explorer/iis/outlook let you
arbitrarily execute all kinds of foreign code or local commands without any
kind of checking or restraint whatsoever.  And yes perhaps there are patches
for the majority of these - but they should never have been released
requiring those patches in the first place.  Windows is targetted not purely
because of it's market share but because it makes possible the functions of
these worms.  I don't agree with the idea that there are more windows based
hackers than unix based hackers - the thought is ludicrous - and it makes
little difference.  You don't need any great level of expertise to write one
of these things, and as bad as the last year or two have become it's
astounding there aren't more of them.  And still microsoft continues to
release software with these vulnerabilities coded into them - and we
continue to buy them.

Look at it this way, if someone made a television that did all the
normal stuff, but had an extra "feature" that let anyone arbitrarily connect
to it and start changing your channels, you'd never buy it.  And if you'd
already bought it and later found out, you'd kick up an enormous stink.  It
ought to be no different with software - especially software that's mission
critical and costs you large sums of money when it fails - not to mention
inadvertently hammering the daylights out of *other* people's software
without you being able to stop it.

These are just my opinions, but I'm seriously tired of the fact that we
who know better get forced to accept appalingly poor quality software simply
because the majority don't know or care what the problems are and follow the
upgrade paths dished out to them.  We don't help this situation any when we
let these kind of arguments ride without pointing out the truth.



cheers,

Toby
P.S.  Just for the record, I too run Win2K, IIS, AND Linux


 Life is poetry, write it in your own words



Toby Tremayne
Architect / Developer
Code Poet and Zen Master of the Heavy Sleep
MercuryRed
Lvl 9, 123 Queen st
Melbourne
VIC 3000
p: +61 3 9605 5035
m: +61 416 048 090
ICQ: 13107913



DISCLAIMER - All errors and omissions excepted. This message contains
privileged and confidential information intended only for the use of the
addressee named above. If you are not the intended recipient of this
message you are hereby notified that you must not disseminate, copy or
take any action in reliance on it. If you have received this message in
error, please notify Mercury Red immediately
- Original Message -
From: Benjamin Falloon <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 7:39 AM
Subject: Re: Check out what Gartner is recommending. Drop IIS!


> Very good intelligent responses Rey and Dave.
>
> Ultimately it comes down to responsible management in the form of
expertise
> as you both allude to. I think you have a good point though Dave in saying
> that IIS is maybe a little over-loaded. I read a report from some people
> administering army.mil (or something like that) just today and it's
> conclusion rested on the same principle of awareness. Interestingly, there
> conclusion was the in order for your 'average' set-up (read - no frills)
the
> most 'secure' server set-up (being less exposed) would probably be a Mac
> with a vanilla web server.
>
> This issue is so multi-faceted that it's impossible to cover specific
needs
> and unwise to generalise to much. One major issue in light the recent
Nimda
> worm is that because there are many irresponsible IIS admins these type of
> worms can spread even further and faster th

RE: cf and apache

[Toby Tremayne]

I run apache on several linux boxes, all running cf - and it rocks.  Lovely 
and fast, doesn't fall down, and takes only a second to restart http and cf 
services together if you ever need it (which is rare).

Toby

At 12:00 AM 9/22/2001, you wrote:
>Works great so long as you do not need SSL. Been running it for almost 3
>years without a problem.
>
>-Original Message-
>From: Ben Whalley [mailto:[EMAIL PROTECTED]]
>Sent: Friday, September 21, 2001 9:53 AM
>To: CF-Talk
>Subject: cf and apache
>
>How much experience do people have with CF and Apache? Anything to be aware
>of if switching from IIS. We are just about to buy a new box and with all
>these nightmares people are having with nimba etc thought it might be a good
>idea.
>
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf kernel panic on linux

[Toby Tremayne]

Has anyone ever encountered kernel panics or crashes caused by cf on linux?  I'm 
running 4.5.1 enterprise on redhat 7.1 at home and I've never even rebooted since the 
install, yet a server I'm running it on with (apparantly) the same setup is crashing 
and they blame cfserver.  Anyone had similar experiences?  There's nothing in the 
knowledgebase

Toby



 Life is poetry, write it in your own words

----

Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Mercury Red
L 9, 123 Queen st
Melbourne
VIC 3000
ICQ: 13107913



DISCLAIMER - All errors and omissions excepted. This message contains
privileged and confidential information intended only for the use of the
addressee named above. If you are not the intended recipient of this
message you are hereby notified that you must not disseminate, copy or
take any action in reliance on it. If you have received this message in
error, please notify Mercury Red immediately


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ColdFusion Server 5 Professional on RedHat

[Toby Tremayne]

Yes you have to specify which os version you want as they're two different 
products.  But 5.0 runs beautifully on Redhat 7.1 with apache 1.3

At 07:07 PM 8/30/2001, you wrote:
>If we buy ColdFusion Server 5 Professional, do you get Windows and Linux
>versions on the 1 CD, or do you have to specify the platform when you
>purchase it?
>
>Also, does anyone have any experience of running version 5 on RedHat
>Professional Server 7.1? The Macromedia site only says it's compatible with
>7.0... will it run on 7.1?
>
>
>
>Thanks
>
>
>Aidan
>--
>Aidan Whitehall <[EMAIL PROTECTED]>
>Macromedia ColdFusion Developer
>Fairbanks Environmental +44 (0)1695 51775
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Hosting

[Toby Tremayne]

don't know of any ratings matrix's (but would be a good idea) but
CrystalTech are pretty cool - plus cheap.  They have a great reputation and
really good support.

Toby



 Life is poetry, write it in your own words

----

Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Mercury Red
L 9, 123 Queen st
Melbourne
VIC 3000




DISCLAIMER - All errors and omissions excepted. This message contains
privileged and confidential information intended only for the use of the
addressee named above. If you are not the intended recipient of this
message you are hereby notified that you must not disseminate, copy or
take any action in reliance on it. If you have received this message in
error, please notify Mercury Red immediately
- Original Message -
From: BEN MORRIS <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 1:27 AM
Subject: CF Hosting


> Fellow Developers,
>
> I am looking for a good (cheap) CF host for my personal sites, anyone have
praise/horror stories for:
> CFXHosting.com
> or
> CFM-Resources.com
>
> Or even better, does anyone know of a page that actually lists cf hosts
with user ratings? I have seen rated web hosts, and lists of CF hosts, but
never the combination of the two.
>
> Thanks for any input.
>
> ---
>
>   Ben Morris
>
>   Web Site Developer
>   American Federation of Government Employees, AFL-CIO
>   (202) 639-6448
>   www.afge.org
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Macromedia strong arms developers into 5.0 upgrade

[Toby Tremayne]

I have to say I feel the same.  Not to disparage the efforts of some of the
reps who have been out here but my biggest fear with the merger is what will
happen to Allaires dedication to it's development community.  It was the
community interaction, the friendly help and technical advice that I found
so readily available that decided me on Cold Fusion, and has helped me
enormously.  The whole Team Allaire concept, the forums, and seeing posts on
the lists occasionally from people like Jeremy Allaire and Ben Forta -
Allaire really stood out in that way to me.

After seeing the new macromedia partnership plans I'm very scared that the
attitude will become more geared to what the development community can be
convinced to buy.

I'm more than happy to be corrected - but they're  my honest to god
apprehensions, so someone please feel free to step up and show my the error
of my ways, because the alternative depresses me.

Toby

--

Life is poetry, write it in your own words

--

Toby Tremayne
Senior Technical Consultant
Code Poet and Zen Master of the Heavy Sleep
Lyricist Software
+61 416 048 090
ICQ: 13107913
- Original Message -
From: Owens, Howard <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 8:10 AM
Subject: RE: Macromedia strong arms developers into 5.0 upgrade


>
> I never get too worked up over somebody saying, "this company is screwing
> me, so I'm leaving."  It happens all the time. Hell, I've said much the
same
> thing myself.  But issues usually get resolved or one realizes that it's
> better the devil you know ... so you stick with the company.  In fact,
I've
> pretty much developed a "three-strikes" policy.  It takes a company three
> screw ups before I get mad enough to leave (though my current business
bank
> -- CalFed --  is on about it's fifth strike, I just haven't had the energy
> to make that big of a move).
>
> But it sends chills up my spine to read somebody like Michael Dinowitz say
> "my relationship with MM seems to be dead."
>
> That doesn't seem to bode well for MM, CF or us developers.  If MM can't
> keep MD happy, who can they keep happy?  If MM doesn't want to keep
somebody
> of MD's stature in the community happy, what are we to believe about how
the
> rest of us can expect to be treated?
>
>
> H.
>
>
> Howard Owens
> Internet Operations Coordinator
> www.insidevc.com
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, August 28, 2001 2:21 PM
> > To: CF-Talk
> > Subject: Re: Macromedia strong arms developers into 5.0 upgrade
> >
> > but my relationship with MM seems to be dead. I'd
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: SiteMinder Opinion

[Toby Tremayne]

The versioning isn't really much at all - basically you have a fully 
functional version of siteminder with CF but under a development 
license.  You just pay to be properly licensed for a site in 
production.  The standard licensing is on a per user basis (ie how many 
users your site authenticates).  When I rang them they were pretty helpful 
and gave me a breakdown of standard costs over the phone - be warned it's 
VERY expensive  but it's a sales thing so depending on your intended 
userbase you can probably wrangle something.

Toby

At 12:23 AM 8/21/2001, you wrote:
>I know a scaled down version of SiteMinder is the basis for ColdFusion
>Advanced Security, however my company is currently looking at the full
>version of Netegrity's SiteMinder product for implementation of
>authentication/profiling for our infrastructure. I was wondering if anyone
>out there has used the full version and what their impression was. We are
>looking to implement it with a ColdFusion/J2EE architecture.  Any comments
>would be appreciated. Thanks.
>
>- Steven Johnson
>---
>[EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help with authorise/authenticate/session management

[Toby Tremayne]

you don't need to - if your datasource works then it will be fine - your 
odbc connections contain the auth info.

Toby

At 12:20 AM 8/21/2001, you wrote:
>AH!  Toby thank you very much. I have been wrestling with this for ages,
>trying to work out how to do it without either client or session vars and
>it's getting very long in the tooth for me.   You make it look simple.  I
>wish I'd asked this question a month ago 
>
>The reason I didn't do it that way is because the CFDocs says "...To use
>this option you must create a client variable storage repository using the
>Variables page of the ColdFusion Administrator."I have no access to the
>Administrator, and can't ask the system admin to do anything with it either.
>The system owner Shiloh says "do not rely on any central system function to
>maintaining user state or authentication."
>
>
>Thanks again.  And thanks for your suggestion Peter too.
>
>One more thing ... How do you pass the username and password for the
>SQLServer7 datasource in the Cfapplication tag or don't you need to?
>
>Cheers,
>Mike Kear
>Windsor, NSW, Australia
>AFP WebWorks
>
>
>-Original Message-
>From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 20, 2001 8:21 PM
>To: CF-Talk
>Subject: RE: Help with authorise/authenticate/session management
>
>Not at all m8y.  Setting client vars to run in a datasource just means that
>CFServer will store clients vars in your datasource instead of server
>memory or whatever.
>
>If you've got problems with your host (as I do ) the easiest way is
>to do this:
>
>write your cfapplication call like this:
>
>  name="myAppName"
>  clientManagement="yes"
>  clientStorage="myDataSourceName">
>
>
>that tells CFServer to store client vars in your datasource.  The you'll
>need to run this:
>
>
>
>  CREATE TABLE [dbo].[CDATA] (
>  [cfid] [char] (20) NULL ,
>  [app] [char] (64) NULL ,
>  [data] [text] NULL
>  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>  GO
>
>  CREATE TABLE [dbo].[CGLOBAL] (
>  [cfid] [char] (20) NULL ,
>  [data] [text] NULL ,
>  [lvisit] [datetime] NULL
>  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>  GO
>
>
>(you might need to alter the sql syntax a little according to your
>datasource but this one works for SQL server - just dont change any names
>or anything.
>
>That will correctly set up the tables that CFServer uses for client storage.
>
>Now a little explanation - as far as the code is concerned, storing client
>variables is no different to storing session or request scoped
>variables.  The difference is in how the CFServer handles them - you don't
>have to use cfquery to manipulate client vars.  Of course you will be able
>to if you want to (and sometimes it can be handy) but the fact that they're
>stored in the datasource doesn't change your code.
>
>I code using the Fusebox methodology, and use client vars ALL the time -
>never have a problem m8y.
>
>Hope all this helps, and if you need anything else just drop me a line.
>
>Toby
>
>At 06:27 PM 8/20/2001, you wrote:
> >Well, I thought when you turn on client variables,  it looks for a
> >datasource in the registry or else the datasource specified in the CF
> >Administrator..  Shanje doesn't allow that.  You have to use your own table
> >in your own datasource.   So just turning on client vars doesn't work.  Or
> >have I got it wrong?
> >
> >You have to save and retrieve client vars using CFQuery calls.
> >
> >Don't you?
> >
> >Cheers,
> >Mike Kear
> >Windsor, NSW, Australia
> >AFP WebWorks
> >
> >
> >-Original Message-
> >From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, August 20, 2001 6:20 PM
> >To: CF-Talk
> >Subject: Re: Help with authorise/authenticate/session management
> >
> >Mike,
> >
> >  Hope I'm not being completely unhelpful  here  but is there
> >a particular problem with using datasource client variables?  I generally
> >employ one of two security models and they both use client vars to at least
> >keep the state of the logged in user etc.  I've always used client vars for
> >everything - if you want some example code or anything like that please
> >feel free to give me a yell.
> >
> >Otherwise I guess you could always use url vars but you're going to end up
> >in a mess of s

RE: Help with authorise/authenticate/session management

[Toby Tremayne]

Not at all m8y.  Setting client vars to run in a datasource just means that 
CFServer will store clients vars in your datasource instead of server 
memory or whatever.

If you've got problems with your host (as I do ) the easiest way is 
to do this:

write your cfapplication call like this:




that tells CFServer to store client vars in your datasource.  The you'll 
need to run this:



 CREATE TABLE [dbo].[CDATA] (
 [cfid] [char] (20) NULL ,
 [app] [char] (64) NULL ,
 [data] [text] NULL
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO

 CREATE TABLE [dbo].[CGLOBAL] (
 [cfid] [char] (20) NULL ,
 [data] [text] NULL ,
 [lvisit] [datetime] NULL
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO


(you might need to alter the sql syntax a little according to your 
datasource but this one works for SQL server - just dont change any names 
or anything.

That will correctly set up the tables that CFServer uses for client storage.

Now a little explanation - as far as the code is concerned, storing client 
variables is no different to storing session or request scoped 
variables.  The difference is in how the CFServer handles them - you don't 
have to use cfquery to manipulate client vars.  Of course you will be able 
to if you want to (and sometimes it can be handy) but the fact that they're 
stored in the datasource doesn't change your code.

I code using the Fusebox methodology, and use client vars ALL the time - 
never have a problem m8y.

Hope all this helps, and if you need anything else just drop me a line.

Toby

At 06:27 PM 8/20/2001, you wrote:
>Well, I thought when you turn on client variables,  it looks for a
>datasource in the registry or else the datasource specified in the CF
>Administrator..  Shanje doesn't allow that.  You have to use your own table
>in your own datasource.   So just turning on client vars doesn't work.  Or
>have I got it wrong?
>
>You have to save and retrieve client vars using CFQuery calls.
>
>Don't you?
>
>Cheers,
>Mike Kear
>Windsor, NSW, Australia
>AFP WebWorks
>
>
>-Original Message-
>From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 20, 2001 6:20 PM
>To: CF-Talk
>Subject: Re: Help with authorise/authenticate/session management
>
>Mike,
>
>  Hope I'm not being completely unhelpful  here  but is there
>a particular problem with using datasource client variables?  I generally
>employ one of two security models and they both use client vars to at least
>keep the state of the logged in user etc.  I've always used client vars for
>everything - if you want some example code or anything like that please
>feel free to give me a yell.
>
>Otherwise I guess you could always use url vars but you're going to end up
>in a mess of spaghetti code among other things.
>
>Toby
>
>
>
>
>At 04:49 PM 8/20/2001, you wrote:
>
> >I have a problem with a site I am working on for a client.  I am stuck with
> >hosting it at Shanje.com for a variety of reasons that are outside the
>scope
> >of this discussion, but I have a big problem setting up a user
> >access/authenticate/session management system.
> >
> >Shanje don't allow client variables on a central datasource or in the
> >registry.  So all client variables have to be done through a table in my
>own
> >SQL7 datasource.   I can't use session management because the site is
> >clustered.   And no CFX custom tags are allowed.
> >
> >Kind of tying my hands behind my back I think.   I can use the NT
> >permissions management to restrict access if I'm happy to give everyone the
> >same username and password.  That's impossible in this site.
> >
> >
> >Can anyone help me out here ... how the hell do I control access to users,
> >and grant permissions for various parts of the site, without using client
> >management, session management, CFX tags?
> >
> >The only way I have been able to think of up to now, is to set or test for
>a
> >cookie at the top of each page, and do a query on the users table.  Is
>there
> >any other way?  Because this implies I have to deny access to anyone who
> >hasn't got cookies enabled.  Has anyone set up an access control system in
> >an environment like this?
> >
> >Please don't suggest moving away from Shanje, because in this case it's not
> >an option.
> >
> >Cheers,
> >Mike Kear
> >Windsor, NSW, Australia
> >AFP WebWorks
> >
> >
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Help with authorise/authenticate/session management

[Toby Tremayne]

Mike,

 Hope I'm not being completely unhelpful  here  but is there 
a particular problem with using datasource client variables?  I generally 
employ one of two security models and they both use client vars to at least 
keep the state of the logged in user etc.  I've always used client vars for 
everything - if you want some example code or anything like that please 
feel free to give me a yell.

Otherwise I guess you could always use url vars but you're going to end up 
in a mess of spaghetti code among other things.

Toby




At 04:49 PM 8/20/2001, you wrote:

>I have a problem with a site I am working on for a client.  I am stuck with
>hosting it at Shanje.com for a variety of reasons that are outside the scope
>of this discussion, but I have a big problem setting up a user
>access/authenticate/session management system.
>
>Shanje don't allow client variables on a central datasource or in the
>registry.  So all client variables have to be done through a table in my own
>SQL7 datasource.   I can't use session management because the site is
>clustered.   And no CFX custom tags are allowed.
>
>Kind of tying my hands behind my back I think.   I can use the NT
>permissions management to restrict access if I'm happy to give everyone the
>same username and password.  That's impossible in this site.
>
>
>Can anyone help me out here ... how the hell do I control access to users,
>and grant permissions for various parts of the site, without using client
>management, session management, CFX tags?
>
>The only way I have been able to think of up to now, is to set or test for a
>cookie at the top of each page, and do a query on the users table.  Is there
>any other way?  Because this implies I have to deny access to anyone who
>hasn't got cookies enabled.  Has anyone set up an access control system in
>an environment like this?
>
>Please don't suggest moving away from Shanje, because in this case it's not
>an option.
>
>Cheers,
>Mike Kear
>Windsor, NSW, Australia
>AFP WebWorks
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Hardware Load Balancers

[Toby Tremayne]

Sorry if this is coming late - but you'd LOVE  FreeSco.  Stands for Free 
Cisco and it replaces a cisco - completely free, runs on any old piece or 
crap machine (486 etc) runs completely from a floppy, plus can handle all 
kinds of other bits and pieces.  Incredibly easy to install and just drop 
in place - you'll never have to think about it again, and it's very very 
secure.

www.freesco.org

HTH

Toby

At 09:06 PM 8/13/2001, you wrote:
>I've had some really good experiences with Cisco's Local Director 416. At
>$6000 - $7000 though, it's really not inexpensive.
>- Original Message -
>From: "Randy Smith" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, August 10, 2001 5:34 AM
>Subject: OT: Hardware Load Balancers
>
>
> > Hi all!  I'm hoping that I can get some insight and guidance in the
> > load balancing arena.  My little group provides intranet apps for
> > various parts of my company (some of them CF, some not).  These apps
> > are spread across HP-UX, Linux, and NT, and are also spread across
> > multiple sites.
> >
> > We're looking for a smallish, inexpensive piece of hardware that would
> > recognize that a server was down and route traffic to an alternate.
> > It would be a bonus if it could recognize the app via URL, and route
> > to a designated replacement.  Right now, we're not worried about
> > session and client variables.
> >
> > Recommendations, prices, thoughts?  Vendors welcome.
> >
> > Many thanks!!!
> >
> > Randy Smith
> > [EMAIL PROTECTED]
> > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: FuseBox

[Toby Tremayne]

Absolutely.  I discovered Fusebox over a year after I started coding in 
cold fusion.  For a good while I just kept implementing the parts of it I 
knew as I had time to read the spec and get used to it. Now I code 
everything in fusebox.  The fusebox community is fantastic - and I've found 
coding in this methodology has actually lent me toward writing more elegant 
and sophisticated solutions to things as a matter of course simply because 
of the mindset fusebox methods draw me into.

The mailing list by the way is now run through topica.com.  Easy way to 
join is go to www.halhelms.com (a great place for fusebox info) and use the 
form there.

Toby

At 11:35 PM 8/9/2001, you wrote:
>I agree 100%.  FuseBox is a great tool and allows you to deploy new sites
>rapidly, but not such a great idea to do starting out with a big project.
>Tool around with it first, learn the ins-and-outs and then begin to apply it
>to bigger apps.  It is easy to use, but also easy to screw it up if you
>don't know what you're doing.  In my old shop, we implemented a very clean
>version of it and was extremely easy to use.  Where I'm currently at, they
>have a half-assed implementation of it and it is a royal pain in the
>you-know-what to debug.  It's horrible.  Get the book from Steve Nelson and
>Craig Girard (www.fusebox.org or www.secretagents.com).  It spells it out
>very nicely.  Good luck.  In case you didn't know, there is a fusebox
>discussion forum through houseoffusion also.  There are some really smart
>and helpful people over there that would fall over themselves trying to help
>you. (This means you Lee).  Great resource.
>
>
>Michael Corrigan
>Programmer
>
>\- Original Message -
>From: "Ken Wilson" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, August 08, 2001 6:36 PM
>Subject: RE: FuseBox
>
>
> > > I have a huge app to build... actually already started.
> >
> >
> > While I happen to like FuseBox and use it for a lot of my projects (where
> > appropriate), I'm not sure that I would suggest you dive into it for the
> > first time on a huge app that is already underway. Particularly if the
> > project is time sensitive. While it's not difficult to learn, it does
> > involve changing the way you do some things and leaves it up to you to
> > decide which parts of it you care to use and which you don't.
> >
> > That said, however, when you do get comfortable with it I think you'll
>find
> > it speeds your development quite a bit. You will, of course, get lots of
> > varied opinions about FuseBox here on CF-Talk...most equally valid from
>the
> > perspective of the person expressing them. In the end you'll have to
>decide
> > for yourself what's best for your situation. But do check it out and try
>to
> > avoid falling for any of those old wivetales about it being mostly about
> > file naming conventions or dictating directory structures.
> >
> > Ken
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Pro Bono Forms - URL

[Toby Tremayne]

Darien,

 I'm a little behind on the lists I'm afraid - you still need the 
help?  I'm between contracts at the moment, so if you do, please give me a 
yell and I'll knock up the forms you need.

regards,
Toby

At 11:21 AM 8/8/2001, you wrote:
>This in in regards to the Pro Bono form help request.
>
>Sorry, forgot to include the URL. Site is 90% complete.
>
>http://209.25.246.197/
>
>The site registration is going through now:   www.4rkids.ws
>
>I will provide server access to a server with CF.  The time frame is next
>Monday. I'm swamped with three commercial projects due in the next four
>days. This site has taken a lot of time, and I was hoping to have had it
>complete already.
>
>Darien Small
>Technical Information Officer
>iExpediter
>[EMAIL PROTECTED]
>
>- Original Message -
>From: "CF-Talk" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, August 07, 2001 6:36 AM
>Subject: CF-Talk-list V1 #82
>
>
> > CF-Talk-list   Tue, 7 Aug 2001Volume 1 :
>Number 82
> >
> > In this issue:
> >
> > RE: Locked Database
> > Re: Locked Database
> > Re: CF 5.0 Enterprise Server install problems
> > Subject: RE: I dont understand session locking :(
> > RE: Locked Database
> > Lock the database?
> > RE: Lock the database?
> > Re: Locked Database
> > RE: Locked Database
> > RE: Lock the database?
> > RE: Downloading Files via CFContent
> > Subtract Null = Error
> > Re: Subtract Null = Error
> > RE: Subtract Null = Error
> > RE: Subtract Null = Error
> > Urgent ! CFHTTP Connection Failed
> > RE: Urgent ! CFHTTP Connection Failed
> > RE: Urgent ! CFHTTP Connection Failed
> > ColdFusion Memory Leak
> > RE: Cybersource
> > RE: How can I insert a new record with no values?
> > RE: Urgent ! CFHTTP Connection Failed
> > RE: Urgent ! CFHTTP Connection Failed
> > RE: Urgent ! CFHTTP Connection Failed
> > Structure on Application Scope
> > RE: embedding a MIME image to an email - HELP URGENTLY!
> > Re: Structure on Application Scope
> > RE: Urgent ! CFHTTP Connection Failed
> >
> >
> > --
> >
> > Date: Mon, 06 Aug 2001 19:41:00 -0700
> > From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]>
> > Subject: RE: Locked Database
> > Message-ID:
><[EMAIL PROTECTED]>
> >
> > Hi -
> >
> > Usually sending a bad query to the data source will break the lock.  You
> > can also set "disable database connections" in the CF Administrator.  If
> > you disable db connections, make sure you enable them again, otherwise
> > your site won't work :-)
> >
> > Jay Sudowski
> > -
> > Handy Networks LLC
> > TEL: 877-70-HANDY
> > FAX: 888-300-2FAX
> > URL: www.handynetworks.com 
> > -
> > Providing reseller and dedicated Windows 2000 web hosting solutions.
> >
> >
> > -Original Message-
> > From: CFHelp [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 06, 2001 10:12 PM
> > To: CF-Talk
> > Subject: Locked Database
> >
> >
> > Is there some code I can put into a page to unlock an access database?
> >
> >
> > Rick Eidson
> > Owner
> > http://www.kchost.net/
> > KChost is getting ready to launch it's enews service
> > Now you can moderate your own affordable newsletter
> > Promote you products and services even sell advertising. Plans start at
> > $5 a month for 500 emails. FREE Trial account.
> >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: what does this mean...

[Toby Tremayne]

it usually means that the template referred to in the error is empty.  The
Cold Fusion Server won't allow zero byte files - put something in it, even
if it doesn't do anything.


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 24 April 2001 9:01 AM
To: CF-Talk
Subject: what does this mean...


Error Diagnostic Information
Just in time compilation error

unknown parser error

The last successfully parsed CFML construct was the CFML template beginning
occupying document position (1:1) to (1:1).

The specific sequence of files included or processed is:
D:\64.224.42.213\PHOTOGRAPHS\INDEX.CFM
  D:\64.224.42.213\PHOTOGRAPHS\..\INCLUDES\FOOTER.CFM  CFInclude



Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFSETTING "HTML Strings" *URGENT*

[Toby Tremayne]

you need to "escape" your quotes - instead of



use:



HTH
Toby


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 April 2001 1:21 PM
To: CF-Talk
Subject: RE: CFSETTING "HTML Strings" *URGENT*


Or just get rid of the quotes. Believe it or not whatever will work.

> -Original Message-
> From: bfalloon [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 10:05 AM
> To:   CF-Talk
> Subject:  CFSETTING "HTML Strings" *URGENT*
>
> Hello,
>
> Can someone help me with this problem?
>
> I want to create a string that contains HTML. Specifically a 'path' string
> to be
> outputted at the top of a page with variable content. The problem that I
> have
> is that I need to do something like this...
>
> Category  href="subcategory.cfm">Sub">
>
> The problem is that because of the quotation marks within the string
> itself,
> it is terminating
> the CFSET command before it gets to the end of the string.
>
> I'm not sure if I should use the converted HTML ie. < becomes < and so
> on
> because I need to output 'functional' HTML on the page below this CFSET,
> not
> 'display' HTML.
>
> Can someone explain how this should be phrased.
> I may also need to append more string information onto the end of this
> string
> depending of other query results.
>
> Thanks in advance!
>
> Benjamin Falloon
> Objektmedia
> www.objekt.com.au
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

embedding variable name

[Toby Tremayne]

I'm sure someone must have tried this before me - I can't figure out a way
to do it.

I have a facility on my forum which allows people to select a poem from the
library, and insert a link to it into the message text.  So when someone
reads the message, they can click on the link and be taken directly to that
poem's page.

The problem with this is that obviously all links need to have urltoken
appended to them.  However I can't find a way to insert the variable name
into the url that gets saved in the message text, then get CF to actually
EVALUATE it when the message is read.

This is what the links look like when they get embedded:



obviously I'm escaping the hashes - so it saves exactly the above text into
the database.  But when I display it is displays exactly like that too -
keeping the hashes in the url, so the link is treated as an anchor!!!

I need it to read these variables when the message is displayed becsause
obviously the variable values wil change from person to person.

Any ideas?


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Custom Tag

[Toby Tremayne]

I pass an attribute to the custom tag :  

and within the custom tag I use:




it works perfectly


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 8:22 AM
To: CF-Talk
Subject: RE: Custom Tag


I tried Caller.xxx and it didn't find it I will have to test it again...
Maybe I had some other problem... because I thought it would be that simple
as well.

Nathan



> -Original Message-
> From: Philip Arnold - ASP [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 11:47 AM
> To:   CF-Talk
> Subject:  RE: Custom Tag
>
> > When in a custom tag how can you reference the query that is
> > located in the
> > callers page...
> >
> > EX:
> > 
> > select a,b,c
> > from y
> > 
> >
> > 
> > ---
> > MyTag.cfm
> >
> > How can I look at all of the items in the query 'xxx'?
>
> You're going to kick yourself as to how simple this is;
> caller.xxx
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help with a

[Toby Tremayne]

Rich,

the tag version of this would be:
















(I think thats right )

HTH

Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Windows2000 migration - Datasource Problem

[Toby Tremayne]

I know it sounds overly simplistic but the only time I've ever received that
error is when I've spelt the datasource name wrong in the actual cfquery tag
itself.....


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Mary Fowler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 1:57 PM
To: CF-Talk
Subject: Windows2000 migration - Datasource Problem


Good evening, me fellow CF'rs.

I have been working all day trying to troubleshoot this and hope that I am
coherent enough to y'all to state the problem I am having correctly.

I am in the process of finishing up a migration to a new machine with
Windows2000 on it.  I have datasource connections for Oracle, SQL Server and
DB2.  They are in the Windows admin for ODBC under systems DSN, they show up
in Cold Fusion Admin for ODBC and verify, I can call up data from them in CF
Studio and I can access them with MSQuery. The problem is when I try to call
up a couple of the apps I get an error message that says:

Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver
specified)


[Microsoft][ODBC Driver Manager] Data source 'FRSDEVNATIVE73_NATIVE' not
found and no default driver specified

Hint: In order to use ODBC data sources with Cold Fusion you must create the
data source using the Data Sources page of the Cold Fusion Administrator. In
addition, if you are running under Windows NT you must make sure that the
Data Source is created as a System DSN in order for it to be available to
ColdFusion.


Data Source = "FRSDEVNATIVE73_NATIVE"

I have checked to make sure the spelling is correct on the DSN. Everything
work fine on the old machine (WINNT 4) Is this a bug with Win2000 and CF
4.5.1?  Any suggestions, clues or answers would be greatfully welcomed.

TIA,
:)mary
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: curly queries

[Toby Tremayne]

thanks for all the help guys - Nick your outputting cf code gave me an idea.
I was working on stored procs and outer joins and grouping and all kinds of
stuff.. in the end this is how I did it:



select  p.poem_title,
p.poem_id,
p.date_written,
p.submission_type,
p.poem_blurb,
p.poem_content,
p.author_id,
pod.option_name,
po.setting
frommember m, poem p, poem_option po, poem_option_def pod
where m.member_id = p.author_id
and m.member_id = #attributes.member_id#
and po.poem_id = p.poem_id
and pod.option_id = po.option_id
and p.poem_id in (select p.poem_id
from poem p, poem_option po, poem_option_def 
pod
where p.poem_id = po.poem_id
and po.option_id = pod.option_id
and po.setting = 'off'
and pod.option_name = 'hidden')

order by p.date_submitted













  
 



#poem_title#



  

  
 

   

#poem_title#

   

  








ridiculously simple for something that's been driving me crazy.  It just
goes to prove once again that when you have a complex problem, break it down
into simple elements - determine exactly what you want to do in the simplest
terms possible, and work from there.  I got stuck on the idea that I needed
to do some exotic query or stored procedure and near drove myself crazy(er).
The above code works perfectly, and allows me to code conditionally for any
option I end up having.  Plus from a database of around 900 poems and
outputting a list of 70 odd (for the author_id I was testing it on) the
whole pae load took just under 250 milliseconds, which I think i can live
with.

Thanks again for the help guys

Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 March 2001 8:47 PM
To: CF-Talk
Subject: RE: curly queries


Toby

Something like this will get you n rows per poem where n
is the number of options, filtering out the hidden ones.
Assuming each poem must have options - otherwise you need
an outer join.

select p.poem_id, p.poem_title, d.option_name, o.setting
from poem p, poem_option o, poem_option_def d
where p.poem_id = o.poem_id
and d.option_id = o.option_id
and poem_id in
(select p.poem_id from poem p, poem_option o, poem_option_def d
where p.poem_id = o.poem_id
and d.option_id = o.option_id
and d.option_name = 'hidden'
and d.setting = 'off')

You could use  in CF
to "group" the output, but actually you want everything
on one line, so I think you'll have to do something
along the lines of



  


#poem_id# #poem_title#
  

#option_name#=#setting#
  

I can't think of a way of doing headers like your example,
if you dont want to hardcode the options.

None of this tested I'm afraid ;-)

Nick

-Original Message-
From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 3:47 AM
To: CF-Talk
Subject: curly queries


I've got a tricky problem that I just can't figure out.

I'm outputting a list of poems fomr a database (just the titles.) Each poem
has several "options" such as hidden, hilite etc.  As I output the titles in
a list, I need to be able to run conditional checks against each option (IE
if hilite is "on" then display markers next to the title.)  The tables are
set up like so:

-
poem
-
poem_id numeric
poem_title  varchar
-


-
poem_option
-
poem_id numeric
option_id   numeric
setting varchar
-


-
poem_option_def
-
option_id   numeric
option_name varchar
-

you can see my problem (hopefully).  To start with I'm getting each
poem_title repeated once for every option that exists.  In the query I need
to select all this information for only the poems whose "hidden" option has
a setting of "off", then I need to output the title only once obviously, at
that time check each of it's options.

This doesn't quite work because while what I NEED is this:

one rec

RE: curly queries

[Toby Tremayne]

Eric,

thanks for that - the query part of it was the simplest part.  The problem
is that while I can output everything the way you've described below - I
still have no simple way to relate the "settings" values to the
"option_names" values.  Without hardcoding in the query etc, I need to be
able to run a conditional check saying "if the option named 'hilite' is set
to 'on' then do this"

do you see my problem?

Toby


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 March 2001 11:50 PM
To: CF-Talk
Subject: RE: curly queries


Toby,

Their are two ways that you could do this.  First way it to return your
data in a column based manor (the "way you want it") then just print it
out, the second is to return it in a row based manor ( the "way it is
now").  Each way has issues.

Column Based :  What it seems like you would like to be able to pivot
your data so that the X direction is Y and vice versa.  In Access you
can use the SQL TRANSFORM function to take data and pivot it across an
axis.  However in SQL server (and I believe Oracle) you don't get such a
function (I've been trying to figure out how that is for quite a while).
If a TRANSFORM or similar function is not available to you, then you can
use SQL CASE statements to artificially create this pivot in the data.
The problem with this approach is that its not very flexible.  If your
options are changing frequently or vary greatly this method is probably
going to cause you more headache than its worth.

Row Based : The way you got the data back looks great to me.  Sure you
are getting back a bit of redundant data, but you are going to put much
less of a load on the DB than approaching this in a column based manor.
Have you ever used the GROUP attribute of CF Output?  This is exactly
the situation its for.  To pull this off (easily) I recommend you do two
things  1) Return the data using some *outer* joins so that their is
a row for every option for every poem (see SQL below) 2) Use CFOUTPUT
with the GROUP tag.  I could see it working something like this, keep in
mind the code below is a skeleton I'm sure you'll need some other logic.

DISCLAIMER : I didn't test any of this code ...so be prepared to fiddle
with it (sorry if eMail messes up the formatting)


SELECT  p.poem_id, p.poem_title,
po.setting,
pod.option_id, pod.option_name

FROMpoem p

LEFT OUTER JOIN
poem_option po  ON p.poem_id = po.poem_id
LEFT OUTER JOIN
poem_option_def pod ON  po.option_id pod.option_name
ORDER BYp.poem_id, option_name






#getPoems.poem_id#

#getPoems.option_name#







I hope this helps.

-eric


Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390
(f)   212.580.7181


-Original Message-
From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 10:47 PM
To: CF-Talk
Subject: curly queries


I've got a tricky problem that I just can't figure out.

I'm outputting a list of poems fomr a database (just the titles.) Each
poem
has several "options" such as hidden, hilite etc.  As I output the
titles in
a list, I need to be able to run conditional checks against each option
(IE
if hilite is "on" then display markers next to the title.)  The tables
are
set up like so:

-
poem
-
poem_id numeric
poem_title  varchar
-


-
poem_option
-
poem_id numeric
option_id   numeric
setting varchar
-


-
poem_option_def
-
option_id   numeric
option_name varchar
-

you can see my problem (hopefully).  To start with I'm getting each
poem_title repeated once for every option that exists.  In the query I
need
to select all this information for only the poems whose "hidden" option
has
a setting of "off", then I need to output the title only once obviously,
at
that time check each of it's options.

This doesn't quite work because while what I NEED is this:

one record:
-
poem_id  |   poem_title   |   hidden   |   hilite  |   spellchec

curly queries

[Toby Tremayne]

I've got a tricky problem that I just can't figure out.

I'm outputting a list of poems fomr a database (just the titles.) Each poem
has several "options" such as hidden, hilite etc.  As I output the titles in
a list, I need to be able to run conditional checks against each option (IE
if hilite is "on" then display markers next to the title.)  The tables are
set up like so:

-
poem
-
poem_id numeric
poem_title  varchar
-


-
poem_option
-
poem_id numeric
option_id   numeric
setting varchar
-


-
poem_option_def
-
option_id   numeric
option_name varchar
-

you can see my problem (hopefully).  To start with I'm getting each
poem_title repeated once for every option that exists.  In the query I need
to select all this information for only the poems whose "hidden" option has
a setting of "off", then I need to output the title only once obviously, at
that time check each of it's options.

This doesn't quite work because while what I NEED is this:

one record:
-
poem_id  |   poem_title   |   hidden   |   hilite  |   spellcheck   |
-
   01"my poem"  "off""on" "on"


instead, I have this:

one record:
-
poem_id  |   poem_title   |   option_name   |   setting |
-
01   "my poem"  "hidden" "off"
01   "my poem"  "spellcheck" "on"
01   "my poem"  "hilite" "on"


as you can see this makes it difficult to do a   

can anyone help me with this please?  i know it's going to be a combination
of writing the correct query and grouping the output - it's just eluding me
utterly.  I can't / don't want to hardcode each option into the queries etc,
because obivously the number and names of options will evnetually grow...
help - anyone?




























Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: UML information recommendations?

[Toby Tremayne]

If you have a look at the fusebox docs ther'es actually an entire section on
fuseML - the fusebox standards for using UML.  I'm reasonably new to fusebox
myself, but the UML schemas adhered to by it's proponents work very nicely -
the methodology itse;f perfeclty lends itself to modelling.

HTH
Toby


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: David Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 February 2001 9:04 AM
To: CF-Talk
Subject: Re: UML information recommendations?


Apparently the Oreilly book is very good as well.

This makes me wonder.  Does FuseBox methodology and UML compliment each
other or compete?

Dave Adams
CFUG Ottawa
- Original Message -
From: Simon Horwith <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 3:15 PM
Subject: RE: UML information recommendations?


> I think the WROX Press UML Book is excellent.
>
> ~Simon
>
> > Simon Horwith
> > Allaire Certified ColdFusion Instructor
> > Certified ColdFusion Developer
> > Fig Leaf Software
> > 1400 16th St NW, # 220
> > Washington DC 20036
> > 202.797.6570 (direct line)
> > www.figleaf.com
> >
>
>
> -Original Message-
> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 2:35 PM
> To: CF-Talk
> Subject: UML information recommendations?
>
>
> Can anyone recommend a good source of information for advanced programmers
> who are new to UML?
> Especially if it relates to web development.
>
> --
-
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>
> To put this contact information into your Palm device, click here:
> http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cachedwithin

[Toby Tremayne]

If you've used cachedwithin on a cfquery and set it for, say, 10 minutes, is
there any way to reset that query before the ten minutes is up?

for example,

the threadlist in my forum has a very chunky query, so I use cached within.
After the first load, it uses cached data which lasts for 5 minutes.  At
some point I add a new thread - obviously it won't appear in the threadlist
until the 5 minutes is up and the query is cached anew, but is there a bit
of code I could attach to the end of the "create new thread" function that
would reset the query again?

Toby


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists