Re: Change Log on database updates - need some ideas

2007-02-22 Thread Robertson-Ravo, Neil (RX)
Jeez. That is terrible design. I mean, hasn't it met the row limit yet? 1200 columns... Has to be a typo? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It

Re: Delete Session Info on Browser Close

2007-02-22 Thread James Holmes
Just turn on j2ee session management (assuming you can control the box) - this automatically ties sessions to in-memory cookies. On 2/22/07, Rick Root [EMAIL PROTECTED] wrote: That's cool, I'd never even considered that method. I've usually avoided session variables for the most part in most

Building ColdFusion services with ColdSpring and Reactor

2007-02-22 Thread Tom Chiverton
In case people aren't getting my blog directly or from the MXNA or UKCFUG blogregators, I will shortly be starting a series of articles outlining one way of building a tiered service architecture, using two core ColdFusion technologies - ColdSpring and Reactor:

Re: OT Allowing access to /flashservices/gateway in httpd.conf

2007-02-22 Thread Tom Chiverton
On Wednesday 21 Feb 2007, Adrian Lynch wrote: I thought maybe: Directory /flashservices/gateway Allow from all /Directory We're using Location /flashservices/gateway Satisfy Any Allow from all /location See

AJAX: Goes everywhere? (was Re: Change Log...)

2007-02-22 Thread Dinner
On 2/21/07, Andy Tyrone [EMAIL PROTECTED] wrote: Well, actually, once you go AJAX, you kinda want it everywhere. It truly is a different way of doing stuff than the old static way. What's that quote... we're just now getting back to where we were 10 years ago, UI wise something

Re: Change Log on database updates - need some ideas

2007-02-22 Thread Dinner
LOL. Yeah, sorry-- I see idea and I'm off. ;-) I forgot there was a real application we were contemplating, vs. just philosophy of how to achieve X. For thread justice: The way I've handled it, in a similar case, was with a duplicate table. Assuming you've got your DB code abstracted to a

Field level edits (with AJAX) (was: Re: Change Log...)

2007-02-22 Thread Dinner
On 2/21/07, Dave Watts [EMAIL PROTECTED] wrote: All AJAX is is JavaScript. It's not really something different. XHTMLHTTPRequest stuff could have been done with frames/whatnot. Or was done, I guess I'd stipulate. You're missing my point, which is that AJAX is not, by itself, a relevant

RE: OT Allowing access to /flashservices/gateway in httpd.conf

2007-02-22 Thread Adrian Lynch
Nice one Tom, that's worked. Thanks for all the other suggestions. Adrian -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 22 February 2007 09:19 To: CF-Talk Subject: Re: OT Allowing access to /flashservices/gateway in httpd.conf On Wednesday 21 Feb 2007, Adrian

[CFCDEV] Building ColdFusion services with ColdSpring and Reactor

2007-02-22 Thread Tom Chiverton
In case people aren't getting my blog directly or from the MXNA or UKCFUG blogregators, I will shortly be starting a series of articles outlining one way of building a tiered service architecture, using two core ColdFusion technologies - ColdSpring and Reactor:

Very odd Web Service Prorblem

2007-02-22 Thread Robertson-Ravo, Neil (RX)
OK, I have a very, very strange problem when invoking a web service which I know is working AOK on another box (I have even deleted it and recreated it both via the CFIDE and via automatic code generation via CreateObject()). I *can* successfully access the ?WSDL via any machine, including the

RE: FCKeditor File Browsing question

2007-02-22 Thread Mark Leder
One option would be to install CFFM on the remote server to serve as the file manager, and disable all upload/modify/manipulate capabilities... then you could just point fckeditor to the remote instance of CFFM. CFFM 1.14has a readOnly property allowing to to use it as a public file repository..

Re: cfmail problem

2007-02-22 Thread Richard Cooper
I had a similar problem that we solved this week. Emails from forms would bounce from the client but I could send mail to the email address fine though outlook and the same mail server. For us it turned out that the mail server was alive and auth for the domain, deleting this solved the

Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Beru
Hello, I would like to map several CF instances (say, one per application) to one IIS site. Does anyone know about a guide or FAQ about this? (I googled the web, even on this list, but I only got one-to-one configs (mapping a CF instance to a website) or one to many (1 CF instance to many

Re: Having difficulty with cffile on IIS7 and Vista

2007-02-22 Thread Richard Cooper
Your specifying the form field value where you should be putting the form field i.e. filefield=fileuploadfiled not filefield=#FORM.fileuploadfiled# ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7

Re: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread mailme
Yep, here http://www.geodesicgrafx.com/blog/index.cfm/2007/2/3/How-to-set-up-muliple-instances-for-just-one-website. I didn't get a chance to write the caveats yet, but I'll write those up this morning. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog Quoting Beru : Hello, I

Re: Delete Session Info on Browser Close

2007-02-22 Thread Dimitris C
Ok, I need a refresher here. I want to delete all session information on browser close. What is the best way to handle this since the session info is stored on the server? The best way is to add the following code in your Application.cfm !--- if user closes browser end session --- cfif

RE: Having difficulty with cffile on IIS7 and Vista

2007-02-22 Thread Sandra Clark
Thanks Richard, I figured that out late last night. I haven't had to write code for a cffile in years so I forgot that and in the blur of upgrading to Vista and IIS7 with a more manual install of ColdFusion, I of course, decided to blame the configuration rather than my code! Sandra Clark

Re: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread mailme
And so they are now written up. Please be aware that this is unlikely unsupported by Adobe, and I've already caught grief from the list for this approach. However, I find that it works for our situation fairly well, especially with our multiple clusters. The additional information is found

CFUNITED/Express NYC early bird ends 3/1/07 - topic details

2007-02-22 Thread Michael Smith
Only 7 days left on the early bird price! Come and experience the magic of CFUnited for an entire day in New York City at CFUNITED/Express http://www.cfunitedexpress.com/ on 3/8/07. Learn the latest ColdFusion and Flex techniques from expert speakers including Ben Forta, Shlomy Gantz, Michael

Page Not Found for /flashservices/gateway?

2007-02-22 Thread Jeff Small
We don't do much Flash Remoting, but we're trying to play around with it and whenever we call up the /flashservices/gateway url on our developer machine we get a page not found error. I could've sworn that we had it installed at one time. It's CFMX7 standard edition. Any hints on what we

A Loop, A Number Format, and a Select

2007-02-22 Thread Les Mizzell
Select currently looks like this: select name=xox option value=00 cfif qry.xox EQ 00 selected=selected/cfif00/option option value=01 cfif qry.xox EQ 01 selected=selected/cfif01/option option value=02 cfif qry.xox EQ 02 selected=selected/cfif02/option ...up

RE: Page Not Found for /flashservices/gateway?

2007-02-22 Thread Kevin Aebig
It's not supposed to return back a page. You should make sure everything has been enabled properly though... !k -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 9:04 AM To: CF-Talk Subject: Page Not Found for /flashservices/gateway? We

Re: Page Not Found for /flashservices/gateway?

2007-02-22 Thread Jeff Small
I know, I'm supposed to get the famous, blank white page. Whenever I try it on my laptop running CFMX7 on IIS under that same configuration I get the white page. Whenever I try to view it on my development machine, I get an actual IIS Page Not Found error. Not a CF one either. How does one go

Conditions on a sub-query collumn in MSSQL

2007-02-22 Thread James Smith
I have a query that looks something like... SELECT t.FirstCollumn, (SELECT moreStuff) AS SecondCollumn FROM SomeTables t And it works fine, however when the result of the sub-query is Null I want to omit the rows from the final results but neither WHERE or HAVING are valid when refering

RE: A Loop, A Number Format, and a Select

2007-02-22 Thread Ben Nadel
cfloop index=i from=1 to=99 option value=#NumberFormat( i, 00 )# cfif (Val( qry.xox ) EQ i)selected=true/cfif #NumberFormat( i, 00 )#/option /cfloop .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help?

are J2EE session ids unique?

2007-02-22 Thread Leitch, Oblio
I can't seem to find an answer to this anywhere - are J2EE sessionIDs unique? That is, if I close/open the browser infinitely, am I guaranteed not to duplicate IDs? What are they based on, how are they created? Oblio This email message may contain privileged and/or confidential information.

Re: Delete Session Info on Browser Close

2007-02-22 Thread Brian Yager
I have done this before using a hidden frame that uses the onUnload event to open a new window to log out the user (delete his session) and immediately close the new window. Brian Ok, I need a refresher here. I want to delete all session information on browser close. What is the best way

Re: OT: New worldship sucks!

2007-02-22 Thread Tom Chiverton
On Wednesday 21 Feb 2007, Will Tomlinson wrote: I just tried installing UPS Worldship 9.0, and I can't because it now uses MSDE for its DB. It detects SQL Server on my machine and says it's incompatible. This sucks! Quick, to VMWare. -- Tom Chiverton Helping to collaboratively pursue

Re: Page Not Found for /flashservices/gateway?

2007-02-22 Thread Tom Chiverton
On Thursday 22 Feb 2007, Jeff Small wrote: We don't do much Flash Remoting, but we're trying to play around with it and whenever we call up the /flashservices/gateway url on our developer I think that might be the wrong URL: Shouldn't it be '/flex2gateway'. That will give a JRun 500 error

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
I'm sure I'm missing something, but why would you need to set up multiple instances of CF for *one* web site? Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 9:42 AM To: CF-Talk Subject: Re: Managing multiple CF7 instances to

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ian Skinner
I'm sure I'm missing something, but why would you need to set up multiple instances of CF for *one* web site? Rick Poor man's fall over clustering. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Sudoku | | |

Re: are J2EE session ids unique?

2007-02-22 Thread Cutter (CFRelated)
From the Adobe TechNote: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18232 J2EE session management uses a new variable, called thejsessionid, to track a user's browser session instead of the CFID/CFTOKEN pair. The jsessionid variable is available to JSPs and Servlets. A

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread mailme
Honestly? Because you work for a government agency, and such is the way it is ;). And this was the easiest solution to implement within the confines of our limitations. We host around 120 sites, and all of them are virtual webs off the main URL. I didn't set it up, and changing it would

Pittsburgh Area CFUG is coming back to life!

2007-02-22 Thread powell
I'm happy to announce the restart of the Pittsburgh Area ColdFusion Users Group. It was pretty active a few years ago, but gradually died out. I know that we have a number of CF shops in the area, and am trying to get the word out to them announcing our next meeting on March 20th at 6:00pm;

Re: Page Not Found for /flashservices/gateway?

2007-02-22 Thread Cutter (CFRelated)
Are you running CF as a multi-instance config? If so you will need to remove the flash gateway from the different jrun instances within the JMC. Cutter _ http://blog.cutterscrossing.com Jeff Small wrote: I know, I'm supposed to get the famous, blank white page. Whenever I try it

Re: are J2EE session ids unique?

2007-02-22 Thread Vince Bonfanti
Yes, according to the J2EE specification, session IDs are supposed to be unique. From the description of the javax.server.http.HttpSession.getID() method: Returns a string containing the unique identifier assigned to this session. The identifier is assigned by the servlet container and is

Re: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Andy Allan
Multiple instances on a single box will also allow you to get over JVM limitations. On a 32 bit cpu machine, the most you can give to any one instance is 1.8gb (typically less though). By running multiple instances, you can assign say, 1GB to x instances and then cluster your instances. .. On

Re: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Beru
Rick, How would you make sure a CF application off the root of your web site does not interfere with another application on the same web site? I thought it would be logical to run each of these apps in their own instance... Is there another solution? On 2/22/07, Rick Faircloth [EMAIL PROTECTED]

Re: Page Not Found for /flashservices/gateway?

2007-02-22 Thread Jeff Small
Actually, no. We're only running on instance on the development server. And like I said, I could've SWORN that it worked before. I can't find anything in the CF Administrator that covers remoting either... -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 -

Re: A Loop, A Number Format, and a Select

2007-02-22 Thread Mik Muller
How about cfloop from=1 to=12000 index=ii cfset s_ii = right(ii,5) option value=#s_ii# cfif qry.xox eq s_iiselected=selected/cfif #s_ii#/option /cfloop Mik At 10:06 AM 2/22/2007, you wrote: Select currently looks like this: select name=xox option value=00 cfif

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ben Forta
Rick, load balancing and performance for starters. But also, for better use of server resources. For example, I regularly see people running a single ColdFusion instance on a big fat box with 4 or 8 Gig RAM, memory that ColdFusion can't use because of limitations as to what the JVM sees. In such a

Re: Page Not Found for /flashservices/gateway?

2007-02-22 Thread Jeff Small
Okay, I think I've found *something*. I looked at my laptop, and under Data Services I have a Flex Integration link that isn't on my development server. It appears as if my Dev server needs to be updated. When I click on the Flex Integration link I have a checkbox to enable Flash Remoting

Re: A Loop, A Number Format, and a Select

2007-02-22 Thread Mik Muller
Oops... forgot a closing bracket after the /cfif You could also make a variable out of the high number to genericize the right() function cfset myTo = 120 cfloop from=1 to=#myTo index=ii cfset s_ii = right(000ii,len(myTo)) option value=#s_ii# cfif qry.xox eq

Re: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Beru
Thanks Matthew! I'll try out your procedure, although I experienced with a very similar one, with mixed results... I am trying to debug the process so that I don't have to restart IIS (production site), and will use your findings about the caveats... On 2/22/07, [EMAIL PROTECTED] [EMAIL

cfstoredproc vs cfquery

2007-02-22 Thread Bobby Hartsfield
Anyone know if there is an advantage either way when it comes to calling a stored procedure? Say I have a storedproc called GetAllResults. I can call it 2 ways. cfquery name=”myquery” datasource=”mydatasource” Execute GetAllResults /cfquery cfdump var=#myQuery# / Or

RE: cfstoredproc vs cfquery

2007-02-22 Thread Ian Skinner
The only one I can think of, but then I don't use SP's very often; IIRC is that the cfstoredProc tag can handle more complex procedures. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Sudoku | | | -

RE: cfstoredproc vs cfquery

2007-02-22 Thread Bobby Hartsfield
None come to mind that can't be executed via cfquery. What do you mean by more complex? -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.441 / Virus Database: 268.18.3/697 - Release Date: 2/22/2007 11:55 AM

CFSEARCH

2007-02-22 Thread Orlini, Robert
I have this basic Cfsearch for a page that searches our collections: CFSEARCH NAME=SearchSnippets COLLECTION=databases TYPE=simple MAXROWS=20 CRITERIA=#FORM.searchstring# /CFIF How do I insert code that will display a your search generated 0 results to display? I know this

Re: cfmail problem

2007-02-22 Thread Will Tomlinson
Yep, you've nailed another one. Just ran a test, hardcoded MY email in the TO. Worked just fine. I'll test and see if a friendly email address would be enough difference to make it work. Know if it would off the top of your head dave? Thanks! Will

Re: Mail Spool Slow

2007-02-22 Thread Rob Kopp
Can you show me some code on how you're doing that? FWIW: we send out thousands and i find it easier to write the files directly to the mail root instead of getting CF to send the email via the cf spool. ~| ColdFusion MX7 by

A few questions about SQL Server 2000

2007-02-22 Thread Andy Matthews
I've got some elaborate joins I'm performing against tables with which I'm not all that familiar. Access has a built in function called Relationships which allows you to visualize tables and their columns. Does SQL Server have something like this? Alternately, is there a quick way of dumping a

RE: cfstoredproc vs cfquery

2007-02-22 Thread Leitch, Oblio
cfstoredproc will allow you to get back multiple resultsets. If you've got the latest updates (and the release notes are correct), they've finally fixed the 'annoymous' resultset issue, allowing un-numbered cfprocresults. -Original Message- From: Bobby Hartsfield [mailto:[EMAIL

RE: A few questions about SQL Server 2000

2007-02-22 Thread Ben Nadel
Andy, while I am no DB expert, Access should allow you to connect to a MS SQL server data base and use all the Access-style visualization I think. I use access to view the DB cause Access has an AWESOME paste-append feature and you can move the columns around (visually). Create a new file

RE: CFSEARCH

2007-02-22 Thread Will Swain
Haven't used cfsearch for a while but from memory wouldn't: your search generated #SearchSnippets.RecordCount# results work here? Will -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: 22 February 2007 16:34 To: CF-Talk Subject: CFSEARCH I have this basic

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
Thank, Andy... -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:44 AM To: CF-Talk Subject: Re: Managing multiple CF7 instances to one IIS site Multiple instances on a single box will also allow you to get over JVM limitations. On a 32

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
Hmmm don't understand how that works, but, I'd sure like to know more. Sounds like something I could employ. Are multiple instances run just in case one instance locks up or something and then the other instance continues processing? Is there an in-depth discussion or blog somewhere about

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
Oh... don't misunderstand my comments. I'm responding from a position of complete ignorance on the topic. I just wasn't sure what the issue was that deploying CF in that manner would address. Sounds to me that running multiple CF instances, each with a few sites/apps in each instance would be a

RE: A few questions about SQL Server 2000

2007-02-22 Thread Dave Watts
I've got some elaborate joins I'm performing against tables with which I'm not all that familiar. Access has a built in function called Relationships which allows you to visualize tables and their columns. Does SQL Server have something like this? Yes, look for Diagrams. You will have to

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
So... other than a workaround for your particular situation, this is not something that has practical benefits in routine deployments... ??? Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:39 AM To: CF-Talk Subject: RE:

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
Makes perfect sense, Ben. Goes right along with what I mentioned as a possible benefit in an earlier post... isolating apps that are new and need time to prove that they're not going to lock up the system. Having the new apps isolated in an instance for awhile from other proven apps seems like

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ian Skinner
Are multiple instances run just in case one instance locks up or something and then the other instance continues processing? That's the idea as I understand it. I've never tried it, so can't comment much more then to say it is possible. Is there an in-depth discussion or blog somewhere about

RE: A few questions about SQL Server 2000

2007-02-22 Thread Andy Matthews
Yay... I found that SQL Server does have database diagrams. That's what I'm looking for. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:57 AM To: CF-Talk Subject: RE: A few questions about SQL Server 2000 Andy, while I am no DB

RE: cfmail problem

2007-02-22 Thread Dave Watts
I'll test and see if a friendly email address would be enough difference to make it work. Know if it would off the top of your head dave? Any email address will work, as long as it's not recognized as a local address by the target mailserver. Dave Watts, CTO, Fig Leaf Software

Wrap issues

2007-02-22 Thread Thomas Peer
We're having issues with the wraptext attribute in CFMAILPARAM on 6.1 It's ignoring return characters when calculating line lengths and inserting a line break after every 72 characters regardless of whether there has been a line break before then. The Wrap() function seems to do the same.

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread mailme
You could run the clustering several ways. We use multiple machines with multiple clusters. Each machine, right now, supports up to three different clusters. So machine A has an instance that is part of cluster G. But so does machine B and C. You could very easily do this with one machine

RE: CFSEARCH

2007-02-22 Thread Dave Watts
I have this basic Cfsearch for a page that searches our collections: CFSEARCH NAME=SearchSnippets COLLECTION=databases TYPE=simple MAXROWS=20 CRITERIA=#FORM.searchstring# /CFIF How do I insert code that will display a your search generated 0 results to display? I know

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Dave Watts
And, if I understand CF licensing issues correctly, I wouldn't have to purchase a license for each instance, right? No. Each license covers two CPUs on a single machine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber

Cfquery timeout parameter.

2007-02-22 Thread Ian Skinner
Can somebody tell me exactly how this works? Reading the documentation I get this message. Timeout: Maximum number of seconds that each action of a query is permitted to execute before returning an error. The cumulative time may exceed this value. What exactly is an action in a query and if

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Dave Watts
So... other than a workaround for your particular situation, this is not something that has practical benefits in routine deployments... ??? Running multiple instances has lots of benefits, some of which have already been mentioned: - more effective use of physical memory - clustering -

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread mailme
My workaround is only if you need to have multiple virtual webs use a different cluster/local or remote instances. If the site is just using one cluster of local instances, then you get the benefit of failover, and if it's a beefier box, full use of your memory. In theory. I've not done real

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ian Skinner
Just to be clear to anybody who is reading this, multiple instances on a box does not require multiple licenses, but it does require the enterprise license. This topic does not apply to the standard license. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento,

RE: cfstoredproc vs cfquery

2007-02-22 Thread Dave Watts
Anyone know if there is an advantage either way when it comes to calling a stored procedure? In the example you provided, there's no difference, but stored procedures can be much more complex than a single SQL statement. Stored procedures can return multiple recordsets, they can accept and

Re: A few questions about SQL Server 2000

2007-02-22 Thread Jim Wright
Ben Nadel wrote: Create a new file Project using existing database An Access project is probably a good way to go since you are comfortable with Access, but it does not use the Access Relationships function that was described. It has something similar in the Database Diagrams button that

RE: Cfquery timeout parameter.

2007-02-22 Thread Ben Nadel
I guess it means the execution of a single: UPDATE SELECT DELETE Statement. Like, these would be TWO actions: UPDATE [table] set name = 'ben'; SELECT * FROM [table] .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help?

RE: Cfquery timeout parameter.

2007-02-22 Thread Ian Skinner
I guess it means the execution of a single: UPDATE SELECT DELETE Would this also apply to sub-selects and other more comlex SQL syntax? Say: SELECT aField FROM (SELECT bField FROM bTable) aTable Would that be two actions? Each one allowed to run for the timeout period, or if the inner select

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ian Skinner
And, if I understand CF licensing issues correctly, I wouldn't have to purchase a license for each instance, right? Rick Nope. We do something similar here, but with multiple IIS websites connected to multiple cf instances, but all on the same box. We isolate our critical applications in

RE: Cfquery timeout parameter.

2007-02-22 Thread Ben Nadel
I assume that one be ONE action for the outer SELECT... But that's just a guess. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED]

RE: cfstoredproc vs cfquery

2007-02-22 Thread Jeffrey Polaski
Just to add a bit to the thread: cfstoredproc is, in general, a little more secure. It allows you to specify the data type of parameters, which can help with security. Stored procedures are generally harder to break out of during a SQL injection attack. Also, a stored procedure can have more

RE: CFSEARCH

2007-02-22 Thread Orlini, Robert
Thanks Dave and Will. Robert O. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 12:33 PM To: CF-Talk Subject:RE: CFSEARCH I have this basic Cfsearch for a page that searches our collections: CFSEARCH

RE: cfstoredproc vs cfquery

2007-02-22 Thread Ian Skinner
I've found that they work really well together. I generally develop an app with cfquery, and change them all to cfstoredproc before I put it into production. I just want to point out that the topic of this thread is that one can CALL simple stored procedures with cfquery... tags, so what is the

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
So each instance is a duplicate of the others? And you maintain separate databases in each instance, also? Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 12:34 PM To: CF-Talk Subject: RE: Managing multiple CF7 instances to one

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
That's good... one license per two CPUs... and one license for unlimited instances on two CPUs? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 12:39 PM To: CF-Talk Subject: RE: Managing multiple CF7 instances to one IIS site And, if I

Re: cfstoredproc vs cfquery

2007-02-22 Thread Paul Ihrig
ok... question. i have always used a stored proc to initally grab my data set. but then use cfquery to re-sort the data as well as page though it.. i am not that quick at dba stuff, but is the way you guys do it? or do you pass your sort orders paging back to the proc.. thx

Re: cfstoredproc vs cfquery

2007-02-22 Thread Robertson-Ravo, Neil (RX)
For one, with cfquery calling an SP either by EXEC or via sp_executesql (preferred) means you cannot return back multiple resultsets. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in

Re: cfstoredproc vs cfquery

2007-02-22 Thread Robertson-Ravo, Neil (RX)
Paging can be done at the DB side for sure, you probably just need to pass in the required offset. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
Good to know... anyway to limit the amount of RAM an instance can affect? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 12:32 PM To: CF-Talk Subject: RE: Managing multiple CF7 instances to one IIS site And, if I understand CF licensing

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Rick Faircloth
Well... so much for that idea... Pro Edition only, here... Rick -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 12:41 PM To: CF-Talk Subject: RE: Managing multiple CF7 instances to one IIS site Just to be clear to anybody who is reading

Help - need to show result only once

2007-02-22 Thread John Seelye
This query calls a function in the database that gets the sum of the items returned with a category id 9 and a valid transaction number. The problem is that it returns one value for each item in the list of those ordered. What i need is to just show the total once. cfquery name=qGetCatTotal

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread mailme
If the goal is to have failover and session replication, then they need to be duplicates. It's really as simple as copying the cfusion-ear file and deploying through the JRun JMS. You would then add this instance (as many as required) to the cluster. Or, you can use the CF Enterprise manager to

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ian Skinner
Good to know... anyway to limit the amount of RAM an instance can affect? I would presume that would be affect by the amount of RAM the jvm setting for the instance was configured to use. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 |

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Ian Skinner
Well... so much for that idea... Pro Edition only, here... Rick Well, if you want you can play with it with the free Developer edition, you just install it in the multi-home or j2ee configuration. Just realize that if you fall in love with the functionality you will need an enterprise

RE: Help - need to show result only once

2007-02-22 Thread Ben Nadel
Without messing with the Function, you could throw MAXROWS attributes in the CFQuery tag maxrows=1. Not the good solution, but one that should work. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/

Re: Help - need to show result only once

2007-02-22 Thread John Seelye
Thanks. I tried that, but the problem is that the function returns only one row as it is, but it returns one row for each item with the FK '9' (which is each thing within that category). I can't mess with the function, it is from a different department and is used in other applications. I

RE: cfstoredproc vs cfquery

2007-02-22 Thread Jeffrey Polaski
I've always done sorting in the query or sp, by adding an order by clause. If I need a special ordering then I usually add a sort order column where I plug in numbers to order it on. If I'm doing paging then I pass in an offset, too. Jeff Polaski Webmaster Office of Research Office of

RE: Help - need to show result only once

2007-02-22 Thread Ian Skinner
Can you use a Query of Query to further refine your result set? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Sudoku | | | - C code. C code run. Run code run. Please! - Cynthia Dunning

Re: SQL next and previous

2007-02-22 Thread David Gardner
Add something like this into your where clause WHERE clientID = cfqueryparam value=#clientID-1# cfsqltype=cf_sql_integer/ OR clientID = cfqueryparam value=#clientID# cfsqltype=cf_sql_integer/ OR clientID = cfqueryparam value=#clientID+1# cfsqltype=cf_sql_integer/ and then sort by clientID.

cfflush

2007-02-22 Thread Tim Stutzman
Hello, I am having trouble with cfflush. Basically I have some queries running and would like to output a message when each query is done. The problem is that the output doesn't occur until all queries are done. I am using cfflush but it seems to have no effect. Thanks

Here's a weird one

2007-02-22 Thread Scott Stewart
In a template I'm working on (it's CF5.0 that's why we're locking vars.) I'm locking the session var Session.ID, then setting Variables.ssId with the value cflock scope=Session type=EXCLUSIVE timeout=10 cfset Variables.sOrgId=Session.Org_Id cfset Variables.sPatientId=Session.Patient_Id cfset

RE: Managing multiple CF7 instances to one IIS site

2007-02-22 Thread Dave Watts
That's good... one license per two CPUs... and one license for unlimited instances on two CPUs? Yes, if you've purchased Enterprise. There is no limit in the license to the number of instances you can run under one license. There is, of course, a practical limit, which is primarily dependent

RE: cfflush

2007-02-22 Thread Dawson, Michael
What is the interval you have set? It needs to be fairly large to be noticed that it should be flushed. I usually set it to 1KB, then if there is a small amount of text that is to be flushed, at that point, I will send a large HTML comment to the stream. M!ke -Original Message- From:

  1   2   >