Hey
Although the call_mssql_sproc functionality works nicely, I ran into an
issue when I try to retrieve datasets using it. As it returns the first row
of the dataset, if the stored proc returns a result set, you'll get the
first row of the result set, not the row containing the numrows and result
values.
I realised that I can do the following, though:
result = DB.fetch("EXEC ResultSetStoredProc ?, ?, ?", 'Filter', (Date.today
- 6), (Date.today + 1))
I'm trying to think of a way to combine these two methods, but I'm not sure
if that's necessary, or even how to do it properly.
Thoughts?
J
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
