RE: what tag captures data from a web page?
cfhttp... and then work with the resulting variable, cfhttp.filecontent. Gene Kraybill -Original Message- From: Ed Gordon [mailto:NetDr@;callptc.com] Sent: Monday, November 04, 2002 10:49 AM To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Authentication issue
Scenario: An organization will be migrating a large number of workstations from an NT domain to a Win2000/AD domain, over a period of 4 to 6 months. NT administrators do not want to establish a "trust" to enable authentication across multiple domains. Is there a way, perhaps using the new facilities in CFMX, that would allow the use of Windows integrated authentication on an intranet throughout such a dual-domain transition? Gene ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Performance Tweaking - Friday Morning Brain Fart
Yup, it was introduced in 5.0... Gene -Original Message- From: Ciliotta, Mario [mailto:mario.ciliotta@;csfb.com] Sent: Friday, November 01, 2002 1:46 PM To: CF-Talk Subject: RE: Performance Tweaking - Friday Morning Brain Fart Hi all, Hate to ask this question, but is savecontent a 5.0 and above tag. I am still in the 4.5 world, starting to migrate to MX. Mario -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 12:06 PM To: CF-Talk Subject: RE: Performance Tweaking - Friday Morning Brain Fart if it's exactly the same output (html output), then you could use . Sytax is: blah 1 blah 2 blah 1 Watch out for . If you have set this, the cfcontent will only trap whatever is between output tags. It basically traps the output buffer from the point of the call. To use the variable, simply output it to the page: #mySelectbox# It's always a string. One way I've used this in the past is in dynamically generating an HTML email that includes some stock quotes or charts etc. Build it once, then use it ina query driven email over and over again. It works well. -mk -Original Message- From: Ian Lurie [mailto:ian@;portentinteractive.com] Sent: Friday, November 01, 2002 10:29 AM To: CF-Talk Subject: Performance Tweaking - Friday Morning Brain Fart Hi all, I've done this before but am having a post-halloween party moment: 1. I have a chunk of code that generates a drop-down menu. The menu's used again and again on a page. 2. I want to generate that code once, insert it into a variable, and then reuse it. That'll shave a LOT of time off the page execution time. I dimly remember an article by Ben Forta (I think) about this - can someone refresh my sugar-addled brain? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: SQL Query Results
Please clarify exactly what you want to retrieve... Gene -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:34 PM To: CF-Talk Subject: RE: SQL Query Results If I use 'OR', won't it stop evaluating once it finds a match? -Original Message----- From: Gene Kraybill [mailto:Gene.Kraybill@;adelphia.com] Sent: Monday, October 28, 2002 1:26 PM To: CF-Talk Subject: RE: SQL Query Results If I understand your intention correctly: WHERE s1_trainer1 = #client.id# OR s1_trainer2 = #client.id# OR s1_trainer3 = #client.id# OR ... Gene K. -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:14 PM To: CF-Talk Subject: SOT: SQL Query Results How can I adjust the following query so that it checks every trainer (s1_trainer1, s1_trainer2, etc.) for a match to #client.id# without having to do 10 queries? SELECT id, type, other, city, prov, s1_startdate, s1_trainer1, s1_trainer2, s1_trainer3, s1_trainer4, s1_trainer5, s2_trainer1, s2_trainer2, s2_trainer3, s2_trainer4, s2_trainer5 FROM courses WHERE s1_trainer1 = #client.id# ORDER BY s1_startdate DESC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL Query Results
If I understand your intention correctly: WHERE s1_trainer1 = #client.id# OR s1_trainer2 = #client.id# OR s1_trainer3 = #client.id# OR ... Gene K. -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:14 PM To: CF-Talk Subject: SOT: SQL Query Results How can I adjust the following query so that it checks every trainer (s1_trainer1, s1_trainer2, etc.) for a match to #client.id# without having to do 10 queries? SELECT id, type, other, city, prov, s1_startdate, s1_trainer1, s1_trainer2, s1_trainer3, s1_trainer4, s1_trainer5, s2_trainer1, s2_trainer2, s2_trainer3, s2_trainer4, s2_trainer5 FROM courses WHERE s1_trainer1 = #client.id# ORDER BY s1_startdate DESC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT js question (child window passing back to parent)
Looks like you may have mis-referenced your child form name -- it's actually
"actionCode" not "actionReason".
Gene
-Original Message-
From: Tim Do [mailto:TDo@;lahd.lacity.org]
Parent Window:
Form that I'm trying to populate with Child window data:
Codes
Child Window:
function passToParent()
{
window.opener.document.newCaseInfo.actionReason.value =
document.actionReason.actionReasonCode.value;
return false;
window.close();
}
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Poll
Someone (sorry, I deleted the msg) was asking about a poll. Here's a freeware one on Dev Ex... http://devex.macromedia.com/developer/gallery/info.cfm?ID=6A948CFB-C9E9-11D6 -840900508B94F380&method=Full Gene -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 3:28 PM To: CF-Talk Subject: Re: Client Variable Storage and SQL Server Yep, afaik CF ( at least prior to MX ) hits the db for each reference to those client variables... If you're concerned about the overhead, you could copy all your client variables to the request scope at the top of the page, i.e. in your application.cfm and then use the request variables instead... Once you've got this in your application.cfm a multi-file regex or two on your development directory should get the rest of the app in line with this structure... If you use lots and lots of client variables or have many pages on which they are not used, however, this might wind up being less efficient than simply using them normally the way you are now, since this would copy all your client variables to the request scope whether they're used on a page or not. The other alternative of course, is to simply manually optimize each page by copying any client variables which are used more than once on that page into the request scope at the top, thereby grabbing only the data that page will need. My own applications only reference them once or twice on a given page, so I don't worry terribly much about their management or overhead. hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > We are using SQL Server to manage our client variables and I've noticed > that > a majority of the SQL commands hitting our server are from Cold Fusion > managing client variables. Has anyone else noticed this type of activity? > Just a simple trace in SQL Profiler revealed statements like: > SELECT data FROM CGLOBAL WHERE cfid = @P1 > or > exec sp_executesql N'SELECT data FROM CGLOBAL WHERE cfid = @P1', N'@P1 > char(13)', '4858:66043525' > I haven't measured this in terms of performance, but I imagine it has to > take some toll on our server. Is this the best way to go or should I try > something else? > Thanks in advance, > Andy > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Multiple filters on cfdirectory
If you really needed the results in a single query, you could retrieve ALL the files and then do a "query of a query" using a condition like this: WHERE Name LIKE '%.gif' AND Name LIKE '%.jpg' or possibly run cfdirectory twice - once for each extension - and use the query functions to merge the two result sets... Gene Kraybill -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 3:46 PM To: CF-Talk Subject: Re: Multiple filters on cfdirectory Only one filter can be applied. You can do a check on the extension of the file and if it does not match your criteria, do nothing, else display the file name and such. >>> [EMAIL PROTECTED] 10/11/02 02:38PM >>> Is there a way to achieve the following (multiple filters), it does not seem to work this way: TIA, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Please clarify behaviour of listContainsNoCase
ListFindNoCase will look at each list item as a whole...
Gene Kraybill
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 12:41 PM
To: CF-Talk
Subject: Please clarify behaviour of listContainsNoCase
Can someone confirm to me that this is the correct behaviour for
listcontainsNoCase:
if( listContainsNoCase("MRS,MS,MISS", "mr" , "," )) {
gender = "F";
} else {
gender = "m";
}
#gender#
returns F, if I change the first entry in the list to MZ, M gets
outputted.
I'm assuming this is because MRS contains 'MR' however I thought the
whole point of having a listcontainsNocase function (as opposed to using
contains() ) was that the function would look at each entry as a whole?
Thanks
Kola
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
CFMAIL with relaying off
Has anyone successfully used CFMAIL with an Exc 2000 SMTP server, when SMTP relaying is prohibited? Adding the IP of the web server to the exception list in the SMTP service doesn't seem to work, as I still get relaying errors on external mail. And CFMAIL doesn't have username/pwd parameters... Gene Kraybill ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT: Spider 404s
I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for " 404 " in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Gene Kraybill ~~ 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: Last row inserted
It's my understanding that CFTRANSACTION may not give guaranteed protection here, if your database supports row-level locking. Correct? Howie Hamlin wrote: > Yep that's it. However, you should do a transaction so that another record > isn't added while you're fetching the current highest ID. > > - Original Message - > From: "Joshua Tipton" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 17, 2001 1:34 AM > Subject: Last row inserted > > > I know this has been asked a million times but what is the best way to > pull > > the id of the row last inserted. Isnt select (column name)MAX as > > (whatever)? - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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
OT: Scheduled File Transfers
We need to automate a daily file transfer process between another company's computer with dialup Internet access but no Cold Fusion or Web server software, and our Web/CF server (from the company's computer TO our server.) Is this typically done by setting up a command line version of a standard FTP client, and then firing that daily by using the NT scheduler, or are there better ways? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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
OT: JS syntax error
This code works in IE, but not in Netscape (4.61)... Can someone help?
function windowOpen() {
leftPos=0;
if (screen) {
leftPos=screen.width-420;
topPos=screen.height-470;
}
var myWindow=
window.open('index.cfm?fuseapp=Products&fuseaction=Catalog','PopUp',
'height=screen.height,width=400,left='+leftPos+',top=30,scrollbars=yes,resizable=no,
toolbar=no,menubar=no');
if (!myWindow.opener) myWindow.opener = self;
}
Gene Kraybill
LPW & Associates
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net
~~
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
CFLOCK for 4.0.1 AND 4.5.1
I'm struggling with implementing CFLOCK so it runs on BOTH CF 4.0.1 and 4.5.1. (The 4.5.1 server has FULL CHECKING on.) Given that 4.0.1 FORBIDS the SCOPE parameter in CFLOCK and 4.5.1 REQUIRES it, I thought I'd do a check for which version of CF was running and stash the appropriate CFLOCK parameters into a local variable. For example, if CF 4.5.1 or better, I'd set the parameter var to be equal to 'SCOPE="Application" TYPE="Exclusive"', etc. So my CFLOCK would look like this: code...> But... CF throws an error on the pound sign, apparently not allowing the specification of parameters via variable. Any ideas besides repeating the entire CFLOCK block for each version? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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: Searching Help files in Studio
And it also fixed the Studio Help Search for me. Many thanks! Gene Kraybill Jann VanOver <[EMAIL PROTECTED]> wrote: > Thanks Aaron! I wasn't the person who posted the problem originally, but > I've been having the same problem with Studio 4.5.1 > > The article you referred to fixed it for me! > Aaron Johnson <[EMAIL PROTECTED]> wrote: > > Check out this KB: > > Search in Studio 4.0 or HomeSite 4.0 doesn't work > http://www.allaire.com/Handlers/index.cfm?ID=13516&Method=Full - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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: Searching Help files in Studio
Thanks for that idea, but no, it's 4.0.1... I can browse the Help files using the reference "tree", but whenever I do a search, it returns no results, even for the simplest of keywords. Guess it's been that way since installation -- I've been relying on the index in the manual. Any other ideas? Gene Kraybill Neil Clark wrote: > is this Studio 4.5.2? if so they have recalled it (well they are in the > middle of an update and is temp unavailable) due to a problem with the Help > Files. ~~ 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
Searching Help files in Studio
In Studio, I can browse the Help reference tree, finding topics by drilling down, but when I use the Search facility, I always get "No matches found", even when searching all references for the most common words. Must be a very simple solution that I'm overlooking... Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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
NULL problem in Query
Mystery. Can someone tell me what I'm missing? I have an Access date field called WhenSubmitted. I start with the field populated. Then I run this test: UPDATE Orders SET WhenSubmitted=NULL WHERE OrderID=4 I manually check the field. It is now empty, presumably set to NULL. But when I run the following, I get a record count of 0. SELECT * FROM Orders WHERE WhenSubmitted=NULL; #GetNull.RecordCount# Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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
Preventing Browsers Cacheing a .cfm file
I have a page where Javascript (the onchange event in a SELECT box) reloads a page and resets some session vars. I had problems where those session vars would not get reset because the page was being pulled out of the browser cache. The problem disappeared if I set the browser options to check the page every time, but I couldn't rely on all users having that option set in their own browsers. Taking a cue from an old post to this list, I found that adding a random number to the query string for the reload action fixed the problem -- but using the standard META Pragma/ META Expire tags did not. Can someone please explain why the META no-cache tags don't work in a situation like this? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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
OT: SQL Union
I want to use the UNION operator to combine two SELECT statements. My problem is that one of the SELECTs draws data that has one less column than the other, because the table used in the second is missing one of the columns found in the first. I'm trying to work out a way to create a dummy boolean column in the second query and populate it with the value of 0, so the UNION operator works. Something like SELECT Column1, Column 2, Column3 FROM Table1 UNION SELECT Column1, Column2, 0 as Column3 FROM Table2 This doesn't work. What will? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net ~~ 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
OT: Javascript problem
Looking for a bit of help with some Javascript I want to use in a CF app.
I want to be able to open a popup window (TEST_POPUP.CFM), enter a value in that
window, and then submit the popup window so it changes a field in the original page
(TEST_MAIN.CFM) to the popup value and automatically submits the original page to
its action script (TEST_ACTION.CFM). I need to show the action page's results in the
original window and close the popup window.
With these 3 little test scripts, the value from the popup window appears in the input
field of the original page, but the original page doesn't get submitted to the action
page. What am I missing?
Gene Kraybill
==
TEST_MAIN.CFM:
<!--
function windowOpen() {
var myWindow=window.open('test_popup.cfm','windowRef','width=200,height=200');
if (!myWindow.opener) myWindow.opener = self;
}
windowOpen();
//-->
TEST_POPUP.CFM
<!--
function updateOpener() {
opener.document.forms[0].output.value = document.forms[0].input.value;
opener.document.forms[0].submit;
window.close();
}
//-->
TEST_ACTION.CFM
this is the page that processes the results from the main page.
output is: #form.output#
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net
~~
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
Pulling hair with CFLOCK
I keep getting this message with a certain CFLOCK: "Timed out while waiting to obtain exclusive access. The error occurred while processing an element with a general identifier of (CFLOCK)..." I have been able to isolate the problem by constructing the following test template. The first CFLOCK always works fine, but the second one always times out. The CFINCLUDEd template that seems to cause the problem makes read access to a number of session variables. This is on a test site where nobody else is accessing this template. (I'm using the NAME parameter because this code needs to work with both 4.0.1 and 4.5.1.) Can someone please help? Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net ~~ Structure your ColdFusion code with Fusebox. Get the official book at https://secure.houseoffusion.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFLOCK - need help
Many thanks to Dave and Steve! With that combined genius and further experimentation, I think I have a cross-version solution: I'll use NAME="#Session.SessionID#" with session variable locks, and NAME="#Application.ApplicationName#" with application variable locks. I discovered, strangely, that ANY OTHER name in either case fails on 4.5.1, at least with FULL CHECKING on. For example, CF 4.5.1 doesn't let me use NAME="Test_#Application.ApplicationName#". Is that a bug or a feature? (My host, a well-known company, says they must keep FULL CHECKING on to protect the environment on a shared server.) Gene Dave Watts wrote: > If you need backwards compatibility, don't use the new SCOPE attribute; > use the NAME attribute instead. That's all you have to do. If you're > working with only 4.5.1 servers, you'd be better off using the SCOPE > attribute, but since you're not, you'll have to stick with NAME. Steve Nelson wrote: > If you wrote your locks in 4.01 > syntax it would work in both. > > timeout=20> Gene Kraybill wrote: > > > > Does anyone know a way to use CFLOCK so it works in both CF 4.0.1 and > > 4.5.1? > > > > I have an application written using the older CFLOCK parameter > > of "NAME", rather than the new ones of "SCOPE" and "TYPE". I know Allaire > > has a wizard to convert CFLOCKs to the new parameters, but my problem is I > > need to be able to run the same code on BOTH 4.0.1 and 4.5.1. The 4.5.1 > > server has "full checking on" for security reasons (beyond my control), so > > if I include both the old and new parameters with each CFLOCK, it throws > > an error. - Gene Kraybill LPW & Associates LLC www.lpw.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFLOCK - need help
Trying again for help on this, rephrasing: Does anyone know a way to use CFLOCK so it works in both CF 4.0.1 and 4.5.1? I have an application written using the older CFLOCK parameter of "NAME", rather than the new ones of "SCOPE" and "TYPE". I know Allaire has a wizard to convert CFLOCKs to the new parameters, but my problem is I need to be able to run the same code on BOTH 4.0.1 and 4.5.1. The 4.5.1 server has "full checking on" for security reasons (beyond my control), so if I include both the old and new parameters with each CFLOCK, it throws an error. Someone tell me there's a way around this! Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFLOCK: 4.0.1 and 4.5.1
Given the change in parameters and approach, what's the best way to use CFLOCK in an app which needs to be able to run under BOTH CF 4.0.1 and 4.5.1? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Debugging info
I've been mystified recently by what seems to be the failure of the CFServer to display standard debugging info in certain cases. (Makes debugging a nightmare!) I DO have ALL the debugging checkboxes turned on (and no IP restrictions) in the "Debugging" section of the administrator. I can catch the errors using CFTRY/CFCATCH, but they should display without that... Example: A change to the Required attribute in a field in an Access db caused an insert to fail -- and the rest of the template to bomb out. But NO debugging info appeared until I created a CFTRY/CFCATCH... I noticed the same kind of problem with a call to a variable which didn't exist. Ideas? Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
OT: combining SQL queries
SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Debugging an undefined DB
Why doesn't an attempt to access an undefined DB produce a CF error? Just spent too much time trying to figure out why pages on a db-driven site weren't displayingNo errors, no content, just the standard CGI variables, etc. at the bottom... It seemed to be a CFSETTING ENABLECFOUTPUTONLY problem, but eventually I remembered I hadn't defined the DSN after re-installing CF in the wake of a hard drive rebuild...Worked perfect once I redefined the DSN ... The odd thing was that even tho I have all CF debugging turned ON, my pages came up without any CF errors... Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Illegal operation in CFHTTP
What might cause the following occasional error, apparently related to the use of CFHTTP to create a query from a text file? -- Message: Illegal operation in Cold Fusion Extension (CFX) Detail: You have attempted to refer to an invalid row/column combination of a query. This query contains 1 rows. You can call CCFXQuery::GetRowCount to determine the number of rows contained within a query. You can call CCFXQuery::GetColumns to determine the number of columns contained within a query. The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (29:4) to (34:22). - Here's the CFHTTP at that spot in the template: (The file is create dynamically for logging page visits in a Fusebox setting.) Any ideas? Gene Kraybill - Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Getting a value from a field
On the form, you could name your products like this: Prod_001 Prod_002 etc. Then on the action page, use form.fieldnames and CFLOOP to loop through all the fields. If the field begins with Prod_, you would then do: Evaluate(thisfield) to determine whether the value is 0, and if not, you'd display that item... Gene Kraybill LPW & Associates "Ben Densmore" <[EMAIL PROTECTED]> > can someone tell me if there is a way to get values out of a form, = > similar to using form.fieldname? Ihave a page where I have about 50 = > products each with their own text box to enter a quantity. Once a person = > submits the form I want to loop through it and if the particular item = > doesn't have a 0 for a value then i want to display that item that was = > ordered. any help would be appreciated. - Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFOUTPUT grouping
How do you implement a "CFOUTPUT Group" scenario when you need to give the user the option of displaying the results by different sorting orders? I'm displaying a list of buildings, some of which have multiple managers. I allow the user to click on any column to indicate how they'd like the results sorted. The desired order is stored in Attributes.Order. My SQL looks like this: SELECT a.*, b.ManagerID, c.FirstName, c.LastName FROM Buildings a, BuildingManagers b, Users c WHERE a.CustomerID=#Session.CustomerID# AND b.BuildingID=a.ID AND c.UserNumber=b.ManagerID ORDER BY #Attributes.Order# To avoid displaying the duplicate building records in the case of multiple managers, I use this: #ListBuildings.BuildingName# #ListBuildings.FirstName# #ListBuildings.LastName# This works fine only when the sort order is by ID (building). What must I add to make it work for other sort orders? Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Upgrade Issues 4.0.1 to 4.5.1
Does anyone have a rather complete list of potential code problems that may arise from an upgrade from CF 4.0.1 to 4.5.1? We're using 4.0.1, but have several sites on a web hosting service which is about to upgrade. Thanks Gene Kraybill LPW & Associates ----- Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access 97 and 2000
I see Access 2000 has an option to save in Access 97 format. Can anyone vouch for this as a reliable way of maintaining Access-97 dbs on a development machine when upgrading to 2000 isn't an option on the live server? Gene Kraybill Andy Ewings <[EMAIL PROTECTED]> > I think you need to have them installed on a seperate drive, or > partition - but I'm not 100% sure > > -Original Message- > From: Gene Kraybill [mailto:[EMAIL PROTECTED]] > Sent: 22 August 2000 18:55 > To: [EMAIL PROTECTED] > Subject: OT: Access 97 and 2000 > > > What does it take to run both Access 97 and Access 2000 on the same machine? > > We have some small CF db's in Access 97. We have a development machine with > Office 2000 and tried to install only the Access portion of Office 97 on the > same > machine. > > When we try to start either version of Access, we now get this message: > > "Microsoft Access can't start because there is no license for it on this > machine." > > Gene Kraybill > > > - > Gene Kraybill > LPW & Associates LLC > www.lpw.net > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or s end a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > - Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Access 97 and 2000
What does it take to run both Access 97 and Access 2000 on the same machine? We have some small CF db's in Access 97. We have a development machine with Office 2000 and tried to install only the Access portion of Office 97 on the same machine. When we try to start either version of Access, we now get this message: "Microsoft Access can't start because there is no license for it on this machine." Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: remove white space
Didn't try it, but this should work: #Replace(YourStringVariable, " ", "", "ALL")# ... where the first set of quotes as a single space in it, and the second has none. It should replace all occurrences of a space with nothing, effectively stripping out the white space no matter how long it is... Gene Kraybill LPW & Associates LLC Mansfield, PA ex-Aussie (Perth) >From Chad at <[EMAIL PROTECTED]>: > I would like to strip a string of white space from the MIDDLE of a string... > eg turn 2 words into oneie... > hello world ===>> helloworld -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFTHROW
Miriam Hirschman wrote: > How Do I define my own error in a cfthrow? I would like to say if the error > is an invalid search criteria then Try something like this: #CFCATCH.Message# Basically the idea is to wrap the CFTHROW in conditional code so that it creates an error when certain conditions are met. You then "catch" the error by referring to it with the TYPE parameter using CFCATCH, and display the defined error message using CFCATCH.Message (and CFCATCH.Detail, if you define that as well). Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Error Handling
[EMAIL PROTECTED] wrote: > I looked a bit into that , but I waant a message only for that error, and > it doesn't seem like I can tell CFTRY to only catch the cfsearch error. > Please tell me if I am wrong. I've just started using CFTRY myself, but check out CFTHROW. It's my understanding you can use it along with some conditional code to "throw" any customized error message for any error condition at all...Your customized error will then be "caught" by CFCATCH at the bottom of the CFTRY block. Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> > You can use CSV files for ODBC datasource, but don't! The main reason is > that ODBC holds onto sources like that once it's got them > > Make a link table in Access which talks to the CSV - this is the much > preferred solution as you can actually run SQL queries on the data I'd be interested in hearing a few more details on this... and info about the advantages of this over using CFHTTP to create a query object and then looping over the query to insert each record into a db... Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Question - Creating Data Source for CSV text file
Hi John, You could write a few lines of CF to convert the CSV file into a query (using CFHTTP), then cfoutput the query and insert each record into a db table. If there's a way to use a CSV file as a datasource, I'm not aware of it. Even if there is a way, you'd be better off transferring the data to a proper db, with the speed advantages of indexes and other db features. Gene Kraybill LPW & Associates John McGown wrote: > I have a customer that is a car dealership. They want to put their car > inventory online. > The company that makes their inventory database tells me that the data store > is not ODBC compliant, but that they could output a CSV text file that they > will auto-FTP to our servers in the middle of the night. Not exactly the > most elegant solution, but it beats entering car data manually. :) > > Can I create an ODBC connection in the CF Administrator to use a CSV text > file as a data source? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFile access problem
Good point. I've noticed that some of the file contention problems seem to disappear if I use a loop to introduce a brief delay between a CFFILE Delete and a CFFILE Write operation on the same file. Is that to be expected, and should CFLOCK solve that problem (it seems that there are still some file contention or access problems). Gene Kraybill > from [EMAIL PROTECTED] > It could be contention for that file by your application. You could either > CFLOCK that CFFILE operation, or if you don't mind losing some writes you > could use CFTRY/CFCATCH to prevent end users from seeing the error. > From: Gene Kraybill [mailto:[EMAIL PROTECTED]] > We have a simple logging system on one of our sites, and occasionally see > this error: > > Error processing CFFILE > > Error attempting to write data to > > target file 'E:/Web/ThisSite/counter/ShowPage_8_Day10.log'. > > Error: The file could not be accessed. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFFile access problem
We have a simple logging system on one of our sites, and occasionally see this error: > Error processing CFFILE > Error attempting to write data to > target file 'E:/Web/ThisSite/counter/ShowPage_8_Day10.log'. > Error: The file could not be accessed. Given that this operation usually works, can we assume that an access problem is likely caused by server overload? Any way of dealing with this on a shared server, other than lessening the server load? Gene Kraybill LPW & Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: file name
"Jay Wigginton" <[EMAIL PROTECTED]> wrote: > Could some please tell me the file name that if present in a directory will > be executed after the current template... OnRequestEnd.cfm Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: DE() vs Evaluate() when doing a variable number of multiple
"Christopher S Martin" <[EMAIL PROTECTED]> wrote: > > > I get an error saying the > parameter form.ingredientMeasurement cannot be resolved. Try this instead: Gene Kraybill ----- Gene Kraybill LPW & Associates LLC www.lpw.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP
"Kevin Queen" <[EMAIL PROTECTED]> wrote: > I was looking into CFHTTP and was wondering if I could use it to load a page > without displaying said page. No problem. Just include a CFHTTP tag pointing to the desired page, but skip the normal step of using CFHTTP.FileContent to display the contents Gene Kraybill LPW & Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: calendar
"Robert Orlini" <[EMAIL PROTECTED]> > I have a calendar setup w/CF. Users can change/edit text in whatever single > day they choose. I would like to create CF code that can have them select a > row of dates and globally insert text in those selected days. Each day is a > column in my tablle. > > Any ideas please? Maybe have an "Add Global Text" button. When user presses that, the calendar is displayed with a checkbox in the corner of each day's square, and there's an input field for the global text. User enters the desired text, checks the desired days, presses Submit... Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Complex Arrays and Structures
Looking for some peer review or alternative ideas on the following... I'm working on a rather complex B2B CF application where we basically want to have a single set of code drive different customized "versions" of the application based on a whole bunch of config settings. This is for an ordering system that will meet the varying needs of, say, 20 large corporate trading partners. Set a bunch of config options for a certain customer, and the app will show certain products and display and process data in a customized way. The approach we've been working on is to create a large application structure to hold the configuration settings for each customer. The key in the first dimension would be the customer ID number. The main config options are numbered, so Customer 1's second config option (set to Yes or No) would be referenced in a struct like this: #Application.Str_ConfigCust["1"]["2"]# Now we also need to store various other string, array and query data for quick on-the-fly access, so we're looking at also storing that at the second dim, such as: #Application.Str_ConfigCust["1"]["OtherDataArray"]# #Application.Str_ConfigCust["1"]["SomeSimpleString"]# #Application.Str_ConfigCust["1"]["SomeQuery"]# We also need to hold the order form data, and there can be multiple forms, so I figured there could be a "Form" struct at the second dimension that holds array data for each form. So #Application.Str_ConfigCust["3"]["Form"]["2"]["FormItemsArray"][5][8]# would reference the form items on row 5, column 8 on Customer 3's Order Form No. 2. I've never attempted to use arrays, structs and queries to this level of complexity, or mix and match them like this in the same structure. The advantage it seems to offer is that all config data will be held in a single structure, and it'll be easy to reference it by customer number and loop over it when needed. But it's also rather complex and the var references are long and unwieldy, so I'm having second thoughts. Also, I need to figure out whether storing all this config data in an application structure will cause memory problems. None of these arrays or queries are very large, but still... Any general comments/ideas/brickbats anyone? And how could we roughly estimate how much memory a complex structure like this will require? Gene Kraybill LPW & Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Custom Tag for Date and Time
"James Taavon" <[EMAIL PROTECTED]> wrote: > Any one have a custom tag that retrieves both the DateFormat (Now()) and > TimeFormat (Now()) as one function that can be inserted into a database? Why format it before putting it into the db? Would it work for you to simply capture the current date and time using NOW and insert that as a date-time object into a single database field? Something like: MyDateTime=#CreateODBCDateTime(Now())# Gene Kraybill LPW & Associates LLC Mansfield, PA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
