CRecordset and Stored Procedures

[unseth]

I'm working with Stored Procedures and CRecordset.

I'm just trying to figure out the syntax. I finally figured out the syntax to the SPO but I can only get the one to work that doesn't take input.

For example:

strSQL = "{CALL spotest}";
rs->Open(CRecordset::dynaset, strSQL, CRecordset::readOnly);

this one works fine. My next one takes input, so

strSQL = "{CALL getFilings '22,41','2000-01-01','2000-01-31','3,1,2','',''}";

that one doesn't work. I get an error. Are the input fields supposed to be passed in differently or is it something else I'm doing wrong?

thanks

 

[unseth]

i figured it out.

thanks.

You need parenthesis. So it should be:

strSQL = "{CALL getFilings ('22,41','2000-01-01','2000-01-31','3,1,2','','')}";

what a pain in the arse.