RE: Making use of cached queries

Try Cfquery name=mytest dbtype=query maxrows=2 SELECT ProductName FROM AllPaid WHERE ProductID = 5 /CFQUERY Ken -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 4:05 PM To: CF-Talk Subject: Re: Making use of cached queries W Luke

RE: Making use of cached queries

PM To: CF-Talk Subject: Re: Making use of cached queries Ken Brocx [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Does it have a problem in calling TOP 2 records? For instance: Try Cfquery name=mytest dbtype=query maxrows=2 SELECT ProductName FROM AllPaid WHERE ProductID

RE: Random Product, with a twist?

You could just put a featured bit-field in the table then call a page via scheduled task to set a random one to featured. Ken -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:39 AM To: CF-Talk Subject: Random Product, with a

RE: Searching with ListFind

Well, I suppose you don't have to define the list if you don't want to. cfif ListFind(ValueList(query.colum),value)Do Something Here If test value Exists/cfif -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:40 PM To: CF-Talk

RE: Searching with ListFind

Nope, as far as I know that's how you do it, and believe me you really haven't seen a stupid question until you've been to my hamster bulletin board... :) http://www.hamsterific.com/BBS/BulletinBoard.cfm -Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent:

COM MX

I have the new MX patch but still when I do this: cfoutput cfobject type=COM name=ProcSale class=PFProCOMControl.PFProCOMControl.1 action=CREATE context=INPROC cfscript (which worked on 5) I get this:  The object type - COM, is unknown for CreateObject function. Please verify the

Com MX more info...

Actually I'm doing this...sorry: cfoutput cfobject type=COM name=ProcSale class=PFProCOMControl.PFProCOMControl.1 action=CREATE context=INPROC cfscript ProcSale= CreateObject( COM,

RE: CF 5 Pro vs Enterprise

You can run .jsp pages... -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:17 PM To: CF-Talk Subject: CF 5 Pro vs Enterprise What does CF5 Enterprise have that Pro doesn't? -- Al Everett Allied Office Products www.askallied.com

Admin password with new update

I ran the auto-updater for mx yesterday and everything seems to be ok, but now I can’t log in to the administrator! It says my password is wrong. I’ve never changed the password and have no idea what happened. Any ideas? Thanks, Ken * Ken Brocx * Seniŏr Developer

RE: Admin password with new update

Well, it turns out that the password is now all caps... I know what you're thinking but we've had this password for over a year and I can type it in my sleep. And one of the other developers also. It was not all-caps before weird... o.O -Original Message- From: Ken Brocx Sent

RE: Getting List of Tablenames for a DSN

Wow, that's great Josh! Where did you get the info on coldfusion.server.ServiceFactory? Thanks, Ken -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:33 AM To: CF-Talk Subject: RE: Getting List of Tablenames for a DSN Thanks

OT: Best JAVA Book...

Hi, I’d like some advice on a good JAVA book. I know CF and ASP, but JAVA is new to me. Thanks, Ken * Ken Brocx * Seniŏr Developer * Dealer Trade Group * (425) 452-3651 * [EMAIL PROTECTED

Variables Collection loop

Hi, I run the following loop to output the variables on a page and their values. I check for a simple value and skip it if it's not a simple value but it still says it can't output the complex output types. cfloop collection=variables item=i #i#-cfif isSimpleValue(i)#EVALUATE(i)#/cfifbr

RE: Variables Collection loop

=== Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ken Brocx [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 5:21 PM To: CF-Talk Subject

New Updater and com -.-

I applied the new update from MM and was thrilled to see the COM objects which didn't work with MX now work! Unfortunately some of the ones that worked before the update have now stopped working Anyone else have this problem of switching COM's that don't work post-SP1? Thanks, Ken

OT: Digital Certs

Someone mentioned good deals on digital certs here last week, and I can't find the reference. Verisign wants $600 for a 128 bit certificate. Does anyone know where there is a better deal? O.o Thanks! Ken __ This

RE: Digital Certs

- From: Ken Brocx [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:50 PM To: CF-Talk Subject: OT: Digital Certs Someone mentioned good deals on digital certs here last week, and I can't find the reference. Verisign wants $600 for a 128 bit certificate. Does anyone know where

RE: CFMX Updater

I have tried to install the updater but it says it didn't install at the end and to make sure the MX server is shut down. I have shutdown the three CFMX services from the windows services menu. Am I missing something? ALSO is there a way to see which CFIDE folder your server is set up to use?

RE: CFMX Updater

, September 17, 2002 1:32 PM To: CF-Talk Subject: RE: CFMX Updater There's only one CFIDE folder ... ? Which installer are you using Ken? ~Todd On Tue, 17 Sep 2002, Ken Brocx wrote: I have tried to install the updater but it says it didn't install at the end and to make sure the MX server is shut down

RE: CFMX Updater

thing happened to me. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Ken Brocx [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 1:20 PM To: CF-Talk Subject: RE: CFMX Updater I have tried

RE: CFMX Updater

I got it! It was pointing to the wrong CFIDE folder, turns out we have three (at least) on the dev server sigh -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:03 PM To: CF-Talk Subject: RE: CFMX Updater I posted this question once

RE: run CF from db

Everyone says Evaluate() is a bad idea, but I've searched the archives and can't see a reason why. So, in case you haven't guessed where this is going... Why is Evaluate a bad idea? Ken -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17,

RE: checkbox -- insert to database problem

You could put in a default value with cfparam, and leave the form.variable unscoped(heresy!) cfparam name=your_checkbox default=0 #your_checkbox# * Ken Brocx Senior Developer Dealer Trade Group (425) 452-3651 [EMAIL PROTECTED] * * -Original

RE: FINALLY!!! It Arrived!

I ordered it weeks ago and they've pushed back my ship date THREE TIMES! O.O Tell them to order more next time Ben... -.- * Ken Bringin' back L337-speak one ascii character at a time... -Original Message- From: jt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11,

RE: Adding Access DSNs programatically to CFMX

cfobject class=AdvDSN.DSN action=CREATE name=AdvDSN cfset strDriver = Microsoft Access Driver (*.mdb) -Original Message- From: Terry Roll [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 12:56 PM To: CF-Talk Subject: Adding Access DSNs programatically to CFMX Hi,

RE: cflocation vs. server side redirect.

No tony, The part // works similar to Does not have to be there. It's commented piece of code. Anything after // in a cfscript won't be run, it's just commenting. Ken -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 12:11 PM To: CF-Talk

FW: Dreamweaver MX opinions (CF Studio opinions?)

Is there any chance of brining back Studio? Dreamweaver is just so cumbersome and intolerably slow (on a p4 1.8) I tried to use it but it's just can't. A complete waste of money. I find it so bad that I have had to consider moving to a new markup language. A language loses a lot of it's

Re-running Query

a href=”#CGI.SCRIPT_NAME#?run_procs=1”update/a /cfoutput * * Ken Brocx * C.E.O Hamster Relations * www.hamsterific.com * [EMAIL PROTECTED] * __ This list and all House of Fusion resources

RE: Weather WDDX

What does this part do? cfcatch cfdump var=#cfcatch# /cfcatch Thanks, Ken -Original Message- From: jeff tapper [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 2:26 PM To: CF-Talk Subject: Re: Weather WDDX nevermind, just tried it with a canadian zipcode and it