RE: CF-Studio 4.52
I am not sure about the hotkeys but the snippets are files on your hard drive. I back mine up regularly. Look in the allaire/ install directory for a directory names UserData\Snippets and just copy them to disk/network. Perhaps hotkeys are thereabouts also? Tony Gruen Development/SFNetworks [EMAIL PROTECTED] -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:38 PM To: CF-Talk Subject: Re: CF-Studio 4.52 On Fri, 05 Jan 2001 09:58:59 -0500, "Sean Daniels" [EMAIL PROTECTED] wrote: OK, so I really want to update to 4.5.2, particularly for the "remembering that your in an RDS session". However, I have customized the crap out 4.5.1 and I am scared off by these mails that say the 4.5.2 installer kills your snippet and hotkey settings. Is there any way to back these up? Or have they fixed this prob in the newest installer? - Sean I've had to reinstall Studio a number of times - new PC, then new OS, both at work and at home - and all I do to save my studio settings (esp colors - I have a highly customised color set up that takes AGES to redo) is find and save the Studio registry keys. You can do the same with the RDS/FTP key. And I always save the userdata dir and copy the contents over to the new install. The only thing to watch for is that the installed dir is the same on both the old and new installs otherwise you'll have to do some registry hacking to get it to work. HTH, K. ~~ 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: Storing images in SQL
Rick, Utilizing CF to simply identify the location of the image is simpler for several reasons. I consider myself much junior to the great minds on this forum but I will humbly offer my experience. Simply put, speed and flexibility are your bonus payoffs. Key points for flexibility are: - you can identify the base image path in your application.cfm and simply reference the image name in the database in your code/query. This is a powerful key when you get a large project with thousands of images and you can identify separate image locations by department, location, branch etcetc to suit the business needs. - We have also found great flexibility in creating client maintained admin interfaces that allow them to dynamically build their own catalogs as they get new products through an interface that they use to add items in the database and upload new images to the image location for their department. - Speed, the biggest bonus. A simple query with a result of less than 30k in data (including the image reference) is loads better than the same query returning effectively the same data at 80+kb. Multiply that times thousands of users.. etc Case in point? http://www.edwardsluggage.com I hope my 2cents helps. Tony Gruen Development/SFNetworks [EMAIL PROTECTED] -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 2:40 PM To: CF-Talk Subject: RE: Storing images in SQL Larry, I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can logically agree with you (and others who have said the same) and I too would like to be one of those well informed people that come to the same conclusion for the same reasons. Could you or anyone else familiar with the techniques required for this please elaborate on this so I can say something other than "it's a bad idea because that's what somebody said." Thanks, Rick -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:28 PM To: CF-Talk Subject: Re: Storing images in SQL Michael, In a nutshell don't. Its far faster, easier and a lot less messy to store the images's name and then dynamically construct the path information. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Michael Buffington wrote: Does anyone have any experience storing images in SQL 7.0, and retrieving them in CF? Any tips would help! Michael Buffington ~~ 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: Hierarchial Display
Wat do you mean by a tree structure? A struct with nested structs with nested structs like what WDDX gives you. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Storing images in SQL
Does anyone have any experience storing images in SQL 7.0, and retrieving them in CF? Its far faster, easier and a lot less messy to store the images's name and then dynamically construct the path information. I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can logically agree with you (and others who have said the same) and I too would like to be one of those well informed people that come to the same conclusion for the same reasons. Could you or anyone else familiar with the techniques required for this please elaborate on this so I can say something other than "it's a bad idea because that's what somebody said." There are a couple of reasons that I prefer to use the filesystem for binary data. One is that it's not especially easy to read and write binary data to and from the database from CF. Most versions of CF provide no facility for working with binary data; CF 4.5.x provides the ToBinary function, but it's still not trivial to read and write the data. In the past, I've used CFX tags to do this, but it still was more trouble than it was worth. Another is that, generally, you don't get much benefit in storing binary data in a relational database. You're not going to build a query that uses the binary data as a filtering condition; text-based relational database just don't provide any useful facility for this. Also, in my experience, the act of reading and writing binary data from the database is often slower than reading it from a filesystem. This makes sense; binary and long-text data isn't stored in the same leaf/page structure as other data within the database. Instead, the leaf or page with the selected record contains a pointer to some other data storage location which contains the actual binary data. Finally, using the database to store this data is often an unnecessary bottleneck. If, to return an image, I have to retrieve the image itself from the database, that's going to occupy a significant amount of CF's time, as CF receives the image data stream. Alternatively, if I retrieve the name and filesystem location from the database, CF can often push the work to the web server, if the files are stored in web-accessible locations. In that case, CF can be used to find the file name, then write that within an IMG tag, and that's all the work it has to do. 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: CFMAIL and hair loss?
Solved. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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: AvantGo channels w/CF?
I'm glad it worked, I also find the scheduler in CF is problematic... Thinking about it some more on a brain that's not been awake for 16 hours, you could also do it directly using cfhttp to call the page and save it to a flat file then cfinclude that file That would take out the vagaries of the cfscheduler and would be a little more streamlined -= Ed -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 2:14 AM To: CF-Talk Subject: RE: AvantGo channels w/CF? Ed, I tried this, and it did work (as it should). This might be the route I end up taking, although not as streamlined as I'd like. Thanks much, Matt -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:06 PM To: CF-Talk Subject: RE: AvantGo channels w/CF? Just an out of blue suggestion, but why don't you call a page that activates a cfschedule tag, then uses cfinclude to actually return the contents of your page... That way the AvantGo server only accesses an html page and your server does the work of rendering the page I've been playing with different aspects of AvantGo channels myself and that's the easiest way I could think of doing what you want to do. It's a faff if you've got a lot of pages Then again cfschedule is pretty flexible... Just some late night thoughts after a long day, please forgive me if it doesn't make any sense... -= Ed -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] Sent: 8 January 2001 8:03 PM To: CF-Talk Subject: AvantGo channels w/CF? Has anyone done any work with creating an AvantGo channel on a CF-based web site? (AvantGo is an offline web browser for Palms and WinCE devices) I've created a test for a client demo. It basically pulls press releases from a database, removes any HTML formatting, and outputs it as very simplified HTML for the Palm. It works fine if I load the page up in Netscape or IE, but if I add the channel to AvantGo, every time I HotSync, the RAM usage on my CF server skyrockets. I've already tried playing with caching, changing page sizes, etc and even if it is just one or two simple pages, CF begins using memory like crazy. We're running CF 4.5 sp1 on a Windows NT 4.0 server. Thanks, Matthew I. Fusfield Senior Web Systems Developer InterActive Network Systems, Inc. [EMAIL PROTECTED] - 856-227-4428 ext 15 ~~ 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: CFMAIL and hair loss? - spoke too soon
Is there a limit to the amount of text you can write in an HTML e-mail sent using CFMAIL? variables.Invoice forms the body of the e-mail. If it goes beyond about 990 bytes, you get the e-mail, but it's blank. Less than that and the e-mail is fine. And if you output the e-mails to the screen, they are OK. Any ideas? The flow is this... CFQUERY builds a list of customers Loop through the query For each iteration, run CF_Invoice for that customer CF_Invoice finds out what they should be billed and calls CF_GenerateInvoice CF_GenerateInvoice builds a webpage, "variables.Invoice", returning it to CF_Invoice CF_Invoice sends an HTML e-mail with the "variables.Invoice" as the body We've tried using different mail servers and making sure the initial query only returns one record so the loop is only run once, always with the same result. BTW, if it's a bug, who should be told? Thanks for any advice -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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: Query confusion - CF not recognising query name
Replies to all included; here's a real silly question but is cfset variables.IDCount=getPeopleInfo.RecordCount written exactly like this or is it written like cfset variables.IDCount=#getPeopleInfo.RecordCount# leaving the # off could be your problem. You are kidding, right? CF hasn't required the # within CFSET since v2 Have you run the query in a query analyzer? If so, does it return results? Also, are you catching a database error and not returning anything to the client? Not in Query Analyzer, but I know it does something as I've put some debugging code around it (getTickCount()) - but it should return 0 in the recordCount if it returns no records... It looks like your code has been greatly excerpted. There is no chance that you are setting the variable getPeopleInfo equal to some simple value and overwriting the query somewhere between the query and the loop? Is the name of the query dynamic? Sorry for the questions, but it seems very unlikely that ColdFusion would behave this way. Any additional information would be useful. These 2 commands of code are exactly as I pasted them, there isn't anything between them that could change it - I've changed the query name as well and it still does nothing... I just took out the and #PreserveSingleQuotes(variables.whereList)# --- set some variables and it worked fine for me. What's in the wherelist?? It ran fine for me. cf 4.01 on Windows 2000 server. OK, the variables.whereList contains things like "fieldName='Yes'" or "fieldName is NULL", I need the PreserveSingleQuotes otherwise it spits when you use apostrophies What about removing the "variables." scope? I even tried putting CFLOOP QUERY="getPeopleInfo" and it came back saying the query didn't exist Are you talking to SQL Server? I don't think it likes the table name "Users" Try putting square brackets around the table name, eg. "[Users]" and see if that helps. AND run it with debugging on to show the SQL and the result. This will let you know whether the SQL is actually being executed and how many rows it returns. SQL Server 7, otherwise the (nolock) wouldn't work - the table name isn't Users, that was Jeff's suggestion. I can't put debugging on as it's a production server - I don't have the data on my test machine to use, and the amount of data is huge to download As I said - it's confusing the hell out of me. Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
Hello everyone. I am running into a problem with my cfquery tag and I was wondering if anyone out there could give me a hand with this. Basically I am querying a database that has a series of records. But when I output the information from the database I only want to select the newest record that was entered. I have a field in the database that keeps track of the time and date of the information entered. Here is the query statement that I am using. I am able to sort the content depending on the date but it still spits out all of the records instead of just the "newest" one. cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC" Select * from UnitPages where ArticleUnit = '#form.units#' order by ArticleDate DESC /cfquery If anyone has an idea how to do this I would really appreciate your help. OK, firstly, if you only want to use the first record then don't let CF do it - if you have millions of records, SQL will have to hand them to CF before it can do it Try; cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC" Select top 1 * from UnitPages where ArticleUnit = '#form.units#' order by ArticleDate DESC /cfquery This will literally return the top row, and nothing else Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Does Studio have Built-in Scripting?
There is such a thing as ActiveScript in Studio so that you can build little
code things to do whatever you want. It's not hugely functional but you can
pull in COM objects to do whatever you want.
I wrote some ActiveScript to put documentation into pages that didn't have
any. Click a button, fill in a few dialogue boxes to put in specific
information then outputted as a CF comment at the end of the file. This was
then read by a browser I created. A whole documentation system. Very easy
(when you know how!).
Have a look in the Help Files in Studio at "Scripting the Visual Tools
Object Model" and then have a go. It's a bit limited and the documentation
isn't wondefully clear, but is useful when you get used to it.
Paul
PS If you want an example, here it is! Set it up as a button on a custom
toolbar, and then (it asks if you want to use a script) point the button at
the script. I hope it works!
- code example -
function Main()
var app = Application; //create application object variable
// if any text is selected, then don't continue
message = "This is a pre-alpha version of cfdoc vtom.\n";
message = message + "This will add in cfdoc documentation at the end of
the file.\n";
message = message + "If you do not want this, press cancel. Otherwise,
enjoy!";
// ask if you want to continue
check = app.MessageBox(message,"",1);
if (check == 1) {
// set up the start and end of cfdoc variables that we will be using
start_cfdoc = "\n\n!---\n=cfdoc\n";
end_cfdoc = "\n=endcfdoc\n ---\n";
// get head_text user input
default_head_text = "Insert Heading";
head_text = app.InputBox("Please insert a cfdoc heading:","Input
Heading",default_head_text);
head = "\n=head '" + head_text + "'\n";
// if head_text is nothing or is "Heading" (default) then end
if ( head_text == default_head_text ) {
head_text = "";
app.MessageBox("You have not entered a heading. An empty header
will be inserted.","",48);
}
// add in subheadings
no_more_cfdoc = "continue";
body_text = "";
sub_head = "\n\n=subhead '";
end_sub_head = "'\n";
i = 0;
i_max = 10;
next = "";
app.MessageBox("This dialogue will allow you to add subheading and
text for up to " + i_max + " subheadings.","",48);
for (i = 0; i i_max; i++) {
if (i != 0) {
next = "";
}
sub_head_text = app.InputBox("Please add " + next +
"sub-heading.", "Please add " + next + "sub-heading.", "");
next_sub_head = sub_head + sub_head_text + end_sub_head;
next_sub_head_body = app.InputBox("Please input the text for the
subheading","Please input the text for the subheading","");
body_text = body_text + next_sub_head + next_sub_head_body;
// see if they want to add more documentation
add_more_documentation = app.MessageBox("Add more cfdoc?","Add
more cfdoc?",4);
if (add_more_documentation == 7 ) {
i = i_max;
}
}
// while (no_more_cfdoc != "yes");
// retrieve text of file
file_text = app.ActiveDocument.Text;
// set up cfdoc documentation
cfdoc_documentation = start_cfdoc + head + body_text + end_cfdoc;
// output entire text
app.ActiveDocument.Text = file_text + cfdoc_documentation;
err_msg = "";
}
// wait 1/2 second and then output thank you message
app.Wait(500);
check = app.MessageBox("Thank you for your interest in cfdoc
documentation system.\n For more information, contact:\n\nPaul
Johnston\n\[EMAIL PROTECTED]","",1);
// get rid of the object reference
app = "";
}
- code example -
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:16 PM
To: CF-Talk
Subject: RE: Does Studio have Built-in Scripting?
I use Note Tab because of it's internal scripting language or I use my
DevAssistant. The DevAssistant is CF based and can build forms,stored
procedures, and more.
-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:15 PM
To: CF-Talk
Subject: Re: Does Studio have Built-in Scripting?
I just wish that Studio had an "on the fly" MACROS capability to capture
and replay keystrokes or mouse clicks -- man would that save a big bunch
of
time (and brain cells) when doing detailed, redundant, repetitive work.
I ususally end up writing small vb aps that use the windows api functions to
create macros. Sure, it takes a little bit more time than if there were
macros, but you have more flexibility and much more power that way. Visual
Basic isn't a difficult language to learn either. Go down to your local
software store and pick up Microsoft's Learn Visual Basic 6
RE: CPU 100% (again, sorry) - with screen shot and theory :)
Perhaps this can help someone help me: screen shot of the performance monitor thingy on the task manager when CF has its fit: http://www.argl.be/images/cf_yuk.gif. The first arrow points to my loading this EXACT page: ---cutstuderen.cfm--cut--- table align="right" cellpadding=5 cellspacing=0 border=1 bgcolor="#ee" trtd bgcolor="#dd"bInhoud/b/td/tr trtdiWelkom/ibr a href="studeren.cfm"Inleiding/abr Planning Het leren vergemakkelijken Studiemethode Leren en zelfcontrole Uit fouten leren Invloed van de ouders /td /tr trtd bgcolor="#dd"bDownload/b/td/tr trtda href="download/reglement.doc"Zelfstandig studeren/a (MS Word)br a href="download/leren_bijlage.xls"Bijlagen/a (MS Excel) /td /tr /table h1Leidraad bij het zelfstandig leren studeren/h1 pAls ouder leeft u intens mee met het wel en wee van uw kind op school. Heeft u even de tijd om hierbij stil te staan? Spiegeltje, spiegeltje aan de wand, ... ---cutstuderen.cfm--cut--- CPU goes to 100% stays there for a while, and then drops to about 50%. The second arrow indicates when I reloaded the same page. CPU to 100% again, stays there for while longer and then drops to about 25%. And it stays there until the browser times out. When I rename the file to "leren.cfm", it loads without any problems whatsoever. My theory: somehow while compiling the page to PCode (or whatever it is CF uses internally) something goes wrong. Perhaps a corrupt file is generated, or an empty file, or whetever. And even rebooting the server doesn't right what went wrong. Even modifying the content of the file and thus resetting the last modified date/time doesn't do anything. All this on CF 4.5.1sp2, NT4sp6a, dual PII 512 MB RAM, plenty HD (10 Gb or so free) with NO database access of any kind. Help! Help! Help! Michel Vuijlsteke Netpoint NV -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:03 AM To: CF-Talk Subject: CPU 100% (again, sorry) Sorry to post about this again, but I went through the archives and did not see any definitive resolution of the problem. We've had some problems on one particular server and always put it down to bad code, but it turns out the dreaded 100% CPU utilization bug is spreading to our other servers too. Was the problem ever solved satisfactorily? Or pinpointed to a particular release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)? Michel Vuijlsteke Netpoint NV ~~ 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
Thats Sql Server only (access too?) . cfquery maxrows=1 might be better Justin cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC" Select top 1 * from UnitPages where ArticleUnit = '#form.units#' order by ArticleDate DESC /cfquery This will literally return the top row, and nothing else ~~ 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: Query confusion - CF not recognising query name
Why not put debugging on for your IP only??? I can't put debugging on as it's a production server - I don't have the data on my test machine to use, and the amount of data is huge to download As I said - it's confusing the hell out of me. Philip Arnold Also you chould RUN SQLtrace to see whats going on. These kind of issues Usually are a result of silly mistakes. I know mind are. Get someone else there to look at the code, might pick it up staight away. Justin MacCarthy ~~ 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
Thats Sql Server only (access too?) Access too. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC" Select top 1 * from UnitPages where ArticleUnit = '#form.units#' order by ArticleDate DESC /cfquery This will literally return the top row, and nothing else Thats Sql Server only (access too?) . cfquery maxrows=1 might be better It's pretty much all SQL flavors - Access does it And, as I said, maxrows can cause speed issues if you have loads of rows, but only let CF display one - some of my tables have tens of millions of rows - can you imagine getting all of that to CF to let it display the first one? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 12:32 To: CF-Talk Subject: RE: cfquery ~~ 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
CF in South Carolina??
Hey everyone: Is just my imagination, or am I the only CF programmer user in South Carolina. It seems the Palmetto state is addicted to M$ and AS400. Rick ~~ 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: Query confusion - CF not recognising query name
Phillip, A couple of suggestions. I use debugging on a production servers all the time. If you have access to the CF Admin, I turn on debugging for my IP address. Since I'm on dial-up and my ISP drops my connection all the time. I have to change IP addresses that the debug shows on about every half hour. While I'm debugging. When I don't have the luxury of turning on debug. I use this to see what is being passed. cfif #cgi.Remote_addr# is "123.456.789.123" cfoutput Whatever variables I'm looking to trace. #PreserveSingleQuotes(variables.whereList)# #variables.peopletable# #variables.idlist# #form.orderby# /cfoutput /cfif I did run your query against one of my usertables and it ran fine without the wherelist and got the idcount to showup I'm guessing you have some record(s) with special characters that are causing the problem. Just try to get one record to work see if the problem is in the code or a record issue. ~~ 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 in South Carolina??
Rick- No! There are 8 Coldfusion developers where I work- from senior to just learning! Also, Bosch Automotive in Charleston uses CF for some intranet type projects, and I can think of several other businesses or individuals who use CF. ;-) Kurt -Original Message- From: Richard L Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 8:23 AM To: CF-Talk Subject: CF in South Carolina?? Hey everyone: Is just my imagination, or am I the only CF programmer user in South Carolina. It seems the Palmetto state is addicted to M$ and AS400. Rick ~~ 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: Query confusion - CF not recognising query name
Why not put debugging on for your IP only??? D'OH - forgot you could do that... Also you chould RUN SQLtrace to see whats going on. These kind of issues Usually are a result of silly mistakes. I know mind are. Get someone else there to look at the code, might pick it up staight away. 2 of us spent 45 minutes looking at it before I hit CF-Talk... Here's the bigger confusion - I've changed nothing on the code and it's now started working... I haven't even upload another version of the template since I sent the first message - the CFServer service has been Stop/Started several times since, but also many times during the problem Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
Where is the application.cfm and onrequestend.cfm with all of this. If there isn't a copy of those 2 files in the directory for this site it will recurse until it finds one. Maybe there is an application.cfm and or onrequestend.cfm page somewhere that is doing some wierd stuff. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 7:00 AM To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) Perhaps this can help someone help me: screen shot of the performance monitor thingy on the task manager when CF has its fit: http://www.argl.be/images/cf_yuk.gif. The first arrow points to my loading this EXACT page: ---cutstuderen.cfm--cut--- table align="right" cellpadding=5 cellspacing=0 border=1 bgcolor="#ee" trtd bgcolor="#dd"bInhoud/b/td/tr trtdiWelkom/ibr a href="studeren.cfm"Inleiding/abr Planning Het leren vergemakkelijken Studiemethode Leren en zelfcontrole Uit fouten leren Invloed van de ouders /td /tr trtd bgcolor="#dd"bDownload/b/td/tr trtda href="download/reglement.doc"Zelfstandig studeren/a (MS Word)br a href="download/leren_bijlage.xls"Bijlagen/a (MS Excel) /td /tr /table h1Leidraad bij het zelfstandig leren studeren/h1 pAls ouder leeft u intens mee met het wel en wee van uw kind op school. Heeft u even de tijd om hierbij stil te staan? Spiegeltje, spiegeltje aan de wand, ... ---cutstuderen.cfm--cut--- CPU goes to 100% stays there for a while, and then drops to about 50%. The second arrow indicates when I reloaded the same page. CPU to 100% again, stays there for while longer and then drops to about 25%. And it stays there until the browser times out. When I rename the file to "leren.cfm", it loads without any problems whatsoever. My theory: somehow while compiling the page to PCode (or whatever it is CF uses internally) something goes wrong. Perhaps a corrupt file is generated, or an empty file, or whetever. And even rebooting the server doesn't right what went wrong. Even modifying the content of the file and thus resetting the last modified date/time doesn't do anything. All this on CF 4.5.1sp2, NT4sp6a, dual PII 512 MB RAM, plenty HD (10 Gb or so free) with NO database access of any kind. Help! Help! Help! Michel Vuijlsteke Netpoint NV -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:03 AM To: CF-Talk Subject: CPU 100% (again, sorry) Sorry to post about this again, but I went through the archives and did not see any definitive resolution of the problem. We've had some problems on one particular server and always put it down to bad code, but it turns out the dreaded 100% CPU utilization bug is spreading to our other servers too. Was the problem ever solved satisfactorily? Or pinpointed to a particular release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)? Michel Vuijlsteke Netpoint NV ~~ 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: DELPHI - where does it fit in the scheme of things?
We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --min ~~ 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: Query confusion - CF not recognising query name
A couple of suggestions. I use debugging on a production servers all the time. If you have access to the CF Admin, I turn on debugging for my IP address. Since I'm on dial-up and my ISP drops my connection all the time. I have to change IP addresses that the debug shows on about every half hour. While I'm debugging. I have a fixed IP, so I've now got debugging permanently on form me only When I don't have the luxury of turning on debug. I use this to see what is being passed. cfif #cgi.Remote_addr# is "123.456.789.123" cfoutput Whatever variables I'm looking to trace. #PreserveSingleQuotes(variables.whereList)# #variables.peopletable# #variables.idlist# #form.orderby# /cfoutput /cfif I checked all of these when I was having the problem - I just couldn't talk to the query although the SQL was running I did run your query against one of my usertables and it ran fine without the wherelist and got the idcount to showup I'm guessing you have some record(s) with special characters that are causing the problem. In that table there's only a few fields - most of which are INT, but since it's working again, I can't trace the problem again Just try to get one record to work see if the problem is in the code or a record issue. I tried that - it just wouldn't talk to the query Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Replacing Special Characters in Database
Since the database is in Access, you can export the table to a text file, manipulate the data using find and replace functions in many editors, and import the data back in. The database is live, but I would expect your product table is static enough to not change while you do the data cleanup. Studio's Find and Replace is very good, but if you can't locate the bad characters, you might need something more powerful like Word. Bob. - Original Message - From: "Josh R" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 9:23 PM Subject: Replacing Special Characters in Database OK, here's the problem. We had to import our old databse into MS Access 97 and found that all the special characters in a memo field for product descriptions have gone crazy. ô and ö replaced ", ù replaced -, Æ replaced ', etc. So I need to go into the 2000+ fields we have and replace all these characters back to their proper settings without destroying the descriptions. (I tried using a query and looping over the replace feature, but it pasted the first description into all the other 2000 fields. NOT GOOD.) What's the safest way to do this on a live databse? Thanks for your help. Josh Rubak [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: DELPHI - where does it fit in the scheme of things?
For those that are using Delphi, what role does it play in the internet? Is it being used strictly for COM access with CF, or are there hidden web abilities some of us may be unaware of? At 07:45 AM 1/9/01 -0600, you wrote: We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --min ~~ 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: DELPHI - where does it fit in the scheme of things?
We use it for all of our COM stuff and for all of our stand alone Windows apps. Delphi can be used as a CGI by using its ISAPI capabilities. There are those that argue that Delphi's ISAPI is superior(in speed) to ASP,CF, or whatever. I still think that it is personal preference as to what any developer uses. I am not sure how you would set up your web server to use Delphi's ISAPI, but it is an option that you have. One thing we consider when we are trying to decide what 'Technology' to use, is when the person who creates this app is gone, how hard is it to find good CF,ASP, or Delphi programmers? HTH, Clint -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 7:50 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? For those that are using Delphi, what role does it play in the internet? Is it being used strictly for COM access with CF, or are there hidden web abilities some of us may be unaware of? At 07:45 AM 1/9/01 -0600, you wrote: We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --min ~~ 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: DELPHI - where does it fit in the scheme of things?
Delphi is a client/server RAD development tool, developed by Borland (Inprise or whatever they are called this days). Main competitors are (were) Visual Basic and PowerBuilder. If I'm not mistaken ColdFusion Studio was built using Delphi. form more information go to Borland home page. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 8:50 AM Subject: RE: DELPHI - where does it fit in the scheme of things? For those that are using Delphi, what role does it play in the internet? Is it being used strictly for COM access with CF, or are there hidden web abilities some of us may be unaware of? At 07:45 AM 1/9/01 -0600, you wrote: We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --min ~~ 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
RequestTimeout
I have a query that takes a while to produce results. It takes longer then the allowed 75sec timeout period. I've put the ?RequestTimeout=500 on the url but I continue to get the error msg about the 75sec timeout period. Why is this override not working or is there something else I should try? ~~ 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: Storing images in SQL
One of the "smaller" issues is backing up.. if the images are stored in the database, they will also be backed up every time you back up the database. If you have a lot of graphics, it will greatly increase the costs (time, media and slowing down the website) to do your daily backups.. If the graphics are stored on the server, you only have to back them up from your development machine. Al Musella a1webs.com There are a lot of other smaller issues, such as the way ColdFusion handles binary data and how that data is transferred between the database server and the ColdFusion application server, but hopefully the above description will give you a general idea of why developers always caution against storing image data directly in the database. ~~ 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
Stripping CRs and LFs
What is the best way to strip CRs and LFs from a string? StripCR() gets the CRsbut I still have linefeeds (or CR/LF combos...) left in the string. I am doing this as part of cleaning up data from an SQL server to put into a ..CSV file...and well, CSV doesn't handle random CR/LF very well :-) Thanks in advance... --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. ~~ 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: DELPHI - where does it fit in the scheme of things?
I remember that Nick Bradbury's original releases of Homesite (before HS was bought by Allaire, which begat CFStudio...) was a Delphi app. It would stand to reason, then, that the current releases at least have some Delphi floating around in them. And wasn't there a known bug with how Delphi handled Z-Order that caused CFStudio/HS that caused it not to "pop forward" on window focus? I recall having a problem with this at the previous job, and I think it was attributed to a Delphi glitch. I can't remember exactly. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Marius Milosav [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 09, 2001 9:00 AM Subject: Re: DELPHI - where does it fit in the scheme of things? Delphi is a client/server RAD development tool, developed by Borland (Inprise or whatever they are called this days). Main competitors are (were) Visual Basic and PowerBuilder. If I'm not mistaken ColdFusion Studio was built using Delphi. form more information go to Borland home page. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 8:50 AM Subject: RE: DELPHI - where does it fit in the scheme of things? For those that are using Delphi, what role does it play in the internet? Is it being used strictly for COM access with CF, or are there hidden web abilities some of us may be unaware of? At 07:45 AM 1/9/01 -0600, you wrote: We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --min ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
At 08:44 1/9/01 -0500, you wrote: Where is the application.cfm and onrequestend.cfm with all of this. If there isn't a copy of those 2 files in the directory for this site it will recurse until it finds one. Maybe there is an application.cfm and or onrequestend.cfm page somewhere that is doing some wierd stuff. Actually it looks for onrequestend.cfm wherever it finds application.cfm. It will not keep looking past the directory where it finds application.cfm for onrequestend.cfm. I don't know what happens if it finds onrequestend.cfm before it finds application.cfm Ryan ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
you sure on that??? I often use onrequestend in places where I dont use application.cfm - primarily for debugging... -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 14:25 To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) At 08:44 1/9/01 -0500, you wrote: Where is the application.cfm and onrequestend.cfm with all of this. If there isn't a copy of those 2 files in the directory for this site it will recurse until it finds one. Maybe there is an application.cfm and or onrequestend.cfm page somewhere that is doing some wierd stuff. Actually it looks for onrequestend.cfm wherever it finds application.cfm. It will not keep looking past the directory where it finds application.cfm for onrequestend.cfm. I don't know what happens if it finds onrequestend.cfm before it finds application.cfm Ryan ~~ 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: Multiple Resultsets from a Stored Procedure
We use multiple resultsets (up to 4) with Sybase stored procedures and it works fine. We're using the native drivers not ODBC. I don't know about any CF preferences or limitations with them. Karen Jefferson VetCentric -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:20 PM To: CF-Talk Subject:RE: Multiple Resultsets from a Stored Procedure To be more specific -- I get the error: ODBC Error Code = S1002 (Invalid column number) [INTERSOLV][ODBC SQL Server driver]Number of bound columns exceeds the number of result columns. I have just discovered that there are no problems with the 3rd resultset, but the first two give me problems. Could this be within the stored procedure then? It runs fine through DBArtisan, but does Cold Fusion have preferences here? Thanks again. Lisa Haas -Original Message- From: Haas, Lisa Sent: Monday, January 08, 2001 2:19 PM To: '[EMAIL PROTECTED]' Subject: Multiple Resultsets from a Stored Procedure I have always had trouble in handling output from stored procedures with more than one result set. I am using the resultset attribute of cfprocresult with a Sybase stored procedure. Has anyone else run into this or come up with some reasons why this is such a problem? Thanks. Lisa Haas The Kennedy Center ~~ 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: Stripping CRs and LFs
Couldn't you replace all instances of Chr(13) (I think that's right...) with a null? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 09, 2001 9:13 AM Subject: Stripping CRs and LFs What is the best way to strip CRs and LFs from a string? StripCR() gets the CRsbut I still have linefeeds (or CR/LF combos...) left in the string. I am doing this as part of cleaning up data from an SQL server to put into a ..CSV file...and well, CSV doesn't handle random CR/LF very well :-) Thanks in advance... --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. ~~ 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: Stripping CRs and LFs
What is the best way to strip CRs and LFs from a string? cfset crlf = chr(13)chr(10) cfset stripped = replacelist(myString,crlf,"") Should do the trick. - Sean ~~ 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: Storing images in SQL
Rick, Others have dealt with speed and storage issues regarding images and databases. Here's how I handle things. Rather than calling a BLOB object. What happens when your client wants to change a significant proportion of the images - its much easier copying the new images to the appropriate directory than inserting the images into the database. Secondly, speed. To display the images, it requires a database call, that is slower than the img src=" tag. Just two issues to consider. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Rick Lamb wrote: Larry, I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can logically agree with you (and others who have said the same) and I too would like to be one of those well informed people that come to the same conclusion for the same reasons. Could you or anyone else familiar with the techniques required for this please elaborate on this so I can say something other than "it's a bad idea because that's what somebody said." Thanks, Rick ~~ 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: Stripping CRs and LFs
Use the Replace function. The best way is to do a replace for CR and then one for LF. as they could be in any order, generally though it should be CRLF. The character codes for LF is 10 and CR is 13 (I think!). I this should work cfset x=#Replace(x,chr(13),"","ALL")# cfset x=#Replace(x,chr(10),"","ALL")# HTH Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bryan Batchelder [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 14:19 To: CF-Talk Subject: Stripping CRs and LFs What is the best way to strip CRs and LFs from a string? StripCR() gets the CRsbut I still have linefeeds (or CR/LF combos...) left in the string. I am doing this as part of cleaning up data from an SQL server to put into a ...CSV file...and well, CSV doesn't handle random CR/LF very well :-) Thanks in advance... --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
There is no application or onrequestend anywhere in sight. I removed those on purpose because they _do_ contain calls to a database and more compicated ColdFusion. There's no issue of looking for those files "higher up" either: all files are in the root directory of a virtual server (http://www.ransel.be if you're curious) (no files there now, sorry, don't want my test server to crash all the time :). Michel Vuijlteke -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 2:44 PM To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) Where is the application.cfm and onrequestend.cfm with all of this. If there isn't a copy of those 2 files in the directory for this site it will recurse until it finds one. Maybe there is an application.cfm and or onrequestend.cfm page somewhere that is doing some wierd stuff. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 7:00 AM To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) Perhaps this can help someone help me: screen shot of the performance monitor thingy on the task manager when CF has its fit: http://www.argl.be/images/cf_yuk.gif. The first arrow points to my loading this EXACT page: ---cutstuderen.cfm--cut--- table align="right" cellpadding=5 cellspacing=0 border=1 bgcolor="#ee" trtd bgcolor="#dd"bInhoud/b/td/tr trtdiWelkom/ibr a href="studeren.cfm"Inleiding/abr Planning Het leren vergemakkelijken Studiemethode Leren en zelfcontrole Uit fouten leren Invloed van de ouders /td /tr trtd bgcolor="#dd"bDownload/b/td/tr trtda href="download/reglement.doc"Zelfstandig studeren/a (MS Word)br a href="download/leren_bijlage.xls"Bijlagen/a (MS Excel) /td /tr /table h1Leidraad bij het zelfstandig leren studeren/h1 pAls ouder leeft u intens mee met het wel en wee van uw kind op school. Heeft u even de tijd om hierbij stil te staan? Spiegeltje, spiegeltje aan de wand, ... ---cutstuderen.cfm--cut--- CPU goes to 100% stays there for a while, and then drops to about 50%. The second arrow indicates when I reloaded the same page. CPU to 100% again, stays there for while longer and then drops to about 25%. And it stays there until the browser times out. When I rename the file to "leren.cfm", it loads without any problems whatsoever. My theory: somehow while compiling the page to PCode (or whatever it is CF uses internally) something goes wrong. Perhaps a corrupt file is generated, or an empty file, or whetever. And even rebooting the server doesn't right what went wrong. Even modifying the content of the file and thus resetting the last modified date/time doesn't do anything. All this on CF 4.5.1sp2, NT4sp6a, dual PII 512 MB RAM, plenty HD (10 Gb or so free) with NO database access of any kind. Help! Help! Help! Michel Vuijlsteke Netpoint NV -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:03 AM To: CF-Talk Subject: CPU 100% (again, sorry) Sorry to post about this again, but I went through the archives and did not see any definitive resolution of the problem. We've had some problems on one particular server and always put it down to bad code, but it turns out the dreaded 100% CPU utilization bug is spreading to our other servers too. Was the problem ever solved satisfactorily? Or pinpointed to a particular release (we're using 4.5.1sp1 but upgrading to 4.5.1sp2)? Michel Vuijlsteke Netpoint NV ~~ 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: Multiple Resultsets from a Stored Procedure
When you say that the third select is the one which returns the data, do you mean successfully, while the other two fail? Or that the first two selects do not return data because they are not supposed to? I assume it's the former. It sounds like if you run it with only one crprocresult tag, where resultset="3", it works fine. Which leads me to ask: Are the first two returning recordsets or variables? If you have always had trouble with multiple result sets, there's definitely a pattern there. Maybe you could switch two of the select statements in the stored proc (for testing). Call the third select when it's in different positions (and with a different number). If your problem has to do with only retrieving the last recordset, (i.e. the last one only works each time, whichever one is last), then this will at least focus your attention on that. Otherwise you can focus on the select statements. Mark I have all the variables in the correct order - the procedure will run fine - the errors come into play when I add the cfprocresult tag for resultset one and two. There are three main select statements in the procedure (the third being the simplest and the one which returns the data). They are not separated in the stored procedure (no begin/end or anything) - could this possibly be the problem? I have never managed to have a stored procedure with multiple resultsets work (with this particular sp writer) with the exception of the last returned resultset. Any ideas are greatly appreciated. Lisa Haas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:21 PM To: [EMAIL PROTECTED] Subject: RE: Multiple Resultsets from a Stored Procedure Yeah, that confuses me too. That's one for the list at large - although not necessarily relevant to the current problem. My guess is the Microsoft makes the odbc drivers, and that they're SQL Server compatible; Sybase and SQL Server have an intertwined history after all. Are there other pages you have where multiple resultsets work? Mark Also - I'm not sure why it says [INTERSOLV][ODBC SQL Server driver] since I am using a Sybase System 11 driver... Lisa -Original Message- From: Haas, Lisa Sent: Monday, January 08, 2001 3:55 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple Resultsets from a Stored Procedure Yes - see below: What I'm now finding is that the third resultset has no problem. The first two give me the error ODBC Error Code = S1002 (Invalid column number) Number of bound columns exceeds the number of result columns. cfstoredproc procedure="mcc_renewal_epatron" datasource="mcc" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@season" value="C2002" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_series" value="CJO" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@end_series" value="CJO" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_package" value="CJ2" cfprocparam type="in" cfsqltype="CF_SQL_CHAR" dbvarname="@end_package" value="CJ2" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@group" null="Yes" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@code" null ="Yes" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@value" null="Yes" cfprocresult name="sub_info" resultset="1" cfprocresult name="patron_info" resultset="2" cfprocresult name="seat_info" resultset="3" /cfstoredproc ~~ 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: CFMAIL High Volume
we use ListServ HPO version www.lsoft.com touted as the best there is currently. We enjoy it. But it costs many $1000's, AND per year, which are enjoyable otherwise. This may be considered an "unfair comment" in a commercial software forum, but I have delivered a sustained 1000 msgs/minute using open source software with a mono-CPU Intel box. I did it for a Lyris refugee just last weekend who had been paying $2500/month for a Lyris unlimited project. He pays no more. The trick to overcome CFmail's eternally sucky SMTP client is to ask it only to hose the data across the room to the ip of an open source box wit a real MTA that does the actual queueing, delivery, retries. Len http://BIND8NT.MEIway.com : Binary for ISC BIND 8.2.3 T9B for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-spam mail gateways ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
There's no issue of looking for those files "higher up" either: all files are in the root directory of a virtual server (http://www.ransel.be if you're curious) (no files there now, sorry, don't want my test server to crash all the time :). Just as a warning, but CF doesn't stop looking for Application.cfm in the root directory of a virtual server. It'll go up to the root of the drive! At least, that's been how it's behaved in the past. I haven't tested this in CF 4.5.1 SP2. 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: Stripping CRs and LFs
Ahh, darnit, I used Replace before, using Chr(10) and Chr(13) but forgot about the scope portion of Replaceguess I thought it was optional. thanks for the help everyone. --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:36 AM To: CF-Talk Subject: Re: Stripping CRs and LFs Couldn't you replace all instances of Chr(13) (I think that's right...) with a null? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 09, 2001 9:13 AM Subject: Stripping CRs and LFs What is the best way to strip CRs and LFs from a string? StripCR() gets the CRsbut I still have linefeeds (or CR/LF combos...) left in the string. I am doing this as part of cleaning up data from an SQL server to put into a ..CSV file...and well, CSV doesn't handle random CR/LF very well :-) Thanks in advance... --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
Actually it looks for onrequestend.cfm wherever it finds application.cfm. It will not keep looking past the directory where it finds application.cfm for onrequestend.cfm. I don't know what happens if it finds onrequestend.cfm before it finds application.cfm you sure on that??? I often use onrequestend in places where I dont use application.cfm - primarily for debugging... I'm sure on that. If you use an onrequestend.cfm in a directory which doesn't have an Application.cfm, the onrequestend.cfm will be ignored. It doesn't matter whether an upward search of the directory tree would find onrequestend.cfm first, or Application.cfm. Either way, CF only looks for onrequestend.cfm in the same directory in which it found Application.cfm. 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
SSL
I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nathan Stanford www.cftipsplus.com Free CF weekly e-zine ~~ 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: SSL
I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? In a word - NO! If it was, all of my shopping carts and secure forms wouldn't work, but they do Remember that CF is only running the request, it doesn't care if it's secure or not - that's down to the web server Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: SSL
Do you also use cfincludes in the ssl page? -Original Message- From: Kurt Ward [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:26 AM To: CF-Talk Subject: RE: SSL Not true. We are currently using 4-5 custom tags in templates that include everything from the header to the footer. Kurt -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:23 AM To: CF-Talk Subject: SSL I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nathan Stanford www.cftipsplus.com Free CF weekly e-zine ~~ 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: SSL
My experience is that you can use at least includes, provided that you have a copy in the SSL directory as well as the non-SSL directory. Dave - Original Message - From: "Nathan Stanford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 10:23 AM Subject: SSL I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nathan Stanford www.cftipsplus.com Free CF weekly e-zine ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
wow - I never knew that... I've just tested it and tthat does appear to be the case... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 15:09 To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) Actually it looks for onrequestend.cfm wherever it finds application.cfm. It will not keep looking past the directory where it finds application.cfm for onrequestend.cfm. I don't know what happens if it finds onrequestend.cfm before it finds application.cfm you sure on that??? I often use onrequestend in places where I dont use application.cfm - primarily for debugging... I'm sure on that. If you use an onrequestend.cfm in a directory which doesn't have an Application.cfm, the onrequestend.cfm will be ignored. It doesn't matter whether an upward search of the directory tree would find onrequestend.cfm first, or Application.cfm. Either way, CF only looks for onrequestend.cfm in the same directory in which it found Application.cfm. 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: SSL
Yes we use cfincludes. The other posts tell the whole story: CF assembles the HTML content to send to the browser, leaving the web server with the task of dealing with SSL. -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:36 AM To: CF-Talk Subject: RE: SSL Do you also use cfincludes in the ssl page? -Original Message- From: Kurt Ward [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:26 AM To: CF-Talk Subject: RE: SSL Not true. We are currently using 4-5 custom tags in templates that include everything from the header to the footer. Kurt -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:23 AM To: CF-Talk Subject: SSL I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nathan Stanford www.cftipsplus.com Free CF weekly e-zine ~~ 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: SSL
Anybody using stuff like http://www.rainbow.com/ncdb/ACCEL.PDF to speed up SSL and offload encryption from the main CPU? Len http://BIND8NT.MEIway.com : Binary for ISC BIND 8.2.3 T9B for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-spam mail gateways ~~ 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: SSL
On 1/9/01, Nathan Stanford penned: I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nope. Do it all the time. -- 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: SSL
Huh? SSL is a delivery method, a networking thing. Custom Tags are at the application level. Technology wise we're talking apple and oranges. What he might have been trying to say is that you SHOULDN'T use custom tags on something that you want to be secure. Extend that as a company policy and it could become CAN'T DO IT. If you're going to take the trouble to secure it using SSL, its real annoying if someone hacks your server and inserts a CF_MAIL in your custom tag... Brian -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:23 AM To: CF-Talk Subject: SSL I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nathan Stanford www.cftipsplus.com Free CF weekly e-zine ~~ 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: SSL
Thanks, That is the ammunition I needed. -Original Message- From: Kurt Ward [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:43 AM To: CF-Talk Subject: RE: SSL Yes we use cfincludes. The other posts tell the whole story: CF assembles the HTML content to send to the browser, leaving the web server with the task of dealing with SSL. -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:36 AM To: CF-Talk Subject: RE: SSL Do you also use cfincludes in the ssl page? -Original Message- From: Kurt Ward [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:26 AM To: CF-Talk Subject:RE: SSL Not true. We are currently using 4-5 custom tags in templates that include everything from the header to the footer. Kurt -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:23 AM To: CF-Talk Subject: SSL I am told by my fellow developer that you can not use custom tags and includes in a page that is using SSL? Is this true? Nathan Stanford www.cftipsplus.com Free CF weekly e-zine ~~ 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
application scope vs request scope
This is a question for those of you in the know... Is there an advantage to putting application variables into the request scope instead of having application variables around a conditionaly statement to only load once per timeout. So in your Application.cfm one would have cfscript request.applicationVar1 = 1; request.applicationVar2 = 2; request.applicationVar3 = 3; /cfscript instead of cfif cfscript application.applicationVar1 = 1; application.applicationVar2 = 2; application.applicationVar3 = 3; /cfscript /cfif ~~ 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: CPU 100% (again, sorry) - with screen shot and theory :)
So no more 100%? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:38 AM To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) wow - I never knew that... I've just tested it and tthat does appear to be the case... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 15:09 To: CF-Talk Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :) Actually it looks for onrequestend.cfm wherever it finds application.cfm. It will not keep looking past the directory where it finds application.cfm for onrequestend.cfm. I don't know what happens if it finds onrequestend.cfm before it finds application.cfm you sure on that??? I often use onrequestend in places where I dont use application.cfm - primarily for debugging... I'm sure on that. If you use an onrequestend.cfm in a directory which doesn't have an Application.cfm, the onrequestend.cfm will be ignored. It doesn't matter whether an upward search of the directory tree would find onrequestend.cfm first, or Application.cfm. Either way, CF only looks for onrequestend.cfm in the same directory in which it found Application.cfm. 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: DELPHI - where does it fit in the scheme of things?
If I'm not mistaken ColdFusion Studio was built using Delphi. form more information go to Borland home page. Think you a right. I seem to remember one of the Allaire beta guys mentioning that this was the case ~~ 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
Contract
Hi All, I am new as an independent developer. Can you please direct me to sites on software contract Writting. 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: DELPHI - where does it fit in the scheme of things?
Yeah, its all Delphi based. I recall this, because the Allaire developers said they would not port CF Studio to linux until Delphi showed up there (which it is about to...so maybe they will port it soon :-) --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. -Original Message- From: JayB [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 10:55 AM To: CF-Talk Subject: Re: DELPHI - where does it fit in the scheme of things? If I'm not mistaken ColdFusion Studio was built using Delphi. form more information go to Borland home page. Think you a right. I seem to remember one of the Allaire beta guys mentioning that this was the case ~~ 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: Multiple Resultsets from a Stored Procedure
That was a good idea. It is only returning the last resultset no matter which select statement is last. Is there something that needs to separate each select (begin/end statements, etc.) in order for CF to see it as a distinct resultset? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:51 AM To: CF-Talk Subject: RE: Multiple Resultsets from a Stored Procedure When you say that the third select is the one which returns the data, do you mean successfully, while the other two fail? Or that the first two selects do not return data because they are not supposed to? I assume it's the former. It sounds like if you run it with only one crprocresult tag, where resultset="3", it works fine. Which leads me to ask: Are the first two returning recordsets or variables? If you have always had trouble with multiple result sets, there's definitely a pattern there. Maybe you could switch two of the select statements in the stored proc (for testing). Call the third select when it's in different positions (and with a different number). If your problem has to do with only retrieving the last recordset, (i.e. the last one only works each time, whichever one is last), then this will at least focus your attention on that. Otherwise you can focus on the select statements. Mark I have all the variables in the correct order - the procedure will run fine - the errors come into play when I add the cfprocresult tag for resultset one and two. There are three main select statements in the procedure (the third being the simplest and the one which returns the data). They are not separated in the stored procedure (no begin/end or anything) - could this possibly be the problem? I have never managed to have a stored procedure with multiple resultsets work (with this particular sp writer) with the exception of the last returned resultset. Any ideas are greatly appreciated. Lisa Haas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:21 PM To: [EMAIL PROTECTED] Subject: RE: Multiple Resultsets from a Stored Procedure Yeah, that confuses me too. That's one for the list at large - although not necessarily relevant to the current problem. My guess is the Microsoft makes the odbc drivers, and that they're SQL Server compatible; Sybase and SQL Server have an intertwined history after all. Are there other pages you have where multiple resultsets work? Mark Also - I'm not sure why it says [INTERSOLV][ODBC SQL Server driver] since I am using a Sybase System 11 driver... Lisa -Original Message- From: Haas, Lisa Sent: Monday, January 08, 2001 3:55 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple Resultsets from a Stored Procedure Yes - see below: What I'm now finding is that the third resultset has no problem. The first two give me the error ODBC Error Code = S1002 (Invalid column number) Number of bound columns exceeds the number of result columns. cfstoredproc procedure="mcc_renewal_epatron" datasource="mcc" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@season" value="C2002" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_series" value="CJO" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@end_series" value="CJO" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_package" value="CJ2" cfprocparam type="in" cfsqltype="CF_SQL_CHAR" dbvarname="@end_package" value="CJ2" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@group" null="Yes" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@code" null ="Yes" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@value" null="Yes" cfprocresult name="sub_info" resultset="1" cfprocresult name="patron_info" resultset="2" cfprocresult name="seat_info" resultset="3" /cfstoredproc ~~ 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: application scope vs request scope
This is a question for those of you in the know... Is there an advantage to putting application variables into the request scope instead of having application variables around a conditionaly statement to only load once per timeout. So in your Application.cfm one would have cfscript request.applicationVar1 = 1; request.applicationVar2 = 2; request.applicationVar3 = 3; /cfscript instead of cfif cfscript application.applicationVar1 = 1; application.applicationVar2 = 2; application.applicationVar3 = 3; /cfscript /cfif I use the Request scope when I'm not running an Application and want variables visible in Custom Tags (called by CF_) I rarely use Applications as I don't like the CFID and CFTOKEN cookies/URL bits, but Request definitely comes in handy Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
CFFILE Delete then WRITE issue....
OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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: CFFILE Delete then WRITE issue....
I think your running into the IIS 'feature' that locks files for you. This 'feature' can be disabled, and someone on this list had a good way of handling it. You should be able to find it in the archives. === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 11:53 AM To: CF-Talk Subject: CFFILE Delete then WRITE issue OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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:CFFILE Delete then WRITE issue....
You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""[EMAIL PROTECTED] Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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
cf and sql backup error
I've got a funny one here that I've not seen before One of my templates features a csv upload feature which updates a SQL 7 database with its contents. Before I run through the file and check the contents for poor formatting, the database itself is backed up to disk. This is the code that runs a backup: cfquery name="backup_db" datasource="*" dbtype="ODBC" BACKUP DATABASE mydb TO my_db_backup WITH DESCRIPTION = 'db Backup #dateval#' /cfquery Obviously my_db_backup is a backup file setup in SQL server. This has been working fine for months before Xmas and New Year, and I don't know whether I'm putting a paranoid slant on it, but after New Year it no longer works, dying with the following error msg: ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1096 pages for database 'mydb', file 'my_db_Data' on file 2. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (11:1) to (11:64). (If the db and backup names look funny, thats cos I've changed em for this posting). Has anyone seen this sort of problem before, or know why its happening? I tried it with a new backup device (eg 'TO my_db_backup2') but to no avail. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL
Im no PKI/Crypto wizard ... however; Im not so sure why these (rainbow) cards are sooo pricey, when now ... both 3Com and Intel Adapters have this or similar tech on their most basic NIC's. the Intel PILA8470C3, and even the PILA8460C3 Desktop adapter. In addition I beleive the newer Gigabit fiver nics as well as Intels new Gigabit over Copper nics have both the onboard encryption processors as well as the IP Traffic acceleration chips. PILA8460C3 - $60 +/- PILA8470C3 - $80+/- PWLA8490SX - $300 +/- PWLA8490T - $295 +/- Whats the diff's between the rainbow stuff and 3coms/Intels NIC's ? Steve - Original Message - From: "Len Conrad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 7:50 AM Subject: Re: SSL Anybody using stuff like http://www.rainbow.com/ncdb/ACCEL.PDF to speed up SSL and offload encryption from the main CPU? Len http://BIND8NT.MEIway.com : Binary for ISC BIND 8.2.3 T9B for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-spam mail gateways ~~ 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: CFFILE Delete then WRITE issue....
NT has this wonderful habit of not dealing with requests immediately - it can mean that when you try to write a file it messes up and needs a slight delay Pain, but it's lovely M$ software! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 16:53 To: CF-Talk Subject: CFFILE Delete then WRITE issue OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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: CFFILE Delete then WRITE issue....
Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""[EMAIL PROTECTED] Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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: Multiple file uploads
Thanks for the pointers, it works great On Mon, 08 Jan 2001 21:08:43 -0600, you wrote: It's actually very simple to accomplish. CFFile looks for the name of the form field, so you have to make sure to match these up. In general, the way you do it is to set up a global variable with the number of the form fields that you want. Then you dynamically name and reference the upload form fields with a numbered suffix, and use CFLoop to handle them all. I've found that sometimes the form fields exist even if there is no file, so you should verify both that a given form field exists as well as it has length GT 0 before you run CFFile on it. Matt -Original Message- From: Kevin Willyerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:37 PM To: CF-Talk Subject: Multiple file uploads Is it possible to upload 5 different files from the same form? The only way I can get it to work is to use a seperate template for each file. Kevin ~~ 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
CFGrid
Hi Please could someone let me know what I am doing wrong. I want to use CFGRID. I am getting this message in the IISLOG. GET /CFIDE/classes/allaire/controls/cfGridFormApplet.class - 404 604 342 0 HTTP/1.0 Mozilla/4.0+(compatible;+MSIE+5.0;+Win32) - - I have in Coldfusion a mapping for c:\inetpub\wwwroot mapped to / Then I have registed an Applet as below: Codebase: /CFIDE/Classes/allaire/controls Code: cfGridFormApplet.class I go to an IE5 browser browser and I get the Applet box up but no GRID and a message at the base of IE5 browser: load: class allaire.controls.cfGridApplet not found. Anyone any ideas. Kind regards Tony ~~ 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
browser check
? looking for help on this if anyone can... on our new layout for our site we have a menu script that works great with IE but not w/ ns. i was wondering if their was a way to do a check with cf that would check which browser was being used and if they were using NS then it would not load the menu script but if they were using IE then it would. ( does that make sense?) any ideas? thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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: CFFILE Delete then WRITE issue....
This is great help and I appreciate all this feedback. Is there an answer to my second question... I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? This would also help me. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:24 AM Please respond to cf-talk Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""[EMAIL PROTECTED] Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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: browser check
You can check this by looking at CGI.HTTP_User_Agent which will identify the browser. The only problem with this is different browsers return different types. Hatton Humphrey -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: browser check ? looking for help on this if anyone can... on our new layout for our site we have a menu script that works great with IE but not w/ ns. i was wondering if their was a way to do a check with cf that would check which browser was being used and if they were using NS then it would not load the menu script but if they were using IE then it would. ( does that make sense?) any ideas? thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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
Using MSXML DOM with CF
Hi all,
I am trying to use a snippet of code from the Maryland CFUG that uses the
CFOBJECT tag to interact with the Microsoft MSXML DOM.
Here is the code:
CFOBJECT action="CREATE" type="COM" class="Microsoft.XMLDOM" name="Parser"
CFSET xmlFile = "sens_xml.xml"
CFSET Parser.Async = false
CFSET Parser.Load(xmlFile)
CFIF NOT Parser.hasChildNodes()
CFTHROW message="Empty XML Tree"
/CFIF
Get the team name
CFSCRIPT
league = XMLDoc.selectSingleNode("league");
nodeTeam= league.selectSingleNode("team");
team= nodeTeam.Text;
/CFSCRIPT
It barfs on the "XMLDoc.selectSingleNode("league");" line with the following
error:
Error resolving parameter XMLDOC.SELECTSINGLENODE
ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:
Is the object recognized at all? Is it loading the xml document? Is my
syntax correct?
The xml document is in the same directory as the cf file.
Any help appreciated,
Jim
~~
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: CFFILE Delete then WRITE issue....
Actually, the feature you are referring to does not have anything to do with the operating system but rather the Web server. IIS creates handles to files for fast references. When you delete a file, you actually delete the file (contrary to what Philip has suggested). The handle, however, is left open. A separate process called the cache scavenger routinely goes through and checks to see which files have been deleted. At this point the handle to the file is deleted and the file "appears" to be deleted from the file system. Although the frequency with which the cache scavenger checks file handles can be adjusted, the performance benefits from this method are great, so it is not recommended that you alter this setting. This is probably why it is hidden in the registry. One side note, the cache scavenger is set by default for something like every 60 seconds. You should not see the file for more than 60 seconds unless someone has already played with this setting. Now, as to the original question, is IIS indeed the Web server in question? If so, is IIS touching the file in-between the write and delete operations? This would invoke the caching mechanism discussed above. If this is the case, there is not to much you can do except name the files uniquely. The CreateUUID() function would probably be overkill: you could probably get away with the RandRange() function if you are deleting the file immediately. If the Web server is something other than IIS or IIS is not touching the file in-between the write and delete operations, then the problem is elsewhere. Are you always enclosing the CFFILE tag in an exclusive lock using the CFLOCK tag? Not doing this would cause a whole host of issues, but I wouldn't really expect the ones you've described. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:12 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue NT has this wonderful habit of not dealing with requests immediately - it can mean that when you try to write a file it messes up and needs a slight delay Pain, but it's lovely M$ software! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 January 2001 16:53 To: CF-Talk Subject: CFFILE Delete then WRITE issue OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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: CFGrid
I'm not exactly sure what you're talking here. My understanding is that CFGRID is used as a CF tag inside a file. CFGRID name="name" height="height"... CFGRIDCOLUMN NAME="col1" HEADER="head1" /CFGRID Brian -Original Message- From: Tony Turner -CFUG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: CFGrid Hi Please could someone let me know what I am doing wrong. I want to use CFGRID. I am getting this message in the IISLOG. GET /CFIDE/classes/allaire/controls/cfGridFormApplet.class - 404 604 342 0 HTTP/1.0 Mozilla/4.0+(compatible;+MSIE+5.0;+Win32) - - I have in Coldfusion a mapping for c:\inetpub\wwwroot mapped to / Then I have registed an Applet as below: Codebase: /CFIDE/Classes/allaire/controls Code: cfGridFormApplet.class I go to an IE5 browser browser and I get the Applet box up but no GRID and a message at the base of IE5 browser: load: class allaire.controls.cfGridApplet not found. Anyone any ideas. Kind regards Tony ~~ 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: CFFILE Delete then WRITE issue....
See my last post for the technical explanations. If I'm guessing correctly, you are running an NT server with IIS? On the first page of your application you create a file that the user can then download? With some subsequent page request, you then delete the file? However, the file still appears to be in the folder tree and a new one with the same name cannot be written for some period of time. If this is the case, then it should not make any difference whether or not the user is "opening" or "saving" the file. What your probably experiencing is just the coincidental timing of your requests and the cache scavenger. I would recommend naming the files uniquely and running your own separate scheduled task that deletes files nightly that are older than so many hours. If this is not the case, then you really need to give us a better idea of what OS, Web server, version of ColdFusion, etc. you are running, as well as the logic behind the application. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue This is great help and I appreciate all this feedback. Is there an answer to my second question... I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? This would also help me. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:24 AM Please respond to cf-talk Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""[EMAIL PROTECTED] Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 OK. I am having a problem here. I am able to DELETE a file with CFFILE without a problem, but when I try to almost immediately WRITE the same file back it tells me there is an issue with the file "Error: The file could not be accessed." Has anyone encountered this before? When I check on the server for the file, what once was a 500k file, is now only 500 bytes, but when I try to open it there it tells me that the "file could not be found." But it exists. And then I have to wait a while to get the OS to release it. I check it 24 hours later (because I am working on other things too, and I so sleep some), and it works fine. I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? Also, when I browse that directory in CF Studio, the file name has a RED DOT to the left, and I have never seen this before. Any help would be MOST appreciated. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 ~~ 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: browser check
Well it depends: you mention a script. Is it written in CF or Javascript. If javascript it's easy (just look at developer.netscape.com and the javascript guide). And it's just as easy using CF. Just check your server variables (CGI.HTTP_USER_AGENT). Then look at the value and parse it out as needed to get the browser name and do a check. Jay At 10:42 AM 1/9/2001 -0700, you wrote: ? looking for help on this if anyone can... on our new layout for our site we have a menu script that works great with IE but not w/ ns. i was wondering if their was a way to do a check with cf that would check which browser was being used and if they were using NS then it would not load the menu script but if they were using IE then it would. ( does that make sense?) any ideas? thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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
CFMail Time Stamp
I have a problem with the time stamp on messages sent through cfmail. My servers clock is set at GMT -0500 but CFMail messages are being stamped with + 0400 wich is affecting the time sent by about 9 hours. Anyone have any insight as to why this is happening or where I go to correct it? Thanks, Chris Stoner ~~ 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 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: CF_Activedit alternatives??
Activeedit requires browsers to support ActiveX, which means Internet Explorer on Windows, exclusively. I've only been using the demo so far and am very happy with it. H. -Original Message- From: Francisco Montes; Spain on Line [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 1:58 AM To: CF-Talk Subject: CF_Activedit alternatives?? Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ 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: CFFILE Delete then WRITE issue....
Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0. The Application is Deleting a file if it exists and then writes the file FRESH. Then gives the user a link to the CSV file. After that, the user can download it, save it, or click another link to regenerate the file. It seems to be happening when the user has OPENed the file and then decides to generate another file that this error occurs. Like I said before, I can then delete the file when they decide to generate another file, but when I try to WRITE the new file, within seconds of the first being deleted, that is when I run into what appears to be a file header of a 500 bytes and it will not let me write it, access denied. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:57 AM Please respond to cf-talk See my last post for the technical explanations. If I'm guessing correctly, you are running an NT server with IIS? On the first page of your application you create a file that the user can then download? With some subsequent page request, you then delete the file? However, the file still appears to be in the folder tree and a new one with the same name cannot be written for some period of time. If this is the case, then it should not make any difference whether or not the user is "opening" or "saving" the file. What your probably experiencing is just the coincidental timing of your requests and the cache scavenger. I would recommend naming the files uniquely and running your own separate scheduled task that deletes files nightly that are older than so many hours. If this is not the case, then you really need to give us a better idea of what OS, Web server, version of ColdFusion, etc. you are running, as well as the logic behind the application. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue This is great help and I appreciate all this feedback. Is there an answer to my second question... I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? This would also help me. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:24 AM Please respond to cf-talk Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris --
Re: CFGrid
Make sure you have CFIDE mapped in the web site. Shawnea - Original Message - From: "Tony Turner -CFUG" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 12:42 PM Subject: CFGrid Hi Please could someone let me know what I am doing wrong. I want to use CFGRID. I am getting this message in the IISLOG. GET /CFIDE/classes/allaire/controls/cfGridFormApplet.class - 404 604 342 0 HTTP/1.0 Mozilla/4.0+(compatible;+MSIE+5.0;+Win32) - - I have in Coldfusion a mapping for c:\inetpub\wwwroot mapped to / Then I have registed an Applet as below: Codebase: /CFIDE/Classes/allaire/controls Code: cfGridFormApplet.class I go to an IE5 browser browser and I get the Applet box up but no GRID and a message at the base of IE5 browser: load: class allaire.controls.cfGridApplet not found. Anyone any ideas. Kind regards Tony ~~ 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 STORED PROCEDURES
Something like this: Declare @Name varchar() Declare @This varchar() SELECT @Name = Name,@This = This from member where membernumber 0 IF @name is 'blah' Begin Do Something here end if @this eq "that" begin Do something end -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: CFMail Time Stamp
Not sure why that's happening but you can force the date in the mail like so: CFMAIL TO="someone" SUBJECT="test" FROM="someone else" CFMAILPARAM NAME="Date" VALUE="#dateformat(now(),"ddd, d mmm ")# #timeformat(now(),"hh:mm:ss")# -0500" test! /CFMAIL Regards, 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: "cftalk" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 1:20 PM Subject: CFMail Time Stamp I have a problem with the time stamp on messages sent through cfmail. My servers clock is set at GMT -0500 but CFMail messages are being stamped with + 0400 wich is affecting the time sent by about 9 hours. Anyone have any insight as to why this is happening or where I go to correct it? Thanks, Chris Stoner ~~ 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: CFFILE Delete then WRITE issue....
When you delete a file, you actually delete the file (contrary to what Philip has suggested). The handle, however, is left open. A separate process called the cache scavenger routinely goes through and checks to see which files have been deleted. At this point the handle to the file is deleted and the file "appears" to be deleted from the file system. I didn't know this - it's always appeared that NT didn't delete the file immediately but "held" the file - I now know exactly why, but now I do g Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: browser check
Go to the CF Developers Exchange look at the custom tags that do this for you. AEBrowser (I think) is the one I use often, works great and returns a lot of useful information on the client that you can use to make good decisions. There are other good ones there too. I use it for checking browser types and versions and then display messages, use different menus or load different stylesheets. -Gary -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 11:43 AM To: CF-Talk Subject: browser check ? looking for help on this if anyone can... on our new layout for our site we have a menu script that works great with IE but not w/ ns. i was wondering if their was a way to do a check with cf that would check which browser was being used and if they were using NS then it would not load the menu script but if they were using IE then it would. ( does that make sense?) any ideas? thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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: CF_Activedit alternatives??
Here is an excerpt from one of my posts last month. There's probably quite a few other useful discussions on this topic in the list archives already. I would like to add ezEdit (http://www.siteobjects.com) to this list of utilities. It is distributed in the form of a custom tag. This tag works like most of the rest. It is free and Open Source. It lacks (and will probably always lack) features like the spell checker found in a few others because of the licensing fees associated with the spell checking databases and such. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 excerpt Most of the solutions out there (especially the ColdFusion ones) are all based on the MSHTML editor. Information developing applications using this component can be found here: http://msdn.microsoft.com/workshop/browser/overview/editing.asp Here's a list of the most popular ones that I've seen around. I know there are a couple people from some of these companies on this list who will probably want to interject on behalf of their company. However, we just researched this fairly extensively. This is a combination of our opinions from evaluating the products and information gathered from the sales people. Please take it for what it is worth: HTMLEdit This is not a ColdFusion solution but I would be remiss not to mention it since it is such a quick and easy solution that probably meets many peoples' needs. http://javaboutique.internet.com/HTMLEdit/ Pros: Simple and Open Source. Cross-platform and cross-browser. Cons: Very, very few features (i.e. only includes basic HTML editing). HTMLAREA http://www.iautomated.com/ Pros: Free (Lite) Version. Cross Platform. Cons: Interface needs some work (i.e. bulky and clumsy); missing some of the features. Pay version is not particularly cheap. Not cross-browser (IE only). ActiveEdit http://www.cfdev.com/ Pros: Cross-platform and Inexpensive. Integration with some other products from the same company like ActiveScan. Cons: Interface needs a little work (i.e. a little clumsy and can't be embedded into a page) and it's missing a couple features (e.g. dictionary), most of which are coming out in the next version. It is not cross-browser (IE only). eWebEdit http://www.ektron.com/ Pros: Nice interface with all the features. Cross-browser and Spectra-ready. Cons: Really (really) high price tag (Although according to their sales rep they haven't figured out their pricing yet so this may change). Not cross-platform (Windows only). Hope this helps. /excerpt -Original Message- From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:58 AM To: CF-Talk Subject: CF_Activedit alternatives?? Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ 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 STORED PROCEDURES
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
Allaire is down
Allaire's home page is throwing a 405... Oops... Howie ~~ 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_Activedit alternatives??
HTMLEdit This is not a ColdFusion solution but I would be remiss not to mention it since it is such a quick and easy solution that probably meets many peoples' needs. http://javaboutique.internet.com/HTMLEdit/ Pros: Simple and Open Source. Cross-platform and cross-browser. Cons: Very, very few features (i.e. only includes basic HTML editing). Does anyone still have a copy or a link to this? The above link doesn't work. I have a project where I could use this. Thanks, Duane Boudreau CFExperts ~~ 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 STORED PROCEDURES
Regarding simple examples of stored procedures OT -- what should a very simple stored procedure that returns multiple resultsets look like? Lisa -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:36 PM To: CF-Talk Subject: RE: OT SQL STORED PROCEDURES 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: CF_Activedit alternatives??
I second this, for the most part. its really good, the only problem is it can sometimes take a while to load (and that's on the office LAN. Must take a while for all those users on dial up.) Chris Martin -Original Message- From: Rob Sherman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:23 PM To: CF-Talk Subject: RE: CF_Activedit alternatives?? I couldn't be happier with the newest version of eWebEditPro. Visit www.ektron.com Sincerely, Rob Sherman Allaire Certified Developer Instructor CFDude, Inc. http://www.cfdude.com CF_Office (310) 543-1622 CF_Fax (310) 543-0512 ~~ 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: CFFILE Delete then WRITE issue....
Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0. We guessed correctly. :) The Application is Deleting a file if it exists and then writes the file FRESH. Then gives the user a link to the CSV file. After that, the user can download it, save it, or click another link to regenerate the file. It seems to be happening when the user has OPENed the file and then decides to generate another file that this error occurs. Again, I don't see why there would be a difference between opening and saving the file. Both those operations occur on the client side, not the server side. Like I said before, I can then delete the file when they decide to generate another file, but when I try to WRITE the new file, within seconds of the first being deleted, that is when I run into what appears to be a file header of a 500 bytes and it will not let me write it, access denied. The 500 byte file that you see is a placeholder of sorts. It exists for up to 30 seconds (the default ObjectCacheTTL). Unfortunately, you will have to adjust your logic to get this application working properly under IIS. Although I like the concept (and for the most part, the implementation) of the cache scavenger, it does add a couple steps to application design in situations such as these. What I would do is the following: 1) Create a directory that holds all the CSV files and only CSV files. 2) When the user requests the page that creates the CSV file, CFDIRECTORY the CSV directory and delete anything older than 1 hour or so. 3) Create your new CSV file with a unique name (either the CreateUUID() function or the RandRange() functions should work fine). Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:57 AM Please respond to cf-talk See my last post for the technical explanations. If I'm guessing correctly, you are running an NT server with IIS? On the first page of your application you create a file that the user can then download? With some subsequent page request, you then delete the file? However, the file still appears to be in the folder tree and a new one with the same name cannot be written for some period of time. If this is the case, then it should not make any difference whether or not the user is "opening" or "saving" the file. What your probably experiencing is just the coincidental timing of your requests and the cache scavenger. I would recommend naming the files uniquely and running your own separate scheduled task that deletes files nightly that are older than so many hours. If this is not the case, then you really need to give us a better idea of what OS, Web server, version of ColdFusion, etc. you are running, as well as the logic behind the application. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:43 PM To: CF-Talk Subject: RE: CFFILE Delete then WRITE issue This is great help and I appreciate all this feedback. Is there an answer to my second question... I think this is an issue if someone tries to OPEN the file instead of SAVING it. So the second question is is there a way to force someone to DOWNLOAD the file instead of opening it? This would also help me. Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:24 AM Please respond to cf-talk Keep in mind that though this eliminates most problems, the issue will still persist. The best way to solve the problem is to use the CFLOCK tag. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:09 PM To: CF-Talk Subject: Re:CFFILE Delete then WRITE issue You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From:
RE: CF_Activedit alternatives??
I couldn't be happier with the newest version of eWebEditPro. Visit www.ektron.com We tested eWebEditPro, but some of our clients don't like installing plugins from companies that they've never heard of - it's a paranoia thing Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
Allaire Curriculum License
Is there anyone on this list who has teached CF in university and has experience with Allaire Curriculum License program. I have some quick questions and since Allaire's Peter Sheridan (responsible for Curriculum License program) is out of the office until January 16 I'm hoping someone else could answer them. PS: Please reply off-list, thanks. Erki ~~ 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
Faster Join
What would be faster an inner join, an outer join, or a where something = something join. I am working with huge queries and a little bit of time on a small query could translate to a huge gain on my joins. Robert Everland III Web Developer Dixon Ticonderoga ~~ 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: Contract
I haven't seen any sites like that, and there's probably good reason. A contract is a legal document, and laws vary per locality. Your best bet is to consult with a lawyer and have them to put together a "template" that you can use. --Billy Albert K Arhin wrote: Hi All, I am new as an independent developer. Can you please direct me to sites on software contract Writting. 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: Faster Join
Outer joins from my experience take the longest. Since a where x=y join is essentially the same thing as an inner join, I can't imagine either one taking any longer. However I could be wrong. Gregory Harris Web Developer Stirling Bridge Group LLC - Original Message - From: "Robert Everland" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 11:02 AM Subject: Faster Join What would be faster an inner join, an outer join, or a where something = something join. I am working with huge queries and a little bit of time on a small query could translate to a huge gain on my joins. Robert Everland III Web Developer Dixon Ticonderoga ~~ 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: CFFILE Delete then WRITE issue....
I see the merit to these suggestions. But, unfortunately this only works around the problem and does not fix it. The 500 byte file that you see is a placeholder of sorts. It exists for up to 30 seconds (the default ObjectCacheTTL). The files are remaining for what looks like about 1 to 2 hours. 1) Create a directory that holds all the CSV files and only CSV files. 2) When the user requests the page that creates the CSV file, CFDIRECTORY the CSV directory and delete anything older than 1 hour or so. There is CSV directory already and all it holds are the 2 CSV's that can be created. The problem with giving them unique names, is that then we would need to educate the user community on how to import that CSV since the program they have is looking for a specific name. Therefore we were trying to keep it the same name that the application will be looking for. Again, these are great suggestions, but I want to know if this can be fixed. Is there a way to FORCE download and not give an option to OPEN? Vance Duke Cold Fusion Application Developer i2 Technologies (469) 357-4729 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 12:54 PM Please respond to cf-talk Sorry I did not elaborate before. NT 4.0 SP 5, CF 4.0, IIS 4.0. We guessed correctly. :) The Application is Deleting a file if it exists and then writes the file FRESH. Then gives the user a link to the CSV file. After that, the user can download it, save it, or click another link to regenerate the file. It seems to be happening when the user has OPENed the file and then decides to generate another file that this error occurs. Again, I don't see why there would be a difference between opening and saving the file. Both those operations occur on the client side, not the server side. Like I said before, I can then delete the file when they decide to generate another file, but when I try to WRITE the new file, within seconds of the first being deleted, that is when I run into what appears to be a file header of a 500 bytes and it will not let me write it, access denied. The 500 byte file that you see is a placeholder of sorts. It exists for up to 30 seconds (the default ObjectCacheTTL). Unfortunately, you will have to adjust your logic to get this application working properly under IIS. Although I like the concept (and for the most part, the implementation) of the cache scavenger, it does add a couple steps to application design in situations such as these. What I would do is the following: 1) Create a directory that holds all the CSV files and only CSV files. 2) When the user requests the page that creates the CSV file, CFDIRECTORY the CSV directory and delete anything older than 1 hour or so. 3) Create your new CSV file with a unique name (either the CreateUUID() function or the RandRange() functions should work fine). Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 "Benjamin S. Rogers" To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: CFFILE Delete then WRITE issue 01/09/01 11:57 AM Please respond to cf-talk See my last post for the technical explanations. If I'm guessing correctly, you are running an NT server with IIS? On the first page of your application you create a file that the user can then download? With some subsequent page request, you then delete the file? However, the file still appears to be in the folder tree and a new
SESSION Timing out WAY before it's supposed to.
I have an application that stores a variable in SESSION scope ... the application is set to timeout after 12 hours, however, when users login and begin working, after about 10-15 minutes, they get logged out. CFServer is set to hold SESSIONs for 12 hours as is the application its self. My only thought is this: Does the SESSION variable have to be set in the Application.cfm file in order for it to use the 12 hour timeout? The variable is currently being set in the index.cfm page while the cfapplication tag that sets the timeout is in the Application.cfm page. CFAPPLICATION name="TRR_ADMIN" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout="#CreateTimeSpan(0,12,00,0)#" This is the code that sets the timeout in Application.cfm cfset SESSION.aID="1" This is the code that sets the session variable in index.cfm Any help appreciated! Joshua Miller Web Development Eagle Technologies Group, Inc. Business Solutions for the Next Generation www.eagletgi.com http://www.eagletgi.com [EMAIL PROTECTED] mailto:[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
