RE: CFFunction Question
Bryan F. Hogan said: I know that. I can't remember what I was doing. But there IS a bug somewhere where not using pounds on arguments causes an error. Just can't remember where. Bugs that are not reported don't exist. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Password Logic
-Original Message- From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Mon, 5 Jan 2004 10:25:27 -0500 Subject: Re: Password Logic but you only need the public key for password verification (eg encrypt th epassword again and verify the encrypted data). Only selected personel would have access to the private key in case anything needs to be decrypted. This could also happen from an intranet system that has access to the same database. While you can use a public key to verify a password, you need the private key to encrypt the password in the first place. Actually that is not true. Imagine the following scenario: The webserver only has the public key. The user enters his password for the first time and the webserver encrypts it using the public key (no problems there, only someone with the private key can now read the password). To verify the password the webserver only has to re-encrypt the entered string and compare the two encrypted strings. As for decrypting the password, this is not possible on the webserver itself (it does not have the private key), but support personel working on a different server which does have the private key can always decrypt the string if the need should arise. I have implemented this before, so I know it is possible. You just need to pick the right method of encryption. Jesse [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Password Logic
You can also generate a random string (or a word from a dictionary file) asking the user to remember this (and write it down if needed). Then ask for that when the user enters his new password. It's easier than coming up with something yourself which will be something close to the person in question most of the time anyways (like wife's name, first child, the dog etc). Jesse -Original Message- From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Mon, 5 Jan 2004 07:59:15 -0800 Subject: RE: Password Logic Mauricio's system is definitely a cut above many others, but as was pointed out it has a weakness.The email goes to a unique address, but you can't gaurantee the recipient is the actual user.You need to authenticate the person and not the address to take this a step further. I use the same system Mauricio describes, but I add in a hint/answer supplied by the user.User writes the question out him/herself, and supplies the case-sensitive answer.In addition to the two password fields on the change screen, the user has to answer the question correctly (its up to the user to pick a q/a only they know and can figure out... Another failure point but I can't see a way to strengthen it). When a user requests a new password, the admin gets an email (almost always worthless, but on one occasion did alert me to a hack attempt). If a user retries more than X times, I lock them out for the duration of their session.Keeps out automated attacks and resets itself so the admin doesn't get bothered too much. I never send passwords.If a user fails the self-service system then I tell them to run the change password routine.If they forget their hint/answer and can be real-world authenticated then I wipe the hint/answer and then make them change their password via the automated system, which upon seeing no hint/answer will demand a new one. The hint is encrypted, the answer is a salted hash. Salted hash:Do the passwords like that as well.Adding salt prevents two hashes from being unique no matter what, and kills dictionary attacks (I still run proposed passwords thru a dictionary filter, just to be mean). Google 'salted hash' and read the MSDN Security Brief that should be the #2 response.In addition to explaining the concept it has some excellent free word-list dictionary sources in it, in mnay languages. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Password Logic
I have an SP for generating a password based on a username and a 'seed' which will generate a random password which is unique for that user. _ From: Jesse Houwing [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 10:01 To: CF-Talk Subject: RE: Password Logic You can also generate a random string (or a word from a dictionary file) asking the user to remember this (and write it down if needed). Then ask for that when the user enters his new password. It's easier than coming up with something yourself which will be something close to the person in question most of the time anyways (like wife's name, first child, the dog etc). Jesse -Original Message- From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Mon, 5 Jan 2004 07:59:15 -0800 Subject: RE: Password Logic Mauricio's system is definitely a cut above many others, but as was pointed out it has a weakness.The email goes to a unique address, but you can't gaurantee the recipient is the actual user.You need to authenticate the person and not the address to take this a step further. I use the same system Mauricio describes, but I add in a hint/answer supplied by the user.User writes the question out him/herself, and supplies the case-sensitive answer.In addition to the two password fields on the change screen, the user has to answer the question correctly (its up to the user to pick a q/a only they know and can figure out... Another failure point but I can't see a way to strengthen it). When a user requests a new password, the admin gets an email (almost always worthless, but on one occasion did alert me to a hack attempt). If a user retries more than X times, I lock them out for the duration of their session.Keeps out automated attacks and resets itself so the admin doesn't get bothered too much. I never send passwords.If a user fails the self-service system then I tell them to run the change password routine.If they forget their hint/answer and can be real-world authenticated then I wipe the hint/answer and then make them change their password via the automated system, which upon seeing no hint/answer will demand a new one. The hint is encrypted, the answer is a salted hash. Salted hash:Do the passwords like that as well.Adding salt prevents two hashes from being unique no matter what, and kills dictionary attacks (I still run proposed passwords thru a dictionary filter, just to be mean). Google 'salted hash' and read the MSDN Security Brief that should be the #2 response.In addition to explaining the concept it has some excellent free word-list dictionary sources in it, in mnay languages. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com http://mysecretbase.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Frames
Hi My left frame has got a link LOGIN and it opens a Login form on right frame. I want to get rid of the LOGIN link and give my administrator direct access to that login form page. So they jus type in http://www.abc.com/index.htm and they go direct inot login form with having left and top frames on right place. How can I specify the form target through URL address bar? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help
Yes I am using Flash Remoting in a shared hosting environemnt and have exactly the problem you describe.The unsatisfactory solution has been to put all my cfCFCsin the same directory and only call them from that directory.Otherwise the path gets screwed up since the braindead macromedia service can't establish different roots for CFC in different Applications. I spent quite a bit of time with my hosting provider to find a workaround, but short of all applucations on the server stuffing their CFC under the same root directory we couldn't figure it out.I would love to hear if others have had different luck. Craig Earls On Mon, 05 Jan 2004 20:14:35 -0400, you wrote: Has anyone used flash remoting on a shared hosting environment, as I¹m convinced its a problem with the path to the cfc... What hosting provider? Does it work in your local development scenario? (you do have a development server right?) Heres a snippet that should work for you: /* AS code */ obj = function () { this. (r) { trace(received: + r); } this. (e) { trace(error: + e.details); } } function init () { NetServices.setDefaultGatewayUrl(http://www.lightwillrise.com:27000/flashservices/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfc.sendmail,new obj()); service.sayHello(); } init(); /* in cfc/sendmail.cfc */ cfcomponent cffunction name=sayHello access=remote output=false returntype=string cfset var message = hello cfreturn message /cffunction /cfcomponent [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFTREE does not work on some machines
On Monday 05 Jan 2004 21:46 pm, Debbie McDaniel wrote: I have been successfully using CFTREE in a web application (CF 4.5.2 Windows 2000 SP3) since 2000. One of our execs recently purchased a new laptop (Windows XP IE 6) and now CFTREE no longer works on his machine. It worked on his old machine with no problems and continues to work for every other exec's laptop. Does the box have a JRE installed ? -- 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: flash remoting help
How do you reference that directory then? Could you give me more details, sounds like we have a winner for the problem! On 6/1/04 11:46 am, Craig Earls [EMAIL PROTECTED] wrote: Yes I am using Flash Remoting in a shared hosting environemnt and have exactly the problem you describe.The unsatisfactory solution has been to put all my cfCFCsin the same directory and only call them from that directory.Otherwise the path gets screwed up since the braindead macromedia service can't establish different roots for CFC in different Applications. I spent quite a bit of time with my hosting provider to find a workaround, but short of all applucations on the server stuffing their CFC under the same root directory we couldn't figure it out.I would love to hear if others have had different luck. Craig Earls On Mon, 05 Jan 2004 20:14:35 -0400, you wrote: Has anyone used flash remoting on a shared hosting environment, as I¹m convinced its a problem with the path to the cfc... What hosting provider? Does it work in your local development scenario? (you do have a development server right?) Heres a snippet that should work for you: /* AS code */ obj = function () { this. (r) { trace(received: + r); } this. (e) { trace(error: + e.details); } } function init () { NetServices.setDefaultGatewayUrl(http://www.lightwillrise.com:27000/flashser vices/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfc.sendmail,new obj()); service.sayHello(); } init(); /* in cfc/sendmail.cfc */ cfcomponent cffunction name=sayHello access=remote output=false returntype=string cfset var message = hello cfreturn message /cffunction /cfcomponent [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question - SOLVED
Thanks to Raymond, Bryan and everyone else that responded.I did log a bug as Raymond suggested. There was 2 solutions to the problem.The first solution was to pass the default value in for every argument that I didn't want to change.Very messy, but it does work. The 2nd solution was to use the cfset var=udf(a=x, e=y, f=z) then output #var#.When I left this yesterday I was receiving a message about var being undefined.This morning on my way in it suddenly came to me that I was seeing the output of my function on the screen before the error message appeared, just not where I wanted it.This got me thinking about how my function was declared. I had declared my function with the cffunction argument output=Yes.This was causing the UDF's body to be output.But I never had a cfreturn in my function declaration so nothing was actually returned to be put in the variable I was trying to set.DUH! So I changed the cffunction to have output=no, loaded the HTML I wanted to output into a variable in the UDF then did a cfreturn of that variable.This works like a champ! Once again, thanks for all the help. __ Bill Grover Manager, Information Systems Phone:301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail:[EMAIL PROTECTED] Rockville, MD 20850-1299 WWW:http://www.euservices.com __ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:34 PM To: CF-Talk Subject: RE: CFFunction Question Ah, ok. It is in the error msg, but in small type: Use ordered arguments instead. It looks like if you copy a UDF to one of the built-in scopes, you can't do udf(a=b) format. Which sucks. All I can say is log a bug for it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 and com objects
You probably do indeed have it working but not natively. .NET is the replacement for COM. COM has a different internal architecture from .NET and thus they are not compatibility natively. That is why you have to use the RCW which translates specific calls from managed clients into COM specific invocation requests on unmanaged COM components. Basically this makes the .NET components think they are talking to another .NET component. This is how it is implemented: Create a RCW out of the COM component Ref. the metadata assembly Dl lint he project and use its methods and properties You can do the RCW step using the Type Library Importer utility or the VS.Net IDE. Ex.) This generates metadata assembly with the name IopExampleRCW.dll out of the COM IopExamlple.dll Command line: tlbimp IopExample.dll /output:IopExampleRCW.dll /verbose In VS.NET IDE you would go to Project -Add Reference-COM tab... All of this is based on the fact that you have already registered the original COM component as well. Unless you register the original COM component none of this will work at all. This will work in all .Net invocations from C#, VB.NET and ASP.NET (et al.) http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:49 PM To: CF-Talk Subject: RE: CF MX 6.1 and com objects .Net does support com, I have it working here now. Secondly I am creating code that can be used by Windows Applications as well as ASP applications and coldfusion applications that will share common business logic. Blacknight does not support what I am trying to achive, so I am correct when I say I am not looking for a wrapper solution. Further discovery shows that I need to setup a DLLRegistrerServer or something. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 and com objects
compatibility natively - That was a good one Compatible natively - Damn MS spell checker http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:53 AM To: CF-Talk Subject: RE: CF MX 6.1 and com objects You probably do indeed have it working but not natively. .NET is the replacement for COM. COM has a different internal architecture from .NET and thus they are not compatibility natively. That is why you have to use the RCW which translates specific calls from managed clients into COM specific invocation requests on unmanaged COM components. Basically this makes the .NET components think they are talking to another .NET component. This is how it is implemented: Create a RCW out of the COM component Ref. the metadata assembly Dl lint he project and use its methods and properties You can do the RCW step using the Type Library Importer utility or the VS.Net IDE. Ex.) This generates metadata assembly with the name IopExampleRCW.dll out of the COM IopExamlple.dll Command line: tlbimp IopExample.dll /output:IopExampleRCW.dll /verbose In VS.NET IDE you would go to Project -Add Reference-COM tab... All of this is based on the fact that you have already registered the original COM component as well. Unless you register the original COM component none of this will work at all. This will work in all .Net invocations from C#, VB.NET and ASP.NET (et al.) http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:49 PM To: CF-Talk Subject: RE: CF MX 6.1 and com objects .Net does support com, I have it working here now. Secondly I am creating code that can be used by Windows Applications as well as ASP applications and coldfusion applications that will share common business logic. Blacknight does not support what I am trying to achive, so I am correct when I say I am not looking for a wrapper solution. Further discovery shows that I need to setup a DLLRegistrerServer or something. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
About CFMX and XML
Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Verity Documentation?
Where can I find Verity (as close to the CF5-bundled version as necessary) documentation beyond the OEM *ColdFusion 5 Advanced Coldfusion Administration* book? That reference helps, but it's not enough. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
http://www.cfdev.com/xml/ try google next time, but the above works. cf xml google :) -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: About CFMX and XML
There is a paper written by Nate Weiss in April of 2002 called Utilizing XML and XSLT in ColdFusion MX. It gave me a basic foundation for an RSS feed that I was working on. You can find it in the Forums of the Devnet site. Bruce - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, January 06, 2004 8:32 AM Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Here's a preso with examples. http://www.rewindlife.com/archives/16.cfm HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Thanks Tony __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:36 AM To: CF-Talk Subject: RE: About CFMX and XML http://www.cfdev.com/xml/ try google next time, but the above works. cf xml google :) -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
OK Samuel. Thanks __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:41 AM To: CF-Talk Subject: RE: About CFMX and XML Here's a preso with examples. http://www.rewindlife.com/archives/16.cfm HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF_MAX_ID - MySQL slowww
Hi all 2 questions: yesterday i need to reinstall CF MX 6.1 after 3 months works fine... Today when run this script: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID cfquery name=atualiza_db datasource=#dsn# INSERT INTO tblNews( intNewsID, strSiteID ) VALUES( #max_ID#, 'Trim(Session.Auth.strSiteID)' ) /cfquery /cftransaction cfbreak cfcatch type=database /cfcatch /cftry /cfloop CF MX hangs CPU and increase RAM again and again What's happened? How to improve performance with MySQL DB? Thanx in advance -- ___ Get your free email from http://www.mail.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Not exactly more details because theDeveloping Cold Fusion MX Applications.pdf or chm I have is good enough to start but more examples are always welcome Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:44 AM To: CF-Talk Subject: RE: About CFMX and XML what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
ahhh, well, what parts are you a bit unsure about? writing it? reading from it? extracting info from inside of it? how far have you gotten? tony -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:00 AM To: CF-Talk Subject: RE: About CFMX and XML Not exactly more details because theDeveloping Cold Fusion MX Applications.pdf or chm I have is good enough to start but more examples are always welcome Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:44 AM To: CF-Talk Subject: RE: About CFMX and XML what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: About CFMX and XML
http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Mind Mapping Programs
I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a little bit, but want to find one and use it regularly as part of my planning processes. The ones I know of are listed below. Anybody have any experience using any of these or know of other ones I have not listed here? Visual Mind MindManager X5 FreeMind MindGenius MindMapper I have not been able to find any comparison reviews for mind mapping software. Good directory link for google though: http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Creation/Mind_Mapping/ Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
writing it and using it with cfc's. ie: i would like implement one cfc to read and write config settings from one xml file..I know how to write and read..but i'm asking for best practices Do u understand what i mean? Thanks Tony __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:02 AM To: CF-Talk Subject: RE: About CFMX and XML ahhh, well, what parts are you a bit unsure about? writing it? reading from it? extracting info from inside of it? how far have you gotten? tony -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:00 AM To: CF-Talk Subject: RE: About CFMX and XML Not exactly more details because theDeveloping Cold Fusion MX Applications.pdf or chm I have is good enough to start but more examples are always welcome Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:44 AM To: CF-Talk Subject: RE: About CFMX and XML what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Thanks Massimo __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:10 AM To: CF-Talk Subject: Re: About CFMX and XML http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
sure do...and I really think that best practices are yet defined in this realm. I could be wrong, but I havent read any or heard about any xml and cfmx best practices yet. now, about cfc's and doing that, check out the cfcdevzone cfc list...there are some real good people on that list, and its very good reading! [EMAIL PROTECTED] www.cfczone.org -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:13 AM To: CF-Talk Subject: RE: About CFMX and XML writing it and using it with cfc's. ie: i would like implement one cfc to read and write config settings from one xml file..I know how to write and read..but i'm asking for best practices Do u understand what i mean? Thanks Tony __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:02 AM To: CF-Talk Subject: RE: About CFMX and XML ahhh, well, what parts are you a bit unsure about? writing it? reading from it? extracting info from inside of it? how far have you gotten? tony -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:00 AM To: CF-Talk Subject: RE: About CFMX and XML Not exactly more details because theDeveloping Cold Fusion MX Applications.pdf or chm I have is good enough to start but more examples are always welcome Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:44 AM To: CF-Talk Subject: RE: About CFMX and XML what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: About CFMX and XML
Ok. I will start. I will be asking in the way of the development. Thanks __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:14 AM To: CF-Talk Subject: RE: About CFMX and XML sure do...and I really think that best practices are yet defined in this realm. I could be wrong, but I havent read any or heard about any xml and cfmx best practices yet. now, about cfc's and doing that, check out the cfcdevzone cfc list...there are some real good people on that list, and its very good reading! [EMAIL PROTECTED] www.cfczone.org -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:13 AM To: CF-Talk Subject: RE: About CFMX and XML writing it and using it with cfc's. ie: i would like implement one cfc to read and write config settings from one xml file..I know how to write and read..but i'm asking for best practices Do u understand what i mean? Thanks Tony __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:02 AM To: CF-Talk Subject: RE: About CFMX and XML ahhh, well, what parts are you a bit unsure about? writing it? reading from it? extracting info from inside of it? how far have you gotten? tony -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:00 AM To: CF-Talk Subject: RE: About CFMX and XML Not exactly more details because theDeveloping Cold Fusion MX Applications.pdf or chm I have is good enough to start but more examples are always welcome Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:44 AM To: CF-Talk Subject: RE: About CFMX and XML what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Regex Help
With regular expressions, it tends to much, much harder to say do this when a condition is false than do this when a condition is true. One option that would at least fix the problem with the scripts (though not the textareas or the PRE blocks) would be to replace [[:space:]] with a class of space and tab.This wouldn't remove line breaks. Peter's suggestion of searching through some regex libraries is a good one.You may find something you could modify. To get a better grip on the problem, can I ask why you're removing whitespace?Is this just to reduce page size?Or is there a reason I've overlooked? --Ben Doom Ryan Edgar wrote: I've written a simple Regex to remove all the whitespace from my templates: CFSET PageSource = REReplace(PageScource, [[:space:]]{2,}, , ALL) The problem I'm having is if there is _javascript_ on a page and there are inline comments, the _javascript_ won't work. alert('Hello'); // 1st line comment alert('Is anyone there?'); // 2nd line comment becomes: alert('Hello'); // 1st line comment alert('Is anyone there?'); // 2nd line comment Is there any way I can tell the Regex to ignore (script([[:print:]])*.*/script) ? The same problem also exists with TEXTAREA and PRE where I want to keep text formatting in place. I've looked through the archives high and low but haven't been able to find anything, so any help at all would be greatly appreciated. TIA, Ryan Edgar Developer nga.net Pty Ltd. Level 2, 17 Raglan St South Melbourne 3205 t. +61 (0)3 9694 5415 f. +61 (0)3 9686 4611 Searching for the best-fit e-recruitment software? http://www.nga.net.au [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Verity Documentation?
I may be on to something here: http://www.diramb.gov.pt/search97/ On Tue, 06 Jan 2004 09:33:54 -0500, in cf-talk you wrote: Where can I find Verity (as close to the CF5-bundled version as necessary) documentation beyond the OEM *ColdFusion 5 Advanced Coldfusion Administration* book? That reference helps, but it's not enough. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Changes not being reflected.
Have any of you run across a scenario where changes are not being reflected? What I have is a page that allows uploads. On the action page I'm using CFFILE to upload it. And as I do every time a build an upload page I forgot to add the enctype attribute to the form so I got the error telling me so. Now I went in added it back in and submit the page. The same error is returned to me. The action page is not seeing that the page has been updated to include the enctype attribute. I say ok fine it's some how caching the page. I don't have any caching code in my site yet and trusted cache is turned off. I made text display change to see if the page is being updated and it is, I also viewed the HTML source of the page and the enctype attribute is included. CFML errors are emailed to me by my site wide error template that is set in the CF admin. This file sits in my web root. My site directory is Webroot programversion www.website.com components udfs errortemplate.cfm I'm using CFMX 6.1, Windows 2000 Server, IIS 5 with all the latest patches and updates. I have also tried removing the generated class files and restarting the CFMX services. This isn't the first time that this has happened. It happens periodically on minor page changes. After awhile it starts working. Anyone have any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes not being reflected.
Is the browser tools/internet options/temporary internet files/settings radio set to every visit to the page? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:48 AM To: CF-Talk Subject: Changes not being reflected. Have any of you run across a scenario where changes are not being reflected? What I have is a page that allows uploads. On the action page I'm using CFFILE to upload it. And as I do every time a build an upload page I forgot to add the enctype attribute to the form so I got the error telling me so. Now I went in added it back in and submit the page. The same error is returned to me. The action page is not seeing that the page has been updated to include the enctype attribute. I say ok fine it's some how caching the page. I don't have any caching code in my site yet and trusted cache is turned off. I made text display change to see if the page is being updated and it is, I also viewed the HTML source of the page and the enctype attribute is included. CFML errors are emailed to me by my site wide error template that is set in the CF admin. This file sits in my web root. My site directory is Webroot programversion www.website.com components udfs errortemplate.cfm I'm using CFMX 6.1, Windows 2000 Server, IIS 5 with all the latest patches and updates. I have also tried removing the generated class files and restarting the CFMX services. This isn't the first time that this has happened. It happens periodically on minor page changes. After awhile it starts working. Anyone have any ideas? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Changes not being reflected.
Yep...if you're using CFMX (may be Enterprise only) there is a setting to force CF to always look for changes or never lookthe setting name escapes me at the moment.This setting is set to NOT check once the app is in production because the code should not be changing. HTH Cheers 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: Bryan F. Hogan To: CF-Talk Sent: Tuesday, January 06, 2004 7:47 AM Subject: Changes not being reflected. Have any of you run across a scenario where changes are not being reflected? What I have is a page that allows uploads. On the action page I'm using CFFILE to upload it. And as I do every time a build an upload page I forgot to add the enctype attribute to the form so I got the error telling me so. Now I went in added it back in and submit the page. The same error is returned to me. The action page is not seeing that the page has been updated to include the enctype attribute. I say ok fine it's some how caching the page. I don't have any caching code in my site yet and trusted cache is turned off. I made text display change to see if the page is being updated and it is, I also viewed the HTML source of the page and the enctype attribute is included. CFML errors are emailed to me by my site wide error template that is set in the CF admin. This file sits in my web root. My site directory is Webroot programversion www.website.com components udfs errortemplate.cfm I'm using CFMX 6.1, Windows 2000 Server, IIS 5 with all the latest patches and updates. I have also tried removing the generated class files and restarting the CFMX services. This isn't the first time that this has happened. It happens periodically on minor page changes. After awhile it starts working. Anyone have any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes not being reflected.
Yep, -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:53 AM To: CF-Talk Subject: RE: Changes not being reflected. Is the browser tools/internet options/temporary internet files/settings radio set to every visit to the page? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Changes not being reflected.
After you cleared your class files, did you restart the CF server in the JRun Admin? Jamie On Tue, 6 Jan 2004 10:47:52 -0500, in cf-talk you wrote: Have any of you run across a scenario where changes are not being reflected? What I have is a page that allows uploads. On the action page I'm using CFFILE to upload it. And as I do every time a build an upload page I forgot to add the enctype attribute to the form so I got the error telling me so. Now I went in added it back in and submit the page. The same error is returned to me. The action page is not seeing that the page has been updated to include the enctype attribute. I say ok fine it's some how caching the page. I don't have any caching code in my site yet and trusted cache is turned off. I made text display change to see if the page is being updated and it is, I also viewed the HTML source of the page and the enctype attribute is included. CFML errors are emailed to me by my site wide error template that is set in the CF admin. This file sits in my web root. My site directory is Webroot programversion www.website.com components udfs errortemplate.cfm I'm using CFMX 6.1, Windows 2000 Server, IIS 5 with all the latest patches and updates. I have also tried removing the generated class files and restarting the CFMX services. This isn't the first time that this has happened. It happens periodically on minor page changes. After awhile it starts working. Anyone have any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes not being reflected.
That's the trusted cache option. And it is not checked. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:53 AM To: CF-Talk Subject: Re: Changes not being reflected. Yep...if you're using CFMX (may be Enterprise only) there is a setting to force CF to always look for changes or never lookthe setting name escapes me at the moment.This setting is set to NOT check once the app is in production because the code should not be changing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:flash remoting help
Yes I am using Flash Remoting in a shared hosting environemnt Tell me about it. Some sysadmins just dont know how to configure flash remoting. Is it Windows or Linux hosting? Please provide the most information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes not being reflected.
I don't have JRun installed but I did restart the services in the control panel. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:55 AM To: CF-Talk Subject: Re: Changes not being reflected. After you cleared your class files, did you restart the CF server in the JRun Admin? Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting help
In my experience its not configuring Flash Remoting, its configuring how the webroots are setup. The paths for flash remoting are based on your webroot. I use a shared environment with Crystal Tech, and remoting works just fine. You need to find out what your webroot is. Then, you can figure out your correct path. HTH, Clint Mauricio Giraldo wrote: Yes I am using Flash Remoting in a shared hosting environemnt Tell me about it. Some sysadmins just dont know how to configure flash remoting. Is it Windows or Linux hosting? Please provide the most information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:flash remoting help
In my experience its not configuring Flash Remoting, its configuring how the webroots are setup. Yes... although I have had quite a few issues with CFC mappings and Remoting since behavior in CFM is different (or has been different in the scenarios I have had) to Flashservices behavior. But that is another story. The issue is directory mapping as Clint pointed out. If the current thread problem is under Windows, maybe pointing your sysadmin to this page will help: http://www.macromedia.com/support/flash_remoting/ts/documents/iis_gateway_connection.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Changes not being reflected.
If you're pretty sure that it's a caching issue: Is there any possibility that you're getting problems with crossed sites (maybe there are multiple versions of the same site on the server, or another site with the same template path/name -- i.e. the multi-homed server caching issue)? Jamie On Tue, 6 Jan 2004 10:58:42 -0500, in cf-talk you wrote: I don't have JRun installed but I did restart the services in the control panel. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:55 AM To: CF-Talk Subject: Re: Changes not being reflected. After you cleared your class files, did you restart the CF server in the JRun Admin? Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_MAX_ID - MySQL slowww
Spectrum WebDesign said: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID It would help if we had the code for cf_max_id and if you placed some timers for the different sections. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Mind Mapping Programs
How about Visio? Shawn -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 7:11 AM To: CF-Talk Subject: OT: Mind Mapping Programs I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a little bit, but want to find one and use it regularly as part of my planning processes. The ones I know of are listed below. Anybody have any experience using any of these or know of other ones I have not listed here? Visual Mind MindManager X5 FreeMind MindGenius MindMapper I have not been able to find any comparison reviews for mind mapping software. Good directory link for google though: http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Cre ation/Mind_Mapping/ http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Cr eation/Mind_Mapping/ Dan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
julian date
What is the best way to work with julian dates in CF? I will need to convert a julian date to a formatted date and vice versa. I have never worked with julian dates before so any info you can send my way would be great. TIA Stephenie Hamilton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: julian date
Convert to julian:numberformat(dateadd(d,dateToConvert+693592,'1 Jan 1900'),99) Convert from julian:dateformat(dateadd(d,dateToConvert-693596,'1 Jan 1900'), mm-dd-) -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:40 AM To: CF-Talk Subject: julian date What is the best way to work with julian dates in CF? I will need to convert a julian date to a formatted date and vice versa. I have never worked with julian dates before so any info you can send my way would be great. TIA Stephenie Hamilton _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: julian date
There are a few Julian date UDF's at www.cflib.org...head http://www.cflib.org...headover there..:-) _ From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 16:40 To: CF-Talk Subject: julian date What is the best way to work with julian dates in CF? I will need to convert a julian date to a formatted date and vice versa. I have never worked with julian dates before so any info you can send my way would be great. TIA Stephenie Hamilton _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Upgrade Problem
I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what did you do to remedy it? Thanks, Bruce [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: SQL question
How do I get the ID of the last record in a table (mySQL db)? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT-SQL Data file issue
I used the tek-tips link below and was able to save the database. Thanks allot for everyone's help. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:17 AM To: CF-Talk Subject: RE: OT-SQL Data file issue http://www.tek-tips.com/gfaqs.cfm/pid/962/fid/4210 http://www.mssqlcity.com/FAQ/Trouble/SuspectDB.htm try these? -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:10 AM To: CF-Talk Subject: RE: OT-SQL Data file issue Unfortunately the last back up I had was from 11/28. This all happened yesterday. And yes the .ldf file was deleted. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:10 AM To: CF-Talk Subject: RE: OT-SQL Data file issue you deleted the ldb file? uhhh, hmm, do you have a backup? tw -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:06 AM To: CF-Talk Subject: OT-SQL Data file issue Ok I made a big mistake. I had a database set to FULL thinking it was set to SIMPLE and forgot to set up a job to truncate the transaction log. Needless to say, the transaction log grew huge (14g) and sucked up all my memory. So I took the database offline and deleted the file and replaced it with a new empty one. Well that made my database suspect. How can I fix this? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFSearch Ignoring Document Titles
Okay, no bites, so let me ask a simpler question. A cfsearch type=simple is *supposed* to search document title and body, no? Thanks, Jamie On Mon, 05 Jan 2004 17:37:54 -0500, in cf-talk you wrote: I've got an index created by K2 spider, but it doesn't seem to be searching on the title field (which is indeed correctly populated in the cfsearch results, I've checked using a dump). Therefore, if I search on the empty string (effectively getting all documents in the index), I see the document (Resume Template -- a word doc) among my results; however, if I search using resume, template, or resume template, the document isn't returned in the search results. Nowhere in the document do either of those terms appear, only in the title. This is why I suspect that cfsearch isn't considering titles. Any help would be appreciated. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: SQL question
Cutter (CF-Talk) wrote: How do I get the ID of the last record in a table (mySQL db)? Define 'last'. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: BD 6.1 and mySQL
I loaded BlueDragon 6.1 on my Win 2003 server this weekend. After a little wrangling I got this to work, but I can't get it to connect to my mySQL db. I did read in a FAQ on thier site about needing an updated driver or something from the mySQL site. I followed all of the necessary instructions from both sites and still have had no success. Any suggestions from anyone? Steve Cutter Blades Seacrets [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Upgrade Problem
On Tuesday 06 Jan 2004 17:01 pm, Bruce Sorge wrote: I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what did you do to remedy it? On Windows ? Have you rebooted ? Nothing in the event log (admin. tools) or CFMX logs ? -- 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: SOT: BD 6.1 and mySQL
Cutter (CF-Talk) wrote: I loaded BlueDragon 6.1 on my Win 2003 server this weekend. After a little wrangling I got this to work, but I can't get it to connect to my mySQL db. I did read in a FAQ on thier site about needing an updated driver or something from the mySQL site. I followed all of the necessary instructions from both sites and still have had no success. Any suggestions from anyone? Which instructions exactly did you follow? What arte the symptoms/error messages? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
Last time I checked, CF_MAX_ID simply did a SELECT MAX() on the table, and added one to the result. If you haven't already, make sure that you have an unique index (key) on the intNewsID column.If it's your primary key, then why aren't you using MySQL's AUTO_INCREMENT column type?It will automatically handle making unique primary keys for you. Create table tblNews ( intNewsID int unsigned not null auto_increment, ..., primary key (intNewsID) ); Cheers, barneyb -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:21 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign said: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID It would help if we had the code for cf_max_id and if you placed some timers for the different sections. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: SQL question
'last' = the last/most recent/highest autonumbered ID in the primary key of the table. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: How do I get the ID of the last record in a table (mySQL db)? Define 'last'. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Upgrade Problem
Maybe this will help: Troubleshooting DataDirect SequeLink ODBC service startup issues http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.htm http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.ht m _ From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 12:02 PM To: CF-Talk Subject: CFMX Upgrade Problem I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what did you do to remedy it? Thanks, Bruce _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: BD 6.1 and mySQL
When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faqId=216 Any help is greatly appreciated (BTW, I'm using the free server version) Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: I loaded BlueDragon 6.1 on my Win 2003 server this weekend. After a little wrangling I got this to work, but I can't get it to connect to my mySQL db. I did read in a FAQ on thier site about needing an updated driver or something from the mySQL site. I followed all of the necessary instructions from both sites and still have had no success. Any suggestions from anyone? Which instructions exactly did you follow? What arte the symptoms/error messages? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: SQL question
Cutter (CF-Talk) wrote: 'last' = the last/most recent/highest autonumbered ID in the primary key of the table. http://www.mysql.com/doc/en/Getting_unique_ID.html Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: BD 6.1 and mySQL
Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faqId=216 Can you connect using the MySQL command line tool from the same host using the same parameters? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Append to File with CFSCHEDULE
I have a requirement to append output to file when using CFSCHEDULE.By nature, when you save output to file with the publish option set in CFSCHEDULE, it overwrites the file if it exists everytime the schedule is run. I don't want to delete the file, I only want to add output data to the existing file. Anyone else dealt with this before? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Append to File with CFSCHEDULE
I'd make an intermediate template which uses cfhttp, or whatever is necessary, then uses cffile to append to your file. Then point your cfschedule at that intermediate file. Would that work? Jamie On Tue, 06 Jan 2004 12:59:43 -0400, in cf-talk you wrote: I have a requirement to append output to file when using CFSCHEDULE.By nature, when you save output to file with the publish option set in CFSCHEDULE, it overwrites the file if it exists everytime the schedule is run. I don't want to delete the file, I only want to add output data to the existing file. Anyone else dealt with this before? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Upgrade Problem
Nothing in the logs, I rebooted, etc... And of course Windows. :) - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, January 06, 2004 11:13 AM Subject: Re: CFMX Upgrade Problem On Tuesday 06 Jan 2004 17:01 pm, Bruce Sorge wrote: I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what did you do to remedy it? On Windows ? Have you rebooted ? Nothing in the event log (admin. tools) or CFMX logs ? -- 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: RE: Mind Mapping Programs
There is another I have used called TheBrain but it is not a MindMapping tool as such. http://www.thebrain.com/Default.htm Kind Regards - Mike Brunt Original Message --- How about Visio? Shawn -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 7:11 AM To: CF-Talk Subject: OT: Mind Mapping Programs I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a little bit, but want to find one and use it regularly as part of my planning processes. The ones I know of are listed below. Anybody have any experience using any of these or know of other ones I have not listed here? Visual Mind MindManager X5 FreeMind MindGenius MindMapper I have not been able to find any comparison reviews for mind mapping software. Good directory link for google though: http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Cre ation/Mind_Mapping/ http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Cr eation/Mind_Mapping/ Dan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
Jochem this the Max_ID CustomTag code (really simplest): !--- required attributes --- cfparam name=attributes.datasource cfparam name=attributes.tablename cfparam name=attributes.primarykey cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery cfif len(getmaxID.Max_ID) cfset caller.Max_ID = getmaxID.Max_ID + 1 cfelse cfset caller.Max_ID = 1 /cfif -- Barney why don't use AUTONUMBER? Please see: This tag is used as a application side autonumber In other words, instead of using the autonumber A.K.A. identity key as your primary key datatype in your database, you would use a simple number datatype. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again.This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. But my query still very sloww Do you have another option to Max_ID - Original Message - From: Barney Boisvert [EMAIL PROTECTED] Date: Tue, 6 Jan 2004 09:39:34 -0800 To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF_MAX_ID - MySQL slowww Last time I checked, CF_MAX_ID simply did a SELECT MAX() on the table, and added one to the result. If you haven't already, make sure that you have an unique index (key) on the intNewsID column.If it's your primary key, then why aren't you using MySQL's AUTO_INCREMENT column type?It will automatically handle making unique primary keys for you. Create table tblNews ( intNewsID int unsigned not null auto_increment, ..., primary key (intNewsID) ); Cheers, barneyb -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:21 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign said: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID It would help if we had the code for cf_max_id and if you placed some timers for the different sections. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: BD 6.1 and mySQL
Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faqId=216 Can you connect using the MySQL command line tool from the same host using the same parameters? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes not being reflected.
No it's a brand new intranet version. The file I'm using is no where else. Thanks for your reply though. By the way it's working now, I wish I could find out why it does that sometimes. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 11:19 AM To: CF-Talk Subject: Re: Changes not being reflected. If you're pretty sure that it's a caching issue: Is there any possibility that you're getting problems with crossed sites (maybe there are multiple versions of the same site on the server, or another site with the same template path/name -- i.e. the multi-homed server caching issue)? Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: BD 6.1 and mySQL
Cutter (CF-Talk) wrote: Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Is there something in the MySQL logs? Is there any indication of network traffic between the machine running BlueDragon and the database server? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
Those reasons for using application-side numbering are all valid, though none of them are worth a performance penalty of ANY amount.And if you're using any vendor-specific SQL, then using the built-in autonumbering is the way to go. If you want to do application-side autonumbering, there are better ways. Track your maxID in some kind of syncronized store and use that, rather than computing it on every INSERT.That'll save you from having to do that potentially very time consuming query. The easiest solution is to use a file on the file system, though that has problems with scalability.A better solution is probably to have a table in your DB like this: Create table keyGenerator ( table char(30), /* fixed width for speed */ currentMaxKey int unsigned not null, primary key (table) ); Then make a function stored in the application scope (if you're on CFMX) which takes a table name and returns the next available key, incrementing the database's value as well.Inside the function use an exclusive named lock so you don't get duplicates returned.Do NOT put the call to it inside your CFTRANSACTION block.You you need zero concurrency for that table, and transactions are designed to do exactly the opposite. Just add a row in the keyGenerator table for each table in your DB that needs an autoincrement column, and away you go.I've never implemented this in practice (DB-specific autonumbering isn't a big deal to me), but it should work a lot faster than CF_MAX_ID. Cheers, barneyb -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:14 AM To: CF-Talk Subject: RE: CF_MAX_ID - MySQL slowww Jochem this the Max_ID CustomTag code (really simplest): !--- required attributes --- cfparam name=attributes.datasource cfparam name=attributes.tablename cfparam name=attributes.primarykey cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery cfif len(getmaxID.Max_ID) cfset caller.Max_ID = getmaxID.Max_ID + 1 cfelse cfset caller.Max_ID = 1 /cfif -- Barney why don't use AUTONUMBER? Please see: This tag is used as a application side autonumber In other words, instead of using the autonumber A.K.A. identity key as your primary key datatype in your database, you would use a simple number datatype. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again.This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. But my query still very sloww Do you have another option to Max_ID - Original Message - From: Barney Boisvert [EMAIL PROTECTED] Date: Tue, 6 Jan 2004 09:39:34 -0800 To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF_MAX_ID - MySQL slowww Last time I checked, CF_MAX_ID simply did a SELECT MAX() on the table, and added one to the result. If you haven't already, make sure that you have an unique index (key) on the intNewsID column.If it's your primary key, then why aren't you using MySQL's AUTO_INCREMENT column type?It will automatically handle making unique primary keys for you. Create table tblNews ( intNewsID int unsigned not null auto_increment, ..., primary key (intNewsID) ); Cheers, barneyb -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:21 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign said: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID It would help if we had the code for cf_max_id and if you placed some timers for the different sections. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_MAX_ID - MySQL slowww
Spectrum WebDesign wrote: cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery Use the proper indexes. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again. That depends on your database. This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. And after a concurrency conflict he will be cursed. Please take a moment to think about the default transaction isolation level in MySQL and the implications that has for your code. It is currently not concurrency save. Do you have another option to Max_ID Bite the bullet and let the database generate the primary key. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_MAX_ID - MySQL slowww
Barney Boisvert wrote: The easiest solution is to use a file on the file system, though that has problems with scalability.A better solution is probably to have a table in your DB like this: Create table keyGenerator ( table char(30), /* fixed width for speed */ currentMaxKey int unsigned not null, primary key (table) ); Then make a function stored in the application scope (if you're on CFMX) which takes a table name and returns the next available key, incrementing the database's value as well.Inside the function use an exclusive named lock so you don't get duplicates returned.Do NOT put the call to it inside your CFTRANSACTION block.You you need zero concurrency for that table, and transactions are designed to do exactly the opposite. But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be far less. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Clearing all Cached Queries at Once?
It's a pretty simple matter to clear all the queries accessed in a request, say by setting a clearcache url var, and writing the code to set the cache span to a nil duration when url.clearcache exists. Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) Q2. Also, say I've got a dynamic query... cfquery ...select * from t where c = #v#/cfquery ... and I clear the query when v = 1, does this all-at-once clear the other cached versions (which were cached when v equaled 2 and v equaled 3)? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
Jochem wrote: Bite the bullet and let the database generate the primary key. Absolutely.As an aside, that MaxID tag has some pretty critical try/catch error handling in it (listed only in the readme if I recall correctly).Without it this already debateable technique is quite dangerous indeed. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Clearing all Cached Queries at Once?
Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) cfobjectcache action=""> This clears the entire server's set of cached queries. Q2. Also, say I've got a dynamic query... cfquery ...select * from t where c = #v#/cfquery ... and I clear the query when v = 1, does this all-at-once clear the other cached versions (which were cached when v equaled 2 and v equaled 3)? No, cached queries are indexed by their sql and the other attributes to the tag. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_MAX_ID - MySQL slowww
Thanks Jochem but autonumber is secure??? Using Win2K/CFMX 6.1/MySQL 4.0.1 InnoDB Transaction Table we're protected using autonumber fields Inside CFTRANSACTION or only MySQL transaction do the job - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Tue, 06 Jan 2004 19:35:57 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign wrote: cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery Use the proper indexes. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again. That depends on your database. This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. And after a concurrency conflict he will be cursed. Please take a moment to think about the default transaction isolation level in MySQL and the implications that has for your code. It is currently not concurrency save. Do you have another option to Max_ID Bite the bullet and let the database generate the primary key. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: BD 6.1 and mySQL
The only logging that is active is error logging and there are no entries here other that system restarts. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Is there something in the MySQL logs? Is there any indication of network traffic between the machine running BlueDragon and the database server? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be far less. The atomicity and isolation comes from the application-side lock.In effect, that function becomes single threaded, and since that's the ONLY access to the table, there needn't be any transactional logic on the DB side. If you use a HEAP table, you'll have to do some trickiness so that if the DB server ever goes down the table gets rebuilt with the appropriate values for the different tables.I don't think the overhead of a MyISAM table is going to be worth that headache, but I don't know that for sure. barneyb -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:42 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Barney Boisvert wrote: The easiest solution is to use a file on the file system, though that has problems with scalability.A better solution is probably to have a table in your DB like this: Create table keyGenerator ( table char(30), /* fixed width for speed */ currentMaxKey int unsigned not null, primary key (table) ); Then make a function stored in the application scope (if you're on CFMX) which takes a table name and returns the next available key, incrementing the database's value as well.Inside the function use an exclusive named lock so you don't get duplicates returned.Do NOT put the call to it inside your CFTRANSACTION block.You you need zero concurrency for that table, and transactions are designed to do exactly the opposite. But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be far less. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
iMail Web Messaging through IIS
Has anyone ever gotten the iMail web mail app to run through IIS? -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RE: Mind Mapping Programs
You are right, it is not, but a pretty darn interesting product. -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:38 PM To: CF-Talk Subject: RE: RE: Mind Mapping Programs There is another I have used called TheBrain but it is not a MindMapping tool as such. http://www.thebrain.com/Default.htm Kind Regards - Mike Brunt Original Message --- How about Visio? Shawn -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 7:11 AM To: CF-Talk Subject: OT: Mind Mapping Programs I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a little bit, but want to find one and use it regularly as part of my planning processes. The ones I know of are listed below. Anybody have any experience using any of these or know of other ones I have not listed here? Visual Mind MindManager X5 FreeMind MindGenius MindMapper I have not been able to find any comparison reviews for mind mapping software. Good directory link for google though: http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Cre ation/Mind_Mapping/ http://directory.google.com/Top/Reference/Knowledge_Management/Knowledge_Cr eation/Mind_Mapping/ Dan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_MAX_ID - MySQL slowww
Spectrum WebDesign wrote: but autonumber is secure??? Yes. Inside CFTRANSACTION or only MySQL transaction do the job They are the same. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF_MAX_ID - MySQL slowww
Barney Boisvert wrote: But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be far less. The atomicity and isolation comes from the application-side lock.In effect, that function becomes single threaded, and since that's the ONLY access to the table, there needn't be any transactional logic on the DB side. cflock is only instance wide. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: iMail Web Messaging through IIS
You mean the web interface? like http://mail.cfxhosting.com ? We used it in 2000. Where are you getting stuck? Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Heald, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:53 PM To: CF-Talk Subject: iMail Web Messaging through IIS Has anyone ever gotten the iMail web mail app to run through IIS? -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
Autonumber is secure, regardless of transactions.It uses a centralized store to ensure that the same number is NEVER issued twice for a given table, within the same server instance.For MyISAM table, the same number will never be issued twice.For InnoDB tables, the counter starts at one greater than the max value when the server starts, so if you delete the last row in a table and cycle the server, you'll get issued that same ID a second time. barneyb -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:49 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Thanks Jochem but autonumber is secure??? Using Win2K/CFMX 6.1/MySQL 4.0.1 InnoDB Transaction Table we're protected using autonumber fields Inside CFTRANSACTION or only MySQL transaction do the job - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Tue, 06 Jan 2004 19:35:57 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign wrote: cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery Use the proper indexes. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again. That depends on your database. This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. And after a concurrency conflict he will be cursed. Please take a moment to think about the default transaction isolation level in MySQL and the implications that has for your code. It is currently not concurrency save. Do you have another option to Max_ID Bite the bullet and let the database generate the primary key. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: RE: iMail Web Messaging through IIS
I am running a web server and this mail server on the same box.I run maybe 10 personal sites off the box, nothing major, all on port 80 using virtual servers.I want to be able to check my web mail at work.I can only get the the web server on port 80. I would like to run the CGI app that comes with iMail through IIS so I can simply set it up as a virtual server like mail.terminal-fusion.com, but it keeps throwing a 404 error saying that login.cgi isn't found.However if I run it through the iMail web server it works just fine, even though there is no iMail.cgi. Someone told me that ipswitch may have set the app up so it can only run through their server. I installed active perl on the system and still nothing. -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 2:00 PM To: CF-Talk Subject: RE: iMail Web Messaging through IIS You mean the web interface? like http://mail.cfxhosting.com http://mail.cfxhosting.com? We used it in 2000. Where are you getting stuck? Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Heald, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:53 PM To: CF-Talk Subject: iMail Web Messaging through IIS Has anyone ever gotten the iMail web mail app to run through IIS? -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RE: iMail Web Messaging through IIS
Someone told me that ipswitch may have set the app up so it can only run through their server. That's possible but I'm not sure. You could run the mail interface on say port 81. Then you would just go to mail.terminal-fusion.com:81 and that should work. As far as sticking with port 80, I think it may have to do with the headers in IIS. It's giving you 404 because IIS has no idea what directory it should use with that header -Original Message- From: Heald, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 2:04 PM To: CF-Talk Subject: OT: RE: iMail Web Messaging through IIS I am running a web server and this mail server on the same box.I run maybe 10 personal sites off the box, nothing major, all on port 80 using virtual servers.I want to be able to check my web mail at work.I can only get the the web server on port 80. I would like to run the CGI app that comes with iMail through IIS so I can simply set it up as a virtual server like mail.terminal-fusion.com, but it keeps throwing a 404 error saying that login.cgi isn't found.However if I run it through the iMail web server it works just fine, even though there is no iMail.cgi. Someone told me that ipswitch may have set the app up so it can only run through their server. I installed active perl on the system and still nothing. -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 2:00 PM To: CF-Talk Subject: RE: iMail Web Messaging through IIS You mean the web interface? like http://mail.cfxhosting.com http://mail.cfxhosting.com? We used it in 2000. Where are you getting stuck? Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Heald, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:53 PM To: CF-Talk Subject: iMail Web Messaging through IIS Has anyone ever gotten the iMail web mail app to run through IIS? -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
You're right.I said I'd never actually implemented it.; )You'd have to use a semaphore in the DB to lock it, and that gets nasty fast.Yeah, anyway, back to what I said at the beginning: just use the DB's autonumbering capabilities. barneyb -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:57 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Barney Boisvert wrote: But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be far less. The atomicity and isolation comes from the application-side lock.In effect, that function becomes single threaded, and since that's the ONLY access to the table, there needn't be any transactional logic on the DB side. cflock is only instance wide. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Clearing all Cached Queries at Once?
Brilliant, thanks. Jamie On Tue, 6 Jan 2004 12:47:04 -0600, in cf-talk you wrote: Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) cfobjectcache action=""> This clears the entire server's set of cached queries. Q2. Also, say I've got a dynamic query... cfquery ...select * from t where c = #v#/cfquery ... and I clear the query when v = 1, does this all-at-once clear the other cached versions (which were cached when v equaled 2 and v equaled 3)? No, cached queries are indexed by their sql and the other attributes to the tag. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
...Barney wrote... For InnoDB tables, the counter starts at one greater than the max value when the server starts, so if you delete the last row in a table and cycle the server, you'll get issued that same ID a second time. Do you're right How to skip it??? Transaction for DB level? Or CFTRANSACTION? - Original Message - From: Barney Boisvert [EMAIL PROTECTED] Date: Tue, 6 Jan 2004 11:01:43 -0800 To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF_MAX_ID - MySQL slowww Autonumber is secure, regardless of transactions.It uses a centralized store to ensure that the same number is NEVER issued twice for a given table, within the same server instance.For MyISAM table, the same number will never be issued twice.For InnoDB tables, the counter starts at one greater than the max value when the server starts, so if you delete the last row in a table and cycle the server, you'll get issued that same ID a second time. barneyb -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:49 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Thanks Jochem but autonumber is secure??? Using Win2K/CFMX 6.1/MySQL 4.0.1 InnoDB Transaction Table we're protected using autonumber fields Inside CFTRANSACTION or only MySQL transaction do the job - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Tue, 06 Jan 2004 19:35:57 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign wrote: cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery Use the proper indexes. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again. That depends on your database. This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. And after a concurrency conflict he will be cursed. Please take a moment to think about the default transaction isolation level in MySQL and the implications that has for your code. It is currently not concurrency save. Do you have another option to Max_ID Bite the bullet and let the database generate the primary key. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF_MAX_ID - MySQL slowww
You can't skip it without doing an external store like I proposed, and Jochem shot full of holes.That's just part of the way InnoDB functions. Keep in mind that this is only an issue when your server cycles, which hopefully isn't very often.It seems kind of weird, but it's for performance reasons, and not that big of a deal. Cheers, barneyb -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 11:22 AM To: CF-Talk Subject: RE: CF_MAX_ID - MySQL slowww ...Barney wrote... For InnoDB tables, the counter starts at one greater than the max value when the server starts, so if you delete the last row in a table and cycle the server, you'll get issued that same ID a second time. Do you're right How to skip it??? Transaction for DB level? Or CFTRANSACTION? - Original Message - From: Barney Boisvert [EMAIL PROTECTED] Date: Tue, 6 Jan 2004 11:01:43 -0800 To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF_MAX_ID - MySQL slowww Autonumber is secure, regardless of transactions.It uses a centralized store to ensure that the same number is NEVER issued twice for a given table, within the same server instance.For MyISAM table, the same number will never be issued twice.For InnoDB tables, the counter starts at one greater than the max value when the server starts, so if you delete the last row in a table and cycle the server, you'll get issued that same ID a second time. barneyb -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:49 AM To: CF-Talk Subject: Re: CF_MAX_ID - MySQL slowww Thanks Jochem but autonumber is secure??? Using Win2K/CFMX 6.1/MySQL 4.0.1 InnoDB Transaction Table we're protected using autonumber fields Inside CFTRANSACTION or only MySQL transaction do the job - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Tue, 06 Jan 2004 19:35:57 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign wrote: cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery Use the proper indexes. Why the hell would you want to do this? Because autonumber datatypes are not easily transferable from database to database.They are also a pain in the neck to develop with, because once the record has been created that number can never be used again. That depends on your database. This technique is not 100% necessary for Fusebox applications, but after you play with autonumbers and try and move data from one database to another you'll thank me. And after a concurrency conflict he will be cursed. Please take a moment to think about the default transaction isolation level in MySQL and the implications that has for your code. It is currently not concurrency save. Do you have another option to Max_ID Bite the bullet and let the database generate the primary key. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Upgrade Problem
I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what did you do to remedy it? I've had to manually delete the trace files to get those services to start. Switch to your CF directory, look for two 1 Mb files with these names (dir *.trc /s), and delete them: ColdFusion MX ODBC Agent.trc ColdFusion MX ODBC Server.trc Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: BD 6.1 and mySQL
MySQL has default security restrictions that typically don't allow remote hosts to connect.A quick and dirty test would be to modify the mysql start script and add an argument for --skip-grant-tables such as: $bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . .Then restart mysqld. If that works, then the more graceful solution is to first remove that argument then adjust the grant tables on the databases used from the remote host. HTH _ From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:16 PM To: CF-Talk Subject: Re: SOT: BD 6.1 and mySQL Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server IP, db name, un pw), and even uninstalled/reinstalled BD + below said instructions to start over from scratch. No luck as yet. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faq Id=216 http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?fa qId=216 Can you connect using the MySQL command line tool from the same host using the same parameters? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF / JavaScript question
I was looking around for a code example of this and haven't been able to find one - it's definitely something that's been on my list of must learn - now it's a need to learn item. I have 2 tables in my db - one is partcategory and one is partsubcatetory. I have a CF snippet set to create a form select pulldown off of the first table, but what I want to have happen is when they make a selection from the first pull down (onChange) run a 2nd query to populate the subcategory with the appropriate items. The part category pulldown select code is this: !--- part cat select pulldown --- cfquery name=selPartCat datasource=#Session.DSN# select * from partcategory /cfquery cfparam name=PartCategorySelect default= cfparam name=FindCategory default= cfset PartCategorySelect=PartCategorySelect 'option value=0' cfset PartCategorySelect=PartCategorySelect--Make A Selection-- cfoutput query=selPartCat cfset PartCategorySelect=PartCategorySelect 'option value=#selPartCat.pc_id#' cfif pc_id eq FindCategory cfset PartCategorySelect=PartCategorySelect selected /cfif cfset PartCategorySelect=PartCategorySelect #selPartCat.pc_category# /cfoutput cfset PartCategorySelect=PartCategorySelect /select cfset PartCategorySelect='select name=PartCategorySelect' PartCategorySelect !--- end part cat pulldown --- cfoutput#PartCategorySelect#/cfoutput This gives me a nice pulldown with the correct values and selection names. Now I'm stuck on the _javascript_ to get the 2nd query / pulldown to be created. Thanks. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF / JavaScript question
I'm not sure what you're doing here. But why not just put the select fields into a seperate templates and then call them as you need to? ( cfinclude ) - Original Message - From: Steve Logan To: CF-Talk Sent: Tuesday, January 06, 2004 2:49 PM Subject: CF / _javascript_ question I was looking around for a code example of this and haven't been able to find one - it's definitely something that's been on my list of must learn - now it's a need to learn item. I have 2 tables in my db - one is partcategory and one is partsubcatetory. I have a CF snippet set to create a form select pulldown off of the first table, but what I want to have happen is when they make a selection from the first pull down (onChange) run a 2nd query to populate the subcategory with the appropriate items. The part category pulldown select code is this: !--- part cat select pulldown --- cfquery name=selPartCat datasource=#Session.DSN# select * from partcategory /cfquery cfparam name=PartCategorySelect default= cfparam name=FindCategory default= cfset PartCategorySelect=PartCategorySelect 'option value=0' cfset PartCategorySelect=PartCategorySelect--Make A Selection-- cfoutput query=selPartCat cfset PartCategorySelect=PartCategorySelect 'option value=#selPartCat.pc_id#' cfif pc_id eq FindCategory cfset PartCategorySelect=PartCategorySelect selected /cfif cfset PartCategorySelect=PartCategorySelect #selPartCat.pc_category# /cfoutput cfset PartCategorySelect=PartCategorySelect /select cfset PartCategorySelect='select name=PartCategorySelect' PartCategorySelect !--- end part cat pulldown --- cfoutput#PartCategorySelect#/cfoutput This gives me a nice pulldown with the correct values and selection names. Now I'm stuck on the _javascript_ to get the 2nd query / pulldown to be created. Thanks. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF / JavaScript question
http://www.webtricks.com/sourcecode/code.cfm?CodeID=18 http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106viewName=Exchange%20Search%20Detailsauthorid=7653985page=0scrollPos=0subcatid=0snid=sn106itemnumber=13extid=1000288catid=0 - Original Message - From: Daniel Farmer To: CF-Talk Sent: Tuesday, January 06, 2004 12:54 PM Subject: Re: CF / _javascript_ question I'm not sure what you're doing here. But why not just put the select fields into a seperate templates and then call them as you need to? ( cfinclude ) - Original Message - From: Steve Logan To: CF-Talk Sent: Tuesday, January 06, 2004 2:49 PM Subject: CF / _javascript_ question I was looking around for a code example of this and haven't been able to find one - it's definitely something that's been on my list of must learn - now it's a need to learn item. I have 2 tables in my db - one is partcategory and one is partsubcatetory. I have a CF snippet set to create a form select pulldown off of the first table, but what I want to have happen is when they make a selection from the first pull down (onChange) run a 2nd query to populate the subcategory with the appropriate items. The part category pulldown select code is this: !--- part cat select pulldown --- cfquery name=selPartCat datasource=#Session.DSN# select * from partcategory /cfquery cfparam name=PartCategorySelect default= cfparam name=FindCategory default= cfset PartCategorySelect=PartCategorySelect 'option value=0' cfset PartCategorySelect=PartCategorySelect--Make A Selection-- cfoutput query=selPartCat cfset PartCategorySelect=PartCategorySelect 'option value=#selPartCat.pc_id#' cfif pc_id eq FindCategory cfset PartCategorySelect=PartCategorySelect selected /cfif cfset PartCategorySelect=PartCategorySelect #selPartCat.pc_category# /cfoutput cfset PartCategorySelect=PartCategorySelect /select cfset PartCategorySelect='select name=PartCategorySelect' PartCategorySelect !--- end part cat pulldown --- cfoutput#PartCategorySelect#/cfoutput This gives me a nice pulldown with the correct values and selection names. Now I'm stuck on the _javascript_ to get the 2nd query / pulldown to be created. Thanks. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF / JavaScript question
Hi Steve, Take a look at the _javascript_ on this page.It might help. http://www.jascouniform.com/ecom/showdetl.cfm?User_ID=4326092st=4888st2=79755318st3=70838938Product_ID=4240 Select a color and the size changes, select a size and the price changes.Not exactly what you wanted but the concept is there. Also, why not join your query to get all the data from both tables at once and group it, put the results in a _javascript_ array, and use this array to populate the selects.Hope this helps... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Studio MX 2004 with Flash Professional
Does anyone know where to get Studio MX 2004 w/ Flash Professional for less than on Macromedia's site?I'm looking to purchase it and was curious if anyone had any leads on a cheaper source.Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Calculating Disk Space??
Hello writing a web file uploader for a project area and we want to show how much disk space is left so users don't try to upload bigger files. (which of course I will also check on file size). anyone know of any good CF stuff for calculating disk space left? Thank you Troy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Calculating Disk Space??
http://www.cflib.org/udf.cfm/freespace [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]