Re: cfftp action=existsFile failing
I tried this and while it connects fine and can even produce the current directory path, the listdir and existfile actions fail. This is so wierd!! I'm wondering if the ftp server requires secure ftp or something for listing and existfile checking. I'm checking with the host providers. >Have you tried opening a connection first and then reusing that >connection for the existsFile check? > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfftp action=existsFile failing
I tried this and while it connects fine and can even produce the current directory path, the listdir and existfile actions fail. This is so wierd!! I'm wondering if the ftp server requires secure ftp or something for listing and existfile checking. I'm checking with the host providers. >Have you tried opening a connection first and then reusing that >connection for the existsFile check? > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajaxCFC Access Denied
Hi Brad, My app have five tabs, all my tabs are running OK except when it needs to make an ajax call. My application.cfc was instantiating my new components, but I took that section out of there because ajaxcfc don't like that e.g: Now I created the object on the cfm page that needs that component. Now, the things that you mentioned I donât know if relate to this as well. Two of the original tabs are still working, but my new other tabs work too until I made an ajax call. I will look into the things that you say. David >What Charlie pointed out was simply a syntax issue separate from what >appears to be a permissions problem. > >Your error seems to be that ColdFusion does not have read access to the >web-inf directory. What user is ColdFusion running under? If CF starts >with Windows as a service, a user can be specified for that service. >The default with windows is "System". If this is your production >server, I would recommend creating a special user for CF to run as which >is NOT an administrator for security's sake. That user will need access >to the web-inf directory among other things. BTW: component.cfc is the >base object that all components inherit from. > >Here is a knowledge base article on the subject: >http://kb2.adobe.com/cps/172/tn_17279.html > >~Brad > >Thank you for replying, > >I made the change: > > >Still the same error. > >David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxCFC Access Denied
What Charlie pointed out was simply a syntax issue separate from what appears to be a permissions problem. Your error seems to be that ColdFusion does not have read access to the web-inf directory. What user is ColdFusion running under? If CF starts with Windows as a service, a user can be specified for that service. The default with windows is "System". If this is your production server, I would recommend creating a special user for CF to run as which is NOT an administrator for security's sake. That user will need access to the web-inf directory among other things. BTW: component.cfc is the base object that all components inherit from. Here is a knowledge base article on the subject: http://kb2.adobe.com/cps/172/tn_17279.html ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres Date: Tue, June 16, 2009 5:21 pm To: cf-talk Thank you for replying, I made the change: Still the same error. David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Thank you for replying, I made the change: Still the same error. David >The access="remote" should be in the tag, not the >tag? > >-- >I have failed as much as I have succeeded. But I love my life. I love my >wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajaxCFC Access Denied
On Tue, Jun 16, 2009 at 3:11 PM, David Torres wrote: > > Hello, > > I have worked on a web app on my computer using AjaxCFC. All is working as > desired and now is time to move it to production. > > When I started going over my changes in production, I have the following > error: > > "Access denied(java.io.filepermission > C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read)" > > I moved the ajax.cfc from the root folder to the component folder where all > my other components are, and it worked for a moment. Then I continued > testing other parts of my project, and I've got the same error again. > > My components start with something like this: > " access="remote">" > > The access="remote" should be in the tag, not the tag? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Please disregard this duplicate message. I was having an error posting this message many times. David > Hello, > > I have worked on a web app on my computer using AjaxCFC. All is > working as desired and now is time to move it to production. > > When I started going over my changes in production, I have the > following error: > > "Access denied(java.io.filepermission > C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read)" > > I moved the ajax.cfc from the root folder to the component folder > where all my other components are, and it worked for a moment. Then I > continued testing other parts of my project, and I've got the same > error again. > > My components start with something like this: > " access="remote">" > > Does anybody has had this error before? > > Thanks, > David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Access Denied AjaxCFC
Hello, I have worked on a web app on my computer using AjaxCFC. All is working as desired and now is time to move it to production. When I started going over my changes in production, I have the following error: "Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read)" I moved the ajax.cfc from the root folder to the component folder where all my other components are, and it worked for a moment. Then I continued testing other parts of my project, and I've got the same error again. My components start with something like this: "" Does anybody has had this error before? Thanks, David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ajaxCFC Access Denied
Hello, I have worked on a web app on my computer using AjaxCFC. All is working as desired and now is time to move it to production. When I started going over my changes in production, I have the following error: "Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read)" I moved the ajax.cfc from the root folder to the component folder where all my other components are, and it worked for a moment. Then I continued testing other parts of my project, and I've got the same error again. My components start with something like this: "" Does anybody has had this error before? Thanks, David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: email and encrypt
Now the email is in HTML format and I putting a hyperlink in it. Click to Validate Shouldn't this work? I still don't get why this would get chopped if they clicked on the link. > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Tuesday, June 16, 2009 3:55 PM > To: cf-talk > Subject: RE: email and encrypt > > > Well yes, but I wanted a long complex variable that someone would not be > able to just guess an ID and validate the account. > > Someone could put ID=5 in there and validate someone else's account. > > Maybe I should use CreateUUID() store that in the database and send it in > the URL in the email? Would be harder to guess they just ID=5. Might > still get chopped off when they click it, because im not sure what is > causing the chopping off. > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
haha I love you guys. -- Ryan LeTulle On Tue, Jun 16, 2009 at 3:11 PM, Barney Boisvert wrote: > > The MD5 gamut is 2^128 or 16^32 or > 340,282,366,920,938,463,463,374,607,431,768,211,456. Your database > will run out of integer keys long before it's an issue with almost > complete certainty. But yes, it is a potential problem. Easy to make > fail-fast with a constraint on your DB though. > > cheers, > barneyb > > On Tue, Jun 16, 2009 at 1:03 PM, Alan Rother wrote: > > > > One catch with a hash, it is possible, however highly unlikely, that two > > different email addresses will produce the same hash. > > Just be aware of it. > > > > =] > > > > -- > > Alan Rother > > Adobe Certified Advanced ColdFusion MX 7 Developer > > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
The MD5 gamut is 2^128 or 16^32 or 340,282,366,920,938,463,463,374,607,431,768,211,456. Your database will run out of integer keys long before it's an issue with almost complete certainty. But yes, it is a potential problem. Easy to make fail-fast with a constraint on your DB though. cheers, barneyb On Tue, Jun 16, 2009 at 1:03 PM, Alan Rother wrote: > > One catch with a hash, it is possible, however highly unlikely, that two > different email addresses will produce the same hash. > Just be aware of it. > > =] > > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
One catch with a hash, it is possible, however highly unlikely, that two different email addresses will produce the same hash. Just be aware of it. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
>Another quick question...I've noticed elsewhere, that it is common to set a >value to NULL. Technically, nulls in a relational database are a sign of badly designed database. (an 'optional' value should be represented with a 0..1 join to a separate table, or similar). In practise, especially with simpler databases/systems, it can be easier to just allow nulls - in particular, for cases when [blank] vs [undefined] mean different things (or, like with dates, when an empty string is treated as zero/1-Jan-1970, which isn't desirable). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
Skip the ID and encrypted email, and just use a hashed email: test.cfm?e=#hash(q.email)# it's easy to look up, uniquely identifying, will generate a relatively short URL, has only safe characters, etc. cheers, barneyb On Tue, Jun 16, 2009 at 12:42 PM, Chad Gray wrote: > > I have a program that emails a user a link to verify their email. > > So I thought I would take their email and use encrypt to mask it. Then > decrypt it to verify the email against the database. > > So I wrote this and put it in the email so they could click on it: > > > > I am getting some errors where some users the URL variable "ID" (the second > variable in the hyperlink) is not defined. Like they clicked on the link in > the email and part of the URL variables were chopped off. > > Anyone recommend a better way of making the URL so I can validate the users > email address? > > I thought URLEncodedFormat would fix any strange characters that would not > pass in a URL variable. > > Maybe it is their email program chopping off the URL variables? > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: email and encrypt
Well yes, but I wanted a long complex variable that someone would not be able to just guess an ID and validate the account. Someone could put ID=5 in there and validate someone else's account. Maybe I should use CreateUUID() store that in the database and send it in the URL in the email? Would be harder to guess they just ID=5. Might still get chopped off when they click it, because im not sure what is causing the chopping off. > -Original Message- > From: Alan Rother [mailto:alan.rot...@gmail.com] > Sent: Tuesday, June 16, 2009 3:48 PM > To: cf-talk > Subject: Re: email and encrypt > > > Well, do you HAVE to put their email address in the URL string? Couldn't > you > just cross reference it off of the ID? Assuming of course you have their > email address stored in your database and the UserID is related to it... > =] > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
I would guess that the urlEncoded() version is probably longer than the line length of some email readers, so it's getting truncated and then your app gets a partial ID back. +1 to Alan on the idea of only passing the ID ... From: "Alan Rother" Sent: Tuesday, June 16, 2009 3:49 PM To: "cf-talk" Subject: Re: email and encrypt Well, do you HAVE to put their email address in the URL string? Couldn't you just cross reference it off of the ID? Assuming of course you have their email address stored in your database and the UserID is related to it... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
Well, do you HAVE to put their email address in the URL string? Couldn't you just cross reference it off of the ID? Assuming of course you have their email address stored in your database and the UserID is related to it... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
email and encrypt
I have a program that emails a user a link to verify their email. So I thought I would take their email and use encrypt to mask it. Then decrypt it to verify the email against the database. So I wrote this and put it in the email so they could click on it: I am getting some errors where some users the URL variable "ID" (the second variable in the hyperlink) is not defined. Like they clicked on the link in the email and part of the URL variables were chopped off. Anyone recommend a better way of making the URL so I can validate the users email address? I thought URLEncodedFormat would fix any strange characters that would not pass in a URL variable. Maybe it is their email program chopping off the URL variables? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
That totally depends on your DB setup.
If you have a column that does not allow NULL, then you have have send the
empty string ('') if there's no value. If you have SQL code that tests
Country IS NULL, then you may want to send NULL for that value in place of
the empty string.
Again, depending on the situation, you can handle it all through the query
param:
That will auto-NULL any empty value ...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323548
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
Another quick question...I've noticed elsewhere, that it is common to set a value to NULL. Is there a benefit to either of these... '#transferData. Country #'' ', '#transferData.Country#'NULL, Thanks, Mark -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Tuesday, June 16, 2009 2:56 PM To: cf-talk Subject: Re: insert trouble...zero length Actually, empty string simply breaks the Boolean check, it's the primary exception. cfif isBoolean(stringVar) ... will at least let it through only if it's actually a value that CF can apply a true/false test to ... From: "Peter Boughton" Sent: Tuesday, June 16, 2009 2:48 PM To: "cf-talk" Subject: Re: insert trouble...zero length Nothing wrong with your mailing list ettiquette - I had to post manually (hof broke) and just got the subject wrong the first time, and posted again so it was correctly threaded. Anyhow, I'd still recommend adding a check against it being missing - unless you're 300% certain it will always be there. Slightly confused that it appears to be one of the string fields - an empty string shouldn't cause an error. :/ -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
Actually, empty string simply breaks the Boolean check, it's the primary exception. cfif isBoolean(stringVar) ... will at least let it through only if it's actually a value that CF can apply a true/false test to ... From: "Peter Boughton" Sent: Tuesday, June 16, 2009 2:48 PM To: "cf-talk" Subject: Re: insert trouble...zero length Nothing wrong with your mailing list ettiquette - I had to post manually (hof broke) and just got the subject wrong the first time, and posted again so it was correctly threaded. Anyhow, I'd still recommend adding a check against it being missing - unless you're 300% certain it will always be there. Slightly confused that it appears to be one of the string fields - an empty string shouldn't cause an error. :/ -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
Nothing wrong with your mailing list ettiquette - I had to post manually (hof broke) and just got the subject wrong the first time, and posted again so it was correctly threaded. Anyhow, I'd still recommend adding a check against it being missing - unless you're 300% certain it will always be there. Slightly confused that it appears to be one of the string fields - an empty string shouldn't cause an error. :/ -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: insert trouble...zero length
Thank you Peter, I appreciate what you're saying...it's just that I can look at the database and see ContactType is present for each record...so while that, I'm sure, would cause an error, it is not in this case. Sorry, I only code part time, a couple times each year (trying to go full time...really amazed...I like coding), so my mailing list etiquette is pretty rough...I should have responded the first time. Thanks for the help. Mark -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: Tuesday, June 16, 2009 2:24 PM To: cf-talk Subject: Re: insert trouble...zero length Your problem there is the numeric ContactType field - if it is missing, you get an empty item between the two commas, which is invalid SQL syntax. You can solve it with cfqueryparam by setting the null property based on whether it contains a numeric value or not: -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
Mark Fuqua MdProfinish wrote: > Sorry to ask, but does actually > suffice as a check for length or do I have to add = 0... LEN(TRIM(myquery.MyFieldName)) = 0> It does suffice do to the loosely typed nature of ColdFusion. Basically anything the evaluates to a ZERO can be considered false and any other value will be considered true. Many like this convienance. Many do not like and prefer to be more explicit for what they are testing. The nice thing here is that ColdFusion accommodates both styles with nearly equal aplomb. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
The exception is blank, which cannot be resolved as Boolean. So, will truly resolve either true or false. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
Yes, ColdFusion will implicitly treat anything as a boolean. As long as the it's not 0 it's considered true. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: insert trouble...zero length
Your problem there is the numeric ContactType field - if it is missing, you get an empty item between the two commas, which is invalid SQL syntax. You can solve it with cfqueryparam by setting the null property based on whether it contains a numeric value or not: -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
I have a similar issue where i'm outputting from Coldfusion to another system through an html page that only outputs the query results, and the receiving system can't handle empty values. I loop through the query and substitute for blanks (in my case I'm using an underscore, but could just as easily do null. I don't know how this will perform on a big query though, in my case this returns a single row which I output in html select * from Config_Basics where CONFIGID=#SIMCONFIG# On Tue, Jun 16, 2009 at 1:50 PM, Mark Fuqua MdProfinish < m...@mdprofinish.com> wrote: > > So I have to put a cfif at each value to check for length greater than zero > and if it is not, set the value to " " for each field...for each iteration? > > -Original Message- > From: Rob Parkhill [mailto:robert.parkh...@gmail.com] > Sent: Tuesday, June 16, 2009 1:42 PM > To: cf-talk > Subject: Re: insert trouble...zero length > > > You will have to make sure that the table you are inserting into can have a > NULL as a value, or you will need to modify your code to look at each value > and change any NULLs to either a space or a zero depending on the datatype > you are inserting. > HTH > > Rob > > On Tue, Jun 16, 2009 at 1:33 PM, Mark Fuqua MdProfinish < > m...@mdprofinish.com> wrote: > > > > > Having trouble with the following code.having trouble with "zero length" > > values. The field in the database is empty and when it goes to insert it > > into another table, it chokes. Is there a way to set a " " value as > > default? Or do I have to do a cfif on each value? I'm sure I'm missing > > something simple here. > > > > > > > > > > > > > > > > SELECT * > > > > FROM plumUser > > > > Where ContactType = 3 and userId = 34 > > > > > > > > > > > > > > > > > > > > > > > > INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, > > CellPhoneEmail, > > City, > > > > CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, > > FirstName, HomePhone, > > > > LastName, OfficePhone, Password, State, Status, SubShortName, UserName, > > ZipCode) > > > > VALUES( '#transferData.Address1#', '#transferData.CellPhone#', > > > > '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', > > '#transferData.City#', > > > > '#transferData.CompanyName#',#transferData.ContactType#, > > '#transferData.Country#', > > > > #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', > > '#transferData.Extension#', > > > > '#transferData.Fax#', '#transferData.FirstName#', > > '#transferData.HomePhone#', '#transferData.LastName#', > > > > '#transferData.OfficePhone#', '#transferData.Password#', > > '#transferData.State#',#transferData.Status#, > > '#transferData.SubShortName#', '#transferData.UserName#', > > > >'#transferData.ZipCode#' ) > > > > > > > > > > > > > > > > Thanks, > > > > > > > > Mark > > > > > > > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
On Tue, Jun 16, 2009 at 11:16 AM, Mark Fuqua MdProfinish < m...@mdprofinish.com> wrote: > > Sorry to ask, but does actually > suffice as a check for length or do I have to add = 0... LEN(TRIM(myquery.MyFieldName)) = 0> > actually that'd be (note the 'eq' not '=') :) Seems like you're saying I can do the following and it will work: > > Values( LEN(TRIM(myquery.MyFieldName))>'#myquery.MyFieldName#'" > ", REPEAT...) > That's what he's saying. CF does implicit boolean conversion. If the number is non zero, it'll come back as 'true'. Run a quick test: Yes No Change out the value of 'myNum' to various values (including a zero) and you'll see the behavior in action :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
Sorry to ask, but does actually
suffice as a check for length or do I have to add = 0...
Seems like you're saying I can do the following and it will work:
Values('#myquery.MyFieldName#'"
", REPEAT...)
Thanks,
Mark
-Original Message-
From: Alan Rother [mailto:alan.rot...@gmail.com]
Sent: Tuesday, June 16, 2009 1:44 PM
To: cf-talk
Subject: Re: insert trouble...zero length
There are several valid ways to handle this.
In your destination table you can define a default value if none is
provided, this of course does require you to do a CFIF around each item in
your insert and you will need to check to see if the value you are about to
insert has a length
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323537
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble zero length
Your problem there is the numeric ContactType field - if it is missing, you get an empty item between the two commas, which is invalid SQL syntax. You can solve it with cfqueryparam by setting the null property based on whether it contains a numeric value or not: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
So I have to put a cfif at each value to check for length greater than zero and if it is not, set the value to " " for each field...for each iteration? -Original Message- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: Tuesday, June 16, 2009 1:42 PM To: cf-talk Subject: Re: insert trouble...zero length You will have to make sure that the table you are inserting into can have a NULL as a value, or you will need to modify your code to look at each value and change any NULLs to either a space or a zero depending on the datatype you are inserting. HTH Rob On Tue, Jun 16, 2009 at 1:33 PM, Mark Fuqua MdProfinish < m...@mdprofinish.com> wrote: > > Having trouble with the following code.having trouble with "zero length" > values. The field in the database is empty and when it goes to insert it > into another table, it chokes. Is there a way to set a " " value as > default? Or do I have to do a cfif on each value? I'm sure I'm missing > something simple here. > > > > > > > > SELECT * > > FROM plumUser > > Where ContactType = 3 and userId = 34 > > > > > > > > > > > > INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, > CellPhoneEmail, > City, > > CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, > FirstName, HomePhone, > > LastName, OfficePhone, Password, State, Status, SubShortName, UserName, > ZipCode) > > VALUES( '#transferData.Address1#', '#transferData.CellPhone#', > > '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', > '#transferData.City#', > > '#transferData.CompanyName#',#transferData.ContactType#, > '#transferData.Country#', > > #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', > '#transferData.Extension#', > > '#transferData.Fax#', '#transferData.FirstName#', > '#transferData.HomePhone#', '#transferData.LastName#', > > '#transferData.OfficePhone#', '#transferData.Password#', > '#transferData.State#',#transferData.Status#, > '#transferData.SubShortName#', '#transferData.UserName#', > >'#transferData.ZipCode#' ) > > > > > > > > Thanks, > > > > Mark > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
There are several valid ways to handle this. In your destination table you can define a default value if none is provided, this of course does require you to do a CFIF around each item in your insert and you will need to check to see if the value you are about to insert has a length Of course if you have to do this anyhow, you can handle the defaulting value right here with an else statement. It is also possible to check for a NULL value in your initial query that gets the data in the first place and when you see a NULL you can replace it with some default value. SELECT ISNULL(isApproved,0) Where the first value is the column name to check and the second value is what you want it replaced with if it turns out to be null. Not knowing what you are doing here, I would recommend just doing an CFIF around each value in your insert and handling the default value there. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
There are several valid ways to handle this. In your destination table you can define a default value if none is provided, this of course does require you to do a CFIF around each item in your insert and you will need to check to see if the value you are about to insert has a length Of course if you have to do this anyhow, you can handle the defaulting value right here with an else statement. It is also possible to check for a NULL value in your initial query that gets the data in the first place and when you see a NULL you can replace it with some default value. SELECT ISNULL(isApproved,0) Where the first value is the column name to check and the second value is what you want it replaced with if it turns out to be null. Not knowing what you are doing here, I would recommend just doing an CFIF around each value in your insert and handling the default value there. =] On Tue, Jun 16, 2009 at 10:33 AM, Mark Fuqua MdProfinish < m...@mdprofinish.com> wrote: > > Having trouble with the following code.having trouble with "zero length" > values. The field in the database is empty and when it goes to insert it > into another table, it chokes. Is there a way to set a " " value as > default? Or do I have to do a cfif on each value? I'm sure I'm missing > something simple here. > > > > > > > > SELECT * > > FROM plumUser > > Where ContactType = 3 and userId = 34 > > > > > > > > > > > > INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, > CellPhoneEmail, > City, > > CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, > FirstName, HomePhone, > > LastName, OfficePhone, Password, State, Status, SubShortName, UserName, > ZipCode) > > VALUES( '#transferData.Address1#', '#transferData.CellPhone#', > > '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', > '#transferData.City#', > > '#transferData.CompanyName#',#transferData.ContactType#, > '#transferData.Country#', > > #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', > '#transferData.Extension#', > > '#transferData.Fax#', '#transferData.FirstName#', > '#transferData.HomePhone#', '#transferData.LastName#', > > '#transferData.OfficePhone#', '#transferData.Password#', > '#transferData.State#',#transferData.Status#, > '#transferData.SubShortName#', '#transferData.UserName#', > >'#transferData.ZipCode#' ) > > > > > > > > Thanks, > > > > Mark > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: insert trouble...zero length
You will have to make sure that the table you are inserting into can have a NULL as a value, or you will need to modify your code to look at each value and change any NULLs to either a space or a zero depending on the datatype you are inserting. HTH Rob On Tue, Jun 16, 2009 at 1:33 PM, Mark Fuqua MdProfinish < m...@mdprofinish.com> wrote: > > Having trouble with the following code.having trouble with "zero length" > values. The field in the database is empty and when it goes to insert it > into another table, it chokes. Is there a way to set a " " value as > default? Or do I have to do a cfif on each value? I'm sure I'm missing > something simple here. > > > > > > > > SELECT * > > FROM plumUser > > Where ContactType = 3 and userId = 34 > > > > > > > > > > > > INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, > CellPhoneEmail, > City, > > CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, > FirstName, HomePhone, > > LastName, OfficePhone, Password, State, Status, SubShortName, UserName, > ZipCode) > > VALUES( '#transferData.Address1#', '#transferData.CellPhone#', > > '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', > '#transferData.City#', > > '#transferData.CompanyName#',#transferData.ContactType#, > '#transferData.Country#', > > #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', > '#transferData.Extension#', > > '#transferData.Fax#', '#transferData.FirstName#', > '#transferData.HomePhone#', '#transferData.LastName#', > > '#transferData.OfficePhone#', '#transferData.Password#', > '#transferData.State#',#transferData.Status#, > '#transferData.SubShortName#', '#transferData.UserName#', > >'#transferData.ZipCode#' ) > > > > > > > > Thanks, > > > > Mark > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
insert trouble...zero length
Having trouble with the following code.having trouble with "zero length" values. The field in the database is empty and when it goes to insert it into another table, it chokes. Is there a way to set a " " value as default? Or do I have to do a cfif on each value? I'm sure I'm missing something simple here. SELECT * FROM plumUser Where ContactType = 3 and userId = 34 INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, CellPhoneEmail, City, CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, FirstName, HomePhone, LastName, OfficePhone, Password, State, Status, SubShortName, UserName, ZipCode) VALUES( '#transferData.Address1#', '#transferData.CellPhone#', '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', '#transferData.City#', '#transferData.CompanyName#',#transferData.ContactType#, '#transferData.Country#', #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', '#transferData.Extension#', '#transferData.Fax#', '#transferData.FirstName#', '#transferData.HomePhone#', '#transferData.LastName#', '#transferData.OfficePhone#', '#transferData.Password#', '#transferData.State#',#transferData.Status#, '#transferData.SubShortName#', '#transferData.UserName#', '#transferData.ZipCode#' ) Thanks, Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Limiting the display of an image to certain times of the day with CF?
Thanks all for the prompt responses. Both solutions work great! Thanks again -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 16 June 2009 14:24 To: cf-talk Subject: re: Limiting the display of an image to certain times of the day with CF? From: "Ian Vaughan" Sent: Tuesday, June 16, 2009 9:12 AM To: "cf-talk" Subject: Limiting the display of an image to certain times of the day with CF? Hi In Coldfusion can you restrict the display of a certain image for only certain times of the day? For example only display the image before 8pm 12pm-2pm and after 5pm on the site homepage If so any ideas on the best way to achieve this? TIA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Limiting the display of an image to certain times of the day with CF?
From: "Ian Vaughan" Sent: Tuesday, June 16, 2009 9:12 AM To: "cf-talk" Subject: Limiting the display of an image to certain times of the day with CF? Hi In Coldfusion can you restrict the display of a certain image for only certain times of the day? For example only display the image before 8pm 12pm-2pm and after 5pm on the site homepage If so any ideas on the best way to achieve this? TIA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limiting the display of an image to certain times of the day with CF?
>>If so any ideas on the best way to achieve this? Simply use http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limiting the display of an image to certain times of the day with CF?
Wrap it up in a CFIF or CFCASE statement. That should do it. HTH Rob On Tue, Jun 16, 2009 at 9:10 AM, Ian Vaughan < i.vaug...@neath-porttalbot.gov.uk> wrote: > > Hi > > In Coldfusion can you restrict the display of a certain image for only > certain times of the day? > > For example only display the image before 8pm 12pm-2pm and after 5pm on > the site homepage > > If so any ideas on the best way to achieve this? > > TIA > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Limiting the display of an image to certain times of the day with CF?
Hi In Coldfusion can you restrict the display of a certain image for only certain times of the day? For example only display the image before 8pm 12pm-2pm and after 5pm on the site homepage If so any ideas on the best way to achieve this? TIA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
