Stored Procedures

http://www.datafaucet.com/storedprocedure.cfm











... do something ...
... display the results ...

Here is the same stored procedure executed using the procedure object.


// get the datasource
ds = request.DataFaucet.getDatasource();
// get a procedure object
proc = ds.getProcedure().init(
procedure = "usp_ComplexProductSearch"
parameters = form,
results = "PopularProducts, RecentProducts, SearchResults",
maxrows = "10,10" // limit popular & recent to 10 records
);

// execute the procedure and return the results struct
q = proc.execute();


... do something ...


... display the results ...