Re: cfssetting showdebugoutput

2010-10-10 Thread enigment

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

2010-10-10 Thread Russ Michaels

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

2010-10-10 Thread David Six

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

2010-10-10 Thread James Holmes

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

2010-10-10 Thread David Six2

 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

2010-10-10 Thread Azadi Saryev

  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...

2010-10-10 Thread Azadi Saryev

  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

2010-10-10 Thread fun and learning

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

2010-10-10 Thread David McGraw

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

2010-10-10 Thread Reed Powell

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

2010-10-10 Thread Jessica Kennedy

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

2010-10-10 Thread enigment

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

2010-10-10 Thread fun and learning

 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