search for: dml

I want when the user clicks on a button on the browser "Perform monthly billing run" the controller to lanch a sql DML statment to be called (in the model?) than runs something like "insert into billing (item, qnt, total_cost, billing_run_timestamp select item, qnt, item*cost as total_cost, timestamp from services where service_end_date is null" How can I run a DML (insert, update, delete) direct sq...

...help%40stat.math.ethz.ch References 1. http://clic.reussissonsensemble.fr/click.asp?ref=365414&site=4428&type=text&tnb=42 2. http://clic.reussissonsensemble.fr/click.asp?site=4428&ref=365414&type=text&tnb=77&subid=&diurl=http://ad1.yourmedia.com/links/prelink.dml?c=000100017806&p=000100057670 3. http://clic.reussissonsensemble.fr/click.asp?site=4428&ref=365414&type=text&tnb=77&subid=&diurl=http://ad1.yourmedia.com/links/prelink.dml?c=000100017806&p=000100057670 4. http://clic.reussissonsensemble.fr/click.asp?site=4428&r...

Is it possible to execute a DML statement against a MySQL database from within Rails? I have a table I''m using for batch processing. It needs to be truncated to reset the primary key before each batch insert statement. I looked at the API here: http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/Database...

Hi all I have a new migration file created that adds some tables and fills one with some data: create_table :sound_styles do |t| t.column :name, :string, :null => false end create_table :show_types do |t| t.column :name, :string, :null => false end create_table :countries do |t| t.column :name, :string, :null => false end ActionView::Helpers::FormOptionsHelper::COUNTRIES.each

Hi All I am trying to understand if I can use migrations to migrate data under the following conditions 1. Across 2 different databases (Oracle/DB2) with same schemas. 2. Across 2 different databases (Oracle/DB2) with different schemas. I am trying to avoid writing DBI/OCI8 scripts. Can somone please shed some light if this is even possible? thanks -daya -------------- next part

Just wondering if there''s a way to use migrations to generate join tables (where the table columns comprise only of foreign keys to other tables, and where the primary key is all the foreign keys taken together). I made the changes manually in MySQL, then did rake db_schema_dump and it gave something like this: create_table "apples_oranges", :id => false, :force

...nsic to do this, currently, but on IRC it was pointed out that a patch [1] has been proposed to implement this functionality in exactly the way that I was looking for. It looks like the discussion has died out but I was hoping maybe to kick it off again. [1] https://reviews.llvm.org/D54749 -- - DML • he/him

I am using the restful authentication plugin and am always prompted to login if a different subdomain is accessed. I have found a couple rails "solutions", but none of them seem to work: # development.rb 1. ActionController::CgiRequest::DEFAULT_SESSION_OPTIONS[:session_key] = ".localhost" 2. ActionController::Base.session_options[:key] = ".localhost" Does anyone

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

Hey folks, am hoping someone can set me straight with a solution to an issue that has come up involving the timing of rendered page elements in relation to the completion of an action''s execution. I have an ror search app which searches through two tables consisting of 7,000 page urls and a table w/ 87,000 related keyphrases within those pages. Search results can take anywhere from 2

...be a 5x improvement. $ ruby oci_test.rb user system total real dynamic sql: 8.000000 0.870000 8.870000 (429.277514) bind vars: 12.530000 0.930000 13.460000 ( 82.228332) Not likely to be noticed in a small scale app that''s just got a handful of queries or DML per request. But our site provides an API through which folks manage hundreds of thousands of database rows, so this adds up quickly. Looks like I''d need to replace the call to AR::Base#sanitize_sql, which currently does the condition substitution, and let the OCI connection handle th...

Are migrations used only when you''re making changes to a database? Does it just allow the developer to avoid using raw SQL when working with databases? -- Posted via http://www.ruby-forum.com/. -- 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

...er I download from (unless I''m missing something). I''m new at this, and don''t really know where to start. What complicates it even more for me is the fact that my box will be BOTH a bridge and router in this scenario. Any pointers etc will be very much appreciated. /dml _______________________________________________ LARTC mailing list / LARTC@mailman.ds9a.nl http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/

I''ve just had a look again at the autocompletion demo that Thomas put up at http://script.aculo.us/demos/ajax/autocompleter Unfortunately, in Konqueror (3.4.1) it doesn''t work at all. Not even an error is triggered. It does work nicely in Firefox. How about Safari? I don''t have the time right now to track this down systematically (maybe latter), but just from

Hi, In "Agilge Web Development With Rails" on page 217, an example of foreign keys is shown. I am however unable to find a definition of wheater the naming of the index is significant. On the above mentioned page, this line is shown in the example: constraint fk_items_product foreign key (product_id) references products(id) In "fk_items_product", "items" is

...QSui/Rvf/v/MWO5oa3QUunGsNUlUCP/r4upA+UPK//9f 6FXTZCCMX880LYDPA4EPXuroWqF3UegdrK3///+jxB2O4xe1Kufqscn8BATTwf0tifjKdQbT 07/xBf6TI2x9I72BHfGe96RQDec33gX4//8W5YvIgkkYp1x/CogsXLC1gRzwsKovf6tL3Is3 e5kCVAAANr3LPazf6P//3hqM6PKGrsT3lOM6AjUlIuV29KA6+219//+F/iYZCksa5zlmWTiO neRMSJdVWQ6DwaigrOgt/v95FeC4SPYUI4TJdMleJwjfJmzHQt/637r617h0JG4RS0WBD7pU GLL/3+D/oqfrkdtdzDOthjQufnca3Jg3zr6prjTgb7zETEcolBZRHqDIwTBMFf///9+J2nOh fHaqejM/ibfu7qGSD87NGrDJI4ZrPwWxlxv/v9SM0QghNFbrXUonnclf9ltUrDP1////xG64 z/wOpwxCmohMsweb9lFfbfOXt4yy+DwH2f+t/y+z3KjcxG/N8snJCPgJS/cLOuX3pT8of+NW /7yU5StWwgtxMDFXVdn1LQd9vG////8Ge8t8XwkvYZdnuGe...

I?m trying backup a user?s IMAP folders from a system running dovecot 2.1.7. to a system running dovecot 2.3.19.1. After much perusing of the web and Dovecot documentation I tried this: 1) On the 2.1.7 host set up the doveadm server to listen on TCP port 2425 and defined a doveadm_password value 2) Issued the following command on the 2.13.19.1 system: doveadm -o

I?m running version 2.1.7 under Raspbian Wheezy (and have been for a number of years). I want to allow one of my other computers to remotely issue doveadm commands to my server but can?t seem to find the right way to add an inet listener to permit this. Using ?doveconf -a? I?ve found the default service definition for doveadm-server. So I copied that and added it to the dovecot configuration with