RE: Help please

2001-10-21 Thread Matthew W Jones
you need to be doing a text compare if it is stored as text, ie. Sales.PROCESS_ID = '#session.PROCESS_ID#' Also, you probably shouldn't use session variables in your query, bc you should be locking ALL accesses to session variables. -Original Message- From: Parker, Kevin [mailto:[EMAIL

RE: variable in custom tag name?

2001-10-05 Thread Matthew W Jones
call the custom tag with a cfmodule, and this should work -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 3:59 PM To: CF-Talk Subject: variable in custom tag name? Is it possible to have a variable in a custom tag *name* when calling it?

RE: oracle brings the server down

2001-10-05 Thread Matthew W Jones
had something like this happen a long time ago. Don't remember the specifics, but we had transactions opening that weren't getting closed. -Original Message- From: FARRAH NG [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 12:57 PM To: CF-Talk Subject: oracle brings the server d

RE: Problem with Stored Procedure

2001-10-05 Thread Matthew W Jones
Another option would be to add the procparams, in the correct order and set null="yes" in the procparam Another option would be to change the stored procedure itself to have the ones you don't want to pass as the last declarations, and just don't include the procparams for those -Original Me

RE: Problem with Stored Procedure

2001-10-05 Thread Matthew W Jones
The @ is correct, but as you are using sql server, it doesn't matter. You need to specify all of the parameters for your stored procedure, in the correct order. With sql server, they (cfprocparam) MUST be in the correct order, dbvarname doesn't even matter at all With Oracle, dbvarname does matte

RE: Strangest Problem in a long time

2001-10-03 Thread Matthew W Jones
(the few others) _required _date _time _integer _float _eurodate _range -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 4:30 PM To: CF-Talk Subject: RE: Strangest Problem in a long time If you use "_date" appended to your field names C

RE: bug with files ending in "Application.cfm"?

2001-09-26 Thread Matthew W Jones
I have had no problems including files that end with application.cfm such as test_application.cfm. I haven't tried to call the files directly though. -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 7:40 PM To: CF-Talk Subject: RE: bug

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

2001-09-25 Thread Matthew W Jones
All I can tell is that this discussion isn't about coldfusion. Please move it to CF Community -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 4:33 PM To: CF-Talk Subject: Re: Check out what Gartner is recommending. Drop IIS! Chris, We're

RE: I'm resending - help

2001-09-20 Thread Matthew W Jones
If you feel you need to grab the generated content into a variable (for whatever reason) and you are using cf 5, there is cfsavecontent, if you are using something prior to 5 then you could use the cf_bodycontent custom tag (possibly available in dev exchange, for sure available at fusebox.org).

RE: Listcontains question

2001-09-19 Thread Matthew W Jones
for that type of comparison, you might be better served staying away from the listfind or listcontains functions. try something like #application.securityerror# Yes, it is slower, but it would be doing the type of comparisons t

RE: CFIF Issue

2001-09-14 Thread Matthew W Jones
try putting a trim around qGetUser.User_Type in the cfif, it is likely bringing a space(s) in your result -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 8:43 AM To: CF-Talk Subject: CFIF Issue OK. I have the following code: Selec

RE: Hierarchy

2001-09-12 Thread Matthew W Jones
ECTED]] Sent: Wednesday, September 12, 2001 9:55 AM To: CF-Talk Subject: Re: Hierarchy http://www.secretagents.com/tools/freeviewlets/index.cfm?category_id=20&show viewlets=1 - Original Message - From: "Matthew W Jones" <[EMAIL PROTECTED]> To: "CF-Talk"

RE: Hierarchy

2001-09-12 Thread Matthew W Jones
That should have read: Is anyone using the "Nested Set Method" for Hierarchy's? Do you have any implementation tips/tricks etc. (specifically towards insert, update, de lete, reordering of an items left/right boundaries)? -Original Message- From: Matthew W Jones [mailto:[

SOT:Hierarchy

2001-09-12 Thread Matthew W Jones
Is anyone using the "Nested Set Method" for Hierarchy's? Do you have any implementation tips/tricks etc. (specifically towards insert, update, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the co

RE: Terrorist and gas shortage

2001-09-11 Thread Matthew W Jones
gas just jumped from 1.50 to 3.50 per gallon around here -Original Message- From: P Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 2:53 PM To: CF-Talk Subject: Terrorist and gas shortage I live in the Midwest and _every_one_ is freaking out. There are gas lines

RE: heading on every page?

2001-09-10 Thread Matthew W Jones
One possible way, which works for IE (I love Intranet development), you will need this style element determine how many rows you can fit on the page: RowsPerPage use something as a count of how many rows you have output: MyCurrentRow Inside of you

RE: brain far

2001-09-05 Thread Matthew W Jones
use a stored procedure for your insert could probably use cfqueryparam also -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 8:54 AM To: CF-Talk Subject: brain far Question, I am having a brain fart. I am entering information into a d

RE: Stored Procedure

2001-08-30 Thread Matthew W Jones
friendID is an int, therefore, you must compare it to an int for it to match. sql is trying to convert it to an int for you, which isn't working. you might be able to get away with a valuelist, instead of a quoted value list. -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]]

RE: TwoSelectsRelated weirdness

2001-08-29 Thread Matthew W Jones
if there are any special characters returning in the query, it can screw it up in that way. () was the last one that bit me -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: CF-Talk Subject: TwoSelectsRelated weirdness Hey all,

RE: locking a loop or the contents

2001-08-15 Thread Matthew W Jones
I prefer C, less times locking, less processes inside the locking -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:09 AM To: CF-Talk Subject: RE: locking a loop or the contents Correction... they should all be READONLY locks -

RE: Locking session scope on existence checks

2001-08-09 Thread Matthew W Jones
yes, lock it. It is the same as a read. -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 9:57 AM To: CF-Talk Subject: Locking session scope on existence checks Do ya need to lock the session scope if you're just checking if a session var e

RE: I don't understand session locking :(

2001-08-09 Thread Matthew W Jones
had they done that, it likely would have placed a lock around each individual use. which would have been hard on performance. as they left it, you control what to lock, which allows you to place a single lock around a block of code. -Original Message- From: Dennis Powers [mailto:[EMAIL

RE: Ben Forta and CF5 -- Coming to a CFUG Near You

2001-08-08 Thread Matthew W Jones
Kansas City, please. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 1:11 PM To: CF-Talk Subject: RE: Ben Forta and CF5 -- Coming to a CFUG Near You what about Columbus Ohio! please! -paul -Original Message- From: Phil Costa [m

RE: Cold Fusion Developer - beginner

2001-08-07 Thread Matthew W Jones
better yet, don't try again -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 1:28 PM To: CF-Talk Subject: RE: Cold Fusion Developer - beginner Uh, Fuon: To the best of my knowledge, female professionals don't like to be referred to as "c

RE: I don't understand session locking :(

2001-08-07 Thread Matthew W Jones
Yes -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 10:01 AM To: CF-Talk Subject: RE: I don't understand session locking :( Wouldn't you actually need to use the Duplicate() function here when referencing the session variable? I seem to rec

RE: I dont understand session locking :(

2001-08-06 Thread Matthew W Jones
The following is a great analogy that was previously posted by Peter Theobald "Alot of people are making this incorrect assumption. Let me give an analogy that should make it easier to remember: Cold Fusion's Advisory Locking, or "Shotguns in a dark room" ---

RE: Documentation and numbers to back up best practices?

2001-08-06 Thread Matthew W Jones
origin for #2 CFML Language Reference Chapter 4 : ColdFusion Expressions: Operands, Operators and Other Constructs states Although you aren't required to use the prefix unless two variables in different scopes have the same name, for readability and processing speed, it is recommended that y