RE: Send response to browser, but continue working on request?
Perhaps you could use the CFSCHEDULE tag to programmatically schedule a job to run (soon) which generates the file and sends the email? Then the page that the user sees will be done as soon as the job is scheduled (should be quick). Though some people hate CFSCHEDULE and I haven't used it much. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:33 AM To: CF-Talk Subject: Re: Send response to browser, but continue working on request? That let's me get a message to the browser, but the request is still running and the browser is still waiting... I want to browser to stop waiting... Have you tried cfflush? I believe this tag will allow you to send partial responses to the browser. I might have spelled it wrong, but I am sure there is a function in CF. David - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:17 AM Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: javascript or html to crash netscape or IE
I need a snippet of javascript/html/dhtml/css/whatever that will cause Netscape or IE to crash reliably so I can test something. I have certainly managed to crash them in the past but can't find the code that did it. Any ideas? Martin Herbener ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript or html to crash netscape or IE
I mean, put the browser in such a state that its window does not update and it can only be made to go away by using Task Manager to kill the process. It's ok if the crash doesn't kill the OS. -Original Message- From: Ron Hornbaker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:45 PM To: CF-Talk Subject: RE: javascript or html to crash netscape or IE I need a snippet of javascript/html/dhtml/css/whatever that will cause Netscape or IE to crash reliably so I can test something. I have certainly managed to crash them in the past but can't find the code that did it. Any ideas? http://www.netscape.com/ usually does it for me. ;) Seriously, crash how? Throw a JS error? Lock up the application? Lock up the computer? Lock up the house, and cause your toilets to overflow and your wife's hairdryer to catch fire? Be specific, man. :) -Ron ¸_¸.·´¯) http://www.BookCrossing.com ~ Read and Release! (¯`·.¸_¸. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle 1704 errors without SQL statement - client var related?
In the past few days I've started to get some Oracle ORA-01704 (string literal too long) errors in my application.log file. These error entries are NOT accompanied by the SQL statement, which is unusual, and which makes it hard to diagnose. I do use client variables, stored in Oracle. Could these errors be related to client variable update/insert/select? Any other explanation for why the SQL statement does not appear in the log file? The errors seem to have started since I upgraded from Oracle 8.0.4 to 8.1.7. CF 4.51 SP2 on windows NT 4 SP 6a. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server runs under user account
I don't know, haven't tried it yet. If you want to try it and let me know what changes, I'll post an updated document. -Original Message- From: dave fauth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 8:18 AM To: CF-Talk Subject: RE: CF Server runs under user account Are there any major changes for CF5, especially w/ the JRUN piece installed for graphing? thanks dave At 01:35 PM 12/1/2001 -0500, you wrote: I posted some info on this at http://www.defusion.com/articles/index.cfm?ArticleID=89 which describes using somewhat more restrictive settings than the allaire --- dave fauth [EMAIL PROTECTED] The opinions expressed here are my own and not those of DOMAIN technologies, inc. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server runs under user account
I posted some info on this at http://www.defusion.com/articles/index.cfm?ArticleID=89 which describes using somewhat more restrictive settings than the allaire article. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 7:36 PM To: CF-Talk Subject: Re: CF Server runs under user account http://www.allaire.com/Handlers/index.cfm?ID=11859Method=Full HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product http://www.sys-con.com/coldfusion/readerschoice2001/nomination formbpa.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Tony Gruen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 7:09 PM Subject: CF Server runs under user account Howdy CF community, Does anyone have any input/experience with setting up CF Server to run as under an user account? We have Win 2000 Server, CF 4.5 and have been instructed to setup a site so that web users of that site are controlled by user account for directory/file access/creation using CFFIle and CFDirectory. Allowing them to upload files, create directories for their site only... protected from effecting other sites on that server. Thank you in advance for any assistance. Tony Gruen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complete lack of locking...
Don't trust CF to auto-lock reads. It seems well-established that CF does not catch every use of shared-scope variables when you use auto-locking. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 3:08 PM To: CF-Talk Subject: RE: Complete lack of locking... For those of you adverse to locking, why not simply set the server to lock all reads? Doing so means you can refer to you session variables (and others that should be locked) without explicitly locking them, however, you do not sacrifice the performance gains (as you would going to single thread mode). You still need to lock the variables when you set them, but if you're like me you only set the variables in a couple of places, but use them all over. Am I missing a performance issue on this? Is there some reason why this option wouldn't be reasonable? Shawn Grover -Original Message- From: Keith Meade [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 1:01 PM To: CF-Talk Subject: Re: Complete lack of locking... I guess I'm hoping that future versions of CF will require *less* locking. The whole locking thing is silliness that should be handled automatically within CF. But the important point is that the Single Threaded Sessions option makes session variable locking unnecessary. And I'll bet a dollar that it doesn't have a discernable affect on real-world performance. Plus you get cleaner code. - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 12:19 PM Subject: RE: Complete lack of locking... No offense, but it sounds like urban legend to me. Assuming it's properly implemented, the Single Threaded Sessions option should only have a significant effect in situations where two ColdFusion requests are being made at the same time within the same session, i.e. when two browser framed windows are loaded at once. Even on a framed site, this would be a relatively rare event. I've never heard a convincing argument for locking session variable access. The only exception I make is when I don't have control of the CF Administrator settings. I make it a point to ensure Locking is in for all Server, Client and Session variables - better safe than sorry You never know what they might do in future releases that may impact on your code - why risk it It's like I never do cfset form.#FieldName#=myValue anymore - I always use SetVariable Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Load balancing with hardware solution - still require Enterpr ise?
In this scenario, was the SSL cert installed on the Foundry box or all the webservers? -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, November 23, 2001 9:19 AM To: CF-Talk Subject: Re: Load balancing with hardware solution - still require Enterprise? No, you don't need lb/failover services of Enterprise with a hardware load balancer... At my last big site we used a Foundry lb with several webservers. If you use session variables, be sure to use the datasource method rather than registry - this was a user can pass from machine to machine without issue. We setup each machine to mount a shared webroot from a fileserver, so that there were no code distribution issues, all machines used the same webroot. Also, each machine was addressable at its own unique hostname, but since the load balancer answered as www, we were able to use the same ssl certificate (www.domain.com) on each machine with error (unless you hit it with its hostname specifically). I was wondering if I passed the job of load balancing to a third party hardware solution, do I still need to use Enterprise? TIA, Dave ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting Errors
I wrote a CFX a couple of years ago to solve this very problem (mixed alpha-numeric data that people want sorted in quasi-numeric order). C++, Windows only. Works in 4.5 but not tested in 5. Not appropriate for huge result sets. http://devex.allaire.com/developer/gallery/info.cfm?ID=44C48F77-35E9-11D4-83 D700508B94F85Amethod=Full -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:47 PM To: CF-Talk Subject: RE: Sorting Errors Opps, my mistake in explaining. ahh... some of the Lot#'s are... alphanumeric for example: 1 10-A 1000 101-B1C2a 201 21 and this should sort as... hummm... I'm not sure what I'm doing anymore... I have to give this more thought 1 10-A 21 101-B1C2a 201 1000 At 02:10 PM 11/21/01 +1300, you wrote: wouldn't it be better to have the LOT# field as int? -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 November 2001 2:02 p.m. To: CF-Talk Subject: Sorting Errors I have a problem that I have a solution to but would like to query the group to see if there is some more elegant solution. Simply Put, When using varchar(10) as a datatype, (for a LOT# field used in manufacturing), the typical number sequence sorts with values like 1000 above something like 101. Example: 1 10 1000 101 201 21 I just pad the left with blanks in the database so that it sorts like this. 1 10 21 101 201 1000 Is there some more elegant or more standard way that I should be using? Thanks to anyone who chimes in. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SUMMARY: Request Scope Follow up Locking Questions
Because it doesn't work. In CF 4.5x, anyway, auto read locking doesn't catch all uses of shared-scope variables; I don't have a list of what it does and doesn't catch, but generally it misses things like Cfquery name=variables.myqyery datasource=#application.dsn# and other non-cfset situations. -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 10:16 AM To: CF-Talk Subject: RE: SUMMARY: Request Scope Follow up Locking Questions But surely that means that CF is using double the memory for every request... Memory to store the session details and memory to store the session details.. Whats wrong with setting CFAdmin to automatically lock reads... That way any time you read a shared var ie IsDefined and DSN's etc its already locked... Then all you have to do is lock the writes.. -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 15:09 To: CF-Talk Subject: Re: SUMMARY: Request Scope Follow up Locking Questions use something like cfset request.var=Duplicate(session.var) to transfer the variable. I think to use request.var this way you can only read the variable. Absolutely - maybe I should have said. I generally transfer session variables into the request scope in application.cfm so that I don't have to worry about locking every time I want to read a session variable (90% of my use of session variables). Of course, if I need to update a session variable, I use a lock for writing to the session variable itself, and the updated value gets read back into the request scope next time round (you can update the corresponding request variable immediately if the value might be needed within the same request, naturally). - Gyrus ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF reading the wrong file?
Ok, I'm really confused. I just got an error that a certain variable was not defined. Ok, I've made that mistake plenty of times, but the template referred to by the error message doesn't use that variable. It is used in another template, located in another directory on the same server. When I look at the list of templates processed (down below execution time) the template that does use that variable isn't in the list. Has anyone seen such behaviour before? Did you find any way to fix it? CF 4.51 SP2, on NT 4 SP6A Martin Herbener ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Stored Procedure
I think you need DBVARNAME=Orderby instead of DBVARNAME=@Orderby This might be helpful: http://www.defusion.com/articles/index.cfm?ArticleID=56 -Original Message- From: Jared Stark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 5:54 PM To: CF-Talk Subject: Problem with Stored Procedure -- Here is code snippet for my stored procedure: CREATE PROCEDURE spGetManagers @OrderBy nvarchar(20) = 'LAST', @OrderType nvarchar(10) = 'ASC', @Id int = -1, @ErrorStatus int OUTPUT, @ErrorMsg nvarchar(255) OUTPUT AS ... -- Here is CF Code calling the stored procedure: cfstoredproc datasource=#request.dsn# username=#request.user# password=#request.pass# procedure=spGetManagers cfprocparam dbvarname=@Orderby type=IN value=LAST cfsqltype=CF_SQL_VARCHAR cfprocparam dbvarname=@ErrorStatus type=OUT variable=ErrorStatus cfsqltype=CF_SQL_INTEGER cfprocparam dbvarname=@ErrorMsg type=OUT variable=ErrorMsg cfsqltype=CF_SQL_VARCHAR cfprocresult name=manager resultset=1 /cfstoredproc You'll notice that I'm not providing parameters for @OrderType, nor @Id as they have default values defined in the sp. -- Here is the error message I am getting: [Microsoft][ODBC SQL Server Driver][SQL Server]Formal parameter '@OrderType' was defined as OUTPUT but the actual parameter not declared OUTPUT. It would appear that it is trying to map my second cfprocparam to the @OrderType parameter, rather than using Named Notation and mapping it to @ErrorStatus. My understanding is that by using the dbvarname attribute it would pass to the correct parameter and I wouldn't need to provide a cfprocparam tag for ALL parameters. 1. Is there something stupid here that I'm missing? 2. Has anyone else had this problem? 3. Should I call it a day, and go home? (yes) Thanks for any help... Jared ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4.5 automatic read locking unreliable?
I have seen suggestions that, with CF 4.5x, the automatic read locking setting misses some read/write situations. I can't remember the exact situation; I think it was something other than CFSETS, such as cfmail server=#application.mymailserver# and similar. Anyone got confirmation or refutation of this claim? Martin Herbener ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 4.5 automatic read locking unreliable?
Any info on whether CF 5 fixes this? -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 10:17 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: CF 4.5 automatic read locking unreliable? I can confirm that. The MM tech said he'd seen it and is planning on writing it up. Auto read locking basically misses everything except cfsets. sheesh We got stung on structfind and structinsert (which are a read and a write). Auto read locking should be treated as only an interim solution to full manual locking, or to moving away from shared-scope variables. best, Chris Norloff -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 2 Oct 2001 09:19:44 -0400 I have seen suggestions that, with CF 4.5x, the automatic read locking setting misses some read/write situations. I can't remember the exact situation; I think it was something other than CFSETS, such as cfmail server=#application.mymailserver# and similar. Anyone got confirmation or refutation of this claim? Martin Herbener ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2 Submit Buttons on one form
I think (haven't tried lately) even without javascript, with two forms. form action=firstplace input type=submit /form form action=secondplace input type=submit /form -Original Message- From: Mark Robinson (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:28 AM To: CF-Talk Subject: RE: 2 Submit Buttons on one form Yep. JavaScript. If you want the code give me a shout back. mark -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 16:23 To: CF-Talk Subject: 2 Submit Buttons on one form Is it possible to place two submit buttons on one form, each button calling a different action (template). If so, how would it be done? Thanks, Mark ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Trouble with ClusterCats
I had a problem with similar symptoms; turned out that the probe process couldn't access cfprobe.cfm. The method ClusterCats uses to decide where to look for cfprobe.cfm is not clear to me, and if it can't get it for any reason it decides that the server is busy. Look in your IIS (or whatever) logs for requests to cfprobe.cfm and see if they are being denied for some reason. -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 7:01 PM To: CF-Talk Subject: Trouble with ClusterCats I'm having some troubles configuring clustering on CF5. Specificaly, the load monitor on all servers runs at less than 3% for 20-30 seconds then shoots up to 100% and makes the machine in the cluster offline. To simplify testing this, the problem duplicates by adding only a single machine to the cluster and bringing up load monitor. Here is my process: 1. Create the Cluster 2. Add A SINGLE machine to the cluster 3. Configure a basic probe to the btauxdir\cfprobe.cfm file checking for Hello 4. Manually verify cfprobe.cfm is working 5. Bring up the load monitor on the single server. Within 30 seconds server load is reported at 100%. Using OS tools and checking the service, there is no noticable load. I have found restarting the CF monitoring service will return state to normal for another 20-30 seconds before jumping up to full utilization. I'm using a very simple configuration, 2 identical servers set up on DNS round robin. No hardware ballancing. My goal is primarily failover protection for when one machine becomes unavailable. I did find the hotfix about CPU utilization. I didn't think it would apply to this as OS CPU utilization is unaffected by this, but the results duplicate regardless of applying the hotfix or not. On an unrelated note, I've descovered on every install of every machine I've ever made of CF5 w/ custerCATS the reset feature under ClusterCATS Administrator - Advanced - Reset fails with an unable to remove Btauxdir error message. I've looked around and found no related issues reported in support forums or addressed in a knowledge base article (go figure) so I thought I would see if anyone has any ideas here... Trey Rouse [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OLE-DB Client Storage Problem
I have at least one OLEDB datasource to an MS Access db that works, but it's not a heavily used app. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:10 AM To: CF-Talk Subject: Re: OLE-DB Client Storage Problem Peter, Thank you for your response. I should probably re-word my question to, Is there anyone on this list who actually uses MS Access (or any other db for that matter) as an OLEDB datasource? I set my database up in CF Admin that way because I thought it would make it more robust (re: Allaire KB article) but OLEDB doesn't seem to be well supported by ColdFusion. By that, I mean there are no OLEDB date functions and, as I've already indicated, CF Admin is unable to make the necessary tables for client variable storage if the datasource is OLEDB. Your suggestion is by far the simplest solution...and I'm ready to bail. :-) Thanks, Dina - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Friday, August 31, 2001 6:39 PM Subject: RE: OLE-DB Client Storage Problem Possibly only supports ODBC connections. Try that first and it should be OK. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mulit-User Concurrency
Another old approach that might work better in the who-knows-how-long-the-user-will-take-or-even-if-they're-still-logged-in world of the web is 1) when selecting include a magic field (explained below) 2) let user make edits with the UIl; when ready to save 3) within a db transaction check to see that the magic field has not changed; if unchanged, do the update, but if changed, re-select data, notify user, display their data and the just-retrieved data so they can decide to overwrite or back off SQL Server (Sybase Microsoft) had/have a specific datatype for this magic field called TIMESTAMP (a name that was a recurrent source of confusion) but it could be implemented in any modern RDBMS; you just need a field that, through triggers or something, is _guaranteed_ to increment any time the record is updated. -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 6:39 PM To: CF-Talk Subject: Mulit-User Concurrency Sure... I see, Thanks Pete. A Cached Array for persistent data which is index pointers so to speak... yep makes sense. Ok... NOW, Thinking deeper... How are people handling Multi-User concurrency issues? How to not overwrite someone elses changes to a record while pondering how to make your own changes to the record IE: User A reads Record #1. User B reads record #1. User B changes fields[3,4,5] in Record #1 and rewrites the entire record. User A changes fields[7,8,9] in Record #1 and overwrites [3,4,5] with old data just changed by User B. In the past I have used the Classic Lock/ReReadRecord/ModifyMyChangedFieldsOnly/WriteRecord/UnLock scenario to avoid this via built in tools... What does CF have built in or in the way of custom tags to help with this? At 04:01 PM 8/31/01 -0400, you wrote: Gonzo, There are cases where building a cached array is more efficient. Mainly when you want indexed Access to records (basically your not going to output all your data at once). So consider the following situation lets say you had a table called documents that you accessed the following way... /getDocument.cfm?DocumentID=12 and it would pull the document from the db with that ID out and display it. If you had a cached query your going to have to loop through it and find the correct document (or do a query of a query). It's much faster to access an array element here than perform this comparison. Here's how you might build such an array, for this general document example: put this in application.cfm ... cflock scope=application type=exclusive timeout=20 cfif NOT IsDefined(application.document) cfquery datasource=dsn name=doc SELECT DocumentID, Name, Description, Content FROM documents /cfquery cfset application.document = ArrayNew(1) cfoutput query=doc cfscript application.document[DocumentID] = StructNew(); application.document[DocumentID].Name = doc.Name; application.document[DocumentID].Description = doc.Description; application.document[DocumentID].Content = doc.Content; /cfscript /cfoutput /cfif /cflock Now to access an element, something like this... cflock scope=application type=readonly timeout=20 cfoutput#application.document[url.DocmentID].content#/cfoutput /cflock Note that if someone types in a DocumentID into the url that is not in the array an error will be thrown, you need to catch that error. Also do not use this technique to store large amounts of data, because your server could run out of RAM. ++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 3:36 PM To: CF-Talk Subject: RE: Efficient Query Manipulation? Bryan... Love that you responded... I was beginning to feel invisible on this list ;-) Umm... Ok You say the DBServer should absorb the load, not the CFServer. So Refinding 100 indexed database records is faster/easier/MoreResource Efficient than CFServer manipulating 100 records stored in an Array. Very Interesting point. RE the interface: Thanks for the ideas... not sure what I'll be doing... Currently I have three submit buttons for each Row now... insert above this row, delete this row, edit this row. Just want to work out the best way to do this before going on because it will be central and used heavily in the rest of this application. again, thanks for making me not feel so invisible ;) Gonzo At 12:17 PM 8/31/01 -0700, you wrote: It is not very efficient to convert query results to an array. The overhead involved is completely avoidable.
RE: Plain text view in outlook?
Probably most effective to get yourself a plain-text email client to experiment with, assuming you have something that looks like a POP server. An older version of Eudora (free light version at ftp://ftp.eudora.com/eudora/eudoralight/windows/english/306/) should work. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 7:02 AM To: CF-Talk Subject: RE: Plain text view in outlook? Mark, tools, options, mail format, and choose plain text from the message form drop down list This option is for sending mail messages, not receiving. Maybe if someone has a plain text (support?) e-mail client I can send him an example? Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
You might want to try using the tcp/ip network library instead of Named Pipes - in general people seem to have more success with it. You have to adjust the network library (the network protocol choice) on both the server and the clients (including the CF server); the server can support more than one library simultaneously (different clients connecting with different libraries) but a client can use only one library to connect to a given server. On the server you adjust this with the install/setup tool, on the client there's something called the Client Configuration utility that does this. All assuming your SQL server is set up to talk tcp/ip.. -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 8:33 AM To: CF-Talk Subject: RE: Strange ODBC Error Hi Mike; We would get that error whenever the connection to our SQL database failed, like is someone decided to reboot the database server while the site was still running. Melanie -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:07 AM To: CF-Talk Subject: Strange ODBC Error Fellow CFers, Has anyone ever seen an intermittent ODBC error, like the following: ODBC Error Code = 01000 (General Warning) [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults()) It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Stored Procedures
In Oracle you would use the DBMS_SQL package.
-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 10, 2001 12:02 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
pass the list as a string variable and parse it in the sp. Haven't done that
with Oracle but do it all the time wiht SQL Server when I have a variable
number in inputs.
I am not sure if Oracle allows you to build a dynamic sql string and execute
it within a sp or not. SQL Server does and if all i have is a list of id
passed in as a comma delimitted list I do:
DECLARE @st varchar(2000)
SET @ST='SELECT BLAH FROM SOMEWHERE WHERE ID IN (' + @MYINPUTLIST + ')
EXEC (@ST)
- Original Message -
From: dave fauth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, August 10, 2001 6:25 AM
Subject: RE: Oracle Stored Procedures
I have a piece of code that I want to move to an Oracle SP. It allows a
person to enter a user-defined number of names to search the db with. The
question I have is how to talk to Oracle to allow for N number of names to
be passed to the procedure.
Any ideas are welcome.
thanks
dave
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Stored Procedures
From the CF 4.51 release notes: Oracle Reference Cursor Support This release supports the return of result sets via Oracle Reference Cursors through the Oracle 8 native driver and the ColdFusion stored procedure interface. The example below shows both the PL/SQL necessary for creating a procedure to return a result set and the CFML necessary for executing the procedure in ColdFusion. The example uses the Oracle SCOTT/TIGER login sample data. The final ColdFusion documentation for this release will contain additional information and examples. Example: Return of all rows in the DEPT table entirely through a package. PL/SQL CREATE OR REPLACE PACKAGE dept_data AS TYPE DeptTyp IS REF CURSOR RETURN dept%ROWTYPE; PROCEDURE refcurproc(pParam1 in out DeptTyp); END dept_data; CREATE OR REPLACE PACKAGE BODY dept_data AS PROCEDURE refcurproc(pParam1 in out deptTyp) IS BEGIN OPEN pParam1 FOR select * from dept; END refcurproc; end dept_data; CFML cfstoredproc procedure=dept_data.refcurproc datasource=my_oracle80_test username = scott password = tiger RETURNCODE=no cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR variable=param1 cfprocresult name = rs1 /cfstoredproc bThe first result set:/bbr hr cfoutput query = rs1 #dname#,#deptno# /cfoutput -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 8:32 AM To: CF-Talk Subject: Oracle Stored Procedures Can anyone help me with the syntax of executing a stored procedure in Oracle? I have one input parameter(grpid) and one output parameter(tpcid) and they are both numeric. Here is what I am trying: cfstoredproc procedure=slct_topic_tpcid datasource=#appDSN# returncode=yes cfprocparam type=In dbvarname=grpid value=100 cfsqltype=CF_SQL_Numeric cfprocparam type=Out dbvarname=tpcid cfvarname=newtpcid cfsqltype=CF_SQL_NUMERIC cfprocresult name=proctest resultset=1000 /cfstoredproc With the code about, I get a syntax error.. Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Synchronize Web Based DataWith Oulokk
I always wondered if the cfimpersonate tag would allow this to work (access the mailbox using the credentials of the individual thru CDO). Has anyone tried? -Original Message- From: Smutz, Miles A Mr DVLPRS (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 9:16 AM To: CF-Talk Subject: RE: Synchronize Web Based DataWith Oulokk About integrating CF with Exchange/Outlook... Collaboration Data Objects (CDO) runs on the server side, and is an interface to Exchange's Messaging Application Programming Interface (MAPI) model. You can find information about CDO at msdn.microsoft.com - one thing that keeps us from using it, though, is that the CF server would have to be running as an account that has access to any Exchange folder it needs to work with. And we probably cannot get that kind of access to the Exchange server. One thing we've looked at is to access a single user's Exchange/Outlook ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data-modeling for anniversaries...
I would use a series of database functions to turn the original date into a date in the current year, like this (Oracle-ish code since I don't know what DB you're using but am too lazy to find the exact syntax): to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(), 'm-d-' ) now I have a date field and can compare to today and today + 7 days. -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:31 PM To: CF-Talk Subject: Data-modeling for anniversaries... I've run into a data-modeling stumper. I have a database table which contains wedding anniversaries and the respective couple's name. The date is stored as the wedding date, so calculating the anniversary is easy. The primary usage of this is to display the anniversaries on a monthly calendar. However, now i need to select just the anniversaries which will be coming up in the next week. The problem is that since the dates are stored with the original years (i.e. 11/28/1970), I can't just select the dates that are between a specific date range, because the year will throw that all out of whack. So how can i select based just on the month/day, also taking into account that in the middle of the week the month can change to the next month (November-December)? Any ideas? Cheers, David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle select after insert does not get new data
I'm seeing something I've never seen before. Using CF 4.51SP2 and the Oracle 8.1.6 client on NT 4 SP6a, accessing an Oracle 8.0.4.4 server on NT 4 SP5?, I am doing an insert followed immediately by a select for the same data and having the select come up empty. If I put in a .3-second delay the select works. I've fooled with using an explicit transaction around the insert and changed the CF server config to use only one simultaneous connection without fixing the problem. Has anyone seen this sort of behavior before? Martin Herbener Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Important ColdFusion Security Patch Released Today
Does anyone know: 1) exactly what files are updated (looks like all the stubs - such as iscf.dll - but I'm not sure) 2) the nature of the security problem - obviously MM is going for security-thru-obscurity and is not going to describe the exact problem, but some clue as to the possible effects, how to tell if the weakness has been taken advantage of, etc would be helpful 3) what workarounds, if any, can be used instead of applying the patch 4) If there's a way to apply the patch without a reboot (if it's just the stubs an IIS stop-start might be enough) -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 8:50 AM To: CF-Talk Subject: Important ColdFusion Security Patch Released Today During a routine internal security audit of Macromedia ColdFusion, Macromedia discovered two important security issues that affect ColdFusion Server versions 2.0 through 4.5.1 SP2. We have released a Security Bulletin about these issues and a patch for ColdFusion Server versions 3.1.1, 4.0, 4.0.1, 4.5, 4.5.1 SP1, and 4.5.1 SP2 (all editions). We are strongly encouraging customers to review the new Macromedia Product Security Bulletin (MPSB01-07) and to install the patch as quickly as possible. You can find the security bulletin and the patch in the Security Zone at: http://www.allaire.com/security ~~~ MPSB01-07: Macromedia releases patch that addresses ColdFusion security issues. Please note, the security issues DO NOT affect ColdFusion Server 5. As a Web application server vendor, the security of the systems our customers deploy is a top priority. Securing Web applications, especially those deployed on the Internet, is complex and involves a wide range of technologies and methodologies from a variety of vendors. Macromedia uses the Security Zone in order to better inform our customers about security issues that may affect them. In the Security Zone you will find Security Bulletins that explain important issues, technical briefs, and links to other resources. In addition, you can subscribe to the Security Notification Service in order to receive future Security Bulletins when they are published. We understand how important security is to our customers, and we're committed to working to provide a secure platform for your Web application development. Thank you for your time and consideration on this issue. - Security Response Team, Macromedia, Inc. P.S. As a reminder, Macromedia has set up an e-mail address that customers can use to report security issues associated with any Macromedia product; that is: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Important ColdFusion Security Patch Released Today
I asked: What workarounds, if any, can be used instead of applying the patch? Adam Berry said: There is not a work around other than the patch, which is why we released it. This kind of blanket statement is hard to accept. What if IIS security has been used to only allow connections from certain IPs, or IIS requires authentication? Would that take care of it (assuming the people I'm trusting by these means are actually trustworthy)? Martin Herbener Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Important ColdFusion Security Patch Released Today
Adam Berry said: The security bulletin explains the potential impact of the security issues. Since these issues were discovered through an internal audit, we decided not to publish explicit instructions for how to exploit the issues. I'd like a more detailed explanation of the impact. Does the flaw allow an attacker to take actions using the security context the webserver runs in, or the one CF Server runs in? I personally don't allow CF Server to run as System, and the userid it gets has limited rights, so even if an attacker can run code using CF Server's process id the attacker can't change (very many) files. If the attacker can only run code in the webserver context, the effect depends on the webserver; IIS has to run as system, but Apache can run with very limited update rights, so there might not be much damage possible. Martin Herbener Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: general question about security and documents
A classic approach would be to put these documents in a place that is not accessible to the public and use CFCONTENT to feed them to the (authorized) user when needed. -Original Message- From: Chris Alvarado [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 10:50 AM To: CF-Talk Subject: general question about security and documents I have an application that uses standard security through session variables etc. If a user navigates to a portion of the application where a document is attached (word, excel, etc) and they have the correct permissions then they will see a link that will allow them to view the file. this is all fairly normal however, technically if they knew the direct path to the file they could merely type in the path into their browser and in a sense bypass all of the security measures built into the application. has anyone come across this issue? I work for a company that is very concerned about security as im sure many of you do. Many of these documents contain sensitive information that should be view by authorized users. Thanks for any and all help, -chris.alvarado ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying a large database
I would not allow the user to wildcard at the start of the names, and require at least one letter of each name. Any good database engine should do fine with those restrictions. -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 8:29 AM To: CF-Talk Subject: Querying a large database Hey Everyone, I have a quick question about querying a database with over 600 thousand entries. The user has the ability to search by a name they type in. Now when they click search I need to query two fields from this table to find the name. Both fields in SQL are indexed. I need some ideas that will not kill our server while someone is performing a search. Remember that the user will be able to type in any part of a name, does not need to be the whole name. Wildcard characters are used like this %#name#%. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Xmailer change doesn't help!
This looks to me as if the SMTP server that the CF server is trying to use is not configured to relay mail. Have you talked to the administrator of the SMTP server? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 11:38 AM To: CF-Talk Subject: Xmailer change doesn't help! I'm trying to send CFMAIL to yahoo using one of the following ways: 1. cfmail to=#a[i]# from=#AUTH.userEMAIL# subject=Surprise From VAMP type=HTML mailerid=Internet Mail Service (5.5.2650.21) 2.cfmailparam name=X-Mailer value=(Microsoft Exchange Internet Mail Service Version 5.5.2650.21) and both throws out: Error,TID=1128,06/11/01,09:23:45,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\1CFA.cfmail. SMTP server replied not local host yahoo.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\1CFB.cfmail. I've tried EVERYTHING that was on the archive, can someone help? Thanks, Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cursors in stored proc
I think CF_SQL_REFCURSOR may only work with Oracle. An MS SQL Server SP can return (multiple) result sets like this create procedure myprocedure as select * from firsttable select * from secondtable end then you use matching CFPROCRESULT subtags. -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 4:15 PM To: CF-Talk Subject: Cursors in stored proc I receive at type mismatch error: Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: char is incompatible with cursor when I call a stored proc which returns a result set: The offending code is: cfstoredproc datasource=#request.ds# procedure=usp_attribute_values cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=Attribute_ID null=Yes cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR variable=qout dbvarname=attcursor null=Yes cfprocresult name=q2 /cfstoredproc and the declaration of the stored proc is: CREATE PROCEDURE usp_attribute_values @attribute_id int, @attcursor cursor varying out AS Environment SQL Server 2000, Win2K, CF 4.52 What am I missing here? TIA Don Vawter - Original Message - From: Chad McCue [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 12:29 PM Subject: Finding out when a application has been timed out. My problem is I can't allow more than two people logged in to my admin section at once. The problem I am having is when the session times out, I need to somehow go into the database and change my field that says someone is logged in. Right now it works fine if the user logs himself out of the admin section. Any ideas would be great. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which SQL ODBC Login method?
If on a shared server, and the server is not set up to use sandboxes to keep different users from using each other's datasources, then putting the userid/pwd in your .cfm files will better protect you from other users of the server (assuming CFFILE is turned off). If sandboxes are in place, I think CF Admin would be safer. To protect yourself from general outsiders I think CF Admin is better; there are more bugs that reveal .cfm soruce code than bugs that allow outsiders to put files on the server. Unsafe inputs (a user appending a malicious query to a URL) will work (or not work) irrespective of where the userid/password is kept. If you do choose to put the userids/passwords in your templates, you might consider moving all CFQUERYs into include files and storing the include files somewhere that's not web-accessible to reduce the outsider risk. Assuming the server admin can give you such a place. Spoken as someone who has never used a shared server and therefore probably isn't qualified... Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:27 AM To: CF-Talk Subject: Which SQL ODBC Login method? Hi all. What do you all recommend? 1. Adding the SQL Login to the CF Administrator ODBC Setup? or 2. Leaving it blank and hard coding it into cfquery? Seems as though hard coding it would be safer since no one else on the server would be able to query it without the username and password. Of course then if someone hacks into your ftp directory ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WhoIs tag that returns a variable
You could use wrap one of these text-emitting tags inside a module and use the generatedcontent attribute to catch the emitted text and put it in a variable. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 11:39 AM To: CF-Talk Subject: RE: WhoIs tag that returns a variable I did. It seems all these tags do is return the results into the HTML stream. If any of the authors of these are here and are willing to share the source, I can modify the CFX to meet our needs. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 09:44 To: CF-Talk Subject: RE: WhoIs tag that returns a variable try one of these? http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywo rds=whois -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 7:22 AM To: CF-Talk Subject: WhoIs tag that returns a variable Hey all, I need a free WhoIs tag that will return the results as a variable, not as part of the HTML page. I looked at Lewis Sellars CFX_TCPIPClient tag and thought it was too complicated for what I need. The existing CFX_WhoIs by Distributed Data System is perfect, except it doesn't return the results as a variable. As an alternative, if someone who has written on that returns the HTML stream can provide the source, I can modify it myself to return a variable. TIA. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle 8i and CFSTOREDPROC
Try CFSTOREDPROC procedure=WebInterface.IsBaseCaseComplete and the rest as you have it. -Original Message- From: Andrew Middleton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 9:17 AM To: CF-Talk Subject: Oracle 8i and CFSTOREDPROC I have a problem trying to call a stored procedure in Oracle 8i using CFSTOREDPROC. My code for the sp is below (followed by my cf code): CREATE OR REPLACE PACKAGE WebInterface AS PROCEDURE IsBaseCaseComplete (p_CaseID IN NUMBER, p_Complete OUT VARCHAR2); PRAGMA RESTRICT_REFERENCES (IsBaseCaseComplete, WNDS); PRAGMA RESTRICT_REFERENCES (WebInterface, WNDS, WNPS, RNDS, RNPS); END WebInterface; / CREATE OR REPLACE PACKAGE BODY WebInterface AS NegAnswer VARCHAR2(3) := 'no'; PosAnswer VARCHAR2(3) := 'yes'; PROCEDURE IsBaseCaseComplete (p_CaseID IN NUMBER, p_Complete OUT VARCHAR2) IS ReturnCase NUMBER := 0; BEGIN p_Complete := PosAnswer; SELECT Ca.CaseID INTO ReturnCase FROM dla.Synopsis, dla.Offender, dla.Offense, DLA.CASE ca WHERE Synopsis.CaseID = Ca.CaseID ANDOffense.OffenseID LIKE Ca.CaseID || '__' ANDOffender.OffenderID LIKE Ca.CaseID || '__' ANDCa.CaseID = p_CaseID ANDrownum 2; IF SQL%NOTFOUND THEN p_Complete := NegAnswer; END IF; -- SQL%NOTFOUND EXCEPTION WHEN OTHERS THEN p_Complete := NegAnswer; END IsBaseCaseComplete; END WebInterface; / And here is the cf code: CFSTOREDPROC procedure=WebInterface datasource=#request.DATASOURCE# username=#Client.Username# password=#Client.Password# CFPROCPARAM cfsqltype=CF_SQL_NUMERIC type=In value=#attributes.caseid# CFPROCPARAM cfsqltype=CF_SQL_VARCHAR type=Out variable=isitok /CFSTOREDPROC The only descriptive errors I have managed to get (by commenting the 2nd procparam) are that either the input variable is not of the right precision (but adding TO_NUMBER function doesn't fix it) or that the procedure is undefined. What is weird is that I also have code to test this in SQL Plus and I don't get any errors when trying to pass in the caseid, it returns the output variable(yes/no) just fine. Here is the test sp code: VARIABLE ret_val VARCHAR2(20); BEGIN WebInterface.IsBaseCaseComplete(20010005, :ret_val); END; / PRINT :ret_val; This is a brain bust for me at this point, I am not a PL/SQL guru and it's the first time I have used this tag with Oracle (SQL 7 is no prob for me). Any help would be greatly appreciated. Andrew = Andrew Middleton Consistency is contrary to nature, contrary to life. The only completely consistent people are the dead. --Aldous Huxley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: [Re: Native Drivers - Oracle80]]
Remember that each database can have multiple schemas; a schema is really just a set of tables (and indexes, triggers, etc) that belong to a user. But if you've got user A who owns schema B in database XYZ, and your application needs access to the tables in schema B, then you can use user A's userid and password in CF admin for that datasource. You can also, if you like, create another user C and give that user whatever rights are needed to the tables (indexes, etc) in schema A. clear as mud, eh? -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 6:09 PM To: CF-Talk Subject: Re: [RE: [Re: Native Drivers - Oracle80]] Thank you so much for your assistance. I finally make it work. One more question if I can. If I create a user A who owns the schema of XYZ database with a password. Should I put user A for CF Login? Please advise. Salute, Julia Phu [EMAIL PROTECTED] wrote: First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the service name is what you will put in the host string spot in CF Admin. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Report Solution (long)--My shared experience
I haven't done anything like this but may have to soon. Question: is there anything stopping a user from creating an html page on their desktop with a form that posts to the report server ASP page, just like your action page does? If not, it appears that anyone could run any report if they can figure out what to put in the form fields. Or is there a step I missed? -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:49 AM To: CF-Talk Subject: Report Solution (long)--My shared experience Okay, all. I just spent 4 days tearing my hair out trying to figure out how to pass CF variables to a Crystal Report(8) (while hiding the db userid and password). I searched the archives and the Allaire site and noticed that many other people have been gnashing their teeth over the same topic, so I thought I would share our solution. It's not pretty, and I'm not looking forward to supporting it, but it will . ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Deep Into Oracle 8.0.5
In CF Admin for a particular datasource there is a setting maintain database connections and another setting Connection timeout. If you check maintain database connections, then CF will keep a connection to the database open for as long as connection timeout after its last use. So if you have page1.cfm and page2.cfm, both accessing the datasource MyOracle, and a user runs page1 and a few minutes later runs page2, the CF server will reuse the connection it made to run queries for page1 in order to run queries for page2. If connection timeout minutes pass with no use of a given connection the CF server will close that connection. Make sense? -Original Message- From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 1:52 PM To: CF-Talk Subject: Deep Into Oracle 8.0.5 I am deeper into Oracle 8.0.5 than I wish to be...but I know someone here can help me. Currently, I have an application that connects to Oracle using Native Drivers. Recently, I have noticed that when I view Oracle Sessions (using Oracle Tools, Instance Manager), when I close my browser session, the Oracle connection that was opened by ColdFusion remains INACTIVE for an hour or more. Does anyone know how to kill the Oracle SessionID that is created when a user logs out of a ColdFusion application? I am using Coldfusion 4.5 SP2, Windows 2K SP1, with Oracle 8.0.5 on a different box. Hopefully, those of you who can help me understand my question. I don't know how else to word it. Thanks In Advance, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Instantiate environment?????? Whats that?
I just dealt with this. It seems to really mean there is something wrong and ColdFusion can't figure out exactly what. In my case a combination of upgrading database drivers and fixing up CFLOCKS seem to have resolved it. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 12:16 AM To: CF-Talk Subject: Instantiate environment?? Whats that? What does this error message mean? I'm using an access database as an interim measure with this project. The CFQUERY mentioned hasn't got anything special in it .. this page is copied from another site that works fine with identical setup - only the data itself is different. So I don't think it's a code error. (but then again I've been known to be wrong before. 1975 I think it was) Here's the error message: [quote] Error Diagnostic Information ODBC Error Code = () Unable to instantiate environment for 'ODBC.' The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:2) to (1:49). Date/Time: 05/17/01 00:08:46 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt) [end quote] And who thought up that word instantiate??? Do they really mean initiate? Initialise? Cheers, Mike Kear AFP Webworks Windsor, NSW, Australia Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle error ORA-24334
Has anyone else seen an Oracle error ORA-24334 no descriptor for this position ? I'm getting it very rarely with a query that generally works ok. CF 4.51 SP2, oracle client 8.1.6, Oracle server 8.0.4.4. Martin Herbener Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Challenge!
You can convert your CF tree-walking code to stored procedures, which helps with performance - I've written implementations for both MS SQL Server and Oracle if you want them. Or you can try Joe Celko's nested set approach (http://www.intelligententerprise.com/001020/celko.shtml) which I've always thought looked cool but haven't had a chance to try. Shall I email you my Swiss bank account numbers directly? :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 10:30 AM To: CF-Talk Subject: Database Design Challenge! If anyone can solve this one, I'll give you a million bucks. Or maybe not, but I'll certainly be impressed... Let's say, for instance, I'm storing data about a family tree. Every person has a record in the People table. Every person has a Mother and a Father, linked with their unique ID. Now the challenge: How can I create the list of all male ancestors, all the way back to the root level (i.e. Adam Eve)? I've managed to do this with a CFLOOP that keeps running a query, going up the tree, until the FatherID is zero, but this is expensive on the database end. For the record, I'm not actually keeping track of people all the way back to Adam Eve, but this is the best way to explain this database design issue. Thank you very much! Norman Elton Jefferson Labs ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTRANSACTION
Yes, as written this use of CFTRANSACTION is purpose-free. But if the developer wants to roll back the transaction if the structupdate fails, I think CFTRY/CFCATCH and CFTRANSACTION type=rollback could be useful. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 11:08 AM To: CF-Talk Subject: CFTRANSACTION There's this code in an application... CFTRANSACTION CFX_Something... CFQUERY... INSERT INTO... /CFQUERY CFSCRIPT StructUpdate(..., ..., ...); /CFSCRIPT /CFTRANSACTION Is there any point in having the CFTRANSACTION? I thought CFTRANSACTION only affected database queries. If the CFX failed, it wouldn't get to the CFQUERY. And if the CFSCRIPT failed, it would have already done the INSERT anyway, even with the CFTRANSACTION... yes? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 4.5/5.0 ORACLE stored procedures - how to cache results? ?
Two ways I can think of in 4.5x: 1) Keep the results on a per-user basis in session variables 2) Write a custom tag wrapper for CFSTOREDPROC that mimics CFQUERY's caching abilities. -Original Message- From: Darren Nickerson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:10 PM To: CF-Talk Subject: CF 4.5/5.0 ORACLE stored procedures - how to cache results?? Folks, A key aspect of our site is a search function that allows users to specify criteria in several categories for a DSS-type query against the database. Since use of this feature is expected to be heavy, response time is critical. To optimize performance, we've designed this section to dynamically generate the SQL based on the user's selection. By dynamically generating the SQL, we can eliminate unneeded joins and tailor the criteria for faster throughput. To further improvement performance, we've designed the module that generates the SQL as an Oracle stored procedure that is called from the search page within a CFSTOREDPROC tag. To return multiple rows back to ColdFusion, we use an Oracle REF CURSOR from the stored procedure. While the stored procedure call from the CFSTOREDPROC tag works, we need the ability to cache large result sets (to allow paging through results) in the same way that the CFQUERY tag provides caching through the CACHEWITHIN option. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Re: Native Drivers - Oracle80]
First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the service name is what you will put in the host string spot in CF Admin. -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 12:14 AM To: CF-Talk Subject: Re: [Re: Native Drivers - Oracle80] ... you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also Yes, I had Oracle 8 client software installed and have created a service name, ABC. On the CF Settings page: DSN: ABC Host String: 127.0.0.1:1521 ColdFusion Login: ABCowner/** I created ABCowner NT user account with Admin right. What else did I miss? Regards, Julia Phu Tom Davison [EMAIL PROTECTED] wrote: did you install the oracle 8 client software on the server? when you do you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 4:26 PM Subject: Native Drivers - Oracle80 Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Are the data soruces setting configured properly? --- I believed I did --- * Did you provide valid security information in the data source settings? --- Honestly, I'm not quite sure what it means. --- * For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Window NT Services Control Panel to change the account the ColdFusion Server service is using. --- Again, I believed I did what it said. --- On the Oracle house, I have one sid with 2 instances. I need a connection to instance2. I'm stumbled on this problem for two days and couldn't find any material or expertise of the failure. Your enlightenment is greatly appreciated. Salute, Julia Phu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: structure in request scope
A request scope variable must be re-set for each page load - that's how request variables work. You could do this cfquery name=request.colorscheme datasource= cachedwithin=some_time_period /cfquery which would run this query at the internal indicated by the cachedwithin attribute; if between query runs the CF server would just look at the most recent query results and put those in the request variable. -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 2:00 AM To: CF-Talk Subject: structure in request scope Could someone tell me how to load a structure into the request scope in the application.cfm once only when a user first visits a page. That is, check that the structure is there and dont rerun the query code if it is unless a change has been made to the database. Its for the colour scheme of a site. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
Bit masks are cool, but remember that there is a limit to how much info you can pack in a bitmask because CF doesn't let you use the bit functions on anything of more than 32 bits. I have taken to using lists for this sort of thing because there's no practical limit to how many items it can contain and there are lots of useful list functions in CF. -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 4:54 PM To: CF-Talk Subject: Bit Masks Hello! I believe that someone once gave a presentation at one of the CFUGs about using bit masks, also know as Right Bit AND, to set up security access levels. This wasn't the same as the presentation at the Fig Leaf site that's slight more oriented towards hierarchy uses. I've looked at all the CFUG sites linked to from the Allaire site but I can't find the presentation. Does anyone recall where the presentation was made and/or how to get the presentation file? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Internal Server Error
There is 4.0x info here: http://www.defusion.com/articles/index.cfm?ArticleID=89 if you have corrections/updates to offer I'd love to see them. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:08 PM To: CF-Talk Subject: Re: Internal Server Error Internal server error sometimes means that the permissions are messed up. Try allowing everyone full access to the page, and try again, then work backwards and see how high you can set the permissions and still have it work.. Does anyone know what permissions have to be set for cf to work? Al a1webs.com At 07:54 AM 5/10/2001 -0700, Bernd VanSkiver wrote: We just set up a Windows 2000 Advanced Server with ColdFusion 4.5.1 SP2 and cannot get any cfm files to work, it always gives me an Error 500 - Internal Server Error. Does this for asp pages also. I did not set up the machine, so figure the guy that did messed with some setting to mess this up, I have set up computers with similar configurations and have never had this problem before. Any ideas why this is happening? I cannot find any setting that fixes this problem. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bit Masks
Well, you're not limited to 5 levels, but rather 31; if you feel confident that will be enough then you're set. Your second approach works IF you can always assume that all the security levels are either lesser or greater than the new one you want to add, never equal. But if you need to have two security levels, one with rights to read pages about accounting projects (but not construction projects) and the other with rights to read pages about construction projects (but not accounting projects), which gets the higher number? -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:13 PM To: CF-Talk Subject: RE: Bit Masks Thanks for the list tip! I'm just now developing an application using CF's BitAnd() function. In my application, I currently have the following permission levels: Level UserDescription Permission DB value for BitAnd 1 1 Public - future permission level READ selected pages 2 3 Basic Project Read User Read all pages 4 7 Basic Project Content User Read all, Add/Update selected data 8 15 Project Manager User Read all, Add/Update all 16 31 me ;-) Since a User with a larger permission value must also have the access all Users with lesser permission values do, CF's BitAnd enables only 5 permission levels. I'm concerned the client might come up with additional permission levels/groups in the future, thereby defeating my use of BitAnd, and forcing me to modify code/user database/client database to use a list instead of BitAnd. Or have I missed a clever way to use BitAnd? best, paul PS It sure helps to ask for help;-) Now that I've done so, I think the simple solution to my problem is not to use BitAnd, but just adopt a sequence of increasing numbers, for example: 5, 10, 15, 20, 25, etc (go by 5's to allow future insertion of new intermediate permission levels), and verify a User's permission is greater than a target. That way, I still only need to store a single number in the database as with BitAnd, and don't need to go to using a list. Any comments? At 10:48 AM 5/10/01 -0400, you wrote: Bit masks are cool, but remember that there is a limit to how much info you can pack in a bitmask because CF doesn't let you use the bit functions on anything of more than 32 bits. I have taken to using lists for this sort of thing because there's no practical limit to how many items it can contain and there are lots of useful list functions in CF. -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 4:54 PM To: CF-Talk Subject: Bit Masks Hello! I believe that someone once gave a presentation at one of the CFUGs about using bit masks, also know as Right Bit AND, to set up security access levels. This wasn't the same as the presentation at the Fig Leaf site that's slight more oriented towards hierarchy uses. I've looked at all the CFUG sites linked to from the Allaire site but I can't find the presentation. Does anyone recall where the presentation was made and/or how to get the presentation file? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: VSS versioning
As far as I can tell, VSS does not have very good reporting capabilities. It is possible to declare a project version (VSS calls this a label), and you can examine an individual file's history to see the labels and associated file versions, and you can do a get to get all the files with a specific label attached, but I've never seen a report of the file versions that go with a label. VSS is a good example of the Microsoft way in a new (to them) market - put out a product (usually purchased elsewhere) that does just enough and make it fairly easy to use. With VSS they've never followed up (as they sometimes do) with new versions that have more advanced functionality. So is anyone using any other source control system that integrates with Studio 4.5? -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Monday, May 07, 2001 12:14 AM To: CF-Talk Subject: FW: OT: VSS versioning I'm reposting this. Anyone use Visual SourceSafe (VSS) for more than just check-in/check-out? -David -Original Message- From: David Shadovitz [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 8:15 PM To: 'CF-Talk' Subject:OT: VSS versioning Our network administrator finally installed VSS, and I've successfully hooked it into my existing CF Studio projects. But VSS looks pretty limited compared to what I've used on UNIX systems. (Heck, CMS on the VAX beats it.) I expect a source control tool to tell me which version of which files were in a given release of my software. For example: Project ABC v1.4 = page1.cfm v2 page2.cfm v5 page3.cfm v1 Project ABC v1.5 = page1.cfm v2 page2.cfm v6 page3.cfm v4 page4.cfm v1 Can VSS do this? I'd greatly appreciate any help. The on-line help and MSDN don't offer much, and I see no books out there. Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spell Checking??
1) In our case, we figured out that cfx_spell was not thread safe by deploying it and watching CF crash under load :-(. I think you need to have some decent C/C++ knowledge and access to the source to be able to be sure in advance. 2) You need to lock them if you need to lock them; that is, depends on the tag and the situation. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 10:41 AM To: CF-Talk Subject: RE: Spell Checking?? 2 Questions 1. How do you know if a cfx tag is thread safe 2. Do you need to lock cfx tags? Cheers KOla -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 04 May 2001 14:06 To: CF-Talk Subject: RE: Spell Checking?? I have a customer who is insisting upon having a built-in spell checker in an application I'm currently writing. The only application I can find seems to be Ben's CFX_Spell. While I admire Ben, it is a 1.0 application that was developed 4 years ago. Did he write the perfect application which needs no updates? Has anyone had any experience with CFX_Spell or have you incorporated any other spell checking system into a CF application? We've used CFX_Spell, and it's not thread-safe, so you'll need to lock it with a named exclusive CFLOCK. Other than that, it's fine, as long as you don't need to have everybody running it at once. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
locking sessions in 4.0 and 4.5 compatible way
I really did search for this, but didn't find an answer. I'm moving from CF 4 to 4.5, and have turned on Automatic Read Locking in all scopes. Now I'm going through to see what's broken as a result. Note that I'm trying to maintain compatibility with 4.0 as much as possible. I found a section of code like this cflock name=#Cookie.CFID##Cookie.CFTOKEN# type=exclusive timeout=30 throwontimeout=yes ... some other code, but no cflocks of any kind... cfset session.userid = blah /cflock which, when run, generates the following error: Symbol session.userid is in a scope that contains data shared across threads and cannot be accessed without an active lock Now, if I do this: cflock name=#Cookie.CFID##Cookie.CFTOKEN# type=exclusive timeout=30 throwontimeout=yes ... some other code, but no cflocks of any kind... cflock scope=session type=exclusive timeout=5 cfset session.userid = blah /cflock /cflock it works fine, but of course CF 4 won't accept that. Is there any way to make CF understand that the first lock is protecting that session scope? Martin Herbener Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT - SQL server memory usage
You can configure SQL Server (my knowledge is based on 6.5) to use a certain amount of memory, and it will pretty much use that whether it needs it or not. If you think it would be ok with less, you can adjust setting and restart it. -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 11:01 AM To: CF-Talk Subject: OT - SQL server memory usage My SQL server on NT4 uses almost 20MB of the server memory all the time. I am wondering if there is something wrong. Is this normal? There is an CF application that uses a database, that's frequently used all day, but it's not used that much except that. I am not using any of the stored procedure stuff to access the database for that application. Could it bring up the performance and/or bring down memory usage? Thanks for your help! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 189,000K memory use - Way too high for CFAS 4.5.1?
That seems pretty reasonable to me. My servers run at between 120 and 150 MB of "committed bytes" (from perfmon). -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 9:53 AM To: CF-Talk Subject: 189,000K memory use - Way too high for CFAS 4.5.1? My memory useage for CFAS 4.5.1. SP2 slowly creeps up to about 189,000K (per NT Server 4.0, SP6a Task Manager reading) and levels out there. I know that the SmartHeap function in CFAS is not releasing memory back to the system on the notion that CFAS will need it again. But I am wondering if 189,000K is abnormally high? Should I look at my applications to see if there is something causing excessive memory use or is this within reasonable bounds? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Transferring 1-3Kb data
I think ftp would be a good fit. You could set up multiple ftp servers and use DNS round-robin or some sort of load-balancing if you really need to, but just now I connected to ftp.freebsd.org and saw "There are currently 1334 users out of 5000 possible" so I don't really think scalability is likely to be an issue (assuming the right OS and hardware). In addition, ftp is well-understood and relatively easy to use. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 5:33 AM To: CF-Talk Subject: Re: Transferring 1-3Kb data Please someone help out. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 5:24 PM Subject: Transferring 1-3Kb data We devloped a client program (in visual c++) that stores log files for usage in the client and its features. I need the best way to deliver those small log files (no more then 2Kb for a full week of usage) to our CF production server and then, to zip those files and send them daily to our development server. I will definitly manage the 2 tasks of zipping and transferring the log files but what is the best way to create/get them from the client? I though about 2 alternatives: 1. open a ftp connection to upload the file weekly by each client. 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not sclable enough, any help would be appriciated! Thanks, Michael Lugassy Interactive Music Ltd http://www.imvamp.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Test Environment for Forta's Book
You could download the eval if you have the hardware: http://www.microsoft.com/exchange/productinfo/Eval.htm -Original Message- From: Dain Anderson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 11:27 AM To: CF-Talk Subject: OT: Test Environment for Forta's Book Greetings, I'm writing to ask if anyone has an Exchange Server running LDAP (or test server w/Exchange) that I could use for testing. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
If it will always be exactly one character, instead of wildcards I would do select blah fromblahtable where left(lastname, 1) in (#listqualify(form.selectbox_of_letters, "'")#) you might have to use something other than left(lastname, 1) if your database uses a different function for that. Be sure to test with the max number of letters as some DBs don't allow an IN list to be longer than some magic number -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 11:25 AM To: CF-Talk Subject: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHEADER questions
I'm not sure what you mean by stopping the output. Do you mean that you might start working through a query (or something) and then find that you don't want to send the data to the user after all? If so, you could first put all the data to download into a variable, then only do the CFCONTENT if you've decided the data are ok. I've used this sort of approach to create RTF files to download to the browser before; I wouldn't call it easy but it's certainly possible. More info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:21 AM To: CF-Talk Subject: CFHEADER questions I have some code on my page using CFHEADER and CFCONTENT that allows the download of a CFOUTPUT to a text file. Is there anything I can use on that page, aside from a CFLOCATION or CFABORT to stop the output of the server to the text file? Also, is there an easy way to create an RTF or Word doc on the fly using this method? tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHEADER questions
That is a pain. As I said, I generally put everything into a variable and then send that, but you still have to be careful about whitespace. There's no magic way to say "CFCONTENT only up to this point" that I know of. -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:30 PM To: CF-Talk Subject: Re: CFHEADER questions Thanks for that link. Very informative. As to the other question: I was mainly interested in it from a practical point of view. When I insert the code on the page from a snippet, I always have to make sure that there isn't any whitespace, closing /body or /html tags, or any other tags after it, or they end up in the file. I just want to make sure the output gets cut off immediately. tom [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm not sure what you mean by stopping the output. Do you mean that you might start working through a query (or something) and then find that you don't want to send the data to the user after all? If so, you could first put all the data to download into a variable, then only do the CFCONTENT if you've decided the data are ok. I've used this sort of approach to create RTF files to download to the browser before; I wouldn't call it easy but it's certainly possible. More info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:21 AM To: CF-Talk Subject: CFHEADER questions I have some code on my page using CFHEADER and CFCONTENT that allows the download of a CFOUTPUT to a text file. Is there anything I can use on that page, aside from a CFLOCATION or CFABORT to stop the output of the server to the text file? Also, is there an easy way to create an RTF or Word doc on the fly using this method? tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
How do you know which number gets which format? Is there some clue in another db field, or is it based on how many digits after the decimal point, or what? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:55 PM To: CF-Talk Subject: RE: Numberformat question. I've been playing with a few different masks, but anytime I set up a decimal mask it's forcing all the places, so for example, if I have the mask set at ",9$99.", the numbers get formatted (using the examples I cited originally) $45.9000, $9.9900, $2.8950 and $0.4585. What I need is $45.90, $9.99, $2.985 and $0.4585. Hatton -Original Message- From: Tumy, Brad [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:27 PM To: CF-Talk Subject: RE: Numberformat question. can't you output like this: $#numberformat(number,mask)# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 11:36 AM To: CF-Talk Subject: Numberformat question. I have a situation where I need to display a price with either 2, 3 or 4 digits after the decimal place. The database is storing the information properly, but I need to format the display to "trim" the output. For example, I have three prices for four items: Item 1 has a price of 45.9 Item 2 has a price of 9.99 Item 3 has a price of 2.985 Item 4 has a price of 0.4585 I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since it trims at two decimal places. The question is, how do I set up the NumberFormat to show the pricing properly when possible top-ends are up to $999,999,999.? TIA Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 4.5 ent on Solaris
I don't know if there are solaris-specific issues. In CF 4.0x it was only possible to do this with ugly kludges. With CF 4.5x it can be done using the CFSTOREDPROC tag; it's only documented in the "new features in 4.5" file in an area titled "Oracle Reference Cursor Support". I've used the feature on NT 4 without problems. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:39 AM To: CF-Talk Subject: CF 4.5 ent on Solaris We have an application that will be running on CF 4.5 Enterprise on Solaris 2.6, against an Oracle 8i 8.15 database (also on Solaris). I'm told there will be an issue with Oracle returning recordsets using stored procedures in CF. Evidently the cursor type specified by CF in the connection is incompatible with Oracle stored procs. Does anyone have any information on this issue? I need to make some decisions before we create the development environment, etc. Thanks in advance, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Includes on HtML?
You can CFINCLUDE a file with any extension. -Original Message- From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 12:21 PM To: CF-Talk Subject: Includes on HtML? Hi All, Another question. Can you cfinclude from *.htm *.html based files? I want to be able to include a hit counter on some of our pages but not by not having them changed to .cfm. Thanks, Dayv ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Includes on HtML?
Right, I misread the the question. If the hit counter generates an image, you can use the same trick that many public hit counters do (for the benefit of geocities-type sites), which is to put an img src="" in the html file that points to a CF template. The CF template would then have to generate and CFCONTENT an image. -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 2:28 PM To: CF-Talk Subject: RE: Includes on HtML? But the question was "can I cfinclude a file from a page with the extension .htm or .html?" The answer is no. There is file inclusion using server side includes, which is actually how it is done in ASP. The thing to keep in mind is that 'includes' are synonymous with 'inline functions' as in C programming. The code just gets pasted to the current 'page'. So, if you could include a .cfm file within a ...html file, the CFML would not get processed unless you told your Web Server to run all .html files through your ColdFusion App Server, something that is usually not recomended. Check out Allaire's site. There are some diagrams there on the interactions betwix web server, cold fusion app server, and browser. Ask yourself 'What actually happens when I enter a URL and hit enter from my favourite browser?'. I think your stuck changing your files to .cfm files. opinions? DK From: [EMAIL PROTECTED] AT INTERNET on 04/04/2001 01:20 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: Includes on HtML? You can CFINCLUDE a file with any extension. -Original Message- From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 12:21 PM To: CF-Talk Subject: Includes on HtML? Hi All, Another question. Can you cfinclude from *.htm *.html based files? I want to be able to include a hit counter on some of our pages but not by not having them changed to .cfm. Thanks, Dayv ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Efficiency Question
FYI - On NT, one of the perfmon stats within the Cold Fusion object is 'Cache Pops/Sec'; if this is anything other than zero, your template cache size is not big enough and CF is kicking templates out of cache to make room for new ones. The performance penalty this causes is significant... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 12:46 PM To: CF-Talk Subject: RE: Efficiency Question Rule of thumb on template cache size - double the size of all of your templates... this give CF room for maneuvering and it should never have to remove items from cache You might need more than that - the Allaire recommendations have gone from 3x file size to 5x! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with CFFILE (sort of)
Put the user in the local administrators group. Or, see a breakdown of the actual rights needed here: http://www.defusion.com/articles/index.cfm?ArticleID=89 -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:22 AM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) OK I can't seem to restart cold fusion as anything other than the local system account. I have created a new user which is part of Domain users and Users but when I try to start Cold Fusion I get an "Internal NT error" number 2140 "Unable to start ColdFusion Service" -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:45 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) IS Coldfusion logged on as a user account or as system - it needs to be logged on as a user to access files over the network. session management etc is on a domain basis 200.200.200.200 is a different domain to www.myserver.com even if they happed to be exactly the same location... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:38 To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are
RE: Serving to the web using W2K, IIS and DSL
Are the applications she's creating Web-based, or are they "native" Windows applications like those built with VB or suchlike? If they're native (not designed to work with a browser) she may need to set up Windows Terminal Services to give coworkers a way to access the apps. -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 7:54 AM To: CF-Talk Subject: WOT: Serving to the web using W2K, IIS and DSL Sorry for the off-topic post. I have a co-worker halfway across the nation who is building some GIS applications using ARC IMS. She's running a W2K machine, IIS and has a DSL connection to the web. Can she serve her own applications to the web so the rest of the team can see what she's doing? A point in the right direction would be much appreciated! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE: CF 4.X and W2K questions
I don't see why you'd need two licenses. Essentially you're putting two websites on the same machine, which anyone who does hosting does routinely. I am lucky enough to have a second server for development, and actually have two sites on it - one for development and another for testers (so the code isn't changing while they're testing). I haven't generally had much use for the root dirs that are set in CF admin and routinely ignore that whole part of the administrator. The one issue I see with two sites hosting the same code on the same machine is the name you assign applications in the CFAPPLICATION tag (assuming you use it); while transferring code to the test system I change that name to name_test so the app variables don't get crossed up. I do suggest that you revisit the production development on the same box one more time. CF Server really can run (though not fast) on some pretty crappy hardware - we used to have it on a IBM pentium 166 desktop with maybe 64 MB of RAM, and my current development server is a 1 yr old Deskpro. Surely someone somewhere in your outfit is getting a new workstation and can donate the old one. -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 8:47 AM To: CF-Talk Subject: UPDATE: CF 4.X and W2K questions Okay, I finally found the answer to my first question. In an Allaire Knowledgebase blurb, it definitively states that we CANNOT use CF 4.0 on W2K: http://www.allaire.com/Handlers/index.cfm?ID=19534Method=Full However, I still have my dual environment/licensing question... Thanks! T Original Message Follows From: "Terri Stocke" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: REPOST: CF 4.X and W2K questions Date: Fri, 23 Feb 2001 12:35:33 - Hey all, I have several questions regarding an upcoming migration from Win NT 4.0/CF 4.0 to W2K/CF 4.5. First of all, I noticed that on Allaire's site, it does show that the system req for CF 4.5 is Win NT 4.0. However, I recall seeing some posts and/or info elsewhere (that I unfortunately can't find) alluding to an incompatability between CF 4.0 on W2K. Is this correct, and if so, what are the issues? Secondly, we only have one machine at our disposal from which to run both development and production (I know, it's not a recommended scenario, but we've been hit with those good ol' automotive industry budget cuts ;) Anyway, we want to have these dual environments on the ONE machine, but with different directory structures. For example, production might point to "info.ourinternalserver.com" and development might point to "dev.ourinternalserver.com". We really want to avoid having the development area as a subdirectory of production. I know that CF 4.0 admin only allows you to define one root directory. Will 4.5 now support what we are trying to do? Can we get away with one license, or will we need two? One of the corp resellers told me that he believes we would need two licenses for this scenario, because we are essentially running two different environments. So even though it is technically one machine, we are using it for dual purposes (dev and prod). Has anyone else tried this? All info is greatly appreciated! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
which cfwr8040 to use?
This article (http://www.allaire.com/Handlers/index.cfm?ID=15885Method=Full) describes an updated CFWR8040.dll file that corrects a memory leak when using an Oracle native data source as a client variable repository. It's not clear to me if this update should be applied to CF 4.51 SP2 or only to CF 4.51; does anyone know? Both DLLs (the one that you have if you've updated to 4.51 SP2 and the one ref'd by the KB article) have internal version numbers of "4.5.0"... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Port?
No, sorry. According to http://www.isi.edu/in-notes/iana/assignments/port-numbers, the "Well-known" ports are 0-1023, the "registered" ports are 1024-49151, and the "dynamic/private" ports are 49152-65535, so logically it should be that last range. But I don't know if Oracle followed the rules. On a client NT machine currently connected to the DB you could run "netstat" at a command prompt and see what port it's using this time - do it a few times and you might see a pattern. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 5:35 PM To: CF-Talk Subject: RE: Oracle Port? Interesting. Would you know the range of ports needed given method 1? I opened 1500-1700 (due to references I found for 1521, 1526 and 1610) but am still having problems (TNS: unable to connect to destination) although it could be something else... This is actually an interesting problem. If you look in the TNSNAMES.ORA file on a machine that connects to the Oracle database you will see an entry for the database you care about with a "Port=" line; this port has to be open to the database. However, by default Oracle 8 on NT does something special: the client connects to the port named, and then the client and the server negotiate a new port on the database server to be used for all the real communication. So even if you open the named port, your client won't be able to query the database because it's trying to submit the query using a new port that not's open in the firewall. Your choices: 1) Teach the firewall to allow access to the DB server on any port 2) Get the firewall admin to install an Oracle-specific "SQL*Net Proxy" 3) Teach the database server not to renegotiate but just use the port identified in TNSNAMES.ORA for all activity. I've only used method 3. This involves something called "Shared Socket". You can search the Oracle Metalink support database for "Shared Socket" or document ID 124140.1, which describes how to do it. Enjoy! -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 2:17 PM To: CF-Talk Subject: Oracle Port? I'm setting up remote access to a db server behind a IP firewall. I need to know what ports to open to that machine so I can access the db from coldfusion. The db server is Oracle 8.0.5 on NT. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Port?
12203 can be a lot of things, unfortunately. You might check the oracle docs (/network.804/a58230/ch10.htm#428653) for instructions on turning on logging on the client. The log files are not real easy to read but can provide some clues. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:28 AM To: CF-Talk Subject: RE: Oracle Port? This sounds like a different problem. If your network engineer has a packet sniffer, I'd ask him to check out stuff from both sides of the firewall. There are three areas that could be a problem... Well I don't have a packet sniffer per se, but I do have a linux box over there on that network I can use... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Port?
This is actually an interesting problem. If you look in the TNSNAMES.ORA file on a machine that connects to the Oracle database you will see an entry for the database you care about with a "Port=" line; this port has to be open to the database. However, by default Oracle 8 on NT does something special: the client connects to the port named, and then the client and the server negotiate a new port on the database server to be used for all the real communication. So even if you open the named port, your client won't be able to query the database because it's trying to submit the query using a new port that not's open in the firewall. Your choices: 1) Teach the firewall to allow access to the DB server on any port 2) Get the firewall admin to install an Oracle-specific "SQL*Net Proxy" 3) Teach the database server not to renegotiate but just use the port identified in TNSNAMES.ORA for all activity. I've only used method 3. This involves something called "Shared Socket". You can search the Oracle Metalink support database for "Shared Socket" or document ID 124140.1, which describes how to do it. Enjoy! -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 2:17 PM To: CF-Talk Subject: Oracle Port? I'm setting up remote access to a db server behind a IP firewall. I need to know what ports to open to that machine so I can access the db from coldfusion. The db server is Oracle 8.0.5 on NT. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
You could generate a CSV file (comma-separated values) which Excel can open. Excel does have a relatively low (~ 250) limit on the number of columns that it will handle with a CSV file, and I've only created files with ~ 1000 rows. Anyway, CF + Unix tools can easily create a valid CSV file. -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:17 AM To: CF-Talk Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: User history..where are users coming from?
For your purposes this is probably fine, but readers should realize this is
not guaranteed effective; the browser can send whatever it wants as the
referer, and I think there are some "privacy-oriented" and other customized
browsers that don't send anything at all.
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 09, 2001 2:00 AM
To: CF-Talk
Subject: RE: User history..where are users coming from?
a... methinks thou art great, all who have helped me with this ponderous
dilemma.
T
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 9:04 PM
To: CF-Talk
Subject: Re: User history..where are users coming from?
If your site is www.site.com then you could do something like:
cfif findnocase("www.site.com",cgi.http_referer) is 0
cflocation url="www.site.com"
/cfif
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!
- Original Message -
From: "Tony Gruen" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 8:06 PM
Subject: User history..where are users coming from?
I have been searching past posts and our reference texts looking for this
but I cannot seem to find anything.
I want to be able to ensure that visitors to certain parts of our site are
actually arriving there by browsing our site. We have outside vendors
linking to product manuals and downloading them from their site. When this
happens I would like to bounce them to our home page and deter vendors
from
using our site to provide services to their customers. It is ok if someone
surfs our site and downloads the manuals.
We have considered using session variables but that would require
restructuring the existing site. I seem to remember a variable
http_referrer
but I can't find anything on it. Am I close? Any suggestions are
appreciated.
Thanks in advance,
Tony Gruen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Noting Seeing Network Drive Properly
If you want to use a non-Admin user, there is some info here that might help: http://www.defusion.com/articles/index.cfm?ArticleID=89 -Original Message- From: JayB [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 4:55 PM To: CF-Talk Subject: RE: CF Noting Seeing Network Drive Properly At 11:28 AM 1/29/2001 -0800, you wrote: Aaron: Thanks for the suggestion. Right now it's set up to log on as the "local system account" and "allow service to interact with desktop" is checked. For "This Account," If I try to add my account name and password, I get an error that says I don't exist ... so I'm guessing this is the wrong account to put here, but if so, I'm not sure what to put here. I asked this question a bunch of times on allaires forums getting vague answers but no real help... This is what I did to get this to get a mapped drive to workstep by step... Here's my set up win2k pro database on peer to peer lan with mapped drive x: CF Server 4.5.1 single user CFStudio 4.5.2 beta On machine where data resides, add a user called data_admin with administrator rights and give it a strong password(you might be able to have a lower permission level...but I couldn;t get it to work) On the machine where Server is running, log on as administrator Create a new user called data_admin with the same properties as that on the ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help needed with ODBC Excel datasource problems...
Random untested suggestion: Create an MS Access DB, attach/link the Excel spreadsheet, and see if Access correctly understands the column as character/string. If Access gets it right, create a CF datasource to the Access DB and query the attached table, hoping that Access' field data type will be the one the CF uses. -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 9:35 AM To: CF-Talk Subject: Help needed with ODBC Excel datasource problems... Hi all- Got a tricky one for ya. I have an Excel datasource that I need to import into an Access DB. I've been to www.cfcomet.com (excellent site, by the way...definitely visit for any issues with accessing MS Office Objects through CF) which gave me a start, but I've run into a problem I can't find addressed anywhere. ---snip --- Didn't work. :( I have one particular field which, in some cases: a) is blank, b) has a number in it, or c) has multiple numbers, separated by spaces (ie. 3 5 2) For whatever reason, CF is importing this field as a number, converting the 3 to 3.0, and dropping the rest of the field. This has me stymied, because ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: . in urls
Also, SP6A fixes this weakness of IIS (parsing the URL from right to left instead of left to right). -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 7:55 AM To: CF-Talk Subject: RE: "." in urls Have you tried escaping the '.' with urldecode() and urlencodedformat() ? Regards, Thomas C. Office: 01565 757 909 This space for rent -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: 25 January 2001 12:47 To: CF-Talk Subject: "." in urls My IIS insists on turning http://servername/index.cfm?art=MFW4.0 into a request for the file with name "MFW4" and extension ".0". There's probably something stupid I'm overlooking, but what? Any help appreciated, Michel Vuijlsteke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a query created from QueryNew()
custom tags; here's one: http://devex.allaire.com/developer/gallery/info.cfm?ID=44C48F77-35E9-11D4-83 D700508B94F85Amethod=Full and there are others. -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 12:20 PM To: CF-Talk Subject: Sorting a query created from QueryNew() Once I've created a dynamic query using QueryNew() that has four columns and many rows and populated it will all the data using QueryAddRow() and QuerySetCell(), is there any way to sort it (CF 4.5.1)? I don't see a QuerySort() function anywhere... Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: string to number
To somewhat answer part of this, in the past I've come to the conclusion
that IIF is slower than CFIF; I don't remember if that's based on my own
tests or someone else's reports. I still use IIF when it makes something
generally more readable, but not too often...
-Original Message-
From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 10:12 AM
To: CF-Talk
Subject: RE: string to number
Steve,
As long as you keep your ranges as you have them in your If statements, the
following formula should yield the correct result. I know this doesn't
address the question that you asked, but others have responded to that, and
I just couldn't help fiddling. Hope you don't mind.
CFSET Grp=("form.adult + form.children")
CFSET SmRmRq=0
!--- The \ in this formula is correct. ---
CFSET SmRmRq=Iif(Grp LTE 28,(Grp-1)\4+1,8)
Of course, this is harder to modify in the future, should one range change.
I'm also not sure whether it runs slower or faster. I am still not sure
whether my obsession with physically compact code runs counter to good
programming sense. I guess I should flip through a CS book!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Conditional loops
I think it would be possible, like
cfset mycounter = 1
cfloop condition="(isdefined("queryname") and mycounter LTE
queryname.recordcount) OR (mycounter LTE listlen(listname)"
cfoutput
cfif isdefined("queryname")
#queryname.fieldname[mycounter]#
cfelse
#listgetat(listname, mycounter)#
/cfif
cfset mycounter = mycounter + 1
/cfloop
but it might be easier to change the query to a list (ValueList function) or
the list to a query
(http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3471A5-2830-11D4-A
A9700508B94F380method=Full - custom tag) so you don't have to keep figuring
out what syntax you need.
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 10:06 AM
To: CF-Talk
Subject: RE: Conditional loops
I guess I should've been more clear about what I want to do.
CFIF isDefined("queryname")
CFLOOP query="Queryname"
CFELSE
CFLOOP index="x" list="listname"
/CFIF
I have gotten a suggestion to rewrite it as
CFIF isDefined("queryname")
CFSET count=queryname.recordcount
CFELSE
CFSET count=#ListLen(listname)#
/CFIF
CFLOOP from="0" to="#count#"
/cfloop
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 9:20 PM
To: CF-Talk
Subject: RE: Conditional loops
why don't you just use the CONDITION attribute of CFLOOP?
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 4:59 PM
To: CF-Talk
Subject: Re: Conditional loops
On 1/16/01, Ruslan Sivak penned:
Is there a way to have conditional loops such as
CFIF something
CFLOOP parameters1
CFELSE
CFLOOP parameters2
/CFIF
/CFLOOP
Nope. You'll have to put the opening and closing loop tags either
both inside each cfif, cfelse block, or put them outside the entire
cfif.
CFIF this IS "that"
cfloop query="example1"
#variable#
/cfloop
CFELSE
cfloop query="example2"
#variable#
/cfloop
/CFIF
Or
cfloop query="example1"
CFIF this IS "that"
#variable1#
CFELSE
#variable2#
/CFIF
/cfloop
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: duplicating inserts
One way is to check in the same SQL statement as your insert: insert into mytable (field1, field2) values (value1, value2) where not exists (select * from mytable where field1 = value1 and field2 = value2) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 10:25 AM To: CF-Talk Subject: duplicating inserts Anyone know of a way to stop records from being reinserted into a database when a user hits the back button? I have a page that checks for duplications in a database, and if it finds no duplicate, then it will insert it into the database. Problem is, when a user hits the back button, it inserts the record again. Its not finding duplicates more than likey because the query is being cached so it doesnt know to look again. But how can I get it to either do nothing including not inserting the record a second time or atleast recheck again to see if its a duplicate record? I can't take caching off this machine as these are some monster queries and performance is greatly improved by caching queries. Thanks *** Misty Woodward ODS Decision Support tel: 913.315.6583 email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFContent to a network share
Actually I recommend using the UNC name (\\servername\sharename\dir\file) because using the drive letter relies on that drive being mapped. -Original Message- From: Adrian J. Moreno [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 5:57 PM To: CF-Talk Subject: Re: CFContent to a network share cfquery is one thing - those refernce a dsn set in CF Administrator. cfcontent needs an actual file path. Your server has no idea what "\\servername\..." means. It needs "D:\exact\file\path\ You may, however, be able to manipulate your serverpath using #ExpandPath()# HTH, Adrian J. Moreno Howie Hamlin wrote: I have one server running CF which accesses DB files (DbaseIV - don't ask g). Anyway, that works fine (I can do queries and such). I have CF logged in as Administrator and using UNC paths. Today, I tried to configure CFCONTENT to send db files to a browser. I get a Windows error of 5 (access denied). Here's the pertinent code: cfset dbfile="\\ServerName\ShareName\databasefolder\"url.file CFCONTENT TYPE="appplication/octet-stream" DELETEFILE="No" FILE="#dbfile#" RESET="Yes" I know the shares work (CFQUERY would not work otherwise). Any ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Connecting to an Oracle DB
1) Did you install the Oracle client on the CF Server? 2) Can you connect to Oracle using an Oracle tool (like SQL Plus)? -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 4:13 AM To: CF-Talk Subject: Connecting to an Oracle DB Anyone help me connect to an Oracle DB? I am having trouble connecting to a Siebel DB via an Oracle ODBC driver. The database is on 8.1.6 EE. I can get an ODBC system/file DSN setup up but cannot verify the datasource. I have always dealt with NT. ;-/ Neil ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFID clones
I thought if the browser, through cookies or whatever, sends a CFID/CFTOKEN pair that CF doesn't remember (because you've deleted it or CF has deleted it automatically), CF would make up a new CFID/CFTOKEN pair and give it to the browser. So if you delete the shared pair, each of your twins upon returning to the site would get a new pair and become single again. -Original Message- From: Massimo "Fuse" Gianadda [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 11:38 AM To: CF-Talk Subject: Re: CFID clones Thank's Paul, but deleting CFID CFTOKEN in DB doesen't delete the twins set in client's cookie (I think ?). So if 2 visitors have the same cfid, they share the variables in the site too. Sorry for my poor English (and CF skill too). maX -Messaggio Originale- Da: "paul smith" [EMAIL PROTECTED] A: "CF-Talk" [EMAIL PROTECTED] Data invio: venerdì 12 gennaio 2001 2.12 Oggetto: Re: CFID clones Short Term: Delete in Registry or DB Long Term: Set time limit for delete in CF Admin best, paul At 02:30 AM 1/12/01 +, you wrote: Dear list, recently we changed one of our server, now several returning visitors share the same CFID-CFTOKEN (clientcookie is set to "yes" in application.cfm) in the same session. What's the best approach to delete the old CFID and set a new one ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFContent to a network share
Turn on auditing and see what userid is trying to make the connection. I think when you use CFCONTENT it's actually IIS, and therefore the iis anon user, that grabs the file. At any rate, it _can_ be made to work. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 12:12 PM To: CF-Talk Subject: CFContent to a network share I have one server running CF which accesses DB files (DbaseIV - don't ask g). Anyway, that works fine (I can do queries and such). I have CF logged in as Administrator and using UNC paths. Today, I tried to configure CFCONTENT to send db files to a browser. I get a Windows error of 5 (access denied). Here's the pertinent code: cfset dbfile="\\ServerName\ShareName\databasefolder\"url.file CFCONTENT TYPE="appplication/octet-stream" DELETEFILE="No" FILE="#dbfile#" RESET="Yes" I know the shares work (CFQUERY would not work otherwise). Any ideas? TIA, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedures Problem
I don't think it has anything to do with the SP. This: CFLOOP INDEX="type" LIST="#termtype#" tells CF to try to treat the entire query as a list, which is why you get the error. Try CFLOOP INDEX="type" LIST="#termtype.termtype#" to pass just that field of the query as the list. -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:34 AM To: CF-Talk Subject: Stored Procedures Problem Greetings, I'm having a problem with the return values from a stored procedure. Here's the call to the SP: cfstoredproc procedure="sp_getrelationships" datasource="EFGprograms" returncode="Yes" debug="Yes" !--- Input to stored procedure --- cfprocparam cfsqltype="CF_SQL_DECIMAL" value="#form.progid#" dbvarname="@progid" type="In" !--- Output from stored proceedure --- cfprocresult name="termtype" resultset="5" /cfstoredproc When we do a simple CF output, as in: cfoutput query="termtype"#termtype#BR/cfoutput We get what appears to be a simple list: 30/15 Balloon,15 Year Fixed Now when we want to loop through the list, as in CFLOOP INDEX="type" LIST="#termtype#" cfoutput#type#BR/cfoutput /cfloop We get the following error message: LIST The value cannot be converted to a string because it is not a simple value. Simple values are booleans, numbers, strings, and date-time values. Any help in figuring out this error and how to correct it would be appreciated. Thanks, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 204 Manassas, Virginia 20109-3795 tel: (703) 393-7930 fax: (703) 393-2659 Web: http://www.pacel.com http://www.ebstor.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Access Application to Cold Fusion
I don't think you'll find an easy way. From bitter experience, let me recommend that you not lightly accept "make a web application that works just like this" as the requirements. Even though it will be frustrating for the user, you need to get them to specify what each screen and report is supposed to do. Otherwise you will be hearing 'in this special case the Access application always did this, your version doesn't and therefore is broken' from the client indefinitely. -Original Message- From: Pete Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 11:08 AM To: CF-Talk Subject: Convert Access Application to Cold Fusion My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking forward to re-writing all of the user interface information (forms and reports) into CF. Thanks. Pete Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT STORED PROCEDURES
Perhaps Select * from member where membernumber0 and active=@active and test=@test order by membernumber ? -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 3:47 PM To: CF-Talk Subject: RE: OT STORED PROCEDURES is there anyway to do the if in the query of a stored procedure without using a Cursor. and this is what i wanted Select * from member where membernumber0 and active='y' and test='no' order by membernumber by using this type logic select * from member where membernumber0 IF @active is 'y' and active='y' END IF @test is 'y' and test='no' END order by membernumber so that by using a stored procedure i can say is active is N then the (and active='y') wont run properly. =) hope that helps @ Here's an example script I was given that show how you can loop through a query using a cursor. Hope it helps. Rick USE Master GO DECLARE @DBname VarChar(50) DECLARE DBCursor SCROLL CURSOR FOR SELECT Name FROM Master..SysDatabases ORDER BY Name -- ORDER BY DBID -- Sys DBIDs: 1 - 6 ; User DBIDs = 7 OPEN DBCursor FETCH NEXT FROM DBCursor INTO @DBName WHILE (@@FETCH_STATUS = 0) -- 0:fetch successful -1:fetch failed -2:row mia BEGIN PRINT @DBname -- do stuff FETCH NEXT FROM DBCursor INTO @DBName END CLOSE DBCursor DEALLOCATE DBCursor This one adds a little bit of Dynamic SQL, which I often find it necessary to use. /* MinimalCursor+DynoSQL.sql */ /* JWM 200011013 */ USE Master GO DECLARE @DBname VarChar(50) DECLARE @SQLString VarChar(255) SET NOCOUNT ON DECLARE DBCursor SCROLL CURSOR FOR SELECT Name FROM Master..SysDatabases ORDER BY DBID -- ORDER BY DBID -- Sys DBIDs ~= 1 - 6 ; User DBIDs ~= 7 IF EXISTS ( SELECT * FROM Information_Schema.Tables WHERE Table_Name = 'tmpUserTable' ) DROP TABLE tmpUserTable CREATE TABLE tmpUserTable ( Users VarChar(50) ) OPEN DBCursor FETCH NEXT FROM DBCursor INTO @DBName WHILE (@@FETCH_STATUS = 0) -- 0:fetch successful -1:fetch failed -2:row mia BEGIN TRUNCATE TABLE tmpUserTable PRINT '*** ' + @DBname + ' Database ***' -- do stuff SET @SQLString = 'INSERT INTO tmpUserTable SELECT ' + '[Name]' + ' FROM ' + @DBName + '..SysUsers' EXEC (@SQLString) PRINT @SQLString SELECT * FROM tmpUserTable FETCH NEXT FROM DBCursor INTO @DBName END CLOSE DBCursor DEALLOCATE DBCursor SET NOCOUNT OFF -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:20 PM To: CF-Talk Subject: OT SQL STORED PROCEDURES WITH THE IF/ELSE/ on Stored Procedures is there a way to write a storedproc so it was like this SELECT * from member where membernumber 0 IF @name is "0" and name='blah' end if @this eq "that" and that='test' end to make it only run certain things if certain values are set Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DoS in coldfusion passwords
So do you manage your production CF Server through direct registry edits? -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 11:15 AM To: CF-Talk Subject: RE: DoS in coldfusion passwords The easy and obvious way to never have to lose sleep over this one is... Never install administrator on a production system. :) Solves that problem 100% of the time. Jeremy Allen ElliptIQ Inc. -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 11:15 AM To: CF-Talk Subject: DoS in coldfusion passwords Don't know if anyone has heard of this one. It was discovered a while ago, but you never know. http://www.foundstone.com/cgi-bin/display.cgi?Content_ID=37 Dave ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LOCKING revisited...
And those of us still on 4.0x don't (I think) have that option. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 3:16 PM To: CF-Talk Subject: LOCKING revisited... Ok, given that we all agree: ** Access to shared variables should *ALWAYS* be locked ** Then why on Earth shouldn't I just turn on Automatic Read Locking for Application (and Session et al if I use them) scope and only worry about write locking in my code? Why doesn't everyone do that, with the rare exception of some code that has unusual locking needs. I've heard the argument that automatic read locking is a slight performance hit. It couldn't be more of a hit than parsing cflock /cflock around every access and still doing the read lock anyway! --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803rid=972879910type=A ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LOCKING revisited...
No. For structure you can use Structcopy. For Queries you're SOL in 4.0x. I've thought about writing a QueryCopy CFX, which should be pretty easy, but haven't done it yet. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 12:26 PM To: CF-Talk Subject: RE: LOCKING revisited... On 12/20/00, Ben Lowndes penned: CF handles complex variables by reference, but simple variables by value... So if you want to move a structure out of the application scope you need to use the duplicate() function and not a direct reference. Is the duplicate() function supported in 4.01? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LDAP testing
There is a free open-source-ish ldap server available from www.openldap.org. It currently runs on various unices; I have gotten it to work in the past via CF but am not currently using it (or any other ldap server). Here is what looks like a port of the previous to NT by Qualcomm: http://www.eudora.com/free/ldap.html -Original Message- From: Marc Schipperheyn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 6:36 AM To: CF-Talk Subject: LDAP testing Hi all, I need to test CF with LDAP. Is there a proper free developer edition of the software that I can use to write a cross-platform safe integration with? We use Windows NT as our developer platform. Kind regards, Marc Schipperheyn __theFactor.e__ _ .e ___ mr M.Schipperheyn MBA Technical Director___[EMAIL PROTECTED] _ .e ___ Friesestraatweg 215a P.o. Box 2010__ tel: +31 (0)50 5757888 9704 CA Groningen__fax: +31 (0)50 5757889 The Netherlands http://www.thefactore.com _ .e ___ Premium Partner for Allaire. Multimedia development _ with Macromedia Director, Authorware Flash. The future is technological, but it will not be a world of gray steel. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LDAP testing
Got curious - it looks like netscape/iplanet have a "eval" LDAP server that runs on NT available for download: http://www.iplanet.com/downloads/download/0103.html -Original Message- From: Marc Schipperheyn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 6:36 AM To: CF-Talk Subject: LDAP testing Hi all, I need to test CF with LDAP. Is there a proper free developer edition of the software that I can use to write a cross-platform safe integration with? We use Windows NT as our developer platform. Kind regards, Marc Schipperheyn __theFactor.e__ _ .e ___ mr M.Schipperheyn MBA Technical Director___[EMAIL PROTECTED] _ .e ___ Friesestraatweg 215a P.o. Box 2010__ tel: +31 (0)50 5757888 9704 CA Groningen__fax: +31 (0)50 5757889 The Netherlands http://www.thefactore.com _ .e ___ Premium Partner for Allaire. Multimedia development _ with Macromedia Director, Authorware Flash. The future is technological, but it will not be a world of gray steel. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Websphere
Perhaps a java servlet engine such as Tomcat (http://jakarta.apache.org/tomcat/)? Unless that's what websphere actually is, which Hal is rather suggesting. Or ASP via ChiliSoft (http://www.chiliasp.com/about/pressrel/caspaix111500.htm). -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 12:02 PM To: CF-Talk Subject: RE: Websphere Kind of on the topic of websphere Does anyone know of a application server that will run on AIX, rather than being stuck with websphere??? Regards Stephen -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, 18 December 2000 21:28 To: CF-Talk Subject: Re: Websphere So one would use jsp as the main language?? - Original Message - From: "Hal Helms" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 18, 2000 2:03 PM Subject: RE: Websphere It's an IBM product that uses Java. It's integrated with IBM's Visual Age for Java IDE. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 4:06 PM To: CF-Talk Subject: Websphere We have a client using websphere that we are doing some work for. I have never touched it. Anybody know what type of engine it is running. Is it a proprietary scripting language? ANy help would be great. Kevin Schmidt, Web Technology Manager Allaire Certified Cold Fusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX and query manipulation
This is true* for 4.0x. Don't know about 4.5 but I don't think many changes have been made to CFX support lately. *You can actually create a DLL with multiple CFX "hooks" (multiple public interfaces, entry points, or whatever real DLL programmers call them) which can be accessed using different names from CF. It seems to me that it would theoretically be possible to pass two different queries to two different CFX hooks and have the DLL process them together, but I haven't seen it done. -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 11:39 AM To: CF-Talk Subject: CFX and query manipulation Hi all, Is it true that a CFX tag can access only one query from the calling template? (Page 177 of Ben Forta's 'Advanced ColdFusion' book) The book further goes on to say that it is impossible for a CFX tag to access or manipulate the contents of more then one query result set from the calling template. Does it hold good for CF4.5? Do CFXJ's help? Kedar Desai Differential Technologies Fairfax, VA = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQuery and Caching
Seems like something whose practicality can be easily tested. Pick a commonly run query and set it up to cache. In CF Admin tell CF to cache up to 10 unique queries. Watch memory usage on the server. If memory usage is still well within limits, try setting the limit to 20. Repeat as desired. I use query caching quite a bit (with CF 4.0x) and have yet to pull back because of memory concerns. You can argue that caching may result in needing fewer simultaneous connections to the DB; each of those connections cost memory too.. -Original Message- From: Todd McFarlin [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 1:08 PM To: CF-Talk Subject: CFQuery and Caching Greetings all, I am new a this project and the current methodology doesn't utilize query caching. I attempted to make an argument, but could not satisfy the big man's concerns of memory consumption. The project is an app, so I cannot quote the configuration that it will run on. The largest query result would pull 1000 rows*15 columns. Can any offer advise to an argument? Pro or Con: TIA, Todd ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Structures?????
You're overwriting the same structure with each row. Try this: cfquery name="thequery" datasource="datasource" select * from ads /cfquery Cfset stads = structnew() cfoutput query="thequery" cfset structinsert(stads, thequery.adid, structnew()) Cfset stads[thequery.adid].CDate = thequery.cdate .. etc for other fields ... /cfoutput cfloop index="ii" list="#StructKeyList(stads)#" CFOUTPUT AdID is #ii# CDate is #stads[ii].cdate# ... etc for other fields ... /CFOUTPUT /cfloop -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 3:55 PM To: CF-Talk Subject: Structures? I'm getting frustrated with this. I want to build a structure from a query with multiple fields in each record in the structure. Then query the structure for a particular row. In other words use a structure like a DB table insert/edit/delete. I seem to be getting only one record in the structure. Anyone see what is wrong with this code?? cfquery name="thequery" datasource="datasource" select * from ads /cfquery cfscript stads = StructNew(); stads.adID="#thequery.adID#"; stads.CDate="#thequery.CDate#"; stads.Email="#thequery.Email#"; stads.Phone="#thequery.Phone#"; stads.City="#thequery.City#"; stads.AdDesc="#thequery.AdDesc#"; /cfscript cfloop query="thequery" CFSCRIPT stads=StructNew(); StructInsert(stads, "adID", "#thequery.adID#"); StructInsert(stads, "CDate", "#thequery.CDate#"); StructInsert(stads, "email", "#thequery.email#"); StructInsert(stads, "phone", "#thequery.phone#"); StructInsert(stads, "City", "#thequery.City#"); StructInsert(stads, "AdDesc", "#thequery.AdDesc#"); /CFSCRIPT /cfloop cfloop index="ii" list="#StructKeyList(stads, ',')#" delimiters="," CFOUTPUT AdID is #StructFind(stads, "AdID")# CDate is #StructFind(stads, "CDate")# EMail is #StructFind(stads, "email")# Phone is #StructFind(stads, "phone")# City is #StructFind(stads, "City")# AdDesc is #StructFind(stads, "AdDesc")# /CFOUTPUT /cfloop ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and SQL
When you say "SQL" do you mean MS SQL Server? If so, SQL Server (at least 6.5, the last version I know) doesn't have a rownum. You can either use CFOUTPUT's startrow and rowcount abilities, or you could query for a list of all the keys in the table, figure out using the listgetat function the key that represents row 50 and the key that represents row 100 and requery for the rows whose keys fall between them. -Original Message- From: Todd McFarlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 6:11 PM To: CF-Talk Subject: RE: Oracle and SQL Greetings again, I'm afraid I wasn't complete in my first posting. Please allow me to expand the situation. I fire off a quick query to grab the number of entries in the table. From this number, I populate a select box based on number of entries/50=pages. Depending on the value from the select box, I need to pass two variables into the SQL statement: StartRow and EndRow. Now, the table I'm grabbing info from is constantly having entries added, deleted, and updated. So that rules out caching Also, we use OBDC drivers. The BETWEEN function sounds very much like it is a starting point. But how does one say RowNum in SQL? -Original Message- From: Todd McFarlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 10:17 AM To: CF-Talk Subject: Oracle and SQL Greetings, Being an Oracle person, I'm having a difficult time trying to make a CFQuery work correctly in SQL. The Problem: I have a database with thousands of rows. I need to select only 50 rows per query. The start row and end row need to be variables. Now, Oracle has a function called RowNum. In the Where part of a query, it allows the selection of certain rows from the table between two set paramaters...something like select rows =50 and =100. This yields 50 rows returned. My Question: Is there a similar function in SQL, or how is this accomplished? My thanks, Todd McFarlin Celosis, Inc. [EMAIL PROTECTED] (510) 814-3078 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL question
There's no nice way that I know of (putting a list in a field is a relational database no-no); the specific kludge would depend on what sort of database you're using. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 7:33 AM To: CF-Talk Subject: OT: SQL question Whew . . . I'm still in one piece after that wind last night . . . What's the best way to query a column in a table that has a comma delimited list? For example, in the query below: If B_xRef is a comma delimited list, what's the most effecient way to find all the Table_b rows that contain the value of A_xRef (which is a single value) SELECT A.A_xRef, B.B_xRef FROM Table_a A, Table_b B WHERE A.A_xRef IN B.B_xRef (or something to this effect?) Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL question
I think a simple "like" will give you false matches - %1% can match1, 11,
121, etc. This is more complicated but I believe it will work:
/*
create table test_match (the_key int, the_sought varchar(50))
create table test_find (a_key int, finder varchar(50))
insert into test_match values (1, '1,2,3,4,10,11')
insert into test_match values (2, '1,2,3,4,12')
insert into test_find values (1, '10')
insert into test_find values (2, '12')
*/
select test_match.the_key, test_find.a_key
from test_match, test_find
where (patindex('%,' + test_find.finder + ',%', test_match.the_sought)
+ patindex(test_find.finder + ',%', test_match.the_sought)
+ patindex('%,' + test_find.finder, test_match.the_sought)) 0
or of course you could normalize as others have recommended.
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 8:30 AM
To: CF-Talk
Subject: Re: SQL question
It's in an MS SQL Server 7
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 12, 2000 8:30 AM
Subject: RE: SQL question
There's no nice way that I know of (putting a list in a field is a
relational database no-no); the specific kludge would depend on what sort of
database you're using.
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 7:33 AM
To: CF-Talk
Subject: OT: SQL question
Whew . . . I'm still in one piece after that wind last night . . .
What's the best way to query a column in a table that has a comma delimited
list?
For example, in the query below: If B_xRef is a comma delimited list,
what's the most effecient way to find all the Table_b rows that contain the
value of A_xRef (which is a single value)
SELECT A.A_xRef, B.B_xRef
FROM Table_a A, Table_b B
WHERE A.A_xRef IN B.B_xRef (or something to this effect?)
Thanks,
Dave
=
"What we need is a list of specific unknown problems we will encounter"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
code to compare cfquery recordsets?
Has anyone written a module to compare queries? I'd just like to know if two queries are identical or not, I don't care how they're different. --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Structure comparison
Does anyone have code (or is there a function I've overlooked) to compare two structures and verify that they're logically identical? Thanks --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
