search for: section_id

Displaying 14 results from an estimated 14 matches for "section_id".

2006 Feb 27
1
How to build a recursive parenting structure?
...ot;section". So I built a "sections" table and in the model I included the line "has_and_belongs_to_many :sections" I also made a table called "sections_sections" to build the heirarchy however the fields I generated were: CREATE TABLE `sections_sections` ( `section_id` INT( 10 ) UNSIGNED NOT NULL, `parent_id` INT( 10 ) UNSIGNED NOT NULL , constraint fk_parents foreign key (parent_id) references sections(id), constraint fk_sections foreign key (section_id) references sections(id) ); Because I can''t have two section_id fields. So how can I let rails...
2006 Apr 18
6
Postgresql and ActiveRecords problems
Hi all. I have a problem with postgresql PK columns and ActiveRecord. The error is: PGError: ERROR: null value in column "item_id" violates not-null. Ok, it''s wrong to insert NULL into PK columns, but rails doing it. How to fix? So sad..
2006 Feb 23
4
MySQL Duplicate Key Error
...able called ''privileges'' which has the following fields CREATE TABLE `sdqualplanner`.`privileges` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '''', `description` varchar(100) NOT NULL default '''', `section_id` int(10) unsigned NOT NULL default ''0'', `designation_id` int(10) unsigned NOT NULL default ''0'', `department_id` int(10) unsigned NOT NULL default ''0'', `view` varchar(1) NOT NULL default ''1'', `create` varchar(1) NOT NULL...
2006 May 28
1
ActiveRecord: FK constraints problem
...(32) NOT NULL, name character varying(64) NOT NULL, title character varying(64) NOT NULL, keywords character varying(256), description character varying(512), contents character varying(2048), last_modified timestamp without time zone ); CREATE TABLE contents_sections ( section_id integer NOT NULL, content_id integer NOT NULL ); ALTER TABLE ONLY contents_sections ADD CONSTRAINT fk_contents_contents_sections FOREIGN KEY (content_id) REFERENCES contents(id); ALTER TABLE ONLY contents_sections ADD CONSTRAINT fk_sections_contents_sections FOREIGN KEY (section_id) R...
2006 Apr 20
4
ActiveRecord: Many-to-Many problem
...ent and Section has: has_and_belongs_to_many :contents and has_and_belongs_to_many :sections and I have an exception when trying to access model properties: "undefined method `add_contents'' for #<Section:0xb745c514>" def add_content_entry @section = Section.find(params[:section_id]) @content = Content.find(params[:content_id]) @section.add_contents(@content) @section.name = ''test'' @section.update redirect_to :action => ''list'' end Where I am wrong?
2004 Jul 16
2
where to sign up for fwd
Could someone please point me to the proper url to register for a fwd acount and get a fwd number. I couldn't find it at www.freeworlddialup.com or fwd.pulver.com Thanks, -Galt -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." Benjamin Franklin
2005 Dec 15
3
Rails: Select and html forms
I''m close to getting this to work, but not quite there. I''m trying to implement a dropdown control, with the current choice selected. I have the following code in the view: 5 <select id="product_product_type" name="product[product_type]"> 6 <%= 7 types = ProductType.find(:all, :order => "product_type") 8
2005 Dec 06
5
How to set a default value?
Hello, I have a price field that I validate of numbers. How can I default a 0.0 value? Regards, Frank Rocco farocco-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org
2005 Dec 19
1
Is there a guide for using ERBSQL?
...Also what if I want to use a different set of options for the table instead of the default ones generated by create_db. Finally, I am using the following sql to signify my foreign keys but these statements create a syntax error when I run create_db: constraint fk_pages_section foreign key (section_id) references sections(id) Any advice or links to a guide on working with erbsql? Also any advice as to how to signify the foreign keys the erbsql way? ---------------------------------------- Jim Jeffers "A trustworthy individual." www.DontTrustThisGuy.com (480) 235-5201 ________...
2006 Jan 30
9
error when adding a new table to the existing application
Deniz wrote: > Hi Everybody, > I am a newbie in this list so please forgive me if this is a lengthy > message. > Currently I am working on a project at my work place that includes > viewing some oracle tables(I do not have control over to rewrite the > tables) and searching the tables based on a given criteria with Rails. > Up untill now everything was working great. The
2006 Apr 03
1
Re: F6H500ukUNV working with fentonups driver
Hi Patrick, 2006/4/2, Patrick Beard <p.beard@blueyonder.co.uk>: > Hi Arnaud, > > Just wanted to let you know the the Belkin F6H500ukUNV is working for me > with the fentonups driver. > > http://catalog.belkin.com/IWCatSectionView.process?IWAction=Load&Merchant_Id=&Section_Id=202840 > > I originally tried it with the genericups driver with upstype=7 but this > gave me 'On battery' 'Low Battery' all the time. I went through all the > upstype settings but none worked. > I then tried the 'bestups' driver but this never worked. > &g...
2007 Nov 17
0
rake errors
...n::Session.new; app.get(''/facebook/update_profiles'') puts app.html_document.root.to_s end end controller action.... def update_profiles @users=FacebookUser.find(:all) @articles = Article.find(:all, :conditions=>"created_at<now() and status>0 and section_id!=13",:limit=>5, :order=>''created_at DESC'' ) fbsession.activate_with_previous_session(''xxx'') for user in @users profile_box = render_to_string(:template => ''facebook/index'') fbsession.profile_setFBML({:markup =...
2009 Mar 14
9
null object pattern
...gems/activesupport-2.1.0/lib/active_support/dependencies.rb:467:in `const_missing'' from /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:479:in `const_missing'' from (irb):1 >> User.new => #<User id: nil, username: nil, section_id: nil, password_hash: nil, password_salt: nil, role_id: nil, member_number: nil, tm_zone_info: nil, region_id: nil> >> UnassignedUser.new => #<UnassignedUser id: nil, username: nil, section_id: nil, password_hash: nil, password_salt: nil, role_id: nil, member_number: nil, tm_zone_inf...
2005 May 13
0
Problem with IAX trunking
...at the "s" extension of "default" context. ; ;register => user:pass@iaxtel.com register => asterisk1:[asterisk1]@10.10.8.252 ; ; Sample Registration for IAX + FWD ; ; To register using IAX with FWD, it must be enabled by visiting the URL ; http://www.fwdnet.net/index.php?section_id=112 ; ; Note that you need an extension in you default context which matches ; your free world dialup number. Please replace "FWDNumber" with your ; FWD number and "passwd" with your password. ; ;register => FWDNumber:passwd@iax.fwdnet.net ; ; ; You can disable authenticatio...