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.
