So i assume that i use the .fetch method:
$DB.fetch("EXEC Stored_Procedure @param1 = X, -- varchar(50)
@param2 = x, -- datetime
@param3 = x', -- datetime
@param4 = x -- bit
") do |row|
puts row[:Column]
end
So i have a couple questions, how do i get any information out of what's
returned? I want to be able to compare the text value of the report with
it's corresponding column in the stored procedure.
I guess my other question is do you know any sequel like gems that support
stored procedures? I'm testing the data of some reports so I'd rather not
try to do each query in the sproc individually.
On Wed, Mar 7, 2012 at 4:58 PM, Jeremy Evans <[email protected]> wrote:
> On Wednesday, March 7, 2012 4:25:59 PM UTC-8, Hillary wrote:
>>
>> Does any of the mssql adaptors support executing a stored procedure?
>>
>> It seems like JBDC does, but I'm using sequel with watir to test a web
>> application so i can't really install jruby.
>>
>
> Unfortunately, JDBC is the only adapter that currently supports MSSQL and
> stored procedures. The odbc, ado, and tinytds adapters support MSSQL, but
> not stored procedures. By that I mean there is no direct support at the
> Sequel level. I vaguely recall you can just call stored procedures in
> MSSQL using literal strings with EXEC, but I don't believe there is support
> for in/out variables (I don't think the Sequel JDBC adapter supports in/out
> variables either).
>
> Note that if stored procedures are supported directly by the underlying
> driver, you can just drop down to the driver level via DB.synchronize and
> call the methods on the yielded connection object.
>
> I'll certainly consider merging patches that add stored procedure support,
> as long as they come with specs.
>
> Thanks,
> Jeremy
>
> --
> You received this message because you are subscribed to the Google Groups
> "sequel-talk" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/sequel-talk/-/LLI-pBBtzA0J.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sequel-talk?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
