Re: cfssetting showdebugoutput
Using cfsetting showdebugoutput=false does actually disable debug output. Any chance there's another call to it somewhere else with a different setting? Are you actually seeing debug output in the requests that fail, even with that code? Or you're not, but debug output being on in administrator but off on the page still breaks things? If that's the case, I'd suggest diffing the working HTML with the busted HTML, and seeing what's different. I'ts unlikely that that combination outputs something toxic to the page, but I suppose it's theoretically possible. That'd tell you what's different, and maybe point you towards a solution. Dave On Sat, Oct 9, 2010 at 10:29 PM, fun and learning funandlrnn...@gmail.com wrote: Hi All - I am using jqgrid to display some data. This works when I turn off the Request Debugging Output in Coldfusion Administrator. I do not have access to Administrator page at my work. Using cfsetting showdebugoutput = false also does not help. Is there a way I can disable request debugging output through my code? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfssetting showdebugoutput
Anything that gets data from the server with a remote request will usually break when debug output is on, as it is being added to the end of the request. make sure you have debug output disabled globally, you could set it in your application.cfm/cfc as setting it in a page that calls another page will only disable it on the calling page. Russ On Sat, Oct 9, 2010 at 10:29 PM, fun and learning funandlrnn...@gmail.com wrote: Hi All - I am using jqgrid to display some data. This works when I turn off the Request Debugging Output in Coldfusion Administrator. I do not have access to Administrator page at my work. Using cfsetting showdebugoutput = false also does not help. Is there a way I can disable request debugging output through my code? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Uploading photos to Facebook - ColdFusion REST API
Howdy folks, I'm working on a ColdFusion application that creates events in Facebook. I have no trouble authenticating users and creating simple events, but as soon as I add a picture with CFHTTPPARAM, I get a blank response from Facebook. Here's the code I have that works: - cfset params = 'access_token=#client.access_token#event_info={page_id: #uid#, start_time: 1295578547, name: Test Event, location: Test,privacy: OPEN,description: Test Event}' cfhttp url=https://api.facebook.com/method/events.create?#params#; method=get/cfhttp - Given the correct permissions and authentication, this works great. But as soon as I change my CFHTTP statement, the code fails. This is the code I'm using: - cfhttp url=https://api.facebook.com/method/events.create?#params#; method=post multipart=yes cfhttpparam file=E:\test\sampleimage.jpg type=file name=image.jpg mimetype=image/jpeg /cfhttp - Anyone have any ideas? It might be that Facebook is looking for some kind of a header, but I'm not sure what that would be. Thanks in advance! David Six ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Uploading photos to Facebook - ColdFusion REST API
Perhaps Facebook is looking for the params in form variables rather than the URL since it's a post? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 10 October 2010 18:59, David Six david.six...@gmail.com wrote: cfhttp url=https://api.facebook.com/method/events.create?#params#; method=post multipart=yes cfhttpparam file=E:\test\sampleimage.jpg type=file name=image.jpg mimetype=image/jpeg /cfhttp ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Uploading photos to Facebook - ColdFusion REST API
Perhaps Facebook is looking for the params in form variables rather than the URL since it's a post? Thanks for looking at this. I tried this: cfhttp url=https://api.facebook.com/method/events.create; method=post cfhttpparam name=access_token value=#client.access_token# encoded=no type=url cfhttpparam name=event_info value=#params# encoded=no type=url /cfhttp And I get the same response, nothing returned from Facebook and nothing posted to events. I tried a few different post combinations and actually I can't get post to work at all, even though GET works fine. Very weird. I'll keep plugging at it. David On Sun, Oct 10, 2010 at 6:07 AM, James Holmes james.hol...@gmail.comwrote: Perhaps Facebook is looking for the params in form variables rather than the URL since it's a post? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 10 October 2010 18:59, David Six david.six...@gmail.com wrote: cfhttp url=https://api.facebook.com/method/events.create?#params#; method=post multipart=yes cfhttpparam file=E:\test\sampleimage.jpg type=file name=image.jpg mimetype=image/jpeg /cfhttp ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338039 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Image button in a cfwindow doesn't pass coordinates
a CFFORM inside a cf ajax control (like CFWINDOW) submits asynchronously using ajax - that's why button coordinates are not passed along. Azadi On 05/10/2010 23:37 , John Pullam wrote: Normally when you click on an image button inside a CFFORM, the coordinates are passed to the form processor. This is a simple way to support multiple buttons from a single form because you can use the presence of a coordinate to tell you which button was pressed. I couldn't figure out why this wasn't working inside a CFWINDOW and eventually I stripped out all the extraneous code until I discovered that when the CFFORM is inside a CFWINDOW, it no longer passes the coordinates. Is that documented? Can anyone comment on that situation? If anyone wants to play around with it, my test program is in 2 pieces below, the page that opens the CFWINDOW followed by the CFWINDOW code which dumps the FORM fields. TestImageButton.cfm: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN http://www.w3.org/TR/html4/strict.dtd; html head meta http-equiv=Content-Type content=text/html; charset=utf-8 titleUntitled Document/title /head body pa href=javascript:ColdFusion.Window.show('EventUpdate');ColdFusion.navigate('TestImageButton2.cfm','EventUpdate'); Click here to open the window/a/p cfwindow name=EventUpdate modal=true resizable=false title=Test width=550 height=550 x=500 y=150 bodyStyle=font-size:12px; font-family: verdana; background-color: ##dcefd2; color: black; text-align: left; headerStyle=font-size:13px; font-weight:bold; font-family:Verdana; color: white; text-align:left; cfajaximport tags=cfform, cfwindow scriptsrc=/CFIDE/scripts /cfwindow /body /html TestImageButton2.cfm: cfdump var=#FORM# cfform cfinput name=Comment size=75 required=no / INPUT TYPE=IMAGE NAME=Save SRC=Buttons/MSave.png INPUT TYPE=IMAGE NAME=Delete SRC=Buttons/MDelete.png /cfform ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't figure out a query to accomplish this...
if you insist on using *, you can do SELECT p.* to select all columns from only one table in a join. but others have already said why selecting * (even from one table) may not be a very good idea. Azadi On 04/10/2010 21:59 , Rick Faircloth wrote: Yes, once I got the query working (except for the duplicate fields) I swapped to select * to avoid having to type the 50 or so fields involved. It works elsewhere, so I figured it should here. But as soon as I starting specifically naming the fields, the duplication cleared up. I would love to know why, but I guess that's just the way MySQL works with that particular query. Perhaps it's the way it has to be done with a left join. Anyway, all is well! Thanks, James! Rick -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Monday, October 04, 2010 9:12 AM To: cf-talk Subject: Re: Can't figure out a query to accomplish this... Are you using select * to get the records? If so, get rid of that and name the select columns from p. select p.area, p.bedrooms, p.bathrooms from ... etc -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 11:28, Rick Fairclothric...@whitestonemedia.com wrote: Spoke (wrote) too soon... I'm getting the correct records, but I just realized I'm getting two of every field returned. �I tried other joins, but can't affect the fields so that I get just one field. How do I modify the query to return just one field ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Array Error
Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = arrayNew(1) / cfset vleafnodes = arrayNew(1) / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfif getRec.account_id EQ vleafnodes[getRec.account_id] cfset vLeaf = true cfelse cfset vLeaf = false /cfif /cfloop The array for the vleafnodes looks like below: array 1 [undefined array element] Element 1 is undefined in a Java object of type class coldfusion.runtime.Array. 2 [undefined array element] Element 2 is undefined in a Java object of type class coldfusion.runtime.Array. 3 3 4 4 5 [undefined array element] Element 5 is undefined in a Java object of type class coldfusion.runtime.Array. 6 6 7 7 8 8 using isdefined or isarray to check if the element is defined in a particular position is not helping during the comparision statement cfif getRec.account_id EQ vleafnodes[getRec.account_id] I keep getting the following error Element 1 is undefined in a Java object of type class coldfusion.runtime.Array. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Array Error
Try this... cfloop query=q cfscript ArrayAppend(vleafnodes, q.account_id); /cfscript /cfloop However this is not going to give you the ability to reference the array element by the account ID, it sounds like what you want is a structure. cfloop query=q cfscript StructInsert(myLeafStruct, q.account_id, q.account_id, true); /cfscript /cfloop This will allow you to reference the account if by the query id. Regards, David McGraw Oyova Software, LLC http://www.oyova.com Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = arrayNew(1) / cfset vleafnodes = arrayNew(1) / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfif getRec.account_id EQ vleafnodes[getRec.account_id] cfset vLeaf = true cfelse cfset vLeaf = false /cfif /cfloop The array for the vleafnodes looks like below: array 1 [undefined array element] Element 1 is undefined in a Java object of type class coldfusion.runtime.Array. 2 [undefined array element] Element 2 is undefined in a Java object of type class coldfusion.runtime.Array. 3 3 4 4 5 [undefined array element] Element 5 is undefined in a Java object of type class coldfusion.runtime.Array. 6 6 7 7 8 8 using isdefined or isarray to check if the element is defined in a particular position is not helping during the comparision statement cfif getRec.account_id EQ vleafnodes[getRec.account_id] I keep getting the following error Element 1 is undefined in a Java object of type class coldfusion. runtime.Array. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfssetting showdebugoutput
You want cfsetting showdebugoutput=No not false. It will stop any debug output, just as if you removed your IP address from the list in cf admin. It will not have any effect on error output, etc. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Array Error
You'll need to use a struct to do your bidding instead of an array-- I don't think you can skip values in arrays, so if your query is returning account_ids 1,2,4,5, #3 would fail. maybe something like... cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = structNew() / cfset vleafnodes = arrayNew() / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfset vLeaf = false cfif structKeyExists(vleafnodes, getRec.account_id) cfset vLeaf = true /cfif /cfloop Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = arrayNew(1) / cfset vleafnodes = arrayNew(1) / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfif getRec.account_id EQ vleafnodes[getRec.account_id] cfset vLeaf = true cfelse cfset vLeaf = false /cfif /cfloop The array for the vleafnodes looks like below: array 1 [undefined array element] Element 1 is undefined in a Java object of type class coldfusion.runtime.Array. 2 [undefined array element] Element 2 is undefined in a Java object of type class coldfusion.runtime.Array. 3 3 4 4 5 [undefined array element] Element 5 is undefined in a Java object of type class coldfusion.runtime.Array. 6 6 7 7 8 8 using isdefined or isarray to check if the element is defined in a particular position is not helping during the comparision statement cfif getRec.account_id EQ vleafnodes[getRec.account_id] I keep getting the following error Element 1 is undefined in a Java object of type class coldfusion. runtime.Array. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfssetting showdebugoutput
I'm pretty certain that no, false, and 0 all have the same effect. Dave On Sun, Oct 10, 2010 at 3:43 PM, Reed Powell r...@powellgenealogy.com wrote: You want cfsetting showdebugoutput=No not false. It will stop any debug output, just as if you removed your IP address from the list in cf admin. It will not have any effect on error output, etc. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Array Error
Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = arrayNew(1) / cfset vleafnodes = arrayNew(1) / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfif getRec.account_id EQ vleafnodes[getRec.account_id] cfset vLeaf = true cfelse cfset vLeaf = false /cfif /cfloop The array for the vleafnodes looks like below: array 1 [undefined array element] Element 1 is undefined in a Java object of type class coldfusion.runtime.Array. 2 [undefined array element] Element 2 is undefined in a Java object of type class coldfusion.runtime.Array. 3 3 4 4 5 [undefined array element] Element 5 is undefined in a Java object of type class coldfusion.runtime.Array. 6 6 7 7 8 8 using isdefined or isarray to check if the element is defined in a particular position is not helping during the comparision statement cfif getRec.account_id EQ vleafnodes[getRec.account_id] I keep getting the following error Element 1 is undefined in a Java object of type class coldfusion. runtime.Array. Thank you. That helped ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm