Both options worked. I'm going to go with DB.fetch(sql, params).insert Thanks.
On Thu, Jan 10, 2013 at 2:45 PM, Jeremy Evans <[email protected]>wrote: > On Thursday, January 10, 2013 2:36:27 PM UTC-8, Hillary wrote: >> >> The stored prodedure doesn't return rows, it just inserts data into the >> tables. Which was why i was using the run, because without the variables >> that was the only way that the data would be inserted into the correct >> tables. > > > You could try using insert instead of all in that case: > > DB.fetch(sql, params).insert > > Note that you can still use DB.run if that doesn't work: > > DB.run(DB.fetch(sql, params).sql) > > 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/-/mSgVZxLyb4EJ. > > 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.
