RE: Dreamweaver 2004 MX - Issues
Still using a beta? The product shipped weeks ago. If you encountering issues with a release product you should contact MM themselves. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Monday, 6 October 2003 7:18 PM To: CF-Talk Subject: Dreamweaver 2004 MX - Issues Anybody else having real pain the in the arse issues with this BETA release? Savings files has stopped working (so attempting a re-install). Also sometimes the text search fails to work. Also the CF help files seemed to be messed up. Not a happy bunny. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javascript regex problem.
script language=_javascript_ !-- function dispTest(){ var UpdprojStart = ; //five spaces. UpdprojStart = UpdprojStart.replace(/\s+/ig, -); alert(| + UpdprojStart + |); UpdprojStart = 1 2 3 4 5; //a spacebefore each number. UpdprojStart = UpdprojStart.replace(/\s+/ig, -); alert(| + UpdprojStart + |); } dispTest(); //-- /script regexs are not defined between quotes but between slashes in js. Also need g (global, same as ALL in regex functions from CF). You can also use i (case insensitive). You also need the + instead of *, because you only want to replace if there is a space. Otherwise you will add a hyphen before each character. Pascal -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: maandag 6 oktober 2003 21:57 To: CF-Talk Subject: OT:_javascript_ regex problem. Hi all, I have a little problem with some _javascript_ and a regex that I can't seem to figure out. I have the following code: script language=_javascript_ !-- function dispTest(){ var UpdprojStart = ; //five spaces. UpdprojStart = UpdprojStart.replace([\s]*, -); alert(| + UpdprojStart + |); UpdprojStart = 1 2 3 4 5; //a spacebefore each number. UpdprojStart = UpdprojStart.replace([\s]*, -); alert(| + UpdprojStart + |); } //-- /script [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: parsing txt file - seems unparsable
I reckon you'll be needing a Java CFX then. Seemed like a fun 5 minute project so here ya go. - import com.allaire.cfx.*; import java.io.*; public class cfReadTxtFile implements CustomTag{ public void processRequest( Request request, Response response ) throws Exception { if ( !request.attributeExists(filename) || !request.attributeExists(variable) ) { throw new Exception(Missing attributes, filename and variable are required.); } String filename = request.getAttribute( filename ); String variable = request.getAttribute( variable ); String fileContent = ; try { BufferedReader in = new BufferedReader(new FileReader(filename)); String str; while ((str = in.readLine()) != null) { fileContent = fileContent + str + System.getProperty(line.separator); } in.close(); } catch (IOException e) { } response.setVariable( variable, fileContent); } } --- Call it like so... cfx_cfReadTxtFile filename=d:\sites\test\string.cfm variable=test cfdump var=#test# Tested and works perfectly on CF5 I'll mail you the source and the compiled CFX off list aswell. Craig. -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 14:20 To: CF-Talk Subject: Re:parsing txt file - seems unparsable Tried this on CF5, and received this error: Unhandled System exception ! Failed to create JavaVM. JNI_CreateJavaVM returned error code JNI_ERR (this may indicate an unrecognized option string) which comes from line: cfobject type=JAVA name=jFR class=java.io.FileReader action=""> any ideas? BTW, using cffile in CFMX to read the file works great, it doesn't choke on the null char. Too bad we don't have MX yet on our corporate servers (sigh). ~~ Stephenie This is better though. cfobject type=JAVA name=jFR class=java.io.FileReader action=""> cfset jFRobj = jFR.init('d:/sites/test/dates.cfm') cfobject type=JAVA name=jBR class=java.io.BufferedReader action=""> cfset jBRobj = jBR.init(jFRobj) pre cfscript line = ; while ( isDefined(line) ){ line = jBRobj.readLine(); if ( isDefined(line) ){ writeoutput(line #chr(13)#); } } jBRobj.close(); /cfscript /pre Seems as soon as we reach EOF, jBRobj.readLine() returns null (expected) and variable 'line' is no longer defined, quite handy in this case. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cffile moving on linux
You could try java.io.File.renameTo(). Just use cfobject to call java.io.File and init the object with the full current filename. Create another file object with the destination file path and call oldFileObject.renameTo(newFileObject) Some think like... cfscript fileObj = createObject(Java, java.io.File); fileObj.init(d:\sites\test\test.cfm); newFileObj = createObject(Java, java.io.File); newFileObj.init(d:\sites\test.cfm); fileObj.renameTo(newFileObj); /cfscript Works for me. Craig. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 21:11 To: CF-Talk Subject: cffile moving on linux Hey all, I'm having a little trouble setting up my site on Linux. We're kinda testing the waters to see if it's worth getting wet. As I was saying, cffile isn't working for me. I've got a part where I upload an image and stick it in the GetTempDirectory() folder. From there I cfcontent it to view a preview of it, then, on approval, move it to the final destination I just created. This is where it errors out, giving me: The value of the attribute source, which is currently /opt/jrun4/servers/cfusion2/SERVER-INF/temp/cfusion-war-tmp/3122706.jpg , is invalid. The photo does exist, as does the destination folder. The permissions are set to root-root rw-r-r, and I have confirmed Jrun logs in as root. I can copy the file to the final destination and delete the original, but I just can't move it. Any insight would be appreciated. Thanks! -nathan strutz _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Strange CFHTTP Error
I'm writing a small load testing script for a XML service we provide but am running into some very strange problems with CFHTTP. Basically I have code like the following: cfloop query=getVehicles cfxml variable=myXmlStr_object cfoutput ...some XML /cfoutput /cfxml cfhttp url="" http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm method=post cfhttpparam type=url name=xml value=#trim(ToString(myXmlStr_object))# /cfhttp /cfloop which, when running it for a single event works perfectly.However, when I start to load more than one request into it different things happen.The first request always goes through first time, but all subsequent requests do not appear to be sending the XML formfield through (XML comes up as completely undefined in the service, so it's not a blank string). Has anyone come across this before?Is there a way round it? Neil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Testing Multipart Emails
Does anyone know of an email account that you can set up as receiving text only emails? I am trying to test a multipart email but only see the html part as this is what my email provider can handle. Any help would be greatly appreciated. Chris Doughty Project Leader MIS Tel +44 (0) 20 8253 5017 Fax +44 (0) 20 8688 6191 www.iclployalty.com --- This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dreamweaver 2004 MX - Issues
I think the beta reference was a tongue in cheek implication that the product is in a beta state. As to the issues: 1) The files probably do save, just DW isn't reporting it. 2) Are you searching in text mode for something in the source code? Change Search In to Source Code instead of Text. 3) There's some orphan references in the CF Help, but shouldn't be a problem generally. - Calvin - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Tuesday, October 07, 2003 2:09 AM Subject: RE: Dreamweaver 2004 MX - Issues Still using a beta? The product shipped weeks ago. If you encountering issues with a release product you should contact MM themselves. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Monday, 6 October 2003 7:18 PM To: CF-Talk Subject: Dreamweaver 2004 MX - Issues Anybody else having real pain the in the arse issues with this BETA release? Savings files has stopped working (so attempting a re-install). Also sometimes the text search fails to work. Also the CF help files seemed to be messed up. Not a happy bunny. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dreamweaver 2004 MX - Issues
1) The files probably do save, just DW isn't reporting it. I've seen this happening too, I am just unable to reproduce it consistently 2) Are you searching in text mode for something in the source code? Change Search In to Source Code instead of Text. I've seen Find Replace failing searching for specific tags if the tags are inside cfsavecont or other CFML tags. I heard other users reporting issues, but we need a set of reproducible steps 3) There's some orphan references in the CF Help, but shouldn't be a problem generally. DW's integrated Reference is useless anyway :-))) Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Testing Multipart Emails
Install a mail client like Thunderbird and send it to that, when you view the source of the message then it includes the whole email (both parts of the message) plus headers HTH -Original Message- From: Chris Doughty [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 09:49 To: CF-Talk Subject: Testing Multipart Emails Does anyone know of an email account that you can set up as receiving text only emails? I am trying to test a multipart email but only see the html part as this is what my email provider can handle. Any help would be greatly appreciated. Chris Doughty Project Leader MIS Tel +44 (0) 20 8253 5017 Fax +44 (0) 20 8688 6191 www.iclployalty.com --- This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Testing Multipart Emails
Thanks for the reply. What I am trying to do is check that the html part is not visible to anyone that can only receive text only. -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 10:59 To: CF-Talk Subject: RE: Testing Multipart Emails Install a mail client like Thunderbird and send it to that, when you view the source of the message then it includes the whole email (both parts of the message) plus headers HTH -Original Message- From: Chris Doughty [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 09:49 To: CF-Talk Subject: Testing Multipart Emails Does anyone know of an email account that you can set up as receiving text only emails? I am trying to test a multipart email but only see the html part as this is what my email provider can handle. Any help would be greatly appreciated. Chris Doughty Project Leader MIS Tel +44 (0) 20 8253 5017 Fax +44 (0) 20 8688 6191 www.iclployalty.com --- This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javascript regex problem.
Pascal, Thanks, it's weird though, I copied a regex from the _javascript_ reference and just replaced it with what came out of the vis regex editor.The reference had the quotes! Thanks again Steve -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 3:38 AM To: CF-Talk Subject: RE: _javascript_ regex problem. script language=_javascript_ !-- function dispTest(){ var UpdprojStart = ; //five spaces. UpdprojStart = UpdprojStart.replace(/\s+/ig, -); alert(| + UpdprojStart + |); UpdprojStart = 1 2 3 4 5; //a spacebefore each number. UpdprojStart = UpdprojStart.replace(/\s+/ig, -); alert(| + UpdprojStart + |); } dispTest(); //-- /script regexs are not defined between quotes but between slashes in js. Also need g (global, same as ALL in regex functions from CF). You can also use i (case insensitive). You also need the + instead of *, because you only want to replace if there is a space. Otherwise you will add a hyphen before each character. Pascal -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: maandag 6 oktober 2003 21:57 To: CF-Talk Subject: OT:_javascript_ regex problem. Hi all, I have a little problem with some _javascript_ and a regex that I can't seem to figure out. I have the following code: script language=_javascript_ !-- function dispTest(){ var UpdprojStart = ; //five spaces. UpdprojStart = UpdprojStart.replace([\s]*, -); alert(| + UpdprojStart + |); UpdprojStart = 1 2 3 4 5; //a spacebefore each number. UpdprojStart = UpdprojStart.replace([\s]*, -); alert(| + UpdprojStart + |); } //-- /script _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dreamweaver 2004 MX - Issues
As others have pointed out DWMX does save files, it just doesn't appear to. So many users have mentioned this I'm surprised its not listed as a known issue Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 10:14 To: CF-Talk Subject: Re: Dreamweaver 2004 MX - Issues 1) The files probably do save, just DW isn't reporting it. I've seen this happening too, I am just unable to reproduce it consistently 2) Are you searching in text mode for something in the source code? Change Search In to Source Code instead of Text. I've seen Find Replace failing searching for specific tags if the tags are inside cfsavecont or other CFML tags. I heard other users reporting issues, but we need a set of reproducible steps 3) There's some orphan references in the CF Help, but shouldn't be a problem generally. DW's integrated Reference is useless anyway :-))) Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javascript regex problem.
You can create a regexp throug the RegExp constructor too. It's defined between quotes then. var UpdprojStart = ; //five spaces. var myPattern = new RegExp(\\s+,ig); UpdprojStart = UpdprojStart.replace(myPattern, -); -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 12:31 To: CF-Talk Subject: RE: _javascript_ regex problem. Pascal, Thanks, it's weird though, I copied a regex from the _javascript_ reference and just replaced it with what came out of the vis regex editor.The reference had the quotes! Thanks again Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Testing Multipart Emails
The Bat http://www.ritlabs.com splits multipart emails into different tabs for the html part and the text part. I imagine all of the text only email clients will show you the text part as well. Any of the Unix ports, any older version of Eudora, Pegasus still makes a DOS version available... -- mailto:[EMAIL PROTECTED] Tuesday, October 7, 2003, 4:48:35 AM, you wrote: CD Does anyone know of an email account that you can set up as receiving CD text only emails? CD I am trying to test a multipart email but only see the html part as this CD is what my email provider can handle. CD Any help would be greatly appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
test
test [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
sql server + cf 5.0
Hello, I have CF 5.0 installed on a Linux box. I have SQL server 2000 installed on my workstation. I need the linux box to be ablet o access the SQL server on my local machine. I can't seem to login to the SQL server via remote connection.I found this out because I tried to create a USER and SYSTEM DNS on the SQL Server box and it didn't connect using SQL permissions..I was however able to create a USER and SYSTEM DNS when using Windows Authentication. Any help? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 01:18:57 -0400 I would do this where you log into the application.You can do this in Application.cfm but you must do two things: 1) Store the query results in a persistent scope (if this is user information use the Session scope, if it's information applicable to the whole application and all users use the Application scope).This will allow the information to be maintained across multiple requests without being destroyed. 2) You need to check and see if the information has already been set and only set it if it needs to be.The Application.cfm template is run for EVERY SINGLE request - unless you do this kind of check you'll be running the code over and over. Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery.Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Testing Multipart Emails
Yes, but we have found a solution using Thunderbird. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 12:58 To: CF-Talk Subject: Re: Testing Multipart Emails On Tuesday 07 Oct 2003 09:48 am, Chris Doughty wrote: I am trying to test a multipart email but only see the html part as this is what my email provider can handle. Have you got 'email provider' there where you meant 'email client' ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Fwd: Clustercats and Apache 2?
Hi, Has anyone had success in running ClusterCats with Apache 2? My IT guys at work are trying to bring up a testing cluster using CFMX 6.1, JRun 4 Updater 2, and Apache 2.0.46 (I think) on beta 2 of Red Hat Enterprise Linux 3 AS. They're hitting an error along the way and have narrowed it down to a variable APACHE_DUMMY_MUTEX (again, I think) that is in Apache 1.3.x and doesn't exist in Apache 2.0.x (that they can find). Any ideas or suggestions? -- Howard Fore, [EMAIL PROTECTED] If everything's coming your way, you may be in the wrong lane - Old Farmhand, Prairie Home Companion [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
If I put the query and cfset SESSION variables into my index.cfm file I can output the results no problem. It won't work if its in my application.cfm? Whats wrong? --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 07:53:15 -0400 Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 01:18:57 -0400 I would do this where you log into the application. You can do this in Application.cfm but you must do two things: 1) Store the query results in a persistent scope (if this is user information use the Session scope, if it's information applicable to the whole application and all users use the Application scope). This will allow the information to be maintained across multiple requests without being destroyed. 2) You need to check and see if the information has already been set and only set it if it needs to be. The Application.cfm template is run for EVERY SINGLE request - unless you do this kind of check you'll be running the code over and over. Something like this (in the Application.cfm). This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this. One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed). There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql server + cf 5.0
Won, IS the SQL Server configured for Mixed Authentication or for Windows Authentication? If the SQL Server is configured to only use Windows Authentication, you will not be able to use a SQL Server login,until you reconfigure it. Dave -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 7:50 AM To: CF-Talk Subject: sql server + cf 5.0 Hello, I have CF 5.0 installed on a Linux box. I have SQL server 2000 installed on my workstation. I need the linux box to be ablet o access the SQL server on my local machine. I can't seem to login to the SQL server via remote connection. I found this out because I tried to create a USER and SYSTEM DNS on the SQL Server box and it didn't connect using SQL permissions..I was however able to create a USER and SYSTEM DNS when using Windows Authentication. Any help? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
It should work. Are you sure you are executing the right application.cfm. Try putting some text in there to verify. You should see the text. application.cfm -- h3Setting session/h3 cfif NOT IsDefined(SESSION.init) ... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 14:11 To: CF-Talk Subject: RE: application.cfm If I put the query and cfset SESSION variables into my index.cfm file I can output the results no problem. It won't work if its in my application.cfm? Whats wrong? --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 07:53:15 -0400 Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql server + cf 5.0
Dave, Thanks for the reply.I actually realized the problem was that I didn't allow the remote user to access any dbs.I gave it roles, but no access to any of the dbs.One click solved the problem.Thanks. And yes it was in mixed authentication mode. At 08:15 AM 10/7/2003 -0400, you wrote: Won, IS the SQL Server configured for Mixed Authentication or for Windows Authentication? If the SQL Server is configured to only use Windows Authentication, you will not be able to use a SQL Server login,until you reconfigure it. Dave -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 7:50 AM To: CF-Talk Subject: sql server + cf 5.0 Hello, I have CF 5.0 installed on a Linux box. I have SQL server 2000 installed on my workstation. I need the linux box to be ablet o access the SQL server on my local machine. I can't seem to login to the SQL server via remote connection. I found this out because I tried to create a USER and SYSTEM DNS on the SQL Server box and it didn't connect using SQL permissions..I was however able to create a USER and SYSTEM DNS when using Windows Authentication. Any help? _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Did you make sure to spell it Application.cfm with a capital A? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Have you got the CFAPPLICATION tag above the code? If not, you can't set the Session variables. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 7:53 AM To: CF-Talk Subject: RE: application.cfm Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 01:18:57 -0400 I would do this where you log into the application.You can do this in Application.cfm but you must do two things: 1) Store the query results in a persistent scope (if this is user information use the Session scope, if it's information applicable to the whole application and all users use the Application scope).This will allow the information to be maintained across multiple requests without being destroyed. 2) You need to check and see if the information has already been set and only set it if it needs to be.The Application.cfm template is run for EVERY SINGLE request - unless you do this kind of check you'll be running the code over and over. Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery.Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
I'm using the correct application.cfm. I did what you suggested. I don't know why the SESSION variables are not being set with the cfset. They just won't output anything in my index.cfm file. --Original Message Text--- From: Pascal Peters Date: Tue, 7 Oct 2003 14:19:41 +0200 It should work. Are you sure you are executing the right application.cfm. Try putting some text in there to verify. You should see the text. application.cfm -- h3Setting session/h3 cfif NOT IsDefined(SESSION.init) ... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 14:11 To: CF-Talk Subject: RE: application.cfm If I put the query and cfset SESSION variables into my index.cfm file I can output the results no problem. It won't work if its in my application.cfm? Whats wrong? --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 07:53:15 -0400 Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
That only really applies on *nix operating systems - Windows based ones don't need that (apart from good practices) -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 8:21 AM To: CF-Talk Subject: RE: application.cfm Did you make sure to spell it Application.cfm with a capital A? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
It's on a Windows server. Why would that make a difference. I could see that on a *nix. --Original Message Text--- From: Won Lee Date: Tue, 07 Oct 2003 08:21:04 -0400 Did you make sure to spell it Application.cfm with a capital A? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
First off, is the file named with a capital A? Second, make sure your cfapplication has the sessionmanagement set to yes.See the following: cfapplication name=Application Name clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,30,0)# HTH! Scott -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Yup...right at the top of my application.cfm file. --Original Message Text--- From: Philip Arnold Date: Tue, 7 Oct 2003 08:24:13 -0400 Have you got the CFAPPLICATION tag above the code? If not, you can't set the Session variables. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 7:53 AM To: CF-Talk Subject: RE: application.cfm Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 01:18:57 -0400 I would do this where you log into the application.You can do this in Application.cfm but you must do two things: 1) Store the query results in a persistent scope (if this is user information use the Session scope, if it's information applicable to the whole application and all users use the Application scope).This will allow the information to be maintained across multiple requests without being destroyed. 2) You need to check and see if the information has already been set and only set it if it needs to be.The Application.cfm template is run for EVERY SINGLE request - unless you do this kind of check you'll be running the code over and over. Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery.Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange CFHTTP Error
Anyone? This is starting to drive me crazy... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 09:48 To: CF-Talk Subject: Strange CFHTTP Error I'm writing a small load testing script for a XML service we provide but am running into some very strange problems with CFHTTP. Basically I have code like the following: cfloop query=getVehicles cfxml variable=myXmlStr_object cfoutput ...some XML /cfoutput /cfxml cfhttp url="" http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm method=post cfhttpparam type=url name=xml value=#trim(ToString(myXmlStr_object))# /cfhttp /cfloop which, when running it for a single event works perfectly.However, when I start to load more than one request into it different things happen.The first request always goes through first time, but all subsequent requests do not appear to be sending the XML formfield through (XML comes up as completely undefined in the service, so it's not a blank string). Has anyone come across this before?Is there a way round it? Neil _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dreamweaver 2004 MX - Issues
wow... i'm impressed! You actually read the EULA? I'd agree that is totally insane! If i paid for it, and if i paid for the upgrade, why would MM care if i ran both versions?? In my case tho, I just installed the 30 day demo of DW2004 - but i did send email to their support folks to ask if it was ok to run both in different folders. They said yep. Thanks for pointing out more sillyness Mitch Shameless plug for my wife's business: http://www.mygccandle.com/showmescents -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:57 PM To: CF-Talk Subject: Re: Dreamweaver 2004 MX - Issues I'd have to say that it is mucho buggier than i expected... good thing i still have the old version installed! In case you purchased DW 2004 as an upgrade, be advised that the EULA doesn't allow to keep running the old version, check section 4 here: http://www.macromedia.com/software/eula/tools/ No need to say I think this totally insane, but I guess you better know about it Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange CFHTTP Error
Have you tried putting the cfhttp call in a custom tag or cfc? Might not make any difference, but you never know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:31 To: CF-Talk Subject: RE: Strange CFHTTP Error Anyone? This is starting to drive me crazy... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 09:48 To: CF-Talk Subject: Strange CFHTTP Error I'm writing a small load testing script for a XML service we provide but am running into some very strange problems with CFHTTP. Basically I have code like the following: cfloop query=getVehicles cfxml variable=myXmlStr_object cfoutput ...some XML /cfoutput /cfxml cfhttp url="" http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm method=post cfhttpparam type=url name=xml value=#trim(ToString(myXmlStr_object))# /cfhttp /cfloop which, when running it for a single event works perfectly. However, when I start to load more than one request into it different things happen.The first request always goes through first time, but all subsequent requests do not appear to be sending the XML formfield through (XML comes up as completely undefined in the service, so it's not a blank string). Has anyone come across this before?Is there a way round it? Neil _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Try doing a CFDUMP of the Session scope - then you can see what is, and what isn't, being set -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 8:24 AM To: CF-Talk Subject: RE: application.cfm I'm using the correct application.cfm. I did what you suggested. I don't know why the SESSION variables are not being set with the cfset. They just won't output anything in my index.cfm file. --Original Message Text--- From: Pascal Peters Date: Tue, 7 Oct 2003 14:19:41 +0200 It should work. Are you sure you are executing the right application.cfm. Try putting some text in there to verify. You should see the text. application.cfm -- h3Setting session/h3 cfif NOT IsDefined(SESSION.init) ... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 14:11 To: CF-Talk Subject: RE: application.cfm If I put the query and cfset SESSION variables into my index.cfm file I can output the results no problem. It won't work if its in my application.cfm? Whats wrong? --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 07:53:15 -0400 Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dreamweaver 2004 MX - Issues
wow... i'm impressed! You actually read the EULA? I try to avoid doing it whenever possible :-) This time I knew there were major changes coming, so I read it Thanks for pointing out more sillyness Since I too believe it's silly, I try to spread the knowledge Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
OK...I just tried a cfdump in my index.cfm file and all I get are the table fields. No data. Yet when I go into SQL query I see the data. --Original Message Text--- From: Philip Arnold Date: Tue, 7 Oct 2003 08:36:38 -0400 Try doing a CFDUMP of the Session scope - then you can see what is, and what isn't, being set -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 8:24 AM To: CF-Talk Subject: RE: application.cfm I'm using the correct application.cfm. I did what you suggested. I don't know why the SESSION variables are not being set with the cfset. They just won't output anything in my index.cfm file. --Original Message Text--- From: Pascal Peters Date: Tue, 7 Oct 2003 14:19:41 +0200 It should work. Are you sure you are executing the right application.cfm. Try putting some text in there to verify. You should see the text. application.cfm -- h3Setting session/h3 cfif NOT IsDefined(SESSION.init) ... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 14:11 To: CF-Talk Subject: RE: application.cfm If I put the query and cfset SESSION variables into my index.cfm file I can output the results no problem. It won't work if its in my application.cfm? Whats wrong? --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 07:53:15 -0400 Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
This might be way off, but is this by any chance a Fusebox 4 application? If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? -Original Message- Why is this not working? I have the following code in my application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
--Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Posts with Bluedragon free
As a suggestion, why don't you try the same portion of code on a Coldfusion to See if the error is Blue Dragon related or some other issue. Kola -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 12:56 To: CF-Talk Subject: CFHTTP Posts with Bluedragon free While I never usually use cfhttp, a particular client wishes to use Bluedragon 3.0 free edition as a bridge for his internal system and our web server, I'm formatting xml packets form his queries and posting to our box, or trying to. I simply cannot get CFHTTP to POST at all, GET's work fine but the packets are far too big for a url. Code as below... cfhttp url="" url port=80 method=POST timeout=15 cfhttpparam type=FORMFIELD name=test value=#urlencodedformat(test)# /cfhttp This just returns Failed to connect with a HTTP staus code of 100 which is continue, this sounds to me as if BD is connecting with the web server but not actually doing the post. I'm more or less sure status code 100 is the web server basically saying go on then, do your post. Anyone use CFHTTP with BD? Ever got a POST to work? Am I missing a BD specific attribute or something? If this doesn't work I'm going to have to write some XML handling code for Access97, and that's not going to be pretty. Unfortunatley the client isn't going to stump up for CFMX of the more advanced version of BD ( so I can use cfobject/java cfx's ), at least not yet. Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
I just pasted the cfquery from my application.cfm into my index.cfm along with the cfdump The first occurence of the cfdump from the application.cfm display nothing. Only the field names yet the second cfdump in my index.cfm display the field names and the field contents. Why is the cfquery not working in the application.cfm? I have the following line in my application.cfm cfapplication name=MyApplication clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(0,0,45,0)# ARGH!!! --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 08:44:46 -0400 --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
At 08:44 AM 10/7/2003 -0400, you wrote: --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! You wrote this was a Windows Server?Well, my MS manual says that the answer to this particular problem is to reboot the box until it starts to work. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Posts with Bluedragon free
Thanks for the suggestion Kola, Have tried it on 5.0 and 6.1 , it works without issue. Craig. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:45 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free As a suggestion, why don't you try the same portion of code on a Coldfusion to See if the error is Blue Dragon related or some other issue. Kola -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 12:56 To: CF-Talk Subject: CFHTTP Posts with Bluedragon free While I never usually use cfhttp, a particular client wishes to use Bluedragon 3.0 free edition as a bridge for his internal system and our web server, I'm formatting xml packets form his queries and posting to our box, or trying to. I simply cannot get CFHTTP to POST at all, GET's work fine but the packets are far too big for a url. Code as below... cfhttp url="" url port=80 method=POST timeout=15 cfhttpparam type=FORMFIELD name=test value=#urlencodedformat(test)# /cfhttp This just returns Failed to connect with a HTTP staus code of 100 which is continue, this sounds to me as if BD is connecting with the web server but not actually doing the post. I'm more or less sure status code 100 is the web server basically saying go on then, do your post. Anyone use CFHTTP with BD? Ever got a POST to work? Am I missing a BD specific attribute or something? If this doesn't work I'm going to have to write some XML handling code for Access97, and that's not going to be pretty. Unfortunatley the client isn't going to stump up for CFMX of the more advanced version of BD ( so I can use cfobject/java cfx's ), at least not yet. Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
ha ha --Original Message Text--- From: Won Lee Date: Tue, 07 Oct 2003 08:49:25 -0400 At 08:44 AM 10/7/2003 -0400, you wrote: --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! You wrote this was a Windows Server?Well, my MS manual says that the answer to this particular problem is to reboot the box until it starts to work. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
I know this is a long shot, but are you using NES? I remember having some problems with the session variables with NES. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:cffile moving on linux
I am also just starting out developing on a Linux platform and it has been relatively trouble free but any catches that I have encountered have always boiled down to a permissions issue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Can you paste the full Application.cfm here and one of us will try it. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:49 To: CF-Talk Subject: RE: application.cfm I just pasted the cfquery from my application.cfm into my index.cfm along with the cfdump The first occurence of the cfdump from the application.cfm display nothing. Only the field names yet the second cfdump in my index.cfm display the field names and the field contents. Why is the cfquery not working in the application.cfm? I have the following line in my application.cfm cfapplication name=MyApplication clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(0,0,45,0)# ARGH!!! --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 08:44:46 -0400 --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dynamic FORM.variables
How would I create a dynamic FORM.variable? I am trying to call a series of variables from a form that are created through a loop, but I'm not sure how to write them out... Would it be something like this: cfloop index=i from=1 to=6 step=1 #FORM.var index# /cfloop Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org//http://scott.sllboces.org/ http://scott.sllboces.org (digital desktop) [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Wed/Thu) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 Massena (Fri) Massena Central School Massena, NY P.315-769-3700 x 3049?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
I figured it out. Thanks --Original Message Text--- From: Craig Dudley Date: Tue, 7 Oct 2003 13:54:46 +0100 Can you paste the full Application.cfm here and one of us will try it. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:49 To: CF-Talk Subject: RE: application.cfm I just pasted the cfquery from my application.cfm into my index.cfm along with the cfdump The first occurence of the cfdump from the application.cfm display nothing. Only the field names yet the second cfdump in my index.cfm display the field names and the field contents. Why is the cfquery not working in the application.cfm? I have the following line in my application.cfm cfapplication name=MyApplication clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(0,0,45,0)# ARGH!!! --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 08:44:46 -0400 --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: application.cfm
What did you figure out? - Original Message - From: Bushy To: CF-Talk Sent: Tuesday, October 07, 2003 9:09 AM Subject: RE: application.cfm I figured it out. Thanks --Original Message Text--- From: Craig Dudley Date: Tue, 7 Oct 2003 13:54:46 +0100 Can you paste the full Application.cfm here and one of us will try it. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:49 To: CF-Talk Subject: RE: application.cfm I just pasted the cfquery from my application.cfm into my index.cfm along with the cfdump The first occurence of the cfdump from the application.cfm display nothing. Only the field names yet the second cfdump in my index.cfm display the field names and the field contents. Why is the cfquery not working in the application.cfm? I have the following line in my application.cfm cfapplication name=MyApplication clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(0,0,45,0)# ARGH!!! --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 08:44:46 -0400 --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic FORM.variables
cfloop index=i from=1 to=6 step=1 #FORM[var i]# /cfloop -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 15:08 To: CF-Talk Subject: Dynamic FORM.variables How would I create a dynamic FORM.variable? I am trying to call a series of variables from a form that are created through a loop, but I'm not sure how to write them out... Would it be something like this: cfloop index=i from=1 to=6 step=1 #FORM.var index# /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Funnily enough that was what I was just thinking... -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 14:19 To: CF-Talk Subject: Re: application.cfm What did you figure out? - Original Message - From: Bushy To: CF-Talk Sent: Tuesday, October 07, 2003 9:09 AM Subject: RE: application.cfm I figured it out. Thanks --Original Message Text--- From: Craig Dudley Date: Tue, 7 Oct 2003 13:54:46 +0100 Can you paste the full Application.cfm here and one of us will try it. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:49 To: CF-Talk Subject: RE: application.cfm I just pasted the cfquery from my application.cfm into my index.cfm along with the cfdump The first occurence of the cfdump from the application.cfm display nothing. Only the field names yet the second cfdump in my index.cfm display the field names and the field contents. Why is the cfquery not working in the application.cfm? I have the following line in my application.cfm cfapplication name=MyApplication clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(0,0,45,0)# ARGH!!! --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 08:44:46 -0400 --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Dynamic FORM.variables
Original Message: From: Scott Wilhelm [EMAIL PROTECTED] cfloop index=i from=1 to=6 step=1 #FORM.var index# /cfloop If you're using CFMX+ (not sure about earlier versions): cfloop index=i from=1 to=6 step=1 #FORM[var i]# /cfloop That should work. (I'm assuming that your form fields are called var1 var2 var3 ... var6.] Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange CFHTTP Error
I was thinking something similar and will try it later on today -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:28 To: CF-Talk Subject: RE: Strange CFHTTP Error Have you tried putting the cfhttp call in a custom tag or cfc? Might not make any difference, but you never know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:31 To: CF-Talk Subject: RE: Strange CFHTTP Error Anyone? This is starting to drive me crazy... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 09:48 To: CF-Talk Subject: Strange CFHTTP Error I'm writing a small load testing script for a XML service we provide but am running into some very strange problems with CFHTTP. Basically I have code like the following: cfloop query=getVehicles cfxml variable=myXmlStr_object cfoutput ...some XML /cfoutput /cfxml cfhttp url="" http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm method=post cfhttpparam type=url name=xml value=#trim(ToString(myXmlStr_object))# /cfhttp /cfloop which, when running it for a single event works perfectly. However, when I start to load more than one request into it different things happen.The first request always goes through first time, but all subsequent requests do not appear to be sending the XML formfield through (XML comes up as completely undefined in the service, so it's not a blank string). Has anyone come across this before?Is there a way round it? Neil _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamic FORM.variables
I have done this. cfloop index=i from=1 to=6 step=1 cfparam name=form.var#i# default= /cfloop You can also do: cfloop index=i from=1 to=6 step=1 input type=text name=var#i# /cfloop HTH Clint Scott Wilhelm wrote: How would I create a dynamic FORM.variable? I am trying to call a series of variables from a form that are created through a loop, but I'm not sure how to write them out... Would it be something like this: cfloop index=i from=1 to=6 step=1 #FORM.var index# /cfloop Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org//http://scott.sllboces.org/ http://scott.sllboces.org (digital desktop) [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Wed/Thu) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 Massena (Fri) Massena Central School Massena, NY P.315-769-3700 x 3049?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: application.cfm
I had a cfset buried in my code... cfset auth = listlast(auth, \) This was being set after my cfquery. Once I put it to the top it worked. cfset auth = #CGI.AUTH_USER# --Original Message Text--- From: David Fafard Date: Tue, 7 Oct 2003 09:19:07 -0400 What did you figure out? - Original Message - From: Bushy To: CF-Talk Sent: Tuesday, October 07, 2003 9:09 AM Subject: RE: application.cfm I figured it out. Thanks --Original Message Text--- From: Craig Dudley Date: Tue, 7 Oct 2003 13:54:46 +0100 Can you paste the full Application.cfm here and one of us will try it. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:49 To: CF-Talk Subject: RE: application.cfm I just pasted the cfquery from my application.cfm into my index.cfm along with the cfdump The first occurence of the cfdump from the application.cfm display nothing. Only the field names yet the second cfdump in my index.cfm display the field names and the field contents. Why is the cfquery not working in the application.cfm? I have the following line in my application.cfm cfapplication name=MyApplication clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# applicationtimeout=#CreateTimeSpan(0,0,45,0)# ARGH!!! --Original Message Text--- From: Bushy Date: Tue, 07 Oct 2003 08:44:46 -0400 --Original Message Text--- From: McGill, Eric Date: Tue, 7 Oct 2003 08:42:03 -0400 This might be way off, but is this by any chance a Fusebox 4 application? No. If not, is there any possibility that there is Another CFAPPLICATION tag set somewhere (like at the top of index.cfm)? Nope. This is frigg'in driving me nuts! -Original Message- Why is this not working? I have the following code in my application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Writing Scripts for HomeSite+
You need to actually write to the document. Consider this example: function Main() { var str; var app; var doc; str = Jedi Master Whopper Supreme; app = Application; doc = app.ActiveDocument; doc.InsertText(str, true); } The last two lines in particular are what you are missing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client variable initialization errors in cfapplication
Everyone, We get errors (3-4/day) when a user goes to our homepage and the cfapplication tag tries to initialize client variables.What causes this issues?I have a feeling that this is a bug in CFMX itself based of looking at the stacktrace (attached at the end of email).Our setup is windows 2K CFMX 6.1 with ONLY using client variables -- no session, application or server variables. Anyone else getting these type of errors?Are they deadlocks from a client variable table perspective?Any other ideas on what is causing this and how to prevent it? Thanks, Jeremy Bruck Here is our CFMX Stacktrace and CFCatch Dump: Browser: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 (nscd2) Cookies: CFID=325895 IP: 64.222.94.27 Message: StackTrace: java.lang.NullPointerException at coldfusion.runtime.ClientScopeKey.hashCode(ClientScopeKey.java:29) at java.util.Hashtable.get(Hashtable.java:333) at coldfusion.runtime.ClientScopeServiceImpl.GetClientScope(ClientScopeServiceI mpl.java:168) at coldfusion.tagext.lang.ApplicationTag.setupClientScope(ApplicationTag.java:5 65) at coldfusion.tagext.lang.ApplicationTag.doStartTag(ApplicationTag.java:283) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm1990321119.runPage(E:\mfgq_live\Application.cfm:87) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Type: java.lang.NullPointerException TagContext 1: Line: 87CFAPPLICATIONFile: E:\mfgq_live\Application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
(Advice) Mass insert of XML data into a database
Hey guys/gals I'm in need of some direction... I have many xml files that I need to parse and save their content into a database. All the xml files have the same element names and those names match the names of the fields in my database table. My problem is I need to loop though each xml file and collect its data then store the available content into the database as a mass insert. I need to loop through about 100 xml files all at once and then somehow make this an auto process that can be run once a week to update the content. Any ideas...? Below is my current code for outputting the information (only the name field is shown). cfhttpmethod=GETURL=""> cfset XMLDoc = XMLParse(CFHTTP.FileContent) cfset xRoot = XMLDoc.Xmlroot cfset myBenefit = XMLSearch(XMLDoc, /benefitDocument) !--- Output the XML formatted query results --- cfloop from=1 to=#arrayLen(myBenefit)# index=i cfoutput cfif structKeyExists(myBenefit[i], Name) #myBenefit[i].Name.xmltext# cfelse /cfif /cfoutput /cfloop Thanks, - Neal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT Macromedia.com - What Content Management System does it use ?
Hi Does any body know what cms Macromedia are using to manage their site, from the url's it is not Coldfusion based. Any body have any ideas Interwoven, Stellent, ??? Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Client variable initialization errors in cfapplication
On Tuesday 07 Oct 2003 14:45 pm, Jeremy Bruck wrote: Type: java.lang.NullPointerException TagContext 1: Line: 87CFAPPLICATIONFile: E:\mfgq_live\Application.cfm What is that line, and it's context ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Macromedia.com - What Content Management System does it us e ?
It uses a few.Spectra, RIA apps, ColdFusion custom built, Broadvision... -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 14:49 To: CF-Talk Subject: OT Macromedia.com - What Content Management System does it use ? Hi Does any body know what cms Macromedia are using to manage their site, from the url's it is not Coldfusion based. Any body have any ideas Interwoven, Stellent, ??? Ian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLAP Issue: /
Hi James, I'm glad it worked out! I'll have to make a personal note about that, since I do some freelance work with CFLDAP from time-to-time. Thanks, -Dain -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Dain, I just wanted to say thank you so much! It turns out that the forward slash is not a documented special character for SUN however when being passed to the DN it must be escaped. -JB !--- ** --- !--- *** In order to search properly special characters must be escaped.*** --- !--- ** --- CFSET variables.URL_StartString= ou=#URL.ou#,ou=White Pages,o=WhitePages !--- Note: When searching the LDAP Server you need to replace all / with \/ --- CFSET variables.StartString= #replace(variables.URL_StartString,#chr(47)#,#chr(92)##chr(47)#, ALL)# !--- ** --- !--- ** --- !--- ** --- CFLDAP ACTION=""> NAME=MyLDAPQuery SERVER=#REQUEST.LDAP_Server# PORT=#REQUEST.LDAP_Server_Port# ATTRIBUTES=#REQUEST.LDAP_Attributes# MAXROWS=#REQUEST.LDAP_Server_MaxRows# TIMEOUT=#REQUEST.LDAP_Server_Timeout# START=#variables.StartString# SCOPE=OneLevel SORT=ou ASC SORTCONTROL=nocase SNIP [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Black Knight evaluation now available
After releasing Black Knight last week, a number of people requested that an evaluation version be made available. Well the wait is over, you can download the 30-day evaluation version from Montara Software's web site. http://montarasoftware.com/go/ee67fe97-f800-1157-affb-e87c411e1c8f Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:parsing txt file - seems unparsable
Thanks! will let you know how it goes. I have really been seeing the usefulness of using Java with CF lately. ~~ Stephenie I reckon you'll be needing a Java CFX then. Seemed like a fun 5 minute project so here ya go. - import com.allaire.cfx.*; import java.io.*; public class cfReadTxtFile implements CustomTag{ public void processRequest( Request request, Response response ) throws Exception { if ( !request.attributeExists(filename) || !request.attributeExists(variable) ) { throw new Exception(Missing attributes, filename and variable are required.); } String filename = request.getAttribute( filename ); String variable = request.getAttribute( variable ); String fileContent = ; try { BufferedReader in = new BufferedReader(new FileReader(filename)); String str; while ((str = in.readLine()) != null) { fileContent = fileContent + str + System.getProperty(line.separator); } in.close(); } catch (IOException e) { } response.setVariable( variable, fileContent); } } --- Call it like so... cfx_cfReadTxtFile filename=d:\sites\test\string.cfm variable=test cfdump var=#test# Tested and works perfectly on CF5 I'll mail you the source and the compiled CFX off list aswell. Craig. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
I'm not sure what your problem is - are you seeing everything but the Session.Init or nothing?Are you absolutely, 100% sure that the query is returning a value. The CF code you have here looks perfectly fine to me. but I would guess that the query would need struser = test changed to struser = 'test' - although I have no idea whyyou're just not getting an outright error. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 7:53 AM To: CF-Talk Subject: RE: application.cfm Why is this not working? I have the following code in my application.cfm application.cfm -- cfif NOT IsDefined(SESSION.init) cfquery name=listenv datasource=database select * from table1 where struser = test /cfquery cfset SESSION.field1 = #listenv.field1# cfset SESSION.field2 = #listenv.field2# cfset SESSION.field3 = #listenv.field3# cfset SESSION.field4 = #listenv.field4# cfset SESSION.init = true /cfif Then in my index.cfm file I'm just outputting the above SESSION variables for testing yet gets displayed except the SESSION.init variable. Why? What's wrong with my syntax? index.cfm cfoutput SESSION.init: #SESSION.init#br SESSION.field1: #SESSION.field1#br SESSION.field2: #SESSION.field2#br SESSION.field3: #SESSION.field3#br SESSION.field4: #SESSION.field4#br /cfoutput --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 01:18:57 -0400 I would do this where you log into the application.You can do this in Application.cfm but you must do two things: 1) Store the query results in a persistent scope (if this is user information use the Session scope, if it's information applicable to the whole application and all users use the Application scope).This will allow the information to be maintained across multiple requests without being destroyed. 2) You need to check and see if the information has already been set and only set it if it needs to be.The Application.cfm template is run for EVERY SINGLE request - unless you do this kind of check you'll be running the code over and over. Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery.Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery.Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
I think you should beware using cflock in your application.cfm file, especially if you set it to EXCLUSIVE, this will essentially make your application a ONE THREADED application.since application.cfm is a RUN ON EVERY PAGE REQUEST file, this may cause unwanted results. just a caveat. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:22 AM To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Yes. And if your server is not set to automatic read locking around every access to a session var. Read http://www.macromedia.com/devnet/server_archive/articles/cf_locking_best _practices.html for locking on CF5 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 16:22 To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Well - not really - it won't single thread the application - at least as long as you END the lock (and end it as quickly as possible).;^) However it will lock (get it!) the session scope WHILE you're writing to (or reading from) it.As a general rules of thumb the only things inside a CFLock should be CFSETs - don't place your query in there, don't place the CFIF in there, etc. Performance won't be affected (at least in any noticeable sense) and you'll. Jim Davis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:25 AM To: CF-Talk Subject: RE: application.cfm I think you should beware using cflock in your application.cfm file, especially if you set it to EXCLUSIVE, this will essentially make your application a ONE THREADED application.since application.cfm is a RUN ON EVERY PAGE REQUEST file, this may cause unwanted results. just a caveat. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:22 AM To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
So then putting a cflock around all my cfset SESSION.variable(s) within my application.cfm is acceptable? What cflock syntax would I use around all my cfset SESSION.variable_name(s)? I'm getting confused on READONLY and EXCLUSIVE. My application will be accessed by 20-50 users. Does this make a difference? When my app is run by a user I run a cfquery and define all my SESSION variables which are the database fields. Should I be using something other than SESSION variables for this? Each SESSION variable will be unique for every user. cflock timeout=2 throwontimeout=No name=name type=READONLY cfset SESSION.variable1=something cfset SESSION.variable1=something cfset SESSION.variable1=something...etc. /cflock --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 10:42:23 -0400 Well - not really - it won't single thread the application - at least as long as you END the lock (and end it as quickly as possible).;^) However it will lock (get it!) the session scope WHILE you're writing to (or reading from) it.As a general rules of thumb the only things inside a CFLock should be CFSETs - don't place your query in there, don't place the CFIF in there, etc. Performance won't be affected (at least in any noticeable sense) and you'll. Jim Davis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:25 AM To: CF-Talk Subject: RE: application.cfm I think you should beware using cflock in your application.cfm file, especially if you set it to EXCLUSIVE, this will essentially make your application a ONE THREADED application.since application.cfm is a RUN ON EVERY PAGE REQUEST file, this may cause unwanted results. just a caveat. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:22 AM To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
if you are setting session vars, use EXCLUSIVE if you are reading from the value of a session variable, use READONLY make sense? its really kinda easy when you think about it like this ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:50 AM To: CF-Talk Subject: RE: application.cfm So then putting a cflock around all my cfset SESSION.variable(s) within my application.cfm is acceptable? What cflock syntax would I use around all my cfset SESSION.variable_name(s)? I'm getting confused on READONLY and EXCLUSIVE. My application will be accessed by 20-50 users. Does this make a difference? When my app is run by a user I run a cfquery and define all my SESSION variables which are the database fields. Should I be using something other than SESSION variables for this? Each SESSION variable will be unique for every user. cflock timeout=2 throwontimeout=No name=name type=READONLY cfset SESSION.variable1=something cfset SESSION.variable1=something cfset SESSION.variable1=something...etc. /cflock --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 10:42:23 -0400 Well - not really - it won't single thread the application - at least as long as you END the lock (and end it as quickly as possible).;^) However it will lock (get it!) the session scope WHILE you're writing to (or reading from) it.As a general rules of thumb the only things inside a CFLock should be CFSETs - don't place your query in there, don't place the CFIF in there, etc. Performance won't be affected (at least in any noticeable sense) and you'll. Jim Davis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:25 AM To: CF-Talk Subject: RE: application.cfm I think you should beware using cflock in your application.cfm file, especially if you set it to EXCLUSIVE, this will essentially make your application a ONE THREADED application.since application.cfm is a RUN ON EVERY PAGE REQUEST file, this may cause unwanted results. just a caveat. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:22 AM To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Thats easy enough. Will SESSION variables being set by one user clobber another users variables are are they unique to each individual user that accessing my application? --Original Message Text--- From: Tony Weeg Date: Tue, 7 Oct 2003 10:51:26 -0400 if you are setting session vars, use EXCLUSIVE if you are reading from the value of a session variable, use READONLY make sense? its really kinda easy when you think about it like this ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:50 AM To: CF-Talk Subject: RE: application.cfm So then putting a cflock around all my cfset SESSION.variable(s) within my application.cfm is acceptable? What cflock syntax would I use around all my cfset SESSION.variable_name(s)? I'm getting confused on READONLY and EXCLUSIVE. My application will be accessed by 20-50 users. Does this make a difference? When my app is run by a user I run a cfquery and define all my SESSION variables which are the database fields. Should I be using something other than SESSION variables for this? Each SESSION variable will be unique for every user. cflock timeout=2 throwontimeout=No name=name type=READONLY cfset SESSION.variable1=something cfset SESSION.variable1=something cfset SESSION.variable1=something...etc. /cflock --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 10:42:23 -0400 Well - not really - it won't single thread the application - at least as long as you END the lock (and end it as quickly as possible).;^) However it will lock (get it!) the session scope WHILE you're writing to (or reading from) it.As a general rules of thumb the only things inside a CFLock should be CFSETs - don't place your query in there, don't place the CFIF in there, etc. Performance won't be affected (at least in any noticeable sense) and you'll. Jim Davis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:25 AM To: CF-Talk Subject: RE: application.cfm I think you should beware using cflock in your application.cfm file, especially if you set it to EXCLUSIVE, this will essentially make your application a ONE THREADED application.since application.cfm is a RUN ON EVERY PAGE REQUEST file, this may cause unwanted results. just a caveat. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:22 AM To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
your follow up question is a bit unclear? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:56 AM To: CF-Talk Subject: RE: application.cfm Thats easy enough. Will SESSION variables being set by one user clobber another users variables are are they unique to each individual user that accessing my application? --Original Message Text--- From: Tony Weeg Date: Tue, 7 Oct 2003 10:51:26 -0400 if you are setting session vars, use EXCLUSIVE if you are reading from the value of a session variable, use READONLY make sense? its really kinda easy when you think about it like this ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:50 AM To: CF-Talk Subject: RE: application.cfm So then putting a cflock around all my cfset SESSION.variable(s) within my application.cfm is acceptable? What cflock syntax would I use around all my cfset SESSION.variable_name(s)? I'm getting confused on READONLY and EXCLUSIVE. My application will be accessed by 20-50 users. Does this make a difference? When my app is run by a user I run a cfquery and define all my SESSION variables which are the database fields. Should I be using something other than SESSION variables for this? Each SESSION variable will be unique for every user. cflock timeout=2 throwontimeout=No name=name type=READONLY cfset SESSION.variable1=something cfset SESSION.variable1=something cfset SESSION.variable1=something...etc. /cflock --Original Message Text--- From: Jim Davis Date: Tue, 7 Oct 2003 10:42:23 -0400 Well - not really - it won't single thread the application - at least as long as you END the lock (and end it as quickly as possible).;^) However it will lock (get it!) the session scope WHILE you're writing to (or reading from) it.As a general rules of thumb the only things inside a CFLock should be CFSETs - don't place your query in there, don't place the CFIF in there, etc. Performance won't be affected (at least in any noticeable sense) and you'll. Jim Davis -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:25 AM To: CF-Talk Subject: RE: application.cfm I think you should beware using cflock in your application.cfm file, especially if you set it to EXCLUSIVE, this will essentially make your application a ONE THREADED application.since application.cfm is a RUN ON EVERY PAGE REQUEST file, this may cause unwanted results. just a caveat. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:22 AM To: CF-Talk Subject: RE: application.cfm Are you saying I should put a cflock around all my SESSION.variable that I'm defining with cfset? If so, whats the default cflock? Something like this (in the Application.cfm).This assumes that you're using the session scope on CFMX - if you're using CF 5 or below you should lock the accesses to the session scope to prevent server instability: cfif NOT IsDefined(Session.Init) cfquery name=myQuery... Your query /cfquery !--- Do whatever you have to do with your variables You might only set the results of the query into the session scope like this: --- cfset Session.myQuery = myQuery !--- Now set your marker variable - once this is done this section of code won't run on the next request for this user --- cfset Session.init = true /cfif There are actually many other ways to do this.One that you might look into if you're only caching the query (and using it as it's returned) is to cache the query using the CachedWithin and CachedAfter attributes of CFQuery. Once you set these if the SAME EXACT query is run again before the refresh period CF will pull the information from the cache and not bother hitting the database. This makes for VERY fast access of the cached query and a very simple page (no marker variables or persistent scopes needed).There are limitations - you read the docs on this, but it may be the way to go. Jim Davis -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:49 AM To: CF-Talk Subject: re: application.cfm HI, I need to load my database fields into session and cookie variables for my application. The catch is I only need cfquery the database once upon initial log in via Windows NT authentication. I don't want the datbase queried if a refresh is performed. Where or how can I do this. Sould the cfquery be in my application.cfm off the main root of the website? /inetpub/wwwroot/website/application.cfm _
cfquery + list
Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Testing Multipart Emails
FWIW, I use Outlook Express 6 (windows) and turn off html for sending and reading. When I receive an html message, only plain text appears in the message window but the associated graphics come through as attachments. Links and other html code don't work of course. - Regards, Bob Haroche O n P o i n tS o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Clustercats and Apache 2?
FYI, I've been told that MM answered a tech support request and said that ClusterCats will not be ported to support Apache 2, and are recommending a hardware solution. We're looking at Cisco's LocalDirector line. Any other vendor suggestions? On Tuesday, Oct 7, 2003, at 08:08 US/Eastern, Howard Fore wrote: Hi, Has anyone had success in running ClusterCats with Apache 2? My IT guys at work are trying to bring up a testing cluster using CFMX 6.1, JRun 4 Updater 2, and Apache 2.0.46 (I think) on beta 2 of Red Hat Enterprise Linux 3 AS. They're hitting an error along the way and have narrowed it down to a variable APACHE_DUMMY_MUTEX (again, I think) that is in Apache 1.3.x and doesn't exist in Apache 2.0.x (that they can find). Any ideas or suggestions? -- Howard Fore, [EMAIL PROTECTED] I hope you believe you understand what you think I said, but I'm not sure you understand that what you've heard is not what I meant. President Richard Nixon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
select PKID from myTable where name not in (#attributes.myList#) that's only if the values of attributes.myList is really a list. you didn't need the 's (apostrophes) that's all. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:06 AM To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfquery + list
Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery Check the ListQualify() function inside the docs Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfquery + list
cfquery name=blah ... select PKID from myTable where name not in (cfquery param value=#attributes.myList# cfsqltype=cf_sql_varchar list=yes) /cfquery Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Won Lee To: CF-Talk Sent: Tuesday, October 07, 2003 8:05 AM Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
something like cfquery name=blah ... select PKID from myTable where name not in (CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes) /cfquery altho make sure that there is something in the list... an empty list will throw an error HTH -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 16:06 To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfquery + list
oi Won!! it's probably not working because each item in the list is not single quoted.. cfset attributes.myList = 'John','Amy' that would work, no? -- Tuesday, October 7, 2003, 11:05:32 AM, you wrote: WL Hello, WL Let's say I have a list: WL cfset attributes.myList = John, Amy WL How can I do a query that would take that list and do a not in? WL cfquery name=blah ... WL select PKID WL from myTable WL where name not in ('#attributes.myList#') WL /cfquery WL (This codes doesn't work) WL CF 5.0 WL [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfquery + list
Won, On 10/7/2003 at 11:05, you wrote: WL cfset attributes.myList = John, Amy WL How can I do a query that would take that list and do a not in? WL cfquery name=blah ... WLselect PKID WLfrom myTable WLwhere name not in ('#attributes.myList#') WL /cfquery WL (This codes doesn't work) WL CF 5.0 Maybe try where not name in What database are you using? ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
We got a winner. Thanks. Thanks to everyone else that helped as well. At 04:13 PM 10/7/2003 +0100, you wrote: something like cfquery name=blah ... select PKID from myTable where name not in (CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes) /cfquery altho make sure that there is something in the list... an empty list will throw an error HTH -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 16:06 To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Macromedia.com - What Content Management System does it us e ?
I believe there's some atomz in there too: http://www.atomz.com/ It uses a few.Spectra, RIA apps, ColdFusion custom built, Broadvision... -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 14:49 To: CF-Talk Subject: OT Macromedia.com - What Content Management System does it use ? Hi Does any body know what cms Macromedia are using to manage their site, from the url's it is not Coldfusion based. Any body have any ideas Interwoven, Stellent, ??? Ian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
and the winner was? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:23 AM To: CF-Talk Subject: RE: cfquery + list We got a winner. Thanks. Thanks to everyone else that helped as well. At 04:13 PM 10/7/2003 +0100, you wrote: something like cfquery name=blah ... select PKID from myTable where name not in (CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes) /cfquery altho make sure that there is something in the list... an empty list will throw an error HTH -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 16:06 To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
This was funny.I got this email just as I sent mine out with the text, The winner is.. At 11:22 AM 10/7/2003 -0400, you wrote: and the winner was? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:23 AM To: CF-Talk Subject: RE: cfquery + list We got a winner. Thanks. Thanks to everyone else that helped as well. At 04:13 PM 10/7/2003 +0100, you wrote: something like cfquery name=blah ... select PKID from myTable where name not in (CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes) /cfquery altho make sure that there is something in the list... an empty list will throw an error HTH -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 16:06 To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 _ -- [ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
returning an image via cfhttp
Hi, using cfhttp to get an image returned, the vendor takes an XML file and reads it. I do the following to get the image, //XML_DOC = XML FILE CFHTTP METHOD=GET URL="" PROTECTED]/GetMap.asp CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_DOC# NAME=xmlparams /CFHTTP CFCONTENT TYPE=image/gifCFOUTPUT#CFHTTP.FileContent#/cfoutput/CFCONTENT the correct scale is returned for the gif but it is the default blank space when an image cannot be found. The gif is not static, its dynamically generated. The web vendor creates the map data contained within the xml file. They have confirmed they are receiving data. You would have thought this would have worked, but they did not get any parameters passed within the request CFHTTP METHOD=GET URL="" PROTECTED]/GetMap.asp CFHTTPPARAM TYPE=XML VALUE=#XML_DOC# NAME=xmlparams /CFHTTP, If I try to do this img src="" instead of cfcontent, I just get a page full of gobildy gook. any ideas, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
Misunderstood what your email was asking. The CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes suggested by Mike Townend was the solution I first tried to implement and worked.All the other solutions may be valid; I'm unsure since I haven't tested them. Once again thanks. At 11:22 AM 10/7/2003 -0400, you wrote: and the winner was? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:23 AM To: CF-Talk Subject: RE: cfquery + list We got a winner. Thanks. Thanks to everyone else that helped as well. At 04:13 PM 10/7/2003 +0100, you wrote: something like cfquery name=blah ... select PKID from myTable where name not in (CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes) /cfquery altho make sure that there is something in the list... an empty list will throw an error HTH -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 16:06 To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 _ -- [ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery + list
cool, just wondering, its good for the list to know, what worked, so that they see, and comprehend, then can take that knowledge with them for the next time they run into that prob. in case you didn't already know this :) ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:33 AM To: CF-Talk Subject: RE: cfquery + list Misunderstood what your email was asking. The CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes suggested by Mike Townend was the solution I first tried to implement and worked.All the other solutions may be valid; I'm unsure since I haven't tested them. Once again thanks. At 11:22 AM 10/7/2003 -0400, you wrote: and the winner was? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:23 AM To: CF-Talk Subject: RE: cfquery + list We got a winner. Thanks. Thanks to everyone else that helped as well. At 04:13 PM 10/7/2003 +0100, you wrote: something like cfquery name=blah ... select PKID from myTable where name not in (CFQUERYPARAM VALUE=#attributes.myList# CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes) /cfquery altho make sure that there is something in the list... an empty list will throw an error HTH -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 7, 2003 16:06 To: CF-Talk Subject: cfquery + list Hello, Let's say I have a list: cfset attributes.myList = John, Amy How can I do a query that would take that list and do a not in? cfquery name=blah ... select PKID from myTable where name not in ('#attributes.myList#') /cfquery (This codes doesn't work) CF 5.0 _ -- [ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
printing multiple pdf's
Hello All, I'm trying to print multiple pdf files that I've created using the html2pdf3 custom tag.Is there a way to print multiple pdf's with one click? Thanks, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT:Javascript regex problem.
Take the \s out of brackets.I suspect that's your problem.Also, you're replacing with a dash, not a blank. Or maybe I'm just tired. --Ben DURETTE, STEVEN J (AIT) wrote: Hi all, I have a little problem with some _javascript_ and a regex that I can't seem to figure out. I have the following code: script language=_javascript_ !-- function dispTest(){ var UpdprojStart = ; //five spaces. UpdprojStart = UpdprojStart.replace([\s]*, -); alert(| + UpdprojStart + |); UpdprojStart = 1 2 3 4 5; //a spacebefore each number. UpdprojStart = UpdprojStart.replace([\s]*, -); alert(| + UpdprojStart + |); } //-- /script When I run it I get: first alert box: || (pipe, 5 spaces pipe) second alert box: | 1 2 3 4 5| (pipe, space, 1, space, 2, space, 3, space, 4, space 5, pipe) But I should have gotten: first alert box: || (pipe, pipe) second alert box: |12345| (pipe, 12345, pipe) I got the regex from the visual regex editor on the house of fusion.What am I doing wrong that this won't work? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange CFHTTP Error
well, you wouldn't have thought it, but it seems to work Thanks for the help Neil -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:28 To: CF-Talk Subject: RE: Strange CFHTTP Error Have you tried putting the cfhttp call in a custom tag or cfc? Might not make any difference, but you never know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:31 To: CF-Talk Subject: RE: Strange CFHTTP Error Anyone? This is starting to drive me crazy... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 09:48 To: CF-Talk Subject: Strange CFHTTP Error I'm writing a small load testing script for a XML service we provide but am running into some very strange problems with CFHTTP. Basically I have code like the following: cfloop query=getVehicles cfxml variable=myXmlStr_object cfoutput ...some XML /cfoutput /cfxml cfhttp url="" http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm method=post cfhttpparam type=url name=xml value=#trim(ToString(myXmlStr_object))# /cfhttp /cfloop which, when running it for a single event works perfectly. However, when I start to load more than one request into it different things happen.The first request always goes through first time, but all subsequent requests do not appear to be sending the XML formfield through (XML comes up as completely undefined in the service, so it's not a blank string). Has anyone come across this before?Is there a way round it? Neil _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strange CFHTTP Error
Cool, I had a strange feeling it might ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 16:46 To: CF-Talk Subject: RE: Strange CFHTTP Error well, you wouldn't have thought it, but it seems to work Thanks for the help Neil -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:28 To: CF-Talk Subject: RE: Strange CFHTTP Error Have you tried putting the cfhttp call in a custom tag or cfc? Might not make any difference, but you never know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:31 To: CF-Talk Subject: RE: Strange CFHTTP Error Anyone? This is starting to drive me crazy... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 09:48 To: CF-Talk Subject: Strange CFHTTP Error I'm writing a small load testing script for a XML service we provide but am running into some very strange problems with CFHTTP. Basically I have code like the following: cfloop query=getVehicles cfxml variable=myXmlStr_object cfoutput ...some XML /cfoutput /cfxml cfhttp url="" http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm http://www.myserver.com/control.cfm method=post cfhttpparam type=url name=xml value=#trim(ToString(myXmlStr_object))# /cfhttp /cfloop which, when running it for a single event works perfectly. However, when I start to load more than one request into it different things happen.The first request always goes through first time, but all subsequent requests do not appear to be sending the XML formfield through (XML comes up as completely undefined in the service, so it's not a blank string). Has anyone come across this before?Is there a way round it? Neil _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: lost access to datasources and log files
I found the answer to my problem.Our root directory on our Linux server hit the max quota, partially due to excessively large log files by ColdFusion.Lesson learned, pay attention to your development servers! This was just the start of my problem.It appears as though when Linux went chaotic, it deleted all of the data in the cfinstallroot/odb/odbc.ini file, however, kept all of the configuration's in the cfinstallroot/registry/cf.registry file.This is why I was getting the conflicting message about datasource names already existing.The ini file was telling the CF Administrator that there was no datasources installed, but the registry file reflected a different story. The behavior also reset permissions on the odbc.ini file so I had to reset this as well.Once I reset those perms, added all the datasources back to the odbc.ini file (you could remove reference to all datasourcesby removing the db entries in the odbc.ini file and the cf.registry file), restarted CF servers (fyi. before you edit files you must stop CF services or else the buffer for those files will overwrite your changes) we were back in business. PhewNot an easy beginning of the week. mike -Original Message- From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 4:13 PM To: CF-Talk Subject: lost access to datasources and log files I have a question for the list.I was hoping someone could help me clear up this behavior I am running CF 5 on a LINUX 7.2 server.Applications on this server started reporting that data sources that I know should be working are no longer in existence.When I went to the ODBC Connections page in the CF Administrator, it reported that there were no data sources added to the server.This is clearly false.As of an 2 hours ago, this server had roughly 7 data sources connected to it.I tried to re-add a data source that used to be there and the server responded with a message saying that the name I have selected is being used for another data source!Strange. When I went to the log files page to see if there were any errors or strange behavior as of recent, I could not access any of the log files. Has anybody ever experienced anything like this before? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
At 10:50 07/10/2003 -0400, you wrote: So then putting a cflock around all my cfset SESSION.variable(s) within my application.cfm is acceptable? What cflock syntax would I use around all my cfset SESSION.variable_name(s)? I'm getting confused on READONLY and EXCLUSIVE. I'm jumping into this thread, but just thought these links might be useful to understand CFLOCK and shared scope vars: CFMX Best practices for locking shared scope variables http://www.macromedia.com/support/coldfusion/ts/documents/tn18235.htm CF5- Best practices for locking shared scope variables http://www.macromedia.com/support/coldfusion/ts/documents/tn17882.htm Gyrus [EMAIL PROTECTED] play: http://norlonto.net/ work: http://tengai.co.uk/ PGP key available [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Access database 401 error
We are running into an unreproducible error when trying to connect to an Access database using CF 5. Our system has a series of scheduled events and in some cases our clients are reporting a 401 Unauthorised error when the scheduled event tries to connect to an Access database. The database connection is stored as a verified ODBC connection in the CF Administrator. Has anyone seen this error before? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Puzzle?
I have two tables... APPLICANTS and DEALS.There can be multiple deals per applicant but only one applicant per deal. SELECT COMPANY_ID, COUNT(APPLICANT_ID) FROM APPLICANTS GROUP BY COMPANY_ID Results: 1 3 2 9 3 7 SELECT COMPANY_ID, COUNT(DEAL_ID) FROM DEALS GROUP BY COMPANY_ID Results: 1 3 2 11 3 8 What I'm trying to get is: 1 3 3 2 9 11 3 7 8 My problem is actually a little harder than this but if someone could tell me HOW to get my desired results above in a single SQL query then I could probably figure out the rest. -Novak [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access database 401 error
This error isn't related to the database connection.A 401 means that your web server has the requested URL protected and the client (in this case, the ColdFusion scheduler) is being rejected by the web server.The ColdFusion scheduler connects to the server as an HTTP client (so, it looks like a browser to the web server).You can enter a user name and password into the scheduled event so that the HTTP request will include a login. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server ((())) PrismAV is Coming ((())) Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Zac Belado To: CF-Talk Sent: Tuesday, October 07, 2003 12:07 PM Subject: Access database 401 error We are running into an unreproducible error when trying to connect to an Access database using CF 5. Our system has a series of scheduled events and in some cases our clients are reporting a 401 Unauthorised error when the scheduled event tries to connect to an Access database. The database connection is stored as a verified ODBC connection in the CF Administrator. Has anyone seen this error before? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Puzzle?
select a.company_Id, count(a.applicantId) as applicantCount, count(d.deal_id) as dealCount from applicants a inner join deals don d.company_id = a.company_id group by a.company_id, a.applicantid, d.deal_id order by a.company_id maybe? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 12:11 PM To: CF-Talk Subject: SQL Puzzle? I have two tables... APPLICANTS and DEALS.There can be multiple deals per applicant but only one applicant per deal. SELECT COMPANY_ID, COUNT(APPLICANT_ID) FROM APPLICANTS GROUP BY COMPANY_ID Results: 1 3 2 9 3 7 SELECT COMPANY_ID, COUNT(DEAL_ID) FROM DEALS GROUP BY COMPANY_ID Results: 1 3 2 11 3 8 What I'm trying to get is: 1 3 3 2 9 11 3 7 8 My problem is actually a little harder than this but if someone could tell me HOW to get my desired results above in a single SQL query then I could probably figure out the rest. -Novak [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: application.cfm
Bushy wrote: Will SESSION variables being set by one user clobber another users variables or are they unique to each individual user that accessing my application? Session variables are unique to each user... unless you don't lock them :-0.Developers who don't often -- very often -- come running, wondering why their users are seeing mixed sessions. Read Jim Davis' excellent tutorial on why you Just Say Yes to locking, and why, at http://depressedpress.com. Cheers, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]