Stored Procedures

[OCdeBruyn]

Provide	Response	Status	Parameter List
Username	Basic User Details	Complete
Username	Retrieve all posts from a specific user	Complete
None	Return all the Topics	Pending
Topic ID	Return all the Posts on a specific topic	Complete
Institution	Return all the group leaders of the groups in the institution	Pending
Group Leader ID	Return all the group members of the group of the group leader	Pending

The following I am still unsure of, because there isnt enough information in the database yet to see how to read and write data to and from the database, but gives a general idea of what needs to be done.

Provide	Responce	Status	Parameter List
(Discuss)	Create a Topic	Pending
(Discuss)	Create a Post (On a Topic)	Complete

[vee921]

Please just indicate the specific stored procedure name with their precise parameters, because they won't work if i don't use the same names. Another thing to look into is to see if the said stored procedure above with a "Pending status" actually has a function in the DAL.

[OCdeBruyn]

They all have functions ... that's why they were put there

[JAspeling]

I will recreate the table which will display the variables i will pass through to the database as well as the values I expect in return when I have a chance

[vee921]

Still waiting for the parameter list and returns for the pending SPs,

[JAspeling]

I'l request the stored procedures as I need them