Re: what if the next CF...

2006-08-04 Thread Robertson-Ravo, Neil (RX)
You can - I am sure there is tool for this, I cannot remember the name (cfanywhere?) "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information w

Re: CF/.NET/SQL Express Server Install Question

2006-08-04 Thread Robertson-Ravo, Neil (RX)
Just be wary of the DB size. For smaller less intense projects MSDE is suitable - glad it is working out! "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It co

Re: All Adobe ColdFusion products to be discontinued

2006-08-04 Thread Robertson-Ravo, Neil (RX)
AG? Which newsgroup? "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the e

RE: All Adobe ColdFusion products to be discontinued

2006-08-04 Thread Loathe
Seriously, is this scare 4 or 5. I mean, CF has been in the process of being discontinued since like CF 4 right? > -Original Message- > From: Jeff Garza [mailto:[EMAIL PROTECTED] > Sent: Friday, August 04, 2006 11:11 PM > To: CF-Talk > Subject: RE: All Adobe ColdFusion products to be disc

Re: All Adobe ColdFusion products to be discontinued

2006-08-04 Thread Paul Hastings
Peter Tilbrook wrote: >>From the ColdFusion newsgroup you mean from our one & only troll (AG). is there any reason why you want to spew his troll talk on a technical list? i thought that cf-community was there for this sort of stuff?

RE: All Adobe ColdFusion products to be discontinued

2006-08-04 Thread Jeff Garza
Oh god... Here we go again... -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 8:04 PM To: CF-Talk Subject: All Adobe ColdFusion products to be discontinued >From the ColdFusion newsgroup << My insider told me that the CF model didn't fit

RE: All Adobe ColdFusion products to be discontinued

2006-08-04 Thread Phillip Holmes
Don't feed the troll. Warmest Regards, Phillip B. Holmes http://phillipholmes.com 214-995-6175 (cell) -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 10:04 PM To: CF-Talk Subject: All Adobe ColdFusion products to be discontinued >From

All Adobe ColdFusion products to be discontinued

2006-08-04 Thread Peter Tilbrook
>From the ColdFusion newsgroup << My insider told me that the CF model didn't fit in with what they (Adobe) have planned. They see the app server market as worthless, they are probably right with similar free products like PHP around. They are probably focusing on new products that are more app

RE: Object Instantiation Exception on LylaCaptcha

2006-08-04 Thread Michael E. Carluen
Nevermind... found it. T'was only the image directory loc on the xml config file. > -Original Message- > From: Michael E. Carluen [mailto:[EMAIL PROTECTED] > Sent: Friday, August 04, 2006 5:03 PM > To: CF-Talk > Subject: Object Instantiation Exception on LylaCaptcha > > I just got an "Obj

Object Instantiation Exception on LylaCaptcha

2006-08-04 Thread Michael E. Carluen
I just got an "Object Instantiation Exception" message while running LylaCaptcha. any recommendation on what I should check? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date C

RE: CF/.NET/SQL Express Server Install Question

2006-08-04 Thread Snake
Every time I have used MSDE, I have found it eats the CPU like a starved animal whenever you put any intensive load on it. It also has a limited number of simultanious connections too. I would presume every page on your site does not hit the database. Snake -Original Message- From: Matt

Re: CF/.NET/SQL Express Server Install Question

2006-08-04 Thread Matt Robertson
I just built a sql server running MSDE 2000 for a client. They get a few tens of thousands of sessions per day and I am absolutely amazed at how well the server is handling the load. I opted NOT to go with SQL Server Express because I didn't see the point, frankly. SSE uses tons of extra resourc

Re: Help please

2006-08-04 Thread Doug
Figured it out..damn ODBC datasources. I have to remember that you have to restart after making changes. Thanks - Original Message - From: "Doug" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, August 04, 2006 5:00 PM Subject: Re: Help please > Well, I can browse the server and the

Re: Help please

2006-08-04 Thread Doug
Well, I can browse the server and the datasources cerify as ok. I can see the SQL's base tables but cannot see the user tables. Just weird. - Original Message - From: "Loathe" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, August 04, 2006 4:40 PM Subject: RE: Help please > You can't s

Re: what if the next CF...

2006-08-04 Thread Casey Dougall
It would be cool if you could deploy apps on cd. Anyone on here use Coral Web Builder? You can build coldfusion applications and deploy them on a auto run cd as one of the choices... http://www.pcaonline.com/prod/index.cfm?loc=coral ~~

RE: what if the next CF...

2006-08-04 Thread Dave Watts
> Basically, what if they pulled a Flex on CF? Well, I think the value proposition is far different for CF than it is for Flex. It never made much sense for Flex to be a server-side product primarily, since Flex was really just another way to generate SWFs. CF, on the other hand, is all server-si

RE: Help please

2006-08-04 Thread Loathe
You can't see the tables under the DB tab, but are you able to browse files on the server? Additionally, are the user name and passwords for the data sources actually in the administrator? I know I sometimes don't do that, and pass them in to the connection through the cfquery tag, for security.

Help please

2006-08-04 Thread Doug Brown
Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by you

Re: ColdFusion Tag and Attribute Case

2006-08-04 Thread Mingo Hagen
No more beer for you. Will Tomlinson wrote: > I think this is lots more readable, no?? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered t

Re: ColdFusion Tag and Attribute Case

2006-08-04 Thread Will Tomlinson
I usually write like this: There's even more greatness in my queries. sElEcT * fRoM tBlPrOdUcTs I think this is lots more readable, no?? :) Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hittin

RE: SQL concat? help

2006-08-04 Thread Russ
Yes, but if you have to run a separate query for each row of the parent query, that will kill performance. > -Original Message- > From: Kris Jones [mailto:[EMAIL PROTECTED] > Sent: Friday, August 04, 2006 5:08 PM > To: CF-Talk > Subject: Re: SQL concat? help > > In CF, getting a list of

RE: Authorize.net CFC

2006-08-04 Thread Emmet McGovern
Nevermind. I looked it up in the dictionary. http://dictionary.reference.com/browse/google -e -Original Message- From: Robert Feyerherm [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 4:58 PM To: CF-Talk Subject: RE: Authorize.net CFC Use the google define tool to define itsel

Re: SQL concat? help

2006-08-04 Thread Kris Jones
In CF, getting a list of values from a column in a query is pretty trivial: valuelist(qryname.colname) Cheers, Kris > What I actually wanted was a list of all someotherID's for a someID in a > single column. I found a function that sort of does this (Coalesce), and > after digging up my old cod

RE: Authorize.net CFC

2006-08-04 Thread Robert Feyerherm
Use the google define tool to define itself.. http://www.google.com/search?hl=en&q=define%3Agoogle -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 2:51 PM To: CF-Talk Subject: Re: Authorize.net CFC If you Google "google" you can probably

RE: SQL concat? help

2006-08-04 Thread Russ
What I actually wanted was a list of all someotherID's for a someID in a single column. I found a function that sort of does this (Coalesce), and after digging up my old code, did it using temp tables and cursors. I was optimizing code that was doing it in CF and was taking a little too long to

OT: what if the next CF...

2006-08-04 Thread RADEMAKERS Tanguy
Hello, Apologies in advance for the long and OT post. Don't worry, this isn't yet another cf wish list (or is it?). This really is long and rambling, so you will need coffee, and you might not want to read this at your desk... maybe print it and take it home for the weekend? Unless you've been li

Re: SQL concat? help

2006-08-04 Thread Kris Jones
The syntax you're using is, I think, correlated subquery. Not sure what that concat() function does--maybe that was a UDF that returned an actual list of IDs? In any case, here is a simple join that would return a recordset of related IDs: select s.someid, so.someotherid from mytable s left outer

Re: Authorize.net CFC

2006-08-04 Thread Josh Nathanson
If you Google "google" you can probably find out what it means. :0) Wait, I just spun myself into an infinite loop... -- Josh - Original Message - From: "Emmet McGovern" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, August 04, 2006 12:36 PM Subject: RE: Authorize.net CFC > O

RE: Authorize.net CFC

2006-08-04 Thread Emmet McGovern
O. I'm so mad at you right now Ferg I just forgot to mention that. -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 3:42 PM To: CF-Talk Subject: RE: Authorize.net CFC I was hoping that's how you'd take that comment Emmet! Too man

RE: Authorize.net CFC

2006-08-04 Thread Emmet McGovern
Thanks everyone for the supportive answers. Without the valuable members of this list my quest to do as little work as possible on a Friday would be an utter failure. I will lift my glass to you all in the forthcoming happy hour I will soon embark upon. I will look into this thing called Goog

RE: Authorize.net CFC

2006-08-04 Thread Ken Ferguson
I was hoping that's how you'd take that comment Emmet! Too many people would have been offended by my backhand slap. --Ferg -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 2:01 PM To: CF-Talk Subject: RE: Authorize.net CFC What the hell

RE: SQL concat? help

2006-08-04 Thread Andy Matthews
For mySQL: SELECT CONCAT(t1.id,'=', t2.id) AS newstring FROM table01 t1 INNER JOIN table02 t2 ON t1.id = t2.id -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 2:17 PM To: CF-Talk Subject: SQL concat? help I'm trying to do a query that should go so

Re: Authorize.net CFC

2006-08-04 Thread Will Tomlinson
>Has anyone made a CFC yet for authorize.net? Free or Paid. > >Emmet Yep, I have one. Email me offlist. Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by

RE: Authorize.net CFC

2006-08-04 Thread Andy Matthews
Just this website... -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 2:01 PM To: CF-Talk Subject: RE: Authorize.net CFC What the hell is a google? -e -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday,

SQL concat? help

2006-08-04 Thread Russ
I'm trying to do a query that should go something like Select someid, (select concat(someotherid) from anothertable where anothertable.someID=mytable.someid) from mytable Basically I want a query that brings in someID and for each of those a list of ID's from another table. Is this

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Russ
Not really, seefusion's unlicensed mode is 2 hours between cf service restarts, which might be acceptable for most dev/staging environments. . > -Original Message- > From: Dave Carabetta [mailto:[EMAIL PROTECTED] > Sent: Friday, August 04, 2006 3:02 PM > To: CF-Talk > Subject: Re: Announc

Re: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dave Carabetta
On 8/4/06, Russ <[EMAIL PROTECTED]> wrote: > It's unlimited instances, but it's per server, right? So with 2 servers, 3 > instances each, I would still need 2 licenses > That's correct. Don't forget (in both products' cases, for that matter) to consider your development and staging environmen

RE: Authorize.net CFC

2006-08-04 Thread Emmet McGovern
What the hell is a google? -e -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 2:44 PM To: CF-Talk Subject: RE: Authorize.net CFC Hey check that out. I Googled Authorize.net cfc and it was like the second listing. I guess some people just can

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Russ
It's unlimited instances, but it's per server, right? So with 2 servers, 3 instances each, I would still need 2 licenses > -Original Message- > From: Snake [mailto:[EMAIL PROTECTED] > Sent: Friday, August 04, 2006 2:18 PM > To: CF-Talk > Subject: RE: Announcing SeeFusion 4 (with Flex

RE: Authorize.net CFC

2006-08-04 Thread Ken Ferguson
Hey check that out. I Googled Authorize.net cfc and it was like the second listing. I guess some people just can't match my mad googling skills, huh? http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:43531 Thanks,   Ken Ferguson 214.636.6126 -Original Message- From: Emmet

Authorize.net CFC

2006-08-04 Thread Emmet McGovern
Has anyone made a CFC yet for authorize.net? Free or Paid. Emmet ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four t

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Snake
The enterprise edition of fusionreactor is for unlimited instances. So you can monitor all your servers and all instances from a single dashboard. The only drawback being that you need to install enterprise on ALL servers in order for dashboard to be able to conenct to them, which is rather silly w

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Brad Wood
So you would only need 4 SeeFusion licenses. That would come to a total of $1196. Two dollars cheaper than Fusion-Reactor! :) In this case, it would actually be cheaper if you had three servers with two instances apiece. Then you would only need three licenses, which would leave you at $900. K

Re: ColdFusion Tag and Attribute Case

2006-08-04 Thread Cutter (CFRelated)
Don't laugh, that's what the legacy code looks like that I rewrite every day (3k plus templated system, what a nightmare) Cutter __ http://blog.cutterscrossing.com Mark Drew wrote: > > I personally write my functions in a mixture of upper case and camel > case such as > and > > Funct

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Richard Kroll
"* New 2-for-1 pricing model for individual servers. For any single physical server, every 2 ColdFusion instances that you want to monitor now require just 1 SeeFusion license." This is a quote from the email that webapper sent today. Rich

Re: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dave Carabetta
On 8/4/06, Dave Carabetta <[EMAIL PROTECTED]> wrote: > On 8/4/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > Russ, one thing to note is that the SeeFusion pricing > > > actually uses "per server" to really mean "per instance." > > > > I think they've changed the license to allow two instances per

Re: Google Checkout Coldfusion MX 6.1

2006-08-04 Thread Mary Jo Sminkey
>Google checkout it supposed to be really awesome and yet here we >are getting suggestions to use COM object calls just to encrypt an xml >shopping cart (which frankly has ZERO top-secret data unless it bothers you >that some hacker might now you are purchasing a t-shirt that says "hooters" >on it

Re: CFMX 7 ODBC Service

2006-08-04 Thread Dan Plesse
Matt, What are you copy/pasting x 100+ times??? LOL On 8/4/06, Matt Robertson <[EMAIL PROTECTED]> wrote: > > On 8/3/06, Dan Plesse <[EMAIL PROTECTED]> wrote: > > It's just one string and it's the same one string CF uses but in a > > different location or any location you wish it to be. > >

Re: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dave Carabetta
On 8/4/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > Russ, > > >Russ, one thing to note is that the SeeFusion pricing actually uses > >"per server" to really mean "per instance." So if you have the max of > >what you said your infrastructure might be (2 servers * 3 instances of > >CF), you wo

Re: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dave Carabetta
On 8/4/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > Russ, one thing to note is that the SeeFusion pricing > > actually uses "per server" to really mean "per instance." > > I think they've changed the license to allow two instances per license. > Hmmm, I got my info from this link: http://www.see

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dave Watts
> Russ, one thing to note is that the SeeFusion pricing > actually uses "per server" to really mean "per instance." I think they've changed the license to allow two instances per license. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber v

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dan G. Switzer, II
Russ, >Russ, one thing to note is that the SeeFusion pricing actually uses >"per server" to really mean "per instance." So if you have the max of >what you said your infrastructure might be (2 servers * 3 instances of >CF), you would have 6 instances times $299, which is $1,794 (assuming >you get

Re: Digests

2006-08-04 Thread Tanguy Rademakers
No worries, i got to bone up on less commands ;) > Sorry about that. I'm working on it. I've been doing a major overhaul > of the site UI and backend and the digests are being moved over to a > new setup today. The whole thing was in a single looped template but > will be moved over to an async

Re: Query problem with lists of values

2006-08-04 Thread Kris Jones
>>>but one item has entries of 15,16,30,49,50,52,75 and it is being put in >>>a catecory that has the id of 2 there are lots of these that are >>>behaving this way. any one think of a way to help with this? > > SELECT catid FROM deep_images WHERE #uid# IN (catid) > IN is evil. > It will randomly

Antivirus for file uploads?

2006-08-04 Thread Burns, John D
I was browsing the archives and it seems a few people mentioned that companies like McAfee and others have products that you can install on your server that give you an .exe that you can call via that you can pass a filename to and it will tell you whether or not the file is infected with a virus.

Re: Cost of global CFC variables

2006-08-04 Thread Michael Dinowitz
I've always hated using that syntax as it totally breaks the idea of encapsulation and just feels totally wrong. Anyway, using a custom tag means creating a 'new' instance of something that has it's own environment. More overhead than I want, even if it's small. But that doesn't address the ori

Re: Digests

2006-08-04 Thread Michael Dinowitz
Sorry about that. I'm working on it. I've been doing a major overhaul of the site UI and backend and the digests are being moved over to a new setup today. The whole thing was in a single looped template but will be moved over to an async process on a scheduled event. Much more efficient and the

RE: Cost of global CFC variables

2006-08-04 Thread Ben Nadel
I have never passed back scopes from a custom tag... But couldn't you just be like: Or maybe THISTAG ??? Then all local variables of the custom tag would be passed back into one data variable... No hassle. ... Ben Nadel www.bennadel.com -Original Message-

Re: Digests

2006-08-04 Thread Tanguy Rademakers
> Hello. Sorry if this has been mentioned. But all week I have not > received any of the CF-Talk digests. I am subscribed to the 2 hourly > ones. I re-subscribed but nothing I only get the spam that started > coming through when I first signed up? > > cheers > Martin Hello Martin, I just

Re: Cost of global CFC variables

2006-08-04 Thread Tom Chiverton
On Friday 04 August 2006 16:29, Ben Nadel wrote: > But isn't part of the beauty of CF is that we don't have to worry about > actual destruction? That's all supposed to be optimized for us via Java (I > think... I don't really know this stuff). 99.9% of the time, you don't need to care, no. -- To

Re: Cost of global CFC variables

2006-08-04 Thread Michael Dinowitz
I'd prefer not to have to worry about passing all of the variables that I do use from the CFX tag back to the function from the cfmodule. It's more of a generic question to see if someone has investigated any overhead. I've already incorporated what I learned about types, required and returntype

Re: MXNA

2006-08-04 Thread Raymond Camden
Back up. On 8/4/06, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Friday 04 August 2006 15:35, Raymond Camden wrote: > > They know and it's being worked on now. > > \o/ > > -- -- === Raymond Camden, Vice President of Technolo

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Brad Wood
Well, I've have to speak up here and voice my satisfaction with SeeFusion. I had already been using SeeFusion 3.3 and I helped Beta test SeeFusion 4 and I really-really liked it. I think WebApper has brought their UI up to speed with Flex 2.0. And with Free dot releases, I'm looking forward to th

RE: Cost of global CFC variables

2006-08-04 Thread Ben Nadel
But isn't part of the beauty of CF is that we don't have to worry about actual destruction? That's all supposed to be optimized for us via Java (I think... I don't really know this stuff). ... Ben Nadel www.bennadel.com -Original Message- From: Tom Chiverton [mailto:

Re: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Dave Carabetta
On 8/4/06, Russ <[EMAIL PROTECTED]> wrote: > Good that you've finally decided to price it out more competitively, as > before I was strongly leaning toward FusionReactor, which is licensed per > server, not per instance. > > One thing that I like better about FusionReactor is that they allow you to

Re: Cost of global CFC variables

2006-08-04 Thread Tom Chiverton
On Friday 04 August 2006 15:07, Ben Nadel wrote: > its not set into REQUEST or APPLIACATION or something) should be destroyed > at the end of the custom tag automatically. Of course, this destruction could take longer than the harmless update :-) -- Tom Chiverton- to the test harness Batman ! *

Re: MXNA

2006-08-04 Thread Tom Chiverton
On Friday 04 August 2006 15:35, Raymond Camden wrote: > They know and it's being worked on now. \o/ -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in Eng

Re: Form parameters as array

2006-08-04 Thread Dmitrii Dimandt
On 8/4/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > Don't you think it would be easier to just have a multi select or a checkbox > for all the users (all named the same)... select the ones you want and > submit. The form field would have a list of selected users. Then you just > run an update

Re: MXNA

2006-08-04 Thread Raymond Camden
They know and it's being worked on now. On 8/4/06, Tom Chiverton <[EMAIL PROTECTED]> wrote: > It seems to be foo bar. > > Error Occurred While Processing Request > > Element COMPONENTS.HANDLERS is undefined in a Java object of type class > [Ljava.lang.String; referenced as > >Please try the f

RE: Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Russ
Good that you've finally decided to price it out more competitively, as before I was strongly leaning toward FusionReactor, which is licensed per server, not per instance. One thing that I like better about FusionReactor is that they allow you to view past requests, and go and see exactly what s

MXNA

2006-08-04 Thread Tom Chiverton
It seems to be foo bar. Error Occurred While Processing Request Element COMPONENTS.HANDLERS is undefined in a Java object of type class [Ljava.lang.String; referenced as Please try the following: Enable Robust Exception Information to provide greater detail about the source of e

Re: Form parameters as array

2006-08-04 Thread Dmitrii Dimandt
On 8/4/06, Mingo Hagen <[EMAIL PROTECTED]> wrote: > I would do that a little different. You coul repeat the checkboxes like so: > > > > > > On the other side of the form action you would receive a list of id's in > the form.isBannedUserID, like this: "1,2,3" for all checked inputs. > Which you c

RE: SQL Select date between two dates with possible NULL values.

2006-08-04 Thread Ben Nadel
What about something like SELECT * FROM [table] WHERE date BETWEEEN ISNULL( Effective_Date, 0 ) AND ISNULL( Deactive_Date, getDate() ) The first ISNULL uses the zero date (in think usually 1900-1-1) if the date is null. The Second ISNU

RE: Google Checkout Coldfusion MX 6.1

2006-08-04 Thread Ben Nadel
I think we should take a minute to step back and see how overly complicated this is. Google checkout it supposed to be really awesome and yet here we are getting suggestions to use COM object calls just to encrypt an xml shopping cart (which frankly has ZERO top-secret data unless it bothers you t

RE: Cost of global CFC variables

2006-08-04 Thread Ben Nadel
Would it help at all to create a ColdFusion custom tag and then call the CFX tag within it? Since CF custom tags have their own scope not shared with the general application, you shouldn't have to worry about all the VAR'ing of function variables? Anything created by the CFX tag (so long as its not

RE: Query problem with lists of values

2006-08-04 Thread Bobby Hartsfield
> It will randomly stop working when you hit the > db's limit for items in a string list. much like Outlook and its limitation on the length of disclaimers at the bottom of incoming mail... ;-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Messag

RE: Form parameters as array

2006-08-04 Thread Dawson, Michael
#form["field" & index]# However, since they are checkboxes, you have to test for their existence first using isDefined() or structKeyExists(). M!ke -Original Message- From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 8:03 AM To: CF-Talk Subject: Re: Form para

Announcing SeeFusion 4 (with Flex 2)!

2006-08-04 Thread Patrick Quinn
Greetings, all. We're excited to announce that we formally released SeeFusion 4 on Monday! Here's a quick summary of new/enhanced features: * Flex 2 rich interface! From real-time charts to spreadsheet export, this is the crown jewel of SeeFusion 4. Never again can it be said that SeeFusion is

RE: Form parameters as array

2006-08-04 Thread Bobby Hartsfield
Don’t you think it would be easier to just have a multi select or a checkbox for all the users (all named the same)... select the ones you want and submit. The form field would have a list of selected users. Then you just run an update query where userid IN list If you prefer to loop for no reason

Re: Query problem with lists of values

2006-08-04 Thread Tom Chiverton
On Thursday 03 August 2006 18:43, Kris Jones wrote: > SELECT catid FROM deep_images WHERE #uid# IN (catid) IN is evil. It will randomly stop working when you hit the db's limit for items in a string list. Which is not fun :-) If you must have comma lists rather than a more sensible layout, why

Re: Form parameters as array

2006-08-04 Thread Mingo Hagen
I would do that a little different. You coul repeat the checkboxes like so: On the other side of the form action you would receive a list of id's in the form.isBannedUserID, like this: "1,2,3" for all checked inputs. Which you could then directly use in an UPDATE sql statement. (WHERE userI

Re: Form parameters as array

2006-08-04 Thread Dmitrii Dimandt
I know that :) What I needed is a simple way to output and process a number of very similar fields. Let's say, you want to ban 10 users from a forum at once. After you've found these users, you could output this: etc. After the form is submitted you could do this in PHP: w

RE: CF/.NET/SQL Express Server Install Question

2006-08-04 Thread Snake
Having SQL on the web server is generally not a good idea, especially if the sites are making heavy use of it. CF, IIS and SQL will be competing for CPU time and disk access. Ideally you should have separate servers. You can inprove performance on a single server by having a separate disk for SQL S

Re: Form parameters as array

2006-08-04 Thread James Holmes
FORM variables are a struct in CF. You can access them like this: #CurrentFormField# is: #FORM[CurrentFormField]# You can see how from there you can do processing based on the name of the Form field etc. You can also use all of the struct functions on the FORM scope like StructFindKey() etc.

CF/.NET/SQL Express Server Install Question

2006-08-04 Thread Glenn Miller
Good morning all, We're having some issues with server performance, and I wondered if anyone else has been beating their heads against a wall with this issue. We've got some brand new Dell servers, all configured with CF, .NET and SQL Express on the same machine. Currently I'm seeing decreased

Form parameters as array

2006-08-04 Thread Dmitrii Dimandt
Coming from PHP I sorely miss the following feature: When submitted, form values would be accessible through an array. This was immensely helpful in cases when multiple similar records (a list from a database, for instance) needed to be edited simultaneously. However, CF arra

Re: Unofficial CF Developer Salary Survey

2006-08-04 Thread Tom Chiverton
On Thursday 03 August 2006 14:26, Ken Ferguson wrote: > that's 120K/yr. You just double the hourly and add a K. Woa. That makes it a bit easier. :remembers -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells

RE: SQL Select date between two dates with possible NULL values.

2006-08-04 Thread Daniel Dabner
You just need an OR in your WHERE clause: WHERE date > Effective_Date AND (date < Deactive_Date OR Deactive_Date IS NULL) -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.5/407 - Release Date: 03/08/2006 ~~~

Digests

2006-08-04 Thread Martin Thorpe
Hello. Sorry if this has been mentioned. But all week I have not received any of the CF-Talk digests. I am subscribed to the 2 hourly ones. I re-subscribed but nothing I only get the spam that started coming through when I first signed up? cheers Martin