Displaying 2 results from an estimated 2 matches for "bank_id".
2012 Nov 17
2
Help needed for error in foreign key validation
I have two models bank and country. User should only associate a Bank with
a country id present in the country table and I put validates presence of
country to enforce it but i get error mysql2::Error: Unknown column
''countries.bank_id'' in ''where clause'': SELECT `countries`.* FROM
`countries` WHERE `countries`.`bank_id` = 17 LIMIT 1 when updating the bank
table
Can you tell me how to fix the issue? If I remove the
validates_presence_of :country I get a database error as expected when i
update...
2011 Mar 28
2
"Holes" in a data frame with time intervals
...h a "declarative" approach.
I have a dataframe df with some information about bank branches with a
validity time associated (start date/end date, format YYYY-MM-DD) to
some attributes (for example number of employees assigned).
The following example will clarify this description:
BANK_ID BRANCH_ID EMPLOYEE # STARTDATE ENDDATE
B1 A15 30 2001-01-01 2001-10-15
B1 A15 28 2001-10-16 2001-12-31
B1 A15 32 2002-01-01 2003-04-18
B1 A15 33 2003-04-19 2004-12-31
B1...