search for: recordsets

Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter

My last query related to this referred to a problem with not being able to store data. A suggestion was made to try to convert the data returned by fitdist into a data.frame before using rbind. That failed, but provided the key to solving the problem (which was to create a data.frame using the variables fitdist produces in the object it returns). I now have almost everything working as

Hi everyone, I need to create a lot of new db tables during application lifecycle. Like 1000 tables, each holding data from a specific device, collecting data in real time. Each table may have different columns number, e.g. one is: datetime, temperature, pressure and another will be: datetime, voltage, current, power, resistance. Can anybody advice how to best achive it, to make good use

are working now, using our own implementation of a COM-RPC-Server. If you want to test a Server/Client-Pair - here's our free Download: www.datenhaus.de/Downloads/dh_RPC.zip For a successful test under wine, you have to Install the Redistributables of an actual VB6-Runtime and some ADO-Distributable >=2.5 first. I've tested the whole thing under a Debian-Sid with a somewhat older

I''ve created a class method in my model called find_filtered. The intent is that I take various params that the user has submitted, and let the model build the query and return the AR collection, which is exactly what happens. However, now I''d like to paginate the recordset. Everything I''ve been able to find about pagination presumes that you have no pre-existing AR

Ive recently been contemplating how to tackle allowing for extra "fields" to be added to a recordset. For example, a user has an email address, but they may also want to put their birthday, height, weight, etc. I don''t want to constrain what is possible in this situation. I think what I''m describing is best documented in Philip Greenspun''s page here:

Hi, I am just starting of in rails. I am trying to understand the features of rails and I have this burning question. (and search is not available now): Apart from relying on the automatic CRUD sql script produced, is there a way I can create my own sql script ex: with many joins between exixting tables (for reporting ). All I need is to declare the custom query and place the result in a

HI: Is it possible to use the RODBC package within MS Access. I have been using from R but was just wondering if it could be used along with R(D)COM. Something like this: Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim myApp As StatConnector Set myApp = New StatConnector myApp.GetErrorText myApp.Init "R" myApp.EvaluateNoReturn "library(RODBC)" myApp.EvaluateNoReturn

Hi there I have a class method defined in my Product Model, ''featured_items'', which returns a recordset from the products table based on certain find conditions. I simply want to paginate this recordset, not the whole products table, using the paginate helper. After reading the Rails docs, I''m still struggling to work out how, in my ''list'' view, to

Hi, I''m considering migrating my site from php to RoR. I''ve installed RoR gone through the onlamp tutorials and made the recipie/todo list sample sites and tinkered with a few of my own. I understand the examples that use models and scaffolding to map tables, but I''m having a little trouble understanding how to handle general purpose queries. A few people have

Can nsd 2.3.3 make load balancing? Example: www 600 IN A 10.0.0.1 600 IN A 10.0.0.2 600 IN A 10.0.0.3 Greet Sebastian Schikora

Hello, This forum has been very helpful to me in the past, and I've run out of ideas on how to solve my problem. I had been using R and MySQL (and Perl) together for quite some time successfully on my Windows XP machine. However, I recently had some problems with MySQL (the ibdata file had become 35GB on my hard drive, turns out it's a known bug with InnoDB), and ultimately the way I

I''m using ActiveRecord for an Extract and Transform operation, so it is outside of its native environment of Rails. I am running into a problem with memory consumption when I retrieve large amounts of data. By large amounts I am talking about roughly 12,700 records that each have a one to many relationship with about 15 additional types of information. One of those types happens

...edit as well, but it's a bit more complicated.. you would have to modify stuff in gedit where the preferences window of Dreamweaver would be... The Dreamweaver window switches to last opened gnome window when exiting an internal window, such as it's preferences or the window used to create recordsets. How to make this bug appear: Open Dreamweaver, Edit > Preferences, click on one of the list items on the left side of the preferences window, next switch to another program via taskbar, then switch back to Dreamweaver, next click on cancel, and voila! Also happens with the about box. Probably e...

Search doesn''t seem to be working, so forgive me if I''m covering old ground here, but I''m having a difficult time figuring out how to implement a "SUM()" function using Active record. Obviously, I could just create a query, but I''d rather make it part of my active record object. Basically I have an object called "Report <

Hi all! I am quite new to rails, and I would like to know if there is a tutorial, or if someone can tell me how to use rails with stored procedures and views. Any help would be appreciated. Thanks to all -- ------------------------------------------- Gioachino Bartolotta

I''ve inherited an EAV database and there''s really no option to remodel it. Data is stored as key_name, key_value pairs Trying to return a meaningful, unified recordset is far too complex to be efficient. I''ve decided to make use of the MySQL GROUP_CONCAT, and CONCAT_WS functions to return a fast query result, with the consolidated fields as one string. The final data is

I have searched for days for an example that demonstrates what i would like to do, and this morning i thought i''d worked it out, but no....here''s what i have: Controller ========== class ProfilesController < ApplicationController def friends current_user.profile.friends end def list_friends @profile_pages, @profiles = paginate( friends, :per_page => 10) end end

Hello, Using Edge_Rails and SQL Server I get an error in my schema.rb file after issuing "rake migrate". database.yml --------------------------------- development: adapter: sqlserver database: triage_development username: user password: pass host: server schema.rb --------------------------------- # Could not dump table "categories" because of following

Are "centralized" database (SQL) servers best left out of virtualization and committed to their own hardware like the "old days" or are there some guidelines one should consider in setting them up? I'm not talking mega-large recordsets, but large enough to handle multiple years of CRMs and intensive querying, Accounting Systems and so forth. Fundamental website CMS database is a no-sweat issue. This would be on plain vanilla CentOS/Xen stock. All usual SQL server flavors considered. I'm trying to get an idea of where I am...