Displaying 3 results from an estimated 3 matches for "family_id".
2006 Apr 01
3
acts_as_list with scope : position update problem?
...yISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `families` VALUES (1, ''Smith'');
INSERT INTO `families` VALUES (2, ''Jones'');
CREATE TABLE `people` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '''',
`family_id` int(11) default NULL,
`position` int(5) NOT NULL default ''0'',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
INSERT INTO `people` VALUES (1, ''Robert'', 1, 1);
INSERT INTO `people` VALUES (2, ''Brian'', 1, 2);
INSE...
2011 Aug 10
1
subqueries in sqlQuery function (package RODBC)
...o execute subqueries in function sqlQuery (package RODBC)
with opened connection with Excel or SQL server 2000. I couldn't find any
example of this.
And if it is possible what should be a correct syntax for this query:
SELECT ct,COUNT(*) as n
FROM (SELECT COUNT(*) AS ct FROM children
GROUP BY family_id) AS x
GROUP BY ct;
sqlQuery(connecton, " CORRECT SYNTAX ")
(This query is an example from book Data Manipulation with R, Phil Spector,
page 47)
Thanks for any help
Andrija
[[alternative HTML version deleted]]
2007 May 28
5
validates_uniqueness_of does not pass unit test
I am doing some very very basic unit testing. If I take away the
uniqueness validation, the tests pass. Could this be a bug in Edge
Rails?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to