I hate it when people think out of the box, and comes up with a perfect simple solution. Perfect, thanx for the help.
regards svend On Oct 19, 2:19 am, Daniel <[EMAIL PROTECTED]> wrote: > On Oct 19, 6:13 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > wrote: > > > Thanx, but using fixtures_create removes the current contense of the > > database. > > This is not for devel, this is in the production enviroment. > > > regards > > svend > > I've only used the technique I mentioned to populate the table in its > totality. If you're appending data to a table, you could perhaps > create a loading table as a copy of the table you're loading to (sql: > create <loading-table> as select * from <table> where 1=0; (not sure > if it works on every db) / or do it the migration way). Use the > fixture technique discussed to load it with data from your yaml file. > Then run an insert sql statement: 'insert into <table> select * from > <loading-table>'. > > -- > Daniel Bush --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
