Re: Routines cannot be declared more than once. UDF ???
Aside from this UDF issue, it's worth noting that if you use a / at the end of your custom tag call, the code will run twice, which could be bad if you're writing code that hanndles money, but is always going to make your code twice as slow whatever the circumstance. What you can do if you want is wrap this around the content of your custom tag: cfif thistag.executionMode eq start...code goes here.../cfif Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:44 PM Subject: Re: Routines cannot be declared more than once. UDF ??? V5 Thanks Isaac, this was indeed the problem, I called the custom tag like tag / trying to confirm with valid xml... Thanks again.. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 2:39 PM Subject: Re: Routines cannot be declared more than once. UDF ??? What version of CF Server? I know at least one way this can happen using CF 5. cfinclude template=myudftemplate.cfm / The trailing slash at the end of the tag (recommended on CF MX as valid xml syntax) causes the file to be included twice (or such was my experience). Otherwise, do a multifile search through the application directory and all subdirectories for the name of the function and if that turns up nothing, then do the same search for the name of the file containing its definition. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 I get the following error, I tried everything, even putting the function in a seperate file. And the function is not declared twice for sure. anyone? Error Diagnostic Information Routines cannot be declared more than once. The routine rfc has been declared twice in different templates. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Routines cannot be declared more than once. UDF ???
Any idea why it runs twice when you terminate it with a forward slash? So you can't make your ocde xml compliant in CF5? - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:46 PM Subject: Re: Routines cannot be declared more than once. UDF ??? Aside from this UDF issue, it's worth noting that if you use a / at the end of your custom tag call, the code will run twice, which could be bad if you're writing code that hanndles money, but is always going to make your code twice as slow whatever the circumstance. What you can do if you want is wrap this around the content of your custom tag: cfif thistag.executionMode eq start...code goes here.../cfif Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:44 PM Subject: Re: Routines cannot be declared more than once. UDF ??? V5 Thanks Isaac, this was indeed the problem, I called the custom tag like tag / trying to confirm with valid xml... Thanks again.. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 2:39 PM Subject: Re: Routines cannot be declared more than once. UDF ??? What version of CF Server? I know at least one way this can happen using CF 5. cfinclude template=myudftemplate.cfm / The trailing slash at the end of the tag (recommended on CF MX as valid xml syntax) causes the file to be included twice (or such was my experience). Otherwise, do a multifile search through the application directory and all subdirectories for the name of the function and if that turns up nothing, then do the same search for the name of the file containing its definition. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 I get the following error, I tried everything, even putting the function in a seperate file. And the function is not declared twice for sure. anyone? Error Diagnostic Information Routines cannot be declared more than once. The routine rfc has been declared twice in different templates. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Routines cannot be declared more than once. UDF ???
because that is shorthand for a matched ending tag that can have text inside it cfmodule template=foo.cfm / is the equivalent of cfmodule template=foo.cfm /cfmodule This is standard and common , esp for the XML and XHTML people out there. That means that unless you've wrapped your custom tag's code with logic to catch when the execution mode is start versus end, then the code will get run twice : once when the beginning of the tag is encountered and once when the ending of the tag is encountered you likely want to use something like: cfif thisTag.ExecutionMode is 'start' ...etc to restrict the execution to only occuring once - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 4:48 AM Subject: Re: Routines cannot be declared more than once. UDF ??? Any idea why it runs twice when you terminate it with a forward slash? So you can't make your ocde xml compliant in CF5? - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:46 PM Subject: Re: Routines cannot be declared more than once. UDF ??? Aside from this UDF issue, it's worth noting that if you use a / at the end of your custom tag call, the code will run twice, which could be bad if you're writing code that hanndles money, but is always going to make your code twice as slow whatever the circumstance. What you can do if you want is wrap this around the content of your custom tag: cfif thistag.executionMode eq start...code goes here.../cfif Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:44 PM Subject: Re: Routines cannot be declared more than once. UDF ??? V5 Thanks Isaac, this was indeed the problem, I called the custom tag like tag / trying to confirm with valid xml... Thanks again.. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 2:39 PM Subject: Re: Routines cannot be declared more than once. UDF ??? What version of CF Server? I know at least one way this can happen using CF 5. cfinclude template=myudftemplate.cfm / The trailing slash at the end of the tag (recommended on CF MX as valid xml syntax) causes the file to be included twice (or such was my experience). Otherwise, do a multifile search through the application directory and all subdirectories for the name of the function and if that turns up nothing, then do the same search for the name of the file containing its definition. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 I get the following error, I tried everything, even putting the function in a seperate file. And the function is not declared twice for sure. anyone? Error Diagnostic Information Routines cannot be declared more than once. The routine rfc has been declared twice in different templates. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Routines cannot be declared more than once. UDF ???
you likely want to use something like: cfif thisTag.ExecutionMode is 'start' ...etc to restrict the execution to only occuring once BTW this is particularly handy if you want to nest calls to custom tags e.g. cf_tag1 cf_tag2 /cf_tag1 but are using cfmodule to call the tag. As all closing cfmodules look the same, the inner tags need to be closed, i.e.: cfmodule template=tag1.cfm cfmodule template=tag2.cfm/ /cfmodule But you don't want the code for the inner tags to run twice so you do the cfif thisTag.ExecutionMode is 'start' trick. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Routines cannot be declared more than once. UDF ???
Well you can't write cfelse/ or /cfelse. Why would you want to make your CFML XML compliant? - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 10:48 PM Subject: Re: Routines cannot be declared more than once. UDF ??? Any idea why it runs twice when you terminate it with a forward slash? So you can't make your ocde xml compliant in CF5? - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:46 PM Subject: Re: Routines cannot be declared more than once. UDF ??? Aside from this UDF issue, it's worth noting that if you use a / at the end of your custom tag call, the code will run twice, which could be bad if you're writing code that hanndles money, but is always going to make your code twice as slow whatever the circumstance. What you can do if you want is wrap this around the content of your custom tag: cfif thistag.executionMode eq start...code goes here.../cfif Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:44 PM Subject: Re: Routines cannot be declared more than once. UDF ??? V5 Thanks Isaac, this was indeed the problem, I called the custom tag like tag / trying to confirm with valid xml... Thanks again.. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 2:39 PM Subject: Re: Routines cannot be declared more than once. UDF ??? What version of CF Server? I know at least one way this can happen using CF 5. cfinclude template=myudftemplate.cfm / The trailing slash at the end of the tag (recommended on CF MX as valid xml syntax) causes the file to be included twice (or such was my experience). Otherwise, do a multifile search through the application directory and all subdirectories for the name of the function and if that turns up nothing, then do the same search for the name of the file containing its definition. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 I get the following error, I tried everything, even putting the function in a seperate file. And the function is not declared twice for sure. anyone? Error Diagnostic Information Routines cannot be declared more than once. The routine rfc has been declared twice in different templates. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form validation
Hi folk, I need to validate all fields of a membership form in my huge CFMX app. But I don't have enough information about the reliable way. I have searched the web but found no reliable and full (advanced level) information. Is there a guide, a sample or an article to help me? What are your suggestions? Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form validation
There is something out there called FusionScript. It is supposed to allow you to validate nearly every field type, and it is ColdFusion based. You can download it at www.fusionscript.com. The current version that is out there is free. The next version you may have to pay for, Nate has not totally decided yet. I just started playing around with it a few weeks ago and so far it is very good. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:28 AM Subject: Form validation Hi folk, I need to validate all fields of a membership form in my huge CFMX app. But I don't have enough information about the reliable way. I have searched the web but found no reliable and full (advanced level) information. Is there a guide, a sample or an article to help me? What are your suggestions? Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form validation
Is it secure? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:08 PM To: CF-Talk Subject: Re: Form validation There is something out there called FusionScript. It is supposed to allow you to validate nearly every field type, and it is ColdFusion based. You can download it at www.fusionscript.com. The current version that is out there is free. The next version you may have to pay for, Nate has not totally decided yet. I just started playing around with it a few weeks ago and so far it is very good. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:28 AM Subject: Form validation Hi folk, I need to validate all fields of a membership form in my huge CFMX app. But I don't have enough information about the reliable way. I have searched the web but found no reliable and full (advanced level) information. Is there a guide, a sample or an article to help me? What are your suggestions? Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form validation
What do you mean? You mean, does it jack with the OS or files on the system? It does not. Check out the site, read the docs and you will get a good idea what it is and what it does. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 9:34 AM Subject: RE: Form validation Is it secure? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:08 PM To: CF-Talk Subject: Re: Form validation There is something out there called FusionScript. It is supposed to allow you to validate nearly every field type, and it is ColdFusion based. You can download it at www.fusionscript.com. The current version that is out there is free. The next version you may have to pay for, Nate has not totally decided yet. I just started playing around with it a few weeks ago and so far it is very good. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:28 AM Subject: Form validation Hi folk, I need to validate all fields of a membership form in my huge CFMX app. But I don't have enough information about the reliable way. I have searched the web but found no reliable and full (advanced level) information. Is there a guide, a sample or an article to help me? What are your suggestions? Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Routines cannot be declared more than once. UDF ???
Theoretically if the cfml language had a complete xsd it could be validated against, you could use the new xml functions in CF MX to parse cfml templates to examine them for various conditions or to get certain information out of them. I could see potentially automatic diagramming of the flow control of a cfml template (which might make any mistakes you'd made more obvious from looking at it). A niche application to be sure. :) Although you might be able to do that now dependant on how lenient the xml functions are -- I haven't done any work with them yet, so I can't say from experience. Well you can't write cfelse/ or /cfelse. Why would you want to make your CFML XML compliant? - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 10:48 PM Subject: Re: Routines cannot be declared more than once. UDF ??? Any idea why it runs twice when you terminate it with a forward slash? So you can't make your ocde xml compliant in CF5? - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:46 PM Subject: Re: Routines cannot be declared more than once. UDF ??? Aside from this UDF issue, it's worth noting that if you use a / at the end of your custom tag call, the code will run twice, which could be bad if you're writing code that hanndles money, but is always going to make your code twice as slow whatever the circumstance. What you can do if you want is wrap this around the content of your custom tag: cfif thistag.executionMode eq start...code goes here.../cfif Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:44 PM Subject: Re: Routines cannot be declared more than once. UDF ??? V5 Thanks Isaac, this was indeed the problem, I called the custom tag like tag / trying to confirm with valid xml... Thanks again.. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 2:39 PM Subject: Re: Routines cannot be declared more than once. UDF ??? What version of CF Server? I know at least one way this can happen using CF 5. cfinclude template=myudftemplate.cfm / The trailing slash at the end of the tag (recommended on CF MX as valid xml syntax) causes the file to be included twice (or such was my experience). Otherwise, do a multifile search through the application directory and all subdirectories for the name of the function and if that turns up nothing, then do the same search for the name of the file containing its definition. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID= 21816 I get the following error, I tried everything, even putting the function in a seperate file. And the function is not declared twice for sure. anyone? Error Diagnostic Information Routines cannot be declared more than once. The routine rfc has been declared twice in different templates. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form validation
FusionScript is designed to allow you to use reasonably simple ColdFusion tags (custom tags) to create client-side JavaScript code essentially using the same syntax you use for the rest of your ColdFusion code. I haven't used it personally because of it's use of custom tags and my still trying to support CF 5. ( Without cfimport you have to have all your templates in the same directory or you have to put the FusionScript templates in the custom tags directory which usually isn't feasable if you have shared hosting. ) FusionScript does some other things (the ActiveServer component is really impressive -- it's not actually a server, just a means of communicating with the CF Server without refreshing a page), but as I understood it, that was the original thrust of it. If you're just looking to validate your data, you can of course, always use server-side script on the action page. I frequently place the action-page within the same template and have it post back to itself, perform validation at the top with a try-catch statement then populate the form with form variables. cfif isdefined(form.membername) cftry cfif not len(trim(form.membername)) cfthrow type=mycustomtype message=Please enter your name. /cfif cfif not isemail(form.memberemail) cfthrow type=mycustomtype message=Please enter a valid email address. /cfif ...etc... cfquery ... INSERT INTO MEMBERS ... /cfquery cfcatch type=mycustomtype div style=color:red; cfoutput#cfcatch.message#/cfoutput /div /cfcatch /cftry /cfif form ... cfparam name=form.membername type=string default= input type=text name=membername value=#htmleditformat(form.membername)# ...etc... /form You can also use CFForm for which there is plenty of documentation -- it creates client-side javascript validation. I've avoided using it in general because I've not been happy with the way it works. On CFMX it includes a client side .js file which can be pointed to with a new scriptsrc attribute, i.e. cfform scriptsrc=/lib/cfform.js ... This is an improvement over the previous versions as it allows you to customize the client-side script and the behavior of the cfform tag without making any changes to the CF Server. Then there's the default ColdFusion Server server-side validation: input type=text name=membername value= input type=hidden name=membername_required value=Please enter your name. This will halt processing of the next page and ask the user to use their browser's back button, providing a list of error messages from fields not properly provided. _required requires a field, _date requires the field to be a date and _numeric requires the field to be a number. I think there may be a couple others, but those are the ones I remember. It should still be in the CF Server documentation. And then there's the qForms API ( http://www.pengoworks.com ) which is a JavaScript API for client-side form validation. I use it (usually in combination with server-side validation using the try-catch as above). I've been pretty impressed with the API in general, although it does show the occasional bug, just like any other open-source project. I've had to fix the _trim() function a couple times by overwriting the one provided in the API with my own (infinite loop - ick). One or more of these should get you where you need to be. :) If you use client-side validation ( cfform, qForms or FusionScript ) I also recommend that you use some form of server-side validation as well. The default ColdFusion Server method of using hidden form fields with _required, _date etc. is likely to be the easiest and as a result least prone to error. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 What do you mean? You mean, does it jack with the OS or files on the system? It does not. Check out the site, read the docs and you will get a good idea what it is and what it does. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 9:34 AM Subject: RE: Form validation Is it secure? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:08 PM To: CF-Talk Subject: Re: Form validation There is something out there called FusionScript. It is supposed to allow you to validate nearly every field type, and it is ColdFusion based. You can download it at www.fusionscript.com. The current version that is out there is free. The next version you may have to pay for, Nate
RE: Form validation
It's known that hackers are trying to post malformed information to the server gaining an idea through the forms in a site. So form validation is an important issue. I know the FusionScript a little, it is a rich tool. But I'm not sure that it's security, has no bug. It doesn't guarantee this, does it? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:45 PM To: CF-Talk Subject: Re: Form validation What do you mean? You mean, does it jack with the OS or files on the system? It does not. Check out the site, read the docs and you will get a good idea what it is and what it does. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 9:34 AM Subject: RE: Form validation Is it secure? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 5:08 PM To: CF-Talk Subject: Re: Form validation There is something out there called FusionScript. It is supposed to allow you to validate nearly every field type, and it is ColdFusion based. You can download it at www.fusionscript.com. The current version that is out there is free. The next version you may have to pay for, Nate has not totally decided yet. I just started playing around with it a few weeks ago and so far it is very good. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:28 AM Subject: Form validation Hi folk, I need to validate all fields of a membership form in my huge CFMX app. But I don't have enough information about the reliable way. I have searched the web but found no reliable and full (advanced level) information. Is there a guide, a sample or an article to help me? What are your suggestions? Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form validation
Quoting Murat Demirci [EMAIL PROTECTED]: I know the FusionScript a little, it is a rich tool. But I'm not sure that it's security, has no bug. All software is either trivial or has bugs. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form validation
You are right. Wait for another mail from me. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:42 PM To: CF-Talk Subject: RE: Form validation Quoting Murat Demirci [EMAIL PROTECTED]: I know the FusionScript a little, it is a rich tool. But I'm not sure that it's security, has no bug. All software is either trivial or has bugs. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form validation
I prefer to start validation at server, and than do Javascript equivalent. But I need reliable UDFs or Custom Tags, OR I can code all of them, but I need a guide that shows me what is a valid e-mail address and what is not. Client-side solutions are user friendly but not powerful. And security is the most important point for my membership module. If there isn't a powerful server-side solution to validate forms, converting client-side Javascript codes to CF codes will be most preferable way for me. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:26 PM To: CF-Talk Subject: Re: Form validation FusionScript is designed to allow you to use reasonably simple ColdFusion tags (custom tags) to create client-side JavaScript code essentially using the same syntax you use for the rest of your ColdFusion code. I haven't used it personally because of it's use of custom tags and my still trying to support CF 5. ( Without cfimport you have to have all your templates in the same directory or you have to put the FusionScript templates in the custom tags directory which usually isn't feasable if you have shared hosting. ) FusionScript does some other things (the ActiveServer component is really impressive -- it's not actually a server, just a means of communicating with the CF Server without refreshing a page), but as I understood it, that was the original thrust of it. If you're just looking to validate your data, you can of course, always use server-side script on the action page. I frequently place the action-page within the same template and have it post back to itself, perform validation at the top with a try-catch statement then populate the form with form variables. cfif isdefined(form.membername) cftry cfif not len(trim(form.membername)) cfthrow type=mycustomtype message=Please enter your name. /cfif cfif not isemail(form.memberemail) cfthrow type=mycustomtype message=Please enter a valid email address. /cfif ...etc... cfquery ... INSERT INTO MEMBERS ... /cfquery cfcatch type=mycustomtype div style=color:red; cfoutput#cfcatch.message#/cfoutput /div /cfcatch /cftry /cfif form ... cfparam name=form.membername type=string default= input type=text name=membername value=#htmleditformat(form.membername)# ...etc... /form You can also use CFForm for which there is plenty of documentation -- it creates client-side javascript validation. I've avoided using it in general because I've not been happy with the way it works. On CFMX it includes a client side .js file which can be pointed to with a new scriptsrc attribute, i.e. cfform scriptsrc=/lib/cfform.js ... This is an improvement over the previous versions as it allows you to customize the client-side script and the behavior of the cfform tag without making any changes to the CF Server. Then there's the default ColdFusion Server server-side validation: input type=text name=membername value= input type=hidden name=membername_required value=Please enter your name. This will halt processing of the next page and ask the user to use their browser's back button, providing a list of error messages from fields not properly provided. _required requires a field, _date requires the field to be a date and _numeric requires the field to be a number. I think there may be a couple others, but those are the ones I remember. It should still be in the CF Server documentation. And then there's the qForms API ( http://www.pengoworks.com ) which is a JavaScript API for client-side form validation. I use it (usually in combination with server-side validation using the try-catch as above). I've been pretty impressed with the API in general, although it does show the occasional bug, just like any other open-source project. I've had to fix the _trim() function a couple times by overwriting the one provided in the API with my own (infinite loop - ick). One or more of these should get you where you need to be. :) If you use client-side validation ( cfform, qForms or FusionScript ) I also recommend that you use some form of server-side validation as well. The default ColdFusion Server method of using hidden form fields with _required, _date etc. is likely to be the easiest and as a result least prone to error. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 What do you mean? You mean, does it jack with the OS or files on the system? It does not. Check out the site, read the docs and you will get a good idea
RE: Form validation
Maybe combining the FusionScript or the qForms with some server-side codes is the best way? You know client-side solutions isn't secure, they are easily breakable. Any more suggestions? -Original Message- From: Murat Demirci [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:50 PM To: CF-Talk Subject: RE: Form validation I prefer to start validation at server, and than do Javascript equivalent. But I need reliable UDFs or Custom Tags, OR I can code all of them, but I need a guide that shows me what is a valid e-mail address and what is not. Client-side solutions are user friendly but not powerful. And security is the most important point for my membership module. If there isn't a powerful server-side solution to validate forms, converting client-side Javascript codes to CF codes will be most preferable way for me. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:26 PM To: CF-Talk Subject: Re: Form validation FusionScript is designed to allow you to use reasonably simple ColdFusion tags (custom tags) to create client-side JavaScript code essentially using the same syntax you use for the rest of your ColdFusion code. I haven't used it personally because of it's use of custom tags and my still trying to support CF 5. ( Without cfimport you have to have all your templates in the same directory or you have to put the FusionScript templates in the custom tags directory which usually isn't feasable if you have shared hosting. ) FusionScript does some other things (the ActiveServer component is really impressive -- it's not actually a server, just a means of communicating with the CF Server without refreshing a page), but as I understood it, that was the original thrust of it. If you're just looking to validate your data, you can of course, always use server-side script on the action page. I frequently place the action-page within the same template and have it post back to itself, perform validation at the top with a try-catch statement then populate the form with form variables. cfif isdefined(form.membername) cftry cfif not len(trim(form.membername)) cfthrow type=mycustomtype message=Please enter your name. /cfif cfif not isemail(form.memberemail) cfthrow type=mycustomtype message=Please enter a valid email address. /cfif ...etc... cfquery ... INSERT INTO MEMBERS ... /cfquery cfcatch type=mycustomtype div style=color:red; cfoutput#cfcatch.message#/cfoutput /div /cfcatch /cftry /cfif form ... cfparam name=form.membername type=string default= input type=text name=membername value=#htmleditformat(form.membername)# ...etc... /form You can also use CFForm for which there is plenty of documentation -- it creates client-side javascript validation. I've avoided using it in general because I've not been happy with the way it works. On CFMX it includes a client side .js file which can be pointed to with a new scriptsrc attribute, i.e. cfform scriptsrc=/lib/cfform.js ... This is an improvement over the previous versions as it allows you to customize the client-side script and the behavior of the cfform tag without making any changes to the CF Server. Then there's the default ColdFusion Server server-side validation: input type=text name=membername value= input type=hidden name=membername_required value=Please enter your name. This will halt processing of the next page and ask the user to use their browser's back button, providing a list of error messages from fields not properly provided. _required requires a field, _date requires the field to be a date and _numeric requires the field to be a number. I think there may be a couple others, but those are the ones I remember. It should still be in the CF Server documentation. And then there's the qForms API ( http://www.pengoworks.com ) which is a JavaScript API for client-side form validation. I use it (usually in combination with server-side validation using the try-catch as above). I've been pretty impressed with the API in general, although it does show the occasional bug, just like any other open-source project. I've had to fix the _trim() function a couple times by overwriting the one provided in the API with my own (infinite loop - ick). One or more of these should get you where you need to be. :) If you use client-side validation ( cfform, qForms or FusionScript ) I also recommend that you use some form of server-side validation as well. The default ColdFusion Server method of using hidden form fields with _required, _date etc. is likely to be the easiest and as a result least prone to error. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms
RE: Form validation
For email I believe there's an isemail() UDF on www.cflib.org -- email validation is becoming less and less feasable with time tho... Have you tried http://devex.macromedia.com for server-side validation tools? I prefer to start validation at server, and than do Javascript equivalent. But I need reliable UDFs or Custom Tags, OR I can code all of them, but I need a guide that shows me what is a valid e-mail address and what is not. Client-side solutions are user friendly but not powerful. And security is the most important point for my membership module. If there isn't a powerful server-side solution to validate forms, converting client-side Javascript codes to CF codes will be most preferable way for me. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:26 PM To: CF-Talk Subject: Re: Form validation FusionScript is designed to allow you to use reasonably simple ColdFusion tags (custom tags) to create client-side JavaScript code essentially using the same syntax you use for the rest of your ColdFusion code. I haven't used it personally because of it's use of custom tags and my still trying to support CF 5. ( Without cfimport you have to have all your templates in the same directory or you have to put the FusionScript templates in the custom tags directory which usually isn't feasable if you have shared hosting. ) FusionScript does some other things (the ActiveServer component is really impressive -- it's not actually a server, just a means of communicating with the CF Server without refreshing a page), but as I understood it, that was the original thrust of it. If you're just looking to validate your data, you can of course, always use server-side script on the action page. I frequently place the action-page within the same template and have it post back to itself, perform validation at the top with a try-catch statement then populate the form with form variables. cfif isdefined(form.membername) cftry cfif not len(trim(form.membername)) cfthrow type=mycustomtype message=Please enter your name. /cfif cfif not isemail(form.memberemail) cfthrow type=mycustomtype message=Please enter a valid email address. /cfif ...etc... cfquery ... INSERT INTO MEMBERS ... /cfquery cfcatch type=mycustomtype div style=color:red; cfoutput#cfcatch.message#/cfoutput /div /cfcatch /cftry /cfif form ... cfparam name=form.membername type=string default= input type=text name=membername value=#htmleditformat(form.membername)# ...etc... /form You can also use CFForm for which there is plenty of documentation -- it creates client-side javascript validation. I've avoided using it in general because I've not been happy with the way it works. On CFMX it includes a client side .js file which can be pointed to with a new scriptsrc attribute, i.e. cfform scriptsrc=/lib/cfform.js ... This is an improvement over the previous versions as it allows you to customize the client-side script and the behavior of the cfform tag without making any changes to the CF Server. Then there's the default ColdFusion Server server-side validation: input type=text name=membername value= input type=hidden name=membername_required value=Please enter your name. This will halt processing of the next page and ask the user to use their browser's back button, providing a list of error messages from fields not properly provided. _required requires a field, _date requires the field to be a date and _numeric requires the field to be a number. I think there may be a couple others, but those are the ones I remember. It should still be in the CF Server documentation. And then there's the qForms API ( http://www.pengoworks.com ) which is a JavaScript API for client-side form validation. I use it (usually in combination with server-side validation using the try-catch as above). I've been pretty impressed with the API in general, although it does show the occasional bug, just like any other open-source project. I've had to fix the _trim() function a couple times by overwriting the one provided in the API with my own (infinite loop - ick). One or more of these should get you where you need to be. :) If you use client-side validation ( cfform, qForms or FusionScript ) I also recommend that you use some form of server-side validation as well. The default ColdFusion Server method of using hidden form fields with _required, _date etc. is likely to be the easiest and as a result least prone to error. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms
server tuning
There are several settings for CF5 in the cf administrator that greatly affect performance and I'm curious what others' experiences have been. Obviously everyone's hardware and software are different, but I think to hear what others have found will be illuminating. My settings are for a cluster of dual xeon 2.4 GHz cf5.0 servers and a dual xeon 2.4 GHz SQL 2k database. All servers have 2 GB of memory. Server Settings : Settings: Limit simultaneous requests to [20] [on] Timeout requests after [90] seconds [on] Timeout requests after [5] unresponsive requests [on] Restart when requests terminate abnormally ODBC: [off] Enable the limit of [0] simultaneous connections [on] Maintain database connections Connection Timeout [0] minutes Thanks, Matt BTW, for some reason this message never appeared (or wasn't accepted) on the cf-server list, so I'm trying cf-talk. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
unexpeted result with cfqueryparam
This behavior isn't a bug, although I can't explain why your code works in CF 5. CF's normal behavior is to escape a single quote contained in a SQL string value by doubling it. This is true whether you use the Trim() function or not. So you'll want to use PreserveSingleQuotes() to prevent CF from automatically escaping the single quotes in your SQL string values. The HTMLEditFormat function is used to preserve specific special characters () that are used inside CFOUTPUT tags by converting them to HTML codes (lt; etc.). But this function preserve *double* quotes, not single quotes. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Java scriptlets on CFMX
However, it wouldn't hurt to 'vote' for easier Java integration using the wish form on mm.com (the URL of which escapes me, since I'm on BART, but is posted here fairly regularly). I agree it would be interesting to explore. The URL to the wish form is below: http://www.macromedia.com/support/email/wishform/ Christian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form validation
Apologies for the shameless promotion but there's also TerraForm, which handles server side validation. All the validating code is set up in UDFs so you can read and modify it. If you want client-side, it also integrates with qForms, generating qForms client side validation commands automatically. http://www.electricsheep.co.nz/terraform/ Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 24, 2003 3:28 AM Subject: Form validation Hi folk, I need to validate all fields of a membership form in my huge CFMX app. But I don't have enough information about the reliable way. I have searched the web but found no reliable and full (advanced level) information. Is there a guide, a sample or an article to help me? What are your suggestions? Thanks in advance. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form validation
Check out hexvalidemail from hexilion. It provides email validation by looking up the hostname. The docs are ASP oriented but it's actually very easy to set up. - Original Message - From: Murat Demirci [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 24, 2003 5:50 AM Subject: RE: Form validation I prefer to start validation at server, and than do Javascript equivalent. But I need reliable UDFs or Custom Tags, OR I can code all of them, but I need a guide that shows me what is a valid e-mail address and what is not. Client-side solutions are user friendly but not powerful. And security is the most important point for my membership module. If there isn't a powerful server-side solution to validate forms, converting client-side Javascript codes to CF codes will be most preferable way for me. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:26 PM To: CF-Talk Subject: Re: Form validation FusionScript is designed to allow you to use reasonably simple ColdFusion tags (custom tags) to create client-side JavaScript code essentially using the same syntax you use for the rest of your ColdFusion code. I haven't used it personally because of it's use of custom tags and my still trying to support CF 5. ( Without cfimport you have to have all your templates in the same directory or you have to put the FusionScript templates in the custom tags directory which usually isn't feasable if you have shared hosting. ) FusionScript does some other things (the ActiveServer component is really impressive -- it's not actually a server, just a means of communicating with the CF Server without refreshing a page), but as I understood it, that was the original thrust of it. If you're just looking to validate your data, you can of course, always use server-side script on the action page. I frequently place the action-page within the same template and have it post back to itself, perform validation at the top with a try-catch statement then populate the form with form variables. cfif isdefined(form.membername) cftry cfif not len(trim(form.membername)) cfthrow type=mycustomtype message=Please enter your name. /cfif cfif not isemail(form.memberemail) cfthrow type=mycustomtype message=Please enter a valid email address. /cfif ...etc... cfquery ... INSERT INTO MEMBERS ... /cfquery cfcatch type=mycustomtype div style=color:red; cfoutput#cfcatch.message#/cfoutput /div /cfcatch /cftry /cfif form ... cfparam name=form.membername type=string default= input type=text name=membername value=#htmleditformat(form.membername)# ...etc... /form You can also use CFForm for which there is plenty of documentation -- it creates client-side javascript validation. I've avoided using it in general because I've not been happy with the way it works. On CFMX it includes a client side .js file which can be pointed to with a new scriptsrc attribute, i.e. cfform scriptsrc=/lib/cfform.js ... This is an improvement over the previous versions as it allows you to customize the client-side script and the behavior of the cfform tag without making any changes to the CF Server. Then there's the default ColdFusion Server server-side validation: input type=text name=membername value= input type=hidden name=membername_required value=Please enter your name. This will halt processing of the next page and ask the user to use their browser's back button, providing a list of error messages from fields not properly provided. _required requires a field, _date requires the field to be a date and _numeric requires the field to be a number. I think there may be a couple others, but those are the ones I remember. It should still be in the CF Server documentation. And then there's the qForms API ( http://www.pengoworks.com ) which is a JavaScript API for client-side form validation. I use it (usually in combination with server-side validation using the try-catch as above). I've been pretty impressed with the API in general, although it does show the occasional bug, just like any other open-source project. I've had to fix the _trim() function a couple times by overwriting the one provided in the API with my own (infinite loop - ick). One or more of these should get you where you need to be. :) If you use client-side validation ( cfform, qForms or FusionScript ) I also recommend that you use some form of server-side validation as well. The default ColdFusion Server method of using hidden form fields with _required, _date etc. is likely to be the easiest and as a result least prone to error. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer
Re: Routines cannot be declared more than once. UDF ???
On Sunday, February 23, 2003, at 04:48 AM, Taco Fleur wrote: Any idea why it runs twice when you terminate it with a forward slash? So you can't make your ocde xml compliant in CF5? It is so that you can detect the execution of the beginning of the tag and the end of the tag using code like this: cfif thisTag.ExecutionMode is start !--- Do something --- cfelse !--- Do something else --- /cfif It is useful in more complex tags that are nested or expect body content. As others have suggested, wrap your tag in the first if statement above so that you can close it without it executing twice. You can't make your CFML completely XML compliant, but this will get you a little closer. Christian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: unexpeted result with cfqueryparam
I didn't figure it was a bug, just couldn't see the reason for the behavior. What still doesn't seem to make sense is that using the trim() in the cfqueryparam value does add an additional apostrophe, but not using trim() doesn't. (In MX, at least.) I've used preserveSingleQuotes so doesn't escape; but, haven't seen that as necessary when cfqueryparam is used. (Are you suggesting to set the cfqueryparm value=#PreserveSingleQuotes(formValue)# ?) I began using the HTMLEditFormat for generated form values in either 4 or 5 because if someone used an apostrophe and this went directly to the database as such, it truncated the entry at the spot of the apostrophe. Using HTMLEditFormat was recommended somewhere along my learning and it worked to prevent this truncation. Thanks for the explanation. Keith E. Keith Dodd Wings of Eagles Services www.wingserv.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 12:56 PM Subject: unexpeted result with cfqueryparam This behavior isn't a bug, although I can't explain why your code works in CF 5. CF's normal behavior is to escape a single quote contained in a SQL string value by doubling it. This is true whether you use the Trim() function or not. So you'll want to use PreserveSingleQuotes() to prevent CF from automatically escaping the single quotes in your SQL string values. The HTMLEditFormat function is used to preserve specific special characters () that are used inside CFOUTPUT tags by converting them to HTML codes (lt; etc.). But this function preserve *double* quotes, not single quotes. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form validation
I haven't used it, but Pengoworks qForms is always highly recommended on this list. http://www.pengoworks.com/index.cfm?action=qForms On 2/23/03 8:50 AM, Murat Demirci [EMAIL PROTECTED] wrote: I prefer to start validation at server, and than do Javascript equivalent. But I need reliable UDFs or Custom Tags, OR I can code all of them, but I need a guide that shows me what is a valid e-mail address and what is not. Client-side solutions are user friendly but not powerful. And security is the most important point for my membership module. If there isn't a powerful server-side solution to validate forms, converting client-side Javascript codes to CF codes will be most preferable way for me. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:26 PM To: CF-Talk Subject: Re: Form validation FusionScript is designed to allow you to use reasonably simple ColdFusion tags (custom tags) to create client-side JavaScript code essentially using the same syntax you use for the rest of your ColdFusion code. I haven't used it personally because of it's use of custom tags and my still trying to support CF 5. ( Without cfimport you have to have all your templates in the same directory or you have to put the FusionScript templates in the custom tags directory which usually isn't feasable if you have shared hosting. ) FusionScript does some other things (the ActiveServer component is really impressive -- it's not actually a server, just a means of communicating with the CF Server without refreshing a page), but as I understood it, that was the original thrust of it. If you're just looking to validate your data, you can of course, always use server-side script on the action page. I frequently place the action-page within the same template and have it post back to itself, perform validation at the top with a try-catch statement then populate the form with form variables. cfif isdefined(form.membername) cftry cfif not len(trim(form.membername)) cfthrow type=mycustomtype message=Please enter your name. /cfif cfif not isemail(form.memberemail) cfthrow type=mycustomtype message=Please enter a valid email address. /cfif ...etc... cfquery ... INSERT INTO MEMBERS ... /cfquery cfcatch type=mycustomtype div style=color:red; cfoutput#cfcatch.message#/cfoutput /div /cfcatch /cftry /cfif form ... cfparam name=form.membername type=string default= input type=text name=membername value=#htmleditformat(form.membername)# ...etc... /form You can also use CFForm for which there is plenty of documentation -- it creates client-side javascript validation. I've avoided using it in general because I've not been happy with the way it works. On CFMX it includes a client side .js file which can be pointed to with a new scriptsrc attribute, i.e. cfform scriptsrc=/lib/cfform.js ... This is an improvement over the previous versions as it allows you to customize the client-side script and the behavior of the cfform tag without making any changes to the CF Server. Then there's the default ColdFusion Server server-side validation: input type=text name=membername value= input type=hidden name=membername_required value=Please enter your name. This will halt processing of the next page and ask the user to use their browser's back button, providing a list of error messages from fields not properly provided. _required requires a field, _date requires the field to be a date and _numeric requires the field to be a number. I think there may be a couple others, but those are the ones I remember. It should still be in the CF Server documentation. And then there's the qForms API ( http://www.pengoworks.com ) which is a JavaScript API for client-side form validation. I use it (usually in combination with server-side validation using the try-catch as above). I've been pretty impressed with the API in general, although it does show the occasional bug, just like any other open-source project. I've had to fix the _trim() function a couple times by overwriting the one provided in the API with my own (infinite loop - ick). One or more of these should get you where you need to be. :) If you use client-side validation ( cfform, qForms or FusionScript ) I also recommend that you use some form of server-side validation as well. The default ColdFusion Server method of using hidden form fields with _required, _date etc. is likely to be the easiest and as a result least prone to error. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 What do you mean? You mean, does it jack with the OS or
Re: Iif() and StructKeyExist()
On 2/20/03 1:17 PM, Aidan Whitehall [EMAIL PROTECTED] wrote: I've got an array of structures and am looping through them and writing several queries on the fly. However, I can't hit on just the right combination of quotation marks to stop it throwing an error. Does anyone know how to write it correctly, outputting either null or the value surrounded by apostrophes? A change in direction would be to consider if you could construct your queries with CFQUERYPARAM. Then you wouldn't need to worry about quoting or apostrophes. I'm not good off-the-cuff with cfqueryparam. I'm sure someone here can give a good example of a null check added to a cfqueryparam ... Any takers? #Iif(not StructKeyExists(values[i], proximity), DE(null), ' values[i][proximity] '))# Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: unexpeted result with cfqueryparam
Quoting [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED]: This behavior isn't a bug, although I can't explain why your code works in CF 5. I would disagree. I think it is a bug. CF's normal behavior is to escape a single quote contained in a SQL string value by doubling it. This is true whether you use the Trim() function or not. So you'll want to use PreserveSingleQuotes() to prevent CF from automatically escaping the single quotes in your SQL string values. But not when using cfqueryparam. Using cfqueryparam is meant to call the functionality of the database driver to do the escaping. Any escaping done by CF before that will only result in doubling the quotes twice, and therefore CF should do no escaping whatsoever of any value passed through cfqueryparam. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Where to purchase CF 5
On Saturday, Feb 22, 2003, at 20:19 US/Pacific, Joe Tartaglia wrote: Does anyone have any ideas on where I can purchase a legal copy of CF Server 5 for Windows? Try Macromedia - see my blog: http://www.corfield.org/blog/archives/2002_10.html#000132 Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
POST Failing from CF Server
Hi all. This is probably not CF related (but may be) but I'm hoping someone here has experienced something similar. About every 2 days or so, all POSTS from the web server will fail, and occasionally it seems as though all outgoing TCP/IP connections will fail. This is a recent phenomenon and I can't put my finger on anything I've installed recently that would have made this start happening. I use several COM objects and CFX tags, like CFX_LinkAPI, CFX_RawSocket to connect to various Credit Card processors, UPS, etc. and also use CFHTTP for some. All of a sudden, none of these will be able to connect. I can connect to the web server fine from the outside. Setup: NT 4 CF 4.5 SP 2 Website Pro 1 GB RAM Dual 512 Mz Nothing that I can see out of the ordinary appears in the event viewer. Any clues on where I should look or what I should monitor? I've gone in and checked and it doesn't appear that I'm using too many resources. In fact, it sometimes happens early in the morning when nothing is going on 9basically) on the server. Thanks for any help y'all can give me. This is frustrating. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDIRECTORY query
(Resent due to CF_Talk problems a few days ago - apologies if anyone has already got it) I've got this cute little app that uses CFDIRECTORY. When I run it at work on my CF5 dev box datelastmodified is returned as a date object and I can manipulate it with DateFormat and TimeFormat. When I run the same app at home on my MX dev box datelastmodifed get returned in the format 13 February, 2003 9:23:55 AM CST and DateFormat crashes out on it. I had a dig around CF Admin figuring it was some admin setting but couldn't find anything that looked like it. Any clues please? ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Encryption software
Depends what you are trying to encrypt... and for what purpose. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Where to purchase CF 5
Heh, I won a copy of CFMX Pro at the MXDU conference (which was excellent by the way). == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 6213 6731 Mobile: 0439 401 823 Facsimile: +61 (02) 6213 7287 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, 24 February 2003 9:22 AM To: CF-Talk Subject: Re: Where to purchase CF 5 On Saturday, Feb 22, 2003, at 20:19 US/Pacific, Joe Tartaglia wrote: Does anyone have any ideas on where I can purchase a legal copy of CF Server 5 for Windows? Try Macromedia - see my blog: http://www.corfield.org/blog/archives/2002_10.html#000132 Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDIRECTORY query
Not sure how the server is setup but try using LSParseDate or something like that. -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:10 PM To: CF-Talk Subject: CFDIRECTORY query (Resent due to CF_Talk problems a few days ago - apologies if anyone has already got it) I've got this cute little app that uses CFDIRECTORY. When I run it at work on my CF5 dev box datelastmodified is returned as a date object and I can manipulate it with DateFormat and TimeFormat. When I run the same app at home on my MX dev box datelastmodifed get returned in the format 13 February, 2003 9:23:55 AM CST and DateFormat crashes out on it. I had a dig around CF Admin figuring it was some admin setting but couldn't find anything that looked like it. Any clues please? ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDIRECTORY query
May be a bug -- have you tried #dateformat(13 February, 2003 9:23:55 AM CST)# on the CF 5 machine at work? (Resent due to CF_Talk problems a few days ago - apologies if anyone has already got it) I've got this cute little app that uses CFDIRECTORY. When I run it at work on my CF5 dev box datelastmodified is returned as a date object and I can manipulate it with DateFormat and TimeFormat. When I run the same app at home on my MX dev box datelastmodifed get returned in the format 13 February, 2003 9:23:55 AM CST and DateFormat crashes out on it. I had a dig around CF Admin figuring it was some admin setting but couldn't find anything that looked like it. Any clues please? ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Experthost error they will not respond
Nothing has changed and all of a sudden one of my clients is getting an error on their website at experthost on a shared server... Here's the error for ColdFusion query: No datasource named theusedtobedatasource is configured in jrun-resources.xml ... Here's the error for ASP query: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Access denied. I don't know if they tried to upgrade or what happened.. I have left numeous messages emails Anyone using experthost having this problem? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Experthost error they will not respond
sorry to say tracy, i am using experthost, right now, and am not having this issue, what sql server is your domain being hosted on? im on sql8 have you tried calling them, whenever i have aproblem i call them and get through fine :) tonyxs -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 9:21 PM To: CF-Talk Subject: Experthost error they will not respond Nothing has changed and all of a sudden one of my clients is getting an error on their website at experthost on a shared server... Here's the error for ColdFusion query: No datasource named theusedtobedatasource is configured in jrun-resources.xml ... Here's the error for ASP query: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Access denied. I don't know if they tried to upgrade or what happened.. I have left numeous messages emails Anyone using experthost having this problem? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Experthost error they will not respond
Yeah-- This happened to me (not the exact issue) about 3 months ago. Most people rave about them, but it was my experience that they had cycled in some new people who perhaps weren't as experienced. They never did anything to correct the situation (with the employees) nor did they do anything to help me with the fact that I lost a couple of days worth of email. That said, we keep them at arms length and only use them for things for ourselves; never for clients. NEVER for clients; not when our rep is on the line for it. Sorry, best of luck with them. -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:21 PM To: CF-Talk Subject: Experthost error they will not respond Nothing has changed and all of a sudden one of my clients is getting an error on their website at experthost on a shared server... Here's the error for ColdFusion query: No datasource named theusedtobedatasource is configured in jrun-resources.xml ... Here's the error for ASP query: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Access denied. I don't know if they tried to upgrade or what happened.. I have left numeous messages emails Anyone using experthost having this problem? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Experthost error they will not respond
I had this same problem months ago. I finally got so friggin frustrated with not only their lack of technical expertise, their unwillingness to respond to numerous emails until I literally threatened to discontinue service with them, and poor up-times, I finally went out and leased a Dell server and started to co-lo my customers sites. I used to sing their praises when I first started, but I now recant EVERYTHING that I ever said that was good about them. - Original Message - From: Tracy Bost [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:20 PM Subject: Experthost error they will not respond Nothing has changed and all of a sudden one of my clients is getting an error on their website at experthost on a shared server... Here's the error for ColdFusion query: No datasource named theusedtobedatasource is configured in jrun-resources.xml ... Here's the error for ASP query: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Access denied. I don't know if they tried to upgrade or what happened.. I have left numeous messages emails Anyone using experthost having this problem? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Experthost error they will not respond
Thanks for the response. I don't think its the database server(sql4) because I can access it with EM.. I think they have done something with the actual web server... Something similiar did happen a couple of months ago but they fixed it fairly quick.. But this has been going on since this morning.. I have been calling and leaving email all day to at least ask for a response to know they are there..The last email was this morning and the guy say Try it now of course it still didn't work... The customer service is so frustrating to say the least... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDIRECTORY query
Thanks Isaac - at work it gets returned as a date object and using DateFormat and TimeFormat works OK - MX at home returns it as 13 February, 2003 9:23:55 AM CST. At home (MX) the code is DateFormat(datelastmodfied, DD/MM/) but this crashes out whereas in CF5 it doesn't. In CF5 its getting returned as a date object so I'm not sure how I can test #dateformat(13 February, 2003 9:23:55 AM CST)# ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 February 2003 12:54 PM To: CF-Talk Subject: Re: CFDIRECTORY query May be a bug -- have you tried #dateformat(13 February, 2003 9:23:55 AM CST)# on the CF 5 machine at work? (Resent due to CF_Talk problems a few days ago - apologies if anyone has already got it) I've got this cute little app that uses CFDIRECTORY. When I run it at work on my CF5 dev box datelastmodified is returned as a date object and I can manipulate it with DateFormat and TimeFormat. When I run the same app at home on my MX dev box datelastmodifed get returned in the format 13 February, 2003 9:23:55 AM CST and DateFormat crashes out on it. I had a dig around CF Admin figuring it was some admin setting but couldn't find anything that looked like it. Any clues please? ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ExpertHost pros/cons (was RE: Experthost error they will not respond)
wow. not a good feeling. i just signed up with a reseller account and have 9 domains now thereGREAT! i havent had a single problem, YET, heh, anyone else care to berate or sing their praises yeah its off topic, but its sunday night, monday morn for some, but i gotta know...email me back off list if you must :) thanks!! tony -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 9:33 PM To: CF-Talk Subject: Re: Experthost error they will not respond I had this same problem months ago. I finally got so friggin frustrated with not only their lack of technical expertise, their unwillingness to respond to numerous emails until I literally threatened to discontinue service with them, and poor up-times, I finally went out and leased a Dell server and started to co-lo my customers sites. I used to sing their praises when I first started, but I now recant EVERYTHING that I ever said that was good about them. - Original Message - From: Tracy Bost [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 8:20 PM Subject: Experthost error they will not respond Nothing has changed and all of a sudden one of my clients is getting an error on their website at experthost on a shared server... Here's the error for ColdFusion query: No datasource named theusedtobedatasource is configured in jrun-resources.xml ... Here's the error for ASP query: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Access denied. I don't know if they tried to upgrade or what happened.. I have left numeous messages emails Anyone using experthost having this problem? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDIRECTORY query
Well -- that's the point of testing on cf 5 the format provided from the use of cfdirectory on mx... That's what I meant by trying #dateformat(13 February, 2003 9:23:55 AM CST)# (the literal string, not the cfdirectory result) on the CF 5 machine -- it might be that the CF 5 server recognizes this as a date whereas MX does not. There's not really such a thing as a date object on cf 5, it simply has an algorithm for examining a sting to determine if it is an identifiable date. So ... if this code produces different output on CFMX than it does on cf 5 then it's probably a bug -- it if produces the same output, but works on CF 5 but not on MX then it is _definitely_ a bug. cfdirectory name=mydir ... blah blah ... cfoutput#dateformat(mydir.datelastmodified)#/cfoutput Or more plainly, the question is does CF5(#mydir.datelastmodified#) == CFMX(#mydir.datelastmodified#) -- both servers should produce the same output (if you disclude the dateformat() and timeformat() functions) -- if they're not the same, it's _probably_ a bug. If they are the same then it must be a bug. Thanks Isaac - at work it gets returned as a date object and using DateFormat and TimeFormat works OK - MX at home returns it as 13 February, 2003 9:23:55 AM CST. At home (MX) the code is DateFormat(datelastmodfied, DD/MM/) but this crashes out whereas in CF5 it doesn't. In CF5 its getting returned as a date object so I'm not sure how I can test #dateformat(13 February, 2003 9:23:55 AM CST)# ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 February 2003 12:54 PM To: CF-Talk Subject: Re: CFDIRECTORY query May be a bug -- have you tried #dateformat(13 February, 2003 9:23:55 AM CST)# on the CF 5 machine at work? (Resent due to CF_Talk problems a few days ago - apologies if anyone has already got it) I've got this cute little app that uses CFDIRECTORY. When I run it at work on my CF5 dev box datelastmodified is returned as a date object and I can manipulate it with DateFormat and TimeFormat. When I run the same app at home on my MX dev box datelastmodifed get returned in the format 13 February, 2003 9:23:55 AM CST and DateFormat crashes out on it. I had a dig around CF Admin figuring it was some admin setting but couldn't find anything that looked like it. Any clues please? ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** * * ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. * * ** ~ ~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
OT: IBM/Informix Object DB's
I was wondering if anyone has worked with IBM U2 and RedBack(Middle tier?) products. Would like to know how these products work and their advantages etc. Thanks Joe Eugne ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfscript object array reference
objXMLHTTP = createObject(COM, Microsoft.XMLHTTP); The code below creates an array and assigns it to the variable objURL if I am correct objURL = objXMLDOM.getElementsByTagName(url); However I can't seem to refence to it, neither with objURL(i).text); nor with objURL[i].text); Any ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript object array reference
objURL = objXMLDOM.getElementsByTagName(url); What is objURL in CF.. i mean type of variable? You might want to dump it.. CFDUMP var=#objURL# if its just an array.. all you need objURL[i] .. Am not sure what your code objURL[i].text is for? Are u trying to parse an xmlDoc.. then its different objURL[i].xmlText; Joe Eugene -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 11:08 PM To: CF-Talk Subject: cfscript object array reference objXMLHTTP = createObject(COM, Microsoft.XMLHTTP); The code below creates an array and assigns it to the variable objURL if I am correct objURL = objXMLDOM.getElementsByTagName(url); However I can't seem to refence to it, neither with objURL(i).text); nor with objURL[i].text); Any ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript object array reference
Forgot about cfdump, will give it a try... Am not sure what your code objURL[i].text is for? Are u trying to parse an xmlDoc.. then its different objURL[i].xmlText; Following is what I am trying to achieve... objXMLHTTP = createObject(COM, Microsoft.XMLHTTP); objXMLDOM = createObject(COM, Microsoft.XMLDOM); objXMLHTTP.open(GET, http://www.coldfusionist.com/xml/rss/rss.xml;, False); objXMLHTTP.Send(); objXMLDOM = objXMLHTTP.ResponseXML; objItem = objXMLDOM.getElementsByTagName(item); writeOutput(table width=100% cellspacing=5 cellpadding=5); for (i = 0; i LTE objItem.length - 1; i = i +1 ) { writeOutput(tr); writeOutput(td width='200'); writeOutput(a href='foo' target='_blank'foo objItem(i).text); writeOutput(/a/td); writeOutput(td/td); writeOutput(/tr); } writeOutput(/table); objXMLHTTP = false; objXMLDOM = false; Joe Eugene -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 11:08 PM To: CF-Talk Subject: cfscript object array reference objXMLHTTP = createObject(COM, Microsoft.XMLHTTP); The code below creates an array and assigns it to the variable objURL if I am correct objURL = objXMLDOM.getElementsByTagName(url); However I can't seem to refence to it, neither with objURL(i).text); nor with objURL[i].text); Any ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript object array reference
can't cfdump COM objects ;(( - Original Message - From: Joe Eugene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 3:21 PM Subject: RE: cfscript object array reference objURL = objXMLDOM.getElementsByTagName(url); What is objURL in CF.. i mean type of variable? You might want to dump it.. CFDUMP var=#objURL# if its just an array.. all you need objURL[i] .. Am not sure what your code objURL[i].text is for? Are u trying to parse an xmlDoc.. then its different objURL[i].xmlText; Joe Eugene -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Sunday, February 23, 2003 11:08 PM To: CF-Talk Subject: cfscript object array reference objXMLHTTP = createObject(COM, Microsoft.XMLHTTP); The code below creates an array and assigns it to the variable objURL if I am correct objURL = objXMLDOM.getElementsByTagName(url); However I can't seem to refence to it, neither with objURL(i).text); nor with objURL[i].text); Any ideas? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: JavaScript: using Submit()
On 2/19/03 9:21 PM, Kwang Suh [EMAIL PROTECTED] wrote: Onclick expects javascript already. Actually, this isn't always the case. In IE, if your page has a VBScript as the last script in the head, then IE will interpret everything after that as VBScript. Since I use both VBScript and JavaScript at work, I now always make sure to specify the script language with the javascript: or vbscript: thingy. Good point! I never use any VB script so I didn't even think of that. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: unexpeted result with cfqueryparam
But not when using cfqueryparam. Using cfqueryparam is meant to call the functionality of the database driver to do the escaping. Any escaping done by CF before that will only result in doubling the quotes twice, and therefore CF should do no escaping whatsoever of any value passed through cfqueryparam. Yes, I do remember seeing your previous comments about using CFQUERYPARAM to preserve single quotes...but I could never get that to test out. Do you have a resource to share? Maybe this is just another Access anomaly... Anyway, here's some test code I ran (CFMX/Access) before sending my last post... cfset variables.showLabel = abc's cfquery datasource=test UPDATE foo SET showLabel = cfqueryparam cfsqltype=cf_sql_varchar value=#trim(PreserveSingleQuotes(showLabel))# / where foo_id = 1 /cfquery ...foo is now abc's in the database, which is what we want. But when I change the CFQUERYPARAM tag to cfqueryparam cfsqltype=cf_sql_varchar value=#trim(HTMLEditFormat(showLabel))# / ...foo becomes abc''s in the database If I change the CFQUERYPARAM tag again to cfqueryparam cfsqltype=cf_sql_varchar value=#trim(showLabel)# / foo is still abc''s ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
[OT] CSS Question
Anyone know how to get rid of that inner border line that appears on a submit button when it is active?? Or even change the color? Or is this a stupid question? ;-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: unexpeted result with cfqueryparam
What still doesn't seem to make sense is that using the trim() in the cfqueryparam value does add an additional apostrophe, but not using trim() doesn't. Hmmmcould've sworn I tested this before but...I just tested cfqueryparam cfsqltype=cf_sql_varchar value=#showLabel# / and, sure enough, foo becomes abc's again...just what we want. So...I guess as long as we leave well enough alone (that is, don't use *any* functions with CFQUERYPARAM), CFQUERYPARAM gets the database to do all the work, right? ~Dina ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4