SearchSearch FAQFAQ  User Control PanelUser Control Panel LoginLogin

All times are UTC - 6 hours



Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: AMFPHP recordset
PostPosted: Tue Jan 24, 2006 1:33 am 
Hi, before purchasing, I'm trying Service Capture with AMFPHP latest stable release.

My app is returning a RecordSet:
I can see all the data in NetConnection Debugger BUT I can't see my recordset in Service Capture: that is, I know, from a screenshot, Service Capture should be able to read the data. I simply get no recordset tab...

Thanks. NNG


Top
  
 
 Post subject:
PostPosted: Tue Jan 24, 2006 6:16 am 
Offline
Site Admin

Joined: Thu Sep 08, 2005 9:29 pm
Posts: 265
Are you returning only a record set or are you returning a complex object with other properties and a record set?

Currently the recordset tab only is present when you return a single recordset and no othe data. Next release should fix this.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 31, 2006 5:47 am 
I'm returning ONLY one recordset (nothing nested at all, a simple recordset). If you want I can post the class code too


Top
  
 
 Post subject:
PostPosted: Tue Jan 31, 2006 5:51 am 
inside the Method Table:

// MT:

"sendQuery" => array(
"description" => "back a resource",
"access" => "remote",
"returns" => "recordset"
),

// METHOD:

function sendQuery($col,$tab){

$query_result = mysql_query(sprintf("SELECT ".$col." FROM ".$tab));
return($query_result);

}


Top
  
 
 Post subject:
PostPosted: Tue Jan 31, 2006 6:50 am 
Offline
Site Admin

Joined: Thu Sep 08, 2005 9:29 pm
Posts: 265
Everything looks correct.

You are seeing the "Remoting" tab with the data, just no "RecordSet" tab? Or you don't even see the request?

Is this a public facing app would you be willing to email me a url for me to test?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 01, 2006 4:40 am 
Hi, may I eventually send you the URL in private mail?

Anyway, what I see is the following:

left side "Request":
three tabs:
Headers, Performance, Remoting

right side "Headers"
two tabs:
Headers, Remoting

this last tab appears practically empty, showing three columns "Name", "Type", "Value".

Thanks.


Top
  
 
 Post subject:
PostPosted: Wed Feb 01, 2006 7:36 am 
Offline
Site Admin

Joined: Thu Sep 08, 2005 9:29 pm
Posts: 265
OK that helps a lot more. It sounds like a problem in trying to render those perticular results.

This sounds like a problem that was fixed a while ago. Your using the latest version of SC correct? I think this problem was fixed in release 1.1.14.

It also could be a problem that I never got to the bottom of here: http://kevinlangdon.com/phpBB2/viewtopic.php?t=18 Do you know if there are any special characters? or does it resolve itself if you specify the encoding to the gateway?

Jus curious, how large is that RecordSet?

Yes, if you feel comfortable sharing the url, my email is sc@kevinlangdon.com


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 01, 2006 9:14 pm 
Offline
Site Admin

Joined: Thu Sep 08, 2005 9:29 pm
Posts: 265
I finally got to the bottom of this. The problem was due to AMFPHP not returning valid UTF characters. I updated SC to handle this and make best guesses on the encoding. This is supported in 1.2.3.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 6 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group