similar to: get foreign key table data

Displaying 20 results from an estimated 100 matches similar to: "get foreign key table data"

2006 Apr 28
7
acts as drop down
Hi Im using the acts as drop down plugin and have this code below acts_as_dropdown :text => "forename", :order => "forename" It currently makes use of the forename in the option tag, how can I get it to use the surname as well ie somthing like ''forename'' . ''surname'' in php Thanks -- Posted via http://www.ruby-forum.com/.
2006 Apr 24
4
creating a select box
Hi trying to create a select box in _form.rhtml. I have a table called organisations that contains fileds, 2 being ''id'' and ''name'' these are the fields I need to bring over to the clients _form.rhtml. whats the best way of going about that?? 2 ways i have seen suggested that I cant get to work -@organisations = Organisation.find_all placed this in def new
2006 Jun 10
4
using STI in a migration
I have some classes in my model which use STI and they work as expected in the console. However, when I try to use them in a migration, I get "uninitialized constant OfficePhone", for example. Why doesn''t the migration environment pick up the class defs? OfficePhone is defined in the model/phone.rb. I put model :phone in the application.rb but my migration just
2006 Apr 25
3
select boxe
yop, http://rubyonrails.org/api/classes/ActionView/Helpers/FormHelper.html ici j''ai vu qu''on pouvait g?n?rer des ?l?ment d''un formulaire gr?ce des m?thodes. Apres quelque petite recherches j''ai trouv? comment g?n?rer un select <%= select(''category'', ''category.id'', Category.find_all.collect {|category| category.nom})
2009 Oct 29
4
Unknown column 'quotes.organisation_id' in 'where clause': SELECT * FROM `quotes` WHERE (`quotes`.organisation_id = 1036)
Hi, I have a small app that needs to keep track of quotes, and organisations. An organisation can either be the unit who finally receives the goods (the end_user) or and intermediary (customer) (and in some cases both) An Organisation will (hopefully :) ) have many quotes; and a quote can belong to an organisation, either as a customer or as an end_user or both. So the quotes table
2006 Jun 08
9
find :order =>
Hi, I have the following find statment @client_pages, @clients = paginate :clients, :per_page => 20, :order => "organisation_id, surname" currently im ordering by organisation_id however I need to order by the field in the organisation table organisations.name how can this be done? Thanks Scott -- Posted via http://www.ruby-forum.com/.
2013 Dec 29
1
how to separate virtual delivery and authentication?
I have a "pure ldap" setting with postfix and dovecot. When using dovecot delivery, the recipient is checked via ldap. The same ldap query is used when authenticate. So, if I want to authenticate with the uid , I can't use a filter like uid=%u because the delivery will fail. I don't want to use %nor something else because I could use multiple e-mail addresses on a single
2006 Jun 27
1
find (ordering by field in related table)
Hi, I am using the rails find command as below @project_pages, @projects = paginate :projects, :per_page => 20, :conditions => "clients.organisation_id = " + params[''search''][''organisation_id''], :joins => ''inner join clients ON clients.id = projects.client_id'' There seems to be a problem with project.id being over written
2006 Jan 06
6
NewbieQ: How do I refresh view after return from popup window
Hi, I have this bitta code that is supposed to open a new window and allow the user to create a new Organisation on the fly whilst editing a new Person i.e. if the Organisation exists they can select it from the drop down select. Otherwise they can click on the cute button and enter a skeleton Organisation record. What I need to do next is refresh the drop down select on returno the new
2004 Aug 19
6
How to run different codecs between the same endpoints on an IAX trunk?
Or perhaps how to configure and refer to two parallel IAX trunks with different codecs? I have a situation where I'm using G.729A as my IAX trunking codec. Now I need to push some short duration, low bitrate modem traffic over the link (a credit card terminal). Obviously the modem audio isn't going to survive the G.729 codec process intact, so for the times the device is used I'd like
2014 Dec 01
2
Application for write permissions to CentOS wiki
On 1 December 2014 at 21:46, Jerry Amundson <jamundso at gmail.com> wrote: > On Mon, Dec 1, 2014 at 3:15 PM, Alan Bartlett <ajb at elrepo.org> wrote: >> On 1 December 2014 at 20:26, Karol Babioch <karol at babioch.de> wrote: >>> Am 11.10.2014 um 00:04 schrieb Karol Babioch: >>>> I hereby would like to ask for write permissions to the CentOS wiki.
2006 Jun 18
2
Table Relationship for Select option list
I''m pretty new to developing web apps and need help with my database table design. I''m working on an inventory application to manage WLAN hardware. I''ve created a table to hold information on each device with the following (model refers to the manufacturer''s model number): create table devices ( id int not null auto_increment,
2008 Jan 20
2
Reporting for Duty.
Hello to the AdminGroup, >From what I have been told (by a very reliable source (AY)), I should direct this for the attention of Ralph. In the nicest possible way, Community members Akemi and Ned (aka toracat and NedSlider) have been twisting my arm to get me to agree to join the Wiki editors. Being susceptible to the right sort of persuasion, I eventually agreed. Over the last few weeks I
2014 Dec 01
2
Application for write permissions to CentOS wiki
On 1 December 2014 at 20:26, Karol Babioch <karol at babioch.de> wrote: > Am 11.10.2014 um 00:04 schrieb Karol Babioch: >> I hereby would like to ask for write permissions to the CentOS wiki. >> I've just created a new account. My username is "Karol Babioch" [1]. > > Ping. Pong! A home page has been created for you and you should now be able to create
2017 Dec 14
4
SIP trunks going to the wrong context
Hi all, I'm trying to resolve a weird issue with SIP routing. I have a number of SIP trunks, from a selection of providers, all of which are registered in sip.conf: [general] context=default allowguest=no allowoverlap=no udpbindaddr=0.0.0.0 tcpenable=yes tcpbindaddr=0.0.0.0 transport=udp bindport=15060 srvlookup=yes allowsubscribe=yes
2006 Aug 14
0
acts_as_dropdown: NoMethodError on load
Rails 1.1.6 on gems I had the acts_as_dropdown plugin working fine, but now starting webrick gives me a: C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1129:in `method_missing'': undefined method `acts_as_dropdown'' for User:Class (NoMethodError) My other plugins are working fine. I have the latest version of acts_as_dropdown. Gems are
2006 Nov 04
0
[Markaby] select with acts_as_dropdown problem.
I''m using Markby to convert a standard form witth selects. Can someone tell me why this works: <tr> <td><label class="formLabel" for="task_owner_id">Owner</label></td> <td><%= select ''task'', ''owner_id'', Owner.to_dropdown %></td> </tr> But, the Markaby conversion
2006 Jun 21
0
acts_as_dropdown
Hi I am currently using the acts as drop down to create select lists. Is it possible to use this blogin to create grouped select lists. (ie one list, but with bold headings above groups of names) thanks, scott -- Posted via http://www.ruby-forum.com/.
2006 Feb 03
9
Because I''m very slow - trying to use console
I can''t see how to use variables so I am using console to test things out... clients table - a column named first_name My very brief console session... >> clients = Client.find_by_sql("select * from clients where first_name = FN") ActiveRecord::StatementInvalid: RuntimeError: ERROR C42703 Mcolumn "fn" does not exist Fparse_expr.c L1034
2006 Feb 02
12
basic ''find'' question
I am struggling to understand the methodology here... I have a find.rhtml <%= start_form_tag :action => ''list2'', :first_name = client %> <%# render :partial => ''form'' %> <p><label for="client_first_name">First name</label><br/> <%= text_field ''client'', ''first_name''