Re: WDDX Replacement Attempt (was RE: Ajax and CFCs)

2005-08-18 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Why not dpxl, seeing as it's not a markup language so much as a data
transfer language that happens to an XML application?

Jim Davis wrote:

+) Something that's easy to parse for JavaScript.  SOAP is NOT easy to
 parse (which is, I think, why there's no generalized SOAP parser for JS).
 
 +) Something that maintains general data types.  SOAP maintains complex
 datatypes (based on Java or C+).  JSON doesn't offer data typing at all.  I
 thought we needed a middle ground.

Not quite true. The data typing in JSON is implicit. Of the types listed
below it can unambiguously represent object, array, null, string,
string, boolean, and number. It's all implicit in the syntax. Dynamic
typing doesn't imply weak typing, nor does a paucity of type annotation
imply dynamic typing. For the former, see Python, which has strong
dynamic typing, and for the latter, see Haskell and ML, which both have
strong static typing through use of type inference[1].

If you're willing to extend things a little bit by including the syntax
new X(comma seperated list of elements), you can represent dates and
binary data too. I don't see any need for undefined, which can be
denoted by simple absence of data, or function, which ties things to
JavaScript even more tightly, in which case you'd might as will go the
JSON route anyway.

That said, I'm not arguing in favour of JSON so much as pointing out
that by perceived typelessness on its part is not quite the case.

I'd include some kind of explicit recordset type too.

 Three tags only (I decided to minimize them to abbreviations since I'm only
 using two tags):
 
 dataML: This is the wrapper tag for the packet.  It can contain, first,
 any number or zero md tags and one d tag.
 
 d: Data.  This tag contains the data items.  It can contain as many
 other d tags as you like in an orgasmic orgy of nesting.  (By having only
 one tag we eliminate problems that XSD has with randomly appearing child
 tags.)
 
 It take three attributes:
 
   type: The type of the data.  I settled on using JavaScript's
 generalized types (plus the addition of binary).  If not provided the data
 type will default to string.   Possible values are:
   +) object (equivalent to a CF Struct)
   +) array (single dimensional with sparse arrays supported)
   +) null
   +) undefined (I'm not sure if this is actually needed yet)
   +) string
   +) number
   +) boolean (true or false are the only acceptable
 values.)
   +) date
   +) binary (BASE64 Data)
   +) function (representing a JavaScript function.

I'd say it would actually be less bulky if you changed the names of the
types into tags.

d type=null/
null/

d type=booleantrue/d
booleantrue/boolean

 dataML
   d type=object fields=fname, mname, lname, 
  d type=stringJim/d
  d type=null /
  d type=stringDavis/d
   /d
 /dataML

dpxl
   object fields=fname,mname,lname
   stringJim/string
   null/
   stringDavis/string
   /object
/dpxl

{fname: Jim, mname: null, lname: Davis}

 Where a simple record set could look like this:
 
 dataML
   d type=array
 d type=object fields=text, value,
d type=stringFund One/d 
d type=stringFund01/d 
 /d
 d type=object fields=text, value,
   d type=stringFund Two/d 
   d type=stringFund02/d 
 /d
 d type=object fields=text, value,
   d type=stringFund Three/d 
   d type=stringFund03/d 
 /d
   /d
 /dataML

dpxl
array
object fields=text,value
stringFund One/string
stringFund01/string
/object
object fields=text,value
stringFund Two/string
stringFund02/string
/object
object fields=text,value
stringFund Three/string
stringFund03/string
/object
/array
/dpxl

[
{text: Fund One,   value: Fund01},
{text: Fund Two,   value: Fund02},
{text: Fund Three, value: Fund03}
]

 But over large numbers of records the repetition of the metadata would
 inflate the packet terribly.  So we use the md tag like so:
 
 dataML
   md label=option
 d type=object fields=text, value,
d type=string /
d type=string / 
 /d
   /md
   d type=array
 d label=option 
dFund One/d 
dFund01/d 
 /d
 d label=option 
   dFund Two/d 
   dFund02/d 
 /d
 d label=option 
   dFund Three/d 
   dFund03/d 
 /d
   /d
 /dataML
 
 This shrinks the serialized version of the data tremendously when you want
 to return large numbers of similar objects (as with a record set).

I'd like to point out that here the md tag is essentially defining a
new type, so you could change this to:

dataML
type name=option
d type=object fields=text,value
d type=string /
d type=string /
/d
/type

d 

Re: WDDX Replacement Attempt (was RE: Ajax and CFCs)

2005-08-18 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jim Davis wrote:

-Original Message-
From: Keith Gaughan [mailto:[EMAIL PROTECTED]

Not quite true. The data typing in JSON is implicit. Of the types listed
below it can unambiguously represent object, array, null, string,
string, boolean, and number. It's all implicit in the syntax. Dynamic

 That's true I guess.  But there IS more: JSON also can't represent
 non-numeric keyed arrays (something called JavaScript Hashtables) for
 example.

Ah, but isn't that what an object in JS(ON) essentially is?

{
I am: a string-keyed,
array or: a hashtable,
if:   you will.
}

 I'd include some kind of explicit recordset type too.
 
 I consider that for a long... long time... but decided against it.  Any
 representation of a recordset I've ever seen is either column-based (which
 is an object whose properties are arrays) or record-based (which is an array
 of objects).
 
 Both of these representations can be done using Arrays and Objects so why is
 it really needed?  Either we create a custom RecordSet object in JS or we
 convert it to the native data types... but since the latter is just as easy
 as the first for JS why bother?

True, but I was thinking that it might be nice to annote it as such.

 The main problem here is that it's impossible to describe such a language an
 XSD (unless you allow any tag - which includes xHTML, made up tags, etc -
 in any place).  XSD only allows a tag to contain ordered tags or any tags
 (so the former would force us to say that object must appear before
 array which must appear before string and so forth - which makes the
 serialization an order of magnitude more complex).

Hmmm... I heard XSD was a bit odd, but I didn't think it was *that* bad.
Holy crap! I think I'll stick with DTDs then.

I'd like to point out that here the md tag is essentially defining a
new type, so you could change this to:
 
 I could... but in keeping with the theme, if I did do it would probably be a
 dt (data type) tag.  ;^)

Fairy nuff. :-)

Should such a thing force all children of the array to be the same?

Yes, unless you want to reserve the undefined type for use in md to
represent somewhere where the types are specified in the body.
 
 I was thinking more organically on this one.
 
 My thinking would be that the type would only apply as a mask to the
 linked elements.  So, if a child tags type was defined it would apply it, if
 not it wouldn't.  If it defined an object but no properties then that
 object could have any properties.

You could do that alright. I was just thinking of a situation where you
might have something like this:

dt name=wotsit
d type=array
d type=object fields=id,name,value
d type=number/
d type=string/
!-- The next element could have any type: do we use... --
d/
!-- Or... --
d type=undefined/
/d
/dt
/dt

Where the value might be an object or an array of objects.

 This is one reason that I'm NOT super comfortable with the type concept...
 it seems to imply a full definition when it could only part of one.

Nah, types can be just partial definitions of what's going on too.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDBLk0mSWF0pzlQ04RArLqAKDAsLs7RDuzsykZFgVRVoQ+5rjzegCfTESs
dHAnWesEpA5/BmCam4IiXKI=
=rFSC
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: WDDX Replacement Attempt - Name?

2005-08-18 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jim Davis wrote:

 DPXL: (Depressed Press Transfer Language) - the professional side of me is
 leaning here.  It puts my company right in the name!  But how smart is it to
 put a trademark in the name of something you're open-sourcing?

Well, seeing as I came up with it first, how about OXL or ODXL? They
don't seem to be taken.

OXL  = Open Transfer Language.
ODXL = Open Data Transfer/Exchange Language.

Both suitably corporate and FOSS friendly.

 I'm really leaning towards a non-abbreviated word... something that means
 move or transfer but maybe even with a sense of irony or humor.
 Wormhole perhaps?DataSphincter? 
 
 Or perhaps a fun abbreviation? STAPOD (Specification That Allows Passing
 Of Data)?  MOPD (Method of Passing Data)? NARDS (No Assembly Required
 Data Specification)?  (This has the benefit that, if it takes off, I may
 someday hear somebody say Were you able to parse my NARDS?)

How about ZAPHOD: Data Transfer Language With No Real Acronym?

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDBPQ1mSWF0pzlQ04RAnVAAJ4gsru3iCEI6dxuYvzH3peQrhPyHACgwrJz
QsAbaVYJfAnqw0FvdZnCFFw=
=cd5q
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Oh..my...god!

2005-07-06 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

S.Isaac Dealey wrote:

 The combination of ColdFusion and the placement of the MM home page
 banner ad... There have been continual occasional complaints from
 people on the mailing lists that these two things never coincide, even
 when the best Macromedia can produce in terms of non-CF related
 banners for their home page is some random website using Flash that
 royally sucks. Some have used the lack of CF banner adds on the
 Macromedia.com site as fuel for wild speculation that maybe CF isn't
 as important to MM or that maybe they're planning to discontinue it --
 all of which is of course nonsense -- though the rumor-mill ends up
 being somewhat similar to the rumor-mill responsible for Learn
 ASP.NET Now! Microsoft to purchase Macromedia!.

Macrobesoft? :-)

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCzAYAmSWF0pzlQ04RAtMyAKDDv0uYpK6C60WtPNWnulpYLnx8XgCePBpe
WJSKVjNxhnSZ14a7Dggc8pI=
=klf1
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Frigging annoying Checkbox behaviour

2005-07-06 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Claude Schneegans wrote:

 So it's a problem with CF or with both browsers.
 
 It's a problem with the HTML standard. There should exist some DEFAULT 
 attribute for controls.
 ie: INPUT TYPE=checkbox NAME=myCheckBox VALUE=on DEFAULT=off
 
 Fortunately, there is a DEFAULT option in CFPARAM

Is it really a problem? I think the assumption is that the defaults will
be supplied on the server anyway seeing as you should check that all
the required fields are present as part of validation anyway. That is,
after all, part of the reason why cfparam exists.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCzAmXmSWF0pzlQ04RAuwJAJoDno/jgmWJ6JcayIxic5nEx+pDjgCgqSK4
81BMPqhEqzpMemPw3LzKRMk=
=35Ml
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: CFFLUSH

2005-07-05 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Ian Vaughan wrote:

 I am using CF7, what is Asynchronous CFML. ? 

It's CFML with added ninjas, lasers, coroutines, and partial
continuations. :-)

Ok, so I'm kidding. I think Neil's getting gateways mixed in with
this by accident. Gateways, of course, have absolutely nothing to
do with solving the problem.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCykiMmSWF0pzlQ04RAqs7AJ4vxvBrqw9ym9HQzIxjSshXUq0AugCgn0UO
DOvkTKGTUK7OMiTOx0DlHJg=
=I019
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Best Subversion book for Dummies

2005-07-01 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Stan Winchester wrote:

 I've never gotten a Dummies book except as a gag, but we tried CVS a while
 back and we got too many errors during the learning process; I'm sure they
 were all user errors and we eventually gave up. Subversion sounds great, but
 before we make the jump I would like to find the best Subversion
 book/tutorial available to help us through the learning curve and to help us
 minimize the user errors. I would greatly appreciate some recommendations
 for the best Subversion for Dummies book/tutorial available for easy
 integration with HomeSite+.

The Subversion book[1] is quite excellent. It contains (almost)
everything you need to get started.

However, if you're setting up a Windows box to act as your repository
server, at the current moment I'd avoid going with the Apache/WebDAV
method, and instead use svnserve. Trying to get the Subversion WebDAV
libraries and Apache's mod_dav to play nice with one another caused me
nothing but grief.

The svnserve program isn't a Windows service, so you'll need something
so you can set it up as one. If you've the Server 2003 Resource Kit,
you can use the instserv and srvany tools to wrap svnserve as a service.
Alternatively, try the SVNService[2] tool, which wraps svnserve as a
service. It's quite easy to use.

But if you want a detailed explaination of how to set svn up on Windows,
you can't go wrong with this article[3].

On the topic of Homesite integration: forget it for the moment if you're
not willing to pay. For Homesite integration you need and SCC provider,
and the only one I know of out there is the commercial PushOK SVN SCC
provider[4]. I haven't used it myself, but it looks quite solid.
Subway[5] appears to be moribund, though chmsubscc[6] looks promising.

Either way, you shoul grab a copy of the excellent TortoiseSVN[6], a
Subversion client that integrates into Explorer. It's incredibly easy
to use, so much so that, I think, almost negates the need an SCC
provider. It's also useful to allowing control over other assets not
handled by the IDE.

Hope that helped. Sorry about any information overload!

K.

[1] http://svnbook.red-bean.com/
[2] http://dark.clansoft.dk/~mbn/svnservice/
[3] http://tinyurl.com/7tpg7
[4] http://www.pushok.com/soft_svn.php
[5] http://nidaros.homedns.org/subway/
[6] http://chmsubscc.tigris.org/
[7] http://tortoisesvn.tigris.org/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCxVk1mSWF0pzlQ04RAslvAKCWHb1yScNCYgRR0lZUijwsBF8duACg31jg
eiMdelPbx1EvrLccUPpHnv8=
=IwSY
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Using Firebird as an embedded database

2005-06-27 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

John Paul Ashenfelter wrote:
 On 6/23/05, Dave Watts [EMAIL PROTECTED] wrote:
 
We've a few projects here where we'll need some kind of an embedded
DBMS. It'd be nice to avoid MySQL (because of the need for a
commercial license), MSSQL (as it's Windows only and its embeddable
form--MSDE--doesn't allow as many simultaneous connections as
we'd need in a server environment), and Oracle (ha! ha! ha! and yes,
I know about Oracle lite). I'm not confident enough in PostgreSQL on
Window quite yet, SQLite and HSQLdb are inappropriate in the context,
so Firebird appears to be the best fit.

 
 
You might take a look at Pointbase, which is the embedded Java database
server that JRun comes with. Offhand, I don't know if it gets installed if
you install CFMX in the standalone server configuration, but it does if you
install CFMX Multiserver.
 
 
 One more option is Apache Derby (formerly IBM Cloudscape). I've only
 played with its so no real feedback, but should probably be on your
 evaluation list.

Will do. Mind you, I can remember in days of yore fiddling with
Cloudscape and getting very irritated with it for some reason. I'll
take a look though.

And I didn't know about Pointbase myself, so I'll take a look at that.

Cheers lads,

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCwB8mmSWF0pzlQ04RAj/zAJ49xMD+NDwYAKwtrKj/Kw0EzefxkACgxJ2v
98HwwtK1mVf8x7LzIhFc7vA=
=vXcz
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Using Firebird as an embedded database

2005-06-23 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

We've a few projects here where we'll need some kind of an embedded
DBMS. It'd be nice to avoid MySQL (because of the need for a commercial
license), MSSQL (as it's Windows only and its embeddable
form--MSDE--doesn't allow as many simultaneous connections as we'd need
in a server environment), and Oracle (ha! ha! ha! and yes, I know about
Oracle lite). I'm not confident enough in PostgreSQL on Window quite
yet, SQLite and HSQLdb are inappropriate in the context, so Firebird
appears to be the best fit.

I've been running it on my laptop, fiddling around with it, and reading
the documentation, and I like what I see so far.

If anybody on the list has been using it for anything, I'd be grateful
for any thoughts or stuff to watch out for.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCuue8mSWF0pzlQ04RAsxdAKCk31LsIeeOIkpHijWS4RQG1rm4VwCgk6NI
283ykDN9+Mz1Ukeuv2qsBcw=
=r9yj
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: how to cfoutput from com.allaire.cfx. methods

2005-06-20 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

David Manriquez wrote:

 I have a method 
 
 public String[] getColumns(HSSFSheet hssfsheet, boolean flag)
  and inside this.
 
   Query query = Response.addQuery(output,mycolumns);
 
 And the complier says that addquery isn't static, but I didn't defined the
 method as Static..

Request is an interface. When you did

Query query = Response.addQuery(output, mycolumns);

Java assumes that you are looking for a class method (although
interfaces can't have them) on the Response interface.

What you need to do is pass the response object passed into
processRequest() to getColumns(). Your method signature for that method
would become:

public String[] getColumns(Request request,
HSSFSheet hssfsheet, boolean flag)

And you'd call addQuery() as follows:

Query query = response.addQuery(output, mycolumns);

When you call getColumns(), it'd look something like this:

public void processRequest(Request request, Response response)
{
// ...

columns = getColumns(request, sheet, flag);

// ...
}

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCttvjmSWF0pzlQ04RAtZDAJsGRD/khGrlVQiGOyOMIh7kzEfDPQCbBRQ6
OzpRStmBUhsc5hmKzyjEL/Q=
=1Qei
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: reverse compliment a sequence

2005-06-15 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Barney Boisvert wrote:

 It ought to do what it's documented to do, which is replace each
 instance of the first list's items with the corresponding item from
 the second list.  It does that very well.

Which can be interpreted two ways.

One is the intuitive one, which is like a string- rather than
character-based version of tr///, where the input string is scanned for
the span of characters closest to the beginning of the string that
matches one of the elements in the domain list. This span of characters
is replaced with its corresponding entry in the range list. It then
does the same thing with the remainder of the string following the span
that's just been replaced. Wash, rinse, repeat. This is a useful
function.

Then there's the counterintuitive one, which is how ReplaceList() works:

function ReplaceList(text, rangeList, domainList)
{
var i = 0;

var range  = ListToArray(rangeList);
var domain = ListToArray(domainList);

for (i = 1; i lte ArrayLen(range); i = i + 1)
{
text = Replace(text, range[i], domain[i], ALL);
}

return text;
}

Which is, quite frankly, next to useless and violates the Principle of
Least Surprise. That, in itself, is a bug.

 Whether that particular function is useful at all is up for debate
 (I'm on the 'no' side).

Ditto.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCsAY/mSWF0pzlQ04RAq7bAJ9U5KMiBh4XHetuOjPYG/tx8kmY3ACfXkhR
HIqMjKBhjyUB1uKuWCYFBXA=
=dDma
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Transaction History File

2005-06-15 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Andy wrote:

 I am thinking about creating a transaction history for auditing, repairing
 and undoing.  I am thinking about using XML since this would be easy to
 create and would adjust naturally to the addition of new attributes.
 However, this would make the file sizes larger. 
 
 What are everyone's thoughts about

 1.  Keeping a transaction log

Good!

 2.  Keeping it in XML format

Not so good. My objection here is that appending to the log would be
prohibitively expensive. If you're doing logging, the format of your
file needs to be something you can append to without needing to do
any messing with the rest of the file. Because XML requires a root
element, this makes using it for log files a bit impractical.

However, If your log file was I-Can't Believe-It's-Not-XML (most of the
XML goodness, but without the root element), it could work. Example:

XML:

stuff
foo bugs=babs
barFred/bar
bazBarney/baz
/foo
foo bugs=babs
barFred/bar
bazBarney/baz
/foo
/stuff

ICBIN-XML:

foo bugs=babs
barFred/bar
bazBarney/baz
/foo
foo bugs=babs
barFred/bar
bazBarney/baz
/foo

Changing ICBIN-XML into XML is simply a matter of prepending and
appending the root element markup.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCsBXCmSWF0pzlQ04RAmSPAKClLMdLa8GJjaPzoEo7XmKtEGqI1QCg8grw
kam21JnddQjMSeiTQ9Qj/YE=
=CWcc
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: reverse compliment a sequence

2005-06-14 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Richard Colman wrote:

 I need to to reverse compliment a nucleotide sequence, so
 
 C become a G
 G becomes a C
 A becomes a T
 T becomes an A
 
 I need to go through a string a character at a time and build a new string.
 
 So:
 
 ACTG becomes TGAC
 
 Is there an easy way to do this?

The following does something simple like Perl's tr///.

function Translate(text, from, to)
{
var iText  = 0;
var iTrans = 0;
var result = ;
var ch = ;

for (iText = 1; iText lte Len(text); iText = iText + 1)
{
ch = Mid(text, iText, 1);
iTrans = Instr(ch, from);
if (iTrans gt 0)
ch = Mid(to, iTrans , 1);
result = result  ch;
}

return result;
}

No error checking, quick hack, but it ought to work.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCr3BHmSWF0pzlQ04RAgFfAKDpvYJobImfGyDR6w+exZwaZTHNpACgui2H
ZhrBxlGpnk8SjQGAs7rtv9I=
=GVFZ
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: reverse compliment a sequence

2005-06-14 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

RADEMAKERS Tanguy wrote:

 Well, i was going to suggest using 
 
 cfoutput#ReplaceList(ACTG,C,G,A,T,G,C,T,A)#/cfoutput
 
 but on my system that replaces ACTG with ACAC
 
 i'm confused?

That's 'cause it's riddled with bugs. It ought to work but doesn't.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCr3EUmSWF0pzlQ04RAsRAAKCg0WNSB+riLkETGI7xqvNCm/hyPwCgh4L2
/ufYlQwtcqARjrTJ1K0CuX8=
=cHSn
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: reverse compliment a sequence

2005-06-14 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Ray Champagne wrote:

 that seemed harsh...

It's not. It *ought* to work something like string-based version of
tr/// in Perl, but doesn't.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCr3aamSWF0pzlQ04RAkc0AKDd+da4PHIlMeFMNaPcZvLkpMlN3QCg2NaO
cwTneqWUdy/vDqDgkQT5XM8=
=nLXp
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Update Dilemma

2005-06-08 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

[EMAIL PROTECTED] wrote:

 I'm a complete newbie at Coldfusion, and have a pretty basic  question.
  
 I'm trying to get an update page working, and it keeps returning the  error:
  
 Error  Executing Database Query. 
 Syntax error in UPDATE  statement. The error occurred in  
 C:\CFusionMX7\wwwroot\CFIDE\gettingstarted\tutorial\update2.cfm: line  65
 63 :   NULL
 64 :   /cfif
 65 :   WHERE ID=#FORM.hiddenField#
 66 :   /cfquery
 67 : /cfif

The root of that error was that your query didn't have a name. However,
there's other problems with it too.

If you're setting values to null in a table, it's much better to use
cfqueryparam. I've rewritten your code to use it. Also, if you want
to check if you're being posted data, use the REQUEST_METHOD CGI
variable. Rather than having two different parameters with the same
basic meaning (URL.recordID and FORM.hiddenField), just use the one
name (recordID). Just use 'recordID', and CF will resolve this to either
URL.recordID or FORM.recordID.

I've assumed that your values are all VARCHARs, though you should change
them to whatever they really should be. Check the cfqueryparam docs
for a list of them.

-  CUT HERE 

cfsilent
cfparam name=recordID type=numeric default=1

cfif CGI.REQUEST_METHOD eq POST
cfparam name=FORM.nametype=string default=
cfparam name=FORM.surname type=string default=
cfparam name=FORM.sex type=string default=
cfparam name=FORM.height  type=string default=
cfparam name=FORM.playing_age type=string default=
cfparam name=FORM.DOB type=string default=
cfparam name=FORM.Hairtype=string default=
cfparam name=FORM.Eye type=string default=
cfparam name=FORM.Image   type=string default=
cfparam name=FORM.Trainingtype=string default=

cfquery name=update datasource=artists
UPDATE  Sheet1
SET Name= cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.name#null=#(FORM.name eq '')#,
Surname = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.surname# null=#(FORM.surname eq '')#,
Sex = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.sex# null=#(FORM.sex eq '')#,
Height  = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.height#  null=#(FORM.height eq '')#,
Playing_age = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.playing_age# null=#(FORM.playing_age eq '')#,
DOB = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.DOB# null=#(FORM.DOB eq '')#,
Hair= cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.Hair#null=#(FORM.Hair eq '')#,
Eye = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.Eye# null=#(FORM.Eye eq '')#,
Image   = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.Image#   null=#(FORM.Image eq '')#,
Training= cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#FORM.Training#null=#(FORM.Training eq '')#
WHERE   ID  = cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#FORM.hiddenField#
/cfquery
/cfif
cfquery name=artist datasource=artists
SELECT  *
FROMSheet1
WHERE   ID = cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#URL.recordID#
/cfquery
/cfsilent
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;

html xml:lang=en lang=enhead

titleUntitled Document/title

/headbody

cfoutput query=artist
form action=#HTMLEditFormat(GetFileFromPath(GetTemplatePath()))#
method=post
input type=hidden name=recordIDvalue=#recordID#
input type=text   name=namevalue=#HTMLEditFormat(name)#
input type=text   name=surname value=#HTMLEditFormat(surname)# /
input type=text   name=sex value=#HTMLEditFormat(sex)# /
input type=text   name=height  value=#HTMLEditFormat(height)# /
input type=text   name=playing_age
value=#HTMLEditFormat(playing_age)# /
input type=text   name=DOB value=#HTMLEditFormat(DOB)# /
input type=text   name=Hairvalue=#HTMLEditFormat(hair)# /
input type=text   name=eye value=#HTMLEditFormat(eye)# /
input type=text   name=Image   value=#HTMLEditFormat(image)# /
input type=text   name=training
value=#HTMLEditFormat(training)# /
input type=submitvalue=Submit /
/form
/cfoutput

/body/html

-  CUT HERE 

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCpypfmSWF0pzlQ04RAoUfAJ43RoZsHU8WB9B+eki5kbzvBtCdTACeIjBh
cfgj875TrqKoNOfyJ72fDOs=
=Ypde
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: 

Re: Web Application Security with Coldfusion

2005-06-07 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Paul Vernon wrote:

 The easiest way is to use cfqueryparam when putting in and use
 HTMLEditFormat when displaying anything from the database that is user
 input.

That, and if you're writing something from the database out to a
JavaScript string, don't forget to use JSStringFormat(). I've seen
mountains of code from various sources that totally omits this one
simple step.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCpYNemSWF0pzlQ04RAjzKAKDXBcQifSufHHuF21DaNVw5MYOuFgCfSBlp
P2XQFrWiaivXQDngB/xsfWs=
=3jfG
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Opera and cookies grrrrrr

2005-06-07 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Paul Vernon wrote:

 I've missed most of this thread so I'm sorry if I'm off base or I'm
 repeating someone but I thought that the RFC's stated pretty clearly that
 the size of a cookie could be no more than 4K and that there could be no
 more than 20 cookies per domain, therefore giving a total of 80Kb of cookie
 storage are you exceeding 80Kb of cookie storage on the client or are you
 saying that Opera isn't respecting the 4Kb/20 cookies rule?

You've got that a bit backwards. To quote RFC 2965:

   5.3  Implementation Limits

   Practical user agent implementations have limits on the number and
   size of cookies that they can store.  In general, user agents' cookie
   support should have no fixed limits.  They should strive to store as
   many frequently-used cookies as possible.  Furthermore, general-use
   user agents SHOULD provide each of the following minimum capabilities
   individually, although not necessarily simultaneously:

  *  at least 300 cookies

  *  at least 4096 bytes per cookie (as measured by the characters
 that comprise the cookie non-terminal in the syntax description
 of the Set-Cookie2 header, and as received in the Set-Cookie2
 header)

  *  at least 20 cookies per unique host or domain name

   User agents created for specific purposes or for limited-capacity
   devices SHOULD provide at least 20 cookies of 4096 bytes, to ensure
   that the user can interact with a session-based origin server.

   The information in a Set-Cookie2 response header MUST be retained in
   its entirety.  If for some reason there is inadequate space to store
   the cookie, it MUST be discarded, not truncated.

   Applications should use as few and as small cookies as possible, and
   they should cope gracefully with the loss of a cookie.

The 4kB/20 cookies rule is a *minimum*. There's no upper limit on how
many cookies can be stored overall or per domain, nor on the size.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCpcEdmSWF0pzlQ04RAp77AJ9/mI5gN+jMK6iuyg7ePEEVYx4OjgCgpMbm
u+SAPGB8USdJXuF2O0Q4R0E=
=Glx9
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF vs LAMP

2005-06-03 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

John Paul Ashenfelter wrote:

 I think the main advantage of CF over PHP/Perl/Python is the ability
 to leverage Java and to scale up into and integrate with J2EE
 containers and applications, but that's just me :)

Cough *Jython* cough! :-)

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCoGO7mSWF0pzlQ04RAtx3AKDVmsGqWAM2beffuPqUkgCWfK26rgCg62k9
ESYgYuj0GdPEO0eAaK60FiE=
=Q3Cw
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF vs LAMP

2005-06-02 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jochem van Dieten wrote:

 On re-reading that was very poorly worded by me.
 
 The SQL DEFAULT keyword is not just meant for use in DDL. SQL is 
 defined in such a way that you can also use DEFAULT in DML to 
 (re)set any column to its default value. You don't even have to 
 know what that default is. So in SQL you can use the command 
 UPDATE subscribers SET title = DEFAULT to restore the default 
 value for the title field in the subscribers table.
 
 More complete implementations already have your better solution.

Yeah, and did I not point out that something like that would be a
better solution? If you go back and read what I wrote after the bit you
snipped again, you'll see that all I was doing was offering reason
why they would have chosen to use that NULL hack rather than doing
things neatly.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCnutrmSWF0pzlQ04RAg0aAJ90SP3iSt9uTaaxl53aTejhmsyF9QCgsLc4
e70uurHEEQ2ybk446SBOrkI=
=wOi0
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: CF vs LAMP

2005-06-02 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jochem van Dieten wrote:

 Apart from being the wrong one, I don't think the reason you 
 offer is valid. The API is still burdened with handling of 
 DEFAULT because DEFAULT is implemented for insert statements, so 
 I fail to see any gains there.

It wasn't a reason, but a possible rationalisation.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCnwi2mSWF0pzlQ04RAq+YAKDEgDKHZ3iLTVV70H30vde89vH20ACgiMYY
qLKmemNO69DY2Of+LKnG45w=
=qtML
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF vs LAMP

2005-06-01 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dave Watts wrote:

 Yup, and it'll give you the default value for that field. I 
 don't see how this is a criticism.
 
 You're kidding, right? That defeats the entire purpose of NULL. How would
 you differentiate between default values and NULLs?

I think that more points to a flaw in the concept of NULLs in SQL
(which, as it happens, is one of the most criticised aspects of the
language) than a flaw in MySQL per-se.

The real problem is that NULL is seriously overloaded in SQL. I wasn't
defending MySQL's behaviour--though I can see how you could infer
that--just pointing out that the real problem is elsewhere.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCnaDdmSWF0pzlQ04RAufZAJ9kTRt9nBg3rbHKyQ3tKbT/I8xAiACgpi7Z
gwq/w3bsPZ0nIAOOqT7B/QU=
=zucO
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: CF vs LAMP

2005-06-01 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Joe Rinehart wrote:

 Can probably be written:
 
 NULLIF(cfqueryparam value=#form.foo# cfsqltype=CF_SQL_VARCHAR
 maxlength=20, '')

Or even:

cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#FORM.foo#
 null=#(FORM.foo eq '')#
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCncLfmSWF0pzlQ04RAmwWAKCi96L7LVanD2BKb437ZXrdHW1cJwCcDQoq
jh+mbzST+hW03/82kpaJqEc=
=x+Is
-END PGP SIGNATURE-

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: CF vs LAMP

2005-06-01 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dave Watts wrote:

I think that more points to a flaw in the concept of NULLs in SQL
(which, as it happens, is one of the most criticised aspects of the
language) than a flaw in MySQL per-se.
 
 It's one thing to observe a flaw in a language. It's another to use that
 flaw as justification for an application's failure to conform to that
 language. I don't see at all how one has to do with the other.

As I said, I'm not defending MySQL. I'm saying that the behaviour of
NULLs in SQL is, well, buggered. Attacking a DBMS, any DBMS on the way
it handles them in various situations is a bit like shooting fish that
are fastened to the barrel of your gun.

The thing is, the overloading of NULL in various DBMSs probably made
sense at the time. Just to taking the situation with MySQL, there are
times where you're inserting a new record and you may or may not want
the default value, but you'll only know at run time.

A better solution would be to have a USE_DEFAULT keyword for that
particular kind of null value or something like that, but extending the
DML like that can be argued against easily too. What overloading NULL
like that has in its favour is that if you're using the likes of
prepared statements, you don't need to mess about the API, it just drops
out of the implementation.

I'm not saying that it's good. I'm just saying that its behaviour is no
worse than that of any other DBMS when it comes to NULLs. There's things
far more annoying in its behaviour than that.

 On an unrelated note, I noticed that I can see better out of my right eye
 than my left eye. So, to improve my driving, I started driving on the left
 side of the road instead of the right side. I'm sure that will be a great
 improvement.

Yeah, depth perception of for the weak! :-)

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCndKOmSWF0pzlQ04RAnKJAJ0ajVfswfjBZ2z7R2lR/unBVtHfIQCfTQSD
NfAQbKbMNY3W1t2EAi8vEq4=
=IXRP
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF vs LAMP

2005-05-31 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Damien McKenna wrote:

The standard demonstration of MySQL's competitiveness with MS-SQL is
the well-know eWeek article
(http://www.pcmag.com/article2/0,1759,103972,00.asp) shows that MySQL
(4.0 in the tests) paced Oracle and simply kicked the butt of
everything else, with MS-SQL coming in at the bottom.
 
 One thing - most pro-MySQL benchmarks use the basic MyISAM tables which
 don't support newer features like transactions, etc.  Once you move to
 INNO DB to add those features you start loosing speed.

This one didn't, however it does play to the fact that you can specify
the table handler to use. The tables in the test that needed
fine-grained locks (row level) used InnoDB, whereas those where table
locks were appropriate or where no locking was needed, used MyISAM.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCnLxVmSWF0pzlQ04RAqntAJ94SSau4fEhMHl8W+JruHRMLo7P0gCeJZK9
2ajtWOlVW/l0pxxUaEKwniI=
=XnwK
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF vs LAMP

2005-05-31 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Bryan Stevenson wrote:

anecdote
True story. MySQL and Informix recently were competing for a contract
at a large enterprise (which I can't name). The *software license*
ONLY for Informix for their 96 (!) processor SGI Origin (maybe it was
48 -- doesn't really matter all that much) was $1.2M. MySQL's
per server commercial license was $600 -- the same as it is for a 1
CPU Dell 750 server.
/anecdote
 
 Of course MySQL allows NULLs in NOT NULL fields among other features ;-)

Yup, and it'll give you the default value for that field. I don't see
how this is a criticism.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCnMrHmSWF0pzlQ04RAjSYAJ9CYGWYHr345tIVPr0PW667m8gN3QCeLeFP
ukdJMquEA6sAHtcx5IkP5YI=
=/DnW
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Enable Robust Exception Information - Tradeoff

2005-05-21 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

S.Isaac Dealey wrote:

You should really only have robust exception
information on on a development server.
 
 I think you might be thinking about debugging.

Nope, I was thinking about robust exception information: sure, it might
be security through obscurity, but there's no sense in revealing the
internal workings of your program and its code (which REI does) on a
production server. If you need to be informed on exceptions on
production servers, that's what error handlers are for.

And of course you wouldn't have debugging on.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCj/NfmSWF0pzlQ04RAjgQAJ46+WvKCRTmEPbIMEBTiYGXiHAUdACcDosG
/i9GN6+JI87D7jySNqPiYbI=
=PpzO
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Enable Robust Exception Information - Tradeoff

2005-05-20 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Leonardo Augusto CRESPO - Gmail wrote:

 Hi all, i hope you're having a great Friday. I'm working on a CF6.1 website
 that generates a substantial number of exceptions. In order to handle those
 errors in an effective way, i'm considering turning on Robust Exception
 Information. However, the production server is known to have performance
 problems. 
  
 I did a research and couldn't find detailed information about how much this
 option impacts on performance. I guess if it increases execution time by 20%
 at the most, it is worth enabling. 
  
 Based on your experience, can you tell how much the Enable Robust Exception
 Information option adds to the overall execution time? 

You should really only have robust exception information on on a
development server.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCjko4mSWF0pzlQ04RAl3WAJ44dSFYvIu7nqIhfpha9DAs62B1YgCfdadb
v6jiq+e7dD1CXo616BTnsl0=
=y5J9
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: why use coldfusion 7?

2005-05-17 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Andy Allan wrote:

 One thing to remember about CF7 is that at it's core is CFMX6.1 + Updater 1
 
 Therefore if you're boss wants to go to 6.1 purely cause it's stable
 then you have absolutely no reason not to go to 7.

The same argument can be made in favour of CF6.1: if you don't really
need any of the CF7 features, you're best off sticking with CF6.1.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCigZ3mSWF0pzlQ04RAnLfAJ9UdPKhgplWkyTQq/OrFyQvU6CNtgCdFHGl
AXncjOS6HbN9YZr8k5IDSLE=
=7/eA
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: why use coldfusion 7?

2005-05-17 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Connie DeCinko wrote:

 I'd disagree arguing that it will cost you more in the long wrong to upgrade
 and test/debug twice.

This isn't like going from CF5 to CF6 where there was a complete
rewrite: the core of CF7 is just plain old CF6.1 + patches. For this
reason alone it *shouldn't* cost you anything more to upgrade tomorrow
when there's a real need rather than today.

What I said was that if you don't need any of the CF7 features, then
using CF6.1 will be just fine because if it's all you're using then
the extra expenditure of buying a copy of CF7 isn't worth it.

This comes with the assumption that you've got unused CF6.1 licenses
about.

 You'll get more mileage out of going straight to
 CFMX7.  And just because you don't NEED the new features today, does not
 mean you will need or find a use for them tomorrow.  You may even find a way
 to improve on your current code with a new feature.

That sounds like the SUV argument: I must have the most powerful car out
there because I *might* need to go offroad or drive through artic
tundra! Sure, I live in suburbia, but you never know when a mountain'll
crop up between home and work. :-)

Ok, so I'm being a little facetious, but when it comes to CF7 there's
truth in the joke: it's a matter of YAGNI. If you're not going to use
those features today, it's a waste of money.

As developers, it's nice to have all those baubles and shiny bits to
play with, but if the upgrade can't be justified in terms of cost then
it's not worth it.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCijy1mSWF0pzlQ04RAiFVAJsFb19W1B0IEE6upskQGOKqh7l3wgCdGdlI
hTNLzgLW74CDFg1oXrYUwb0=
=anSh
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: transparent png for ie hack

2005-05-16 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Ewok wrote:

 I am so tired of hacking up alternate styles and images to get a site
 looking the same in IE as it does in FF!
 
 A lot of the time, I've been able to use style filters to get what I'm
 looking for maybe you could try some of those? Opacity maybe? Just a
 thought.

It's possible... kinda.

http://webfx.eae.net/dhtml/pngbehavior/pngbehavior.html

Mind you, this won't work around everything.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCiJbKmSWF0pzlQ04RAstTAJ9YbSBcs7WbHE+ms+OQqGgg6AOQewCZAWMd
6UA5gqP83YFLhOE0J3FylDg=
=ajcI
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF and Hungarian Notation - a better solution

2005-05-16 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I-Lin Kuo wrote:

 A recent blog entry by Sean Corfield has led to this
 thought:
 
 http://www.corfield.org/blog/?mode=entryentry=D1CB9656-0284-4F53-209C8F9F6159FB8D
 
 It seems to me that the primary argument given for the
 use of Hungarian notation to signify data types is to
 allow the naming convention to compensate for weakly
 typed languages like CF and VB. It's proponents argue
 that using Hungarian notation allows them to see at a
 glance the type of the variable without having to
 search through code.

Slight correction there: VB is, in fact, strongly typed as long as you
avoid using variants, which subvert its strong typing.

 I think there is another better solution to this
 problem -- let the IDE and the language solve this
 together. For example, when using the Eclipse IDE for
 Java, hovering over a variable name brings up the
 JavaDocs for that variable, showing its type
 information as well as any comments by the author
 about its intended usage. This information would be
 far more useful than the mere knowledge of the
 variable type. If CF were to add some kind of
 JavaDoc-like annotation feature, then I don't think
 there would be any more arguments about CF and
 Hungarian notation (excluding notepad and emacs users
 :) 

Well, yes and no. I don't use HN myself (although I do use something
similar, and I think most programmers do unconsciously), but I
understand the reasoning behind it.

Disregard all the stupid corrupt forms (the ones where you prefix the
likes of 'str', 'int', 'flt', 'tbl', 'dw', c.), and go read Simonyi's
original description[1]. The error people made when reading this was to
confuse the meaning of the word 'type'. Simonyi was talking about
semantics--that is, logical types--rather than physical types. For
instance if you have an integer, and you're using it as an index, you'd
prefix this with 'i', e.g. 'iMessage', and counter might be called
'cUnits'.

This is very, very different from the VB-style HN that most people on
this list have probably been in contact with, where you prefix the
physical type to the variable (which is just a little dumb). Case in
point: prefixing variants with 'vnt', tables with 'tbl', c. This kind
of notation sprung from two sources: C-programmers who learned Windows
programming from Petzold[2] and picked up 'HN' there, and from reading
code produced by the systems group in MS. Both sources made the
unfortunate error of confusing physical types with the types Simonyi was
talking about. The VB crowd just compounded this to the mess we have
today.

Most of the conventions in the original HN are actually useful in any
language, primarily because most of the things in it are things you
put in names anyway. Mind you, some of them, such as the 'p' and 'sz'
prefixes are C-specific, and though I personally thing 'sz' isn't
particularly useful (unless you're dealing with a whole bunch of
different string types that look otherwise identical, like you might
in C), though 'p' *is* useful if you're dealing with pointers a lot.

Sorry for the ramble. If you haven't already read it, you should read
Joel Spolsky's original article[3], which is what triggered Sean to
write his one. Also, Larry Osterman's last blog entry on the topic[4]
is worth a look.

K.

[1] http://msdn.microsoft.com/library/en-us/dnvs600/html/HungaNotat.asp
[2] http://www.charlespetzold.com/pw5/
[3] http://www.joelonsoftware.com/articles/Wrong.html
[4] http://blogs.msdn.com/larryosterman/archive/2004/06/22/162629.aspx
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCiJ6VmSWF0pzlQ04RAj98AKCTbPq4TleveCLQTjZO+sBArTjsTwCeOEui
pzrUM9eiWgF3QkHmBjersgI=
=QHQh
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: CF and Hungarian Notation - a better solution

2005-05-16 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Steve Brownlee wrote:

 I think the original point was for CF developers (specifically in the Eclipse
 IDE) to have JavaDocs capabilities so that they could describe the usage,
 type and purpose of the variable.  I don't think anyone was arguing the
 history or usage of Hungarian Notation.

I realise that, but let me quote the original post:

 It seems to me that the primary argument given for the
 use of Hungarian notation to signify data types is to
 allow the naming convention to compensate for weakly
 typed languages like CF and VB. It's proponents argue
 that using Hungarian notation allows them to see at a
 glance the type of the variable without having to
 search through code.

This is what I was talking about: HN has nothing (in its original form)
has nothing to do with types in the above sense of physical (integers,
floats, strings, c.) rather than logical type (indexes, counters, c.),
which is what HN is about.

I probably should have been a bit more precise in what I wrote.

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCiKpimSWF0pzlQ04RAmNTAJ4ivGHuoPp3uOxsNX2+ra4noAo1fACeNRa0
J9y5vs4hlI4rf5UI83kBL9A=
=8d1o
-END PGP SIGNATURE-

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Availability of try..catch [was Re: Dynamic Javascript Question]

2005-05-11 Thread Keith Gaughan
S.Isaac Dealey wrote:

 last I knew javascript try-catch wasn't cross-browser... I think IE
 allows it but Mozilla browsers tell you that you can't use the keyword
 try when you attempt it. Or at least that was my experience
 previously.

Nope, it's definitely cross-browser. Drop this into the Mozilla
addressbar to test:

javascript:try { 1 == 1; } catch (e) { }

It should write out true if it works, or complain if it doesn't.

I've been using try .. catch with Firefox since v0.8, so it ought to
work everywhere. I also opened up Opera (v7.54u2), and it works there
too.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: CF 4.5 SOAP

2005-05-11 Thread Keith Gaughan
Doug Ford wrote:

 Hi Folks -
 
 I am relatively new to this forum... Long time stalker, first-time poster!
 
 I was wondering if anybody has any experience with CF 4.5 (yes, I know it's 
 old) and SOAP.
 
 The company who I process online ACH payments with has recently switched to 
 using a SOAP webservice and I need to figure out a way to do this...ASAP.
 
 If that means using a .dll file or a Java package, I am all up for it.
 I just need to make sure I can pass the variables that I need to pass.
 
 Any and all help is appreciated!!

Well, if you're really stuck with CF4.5, then I recommend that you use
Apache Axis[1]. This is what CFMX itself uses internally to call and
implement webservices. Just generate the stubs you need from the WSDL
files, and Robert's your father's brother.

K.

[1] http://ws.apache.org/axis/

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Google Web Accelerator problems

2005-05-10 Thread Keith Gaughan
Damien McKenna wrote:

 Just to explain the seriousness of this to people who don't have time to
 read the articles... GWA loads *every* single link on *every* page the
 user visits that isn't on an SSL site (i.e. https), including links
 after you have logged into a site, including links saying delete
 records, send my boss a really nasty email, order this book
 immediately and big nasty red button that will destroy the fabric of
 society.

It must be said that anybody who uses links for anything but idempotent
actions ought to be slapped silly.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Javascript to coldfusion

2005-05-09 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jeremy Bunton wrote:

 I want to set a javascript var to a coldfusion variable, what I am doing
 looks like below. The value being a true false Boolean. I keep getting an
 error that doit is undefined in CF. I've gone from coldfusion to JS before,
 but not the other way around. Thanks
 
 Jeremy
 
 script
 var doit = confirm(Are you sure you want to delete?);
 cfset didit = doit
 
 /script

You can't.

You see, the thing here is that when you thought you were assigning a
value from a ColdFusion variable to a JavaScript one, all you were doing
was generating some JavaScript code for doing the assignment. This gets
sent to the browser and executed. The only thing the Client and Server
know in common is HTTP.

JavaScript doesn't know about ColdFusion, and vis versa. If you want the
browser to execute some code on the server, you need to send a request
back to it, sort of as follows:

form method=post action=/page/to/execute.cfm
input type=hidden name=id value=5432 /
input type=submit value=Delete onclick=return ConfirmDelete() /
/form

script type=text/javascript
function ConfirmDelete()
{
return confirm(Are you sure you want to delete?);
}
/script

[Aside: I don't use onclick myself, preferring to add handlers
unobtrusively.]

K.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCf3X8mSWF0pzlQ04RArq0AKDomXZjOplRYkA9/6hxFqh61zGa6ACgyECC
nFoY6fae1o+r41PsTamg8wo=
=Ozvu
-END PGP SIGNATURE-

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: HASH() reverse

2005-05-08 Thread Keith Gaughan
Dave Merrill wrote:

 Nice explanation Jim (:-)
 
 It's sometimes hard for people to understand this basic concept. That was
 the simplest, clearest, most common-sense take on hashing I've seen. I'll
 remember it if I need to go through this with a client.

I can do better:

 Hashing text is like mashing potatoes: once you've done it, you
 can't get back what you started with.

K. :-)

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: New Development Libraries

2005-05-04 Thread Keith Gaughan
Roger B. wrote:

 I understand you can include L-GPL code in commercial applications,
 but you must supply the source code to paying customers for the
 infected application. 
 
 
 Stan: I could be wrong, but my understanding is this:
 
 If I bundle an L-GPL'd spellchecker with my CMS, I have to make the
 source of the spellchecker available if I make any changes. But the
 whole point of the L-GPL is that the controls stop there... the rest
 of the CMS is licensed in whatever fashion I please.

Precisely, which is exactly the justification the FSF gave for creating
the LGPL in the first place. Worth noting for historical reasons is that
before it was known as the Lesser General Public License, it was called
the Library General Public License.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: New Development Libraries

2005-05-04 Thread Keith Gaughan
Stan Winchester wrote:

 Like I said, I'm not an attorney and I find reading those long
 technical legal documents rather daunting. I appreciate the
 clarifications. I wish attorneys could write in plain English
 that we can all understand.

Ah, but if they did, they wouldn't have jobs anymore. :o)

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: New Development Libraries

2005-05-04 Thread Keith Gaughan
Jochem van Dieten wrote:

 The GPL requires that you provide the source code of every 
 application that incorporates or links a GPL licensed library to 
 everybody that has obtained a compiled version from you without 
 limits on change, use or redistribution other then the GPL itself.

There's one little proviso that many people miss out here.

You can still use GPLed libraries in commercial apps without releasing
your source just as long as the GPLed libraries and the commercial
code don't touch. There's a few ways in which this can be done. These
depend on forms of loose coupling, making the result a mere aggregation
as opposed to a derivative work.

Dynamic Linking
===

Pretty obvious is this one. The GPLed code is in a seperate library
and is only linked into your app at compile time. Examples of this
would be kernel modules and drivers in Linux (which itself is GPLed),
DLLs and SOs, jar files (so long as your compiled class files are
in one jar and the GPLed code is in another).

Aside: With Java and similar languages, the issue of subclassing comes
up. In this case, if you subclass a GPLed class, your class is a 
derivative work and therefore subject the GPL. Interfaces, I believe,
are a different matter.

Aside: The GPL FAQ disagree with me on this. However, the GPL, if my
reading is correct, says nothing that disallows what I've stated above.
The reason for this is that when you dynamically link to a library, you
leave hooks there for the dynamic linker to resolve. Supposing even a
wholly hypothetical library, equivalent in functionality to the GPLed
one, that is licensed in such a way as to allow redistribution without
the kind of restrictions as the GPLed library and can be dropped in
in place of the GPLed library for the dynamic linker to resolve the
hooks at runtime without needing a recompile of your program, then that
your program is dynamically linked to a GPLed library at run time is
more an artifact of the system it's running on rather than something
inherent to your program, rendering it a mere aggregation rather than
a derivative work. Phew, that was a long sentence!

Thunking Layers
===

You write a small wrapper library that talks to the GPLed code. Dynamic
Linking is a variant of sorts on this, but in this case you're doing
everything manually rather than automatically, and the GPLed code will
still probably be statically linked anyway. You then license the wrapper
library under a suitable GPL-compatible license, such as the BSD license
or LGPL.

How this gets away with it in a legal sense is that the fact the wrapper
library depends on a GPLed library is simply an implementation detail of
that library and not one that your app depends on. You can, for
instance, use a completely different library, and modify the wrapper
library's implementation without it affecting your code.

This is the safest option. If you want to be extra safe, dynamically
link your wrapper library rather than statically linking it to the
GPLed library might be your best bet.

As an example of this. Say the expat XML parser was covered by the GPL
(it's not, but bear with me). A few years back, I wrote a rather neat
class in C++ to act as a wrapper around it. It used a bunch of static
private methods as callbacks, and a pointer to the instance in question
as the userData. Say I release this class and make it available under
the LGPL, BSD license or some other GPL-compatible license.

Now I go and write some app that uses this class and release it
commercially. My app depends on the wrapper class, but on expat only
as an implementation detail of the wrapper class. I could just as
easily recode the wrapper class to use libxml2, msxml, or some other
parser.

 The GPL is often called 'viral' because using a little bit of GPL 
 code in an application 'infects' the rest of the application. The 
 LGPL does not have this problem. But it is important to recognize 
 that nobody can force you to give away your sourcecode. If you 
 don't adhere to the GPL you are violating IP law and somebody 
 might claim damages, but the law does not recognise open-source 
 your own code as a remedy.

OTOH, it doesn't need to recognise it. Licenses are part of contract
law, and its under contract law that the arguments would be made.

The GPL is a contract that states that if you create a derivative
work of a piece of software covered by the GPL and distribute the
derivative work, you must make the source code of the derivative
work available upon request.

K.

PS. Jochem, you don't mind if I post this on my blog, do you?

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205577
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: 

Re: CFMX interrupting javascript - MORE

2005-04-28 Thread Keith Gaughan
RADEMAKERS Tanguy wrote:

 you have two calls to function urlencodedformat:
 
 #urlencodedformat(main_jpeg)#
 #urlencodedformat(tempPopTitle)# 
 
 could that have something to do with it?

Well, I wouldn't do that, nor would I get rid of the javascript: bit in
the link (as such). Try this:

cfset popupLink = href=http://XX/Show_Movies_Image.cfm?Image=; 
 URLEncodedFormat(main_jpeg) 
 type=DVDtitle= 
 URLEncodedFormat(tempPopTitle)
cfsavecontent var=file
cfoutput
a href=http://XX/DVD/#URL#;
style=color:navy;font-size:15px#Trim(tempTitle)#nbsp;DVD
a onclick=popupBoxArtDVD(this.href, 236, 335);return false
onmouseover=window.status = 'See Box Art'
onmouseout=window.status = ''
href=#popupLink#img
src=http://XX/gif/excal2/Files_Icon.gif;
alt=Box Art hspace=4 vspace=0 border=0 align=bottom/a
/cfoutput
/savecontent
cffile action=append file=#complete_filename#
 addnewline=No output=#file#

Also, look for any variables that you're repeatedly reprocessing within
the loop, but that don't actually change in value and move them out of
it. Doing something just once is always faster than doing it over and
over again.

Also, I removed a few trims that looked redundant from the above.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: cfqueryparam and null values

2005-04-27 Thread Keith Gaughan
Pete Ruckelshaus wrote:

 OK, here's what I did, a bit more elegant than the first time.  I
 added the following to my UDF library include file:

snip

Um... why not:

function isNullNumeric(str) {
 return not isNumeric(str);
}

function isNullString(str) {
 return len(trim(str)) eq 0;
}

function isNullDate(str) {
 return not isDate(str);
}

Much sorter, and more direct too. :-)

K.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: cfqueryparam and null values

2005-04-27 Thread Keith Gaughan
Bryan Stevenson wrote:

 arrrgg...listen to Barney (and me and Dave W)...just do it in the null 
 attributeno silly JS neededyou're making it WAY too complicated and 
 it will be a monster to maintain.
 
 sorry for the rantit just pains me to see these kinds of solutions ;-)

Oh, no: I totally agree, hence the nudge-nudge-wink-wink way I wrote the
comment.

K.

P.S. I assume by JS you meant to write CFScript.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: _Are_search_engine_safe_URLs_really_necessary?

2005-04-26 Thread Keith Gaughan
S.Isaac Dealey wrote:

  1. (a) http://example.com/archives/2005/4/25/
 (b)
 http://example.com/archives.cfm?yr=2005mth=4dy=25
 (c)
http://example.com/index.cfm?fuseaction=blog.archivesyr=2
005mth=4dy=25
 
 You know, there's nothing keeping me from using
 http://example.com/archives/?2005/4/25
 http://example.com/archives.cfm?2005/4/25
 
 You can get the data from the variable #cgi.query_string# although
 according to the article, these would not pass as SES url's merely
 because they include a question-mark in the url.

Yup, I I agree completely. And with a tiny bit of hacking with
CGI.PATH_INFO and CGI.SCRIPT_NAME, you could do:

 http://example.com/archives.cfm/2005/4/25

  2. (a) http://example.com/entries/name-of-an-entry/
 http://example.com/entries/348/
 (b) http://example.com/entries.cfm?name=name-of-entry
 http://example.com/entries.cfm?id=348
 (c)
http://example.com/index.cfm?fuseaction=blog.entryname=na
me-of-entry
 http://example.com/index.cfm?fuseaction=blog.entr
 yid=348
 
And so on. I think you'll agree that the (a)s are a bit
easier on the user.
 
 a bit

And as a bonus, if you're doing URL remapping, you can, if need be,
rearchitect the app without breaking the URLs. And there's fewer
useless warts on it too. :-)

K.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: nest #

2005-04-25 Thread Keith Gaughan
Maxwell Smart wrote:

 I'm trying to output the results of a query similar to:
 
 #productrange1.name#
 
 however I would like to increment the 1 based on the ID of another table such 
 as
 
 #productrange#ID#.name#
 
 however obviously this is not allowed.
 
 any suggestions please?

No, it's not allowed. You've three options here, a bad one and two good
ones.

The bad one is to use Evaluate(). Don't do this. It's slow and makes
code hard to maintain more often than not. If you see it as really
being your only option (which it shouldn't be), then here's what you
do:

 #Evaluate(productrange#ID#).name#

The first good option is to store all your product ranges in an array
(if the id range is dense), that way, you could do something like:

 #productranges[ID].name#

The third option is to store them in structs. This is good if your range
of ids is typically sparse, or textual. Referencing an element of the
struct is the same as for arrays.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Are search engine safe URLs really necessary?

2005-04-25 Thread Keith Gaughan
Al Everett wrote:

 For those of you taking a lot of time getting your dynamic site URLs
 to look like static ones, this article may be of interest to you:
 
 http://www.emediawire.com/releases/2005/4/emw232456.htm
 
 (I am in no way affiliated with the site. It just happened to come up
 in a Google Alert and covers a topic I've seen pass through the list
 more than once.)

I think the main reason for having search engine friendly URLs these
days has absolutely nothing to do with search engines, and everything
to do with the people using your system. Search engine friendly URLs
are somewhat more user-friendly than their query string-based
equivalents if done right.

Let's take a simple example. For instance, let's say that you were
writing a bit of blogging software. Which looks more user-friendly
to you:

  1. (a) http://example.com/archives/2005/4/25/
 (b) http://example.com/archives.cfm?yr=2005mth=4dy=25
 (c) 
http://example.com/index.cfm?fuseaction=blog.archivesyr=2005mth=4dy=25

  2. (a) http://example.com/entries/name-of-an-entry/
 http://example.com/entries/348/
 (b) http://example.com/entries.cfm?name=name-of-entry
 http://example.com/entries.cfm?id=348
 (c) 
http://example.com/index.cfm?fuseaction=blog.entryname=name-of-entry
 http://example.com/index.cfm?fuseaction=blog.entryid=348

And so on. I think you'll agree that the (a)s are a bit easier on the
user.

[Aside: I'm not sniping at Fusebox, in case anybody's thinking I am.
It's a good framework, but exposes some things that the user shouldn't
see, like the fact it's being used at all. This goes for any framework.]

Also, user-friendly URLs also mean that you can change the underlying
architecture of your app without breaking the URL part of its user
interface. A lot of people forget that URLs are just as much a part of
the UI as what you see in the viewport, and shouldn't.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: take duplicate out of a list

2005-04-20 Thread Keith Gaughan
CFDEV wrote:

 Hi, is there an easy way to take duplicate out of a list or do I have to
 loop trough the list and create a new list with all elements and check if
 they are already in the new list before inserting them?

Here's a neat method:

cfset lst = a,list,with,with,duplicate,elements
!--- We shall be using a struct as a set! ---
cfset set = StructNew()
cfloop index=elem list=#lst#
 cfset set[elem] = 
/cfloop
cfset lst = StructKeyList(set)

Et, voilà!

After all, a map is just a set with values attached to each one of the
elements. For example, the HashSet in Java is internally implemented
using a HashMap.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Coldfusion is on Nº 25 in tiobe.com

2005-04-20 Thread Keith Gaughan
James Holmes wrote:

 LOL, they have LabVIEW above VBScript. I happen to know labVIEW because I
 did research in a field that it suited, but who else has heard of it?

I have, and it's a pretty nifty language. In fact, the whole idea behind
dataflow languages is pretty nifty. I was introduced to it when I was in
college and doing work experience in a research lab. My group was doing
stuff with MEMS, and I needed to use LabVIEW to build some instruments
for testing the wireless networking stack I was working on. I can't
imagine writing that stuff in any other language!

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: take duplicate out of a list

2005-04-20 Thread Keith Gaughan
Ewok wrote:

 Hey not bad. Neat approach.

It came to me a while back in one of those ah! moments. And the
neatest thing about it is that it works just fine on CF5.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-19 Thread Keith Gaughan
Jim Davis wrote:

PDF 's **ARE** PostScript files - they are just in PDF format, but
whatever
way you look at it they are PostScript files...
 
 True - but more exactly they could be called Postscript Plus since while
 the pure data may be postscript PDFs contain more than just postscript
 information.

More like PDF = PS-+: As stated, PDF is based on a simple _subset_ of
PS, but it has a lot of extra features on top of that.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Stopping this argument once and for all: PS and PDF

2005-04-19 Thread Keith Gaughan
PDF is based on a subset of PS. It does not contain the full PS 
language. In fact, IIRC, unlike PS it's not even Turing complete.
On top of this subset, Adobe added a bunch of extra stuff, such
as encryption, compression, watermarking, metadata, c.

PDF != PS, but they share a common subset.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Bloomberg article

2005-04-19 Thread Keith Gaughan
dave wrote:

 he just doesnt like flashpaper because he doesnt like the way it displays 
 fonts

Far beyond that. I'm saying that not only do I dislike it (because it's
less powerful), it's redundant as a product as far as Adobe is
concerned.

I think the use of rasterised fonts is a step back from the use of
outline fonts, even for mobile devices.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Bloomberg article

2005-04-19 Thread Keith Gaughan
Adrocknaphobia wrote:

 Uhhh... considering the post you replied to cut+pasted one of several
 paragraphs which explicity talked about FlashPaper... exactly what are
 you talking about?

The FAQ mentions FlashPaper nowhere. Nowhere. It mentions Flash alright,
but nowhere does it mention FlashPaper. Do a search on the document if
you don't belive me.

 PDF on a mobile device does not make sense. PDF is for PRINT. Why
 would someone want a printable document on thier phone?

Then what's the argument in favour of FlashPaper, or anything that
breaks documents down into fixed-size pages (PowerPoint-style cards
being another matter) on a mobile device?

 Not to mention the quality and filesize issues.

Quality is definitely in PDF's favour. As is file size. That's part of
where my complaint about the use of rasterised fonts comes from: they
bulk up the size of the file. You can take two views on how to store
them: (a) one big rasterisation that's resized as need be, or (b) lots
of little ones, each for whichever size the font will be displayed at.
Both are problematic, both from a bulk and a quality point of view.
Outlines, on the other hand, are mathematical descriptions of the letter
forms and are therefore compact. You needn't store all the letterforms
for the font you're using, only the ones used in the document. Also,
they can be resized without loss of quality. Modern font rendering
technologies use outline fonts exclusively, even on screens.

 FlashPaper is perfect for the mobile
 document. Don't expect them to get rid of it any time soon, the only
 thing you'll most likely see is a different name for it.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Rick Root wrote:

 Macromedia's Flash Player, which displays moving images and sound on 
 Web pages, is installed in more than 98 percent of Internet-connected 
 desktop computers. By buying Macromedia, Adobe Chief Executive Bruce 
 Chizen, 49, is reducing reliance on his flagship Acrobat software, used 
 by graphics professionals.
 
 Aside from the ridiculous oversimplification of the flash player, no 
 other macromedia products are mentioned in the article.

I'm just hoping that this will mean the end to the awful pointless
abortion of an idea that is FlashPaper. Now that Macromedia as been
consumed by PDF's creators, there's no need for an Acrobat killer.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: fyi: Adobe to aquire Macromedia

2005-04-18 Thread Keith Gaughan
Matt Robertson wrote:

 But I have to ask myself whether Adobe was looking to acquire a server
 technology company or a graphics technology company.
 
 Anyone? Anyone? Bueller?

People said the same thing when MM bought Allaire.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Adam Haskell wrote:

 Great say goodbye to flash paper...

And good riddances.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Calvin Ward wrote:

 I fail to see what is wrong with Flashpaper, it has a smaller footprint and
 can be easily embedded in pages, and is supported by more browsers than PDF
 is.

Are you talking about executable footprint or file footprint? If it's
executable footprint, then that's just because Acrobat is, well,
bloated. You can embed PDFs in pages--that is, after all, what the
object tag is for--it's just that there's no good reason to (nor can I
see a good reason to embed FlashPaper in a page). And then there's
browser support: last time I looked, it was the other way round with PDF
renderers that are embeddable into browsers being more common than Flash
plug-ins.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Kazmierczak, Kevin wrote:

 I predict a new tag
 
 cfpsd
 
 Oh dear.
 
 Kevin.

Portable Scheme Debugger? w00t! ;-)

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Adam Haskell wrote:

The delays of PDF are not format related. They are software program
related. It is the set of extensions in Acrobat which makes PDF look
like a fat pig. The PDF format has potential, but lacks good software
for mobile devices.
 
 
 The rendering software is huge bulky and slow b/c of the PDF format. A
 PDF docuemnt contain nothing, but XML. This forces everything to be in
 the reader which cuases it to be a pig... Could the reader be
 re-written in a more streamline fashion and still provide all the
 functionality..maybe..time will tell.

Dude! XML? Far from it. The stuff you see when you open a PDF in a text
editor is a combination of commands for a stack-based virtual machine
(à la PostScript), and a bunch of compressed datastreams.

There's absolutely no reason whatsoever that PDFs can't be opened
quickly, even on small machines. There's much faster software for
reading PDFs out there than Acrobat Reader.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Connie DeCinko wrote:

 Flash Paper has a very valid role for those instances where the Acrobat
 reader is extreme overkill.  Hell, the Acrobat tool bars, tab bars, status
 bar, etc. eat up half the screen real estate when all you need to do is show
 a simple report or eBrochure.  Every try to embed a PDF in a page?  You
 can't read the document due to the wasted space of the Acrobat reader
 interface.

But those are flaws with Reader as opposed to PDF. I can see Adobe doing
much the same thing to FlashPaper in they decide to continue with it.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Adam Haskell wrote:

 I have seen you say this in multiple threads now what your beef with
 the product?

I think it's redundant. I don't think it can do anything interesting
that can't be done with PDF. And most of the apparrent advantages of
FlashPaper aren't so much with the format, but that the viewer for
one has been subject to less pointless bloat than the other.

And I hate that FlashPaper uses rasterised fonts: it's like 1990 all
over again, and for no particularly good reason.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Connie DeCinko wrote:

 PDFs are Postscript.  They are actually the native file format for
 Illustrator files.

They're no so much PS as a cut-down dialect of it with a lot of the
smarts removed, and a few extra features like stream compression. Unlike
PS, I don't think that the stack machine is Turing complete.

And on Illustrator, that's EPS you're talking about, right?

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Mark Smyth wrote:

 I, like many others miss allaire

Yeah, that was always a much cooler name.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Ryan Duckworth wrote:

 I think that most ColdFusion programmers / managers are overreacting
 to this announcement.  

Agreed. If anything, this is an excellent opportunity for New Atlanta
what with the internal upheavals at the new company most probably having
a knock-on effect on development speed.

And CF's a great product. While I wouldn't put it beyond Adobe to screw
the pooch on this one and try to retire CF, I think they'll do exactly
the same thing as Macromedia did, and stick with it.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Adam Haskell wrote:

 Embedded pdfs still take a long time to load...flashpaper is supported
 on over 98% of the computers on the internet, Acrobat is not near
 that.

Where'd you get that statistic from?

 Flashpaper is more widely supported. The executable footprint is
 unbeleively different 500k vs 10+ MB the SWF vs PDF sizes are simular
 though PDF wins out most of the time.

Indeed, but as I said, Acrobat Reader isn't the only PDF reader out
there, and most are a *lot* smaller than it. That's a point against
Adobe Reader, not PDF.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
dave wrote:

 That's just silly.

If you look at it from Adobe's point of view, it's not so silly.

 Everyone who's been using flashpaper on the sites I use it on rave about.
 You may not like it but the uses sure do, slick, clean, fast, no adobe
 plugin necessary, sure it needs a flash one but who doesn't have that?

I shall avoid. And I don't think it has much life left, not even as a
PDF lite, seeing as if Adobe wanted to create a light version of
Reader, they could. The problem with PDF isn't the file format itself
(which is quite well engineered), but Reader.

As I said, having two file formats that do the same thing (almost:
PDFs at least use outline fonts where available or embedded) isn't all
that much use to Adobe.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Kevin Aebig wrote:

 Maybe my view is biased, but I'll take a 150k plugin over a 10 mb plugin for
 my users anyday. The bloated abortion that is called the acrobat plugin is a
 utter waste of time. My guess is that within 2 versions, flashpaper *would*
 have surpassed PDF's in features...

Yup, I agree that the Acrobat plug-in's a piece of crap too. However, I
really can't see Adobe putting much work into FlashPaper. The PDF lite
argument just doesn't hold water.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Adrocknaphobia wrote:

 Flashpaper is here to stay. The simple reason... mobile. PDF is not
 fit for mobile deployment. Flashpaper will  help solidify Adobe's web
 document manifesto.
 
From the FAQ.
 
 'Do you expect to integrate the FlashPlayer and the Adobe Reader? The
 complementary functionality of FlashPlayer and Adobe Reader will
 enable the deployment of a more robust cross-media, rich-client
 technology platform. The combined company will continue to be
 committed to the needs of both the FlashPlayer and Adobe Reader
 users.'

Which can be read... Flash: hmmm... quite cool! We'll have some of
that. Quite happy with PDF now, even if the reader's a bloated hog.
FlashPaper? That's quite up in the air. Quite a bit like PDF though...

Notice that not once in the FAQ was FlashPaper mentioned. Therefore
one can read it as neither an endorsement or otherwise of FlashPaper.
My thinking is that Adobe won't see the point in supporting two
all-too-similar products, much as I expect that Freehand will give
way to Illustrator (which I'll regret as I quite like Freehand),
Fireworks to give way to Photoshop/Imageready, and GoLive to give way
to Dreamweaver. I think Flash itself is quite safe, as is CF, but
I've great doubts about FlashPaper.

PDF is perfectly capable of being used in a mobile environment, it's
Reader that's the problem. It's an error to confuse the file format
with the software. If Adobe want a version of Reader that will work
ok on small machines, they'll do it. However, I think they'll
concentrate on one file format rather than two[1].

K.

[1] This is your chance to make a but what about PostScript comment.
 ;-)

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
Adrocknaphobia wrote:

 I don't feel like reading all 70 of the posts in the this thread, so
 lets jsut put it this way. If you are worried about CF getting the
 boot, then get your comapnies to buy as many CFMX7 licenses as they
 can. Afterall, they wont give the boot to a product line that returns
 a profit. Make CFMX7 the best selling version yet.

CF? 'Tis safe as houses.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
dave wrote:

 or sell it to new atlanta, in which case hopefully they'd hire away
 the current cfm guys to continue on, which wouldnt be too bad.

As a second worst-case scenario (mainly because New Atlanta don't
exactly have the same kind of resources as Adobe or MM, or even I think
Allaire in its day), that's a pretty decent place to be, albeit a bit
odd seeing as we'd have almost the same product twice from the same
company...

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


What Marc Cantor has to say on the merger

2005-04-18 Thread Keith Gaughan
http://marc.blogs.it/archives/2005/04/can_i_have_my_n.html

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Rick Root wrote:

 http://www.macromedia.com/software/player_census/flashplayer/
 
 Though technically Flashpaper is only supported on 95.1% of platforms as 
 of December 2004. ;)

Forgive me if I take those with a grain of salt: have you seen where it
ranks Windows Media Player?

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Kevin Aebig wrote:

 Notice how I said would... =]

D'oh! Sorry 'bout that. I'm overloaded with work this week and my
attention isn't exactly 100%.

 My biggest worry is that Adobe has a horrible history of supporting only Win
 and Carbon based Mac apps. They're untested when it comes to servers and
 even more untested with Java. I think there will be alot of dark days ahead
 if MM isn't kept somewhat intact...

Ack! You're shattering my hopes!

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Burns, John D wrote:

 Any reason they couldn't get rid of FlashPaper but make a lite version
 of Acrobat Reader in the Flash 8 player that could decyfer PDFs?

Little or none, especially if you don't expect the cut-down version to
cope with things like embedded JavaScript or Forms. However, it wouldn't
quite be the Flash 8 player, but more a combination of the two. That's
quite a neat idea though.

  Then
 everything just gets saved to PDF and it just has certain limitations or
 something so you don't have to download another plugin (Acrobat Reader)?
 Maybe I'm missing a fundamental issue with that but it seems like a good
 way to go.  Perhaps advanced features like filling in forms and stuff
 would require Acrobat Reader, but simple display of a PDF would be able
 to be done through the flash player.

Indeed you're correct.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Bloomberg article

2005-04-18 Thread Keith Gaughan
Burns, John D wrote:

 What wrong with high rankings for WMP?  Windows machines are all over
 the place. Most times, people do have WMP, the problem with delivering
 it usually falls to firewalls and filters and packet inspectors.  The
 numbers for WMP on the internet probably are staggeringly high. 

It's not that it's too high, but that it's too low! Unbelievably so.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: macromedia and Adobe?!

2005-04-18 Thread Keith Gaughan
dave wrote:

 What I was saying was that if Adobe chooses to discontinue cfm then
 new atlanta should purchase the rights and continue forward.

Yup, gotcha. That's pretty much what I thought you were saying.

 
 From: Keith Gaughan [EMAIL PROTECTED]
 Sent: Monday, April 18, 2005 1:57 PM
 To: CF-Talk cf-talk@houseoffusion.com
 Subject: Re: macromedia and Adobe?! 
 
 dave wrote:
 
or sell it to new atlanta, in which case hopefully they'd hire away
the current cfm guys to continue on, which wouldnt be too bad.
 
 
 As a second worst-case scenario (mainly because New Atlanta don't
 exactly have the same kind of resources as Adobe or MM, or even I think
 Allaire in its day), that's a pretty decent place to be, albeit a bit
 odd seeing as we'd have almost the same product twice from the same
 company...
 
 K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Interfacing Delphi with CF

2005-04-18 Thread Keith Gaughan
Jim Davis wrote:

 I didn't think that Delphi had a database engine at all.  Delphi (unless
 I'm wrong which is likely) is much more comparable to something like Visual
 Basic than to Access or Foxpro.
 
 Delphi would probably (I'm guessing) use something like the JET engine if it
 needed a database internally or (more likely) access an external database
 directly.

With Delphi, you're talking about the likes of InterBase and BDE.

If it's InterBase, I'm pretty sure that there's ODBC drivers for it.
There's definitely JDBC drivers: check out the Firebird website.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Max value of 3 variables

2005-04-15 Thread Keith Gaughan
Calvin Ward wrote:

 For flexibility, how about this: ListFirst(ListSort(numbers,'numeric'))

If we were talking about a lower-level language, I'd warn against that
way of doing it. On average, ListSort() takes O(nlogn) to sort a list,
whereas scanning the list with cfloop as below will be done in O(n)
time, which is faster. The only advantage that using ListSort() has is
that it's precompiled into Java.

Come to think of it, a linear scan will still be faster regardless,
unless you're dealing with CF5 or below.

The best and safest way to scan an unsorted list for the maximum number
would be:

!---
 Using the first element as our default max ensures that if the
 list contains only negative numbers, it will still work properly.
 This is my one improvement over Ewok's method.
---
cfset max = ListFirst(numbers)
cfloop index=i list=#numbers#
 cfif i gt max
 cfset max = i
 /cfif
/cfloop

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Max value of 3 variables

2005-04-15 Thread Keith Gaughan
Rick Faircloth wrote:

Or #arrayMax(listToArray(numbers))#
 
For flexibility, how about this: ListFirst(ListSort(numbers,'numeric'))
 
 
 And how, exactly, would these assist in obtaining
 the top value of 3 numbers?
 
 Does arrayMax put the maximum value first in the array?

No, it searches the array and returns the maximum value in it.

 I guess ListFirst(ListSort(... would put the maximum value first in the
 list?

No, it doesn't touch the list except to sort it, and then return the
first value in the list.

If it's just three numbers, then Max(Max(a, b), c) is fine, but as the 
saying goes, two is an impossible number[1]: it's worth generalising
this to cope with any number of values, which is what everybody was
doing.

K.

[1] http://c2.com/cgi/wiki?TwoIsAnImpossibleNumber

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: What's your setup for multiple developers

2005-04-13 Thread Keith Gaughan
Sean Corfield wrote:
 On Apr 12, 2005 11:36 AM, Marlon Moyer [EMAIL PROTECTED] wrote:
 
do you have any suggestions for a windows only environment concerning
version control?  I know the vb guy uses MS VSS.  How easy is that to
integrate into DWMX?
 
 
 Personally, I'd avoid VSS like the plague. There have been two many
 reports of repository corruption for my tastes. And I believe it also
 uses the lock-for-edit mode which can be a real pain when you have
 multiple developers collaborating. However, Dreamweaver integration
 for VSS is reasonably painless.

Having said that, if you don't mind locking and you want something more
stable than VSS, then ComponentSoftware RCS[1] is quite good. A trained
monkey could set it up, and the single-user version is free. It has SCC
integration, so you can use it directly from the likes of Visual Studio,
Homesite, and anything else that supports SCC.

[1] http://www.componentsoftware.com/csrcs/

 Dreamweaver integration with CVS (and Subversion) is non-existant
 (there is an extension - Windows-only - that costs money and works
 with a local CVS repository which is neither use nor ornament as far
 as collaborative development is concerned!).

Same goes for Subversion. I think the company Sean's talking about is 
PushOK[2], who provide SCC proxies for CVS and Subversion.

There's two independent projects out there to produce SCC proxies for
Subversion. One of them that I can remember is Sourcecross[3], but
that's gone very quiet. There's another one that I can't remember the
name of (and Google isn't helping), but that one's moribund too.

[2] http://www.pushok.com/soft_short_info.php
[3] http://www.sourcecross.org/

 However, both CVS and SVN have good tools to integrate with Windows
 Explorer which makes version control  pretty painless. TortoiseCVS and
 TortoiseSVN are the popular ones I think (I didn't like them but, hey,
 you can't please everyone).

Both excellent tools, I think. I use TortoiseCVS for projects that I
work on that are hosted on SourceForge.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: What's your setup for multiple developers

2005-04-12 Thread Keith Gaughan
Marlon Moyer wrote:

 I'm trying to figure out best to configure my development server. 
 I've got 2 developers and 1 more on the way soon.  We currently work
 with CF6, but we are thinking of going to CF7 very soon.  I've always
 used the devnet version of CF on my local machine, currently CF6, to
 develop and the other developer used the development server.  We
 really need to start working on some shared code, but it seems that
 without buying another license to use on the development server, were
 kinda screwed.
 
 How are other shops doing it?  

You ought to be using some kind of version control system, if only for
auditing purposes. CVS is fine, but you might want to got for
Subversion, Perforce, or something else. Haven't used SourceSafe, but
I haven't heard good things. Subversion and CVS are free, but others
aren't.

Next you want the developer version of whatever you're using.
Thankfully, this is all free.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: What's your setup for multiple developers

2005-04-12 Thread Keith Gaughan
Damien McKenna wrote:

 These conflicts are almost always a case of opening the file and
 manually merging the changes between the multiple edits.  These rare
 occurances should never cause enough concern that a decent revision
 management system is not used, that would be just foolish.

That, and such conflicts only happen if the regions edited overlap.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: recoding some parts into Java...

2005-04-08 Thread Keith Gaughan
Jochem van Dieten wrote:

 As I've mentioned before, the way this has been set up is on CF
 Developer Edition along with scheduled tasks for each group of
 1000 clients. This is the system that I have inherited.
 
 Are you now admitting to running Developer Edition in production 
 on a public mailinglist where you know several Macromedia 
 employees are member? If I were you I would drop everything and 
 first write a memo to the boss alerting him to that and 
 recommending him to call the BSA to schedule a license audit. 
 Just in case they start looking for someone to blame.

Actually as long as this isn't a cracked version, I'd this is completely
legal. Production, at least by my reading of Macromedia's licencing
for the product, seems to mean accessible by more than one IP. The
Developer Edition is pretty close to useless for anything but
development because of this. However, I can't see anything wrong with
somebody running the Developer Edition to drive an in-house app where
you're only going to be connecting to it from one terminal.

I'd like to see what somebody from MM has to say on this.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: recoding some parts into Java...

2005-04-08 Thread Keith Gaughan
Jochem van Dieten wrote:

 Keith Gaughan wrote:
 
Jochem van Dieten wrote:

Are you now admitting to running Developer Edition in production 
on a public mailinglist where you know several Macromedia 
employees are member? If I were you I would drop everything and 
first write a memo to the boss alerting him to that and 
recommending him to call the BSA to schedule a license audit. 
Just in case they start looking for someone to blame.

Actually as long as this isn't a cracked version, I'd this is completely
legal. Production, at least by my reading of Macromedia's licencing
for the product, seems to mean accessible by more than one IP. The
Developer Edition is pretty close to useless for anything but
development because of this. However, I can't see anything wrong with
somebody running the Developer Edition to drive an in-house app where
you're only going to be connecting to it from one terminal.
 
 
 http://www.macromedia.com/software/eula/server/ point 3(h)

Well spotted! I retract what I said.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Getting the caller template

2005-04-06 Thread Keith Gaughan
Ian Skinner wrote:

 The getBaseTemplate() function might be what you are looking for.

That won't do the trick if there's more than one level of template
nesting.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: OT rookie: link table

2005-04-04 Thread Keith Gaughan
Chris Kavanagh wrote:

 people.person_id

 hahahahahhahahhahhhaahaha.ah. sigh.

 sorry Chris, back to the topic.
 
 :|   uh?
 
 I love it when I'm funny but it's a bit disconcerting when I don't know 
 why.

Kerry's just stirring the crap. It's to do with the pluralisation of
table names thread that went on for an inordinate length of time a while
back. Don't bite.

it only gets TASKS that belong to the PROJECT that the PERSON

is cleared for

Im not sure how you are defining cleared for, but it should just be a
couple more Inner Joins?
 
 Well i have a Session.person_id.  I should be able to compare that 
 somehow with the table people_project (which is a combination of 
 person_id and project_id), and thereby find out which project(_id)(s) 
 match which the logged in person(_id), right?

My understanding is this:

cfquery name=tasks datasource=taskomatic
SELECT  TK.task_id,
 TK.name AS task,
 TK.deadline,
 TK.owner_id,
 TK.lead_time
 TK.status_id
 PJ.project_id,
 PJ.name AS project,
 PJ.colour,
 PJ.company_id,
 TK.owner_id,
 PN.name AS owner,
 IM.importance_id,
 IM.importance
FROMtasks  TK
JOINprojects   PJ ON PJ.project_id= TK.project_id
JOINpeople PN ON PN.person_id = TK.owner_id
JOINimportance IM ON IM.importance_id = TK.importance_id
cfif SESSION.company_id neq 0
JOINpeople_project PP ON TK.project_id= PP.project_id
/cfif
WHERE   tasks.status_id = 1
cfif SESSION.company_id neq 0
 AND PP.person_id = cfqueryparam cfsqltype=CF_SQL_INTEGER
 value=#SESSION.person_id#
/cfif
/cfquery

Run that and cfdump it to check if it's what you're looking for.

Don't be scared by the cfqueryparam: it's just for creating prepared
statements, which are safer than just dumping values directly from
variables into the statement, and allow the DBMS to cache the query,
which makes it faster on subsequent runs.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Joe Celko and Nested Sets; was Re: recordsets return by stored procedures?

2005-04-04 Thread Keith Gaughan
Adam Howitt wrote:

 You may want to check out Joe Celco's nested set model (no refs but google 
 should find it) for a neat way to handle this type of hierarchical 
 information storage. In the meantime you could keep the cursor but insert 
 the resulting recordsets into a working table before returning the complete 
 resultset. You would create the working table if @depth = 1 (set a local 
 variable and pass it to subsequent calls and drop it after the last call) or 
 permanently create it which would give you better performance and the 
 ability to use indexes.

I highly recommend his book, SQL for Smarties[1]. Here's a few links
that should help:

  1. http://www.intelligententerprise.com/001020/celko.jhtml
  2. http://www.dbmsmag.com/9604d06.html and
 http://www.dbmsmag.com/9603d06.html
  3. http://troels.arvin.dk/db/rdbms/links/
  4. http://www.onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html
  5. http://dbazine.com/tropashko4.shtml
  6. http://www.sitepoint.com/article/hierarchical-data-database

He also wrote a whole book on trees and hierarchies[2].

K.

[1] http://www.amazon.co.uk/exec/obidos/ASIN/1558605762/
[2] http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Submit Once

2005-04-04 Thread Keith Gaughan
Jeffrey Pratte wrote:
 Gang,
 
 I am occasionally getting duplicate records in my database. I think it is 
 coming from people hitting “Submit” twice when the server is slow. How do 
 you guys prevent this? 
 
 I tried some JavaScript code to disable the button, which did gray-out the 
 button, but then did not pass the Button info along to Cold Fusion.
 
 Thanks for you help, Jeff

There's a few ways.

The simplest I can think of is to create a data structure (a database
table would be sufficent) to keep track of your forms where you want
to prevent multiple submissions. The schema of a table to do this would
be something like the following:

CREATE TABLE forms (uuid CHAR(35) NOT NULL PRIMARY KEY);

Before you generate a form, do the following:

cfset uuid = CreateUUID()
cfquery name=foo datasource=bar
INSERT INTO forms
(
 uuid
)
VALUES
(
 cfqueryparam cfsqltype=CF_SQL_CHAR value=#uuid#
)
/cfquery

And then embed the uuid in a hidden field in the form you want to
protect.

Just before you process the form, check to see if the uuid is in the
table. If it is, it's the first time the form has been processed,
otherwise it's a resubmit.

cfquery name=checkUUID datasource=bar
SELECT  COUNT(*) AS isPresent
FROMforms
WHERE   uuid = cfqueryparam cfsqltype=CF_SQL_CHAR
 value=#FORM.uuid#
/cfquery
cfif checkUUID.isPresent
 cfquery name=foo datasource=bar
 DELETE FROM forms
 WHERE  uuid = cfqueryparam cfsqltype=CF_SQL_CHAR
 value=#FORM.uuid#
 /cfquery
 !--- Process as normal ---
cfelse
 !--- It's a resubmit ---
/cfif

Now, where is a chance of a race condition in the code above where, if
the user was quick enough on the resubmit (and they'd have to be
*really* quick), the code to check if the form was present might be ran
in one of the requests before the first one managed to delete it. To
prevent this, you'd have to serialise access to the forms tables
somehow, be it through a transaction or an exclusive table lock.

But the principle is sound and should work for you.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Submit Once

2005-04-04 Thread Keith Gaughan
Also, you might be interested in this post on Mark Nottingham's site:

 http://www.mnot.net/blog/2003/09/13/click_submit_only_once

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Submit Once

2005-04-04 Thread Keith Gaughan
Keith Gaughan wrote:

 But the principle is sound and should work for you.

This also has the advantage that it ensure that the form works without
the browser needing to have JavaScript enabled.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Submit Once

2005-04-04 Thread Keith Gaughan
S.Isaac Dealey wrote:

 That's actually a pretty complicated solution -- although if you need
 a solution that works server-side without the aid of javascript you're
 reather limited to something like that...

If you looking for a server-side only solution, it's the simplest. Mind
you, if you don't mind using JS, then there are, of course, simpler
ways. But I'd taken from his post--and I might be mistaken--that those
weren't what he was looking for.

No matter though.

 I wonder if visually
 impaired users double-click form submit buttons the same as some
 sighted users... I wouldn't expect it, though it could happen. In
 general I wouldn't expect users who have javascript-disabled (either
 due to visual impairment or otherwise) to produce those impatient
 double-submits.

I'm not even thinking of them! I was just presenting a server-side only
solution.

BTW, you could also use a struct stored in some persistent scope such
as SESSION or APPLICATION as a set and you'd get the same effect. I do
this in a replacement for cfform I wrote that uses more modern
validation and has a few extra features.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
Calvin Ward wrote:

 Then it is still inconsistent, since Variables refers to the content of the
 scope and Request refers to where the scope is available.

That is a different matter: the consistency I'm talking about is how 
pluralisation relates to their actual name. In such cases, it's consistent.

 While we are at it though, Client, Cookie, Session, Application, Server, and
 CGI are all singular as well.

And the only one that can be seen as inconsistent in that whole list is
COOKIE.

K.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
Calvin Ward wrote:

 I can definitely understand that, however I would also rather be referring
 to a single doctor by doctors.firstname as well.

Seeing as I use aliases extensively, that's never cropped up for me.

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
S.Isaac Dealey wrote:

Say I'm a Spaniard or Hispanophone. Plurals in Spanish always end in
-es. Is using plurals for tables names more consistant in Spanish than
English? Of course not.
 
 Assuming that statement is true, yes it does. I was talking about
 syntactical consistency, in which, if I have a rule that all names are
 appended with x, then that is a consistent syntactical rule. If I then
 amend my rule to say that all names are appended with x -- except for
 names we don't feel like appending with x (which is how the rules for
 plurals in English work) then the syntax rule is inconsistent.

That appears overly rigid to me. The only reason why there's
inconsistency in English plurals is phonological. -s and -es are both
the same morpheme.

If you were to ask a linguist if there was inconsistency here, they'd
definitely say no.

 There is no way of automating the rule -- it requires manual entry of a
 dictionary to explain what names are random exceptions to the rule
 -- and that's really the whole point -- plurals in english are
 arbitrarily random. A consistently applied syntax rule may be
 abritrary but is not random.

It's rather simple, and doesn't require a special rule, at least not for 
native germanic words (and a good deal of the romance ones and others in
the language, spare the odd irregular ones like oxen, children, and
the strong nouns). If a world ends in a sibilant (s, z, sh, x [really
ks], ch [really tsh]); the soft g is also a sibilant, but owing to
other complications doesn't really figure in this), -es is used. If it
ends in -y, -ies is used. Otherwise -s. It's quite simple.

Or let's take Gaelic: nouns in Gaelic come in various declensions, and
the plural of a word varies depending on its declension (and various
complex phonological considerations: oh wait! that's why English has
two plural endings!).
 
 What english do you speak? I can think of several... s, es, i, a --

Let's take them: -s and -es are really the same morpheme, -i and -a
are latinate ones that are barely used in modern English. Not only that,
but many of those plurals have morphed into collective nouns (data being
one such).

 and that's not even including the cases in which the plural of a word
 has almost nothing to do with the word in question (person/people,

You'll notice that person and people are not related. You'll also
notice that people is a collective noun, not a plural. The plural of
person is, wait for it, persons.

 goose/geese, mouse/mice).

Irregular nouns. Give us a break!

It could be -anna, -í, -e, -a, the noun could undergo
palatalisation of the final consonant, c. Does this make  using
pluralisation more consistant in English than Gaelic? Nope.
 
 Yep.

This goidelophone wishes to disagree.

But when it comes down to it, this is all convention. I pluralise
because bits of SQL like SELECT ... FROM products ...,  INSERT INTO
products ..., UPDATE products ..., and DELETE FROM products ...
read better than me because these work on sets of entities as opposed
to singular entities. When it comes down to it, how it sounds is
really the only way of justifying it.
 
 It's not the only reason, but it's the reason most commonly
 understood. (Re: previous post regarding automation of table names).

And we write code for humans to understand, not computers.

 Really if you want to run the length of the argument then you could
 just as easily name your classes plural as well, and technically a
 class does describe a collection of objects (their type), though when
 we write code we don't generally think of a class that way, we think
 of it as being singular even though we then instantiate objects to
 create what are actually singular entities of type.

A class is not a collection of objects. A class is is a description of a
type of object. Table != class. That's a red herring.

OTOH, I pluralise the names of real collections of object, such as 
arrays, where it makes sense.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
S.Isaac Dealey wrote:

Ack! Strawman argument! You're picking on a weakness of
English rather
actually arguing about whether pluralisation is a good
thing or not.
 
 How about this: If you like to have singular named class names, the
 name of the class matches the name of the table and as a result can be
 automated. I.e. address.cfc matches the address table, contact.cfc
 matches the contact table and addendum.cfc matches the addendum table.
 
 If plural table names are used, there isn't consistency and as a
 result, class names must also be plural or there can be no automation
 between the class and the table.

That is a red herring.

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
Dave Watts wrote:

 You are trying way too hard to justify your position. I can guarantee you
 that no one at Allaire spent as much time figuring out how to name variable
 scopes as you've spent figuring out how to fit them within your argument.
 You are seeing patterns where none actually exist.

I don't disagree. I'm just saying that there's no big inconsistency in
the naming.

I'm tired of this. I'm off to find other things to be grumpy about. :-)

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: ListAppend and delimiter question

2005-03-31 Thread Keith Gaughan
Charles Heizer wrote:

 I have a strange question, I think. Can a delimiter be only one character?
 I'm trying to do a sql statement and I wanted to use ListAppend and specify
 the delimiter as AND
 
 Example ...
 
 cfset tmpWhere = ListAppend(tmpWhere,c,AND)
 
 
 But when I view the list I only see A as the delimiter.
 
 Is this a bug or is this how it should be?

Nope, that's exactly how it's supposed to work.

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

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


Re: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
Mark Davis wrote:

 This has to be the stupidest and most wasteful thread I have ever seen.
 STFU!

You know, I agree with you that it's a bit stupid, just like any one of
the holy wars. But luck at it this way: at least nobody brought up code
layout style.

Oops! ;-)

K.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: STFU was RE: Table name - Singular or plural?

2005-03-31 Thread Keith Gaughan
Adam Haskell wrote:

 The simple solution to ajax is STFU:
 
 Simultanious Transactions with iFrames Unexposed.
 
 best I could come up with :)

Better yet: Simultaneous Transactions with Frames Unused. (Owing to the
fact that the Ajax freaks talk about using XMLHttpRequest as opposed to
the older methods.)

K.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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


  1   2   3   >