Thanks rohit, I had looked through github, my rdocs from the gem but didn't think of looking at the rubyforge site!!
tonight when i get home I shall test this out. Also tried searching for example usage of stored procedures within sequel github and my gem structure with no luck not to mention googling. Question - Is what I am trying to do something not normally done? if this is the case what would be considered mainstream? also is there any examples of usage for the full_text_search? I refer to this url - http://sequel.rubyforge.org/rdoc-adapters/index.html I am only too happy to do something as a worked example and post to this forum or github. On 22 March 2011 02:43, rohit <[email protected]> wrote: > Dave, > > This is the doc that Jeremy is referring to > > http://sequel.rubyforge.org/rdoc-adapters/classes/Sequel/Dataset/StoredProcedures.html > > It is defined on Sequel::Dataset. Try > > DB.dataset.call_sproc(:select, :sound, 'dave') > > On Mar 21, 5:40 am, dave <[email protected]> wrote: > > Jeremy, > > > > I've tried and looked at the rdoc that comes with sequel 3.21.0 and it > > implies it's wanting 2 parameters only as per listing of errors and > > finally a result but with nothing being returned. > > > > irb(main):056:0> puts s > > dave > > => nil > > irb(main):057:0> puts temp > > > > => nil > > irb(main):059:0> puts @db.call_sproc('sound',"#{s}") > > NoMethodError: undefined method `merge' for "dave":String > > from C:/Ruby187/lib/ruby/gems/1.8/gems/sequel-3.21.0/lib/ > > sequel/adapters > > /mysql.rb:96:in `call_sproc' > > from (irb):59 > > from :0 > > irb(main):060:0> puts @db.call_sproc('sound',"#{s}",temp) > > ArgumentError: wrong number of arguments (3 for 2) > > from (irb):60:in `call_sproc' > > from (irb):60 > > from :0 > > irb(main):061:0> puts @db.call_sproc('sound',"#{s}",:select) > > ArgumentError: wrong number of arguments (3 for 2) > > from (irb):61:in `call_sproc' > > from (irb):61 > > from :0 > > irb(main):062:0> > > > > If I was to use you're sample then it'd be wrong number of arguments > > (4 for 2) so I'm out of my depth here. > > also while looking over the rdocs i see you support full text searches > > now this might be another way of getting where i want to go. > > but again I believe i'll become unstuck as the last parameter it has > > opts{} but there's no definition of what the opts are. > > > > can you or others within this group point me to some simple code for > > either that I can test with? > > > > cheers, > > > > dave. > > > > On Mar 21, 5:21 am, Jeremy Evans <[email protected]> wrote: > > > > > On Mar 20, 2:31 am, dave lilley <[email protected]> wrote: > > > > > > Well been doing some trails, reading searching and via MYSQL console > i've > > > > found this works... > > > > > > call sound(str,temp) > > > > > > So... > > > > > > I've tried in my db connection class a new method with this * > > > > @db.call_sproc(sound(str,temp))* and get the error below... > > > > > You aren't calling that function correctly. Check the RDoc. It's > > > something like: > > > > > @db.call_sproc(:select, 'sound', str, temp) > > > > > > the sound procedure has this as it's only statement.... > > > > > > .... sound(in str varchar(40), out text char(4) > > > > begin > > > > select soundex(str) > > > > end > > > > > I'm not sure Sequel supports in and out parameters on stored > > > procedures, but that select statement should return rows, so you > > > should get a result. > > > > > Jeremy > > > > > > -- > 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. > > -- 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.
