Re: Array Error

2010-10-10 Thread fun and learning
> Hi All - > > I am trying to do the following in my code. > > > > > 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 > > > > > > > > > > > > S

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 wrote: > > You want 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 err

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... SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_

Re: cfssetting showdebugoutput

2010-10-10 Thread Reed Powell
You want 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

Re: Array Error

2010-10-10 Thread David McGraw
Try this... ArrayAppend(vleafnodes, q.account_id); 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. StructInsert(myLeafStruct, q.account_id, q.account_id, tr

Array Error

2010-10-10 Thread fun and learning
Hi All - I am trying to do the following in my code. 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 SELECT account_id, name, acc_num, debit, credit, balan

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 f

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 pr

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: https://api.facebook.com/method/events.create"; method="post"> And I get the same response, nothing returned from Facebook and nothing po

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 wrote: > > https://api.facebook.com/method/events.create?#params#"; > method="post" mul

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

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

Re: cfssetting showdebugoutput

2010-10-10 Thread enigment
Using 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