Alex | 4 Jul 19:07 2009
Picon

multiple rows return ?


Hi all,

I have not found any examples that handle multiple rows of data
returned from database. Anyone can please show me an example? What I
have is this

I have a service that returns multiple rows of result from a database
query, for example

SELECT employeeID, employeeName, employeeAddress FROM EMPLOYEE;

Say the returned result is

1 | John | One Road
2 | Mark | Two Road
3 | Luke | Three Road

How can I represent that in xsd and how those results are going to put
into the array to return the result from the services and at the
client side getting and displaying these results?

Thanks in advance for any help.

Dalibor Andzakovic | 5 Jul 22:40 2009
Picon

Re: multiple rows return ?


One way you could achieve this is:

XSD:

<xsd:complexType name="EmployeeList">
<xsd:sequence>
	<xsd:element name="Employee" type="EmployeeList_T" minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
</xsd:complexType>

<xsd:complexType name="EmployeeList_T">
<xsd:sequence>
	<xsd:element name="employeeID" type="xsd:integer" />
	<xsd:element name="employeeName" type="xsd:string" />
	<xsd:element name="employeeAddress" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>

PHP

$sth = $this->PDO->prepare("SELECT employeeID, employeeName, employeeAddress FROM EMPLOYEE;");
$sth->execute();
		
$employeeList = SCA::createDataObject('your/xsd/namespace', 'EmployeeList');		

while($row = $sth->fetch(PDO::FETCH_OBJ)){			
	$employee = $employeeList->createDataObject('Employee');
	$employee->employeeID = $row->employeeID;
	$employee->employeeName = $row->employeeName;
(Continue reading)

Dalibor Andzakovic | 21 Jul 01:55 2009
Picon

PECL build on OSX


Hi all,

Has anyone successfully built SCA_SDO on current OSX with PHP 5.3 from
macports?

pecl install SCA_SDO errors out with:

/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:80: error: multiple
storage classes in declaration of 'arginfo_sdo_dataobject'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:86: error: multiple
storage classes in declaration of 'arginfo___get'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:90: error: multiple
storage classes in declaration of 'arginfo___set'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:103: error: multiple
storage classes in declaration of
'arginfo_sdo_dataobject_createdataobject'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:119: error: multiple
storage classes in declaration of 'arginfo_sdo_sequence_getproperty'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:123: error: multiple
storage classes in declaration of 'arginfo_sdo_sequence_move'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:128: error: multiple
storage classes in declaration of 'arginfo_sdo_sequence_insert'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:144: error: multiple
storage classes in declaration of 'arginfo_sdo_list_insert'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:158: error: multiple
storage classes in declaration of 'arginfo_sdo_datafactory_create'
/private/tmp/pear/download/SCA_SDO-1.2.4/sdo.cpp:177: error: multiple
storage classes in declaration of
'arginfo_sdo_das_datafactory_addType'
(Continue reading)

dnzone88 | 29 Jul 10:56 2009
Picon

phpsoa error message


I m in need of help. I get this error message everytime i try to run
my code
"Fatal error: Uncaught SCA_RuntimeException: The remote service threw
a soap fault. The text of the response was: thrown in /usr/local/
apache2/htdocs/MyMOL/webservices/CompanyData/SCA/Bindings/soap/
Proxy.php on line 419"

My Senario is like this. I develop my code on my local pc under
windows XP using wamp and my production server is actually a linux
server. Everytime i test the web services locally on my pc it work
fine but when i uplaod my code to the server i get the error message
above.

Below is my sample code: -
CompanyData.php
<?php

include "include/dbconnection.inc";
include "SCA/SCA.php";

/**
 *  <at> service
 *  <at> binding.soap
 *  <at> types http://10.8.6.199/CompanyData CompanyData.xsd
 */
class CompanyData {

	/**
	 * Get Web Service Path
(Continue reading)

deadguy | 31 Jul 03:43 2009
Picon

no wsdl generated


Hello all,

I've seen some very similar posts to my problem, but have not yet
found a solution for me.  I'm trying to generate the wsdl for the
following sample from the php manual:

<?php

include "SCA/SCA.php";

/**
 * Scaffold implementation for a remote StockQuote Web service.
 *
 *  <at> service
 *  <at> binding.soap
 *
 */
class StockQuote {

    /**
     * Get a stock quote for a given ticker symbol.
     *
     *  <at> param string $ticker The ticker symbol.
     *  <at> return float The stock quote.
     */
    function getQuote($ticker) {
        return 80.9;
  }
}
(Continue reading)

Matt Brown | 31 Jul 19:14 2009
Picon

Re: no wsdl generated


Finally able to get SCA logs going.  I must it's ridiculous that doing
so isn't documented anywhere;  you have to go through the log code to
figure it out.

For future reference:
SCA.php: SCA::initComponent() (line 128)
uncomment self::$logger->startLog();

SCA_Logger.php: SCA_Logger::startLog() (line 273)
uncomment  trigger_error("SCA logging started; logging to $this->logfile");

For me, on ubuntu 9.04, it was logging to /tmp/log/SCA.log

Anyway, once I managed to get some logs, I got the following:

Finally able to get SCA logs going.  I must it's ridiculous that doing
so isn't documented anywhere;  you have to go through the log code to
figure it out.

For future reference:
SCA.php: SCA::initComponent() (line 128)
uncomment self::$logger->startLog();

SCA_Logger.php: SCA_Logger::startLog() (line 273)
uncomment  trigger_error("SCA logging started; logging to $this->logfile");

For me, on ubuntu 9.04, it was logging to /tmp/log/SCA.log

Anyway, once I managed to get some logs, I got the following:
(Continue reading)

Matt Brown | 31 Jul 18:22 2009
Picon

Re: no wsdl generated


From phpinfo():

PHP Version 5.2.6-3ubuntu4.1

soap

Soap Client 	enabled
Soap Server 	enabled

Directive	Local Value	Master Value
soap.wsdl_cache	1	1
soap.wsdl_cache_dir	/tmp	/tmp
soap.wsdl_cache_enabled	0	1
soap.wsdl_cache_limit	5	5
soap.wsdl_cache_ttl	86400	86400

I changed the PHP log setting to E_ALL.  Still no messages.

Any ideas?

thanks

On Thu, Jul 30, 2009 at 9:43 PM, deadguy<deadguysfrom@...> wrote:
> Hello all,
>
> I've seen some very similar posts to my problem, but have not yet
> found a solution for me.  I'm trying to generate the wsdl for the
> following sample from the php manual:
>
(Continue reading)


Gmane