Re: Visual Fusion - Thoughts?

2003-01-16 Thread James Sleeman
Pablo Varando wrote:

>Hello CF-Talk community:
>
>For the last year or so I've been working on an application called
>"Visual Fusion©" (Patent pending).
>
I don't want to sound negative or anything, but I have to ask, why ?  

It sounds to me (after reading the thread) that what you are trying to 
do is to use the CF syntax to write "real" applications (rather than web 
applications), but, IMHO, the CF syntax is simply not suited to that, it 
was designed to intermix with HTML.  In effect you would be using a soft 
toy to hammer in a nail, sure the soft toy is nice and comfortable to 
hold but it's positively crappy when it comes to hammering in a nail.

Languages are designed in general for certain purposes, CF is designed 
to handle web transactions by manipulating basic data and generating 
textual output (HTML), Java is designed for cross platform applications 
programming.

By all means, develop this application, but if you are doing it to make 
money, you should research it very thoroughly,  I just don't see writing 
applications in CFML being an advantage over languages specifically 
designed for that purpose.

---
James Sleeman

~|
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: Memory Leakage

2002-10-18 Thread James Sleeman
Dave Watts wrote:

> You might see if there are any documented problems with the specific
> database drivers that you're using, or if there's a newer version of those
> drivers.

Mmm, should have mentioned it is using an MS SQL 2000 database (standard 
drivers as from Mr Gates), a quick googling finds no mention of leaks. 
Other sites using MS SQL 7 & 2000 that we have see no similar leakyness.

---
James Sleeman

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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



OT: Sites using CF Linux

2002-10-03 Thread James Sleeman

Hi all,
can anybody give me pointers to large sites using CF on Linux.  The boss 
is trying to swing a client from PHP :-)

---
James Sleeman

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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



SOT: Statistics gatherers

2002-09-24 Thread James Sleeman

Hi all,
I'm currently investigating statistics gathering packages, such as 
"ActiveTracker", to be used to probide usage statistics for fusebox-like 
sites.  The hosting providor's stats package (which probably parses log 
files) only sees index.cfm (yea, they should get a better package) when 
I say index.cfm/Foo/Bar.

Anyway, "ActiveTracker" seems quite nice, however it stores the data in 
the form of 1 record per hit, which while I can appreciate is the fastes 
t way of logging, on a high traffic site that's going to be creating a 
LOT of records, I have visions of a huge wasteful table of hit records .

Does anybody know of a similar package (doesn't necessarily need to be 
in CF, if it was open source I could possibly convert it), that stores 
the data in a slightly less gratuitous method ?  It would need to 
provide the usual "stats" functions, session counts, referrers, exit 
pages, top pages, paths through site etc etc.

---
James Sleeman


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Uniquely identifing a structure.

2002-09-01 Thread James Sleeman

- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>

> May be missing what you're trying to do, but how about generating a uuid
> and then having another structure linking uuids to structures.
>
> 
> 
>

Yea, no :-)  Perhaps I explained it badly.

What I want to do is boil an _arbitrary_ structure down to a small value of
some sort such that with two of these values I can compare the structures
for functional equivalence (i.e same keys, same values for those keys but
not necessarily same order in the underlying datastructure (admittedly my
WDDX method doesn't work correctly for different ordering (or case) of keys
it'll produce distinct keys for thoe functionally equivalent structures)).

Example pseudocode lets say it's called blah.cfm...

Code...





Same

Different


Initial key stored.




Output...

1. blah.cfm?hello=goodbye&goodbye=hello==> Initial key stored.
2. blah.cfm?hello=goodbye&goodbye=hello==> Same.
3. blah.cfm?goodbye=hello&hello=goodbye==> Same.
4. blah.cfm?foo=bar==> Different.


Note that 2 & 3, while the order is different, functionally they are
equivalent and so they both report same.  I've only used the URL scope here
because it's an easy structure for an example, but in my application there
is the possibility of nested structures, arrays and queries in the
structures to be compared.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.384 / Virus Database: 216 - Release Date: 24/08/2002

__
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
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



Uniquely identifing a structure.

2002-09-01 Thread James Sleeman

Hi all,
I need to get a simple string value that will uniquely identify a given
structure, currently what I am using is this...




which produces exactly what I want, but my problem is that this happens
several times per request and thus it is potentially a bottle neck (even if
wddx is fast, the structure in question could possibly be large).

Does anybody have any better ideas on how to accomplish this ?

---
James Sleeman


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.384 / Virus Database: 216 - Release Date: 24/08/2002

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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



exposing limited formatting functionality

2002-07-16 Thread James Sleeman

For the current job, a requirement is that for the various editable content sections 
that I expose *limited* formatting functionality to the site editor(s).  That is... 
editors should be able to write something like...


[Header]Foo Bar Narf[/Header]
[Bold]Hello[/Bold], how are you...

This is an [IMG]images/myimage.jpg[/IMG], this is a link - http://www.foobar.com/.


and have it converted to


Foo Bar Narf
Hello, how are you...
This is an , this is a link - http://www.foobar.com/.


before I bite the bullet and write something myself, does anybody know of a custom tag 
or user defined function anywhere that performs some function such as this.

---
James Sleeman




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/15/2002

__
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
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: Component Calls: What would you do?

2002-07-10 Thread James Sleeman

- Original Message -
From: "Matt Liotta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 1:59 PM
Subject: RE: Component Calls: What would you do?

You said it yourself...

> If the language supports
> overloading than the constructors can be overloaded, if the language
> doesn't then the constructors can't be overloaded.

So - CF doesn't support overloading, that doesn't mean that what you call
the component body isn't a default constructor.  Infact, it just means that
Macromedia was sensible - they decided that there was no need for a special
constructor method for CFC's because each CFC may only have a default
constructor (and by definition, a default constructor cannot have
arguments).

Lets say, for example, that MM took what you call the "component body" and
turned that into a method that every CFC must have, that takes no arguments,
would you be happy to call that a constructor.  I think so.  So what
difference does it make if that method is given a name, as a specific
method, or just remains nameless as the "component body", it still does the
same thing, at the same time, is compulsory and takes no arguments.

I think if you said to any Java or C++ programmer, "see this bit of code,
that is what CFC's use as thier one and only constructor", they will
instantly recognize that this happens when the object is "constructed", that
it's a "default constructor" and that because CF doesn't support
overloading, that it's the "only constructor".

And likewise I think if you said to any CFC programmer, "see this Java
function, this is what Java classes use as thier default constructor, but
because you can overload in Java you may specify more non-default
constructors that can take arguments", it would be quite plain that this
function happens when the object is "constructed", that it's a "default
constructor" and that because Java supports overloading, it's not the "only
constructor".

The concept is the same - a bit of code, that gets executed when the object
is created, that can be used to initialize everything that object needs, be
it written in Java, C++, Python, Smalltalk or ColdFusion.

---
James Sleeman



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/9/2002

__
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
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: (Opinion) Pop-up or not to pop-up?

2002-07-07 Thread James Sleeman

> Seriously, my first modem was a 5-pound walnut, wooden, box-jointed box, 
> about the size of a small tool--box, and had a speed of 100 baud -- and 
> *rented* for $79 per month -- we could run our APL terminals from 
> anywhere!


EI: Right.  I had to get up in the morning at ten o'clock at night,
half an hour before I went to bed, eat a lump
of cold poison, work twenty-nine hours a day down mill, and pay mill
owner for permission to come to work, and when we got home,
our Dad would kill us, and dance about on our graves
singing "Hallelujah."
MP: But you try and tell the young people today that... and they won't
believe ya'.



Sorry, couldn't resist.

---
James Sleeman



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/6/2002

__
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: CFMX bug ??

2002-07-03 Thread James Sleeman

> Complex object types cannot be converted to simple values.
>
>   The Error Occurred in J:\InnovativeMedia\StaffAdmin\qry_husk.cfm:
line
> 71
>   Called from J:\InnovativeMedia\StaffAdmin\dsp_husk.cfm: line 6
>   Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 126
>
> 69 : 
> 70 : 
> 71 :  href="#URL#" class="OLmenuLink"
> onMouseOver="highlightMenuItem('#menuName##menuX#')"
> onMouseOut="unhighlightMenuItem('#menuName##menuX#')">#Name#
> 72 : 
> 73 : 


Replying to myself again :-)

of course URL is a give away there, naming a variable the same as a scope is
bad in any case, but used to work in CF5... the release notes have this to
say.

---
Currently in ColdFusion MX, you can create a variable with the same name as
a scope (Application, CGI, Client, Cookie, Form, Request, Server, Session,
URL, or Variables). The created variable is only visible if the Variables
scope prefix is explicitly used; otherwise, an error results. However, scope
names are reserved in ColdFusion MX and might be enforced in a later
version. Therefore, Macromedia strongly recommends that you do not use scope
names as variable names.
---

This doesn't explain "file" though.

---
James Sleeman



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002

__
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: CFMX bug ??

2002-07-03 Thread James Sleeman

- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 7:04 PM
Subject: RE: CFMX bug ??



> In the second case, #URL# might be the prime suspect for the same
> reason.

Yes, duh, realised that as soon as I posted :-)  Don't blame me I didn't
write that bit of code :-)



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CFMX bug ??

2002-07-03 Thread James Sleeman

- Original Message -
From: "James Sleeman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 6:34 PM
Subject: CFMX bug ??



> 
> DESTINATION="#REQUEST.MirrorDir#\#file#" >
> 
>
> fails with...
>
> Complex object types cannot be converted to simple values.
>

Replying to myself...

I have narrowed it down somewhat, it seems that there is something funky
about calling a variable "file" (not case sensitive), no matter what I set
"file" to (either there as the loop index, or manually as ) it always remains an empty struct (at least thats what
CFDUMP tells me it is).  So i renamed the variable file to xfile and this
section of code works now.

But after waiting around for aages while it compiled code, lo and behold
a very similar error occurs here...


Complex object types cannot be converted to simple values.

  The Error Occurred in J:\InnovativeMedia\StaffAdmin\qry_husk.cfm: line
71
  Called from J:\InnovativeMedia\StaffAdmin\dsp_husk.cfm: line 6
  Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 126

69 :
70 :
71 : #Name#
72 :
73 :



here I'm guessing it's either #Insert#, #URL# or #Name# that is the problem.
How many of these am I going to find around the place ?!?!?!?!?!

---
James Sleeman



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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



CFMX bug ??

2002-07-03 Thread James Sleeman

Hi all,
I'm just working on porting our intranet (which is currently running
under CF5) to CFMX, and right off the bat I have a little strangeness

I have a query, Q_Changers which contains the names of files that need to be
copied, generating the query works fine, but the copy code...


   


fails with...

Complex object types cannot be converted to simple values.

The Error Occurred in J:\InnovativeMedia\app_globals.cfm: line 122
Called from J:\InnovativeMedia\StaffAdmin\app_locals.cfm: line 12
Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 9

120 :
121 :   
122 :
123 :   
124 :

but I'm not using any complex objects there, all variables on line 122 are
simple strings, (REQUEST.RootPath & REQUEST.MirrorDir are directory paths,
and file is of course just a filename).  Not to mentiong the intranet is
functioning correctly under CF5 as I type.

Ideas anybody ?

---
James Sleeman




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002

__
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: Netscape and MX

2002-07-01 Thread James Sleeman

> We are in the process of changing these over to run on MX. The problem is
> that anything with DHTML ends up causing the text in Netscape to change to
> either a little box indicating a character not supported for display by
> windows or a little cross like symbol. Everything still works fine in I.E.
> and this is the same code running on CF 5.0 with no modifications yet.
Both
> servers are running NT 4.0 with Service Pack 6.
>
> Has anyone else ran in to this or did I miss something in the
documentation?
> You help is appreciated.

Do you have debugging information turned on, and if you do do you have the
new floating/dockable debugging pane turned on - it will only work in the
latest model browsers and could be causing the errant effects you are seeing
in NS4.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/28/2002

__
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: Aggregating server side form validation messages

2002-06-30 Thread James Sleeman

i usually do something like this







in my server side action, then in the form display



 Please correct the following :


 #error# 






- Original Message -
From: "Mark Leder" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 4:57 PM
Subject: Aggregating server side form validation messages


> I'm doing both client side (JS) and server-side form validation.
> Typically in JS Client side, if there are a number of required fields
> not filled in by the user, upon submit, a single popup alert occurs
> listing all the fields that need to be filled in.
>
> I want to do this same process with server side (using CFM) as well.  In
> other words, using a first name field as an example, I'd like to replace
> the CFLOCATION statements in each check group (I could wind up with 30
> checks on the various field) with something that will "remember" the
> #val# number and then lump them all one CFLOCATION statement at the end
> of the validation routine, such as:
>
>  URL="#REQUEST.webroot##REQUEST.Ssubwebroot#/default.cfm?pID=#URL.pID#&va
> l=19a, 19b, etc." ADDTOKEN="No">
>
> The &val= appendage would be dynamic, only having those values which did
> not pass the server-side validation.
>
> How would I accomplish something like this?
>
> ==
>
> 
> 
> 
> 
>  URL="#REQUEST.webroot##REQUEST.Ssubwebroot#/default.cfm?pID=#URL.pID#&va
> l=19a" ADDTOKEN="No">
> 
> 
>
> 
> 
>  #IsAlphabet(SESSION.ecom.firstname)#>
> 
> 
>  URL="#REQUEST.webroot##REQUEST.Ssubwebroot#/default.cfm?pID=#URL.pID#&va
> l=19b" ADDTOKEN="No">
> 
>
>
> ===
>
> Thanks,
> Mark
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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



Global database of cities/towns/villages.

2002-06-30 Thread James Sleeman

Hi all,
a client wants people to be able to select a country, region and city/town/village 
from select lists, problem is that it needs to be global.  I found this one
http://www.meridianworlddata.com/Product-Overview.asp?itemid=731
but apart from the hefty price tag a quick search revealed that it doesn't even have 
some large towns in New Zealand (for example, Rangiora which has a population of 8500 
or so) so it doesn't instill confidence.  

Anybody know of any better sources ?

---
James Sleeman



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/27/2002

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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



Apache 2.0.39 (win) + MX, any progress ?

2002-06-26 Thread James Sleeman

Anybody know if any progress has been made on the problem with CFMX and Apache 2.0.39 
(i.e it causes the Apache2 service not to start) ?  I'd really like to be able to try 
some stuff with MX but need to use it with my Apache 2.0.39 install.

---
James Sleeman


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/23/2002

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Selecting specific value from a query result?

2002-06-24 Thread James Sleeman

> I have a nagging feeling this is really obvious, but I can't get it -
can't
> I grab a specific value from a query using structure or array functions?
>
> I need to specify retrieval of value N from column X, if that makes sense.

Q_MyQuery.X[N]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/21/2002

__
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: Using CFInclude tag in content being extracted from DB....is it possible

2002-06-24 Thread James Sleeman

> James Sleeman wrote:
> | There is another thread running on this at the moment, see "templates
held
> | in database".
> |
> | To answer your question though, write the content from your database to
a
> | temporary file using CFFILE, then use  to include that
> file, then
> | delete the temporary file...
>
> but this approach is flawed with cfmx as the first hit on a template s
> slow as it is compiled in to java byte code. :-(

That is correct, hence why you don't want to rewrite the file each time you
need it.  If you only pull it out of the database when it changes then CF
will compile it only once per change...  easy way to do this is to name the
file as the hash of the content eg...




... write out the file ...




Lock around the file writing of course to stop 2 threads trying to write it
at the same time if it doesn't exist.  You probably want to clean up the
files every now and then (just delete any older than x days when the app
fires up or something).

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/21/2002

__
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
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: cflocation url length

2002-06-24 Thread James Sleeman

> I've noticed that cflocation seems to fail when the url argument is very
> long, for example > 850 chars. I think I remember seeing somewhere that
> CFLOCATION actually implements an HTTP 302 Redirect. Is there something in
> the html headers which is restricts the url length, or is this an
artificial
> restriction imposed by cflocation?
> More pratically, has anyone determined the actual cutoff point where
> cflocation will fail?


The limit varies from browser to browser.  The thing to remember is, if your
sending data that is potentially large, you need to either store the data in
a session variable/database/whatever and pick it out at the other end, or do
it in a form post.  Using Javascript you can easily make a hidden form on a
"Loading..." page submit automatically


    Loading...






---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/21/2002

__
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
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: Using CFInclude tag in content being extracted from DB....is it possible

2002-06-23 Thread James Sleeman

There is another thread running on this at the moment, see "templates held
in database".

To answer your question though, write the content from your database to a
temporary file using CFFILE, then use  to include that file, then
delete the temporary file...






Written off the top of my head, those attributes to CFFILE might be wrong.

- Original Message -
From: "Picker, Mark" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 6:26 PM
Subject: Using CFInclude tag in content being extracted from DBis it
possible


> Hi,
>
> We are developing a site that has all the page contents stored in a
> database.  Each page has a variable set at the top and an include later
> in the page that calls a page to load content from the database.
>
> This is a page from the site (all are the same as this) :
>
> 
> 
>
> 
> 
> 
>
> and this is the content.cfm page :
>
> 
> SELECT tblDocuments.fldDocumentID,
> tblDocuments.fldDocumentTitle, tblDocuments.fldDocumentText
> FROM tblDocuments
> WHERE (tblDocuments.fldDocumentID=#PageID#)
> 
>
> 
> #Evaluate(DE(fldDocumentText))#
> 
>
> All seems to work ok except if the content coming from the database has
> any coldfusion tags in it.  Functions appear to be ok, just not tags.
> The problem is, some pages has  in them.
>
> This is an extract from a pages contents in the database :
>
>   
> 
> #now()#
>
>
> The #now()# is done, and displays date/time etc, but the  tag
> does not do anything and actually appears as code in the source to the
> final page in the browser.
>
>   
> {ts
> '2002-06-24 16:16:26'}
>
> 
>
> Does anybody know how to get around this problem? I need to use the
>  that is in the database content.
>
> Regards,
>
> Mark Picker
> Internet Manager
> Western Institute of TAFE - Dubbo
> Direct Line : (02) 6885 7538
> Institute Office : (02) 6885 7522
> Fax Number : (02) 6884 3610
>
>
> 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
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002

__
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: Exclusive Lock timeout question

2002-06-23 Thread James Sleeman

> I've been under the impression that  serializes access to
the
> entire datasource ... in which case I think I would be more inclined to
use
> the named cflock approach since it wouldn't affect the performance of any
> other pages which might be accessing other parts of the db in question...

It would depend on the database.  CFTRANSACTION just tells the database to
start, end commit or rollback a transaction, wether the database engine
thinks it should serialize all access to the entire datasource is up to it,
but most would be sensible about it (i.e they will allow transactions to
execute simultaneously until such point as a conflict is found, if one
transaction would not interfere with another then the (good) database should
have no problem allowing them to execute at the same time). :-)

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002

__
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: Exclusive Lock timeout question

2002-06-23 Thread James Sleeman

- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, June 23, 2002 11:07 PM
Subject: Exclusive Lock timeout question


> My question is, if I set a timeout value of "10" on an exclusive
> lock, what exactly times out?
>
> Is it...
> A) The person waiting for the lock will receive an error after
> waiting for 10 seconds?

If throwontimeout is set, yes.

> B) The person using the lock will receive an error if the code inside
> the lock runs for more than 10 seconds?

No

> C) Both?

No

Coldfusion will attempt to get the lock for 10 seconds, if it gets the lock
inside 10 seconds it will enter the locked portion of code and continue on
as normal.  If it doesn't get the lock it will either (depending on what you
set throwontimeout to do) throw an error or continue from the first
statement after the locked portion of code.



> Or is there a better way to do this in anyone's opinion.

Perhaps you shoudl use CFTRANSACTION, it will "atomize" the individual
queries ... that is...

you have an available quantity, say 5, and 2 customers

customer one comes in he wants 3 items, and customer 2 comes in he wants 3
items, your code is



get number of available items




reduce number of items


Say "not enough items"



all the queries between the  tags will for all intents and
purposes happen simultaneously, that is, for customer one (assuming they got
into the CFTRANSACTION first) they will get the number of available items,
and set the reduced number _at the same time_.  Customer 2 will then get
reign over the CFTRANSACTION and they will get the new number of available.
Think of it as an exclusive lock that the database will handle for you, nice
and easy.


---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002

__
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: CFEncrypt Utility

2002-06-23 Thread James Sleeman

- Original Message -
From: "Matt Liotta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 1:41 PM
Subject: RE: CFEncrypt Utility


> Without giving it all away... It allows you to package up some CF code
> and lock it down with a key. Then you distribute it to some destination
> server. The person on that end gives the tool the correct key to unlock
> it, and the tool gets CF to compile all the code into classes and then
> removes any trace of the source. There are lots more details to it
> including how it protects against various types of attacks on stealing
> the source, but those are implementation details you can't have.
>

I was under the impression that while Ben Forta showed in an early demo that
the CF source code could be removed from the server that in the CFMX release
it is not really possible to do this (I realise you are not sending around
java classes, but still).

Whatever the case you are still going to end up putting the source in clear
text (or cfencrypted at least) on the server even if only for a short time,
it would be trivial to have something watch the directory the files are
installed (temporarily) to and whip off a copy somewhere before your tool
scrubs them, no ?

Unless CFMX can be coaxed into decrypting - in memory (the way it does with
cfencrypted files) - source code files encrypted with some high quality
algorithm, using a private key that is retrieved from some means not
accessible to anything other than the CF server and never stored on disk
(perhaps it could be retrieved over the web at run time, or wired into a
server dongle (that's not a bad idea, if MM equiped CF server with unique
dongles we could encrypt the files against the customers dongle ID)), then I
don't see how it will be possible to protect source code with significant
success (of course, you can never be 100% successfull, it's all just a bunch
of bits in the end).

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.370 / Virus Database: 205 - Release Date: 6/16/2002

__
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
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: Client side sorting SLOOWWWWW!! HELP!

2002-06-23 Thread James Sleeman

Couple of things, JavaScript is slow, you just have to accept that.  And you
don't say what sorting algorithm your using, at least use a basic
implementation of Hoare's Quicksort, if you have the time you should examine
the data and invent a partitioning algorithm for the quicksort that will
best suit the data for speed of sort.  Also make sure that your comparison
operation is as efficient as possible - that's the real gut work of a good
sorter and it needs to be FAST.  Remember that sorting algorithms are
dependant on the data also, not even Quicksort will be the quickest sort for
all data (Quicksort will get slow for unbalanced partitions).

Now that's for the sort algorithm, but also remember if your rewriting HTML
tables (sounds like you are) on the fly that will be a slow process, you are
better to dump all the re-written HTML in one go rather than slowly
appending to the innerHTML of an element.

You might find it better to incorporate this into a Java applet, java (while
still not blindingly quick) should be much quicker than javascript and
you'll do away with re-writing HTML that way.

- Original Message -
From: "Andre Turrettini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 1:51 AM
Subject: Client side sorting SLOOW!! HELP!


> Hey, maybe someone can help me with this advanced topic.  I'm doing client
> side sorting of tables with dates, numbers, and text and it was working
> dandy on my test tables but then I tried to do a big fat one.  Like 600
rows
> and 10 entries per row and it slos down like bad!! Anybody done
this
> and have any tips on speeding it up?  DRE
> 
__
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
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: WYSIWYG HTML editors (a'la soEditor) for Macs ?

2002-06-12 Thread James Sleeman

On Thu, 2002-06-13 at 00:19, Tim Painter wrote:
> Don't know if this will work, but try http://editize.com/index.php  -- they
> have a java based editor that may fit the bill.

Looks swish, but doesn't support images (or tables, but that's not so
important), and Java support pre OSX sucks on Macs (no 1.3, can get
Swing but it's a pain) so it probably wouldn't even work on them.


__
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: Backups

2002-06-11 Thread James Sleeman

> I'm asking because our hosting provider just told us that they can't
backup
> our .mdb files, because they're locked when CF opens a connection to them.

Most backup software should be able to back up locked files, they generally
don't garuntee that the content is OK, but usually it shouldn't be a
problem.  Sounds like you should look for a new providor.

__
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
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



WYSIWYG HTML editors (a'la soEditor) for Macs ?

2002-06-11 Thread James Sleeman

Hi all,
we have a client, who despite our best efforts ( :-) ) is steadfastly Macintosh.  
They won't purchase a PC, they won't even purchase Virtual PC.  Now, in many of our 
administration systems we use soEditor (lite, not that it matters), which works 
wonderfully under IE on windows, and doesn't on anything else (understandably, it uses 
IE components).  This client really really really wants similar functionality for 
thier next site, but still refuses to get Virtual PC (soEditor works fine under 
Virtual PC, or so I hear from other clients).  

Does any body know of any comparable WYSIWYG editors that will function on a Mac 
platform (either IE or NS/Moz) ?

---
James Sleeman


__
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: Online CSS editors ?

2002-05-21 Thread James Sleeman

- Original Message -
From: "Nick de Voil" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 2:59 AM
Subject: Re: Online CSS editors ?

> Yes, I have one I built, drop me a line if you're still looking.

Certainly still looking, you should put up a demo somewhere, looks like I'm
not the only one interested in something like that :-)

---
James Sleeman
[EMAIL PROTECTED]

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.


__
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



Online CSS editors ?

2002-05-20 Thread James Sleeman

I am looking for a way that I can allow site admins to edit CSS styles to effect the 
look of a site, or page etc.  It needs to be edited online.  Basically I want soEditor 
but for editing CSS styles instead of html :-)  

Anybody seen anything like this around ?


---
James Sleeman


__
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: UDFs in a Custom Tag problem

2002-05-19 Thread James Sleeman

You have to do it as an include, the function declaration actually happens
on parsing of the template you see, so when your custom tag gets hit on the
end tag that parser "reads" the custom tag template again, and sees a
declaration for isOperator - no matter that it won't be used this time
around.  A CFINCLUDE'd file won't be parsed ("read") until the CFINCLUDE is
executed, so it is an effective work around.






and thisOperator.cfm contains


 function IsOperator( value ) {
 blah blah blah;
 return something;
 }





- Original Message -
From: "heirophant mm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 18, 2002 2:27 AM
Subject: UDFs in a Custom Tag problem


> Hello developers,
>
> I'm writing a custom tag, and I've written some UDFs to clean up some of
the code within the custom tag. Only the custom tag uses these UDFs -
they're pretty specialized - so I thought it would be easiest to just put
them right inside the template for the custom tag. Here's my general
structure:
>
> 
> 
> function IsOperator( value ) {
> blah blah blah;
> return something;
> }
> 
> more code
> 
> 
> some output, etc.
> 
>
> I get this error:
> "Routines cannot be declared more than once. The routine IsOperator has
been declared twice in different templates."
>
> I have found that this error occurs at the very beginning of the "end
ExecutionMode" of the tag.
>
> I can't figure out how to stop this error. Any ideas? Thanks
>
> Mike Mertsock
> Alfred University Webteam
>
>
>
> 
> Outgrown your current e-mail service?
> Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL
PLUS.
> http://login.mail.lycos.com/brandPage.shtml?pageId=plus
> 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
>

__
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
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: Looping through file-fields

2002-05-19 Thread James Sleeman

> 
> 
> 
> 
> 
> Received file number #f#
> 
> Nothing for #f#
> 
> 
> 
> 


Use  Form["File#f#"]  instead of ('Form.File#f#')


__
Get the mailserver that powers this list at http://www.coolfusion.com
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: SHA-1

2002-05-16 Thread James Sleeman

> We have a requirement to use SHA-1 encryption to store certain values
> within a MS SQL7 database.  Does anyone know of a custom tag or any other
> encryption tool that utilizes SHA-1?

Just a note, I'm sure you know, but others might not.  SHA-1 is not an
encryption method, it's a one-way hash, what goes in can never come back
out.

---
James Sleeman

__
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: Cancel button with CFINPUT Requires=Yes

2002-05-14 Thread James Sleeman

http://where.ever.you.so.please/'">


- Original Message -
From: "Bruce Holm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 15, 2002 11:16 AM
Subject: Cancel button with CFINPUT Requires=Yes


> I am noticing that if you use CFFORM and then CFINPUT or CFSELECT and
specify a field to be "Required" that having a Cancel submit button is not
possible.  It will ask for all required fields before you can click on
Cancel.
> Kind of defeats the point of Cancel.  Any work arounds?  Suggestions on
how to deal with this (other than not to use CFINPUT, etc.)


__
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



Online stylesheet editor

2002-05-12 Thread James Sleeman

In the same vein as soEditor etc. I want to be able to offer users the ability to 
modify a stylesheet online, in a graphical environment (rather than just dumping them 
a textarea with the stylesheet in it :-)).  Anybody know of an existing solution?


---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz
 
CAUTION:  The information contained in this email message is confidential and may be 
legally privileged.  If the reader of this message is not the intended recipient you 
are notified that any use, dissemination, distribution or reproduction of this message 
is prohibited.  If you have received this message in error please notify the sender 
immediately and destroy the original message and any attachments. 
 
Views expressed in this communication may not be those of Innovative Media Ltd. 


__
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
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: Spiders and SES urls

2002-05-12 Thread James Sleeman

> yes, but that is not really a 'search engine safe' url.
> the .cfm in there will give the search spider all the clues it needs to
> determine that this page is data-driven.
> they won't ban you or anything, but you won't get as many points as if
your
> URLs looked like:
> http://www.somesite.com/index/19/
> that is a true 'search engine safe' url, otherwise known as a
> 'directory-style-querystring'

But that would require passing any file - at least any file without
extention to the CF engine.  Bit of a problem no ?


__
Get the mailserver that powers this list at http://www.coolfusion.com
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



getting NAME attribute of a CFFORM ancestor

2002-05-09 Thread James Sleeman

Hi all,
any body know if it's possible to get, programmatically, the value of the Name 
attribute of an ancestor CFFORM tag... that is something like this pseudocode 
(simplified use),








I tried using getBaseTagData("CFFORM") but apparently (in CF's words...)
"The parameter combination of function GetBaseTagData does not specify a base tag that 
exposes any data.  "

If you're wondering, it's for use in a custom tag that writes some augmented form 
fields for use in a CFFORM, sure I could pass the custom tag a FormName attribute, but 
I figure that seeing as you don't have to do  
that you shouldn't have to do  either.

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz
 
CAUTION:  The information contained in this email message is confidential and may be 
legally privileged.  If the reader of this message is not the intended recipient you 
are notified that any use, dissemination, distribution or reproduction of this message 
is prohibited.  If you have received this message in error please notify the sender 
immediately and destroy the original message and any attachments. 
 
Views expressed in this communication may not be those of Innovative Media Ltd. 


__
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: Finer grain performance indicators

2002-05-05 Thread James Sleeman

>From the good folks at Apache...

http://jakarta.apache.org/jmeter/index.html

- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 06, 2002 4:47 PM
Subject: Re: Finer grain performance indicators


> At this point it time, several thousand is out of the question,
few-several
> hundred would be fine ... nothing would be great ...
>
> I said in the previous message, I want to run some load testing on our
apps
> and see how they stand up and where we can improve.


__
Get the mailserver that powers this list at http://www.coolfusion.com
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: All CFM Templates Require Login?

2002-05-05 Thread James Sleeman

> He was trying to determine if two different web servers were configured
> the same. If the configuration is based on text files, than a simply
> text file comparison tool will do the job.

Two (apache) config files can do the same thing and look entirely different,
diff wouldn't have helped much in this case.






__
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: Finer grain performance indicators

2002-05-05 Thread James Sleeman

- Original Message -
From: "Matt Liotta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 06, 2002 3:49 PM
Subject: RE: Finer grain performance indicators


> The only way to really measure the performance of your application is
> with load testing tools. Simply looking at the time it takes to process
> a single request is generally not that useful.

I disagree, load testing comes after you have performance tuned the
application for single requests, the execution times will point you to areas
of code that need improvement, or optimization, load testing can help point
you to bottle necks exosed when the throughput is much higher than the
single request.  Execution times will help you optimize the code, load
testing will help you optimize the logic.

> However, an execution
> time above 250ms is just plain slow.

That is entirely relative - if you are doing a query manipulating 40,000
rows and your server is running on an old 486 with 64mb of ram then 250ms
would be pretty bloody quick (magic box quick!), and if you are displaying a
simple "Hello World" template on an Athlon 1700XP with 2 gig of usable Ram
and a 3 gig Ram Disk containing your entire operating system, then 250ms is
pretty slow.

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.


__
Get the mailserver that powers this list at http://www.coolfusion.com
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



Finer grain performance indicators

2002-05-05 Thread James Sleeman
for those very quick templates.  It would also be better if multiple calls
to the same template were not lumped togethor, for example in the above all
the templates in \PBCORE\ get run multiple times (4 times if I count
correctly) but they each only get one time.

Ideas ??

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.

__
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
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: RDS in DW MX not working (fixed)

2002-05-01 Thread James Sleeman

- Original Message -
From: "James Sleeman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 4:08 PM
Subject: RDS in DW MX not working


> Has anybody managed to get RDS working in DW MX ?  I'm trying to use the

Ahh, did some digging around in the server logs and found that when I hit
that "RDS login" link it posted a request to the "testing server" for
/CFIDE/main/ide.cfm, and while I did have a /cfide alias set up for all the
Apache sites, aliases are case sensitive so I actually had to alias /CFIDE
to the Coldfusion CFIDE directory.

Sweet .. on with the previewing.

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.


__
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
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



RDS in DW MX not working

2002-05-01 Thread James Sleeman

Has anybody managed to get RDS working in DW MX ?  I'm trying to use the
Databases tab in the Application section... I have set up the site
correctly, numbers 1, 2 and 3 are checked but when I click "RDS login" in
step 4 I just get an error -

The server name or address could not be resolved.  The URL prefix (specified
when you set up this Dreamweaver site) might be ill formed.

but the URL Prefix (in the testing site configuration) is correct, and the
fact that step 3 is checked off tells me that DW knows this is the case
(because if I make that URL prefix invalid it doesn't check step 3 off).

Without being able to see databases I'm having to jump back and forth
between studio and DW, when if I had it I could almost use DW exclusively.

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Am I the only one who uses CONNECTSTRING ? (MX rant)

2002-05-01 Thread James Sleeman

- Original Message -
From: "Ben Forta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 6:47 AM
Subject: RE: Am I the only one who uses CONNECTSTRING ? (MX rant)


> The following message is being posted for Libby Freligh, ColdFusion
> Product Manager, who for some reason was unable to do so herself (kept
> bouncing).
>


Thanks Ben & Libby, it's good to know it hasn't been forgotten about.



---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz

CAUTION:  The information contained in this email message is confidential
and may be legally privileged.  If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited.  If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.


__
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



Am I the only one who uses CONNECTSTRING ? (MX rant)

2002-04-30 Thread James Sleeman

Ok, now the NDA is moot I can ask the wider community.  One of the best features IMHO 
in CF5 was the introduction of CONNECTSTRING to enable us to have dynamic datasources, 
that is, DSN-less connections.  

Since CF5 came out I have used these almost exclusively, infact I have been able to 
write applications that simply would not have been possible without it.

But with the introduction of CF MX the CONNECTSTRING is now no more, at least in the 
initial release.  This means we say goodbye to dynamic datasources and it's back to 
having to have every database set up individually by the CF administrator.  This, in 
my opinion is a major step back, surely the purpose of a new release is to add 
features not take them away.

The reason for losing the functionality appears to be to do with JDBC, and while it is 
possible to work around, Macromedia has basically said they don't have time to do it 
now so it's easier to sweep under the carpet and perhaps catch it next time - whenever 
that may be.

This single issue is certainly going to stop me from using MX with any of my existing 
applications - the changes necessary would be widespread, and in some cases 
impossible.  Indeed, for new applications I will have to evaluate thier needs 
carefully to determine if I can use MX or not.  

This is going to cause shared hosting providors to not be able to upgrade thier 
existing servers, at least not without imposing on thier clients to a great degree, 
it's also going to increase thier work load because now they must set up each and 
every database (can you imagine if 500 clients ask to have thier previously dynamic 
datasources set up all at once !).

But, only a couple of people in the beta group aside form myself seem to be at all 
concerned about this.  Am I the only one who uses CONNECTSTRING ?  Surely it is such a 
useful feature that we can't release MX without it ?  Surely it's worth working on for 
a little longer to get this functional ?

Well, just had to get that off my chest, I'll go back to work now :-)

---
James Sleeman


__
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: CFStudio > DWMX hiccups

2002-04-30 Thread James Sleeman

> > At least it wont
> > crash as much as Studio...that's a plus.
>
> Damn straight! Haven't used it much, but stopping those bloody Access
> violations that wiped hours of work away at times has to be #1 hope for
> DWMX. Fingers crossed.


Yeah, but it could do with a bit of a crash diet.  Sitting idle here on my
workstation with no files open it uses more than 40 meg of ram and 15 - 20%
CPU time, that's a lot of resources to be doing nothing with.  Switching to
it from another application also seems to be quite intensive for it, takes a
couple seconds.  Hopefully it loses a few inches from the waist before it
hits the streets.

Personally I woulda liked to see it written in Java like CF MX using Mozilla
as it's layout engine, then we could have DW MX 4 Linux and I could be rid
of this Windows machine.  Course, that probably would have made it _really_
slow (java, not mozilla ;-)).

---
James Sleeman


__
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: CFABORT after CFLOCATION?

2002-04-30 Thread James Sleeman

> My question is: Why is the custom tag executing? Shouldn't the page stop
> processing after the cflocation call? If I put a CFABORT directly after
the
> CFLOCATION call *within* the CFIF block, the custom tag still executes.
> However, if I place the CFABORT above the custom tag call, but *outside*
of
> the CFIF block, the page properly CFLOCATEs and the custom tag is not
> called.

Hmm, sounds to me like something fishy in that CFIF conditional...

try this (i know you'll think - well duh of course it's executing, but just
humor me :-))...


 




if the page doesn't abort then you know that conditional is not running
(which is what sounds like is happening), are there any nested conditonals
in there that could cause the location not to happen ?


__
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: Locking by name - is is application independant ?

2002-04-28 Thread James Sleeman

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 8:04 AM
Subject: RE: Locking by name - is is application independant ?


> > The problem with this is that you can't just lock "part"
> > of the APPLICATION scope for example, if you want to do
> > something to only some stuff stored in the app scope you
> > need to use named locks - but if you do that you're gonna
> > have to be careful that you don't use a name that some
> > other application on the same server has used (perhaps
> > without your knowledge if on a shared server).
>
> I don't know how well that would work, though, since the Application scope
> is a structure - a variable - itself. I don't know enough about the
> internals of CF to say whether it would be safe to only lock access to a
> structure member, rather than to the structure itself, but personally, I'd
> avoid it.

It's a concurrency thing more than anything - if one request is setting up
the stuff in APPLICATION.CONFIGURATION I don't want anything reading the
configuration until I'm done.  But they should be perfectly entitled to read
and write to APPLICATION.LOGGEDINUSERS for example.

I see where you're gettng at though, I think it's just a little
inconvienient :-)





__
Get the mailserver that powers this list at http://www.coolfusion.com
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: Locking by name - is is application independant ?

2002-04-28 Thread James Sleeman

On Sat, 2002-04-27 at 04:54, Dave Watts wrote:
> > When should you use each? Right now, I do not use 
> > named locks.
> 
> If you're using CF 4.5.x or higher, you should use the SCOPE attribute when
> locking memory variables, and the NAME attribute for locking other things,
> like CFX tags, if they need to be locked.
> 
> If you're using CF 4.0.x, you don't have a SCOPE attribute, and have to use
> the NAME attribute for all locks.

The problem with this is that you can't just lock "part" of the
APPLICATION scope for example, if you want to do something to only some
stuff stored in the app scope you need to use named locks - but if you
do that you're gonna have to be careful that you don't use a name that
some other application on the same server has used (perhaps without your
knowledge if on a shared server).  

What CF really needs is a combination of scope="" and name="" so that we
can specify we want to lock a structure within our application, but
identify the lock by this name (local to our application), oh well,
dreams are free.


__
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: 2 Zip or Not 2 Zip

2002-04-25 Thread James Sleeman

Y'know, it sounds to me like this special text file should be embedded into
the music files themselves ?  That, or the music files should be tarred or
zipped or otherwise grouped into a file with thier text file.  Whichever
way, the C++ application should unquestionably be doing the
extraction/untarring/zipping... to get out the music and encryption key for
sending to the device.  The last thing you want users to do is jump through
hoops to get what they want, wether the hoop is having to download a
mysterious text file as well as what they want, or unzip files and pass them
into another application.

I would suggest that having 2 files the user must download is going to be,
as you believe, confusing for Jo Bloggs.  Whatever you do you have to get
those files combined into one.

Sounds an interesting project BTW.

- Original Message -
From: "Owens, Howard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 5:09 AM
Subject: RE: 2 Zip or Not 2 Zip


> Good suggestions this morning ...
>
> It's a C++ application on the client side ... manages all of the files,
uses
> a special encryption method to prevent swapping files between devices,
> writes them to an external device that uses the files (only properly
> encrypted files can be used on the ID-identified device for which they are
> written).
>
> H.
>
>
>
> > -Original Message-
> > From: Lewis Sellers [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, April 25, 2002 9:24 AM
> > To: CF-Talk
> > Subject: RE: 2 Zip or Not 2 Zip
> >
> > At 09:16 AM 4/25/2002 -0400, you wrote:
> > >After thinking about it overnight, my advice is to do it the Zip way,
AS
> > >WELL AS whatever way the programmer comes up with.
> > >
> > >Then do some benchmarking analysis and see which method works best. You
> > >can support this plan by saying that it really is in the best interest
> > >of the client to evaluate all of your options before making a decision.
> > >
> > >Then make the decision as to what method works best. I have a feeling
> > >that once the programmer sees the results he may very well be more open
> > >to the Zip idea.
> > >
> > >However, since we do not have all the details of the project, who
knows?
> > >Maybe this guy's method really will work better. That is why the idea I
> > >outlined above benefits everyone.
> >
> >
> >
> > I think one "detail" that might help the group at large here :) decide
is
> > what was meant by this being a "client-side application". I was under
the
> > impression that mean an activex COM (as Howard mentioned the word COM).
If
> >
> > that's so, you simply throw in a generic ZIP class to the project (if it
> > were in c++) and run with it. (In fact, if it's an activex control the
end
> >
> > user might not necessarily even ever see the file).
> >
> > A java applet might work just as well at this point (though as .NET
> > gung-ho
> > as the programmer is they might not want to touch java).
> >
> > Anyway, if it's not activex... well... maybe something besides ZIP might
> > be
> > easier after all on the client end.
> >
> > --min
> >
> >
> >
> 
__
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
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



Locking by name - is is application independant ?

2002-04-25 Thread James Sleeman

If i have two applications on the same CF server, indentified by to different 
CFAPPLICATION tags, say one with an application name Foo and the other Bar, and I 
execute a bit of code in each that does a *named* cflock using the same name, will 
that lock extend across applications ?  That is...

In Foo.cfm

 

 
Do something here
 

In bar.cfm

 

 
Do something else here
 

can Bar get into it's CFLOCK while Foo is in it's CFLOCK.

I'm hoping yes, beause that's what I expected, but I'm seeing some behaviour on our 
server with different sites using locks with the same name that might indicate that 
the answer is no.

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz
 
CAUTION:  The information contained in this email message is confidential and may be 
legally privileged.  If the reader of this message is not the intended recipient you 
are notified that any use, dissemination, distribution or reproduction of this message 
is prohibited.  If you have received this message in error please notify the sender 
immediately and destroy the original message and any attachments. 
 
Views expressed in this communication may not be those of Innovative Media Ltd. 


__
Get the mailserver that powers this list at http://www.coolfusion.com
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: QoQ

2002-04-23 Thread James Sleeman

>
> 
> Select  numberfield
> From tbl
> 
>
>
> 
> Select numberfield
> from qmain
> WHERE  qmain.numberfield > 45
> 



you are missing DBTYPE="query"

i.e.


 Select  numberfield
 From tbl




- Original Message -
From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 9:45 AM
Subject: QoQ


> Hello all
>
> need a little help with QoQs.
>
> How can I compare numbers in the QoQ?
>
> Example:
>
> 
> Select  numberfield
> From tbl
> 
>
>
> 
> Select numberfield
> from qmain
> WHERE  qmain.numberfield > 45
> 
>
>
> IF I use the ">"  I get a PCODERUNTIME.  error
> If I use GT  I get the error that numberfield is not a number.
> I even tried #qmain.numberfield#, but then it only compares the first
> record.
> I have ran numberfield through the ISNUMBER function and get true so it is
a
> number.
>
>
> Thanks for any help
> Rodney
>
>
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
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: CFLOOP problem with commas

2002-04-23 Thread James Sleeman

> As you can see, the first URL outputs normally, but the second URL
> breaks at every comma. Is there a way around this? I don't want to
> insert Chr() codes if I can help it!

Remember that when picking a delimiter, any character is fair game, you can
be pretty much assured that something like the BEL character (CHR(7)) or
something equally as unprintable isn't going to apear in your list, and if
you're paranoid just do a check before using the list and pick another
delimiter if it is in use.

A handy ascii chart... http://www.asciitable.com

---
James Sleeman


__
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: Using ... Why?

2002-04-21 Thread James Sleeman

What it means to you as a developer is essentially that however many queries
you do inside a

 block they will ALL be executed at the same time (well, they won't
strictly, but it will look that way to you).  Generally you use them to
maintain database & query integrit, think of this (most common) example...

You have two processes, both are trying to insert into a database table,
before they do they must figure out what the next "key" value to use is but
querying the database, adding to the key it got from the query and using
that in the insert... each process looks like tihs.

Query 1 - get key
Add to key
Query 2 - insert record using key

Now let's say process one comes in, it runs query 1 and adds to the key,
then the task scheduler kicks in, switches out process one and switches in
process two, process two runs query 1 and adds to the key - but because
process one hasn't yet run query 2, process two has calculated the same key
as process one !  One of those processes has to fail now because you can't
have the same key twice.

If this was wrapped in a transaction then Query 1 and Query 2 would be
grouped togethor, we are assured that they execute "at the same time" and
thus there is no way process two can get the same key as process one.

The other main reason to use a transaction is if you want to "rollback" to
the point before you started the transaction if something goes wrong
inside... CF will automatically roll back if it generates an (uncaught)
exception - some bad SQL for instance.

The level of "locking" that a transaction induces is totally dependant on
the database, and some databases do not support transactions at all (MySQL I
believe is in this group) leaving all locking up to the developer.

- Original Message -
From: "Charles Nahm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 7:22 AM
Subject: Using ... Why?


> Are cftransaction tags necessary for certain types of queries (e.g.
queries
> involving Merant driver access to a DBaseIII database?).
>
> I am working with some code from the past and I notice the 
> tags in some areas but not in others.  Recently I have added more
> stress/queries to the DBaseIII databases and am noticing big slowdowns in
> the processes that require access to those files...
>
> In:
>
>
http://www.cfcertification.com/cfdocs/CFML_Language_Reference/2_ColdFusion_T
> ags/lr2_098.htm
>
> They say it can be used to group multiple transactions into one single
> business event.  What does that mean?  Does this mean the database will be
> locked out until all the functions within the  tags are
> finished?  Is this a requirement for certain types of db's?
>
> Any help/ideas appreciated, you people have been amazing.  Thanks.
>
> Charles
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
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



bulk insert to SQL server but not from file

2002-04-16 Thread James Sleeman

Hi all,
I have an old, ugly and large Paradox database that I inherited and am converting 
into a new, beautiful and large SQL Server (7) driven schema.  

Problem is the importing of this old database - it takes a VERY long time and i 
have to watch it like a hawk because invariably the Paradox data is broken beyond 
belief in places and I have to fix the data or scrap that row or work around it...  

The reason it takes so long (it's not to do with Paradox itself, those queries get 
cached), is that the inserting of this data generates, about 500 insert queries per 
row of data in the old paradox database (it was a big flat file thing more or less, my 
schema is fully relational), there are just under 1000 rows, that's, 50 inserts !  
Not to mention the fact that the SQL server is all the way across the net :-)

So, is there any way to do a BULK insert into single tables aside from using "BULK 
INSERT" itself, which inserts from a file on the SQL server (I don't have access to 
put files on the SQL server anyway), so that instead of 500 individual inserts per old 
database row I can just do one insert for each of my new tables (that is insert all 
the "Education" data for a row in one shot, insert all the "Staff" data in one shot 
etc) there by reducing the load to maybe 40 "bulk" inserts per row, and the total down 
to 4 "bulk" inserts (which is still a lot, but not staggeringly). 

Ideas anybody ?

---
James Sleeman

Innovative Media Ltd
Ph: (03) 377 6262
http://www.websolutions.co.nz
 
CAUTION:  The information contained in this email message is confidential and may be 
legally privileged.  If the reader of this message is not the intended recipient you 
are notified that any use, dissemination, distribution or reproduction of this message 
is prohibited.  If you have received this message in error please notify the sender 
immediately and destroy the original message and any attachments. 
 
Views expressed in this communication may not be those of Innovative Media Ltd. 


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: InTransaction Function?

2002-04-12 Thread James Sleeman

Sure, 


I am in a transaction

I am not in a transaction


I use it like this on my "action" templates (eg inserting something into
a database






DO THE DATABASE STUFF



On Sat, 2002-04-13 at 10:00, Shawn Grover wrote:
> I'm sure I've seen this topic before, but can't seem to find anything in the
> archives, or through a google search...
> 
> Is it possible to dynamically determine if the code being processed is in
> the middle of a CFTransaction?
> 
> For instance:
> 
>   
>   
>Show Message
>   
> 
> 
> I make a call to a custom Error Handler tag in a transaction, and need to
> know if a RollBack needs to be done or not.  I'd rather not have to create a
> new attribute/flag for the custom tag, if it's not needed.
> 
> Thanks.
> 
> Shawn Grover
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Trigger and Sequences

2002-04-10 Thread James Sleeman

> 
> create table #answtable# (
> FLDUNIQUE_ID number(10), 
> FLDID number(11), 
> FLDFIRSTNAME varchar(50), 
> FLDLASTNAME varchar(50), 
> 
> 

Your create table there looks a little, err, incomplete :-)

__
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: Crosswired queries

2002-04-09 Thread James Sleeman

> Is their anyway a query refernecing datasource A can affect datasource B?

No.  Well, not unless you have "linked" A & B somehow, say using linked
tables or replication or something like that.

> I have a query that sets a group of classes offered by a client to
inactive in
> datasource A if the date is < today. The client is trying to tell me that
this
> query is causing the products in datasource B to deactivate. Has antone
ever
> heard of anything like this on an access database?

Have you checked inside B to see if the value you think is changing is
actually changed ?  Have you tried the same thing as your client to see if
it really does happen or if your client was doing something wierd ?



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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 IDE are you using for Java CFX?

2002-04-08 Thread James Sleeman

> What IDE are you folks out there using for developing Java CFX?  I am
> currently using CF Studio and the command line compiler (pain in the @$$).
> I was considering buyin' a copy of JRun Studio, but wanted to see what the
> masses think.  Thanks!


I use RealJ
http://www.realj.com/

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: parsing CFML

2002-04-08 Thread James Sleeman

> And how about those dreaded  and  HTML tags often scattered
throughout cf code.

Yea I didn't intend to parse it AS XML, because it's obviously not valid XML
(many instances of unclosed tags in CF, and HTML), but I thought somebody
might have written a parser that produces a similar interface to the
structure of the code as an XML parser would to XML.

> I might suggest parsing it with regular expressions instead unless you
really need to treat it as XML, or want to handle every single tag that CF
can support.

I did write something to parse (nested) cfcases, but I thought before i went
too far I should check to be sure I wasn't just reinventing the wheel.

> Also, what are you going to do with custom tags?

Probably not a lot :-)


__
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



parsing CFML

2002-04-08 Thread James Sleeman

Hi all,
  this is a bit of a strange request I guess.  I want to parse CFML
files like they were XML files, so that I can access the structure of
the (well formed, no overlapping with html etc) cfml.  For example, so
that I can do something like




I just saw a cfcase, it's value was
#parsecf[i].value# and the content of this cfcase
is #parsecf[i].contents#...

. etc .




has anybody done anything like this ??

---
James Sleeman

__
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
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: Since when was fusebox ever supported or promoted by Allaire / Macromedia?

2002-04-04 Thread James Sleeman

I've highlighted where they say it.

>From the Back Cover
Fusebox: Developing ColdFusion Applications is the most complete resource
for learning to develop ColdFusion applications with the Fusebox standard.
Fusebox is a free web application standard that was created as a standard
for writing web applications. * (This methodology is supported and
promoted by Allaire/Macromedia.) * The aim of this methodology is to
reduce the high failure rate of these applications. If a team of developers
uses Fusebox to write ColdFusion applications, the applications will be
written more quickly and effectively because they will all code according to
the same standard. Fusebox's popularity is growing daily and will grow even
more with the next release of ColdFusion. The authors explain concepts such
as the Fusebox lifecycle process, testing, and deployment. The appendixes
are full of extra Fusebox references and resources. The web site includes
databases, files, and code from this book; current enhancements and
revisions to the material in this book; links to other Fusebox resources;
the latest updates to the core of Fusebox, for any version.


- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 3:58 AM
Subject: RE: Since when was fusebox ever supported or promoted by Allaire /
Macromedia?


> > Since when was fusebox ever supported or promoted by Allaire
> > / Macromedia?
>
> To the best of my knowledge, never.
>
> > http://www.amazon.com/exec/obidos/ASIN/0735712697/qid=10179238
> > 36/sr=1-5/ref=sr_1_5/002-7985215-1486459
> >
> > ( According to this listing that just appeared on amazon.com )
> > The way I remember it, Allaire went out of there not to endorse
> > or support any methodology.  I didn't realize that Macromedia
> > had taken an official stance.
>
> I don't see anything there to indicate otherwise.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
__
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: DSNless query

2002-04-03 Thread James Sleeman

I always use

 
 
 



- Original Message -
From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 10:26 AM
Subject: DSNless query


> Hello all
>
> Hoping someone can tell me what I am missing here.
> We are running:  CF5 NT  ACCESS2K
>
> 
>
> 
> SELECT DrawingDetails.*
> FROM DrawingDetails
> WHERE DrawingDetails.ESID=5;
> 
>
>
>
> I get the error:
> Error Diagnostic Information
> ODBC Error Code = IM002 (Data source not found and no default driver
> specified)
>
>
> [Microsoft][ODBC Driver Manager] Data source '' 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.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (4:1) to (4:68).
>
>
> Date/Time: 04/03/02 15:31:44
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
> Remote Address: 137.80.60.254
>
>
> Thanks for any help
> 
__
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
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: Testing Software

2002-03-25 Thread James Sleeman

> Does anyone know of any software like vmware that will allow for Mac
> emulation.  From what I understand vmware does not, but does anyone know
of
> another that does?

Best way is to... buy a mac.  We have a lone iMac sitting in middle of the
office for website testing.  And when it's not testing it makes a good (if
ugly) MP3 jukebox :-)

__
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: cfmail query acting strange

2002-03-24 Thread James Sleeman

Sounds like you don't want to use a query with the cfmail (which specifies
"who" to send the email body to rather than what to send to a single person)
but rather nest a CFLOOP QUERY="" inside your body...



ItemPublication

  #Item_id##Headline#"td>
 
 


Think about it, if you substitued CFMAIL for CFOUTPUT (as that's the way you
thought it worked) would you get the output you want ?  No you'd get
something like

Item Publication
1   Foo
Item Publication
2   Blah
Item Publication
3   Narf

etc...

you need to loop -inside- the table -after- the header row to get the
correct output.

- Original Message -
From: "Tristram Charnley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 23, 2002 3:58 AM
Subject: cfmail query acting strange


> I always thought cfmail with the query attribute acted like  query...> What am I doing wrong all of a sudden?  CFMAIL is sending
multiple
> separate emails, one for each record in the query, rather than multiple
> records in the one email.
>
> Whats happened?
>
> 
> SELECT item_Id,Headline
> FROM Publications
> WHERE Item_ID IN (#form.item_id#)
> Order By Item_ID
> 
>
> from="y"
>subject="Publication request"
>query="GetPubs"
> type="HTML">
>
> 
> ItemPublication
>
> #Item_id##Headline#"td>
>
> etc etc
> 
> 
>
> Tristram Charnley
> ---
> [EMAIL PROTECTED]
> Allaire Certified ColdFusion Developer
>
>
>
> 
__
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: CFSCRIPT & Preservesinglequotes()

2002-03-21 Thread James Sleeman

Yea this is a really wierd bug that I have encountered also, basically what
I see happening is.. when you supply your variable to the UDF - inside a
cfquery block CF escapes quotes in the variable before handing to the UDF,
and then it takes the value your UDF returns and escapes the quotes again.
So your one quote becomes '' when going into the UDF and then  coming
out of the UDF :-o

Two ways to fix it, what I did was unescape the single quotes in the value
my UDF gets, so I have something like

function myUDF(someValue) {
someValue = Replace(someValue, "''", "'", "ALL");
... do stuff ...
return someValue;
   }

or I think you could also use preserve single quotes when passing the value
to the UDF, something like...


   SOME SQL STUFF
#myUDF(preserveSingleQuotes(yourVariable))#


which should stop the escapement of single quotes when passing yourVariable
into myUDF, the single quotes will still be escaped coming out, but that's
what you'd expect, if you didn't want that either you could do

#preserveSingleQuotes(myUDF(preserveSingleQuotes(yourVariable)))#


Whatever way you look at it it's a very wierd thing, it's one thing to
escape values being spit out to the database, it's another to escape values
when feeding them to a UDF.

- Original Message -
From: "Sean Daniels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 5:06 AM
Subject: CFSCRIPT & Preservesinglequotes()


> I have written a seemingly simple UDF for cleaning up data before an
insert
> or update statement (it trims the string, inserts null when necessary,
wraps
> string in single quotes if it's a char field):
>
>
> 
> function checknull(ii,isint) {
> if (isint) {
> return iif(len(trim(ii)),de(trim(ii)),de("null")); }
> else {
> return
> iif(len(trim(ii)),de(chr(39)&trim(ii)&chr(39)),de("null")); }
> }
> 
>
> Basically, my insert statement looks like:
>
> Insert into tablename (intfield,charfield)
> Values (#checknull(intfield,1)#,#checknull(charfield,0)#)
>
> It works great except for when the charfield contains apostrophes. It
> escapes them all and the result is that twice as many apostrophes get
> inserted. I know that somewhere in here I should probably be using
> preservesinglequotes() but everywhere I attempt to use it in the UDF I get
a
> JIT compilation error. I also get a JIT if I put the preservesinglequotes
> function in the calling template
> [preservesinglequotes(checknull(charfield,0))]
>
> Any suggestions? Please? Unfortunately I used this function all through an
> app before finding the bug, so I would be psyched to make repairs to the
> function itself not all the code that uses it.
>
> - Sean
>
> ~~
> Sean Daniels
>   Director, Engineering
>   Marketplace Technologies, Inc
> (T): 207.363.7374
> (C): 207.332.6340
> (F): 240.269.6319
> ~~
>   http://www.dealforce.com
>   http://www.mergernetwork.com
>
>
>
> 
__
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 admin password

2002-03-21 Thread James Sleeman

CF servers on unix machines keep thier own "registry" files, on windows
machines they use the windows registry.

- Original Message -
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 10:30 AM
Subject: Re: CF admin password


> I know nothing of UNIX, but I do not believe it has a registry setting.
>
>
>
>
> "Success is a journey, not a destination!!"
>
>
>
> Doug Brown
> - Original Message -
> From: "Dave Watts" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 2:18 PM
> Subject: RE: CF admin password
>
>
> > > I am on a Unix System running Apache and I need to
> > > reset the CF Admin password for CF 4.5 because it
> > > was forgotten can someone tell me how to do this.
> > > Please email me off list.
> >
> > 1. Stop the CF server.
> > 2. Edit the registry file (typically
/opt/coldfusion/registry/cf.registry).
> > 3. Find the entry
> > HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword
and
> > set it to "0".
> > 4. Save the registry file.
> > 5. Start the CF server.
> > 6. Open the CF Administrator - it won't require a password - and enable
the
> > password, and set the password to the desired value.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Getting database structure from Access

2002-03-20 Thread James Sleeman

Sure, stick the following into a cfm file and give it a whirl, enter a ful
path to database (eg d:\foo\bar.mdb) where required.  Needs access installed
on the CF server machine.







 
 
  
  
  
  
 

 Examine A Database





 Enter the location of a Microsoft Access database on the system.


Database :






 
  #tableDef.Name#

   
#field.Name# (#field.Type#(#field.Size#), #field.Required#

   
 









- Original Message -
From: "Thane Sherrington" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 4:27 AM
Subject: Getting database structure from Access


> Is there a way to get database structure (tablenames, column names, and
> data types) from an Access database using ColdFusion?
>
> T
>
> 
__
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 NEEDED

2002-03-18 Thread James Sleeman

I had to do a similar thing once, take some information via CF on an NT
machine, and pass it off to a perl script on a Linux machine.  The way I did
it was to write a daemon in perl (using Net::Daemon module) which just sits
listening on a port on the linux box, then I used the TCPCLIENT custom tag
on the NT box via CF to connect to the daemon, sned the information and tell
the daemon to "do it", the daemon feeds the information to the perl script,
and goes back to listening for more connections.

- Original Message -
From: "Allan Pichler" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 8:32 PM
Subject: RE: HELP NEEDED


> Well ... the thing is ... I'm not executing any perl scripts from my cf
> machine (Win2k with IIS)
>
> That's exactly what I need . a way for the cf machine to execute a
perl
> script on another server (FreeBSD)
>
> Anyone ?
>
> @llan
>
> -Original Message-
> From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 5:18 PM
> To: CF-Talk
> Subject: RE: HELP NEEDED
>
> Golly... I'm not UNIX expert, but as long as you can find a way to
> execute your PERL script from your CF machine (is it Windows or what?)
> then you can make CF perform the execution as well.  Is there a
> webserver running on the other machine? If so, then (and its really not
> necessary but keeps you using CF) then you could use CFHTTP to run the
> script via the webserver.  If you don't want to run a webserver on the
> PERL machine and you don't presently have any way of executing the
> script from your CF machine then some custom programming is in order.
> You might be interested in writing a small application server in java,
> C++ or perl that waits for a TCP-IP request and only runs that one
> script.  It's not terribly hard to write it. I have a good book and can
> email you off line with some pointers.
>
> - Matt Small
>
>
> -Original Message-
> From: Allan Pichler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 11:03 AM
> To: CF-Talk
> Subject: RE: HELP NEEDED
>
> Well ... the problem is that the other box is a FreeBSD box! Can I use
> cfexecute to solve my problem
>
> @llan
>
> -Original Message-
> From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 5:04 PM
> To: CF-Talk
> Subject: RE: HELP NEEDED
>
> That is, using CFEXECUTE.
>
> - Matt Small
>
>
> -Original Message-
> From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: HELP NEEDED
>
> Just thinking here...
> Why don't you write a batch file on your CF server that executes your
> perl script on the other server?
>
> - Matt Small
>
> -Original Message-
> From: Allan Pichler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 10:24 AM
> To: CF-Talk
> Subject: HELP NEEDED
>
> I have a little problem guys and i need your help!
>
> I've made a little perl script that runs every 5 minutes, it checks a
> MySQL
> DB to see if there's any mailjobs scheduled that needs to be executed.
>
> If there's jobs in queue it runs another perl script with the id of the
> mailjob as an argument.
>
> Now my problem is this ... I'm making a web interface to setup the
> mailjobs,
> and in this interface I would like to have a "Test Mailjob" button that
> shows a form where the user can specify a test email account to send X
> test
> mails to.
>
> How do I get CF to execute a perl script on another server with some
> commandline arguments 
>
> Please help out if you can!
>
> @llan
>
>
>
>
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
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: SUCCESS!!!

2002-03-12 Thread James Sleeman

A note on that - expandpath, getcurrenttemplatepath and
getbasetemplatepath (did I forget any ?) will get you the full path to
your files - which can be quite handy stuff to know for advanced
applications.
#ExpandPath('./')##GetDirectoryFromPath(GetCurrentTemplatePath())##GetDirectoryFromPath(GetBaseTemplatePath())#

On Wed, 2002-03-13 at 09:26, [EMAIL PROTECTED] wrote:
> Thank you.  It worked!
> 
> D-
> > Did you try #ExpandPath("filename.gif")#?

---
James Sleeman

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Setting a dynamic variable...

2002-03-11 Thread James Sleeman

> "session.#attributes.CartName#" = StructNew();
> "session.#attributes.CartName#.items = ArrayNew();
>
> Which seems to work fine, however if I try the following line:
>
> "session.#attributes.CartName#.items[1] = "blahblahblah";
> or
> 
>
> I get the following error:
>
> ---
> Cannot set dynamic variable with name 'session.myCart.items[1]'. The
variable name is illegal. Variable names
> must start with a letter and can include only letters, numbers, and
underscores.

It would be better to treat the session structure as an associative array...

session[attributes.cartName] = StructNew();
session[attributes.cartName].items = ArrayNew(1);  // Note you missed the 1
in this...

session[attributes.cartName].items[1] = "blahblahblah";

that way you get away from that whole hacky way of setting dynamic
variables.  You could also use setVariable - but I think this way is cleaner
personally.

---
James Sleeman

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Trim in SQL

2002-03-04 Thread James Sleeman

- Original Message -
From: "Ben Forta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 3:07 PM
Subject: RE: Trim in SQL


> There is no TRIM(), but there is a RTIM() and a LTRIM():
>
> SELECT foo from bar
> WHERE RTRIM(LTRIM(narf)) is like 'blah'

Thanks, unfortunatly it's not quite the same - it only trims spaces (maybe
tabs too, didn't test), not other whitespace like (specifically) CR and LF.
I have done the following instead, but it's a bit hacky...

Replace(Replace(narf, Char(10), ''), Char(13), '')

---
James Sleeman
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



OT: Trim in SQL

2002-03-04 Thread James Sleeman

Anybody know if there is a way of doing something like the following with
SQL server

SELECT foo from bar
WHERE TRIM(narf) is like 'blah'

---
James Sleeman
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



get modification date of file via http

2002-03-03 Thread James Sleeman

Hi all,
anybody know if there is a way of getting the modification date of a
file without retrieving the entire file using CFHTTP.

Essentially what I want to do, in pseudo code is



Download file


i.e the same thing that a web browser cache might do when requesting  file -
if the header indicates the URL is newer than the file in the cache,
download it, otherwise use the cached version.

---
James Sleeman
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Displaying Please wait message during a process

2002-03-02 Thread James Sleeman

On Sat, 2002-03-02 at 04:11, Mark Leder wrote:
> I have a template that I want to display "Please wait" text, then
>  go 
> through a CFIndex Process, with a "complete" message when done. 
>  This 
> is displayed in a pop-up window.  I find that when the CF process
>  
> starts, the window goes blank until the process is done, then 
> displays all the text.  I've tried a CFFlush on the "please wait"
>  
> prior to the process, but then the process hangs.  I've also
>  tried 
> wrapped CFSilent around the process, to no avail.
> 
> What's the right way to do this?

CFFLUSH should do the job, but remember some browsers won't display
anything until thier buffer is full.  The way to do this before CFFLUSH
existed was to put an intermediate page in, lets say your long process
happens on a form submission - you make the process look like

SUBMIT FORM => "PLEASE WAIT" Page => Process Form

where you submit the form to the please wait page, which includes a
hidden form to pass the data on to the real processing.  In the onload
of the please wait page you submit the form.  Thus the please wait page
will hang about on screen until the processing returns it's data.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Regular Expression Help

2002-03-02 Thread James Sleeman

On Sat, 2002-03-02 at 10:10, Jared Stark wrote:
> Hello all.  I am trying to write a simple search engine, and would like 
> to replace certain commonly used prepositions from the search string 
> such as 'a','the','for', etc...
> 
> I have an array of the prepositions that I would like to remove, however 
> the problem I have is that it is removing them when they are subsets of 
> other words, for example 'them' would become 'm' when removing 'the', 
> 'bag' would become 'bg' when removing 'a', etc...  
> 
> I'm not an expert at regular expression, but I'm assuming it is possible 
> to remove only those instances where the prepositions are stand-alone 
> and not subsets of other words.  Could someone render me some 
> assistance?

If you want to use regular expressions to do it, easiest way would be to
use the character class for whitespace before and after your
preposition.

However don't underestimate the power of the CF list processing
functions, think of your search term as a list seperated by whitespace
and you can use any of the CF list functions.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Attaching CSS style sheet

2002-03-02 Thread James Sleeman

the  tag should always appear in the  section of
the generated HTML document, unless your application.cfm also includes
this section, putting the  in there would cause it to appear
outside the  section.  

i.e it's makes for bad HTML.

On Sat, 2002-03-02 at 10:06, WebMaster wrote:
> What's the problem with referencing the stylesheet in the application.cfm 
> file? I have done this on several websites and never seen a problem before.
> 
> Here's the code I use:
> 
> 
> 
> Is there an issue with doing it this way?
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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 : Submit file field form via javascript

2002-02-28 Thread James Sleeman

At 08:31 PM 2/28/2002, you wrote:
>I think it has something to do with the security in the browsers.

Yea I think it's to stop you from silently uploading files from the user's 
machine.. eg
onLoad = document.forms[0].fileField.value = 'C:\SomeSecretStuff.txt'; 
document.forms[0].submit()
a real PITA though.

>I did a search on it, and found several discussion boards with people
>asking about that.
>They wanted to use an image though instead of a button to do what you
>are wanting to do.
>But noone can get it to work, they get access denied.
>http://www.siteexperts.com/forums/viewConverse.asp?d_id=7741&Sort=0

Yeah that's more or less what I want to do.  Looks like I'm outa luck.

>The only way I was able to get it to semi-work was to set the width of
>the file field to 80, so it sort of hides the text part, and click on
>the browse button.
>
>
>
>style="width:80px">
>
>

I hadn't thought of that.



James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



OT : Submit file field form via javascript

2002-02-27 Thread James Sleeman

Anybody know if there is a way to submit a form containing a file field via 
javascript whilst retaining the contents of the file field ?  IE seems to 
(I'm presuming for security reasons) not allow this.  Specifically what I 
want to do is...


   

but as soon as the javascript goes to submit the form the contents of Foo 
get scrubbed.

Ideas anybody ?
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



Bug Tracking Systems

2002-02-27 Thread James Sleeman

Hi all,
I'm thinking about offering a bug tracking system for our clients (during 
testing stages of course, I'd never have a bug in a production system :-)) 
for the various jobs they have running with us (i.e we'd have a number of 
projects with each client that they can open bugs with, but each client may 
not see another clients projects or bugs).

Before I invest energy into reinventing the wheel, does anybody know of any 
bug tracking systems written in CF that I might be able to massage to fit 
my needs ?

---
James Sleeman
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: This is cool.. Doable??

2002-02-26 Thread James Sleeman

At 11:22 AM 2/27/2002, you wrote:
>Adam,
>
> > hmm - wouldn't that also block search spiders as well? I can imagine they
> > spider fairly quickly throughout your site. This may be your desired
> > functionality however.
>
>You are right, I guess I could add a simple filter using CGI USER AGENT
>and sort out fast/altavista/google and other search engines I know about
>(and care about).

Spiderhunter.com has data available on the IP's useragents and DNS of 
spiders around the place, I've used it to do spider detection work in the 
past (and may do so in the future too when I get around to it :-)).

http://www.spiderhunter.com/spiderlist/index.cfm?FuseAction=Results&Key=1470.26536188&SearchEngineIDLink=-1&ReportFormat=1&information=2



James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Recursion of UDFs

2002-02-25 Thread James Sleeman

At 11:33 AM 2/26/2002, you wrote:

>to populate this struct, but my UDF does not continue looping after the
>first recursion call.

Oh man, I spent most of yesterday debugging a seemingly simple recursive 
UDF, I was so sure it was all correct, just couldn't work out what was 
going on.  Until I finally realised, that I hadn't created my "local" 
variables as

 var localVariable = "";

but instead had just done

 localVariable = "";

causing, of course, localVariable to in fact be a global variable, so of 
course, my recursive calls were thoroughly munging what I thought were 
untouchable local variables, causing all manner of mayhem.

Oh for compiler warnings :-)



James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



joining arrays

2002-02-24 Thread James Sleeman

Hi all,
 anybody know if there is a nicer way of joining arrays in CF than

 i = 1;
 while (i lte arrayLen(secondArray)) {
 arrayAppend(firstArray, secondArray[i]);
 };




James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: SQL trickyness

2002-02-24 Thread James Sleeman

At 08:50 PM 2/22/2002, you wrote:
>What about this hack?
>
>SELECT TOP 1
> (SELECT TOP 1 TipID
> FROM TIPS
> WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink#
> ORDER BY TipTitle ASC) As FirstTip,
> (SELECT TOP 1 TipID
> FROM TIPS
> WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink#
> ORDER BY TipTitle DESC) As LastTip
>FROM TIPS
>
>I tried the Last() and First() functions and they didn't work in Query
>Analyzer (on 7 and 2K).  Weird.

Ahhh, I didn't think of that, brilliant :-)

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: SQL trickyness

2002-02-21 Thread James Sleeman

At 04:12 PM 2/22/2002, you wrote:
>James,
>
>Rather than using Last() and First(), try Max() and Min().  Also, try adding
>in a GROUP BY clause.  Adding it in always seems to fix the error messages
>about aggregate functions.

Min and Max will give me the minimum and maximum values without regard to 
where they occur in the recordset, I want the first and last values as they 
appear in the recordset

eg  if the select gives a recordset like

[ID][TITLE]
  1Bar
  3Foo
  2Goop

I want to get

[MinimumID][MaximumID]
  1 2

using a group by would give me

[MinimumID][MaximumID]
1   1
3   3
2   2

(because titles are unique).



James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: SQL trickyness

2002-02-21 Thread James Sleeman

It goes away but it won't give me what I want - I effectively want one 
group, that would give me as many groups as there are unique tiptitle values
 ?

At 04:22 PM 2/22/2002, you wrote:
>Whenever you use aggregate functions in SQL, you need to add a group
>by
>clause that contains the fields that you're not aggregating on.  That
>  would
>be stuff in your select and in the order by.  So, add a "group by Tip
>Title"
>before the order by and your error should go away.
>
>-Original Message-
>From: James Sleeman [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, February 21, 2002 8:01 PM
>To: CF-Talk
>Subject: SQL trickyness
>
>
>Hi all,
>  trying to do a little funky SQL to get the minimum and maxim
>um
>ID's with respect to a sort order on a table but I'm getting an acces
>s
>error, cam anybody see what is wrong with my sql here...
>
>DBTYPE="#CFG.DBTYPE#" NAME="Q_Tips">
>  SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP
>  FROM  TIPS
>  WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLi
>nk#
>  ORDER BY  TipTitle ASC
>
>
>
>
>Error Diagnostic Information
>ODBC Error Code = S1000 (General error)
>[Microsoft][ODBC Microsoft Access Driver] You tried to execute a quer
>y that
>does not include the specified expression 'TipTitle' as part of an
>aggregate function.
>SQL = "SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP
>  FROM
>TIPS WHERE TipTipCategoryLink = 1 ORDER BY TipTitle ASC"
>Data Source = ""
>The error occurred while processing an element with a general identif
>ier of
>(CFQUERY), occupying document position (20:2) to (20:104) in the temp
>late
>file
>D:\JOBS\WEB-FUSION\WEBSHOPCODEBASE\_MIRROREDFILES\BFD5C5FB051709B72C9
>FF321B6
>2A465C\PLUGIN_SHOWSTUFF\QRY_SHOWTIP.CFM.
>Date/Time: 02/22/02 16:02:18
>Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
>Remote Address: 10.10.10.105
>Query String:
>FuseAction=showTip&TipID=7&CFID=6778&CFTOKEN=31983074&ForceUp
>date=1
>
>
>
>
>James Sleeman
>Innovative Media Ltd
>Phone: (03) 377 6262
>http://www.websolutions.co.nz/
>
>CAUTION: The information contained in this email message is confident
>ial
>and may be legally privileged. If the reader of this message is not t
>he
>intended recipient you are notified that any use, dissemination,
>distribution or reproduction of this message is prohibited. If you ha
>ve
>received this message in error please notify the sender immediately a
>nd
>destroy the original message and any attachments.
>
>Views expressed in this communication may not be those of Innovative
>Media
>Ltd.
>_
>_
>Get Your Own Dedicated Windows 2000 Server
>   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
>   Instant Activation · $99/Month · Free Setup
>   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
>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
>
>
>
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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



SQL trickyness

2002-02-21 Thread James Sleeman

Hi all,
 trying to do a little funky SQL to get the minimum and maximum 
ID's with respect to a sort order on a table but I'm getting an access 
error, cam anybody see what is wrong with my sql here...


 SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP
 FROM  TIPS
 WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink#
 ORDER BY  TipTitle ASC




Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that 
does not include the specified expression 'TipTitle' as part of an 
aggregate function.
SQL = "SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP FROM 
TIPS WHERE TipTipCategoryLink = 1 ORDER BY TipTitle ASC"
Data Source = ""
The error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (20:2) to (20:104) in the template 
file 
D:\JOBS\WEB-FUSION\WEBSHOPCODEBASE\_MIRROREDFILES\BFD5C5FB051709B72C9FF321B62A465C\PLUGIN_SHOWSTUFF\QRY_SHOWTIP.CFM.
Date/Time: 02/22/02 16:02:18
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 10.10.10.105
Query String: 
FuseAction=showTip&TipID=7&CFID=6778&CFTOKEN=31983074&ForceUpdate=1




James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Dynamic Include

2002-02-19 Thread James Sleeman

At 10:24 AM 2/20/2002, you wrote:
> > What is the best way to allow someone on another Web server
> > which will not
> > necessarily have CF on it to imbed a call to a CF page on my
> > server. Where
> > my page would do some database lookups and return some HTML
> > that would be
> > imbedded in the original page (not a redirect).
>
>Lee,
>
>You could do this:
>
>  http://www.yourdomain.com/filename.cfm"</A>;>
>
>where filename.cfm would use cfcontent to set headers that would trick the
>browser into thinking it was a JavaScript file, and then use valid
>JavaScript in that file to write the content to the screen. It can be a
>chore converting your CF output to valid JavaScript, however.


Wouldn't you just catch all the output of your template (CFSAVECONTENT in 
CF5, make a custom tag previously) and use JSStringFormat() to convert to 
javascript ?

eg...


 
 This Is A Page
 
 Foo Bar Bar Foo
 Any stuff you want in here, cf stuff, html stuff, 
whatever...
     
     


 <CFOUTPUT>document.write("#JsStringFormat(TheRealOutput)#");





James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



Query of Query problem

2002-02-18 Thread James Sleeman

Anybody know if this is a known bug in CF ?

This query


 SELECT * FROM Q_Table
 WHERE FrWMin <= #Weight#
 AND   ((FrWMax > #Weight#) OR (FrWMax = ''))


produces a single row with value of 15.0 in the FrZWPrice field

but this query


 SELECT Max(FrZWPrice) AS Price FROM Q_Table
 WHERE FrWMin <= #Weight#
 AND   ((FrWMax > #Weight#) OR (FrWMax = ''))


ignores the where clause and simply returns the maximum FrZWPrice, which in 
this instance is 55.0



James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



Getting locale's date format

2002-02-12 Thread James Sleeman

Hi all,
is there any way to get a string representation of the currently set locale's 
date format, ie something like "dd/mm/" or 
"mm/dd/".  Seems that I can parse dates in the locale's date format but you can't 
find out programattically what that date format is.

I want to do soemthing like... 

Please enter dates in #GetLSDateFormatString()# format.


---
James Sleeman

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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:Pausing execution

2002-02-11 Thread James Sleeman

"Kay Smoljak" <[EMAIL PROTECTED]> wrote on 2/12/2002 4:46:30 PM:

>Has anyone used this tag? I don't mind forking out the $5 (actually $10
>in Australian pesos) but does it really work? Does anyone have a better
>way of delaying the user for a certain amount of time?

I would use a deadlock situation to my advantage...






the first lock will obtain fine, the internal lock won't be able to because DummyLock 
is already locked, after 2 seconds it will timeout without an 
error and  continue on it's merry way.



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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:[2] Jeremy Allaire interview on DevX

2002-02-07 Thread James Sleeman

Jon Hall <[EMAIL PROTECTED]> wrote on 2/8/2002 6:24:23 PM:
>
>stas wrote:
>> So you want to design your GUI in Flash 
>
>I want to design a GUI with the tool that gives me the most power, with 
>  the least amount of code.

It would take considerably longer I believe to implement a competent gui in flash than 
to hand code in your toolkit of choice in 
compiled/interpreted language (eg Swing on Java, GTK in C, TK In Tcl, wxWindows in 
Python).

>> re-invent every little widget?
>It's called originality. Take an html select box widget for example. It 
>takes almost no code to create and stlye to create any kind of look 
>compared to what it takes to create in say CSharp, which I have been 
>working with lately. I long for style sheets when doing a form 
>component, just because it's what I'm used too.

It's called consistency, and that is the driving force behind toolkits in the first 
place, it is much easier for the user if one programs "checkbox" 
looks and works the same as other program's checkboxes. Not to mention that it vastly 
increases code reuse and helps to enforce a modular 
approach for the engineer.  Flash isn't designed to be an interface toolkit, it is 
designed to deliver animation and whizzy interactive things, let it do 
what it's best at, leave the interface display to the various libraries designed to be 
interface toolkits (and in the case of web sites, to the HTML).

---
James Sleeman

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



OT: OBJECT tag for java plugin and IE

2002-02-07 Thread James Sleeman

Hi all,
I have a system where I have a large amoutn (or will have a large amount :-)) 
of "distributed front ends" to ecommerce sites, they 
basically consist of images, and a couple of dummy fusebox files that call a set of 
shared code sitting away on another server.  Anyway, I want to 
add a java applet I have written into an area of the system, but my problem is that I 
don't want to have to put the JAR files in with the front-end 
code.  So I thought I'd do something like...

http://java.sun.com/products/plugin/1.1.2/jinstall-112-win32.cab##Version=1,1,2,0";>







that's obviosuly the OBJECT tag for getting the java plugin in IE to run my applet, 
notice the codebase, I'm telling it to get the jar files from this 
"directory" (which is really a search-engine-friendly url to a fuseaction that will do 
a cfcontent to return the requested jar file).  Now, while this 
works fine in mozilla (with an equivalent applet tag instead of the object tag), IE 
just doesn't like it.

Does anybody have any idea why this wouldn't work ?  

NB: I've tested the applet in IE and it works fine, it's just when I try and reference 
the jars in this manner that it fails.

---
James Sleeman

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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



ReReplace(NoCase) maximum length

2002-01-31 Thread James Sleeman

Hi All,
anybody know if there is a maximum length on the string passed to 
ReReplace(NoCase) ?  Reason I ask is that I am running the following 

ReReplaceNoCase(trim(text), "^(.*)$", "\1");

and when the string in text is above a certain length (don't know how 
long exactly) the code fails with an Invalid regular expression message.
  I cut the offending text in half (it's comign from a database field 
  (the data in the field is fine, all there, all returned in query)) 
  and each half goes through just fine, but put em togethor and I get 
  the error.  Hopefully the "designers" won't mind me splitting thier 
  page into two (stupidly long anyway) :-) 

---
James Sleeman

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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



little OT, getting DataTypeEnum from DAO

2002-01-29 Thread James Sleeman

Hi all,
I'm doing a little experimentation with getting table & field information 
from Access using some code Brendan Avery posted (RE: SQL for grabbing list 
of tables in DB / fields in table?). My intention is to use this 
information to further automate the creation of administration systems.

Anyway, I've got it sussed to the point of being able to get the table 
names, field names, types, sizes, wether they are required etc, however the 
types are defined as an integer which is identified by a DAO constant.

Now, I know nothing really about this whole COM business, I used "Object 
Browser" in access and found DAO.DataTypeEnum holds all these constants, 
but how do I get that information into CF ?

Here is the code as it stands...








#tableDef.Name#


#field.Name# (#field.Type#, #field.Size#, #field.Required#)





Anybody here a COM guru :-)


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Quick cfdirectory ?...

2001-12-11 Thread James Sleeman

At 03:01 PM 12/12/2001, you wrote:
>Is it possible to keep the "Dir" Types out of my query for cfdirectory?
>With a filter maybe?  This is what I got's:
>
>directory="#request.Path.FileDir#filez\">
>
>and it returns:
>
>".", "..", "file01", "file02", "file03", etc.  Can I throw a filter
>attribute on the cfdirectory?  I can figure out how to make it return all
>the *.wma files, but I can't figure out how to just give me back Type=File,
>(Type is a returned column when using cfdirectory) and not the Type=Dir.
>And I've got it doing basically what I want, which is excluding the Dir
>Types, with some cfifs, but I'd rather leave them out of the over all
>picture.  Any assistance would be greatly appreciated...


Mmm, I don't think there is a way to do it directly with the cfdirectory 
tag.  If you are runing CF5, you can just do a query of the query that 
cfdirectory returns to get all the type='file' or type='dir' records.  If 
you are not yet on CF5 you could build another query manually (using 
combinations of queryNew(), queryAddRow(), querySetCell()) from the query 
that cfdirectory returns, opnly inserting those rows you want (i.e where 
type eq "file").




James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
~~
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: Templates executing twice CF bug

2001-12-11 Thread James Sleeman

Ok, here is what I see is hapenning in this situation (and it is NOTHING to 
do with CF or IIS or anything server side here), quite simple... let's take 
for exampl the _URL_) you are using in the src of your img tag it has a bit 
before the first #  which in this case is an empty string, and a bit after 
the first # which isn't important for now.  What does this remind you 
of perhaps something like foo (by now 
you probably see your error but I'll continue for those who it is not 
obvious to).  What that anchor does is tells your browser to get blah.htm 
and display it from the point in the document that the anchor named 
someAnchor appears.  You canm just as easily write foo which tells the browser to go to the point in the 
document where the anchor someAnchor appears.  Both of these are valid 
URLS.  The src in an image tag takes a valid URL.  So in your example img 
tag below, when the browser gets that (the hashes come through because 
there is no cfoutput around it) it reads that as "load the image from the 
current document at the point where the anchor 
"variables.someVariable#/test.gif" is written" (which of course makes no 
sense, but the browser doesn't care, all it wanted was a URL and you gave 
it a URL), it does it's duty, the img tag causes  the template to be hit 
again, and when it gets the results it tries to the anchor you specified 
(which of course doesn't do anything because not only does the anchor not 
exist, but that file isn't an image either).  Now of course this may not 
happen on all browsers, mainly because if they are clever enough they will 
not have to actually hit the server to get the same file they are looking 
at, and if they are really clever enough they will know that an anchor 
specification inside an img src is nonsense and will ignore it.

Nothing mystical, just not an expected behaviour on behalf of web browsers.

At 05:29 PM 12/11/2001, you wrote:

>


James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media Ltd. 
~~
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: MS Access: True/False Questions

2001-12-05 Thread James Sleeman

First IANAL (nor have I actually read the GPL in a long time), but the way 
I understand it.  They are completely within their rights to sell a 
closed-source version of their software if they wish to do so.  Them 
releasing a GPL'd (is it GPL'd?) version does not in any way prohibit them 
from also releasing a closed-source version - it's their 
software.  Likewise they could just as easy stop releasing the GPL'd 
version and start releasing a closed version instead.  The only caveats 
are... if there is source from contributing developers then that source 
remains the contributing developer's source licensed by the license the 
contributing developer released it under (ie GPL, wether directly or 
indirectly through becoming part of the GPL'd mySQL) and as such the 
company would have to either not include the contributed code or obtain a 
different license for said code from the contributing developer, and if 
they were to withdraw the GPL'd version from release existing copies in the 
world remain GPL'd (and thus a source fork would likely begin).


Of course this is all totally OT.  So to bring it back some, when I was 
playing with CF on linux I looked at using mySQL but the limitations 
(especially on no sub-selects which is something I use often and am not 
willing to give up without a fight !) were too great, postgres on the 
otherhand worked very well, nice and fast, I've heard that the Vacuum() 
procedure which must be run periodically can be a bit of a pain - tying up 
the database for inordinate amounts of time, but I guess replication or 
something could get around that for large scale sites.  And of course it's 
free :-)

At 01:35 PM 12/6/2001, you wrote:

>If MySQL was allowed to sell a closed version of it's software, instead of
>having to sell overpriced support contracts it would be much more
>successful.





--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media 
Ltd.

~~
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: MAC File Upload Issues

2001-12-03 Thread James Sleeman

As I remember IE on the Mac messes up when uploading files, I had the same 
problem a couple of years ago and found no solution.  Use Netscape to 
upload files and your problems will disappear :-)

>I'm uploading a file via CFFILE and the code works flawlessly - until you
>get onto a MAC (IE5)



--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media 
Ltd.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
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



BUG In CF5, is it known ?

2001-12-03 Thread James Sleeman

I had an old client come to me with a bug today.  The server was upgraded 
to CF5 a while ago and this bug seems to be related to that... basically I 
was using a variable called "Arguments", and it was producing an "unknown 
exception" from CF, simply changing the variable to be called "Argies" 
fixed the problem - after an hour of bug hunting of course !

So, this doesn't work...


 



while this one does...


 


it's all in a standard single file template, not fusebox, nothing fancy 
happening, just a simple file.  The error message that CF produced wasn't 
helpful at all basically claiming that an unknown exception occurred but 
didn't say where. Arguments is the array used within a UDF, seems wierd 
that it shoudl cause problems OUTSIDE of CFSCRIPT let alone UDF's.



--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media 
Ltd.

~~
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



  1   2   >