search for: recordset

...use the # migrations feature of ActiveRecord to incrementally modify your database, and # then regenerate this schema definition. ActiveRecord::Schema.define() do # Could not dump table "SalesCustomers" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "SalesPlans" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the...

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

...talling these prerequisites, I removed the IE6-ProgramFolder, unpacked our ZIP to c:\dh_RPC, started the Server and the Client - eh voilà - all was working fine (Linux->Linux and XP->Linux). The complete set of COM-DemoCalls was working "OutOfTheBox", even the "Disconnected ADO-Recordset"-Call was successful. (For the Linuxers, that are serialized DB-Resultsets, wich are often used in distributed COM-Scenarios). No Memory-Leaking, even under Stress (the server was able, to deliver max. 700 small COMRequsest per second, stressed from multiple Clients (XP-Box, comparable Hardwar...

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 collection. Is there a way to use the result of my find_filtered (which is an array of AR) and create paginator objects for it? Thanks -- View this message in context: http://www.nabble.com/Pagi...

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: http://philip.gre...

...ve 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 recordset and then to display it somewhere. Thanks also for any links to documentation that clarifies this. TIA, Tuka PS: I dont program with ruby yet... but I can easily read any snippet given.. I think -- Posted via http://www.ruby-forum.com/.

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 "myDB <- odbcConnectAccess(CurrentDb)" 'query the database and save it as R object 'a' myApp.Evalua...

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 paginate these records....

...le understanding how to handle general purpose queries. A few people have said "with rails I never need to" but either my cases are special or I just don''t "get it" yet. For example, my existing site runs the mysql query SHOW PROCESSLIST, captures the output in a recordset and dumps it to html. Another example is user management where I issue grant statements "GRANT ALL ON dbname.* to user%''*'' IDENTIFIED BY ''abcdefg''", and this merely executes and does not return a record set. I''m absolutely sure there is a...

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

...er solving my MySQL problem, I ran into a strange error in R (and DBI/RMySQL). R connected to the database just fine, and I could even show the tables in the database and load two of them into R. However, the tables I loaded successfully were only a single column. Every time I tried to load in a recordset that was multiple columns, I got a relatively nondescript Windows error("R for Windows terminal front-end has encountered a problem and needs to close. We are sorry for the inconvenience."). To verify that it wasn't a memory issue, I even tried "rs <- dbSendQuery(con, &quot...

...ore fly-weight model. In short, once I''m done with a record I don''t need it any more. Most database related stuff I''ve used operates this way. In short you have one object (in Java it would be a ResultSet), and its contents are mutated as you iterate over the whole recordset. Instead of trying to create 12,700 objects and its ancillary information, merely creating one object and changing its value as you iterate. Am I going to have to go to a lower level API to do what I need? If so, I would still like to use the ActiveRecord API for each individual record.... U...

Hi all, I've been using Dreamweaver CS4 with WINE for the last couple of days, here are a couple of bugs that I noticed. WINE buglist for Adobe Dreamweaver CS4 Version 10.0 Build 4117: Shift doesn't work in the listbox but ctrl does (for example, when using the recordset window) After opening some menus, the menus do not disappear, not even when minimizing, and stay there until the program is closed. A good way to make this occur is to click on one of the menus and just pass your cursor over every other menu, then click on an empty space in the bar next to the men...

..."date >= ''" << begin_date << "'' AND date <= ''" << end_date << "'' AND user_id = ''" << @user.id.to_s << "''") As I said, the above just returns the first field of a recordset for the given date range -- not a sum of the entire week. I could iterate through that record set and create a running total, but that doesn''t seem like the right way to do it. -- Posted via http://www.ruby-forum.com/.

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 to be displayed and downloaded (CSV), but not all fields will be available for each &...

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

...--------- development: adapter: sqlserver database: triage_development username: user password: pass host: server schema.rb --------------------------------- # Could not dump table "categories" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. Any ideas? If you need more info, I''ll be happy to supply it. I probably missed something, but I''m not seeing it. Thanks for lending an eye! -- Adam C. Bair ada...

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 a...