Your mashlet code is fine, but it doesn't invoke a database service directly, it invokes a mashup service called StaffService, which I assume you created using Presto Wires, and this StaffService mashup must then invoke a published DB Service findStaffAll operation.
Can you confirm that the StaffService mashup service exists and is active and returns an xml response of the form:
<?xml version="1.0" encoding="UTF-8"?>
<Staff_Array>
<Staff>
<staffNo></staffNo>
<sFname></sFname>
<sLname></sLname>
<sHouseNo></sHouseNo>
<sStreet></sStreet>
<sCity></sCity>
....
....
</Staff>
...
...
</Staff_Array>
You could also test by bypassing the StaffService mashup and invoking the DB Service directly
by replacing the request sid and oid with your DB service name as sid and an oid of "findStaffAll".
Appreciate you taking a look through the code, it was actually a DB service i was calling and that was the problem, i was calling it like a mashup so just changed the oid to "findStaffAll" and put all columns in lower case (not sure this was necessary but this was the format given in the XML output) and it returned the values from database in the grid.
Thanks alot
Hello there,
I am currently trying to develop a custom mashlet type that will be in the form of a grid taking in the details from a database service called StaffService (which is just staff details in a table from a database) as i want to add events on a row select. This is service is working correctly and has been tested and returns results in the XML record fornat Staff_Array/Staff.
I have based my attempt on the sample.employeelist example given in the webapps/mashlets folder but so far the mashlet is only being displayed with the grid headers given but with no details under them from the database service.
i have attached the main script used for this. I see for "FindAll" from a database service there is no parameters needed for the request.
thanks
Jack