RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
Sure, you can cache everything, but sometimes it is a little harder to get it to work. If you have a lot of WHERE a = #b# AND b=#c# OR c IN (cfloop list#d# index=e#e#/cfloop). You need to create mechanisms to make sure the query is uniquely cached. You don't want to end up returning a query, with

RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
variableName is meaned to be created by you, dynamically based on the SQL code executed. When you have WHERE, AND, OR statements (as well as group by, distinct, order by, joins, count, max, top, etc.etc.) in your query sql code you must make sure the variable it is cached in is not the same as a

Re: CF on Linux

2004-07-30 Thread Thomas Chiverton
On Thursday 29 Jul 2004 19:21 pm, Doug James wrote: Verity works on our version regardless of the official MM system requirements stating differently. :nods The thing is, if it is critical to your app, and breaks, you have no hope of MM fixing it :-( I think there was a technote that extended

Re: The search is killing the server. Please help!

2004-07-30 Thread cf coder
I tried applicaion variables, but as Hugo pointed out since the queries will be different for each user (using different keywords), and the refinement/paging would be per user, the session scope would make sense? I don't know where to go from here. Its getting all messy and confusing. All I want

RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
During the days we have posted an enormous amount of tips, tricks, code and guides on how to do the job. You still need more info? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380

RE: The search is killing the server. Please help!

2004-07-30 Thread Dave Wilson
I don't know where to go from here. Its getting all messy and confusing. All I want to do is, store the results returned by a query somewhere in memory so that if the search returns more than 100 records (100 records are displayed per page), when the 'next' button is clicked.. instead of running

RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
RAM is one of the cheapest pieces of hardware which enables you t speed up things a lot. Cached queries don't take very much of your RAM memory. Especially not when you are only caching it for 5 minutes as your example states. Micha Schopman Software Engineer Modern Media, Databankweg 12 M,

Re: The search is killing the server. Please help!

2004-07-30 Thread cf coder
Thank you all for your help. I really appreciate it. I've taken Hugo's advise (thank you Hugo) and gone with session scope route. I'm storing the results in a session variable. I'm not caching anything, it just adds more complexity to a already complex solution. Here is the code for anyone who is

RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
This means if you have 10.000 users doing a search for dog the server now creates 10.000 session entries each with the exact same resultset for dog ;) That is why I suggested application variables. Everybody has instant access to the cache if they search for the same thing. Micha Schopman

Re: The search is killing the server. Please help!

2004-07-30 Thread Adam Haskell
using the application scope creates a lot more complexity...and for what? A transparent change to the end user? That to me would make no sense. Adam H On Fri, 30 Jul 2004 14:47:54 +0200, Micha Schopman [EMAIL PROTECTED] wrote: This means if you have 10.000 users doing a search for dog the

Re: hosting blogs

2004-07-30 Thread Jake .
We are thinking about hosting blogs on our server. Does anyone know of a multiple user blog application in ColdFusion? Check out my BlogFusion application. I'm just about to launch v.3.5 that has a ton of new features. Go to www.countersinkdg.com for info. If you email me offline, I'll

RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
So because something is more difficult to do, we just take the situation which causes the most overhead on the server and stores duplicate data. Session variables can get you faster into trouble then application variables because the CMFX garbage collector is only called once a time and not on

Re: The search is killing the server. Please help!

2004-07-30 Thread G
Caching a query and using the blockfactor to employ a Get next n records is a really easy thing to implement. Its easy to code, easy to use, easy to maintain, easy to understandi guess i dont see where the complexity comes in? - Original Message - From: Micha Schopman To: CF-Talk

SOT: Checked/unchecked input boxes

2004-07-30 Thread Robert Orlini
How do I send via a CFIF IsDefined(form.update.x) in my code instructing CF to Update a field when a input box is unchecked as well as checked. Its working when its checked (input type=checkbox name=itemstatus value=received checked), but how do I send a NR when its unchecked? Robert O. [Todays

RE: hosting blogs

2004-07-30 Thread Reece, Cynthia
We use fusetalk and have been very happy with them: www.fusetalk.com. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Thu 7/29/2004 2:36 PM To: CF-Talk Cc: Subject: hosting blogs We are thinking about hosting blogs on our server. Does anyone know of a

RE: Checked/unchecked input boxes

2004-07-30 Thread Tangorre, Michael
On the page where you need to use the value, cfparam it and default the value to NR. Checkbox values are not passed unless theya re checked so using cfparam will be the value when it is not checked. HTH, Mike How do I send via a CFIF IsDefined(form.update.x) in my code instructing CF to

Re: SOT: Checked/unchecked input boxes

2004-07-30 Thread Scott Stroz
Add cfparam name=form.itemstatus default=NR to your action page.This will set form.itemstatus to NR if it is not passed in by the form. - Original Message - From: Robert Orlini [EMAIL PROTECTED] Date: Fri, 30 Jul 2004 09:28:14 -0400 Subject: SOT: Checked/unchecked input boxes To:

RE: The search is killing the server. Please help!

2004-07-30 Thread Micha Schopman
It could break existing caches :-) We talked about that in earlier postings. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription]

Cold Fusion-based blog

2004-07-30 Thread Joe Tartaglia
I am looking for a Cold Fusion-based blogging app. and would appreciate any recommendations you might have. Thanks Joe Tartaglia High Caliber Solutions 212-684-5553 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Chris Berg
Hello, I am having a problem deleting a collection via cfcollection.This collection was created by CF and is not external to it.It has an entry in the K2server.ini file for Verity K2, but when I go to run the delete, I get an error:Could not delete the contents of the collection directory

Re: Cold Fusion-based blog

2004-07-30 Thread Raymond Camden
This thread seems familiar Anyway, you can download my blog at www.camdenfamily.com/morpheus/blog. It supports SQL Server, MS Access, and MySQL. A new version (3.5) should be released soon. On Fri, 30 Jul 2004 09:43:29 -0400, Joe Tartaglia [EMAIL PROTECTED] wrote: I am looking for a Cold

Re: The search is killing the server. Please help!

2004-07-30 Thread Adam Haskell
My point is that more overhead on a server is, to me, an acceptable trade offto more maintainable code, under the assumption it does not affect the end user's view of the system. Once you see a noticeable impact in doing it a simpler way thats when the situation should be reassessed. Adam On

RE: The search is killing the server. Please help!

2004-07-30 Thread Dave Wilson
So? This simply means the broken cached query will just be run again (minor performance bottleneck) and re-enter the cache. Increase the number of cached queries in cf administrator accordingly. This is by far much more efficient (memory usage) than storing multiple instances of the same result

Re: Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Ben Doom
I've not used K2, but... In Verity on Windows, I've seen problems where a file gets locked by a CF thread and then is never released.Therefore, it can't be deleted. Rebooting the box fixes it for me, though there may be a less drastic solution. Once you've unlocked the file, you can delete

RE: Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Gaulin, Mark
Try stopping both K2 and the Cold Fusion Application service. -Original Message- From: Chris Berg [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 9:48 AM To: CF-Talk Subject: Deleting a Verity Collection (K2-Related Problem) Hello, I am having a problem deleting a collection via

Re: Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Chris Berg
I can delete the directory manually on the server without rebooting it or stopping the service, but I am unable to delete it programmatically, this is where my problem lies.I need to be able to delete the collection programmatically with no backend intervention. Thanks for the ideas.This makes me

Re: Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Chris Berg
I can delete the directory manually on the server without rebooting it or stopping the service, but I am unable to delete it programmatically, this is where my problem lies.I need to be able to delete the collection programmatically with no backend intervention. Thanks for the ideas.This makes me

RE: Monitor CFMX threads

2004-07-30 Thread lists
Well, I'm not getting any errors, using Pete's newer version with the try/catch block.But I get no info on each thread at all.I get the # of threads, but that's all.Any tweaks we can make to this?is this code depend on the JVM version or something? -- --- Douglas Knudsen

OT: js calendar layer

2004-07-30 Thread George Abraham
Hi all, Anyone have a quick link to a _javascript_ for a inline calendar layer that allows one to pick dates? TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Reading the output stream

2004-07-30 Thread Adam Haskell
This should o the trick :) obj_output = getPageContext().getCFOutput(); Stuff = obj_output.getString(); obj_output.clearAll(); Adam On Thu, 29 Jul 2004 16:14:27 -0400, Joe Bernard [EMAIL PROTECTED] wrote: The only piece I'm having trouble with is reading in the output stream. I cannot use

RE: js calendar layer

2004-07-30 Thread Tangorre, Michael
The site appears to be down right now, but when it comes back up, check it out.. http://dynarch.com/mishoo/calendar.epl Mike Hi all, Anyone have a quick link to a _javascript_ for a inline calendar layer that allows one to pick dates? [Todays Threads] [This Message] [Subscription]

Re: js calendar layer

2004-07-30 Thread Howie Hamlin
I like the one found here a lot: http://www.totallysmartit.com/ If you have any trouble downloading it from there then you can download iAS from our site as we include the calendar in the source code: http://www.coolfusion.com/downloads/index.cfm?id=4 HTH, -- Howie Hamlin - inFusion Project

RE: js calendar layer

2004-07-30 Thread Tangorre, Michael
The only problem with that one is that it does not work in all (4+) browsers and it gets hidden by other form elements if the widget opens on top of them. I like the one found here a lot: http://www.totallysmartit.com/ If you have any trouble downloading it from there then you can download

RE: hosting blogs

2004-07-30 Thread Michael Wilson
Hi, I looked for a mature and feature rich CF blogging system for months with no success. I've looked at everything posted here and while some are beginning to show promise, none (in my opinion) are as robust as MovableType or WordPress. I've installed and used both MT and WP in Linux/Apache

Re: Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Ben Doom
Was the collection created programmatically?I'm guessing it was, but it never hurts to ask --Ben Chris Berg wrote: I can delete the directory manually on the server without rebooting it or stopping the service, but I am unable to delete it programmatically, this is where my problem

CFC Practices

2004-07-30 Thread Michael Dinowitz
In a CFC it is possible to call another function of the same CFC without specifying the component attribute (like so): CFInvoke Method=Set_Order Has anyone tried this and is there any savings or penalty for doing it this way? I haven't seen anything, but there are others here with more component

Re: ecommerce storefronts

2004-07-30 Thread Mary Jo Sminkey
Just to add to Paul's reply: There are 3 things you need to process credit cards online. First, you need a business checking account. A personal checking account will not do. Most business checking accounts have minimum balances of at least $2500 and only offer interest for much larger account.

RE: Deleting a Verity Collection (K2-Related Problem)

2004-07-30 Thread Gaulin, Mark
I use cfexecute to run a script that stops the k2 service, then use cf to delete the collection, and then use another script to restart the service.It sucks but it works most of the time (but not 100%). Mark -Original Message- From: Chris Berg [mailto:[EMAIL PROTECTED] Sent: Friday,

SQL Server varchar not liking HTML entities?

2004-07-30 Thread Damien McKenna
I'm trying to clean up some old data where they have e.g. the TM symbol embedded in the data.The odd thing is that in the Enterprise Manager when I am editing the field (after doing a show-all) and I change the TM to trade; I am told: The value you entered is not consistent with the data type

Allow End User to Save As Excel/CSV

2004-07-30 Thread Claremont, Timothy
Can someone point me in the right direction on allowing the end user to save query results as an Excel or CSV file on their local machine? I am using the following code, but it just displays the table on screen, and does not save the file: cfquery name=GetProviderResults datasource=CombinedRaps

RE: The search is killing the server. Please help!

2004-07-30 Thread Andrew Tyrone
I fail to see why a lot of these ideas are even necessary in this case.The records returned number about 5000.NO ONE is going to page through all 5000 records.This is what the search filters are for.Just return the top 20, 50, 100 records ordered by whatever your business rules require ONLY IF

Re: CFC Practices

2004-07-30 Thread Dave Carabetta
On Fri, 30 Jul 2004 10:53:50 -0400, Michael Dinowitz [EMAIL PROTECTED] wrote: In a CFC it is possible to call another function of the same CFC without specifying the component attribute (like so): CFInvoke Method=Set_Order Has anyone tried this and is there any savings or penalty for doing it

RE: js calendar layer

2004-07-30 Thread Tyler Silcox
I found these the other afternoon: HYPERLINK http://www.mattkruse.com/_javascript_/calendarpopup/index.htmlhttp://www.mat tkruse.com/_javascript_/calendarpopup/index.html A good amount of examples and options... Tyler _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday,

Consume CFMX webservice in MSAccess

2004-07-30 Thread Mark W. Breneman
I have a client that has built an impressive MS Access database based on an excel data dump of his database on my CFMX server. We are looking to move to the next level and let him get the data via CFMX webservice and import it directly into access. I assume there is a tool for making MS access

Re: ecommerce storefronts

2004-07-30 Thread daniel kessler
We are the makers of SiteDirector... It looks nice and well-made, full-featured. I also like these storefronts: (EZCart) http://www.cf-ezcart.com/and (CFWebstore) http://cfwebstore.com/ There are many gateways such as AuthorizeNet, Versign, CDG Commerce and others.The storefronts pass

RE: CFC Practices

2004-07-30 Thread Jim Davis
I'm not sure - but it'd be easy to try.;^) I just never use CFINVOKE inside a CFC - in that case I'd always use script/function syntax - and then you don't use the component name inside the CFC: cfset Set_Order() / Jim Davis From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, July

OT: QForms Question..

2004-07-30 Thread Tangorre, Michael
Anyone here using qforms? Anyone see anything wrong with this? I keep getting an object expected error.. g form input type=Button name=btnDeletePoc value=Delete POC class=submit-button / /form objForm2.btnAddPoc.addEvent(onClick,spawnWindow('http://www.google.com'); );

RE: Allow End User to Save As Excel/CSV

2004-07-30 Thread Ryan Duckworth
Tim, Put this code at the top of the page and it will do the trick: cfcontent type=application/vnd.ms-excel You also need the start table and /table tags. It will prompt the user to Save or Open the Excel file. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications

Re: Allow End User to Save As Excel/CSV

2004-07-30 Thread Kevin
Hey, I am a real newbie so this might not be much help, but I would think that if you opened up a ascii file for output and then write each line with a coma as the separator then the user could import the CSV file into excel. cffile action=""> file=C:\inetpub\wwwroot\mine\excel_csv.txt

Re: CFC Practices

2004-07-30 Thread Michael Dinowitz
According to what I've read, using CFINVOKE without the component attribute does not invoke a new instance of the component. If this works the same internally to a CFC as using a function call, I'd rather use the CFINVOKE. It's just cleaner looking with the CFINVOKEARGUMENTs. (This is someone

RE: Consume CFMX webservice in MSAccess

2004-07-30 Thread Dave Watts
I have a client that has built an impressive MS Access database based on an excel data dump of his database on my CFMX server. We are looking to move to the next level and let him get the data via CFMX webservice and import it directly into access. I assume there is a tool for making MS

Re: CFC Practices

2004-07-30 Thread Joe Rinehart
Hi, It's not that you don't want to not set the component attributes; rather, you'd want to set the component attribute as a reference to itself.I.e.: cfinvoke method=myMethod component=#this# However, the preferred way to do this is just to do cfset myMethod() or cfscriptmyMethod();/cfscript.

RE: cf_sql_date

2004-07-30 Thread Tyler Silcox
Err...yea, you right.I didn't see the cfsqltype type. You need to use the cfsqltype cf_sql_timestamp type for MSSQL, but you also have to have datetime as your column type in MSSQL if you want the date and time...instead of just smalldatetime, etc. Tyler _ From: Matthew Walker

RE: Checked/unchecked input boxes

2004-07-30 Thread Andrew Tyrone
You can use cfparam to create the form variable if it doesn't already exist. So to set FORM.itemstatus to NR by default, you could use: cfparam name=FORM.itemstatus default=NR -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 9:28 AM To: CF-Talk

Re: Allow End User to Save As Excel/CSV

2004-07-30 Thread Tim Claremont
Well, I get the file save dialog box, which is great, but it wants to save the file as downloadproviderreport, which is the name of my cfm file, sans the extension. If I say I want to 'open it' I have to choose an application. Choosing Excel opens the file as expected. What is wrong with my code

Re: CFC Practices

2004-07-30 Thread Deanna Schneider
Um, why would you need to use cfinvoke? If you're in the same CFC, you have direct access to other functions - Original Message - From: Michael Dinowitz In a CFC it is possible to call another function of the same CFC without specifying the component attribute (like so): CFInvoke

Re: CFC Practices

2004-07-30 Thread Raymond Camden
Joe, I haven't tested this, but I know that if you do cfset x = this.foo() inside a CFC, the this portion makes the call act as if it were external, so if FOO was marked ACCESS=PRIVATE, it wouldn't work. Your code below may have the same problem. Note - MAY. On Fri, 30 Jul 2004 11:36:15 -0400,

RE: cf_sql_date

2004-07-30 Thread Andrew Tyrone
Actually, smalldatetime and datetime are only different by the following (from SQL Server Books Online): datetime Date and time data from January 1, 1753 through December 31, , to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are

Re: Allow End User to Save As Excel/CSV

2004-07-30 Thread Mike Kelp
At the top just before your before you output the data...This will clear any content before the cfcontent tag and tell the browser the content you are outputting onto the page is an attachment. cfheader name=Content-Disposition value=attachment; filename=Name_Of_File.csv cfcontent reset=yes

RE: CFC Practices

2004-07-30 Thread Andrew Tyrone
Yes, I have a lot of this going on in my last project.Some complex database transactions have more than one method that gets used in more than one main transaction, so these are broken up into private methods, called by just referencing the method itself WITHIN the CFC (which is the keyword). As

Re: CFC Practices

2004-07-30 Thread Dave Carabetta
On Fri, 30 Jul 2004 11:26:38 -0400, Michael Dinowitz [EMAIL PROTECTED] wrote: According to what I've read, using CFINVOKE without the component attribute does not invoke a new instance of the component. If this works the same internally to a CFC as using a function call, I'd rather use the

RE: CFC Practices

2004-07-30 Thread Andrew Tyrone
If you have a lot of arguments, however, readability is easier maintained with cfinvoke method=bar ... and then a series of cfinvokeargument tags thereafter and a closing /cfinvoke.Using cfinvoke without the component name (see my other post) does not instantiate the component again.

Re: Cold Fusion-based blog

2004-07-30 Thread Jason L. West, Sr.
Raymond, Check your blog, the only thing I am getting is a blank page. Jason Raymond Camden wrote on 7/30/2004, 09:46: This thread seems familiar Anyway, you can download my blog at www.camdenfamily.com/morpheus/blog. It supports SQL Server, MS Access, and MySQL. A new version

RE: CFC Practices

2004-07-30 Thread Samuel R. Neff
You could also do cfinvoke component=#this# method=... ... Which I think is easier to understand than a cfinvoke without a component attribute (didn't know that worked, but still prefer to specify component). Sam Blog http://www.rewindlife.com TeamMM

Re: Reading the output stream

2004-07-30 Thread Joe Bernard
Paul: That is a concern. It's something we're going to try as a beta. If it works out, we just gained quite a few new users. Adam: Perfect. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: CFC Practices

2004-07-30 Thread Michael Dinowitz
True. I didn't think of that. Now the original question is, what's faster/better for internal method calls. 1. CFINVOKE method... 2. CFINVOKE component=#this# method... 3. function call I prefer one of the first 2 as the CFINVOKE is cleaner, but which of those two are better. If both are the

Re: CFC Practices

2004-07-30 Thread Barney Boisvert
My vote is for the function call in CFSET/CFSCRIPT.if you need named arguments (rather than positional), just use an argumentCollection. It's minutely less readable than CFINVOKE/CFINVOKEARGUMENT (because the arguments are defined before the function name is listed), but I've never had that be a

Re: The search is killing the server. Please help!

2004-07-30 Thread Adam Haskell
I don't disagree with you andy, 5000 results does sound completely rediculous. But the fact of the matter is if someone wants to do this, then I'll give my input on how I think it should be done. I am not one to refuse to give helpful insight on how to accomplish a task just becuase I think it is

Re: The search is killing the server. Please help!

2004-07-30 Thread G
To that end, when you work for the Government as I do, the ridiculous quickly becomes the ordinary.A query returning 5000 records, and a report to display all those records, is not only a possibility, its LIKELY. All you can do as a designer is get your objections on record, then do your best to

Re: CFC Practices

2004-07-30 Thread Michael Dinowitz
I personally hate positional parameters simply because they lack precision and can get you into trouble if something is moved. I've seen a lot of errors on peoples sites that can be traced back to a misplaced variable. The argumentcollection is a viable alternative though. Problem is, it still

RE: CFC Practices

2004-07-30 Thread Spike
If you don't want to use positional parameters, you can also do this: cfset result = someMethod(arg2=foo,arg3=bar) I've seen a lot of code that works like that. Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse?

Re: CFC Practices

2004-07-30 Thread Deanna Schneider
If you're worried about readability, why don't you just use name=value notation: myFunction(param1='test',param2='this'); My vote is for the function call in CFSET/CFSCRIPT.if you need named arguments (rather than positional), just use an argumentCollection. It's minutely less readable than

RE: CFC Practices

2004-07-30 Thread Spike
I would disagree. I find the third option much cleaner, so I think this all comes down to a question of style. The speed difference between any of them is almost certainly a non-issue, but specifying the component name prevents you from accessing the private methods, so it is limiting in that

RE: CFC Practices

2004-07-30 Thread Dave Watts
I personally hate positional parameters simply because they lack precision and can get you into trouble if something is moved. I've seen a lot of errors on peoples sites that can be traced back to a misplaced variable. You can use named arguments within a function call: cffunction

RE: CFC Practices

2004-07-30 Thread Guy Rish
Michael, I first ran into this, in use, when I was putting together the CFINVOKE tag for BlueDragon.I had read about it when CFMX came out and never thought I would use that stem of functionality.In fact, initially I thought this was pretty stupid and might have just been a side effect of the way

Re: CFC Practices

2004-07-30 Thread Michael Dinowitz
Pass 10 variables in name/value format this way and tell me how readable it is. :) If you're worried about readability, why don't you just use name=value notation: myFunction(param1='test',param2='this'); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: CFC Practices

2004-07-30 Thread Dave Carabetta
On Fri, 30 Jul 2004 12:55:16 -0400, Michael Dinowitz [EMAIL PROTECTED] wrote: Pass 10 variables in name/value format this way and tell me how readable it is. :) If you're worried about readability, why don't you just use name=value notation: myFunction(param1='test',param2='this'); OK:

Re: CFC Practices

2004-07-30 Thread Mark Drew
Ohh, now that was like, you were reading my mind and answered my question before I even posted it.. what a useful list! I was calling a method in a cfc and changing the arguments, and of course they are positional and I was thinking to myself, Gosh, its friday evening here, and I need to add more

Re: Formatting output for printing question

2004-07-30 Thread Kevin
Hi Tom, Thank you for the link and info. I have a more specific question on output and hope you can help. I was thinking of creating a PDF document and then populating it with the fields from a SQL query. For example, I make a PDF template of an invoice and set the fields to be filled in. The

Re: CFC Practices

2004-07-30 Thread Deanna Schneider
Personally, I still think it's more readable to set up a structure then, of all you want to pass and use the argumentcollection. It's, of course, a personal style thing. But, the more I use cfscript notation, the more I love it. It just seems much more clean and readable to me. Of course, that's

Re: CFC Practices

2004-07-30 Thread Michael Dinowitz
At the risk of getting into a style debate, I find having the CFINVOKEARGUMENT tags with all of their arguments as a sub of the main CFINVOKE (either without the component attribute or with it set to #this#) to be cleaner. cfinvoke method=SP_Order_Get returnvariable=qGetOrderInfo

RE: Consume CFMX webservice in MSAccess

2004-07-30 Thread Mark W. Breneman
Thanks Dave, that is just want I was looking for. I have to laugh that I can make a webservice in a few seconds and it will take the client hours or days to write the MS access end of it. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED]

Re: CFC Practices

2004-07-30 Thread Barney Boisvert
How about this variation: cfset qGetOrderInfo=SP_Order_Get( Order_ID = Order_ID, Order_Method = Order_Method, Item_Status = 7 ) / I'd say that's definitely cleaner and easier to read that the tag-based version, becuase the eye doesn't have to parse all those extra tags and quotes.And it's even

RE: The search is killing the server. Please help!

2004-07-30 Thread Andrew Tyrone
Adam, I am not saying that your input is worthless, but I think it is a good developer's duty to make a case for more efficient ways to do things.From what I gathered of the initial post, nothing was set in stone.Given that, I can't in good conscience agree with most of the methods put forth

GT 0 failing CFIF decision

2004-07-30 Thread daniel kessler
I run a query to see if some items are inserted into an Oracle DB.If the record count is greater than 0, I consider it added.In the code below, I'm displaying the recordcount and it's being listed as 8, but I'm failing the GT 0 IF statement. Can someone please tell me why this is failing?

Re: GT 0 failing CFIF decision

2004-07-30 Thread Jeff Garza
An insert statement (which is what I assume you are doing) doesn't return a recordset.You might want to create a stored proc that returns an output param back to CF indicating that the insert either failed or succeeded. HTH, -- Jeff Garza - Original Message - From: daniel kessler To:

RE: The search is killing the server. Please help!

2004-07-30 Thread Andrew Tyrone
The subject didn't have anything to do with reports, but a list returned to the user in it's entirety.The discussion was about caching, and in this case there is no need to return all 5000 records to the user because the user will not page through them anyway without entering some sort of

Re: GT 0 failing CFIF decision

2004-07-30 Thread daniel kessler
Sorry, I should have put the query An insert statement (which is what I assume you are doing) doesn't return a recordset. I am doing an insert, but I'm doing a Query after the insert to see if it's been added.In the code, add_check is the query name.Here's the query: cfquery name=add_check

RE: GT 0 failing CFIF decision

2004-07-30 Thread Dave Watts
An insert statement (which is what I assume you are doing) doesn't return a recordset.You might want to create a stored proc that returns an output param back to CF indicating that the insert either failed or succeeded. Unless I'm missing something, this is needless complication. If the

Re: CFC Practices

2004-07-30 Thread Joe Rinehart
Thanks Raymond.I'll probably never find out, because I never use cfInvokebut if I do, I'll let you know. :) -joe - Original Message - From: Raymond Camden [EMAIL PROTECTED] Date: Fri, 30 Jul 2004 10:52:58 -0500 Subject: Re: CFC Practices To: CF-Talk [EMAIL PROTECTED] Joe, I haven't

Re: CFC Practices

2004-07-30 Thread Joe Rinehart
Raymond / others with cfinvoke component=#this#... It will fail, as it should, when trying to invoke a private method. It's a slowish afternoon, so I did this: Test.cfc: cfcomponent cfset myId = createUuid() cffunction name=sayHi access=private cfoutputsayHi: #myId#br/cfoutput /cffunction

CF Ticketing System

2004-07-30 Thread Mickael
Hello All, Does anyone know of a free Coldfusion ticketing system?The kind where people can log an issue get a ticket number and view them in a queue?I had one in PHP that was free and pretty robust.Just wondering if there is one out there for free or cheap if someone has one to sell. Thanks

CF on Linux

2004-07-30 Thread Robert Orlini
OK. I installed RedHat ES server. Do I need a cd that is CF for Linux? Can the regular CFMX installation you use for Windows work? I'm sorry but I'm very new to Lunix. Thx. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

RE: CF on Linux

2004-07-30 Thread Ben Forta
The same CF works, but the installer is different. You can grab a downloadable installer off of the Macromedia web site. --- Ben _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 2:46 PM To: CF-Talk Subject: CF on Linux OK. I installed RedHat ES server. Do I

Re: CFC Practices

2004-07-30 Thread Michael Dinowitz
I just tested it out as well. I wrote a CFC with 2 methods. The private method was called from the public one. Using the three types of calls, the CFINVOKE using component=#this# failed (as joe mentioned). The function call worked, as did the CFINVOKE with no component. I'll do some deep speed

Re: CF on Linux

2004-07-30 Thread Doug White
You need CF for Linux == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == - Original Message -

RE: CF on Linux

2004-07-30 Thread Robert Orlini
Thanks Ben. I looked through Macromedia's site, but could not find it. Do you have the link or how should I search for this installer? Do I then copy it to a cd and run it on the Linux box? Robert O. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, July 30,

Re: CF on Linux

2004-07-30 Thread Rob
On Fri, 30 Jul 2004 15:09:23 -0400, Robert Orlini [EMAIL PROTECTED] wrote: I looked through Macromedia's site, but could not find it. Do you have the link or how should I search for this installer? Do I then copy it to a cd and run it on the Linux box?

RE: web server document root?

2004-07-30 Thread Calder, Erick
in the end, what I had to do to establish the web server root was to subtract cgi.script_name from GetBaseTemplatePath() - it took minor tweaking since you get one in / form and the other in \ form but it works -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent:

Re: Cold Fusion-based blog

2004-07-30 Thread Raymond Camden
It's working fine for me. Maybe it was down for a bit? On Fri, 30 Jul 2004 12:15:26 -0400, Jason L. West, Sr. [EMAIL PROTECTED] wrote: Raymond, Check your blog, the only thing I am getting is a blank page. Jason Raymond Camden wrote on 7/30/2004, 09:46: This thread seems familiar

  1   2   >