search for: sector_id

Displaying 4 results from an estimated 4 matches for "sector_id".

Did you mean: sector_div
2007 Aug 22
3
tackle memory insufficiency for large dataset using save() & load()??
...ello List, i have been agonizing over this for days, any reply would be greatly appreciated! Situation:___________________________________ My original dataset is a .csv dataset (w/ 2M records) with 4 variables: job_id (Primary key, won't be used for analysis, just used for join tables), sector_id (categorical variable, for 19 industry sectors), sqft (con't variable for square footage), building_type (categorical, for 2 building types) some values of sqft were inputed wrong, so i'd like to set sqft<1 to "NA" and then use aregImpute() to impute those NAs....
2005 Dec 12
2
count sql failing with unknown table....
Hey Rails People, I''m doing my first Rails app and I''m having a newbie problem with the count method.... Mysql::Error: #42S02Unknown table ''jobs_sectors'' in where clause: SELECT COUNT(*) FROM jobs WHERE (jobs_sectors.sector_id = 1 ) Extracted source (around line #4): 1: <div class="sectors"> 2: <ul> 3: <% for sector in @sectors -%> 4: <li><%= sector.name %> ( <%= sector.jobs.count %> )</li> 5: <% end -%> 6: </ul> 7: </div> My test applicatio...
2006 Mar 09
1
Missing fields in search result
...NIZED) doc << Field.new("city", company.address.city, Field::Store::YES, Field::Index::UNTOKENIZED) doc << Field.new("street", company.address.street, Field::Store::YES, Field::Index::TOKENIZED) doc << Field.new("sectorid", company.sector_id, Field::Store::NO, Field::Index::UNTOKENIZED) doc << Field.new("parentsectorid", (company.sector.parent_id || ""), Field::Store::NO, Field::Index::UNTOKENIZED) doc << Field.new("sector", company.sector.name, Field::Store::YES, Field::Index::U...
2006 May 18
8
Concatenated key
Hi all, I started playing a couple days ago with Rails and it find it very interesting. But I''m a bit stuck with making it work with a concatenated primary key. I want to use my own names for the DB fields and I''m using SQL Server 2005. My tables look roughly like this: CREATE TABLE USERS ( USR_ID VARCHAR(25) NOT NULL PRIMARY KEY, USR_PASS VARCHAR(25) ) CREATE TABLE