Re: HOF Site
I have an IP or two and I KNOW that Google has his information as they've been paying him adsense revenue. Unfortunately, they will not give that information out. I'm wondering what they need to get access to the information. Lawyer letter? Court order? FBI warrant? As you can probably see, the site is down again and he's asking to get on my domain account so he can get his adsense account back. Like I'm going to trust him with his behavior. On 5/20/11, Raymond Camden rcam...@gmail.com wrote: You know it's a guy - got a name? On Fri, May 20, 2011 at 4:57 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Yes and no. It's the same guy who used the hole in Galleon to hack into HoF and Forta.com last year. At least he's using the same code. I found pieces of it in files around the site, though he didn't get access through CF this time (that I could see). While I have his adsense ID, Google will not give me any information as to who he is, where, or anything else. I do know that the IP used to run some of the scripts traces to China and his communications with me are definitely the result of a translation program. If I dedicated the time to it I could get a better idea of who he is and what else he's done but it's currently not worth the time and effort on my part. Now if someone wants to sponsor me to investigate further... :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFThread Memory Issues sending emails
Thanks very much for this great response. I'm going to look at implementing the idea you had for sending things out in batches. I've got another big send to do this week so we'll see how it goes! -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: 21 May 2011 14:25 To: cf-talk Subject: RE: CFThread Memory Issues sending emails For a quick fix, I'd split those up into smaller batches. For instance, your cfthread could process 1000 emails (or whatever number you decide is manageable by your configuration) id make the count a parameter that is easily passed in via URL so all you'd have to do is change the url var in a scheduled task to increase/decrease the count. Then the thread's process would be something like... 1) Grab top X records that need to be sent. 2) Send the emails for those top X records 3) Update those records to indicate that they have been processed so they arent grabbed again by step 1. 4) Stop. Then just schedule it to run every minute or so. If you use timestamps as your step 3 indicator, you still have the start and stop times once there are no emails left to send. For a more elaborate solution, id queue individual emails up into a DB table and have multiple threads process them one at a time until they were done (makeshift CF message queue). I've found that letting a thread process 100s of thousands of small items individually makes that thread much happier than if it had to process even a fraction of that amount all at once. That said, I would have to agree and think your described setup should have zero problem with sending that many emails in a single loop. Have you monitored CF to see how the thread was doing? Maybe watch jconsole memory stats as the thread is running to see if it is indeed climbing rapidly and causing the GC? Maybe the thread is being spawned more than once? Maybe you could try loading all of the used variables into a single struct within that thread so you can clear that struct at the end of the loop? I'm just throwing out ideas here... .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Firewall [mailto:firew...@cc.uk.com] Sent: Thursday, May 19, 2011 7:38 AM To: cf-talk Subject: CFThread Memory Issues sending emails This one has me really stumped. I'm running a pretty simple cfmail script to send out email messages to a user list. Up until now I was simply doing it with a browser reload but the client recently doubled the number of emails they want to send to about 57,000. So I decided to implement this with cfthread wrapped around my loop containing the cfquery and cfmail code. The idea being that the server simply returns the page to the browser and kicks of a massive send job in the background. Once the mail script completes an email is send to the user saying I sent your email to X people, I started at xx:xx and finished at xx:xx My testing worked perfectly and the client used it on smaller email jobs without a problem, I tried it for the first time yesterday on the main massive list and about a third of the messages were sent out before the server seemed to hang. Looking at the logs I saw loads of JVM errors referring to GC aka the garbage collector. The specific log entry was: java.lang.OutOfMemoryError: GC overhead limit exceeded The server seems to have no problems sending about 10-15k emails using this process but when I try it on this one big list it results in all kinds of problems so I'm wondering if this is an issue with cfthread, JVM, CF 8.0.1 or my code. I'm wondering if this anyone else has tried to do this and seen the same problem; and if so how did you go about solving it? My setup is Coldfusion 8.0.1 (64bit) running on Red Hat Enterprise 5, the server itself is a nearly new core i7 Dell PowerEdge with Raid SSD hard drives and 12Gb RAM; in other words it should look at 57k emails and just laugh at the smallness of the list :) I've included the outline of my send code just in case someone spots something really stupid in my code: cfthread name=sendEmail#Form.id# action=run cfset startingTime = '#timeformat(now(), HH:MM:SS)#' cfquery datasource=#Application.ds# name=gn Grab info to send in email /cfquery cfloop list=#Form.sendToList# index=e cfoutput cfquery datasource=#Application.ds# name=gu Grab user details based on ID contained in e /cfquery cftry cfmail to=#emailSendTo# from=#gn.addName# #gn.addEmail# subject=#gn.msgSubj# type=html cfinclude template=email-body-#gn.emailType#.cfm
RE: SQL Quandary
That's perfect, thank you James! -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: 23 May 2011 03:12 To: cf-talk Subject: Re: SQL Quandary It can be. Taking your last example: IF (SELECT checkProjected FROM tbl_Params WHERE siteID = 1) = 1 select projected from tbl_stockItems where projected 10 else select projected from tbl_stockItems where projected 10 This can be written as: select projected from tbl_stockItems where ( (SELECT checkProjected FROM tbl_Params WHERE siteID = 1) = 1 AND projected 10 ) OR ( (SELECT checkProjected FROM tbl_Params WHERE siteID = 1) 1 AND projected 10 ) Since the subquery clause can only be true for one of the AND clauses, only one set of results will be returned. No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3654 - Release Date: 05/22/11 19:33:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HOF Site
Have you reported this to the police? -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 23 May 2011 09:24 To: cf-talk Subject: Re: HOF Site I have an IP or two and I KNOW that Google has his information as they've been paying him adsense revenue. Unfortunately, they will not give that information out. I'm wondering what they need to get access to the information. Lawyer letter? Court order? FBI warrant? As you can probably see, the site is down again and he's asking to get on my domain account so he can get his adsense account back. Like I'm going to trust him with his behavior. On 5/20/11, Raymond Camden rcam...@gmail.com wrote: You know it's a guy - got a name? On Fri, May 20, 2011 at 4:57 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Yes and no. It's the same guy who used the hole in Galleon to hack into HoF and Forta.com last year. At least he's using the same code. I found pieces of it in files around the site, though he didn't get access through CF this time (that I could see). While I have his adsense ID, Google will not give me any information as to who he is, where, or anything else. I do know that the IP used to run some of the scripts traces to China and his communications with me are definitely the result of a translation program. If I dedicated the time to it I could get a better idea of who he is and what else he's done but it's currently not worth the time and effort on my part. Now if someone wants to sponsor me to investigate further... :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
On Mon, May 23, 2011 at 1:16 AM, Robert Rhodes wrote: Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? Install Wireshark to capture all traffic on a system: http://www.wireshark.org/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HOF Site
Have I reported a guy from China to the police? No. Was I afraid that he would do more damage in retaliation? Yes. Am I still afraid? Yes, but I'm more angry than afraid so he's in trouble now. What am I going to do? First I'm going to get all of the information I can from others who have been effected by him in the past. Then I'm going to provide that and my own information to the FBI cyber crimes division and to Google. This includes his Google adsense account number. Google's already pulled his adsense account but there may be more they can do as they have a presence in China. If there's a way to prosecute him, I'm all for it. If anyone has contacts at the FBI, at Google, or in China, especially in the government and/or police, please contact me off list. I'd love to get someone over there to get this guy. If anyone has any other suggestions, please let me know. Thanks On Mon, May 23, 2011 at 7:45 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Have you reported this to the police? -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 23 May 2011 09:24 To: cf-talk Subject: Re: HOF Site I have an IP or two and I KNOW that Google has his information as they've been paying him adsense revenue. Unfortunately, they will not give that information out. I'm wondering what they need to get access to the information. Lawyer letter? Court order? FBI warrant? As you can probably see, the site is down again and he's asking to get on my domain account so he can get his adsense account back. Like I'm going to trust him with his behavior. On 5/20/11, Raymond Camden rcam...@gmail.com wrote: You know it's a guy - got a name? On Fri, May 20, 2011 at 4:57 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Yes and no. It's the same guy who used the hole in Galleon to hack into HoF and Forta.com last year. At least he's using the same code. I found pieces of it in files around the site, though he didn't get access through CF this time (that I could see). While I have his adsense ID, Google will not give me any information as to who he is, where, or anything else. I do know that the IP used to run some of the scripts traces to China and his communications with me are definitely the result of a translation program. If I dedicated the time to it I could get a better idea of who he is and what else he's done but it's currently not worth the time and effort on my part. Now if someone wants to sponsor me to investigate further... :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HOF Site
http://www.ic3.gov/default.aspx Could this be a place to start? If not, I would call my local police and escalate it from there. My feeling is that you need to get it reported so that some logging starts by some kind of police authority so that if you ever do get a chance to get this idiot into a court room, you'll have some evidence. I have no idea exactly how the police would manage a situation like this, but if I was in your position, I would be finding out. I could imagine a situation where you did not report the crime for some period and it did go to court, one of the first questions you might be asked is why you didn't report it as soon as it happened. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 23 May 2011 13:21 To: cf-talk Subject: Re: HOF Site Have I reported a guy from China to the police? No. Was I afraid that he would do more damage in retaliation? Yes. Am I still afraid? Yes, but I'm more angry than afraid so he's in trouble now. What am I going to do? First I'm going to get all of the information I can from others who have been effected by him in the past. Then I'm going to provide that and my own information to the FBI cyber crimes division and to Google. This includes his Google adsense account number. Google's already pulled his adsense account but there may be more they can do as they have a presence in China. If there's a way to prosecute him, I'm all for it. If anyone has contacts at the FBI, at Google, or in China, especially in the government and/or police, please contact me off list. I'd love to get someone over there to get this guy. If anyone has any other suggestions, please let me know. Thanks On Mon, May 23, 2011 at 7:45 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Have you reported this to the police? -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 23 May 2011 09:24 To: cf-talk Subject: Re: HOF Site I have an IP or two and I KNOW that Google has his information as they've been paying him adsense revenue. Unfortunately, they will not give that information out. I'm wondering what they need to get access to the information. Lawyer letter? Court order? FBI warrant? As you can probably see, the site is down again and he's asking to get on my domain account so he can get his adsense account back. Like I'm going to trust him with his behavior. On 5/20/11, Raymond Camden rcam...@gmail.com wrote: You know it's a guy - got a name? On Fri, May 20, 2011 at 4:57 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Yes and no. It's the same guy who used the hole in Galleon to hack into HoF and Forta.com last year. At least he's using the same code. I found pieces of it in files around the site, though he didn't get access through CF this time (that I could see). While I have his adsense ID, Google will not give me any information as to who he is, where, or anything else. I do know that the IP used to run some of the scripts traces to China and his communications with me are definitely the result of a translation program. If I dedicated the time to it I could get a better idea of who he is and what else he's done but it's currently not worth the time and effort on my part. Now if someone wants to sponsor me to investigate further... :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
SoapUI is a great tool for debugging soap: http://www.soapui.org/ If you give it a WSDL url it can generate stubs for testing the remote service and lets you see and edit all aspects of the soap request and response. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Sun, May 22, 2011 at 7:16 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocumentitem type=pagebreak
Thanks. I'll try that. I just can't figure out what that something else you mention is. It's like it loads the quesry (and I dumped it, it's only producing one record) and traversing the query once, creating the blank page, then traversing the query result a second time to read the data. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, May 18, 2011 2:13 PM To: cf-talk Subject: re: cfdocumentitem type=pagebreak Sounds like there's something else going on that would cause a blank at the beginning, if that's what you're seeing, but the code you've got there will also *always* append an extra page break after every record, including the first one. Try this instead: cfdocument format=pdf filename=#ExpandPath(.)#\xxx.pdf cfoutput query cfif currentRow GT 1cfdocumentitem type=pagebreak/cfdocumentitem/cfif ... query output stuff ... ... end query output stuff ... /cfoutput From: Stephens, Larry V steph...@indiana.edu Sent: Wednesday, May 18, 2011 2:10 PM To: cf-talk cf-talk@houseoffusion.com Subject: cfdocumentitem type=pagebreak cfquery ... cfdocument format=pdf filename=#ExpandPath(.)#\xxx.pdf cfoutput query ... query output stuff ... ... end query output stuff ... !--- just in case the query returns multiple records --- cfif GetRec.Recordcount GT 0cfdocumentitem type=pagebreak/cfdocumentitem/cfif cfoutput rest of tags What I expect is a pdf file with no blank pages if there is one record. (Haven't tested it yet with multiple records.) What I get (with one record) is a blank page at the top and then my data. Why does this give me a blank page at the top (and can I stop it)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HOF Site
Michael, Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. Russ On Mon, May 23, 2011 at 1:54 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: http://www.ic3.gov/default.aspx Could this be a place to start? If not, I would call my local police and escalate it from there. My feeling is that you need to get it reported so that some logging starts by some kind of police authority so that if you ever do get a chance to get this idiot into a court room, you'll have some evidence. I have no idea exactly how the police would manage a situation like this, but if I was in your position, I would be finding out. I could imagine a situation where you did not report the crime for some period and it did go to court, one of the first questions you might be asked is why you didn't report it as soon as it happened. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 23 May 2011 13:21 To: cf-talk Subject: Re: HOF Site Have I reported a guy from China to the police? No. Was I afraid that he would do more damage in retaliation? Yes. Am I still afraid? Yes, but I'm more angry than afraid so he's in trouble now. What am I going to do? First I'm going to get all of the information I can from others who have been effected by him in the past. Then I'm going to provide that and my own information to the FBI cyber crimes division and to Google. This includes his Google adsense account number. Google's already pulled his adsense account but there may be more they can do as they have a presence in China. If there's a way to prosecute him, I'm all for it. If anyone has contacts at the FBI, at Google, or in China, especially in the government and/or police, please contact me off list. I'd love to get someone over there to get this guy. If anyone has any other suggestions, please let me know. Thanks On Mon, May 23, 2011 at 7:45 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Have you reported this to the police? -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 23 May 2011 09:24 To: cf-talk Subject: Re: HOF Site I have an IP or two and I KNOW that Google has his information as they've been paying him adsense revenue. Unfortunately, they will not give that information out. I'm wondering what they need to get access to the information. Lawyer letter? Court order? FBI warrant? As you can probably see, the site is down again and he's asking to get on my domain account so he can get his adsense account back. Like I'm going to trust him with his behavior. On 5/20/11, Raymond Camden rcam...@gmail.com wrote: You know it's a guy - got a name? On Fri, May 20, 2011 at 4:57 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Yes and no. It's the same guy who used the hole in Galleon to hack into HoF and Forta.com last year. At least he's using the same code. I found pieces of it in files around the site, though he didn't get access through CF this time (that I could see). While I have his adsense ID, Google will not give me any information as to who he is, where, or anything else. I do know that the IP used to run some of the scripts traces to China and his communications with me are definitely the result of a translation program. If I dedicated the time to it I could get a better idea of who he is and what else he's done but it's currently not worth the time and effort on my part. Now if someone wants to sponsor me to investigate further... :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HOF Site
On Mon, May 23, 2011 at 4:46 PM, Russ Michaels r...@michaels.me.uk wrote: Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. Well, indeed. I cannot imagine or understand why anyone would allow this situation to continue. -- mac jordan www.kestrel.org | www.reactivecooking.com | www.jordan-cats.org twitter: @ramtops ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HOF Site
As a father of two little ones I can certainly imagine a situation where one wouldn't look forward to doing a ton of off-hour unpaid work. Michael has about 300 children, and likely the thought of blowing a couple of weekends setting up new servers and moving stuff over for a discussion board that does't generate revenue just to prevent a nuisance is probably up there with root canal on the things I'd like to do list. Not saying it's right, just saying that if that's the case... I'd certainly understand. On Mon, May 23, 2011 at 11:50 AM, mac jordan mac.jor...@gmail.com wrote: On Mon, May 23, 2011 at 4:46 PM, Russ Michaels r...@michaels.me.uk wrote: Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. Well, indeed. I cannot imagine or understand why anyone would allow this situation to continue. -- mac jordan www.kestrel.org | www.reactivecooking.com | www.jordan-cats.org twitter: @ramtops ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Quandary
Simple and elegant. On Sun, May 22, 2011 at 10:11 PM, James Holmes james.hol...@gmail.comwrote: It can be. Taking your last example: IF (SELECT checkProjected FROM tbl_Params WHERE siteID = 1) = 1 select projected from tbl_stockItems where projected 10 else select projected from tbl_stockItems where projected 10 This can be written as: select projected from tbl_stockItems where ( (SELECT checkProjected FROM tbl_Params WHERE siteID = 1) = 1 AND projected 10 ) OR ( (SELECT checkProjected FROM tbl_Params WHERE siteID = 1) 1 AND projected 10 ) Since the subquery clause can only be true for one of the AND clauses, only one set of results will be returned. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 23 May 2011 09:29, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: because the intention is not a simple WHERE search expression. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HOF Site
I've been moving the site(s) to a new server but he keeps messing with the current machine as I move things. Add to that a really important project that has to take precedence... I should have the site back up in an hour or two. Greg is going down there now to physically deal with this. On Mon, May 23, 2011 at 11:46 AM, Russ Michaels r...@michaels.me.uk wrote: Michael, Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HOF Site
I have an image of Greg, with baseball bat and a mean look. Good luck mate, any help required? just ask! MD On 23 May 2011, at 17:49, Michael Dinowitz wrote: I've been moving the site(s) to a new server but he keeps messing with the current machine as I move things. Add to that a really important project that has to take precedence... I should have the site back up in an hour or two. Greg is going down there now to physically deal with this. On Mon, May 23, 2011 at 11:46 AM, Russ Michaels r...@michaels.me.uk wrote: Michael, Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
A little help working with .NET webservice
I've got a web service that takes an object as a parameter updatedata(org.datacontract.schemas._2004._07.LMSService.UserDTO) generated from a .net webservice How in Coldfusion to I create the UserDTO object so I can call the updatedata webservice method? -Joshua O'Connor-Rose ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: A little help working with .NET webservice
NM piled all the properties in a struct and it worked fine. -Joshua On Mon, May 23, 2011 at 12:02 PM, Joshua O'Connor-Rose joshua.oconnorr...@gmail.com wrote: I've got a web service that takes an object as a parameter updatedata(org.datacontract.schemas._2004._07.LMSService.UserDTO) generated from a .net webservice How in Coldfusion to I create the UserDTO object so I can call the updatedata webservice method? -Joshua O'Connor-Rose ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: A little help working with .NET webservice
good, was just about to suggest, as I recently had to do same. tw Sent from my iPhone... Don't hate. On May 23, 2011, at 4:44 PM, Joshua O'Connor-Rose joshua.oconnorr...@gmail.com wrote: NM piled all the properties in a struct and it worked fine. -Joshua On Mon, May 23, 2011 at 12:02 PM, Joshua O'Connor-Rose joshua.oconnorr...@gmail.com wrote: I've got a web service that takes an object as a parameter updatedata(org.datacontract.schemas._2004._07.LMSService.UserDTO) generated from a .net webservice How in Coldfusion to I create the UserDTO object so I can call the updatedata webservice method? -Joshua O'Connor-Rose ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Shameful
Btw - it should be fixed now. On Tue, May 17, 2011 at 5:56 PM, Bryan Stevenson br...@electricedgesystems.com wrote: Next time report your issue with the Adobe website to...ummm...Adobe ;-) On Tue, 2011-05-17 at 15:33 -0400, Irvin Gomez wrote: Really? You come in here with the intention to insult and raise ire and act like you were innocently conveying a message. Geek please. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HOF Site
Ditto. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Mark Drew [mailto:mark.d...@gmail.com] Sent: Monday, May 23, 2011 12:51 PM To: cf-talk Subject: Re: HOF Site I have an image of Greg, with baseball bat and a mean look. Good luck mate, any help required? just ask! MD On 23 May 2011, at 17:49, Michael Dinowitz wrote: I've been moving the site(s) to a new server but he keeps messing with the current machine as I move things. Add to that a really important project that has to take precedence... I should have the site back up in an hour or two. Greg is going down there now to physically deal with this. On Mon, May 23, 2011 at 11:46 AM, Russ Michaels r...@michaels.me.uk wrote: Michael, Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Fwd: Google Picasaweb API
Thank you so much for the API link that really helped. I am almost done with it. Quick question: i do have a albumid and photoid, now I need to download the image from picasa (high res) how do I do that? I digged the api docs and seems like couldn't find anything. The album is not public and use authkey. I did modify your cfc and add functions to get the albums and photos with authkey. But now I need to get the high res image which was originally uploaded. and have no clue how do I get that through api. thanks once again for your help. really appreciate that. Regards, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HOF Site
Ditto... -Original Message- From: Mark Drew [mailto:mark.d...@gmail.com] Sent: Monday, May 23, 2011 11:51 AM To: cf-talk Subject: Re: HOF Site I have an image of Greg, with baseball bat and a mean look. Good luck mate, any help required? just ask! MD On 23 May 2011, at 17:49, Michael Dinowitz wrote: I've been moving the site(s) to a new server but he keeps messing with the current machine as I move things. Add to that a really important project that has to take precedence... I should have the site back up in an hour or two. Greg is going down there now to physically deal with this. On Mon, May 23, 2011 at 11:46 AM, Russ Michaels r...@michaels.me.uk wrote: Michael, Don't you think perhaps you should be moving your sites to a new server if he has access to this one and you are unable to block him? What if he installs some fishing, XSS or other scripts and starts to steal details form your users. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Fwd: Google Picasaweb API
I have not worked with Picasaweb API much, but looking at its reference guide, it seems you can provide imgmax=d query parameter to make madia:content elements reference the original uploaded photo. imgmax query param can only be used when retrieving *feeds* in order to get images of appropriate size - it CAN NOT be used when retrieving the actual images. example url: https://picasaweb.google.com/data/feed/api/user/userID/album/albumName?imgmax=d media:content's URL attribute in the response to above request will contain the url of the original photo. more info: http://code.google.com/apis/picasaweb/docs/2.0/reference.html#Parameters Azadi On 24/05/2011 08:39 , Guru wrote: Thank you so much for the API link that really helped. I am almost done with it. Quick question: i do have a albumid and photoid, now I need to download the image from picasa (high res) how do I do that? I digged the api docs and seems like couldn't find anything. The album is not public and use authkey. I did modify your cfc and add functions to get the albums and photos with authkey. But now I need to get the high res image which was originally uploaded. and have no clue how do I get that through api. thanks once again for your help. really appreciate that. Regards, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm