On Aug 7, 2006, at 4:53 PM, Jonathan Vanasco wrote:
> query=> [
> first_name=> { lower=> 'john' },
> last_name=> { upper=> 'DOE' },
> ]
just to add-- i know i can approximate that with an ILIKE and then
parse the result set. i'm looking to specify the c
is there any way to do:
query=> [
first_name=> { lower=> 'john' },
last_name=> { upper=> 'DOE' },
]
becomes:
SELECT t1.name FROM useraccount t1 WHERE lower(t1.first_name)= ?
AND upper(t1.last_name)= ?
--
On 8/7/06 4:27 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 8/7/06 4:14 PM, Sean Davis wrote:
>> This is what I thought of first, but the user of a "mirror" or "local"
>> database will want to set up his/her username/password, hostname, etc. So,
>> I probably need finer, more flexible c
On 8/7/06 4:14 PM, Sean Davis wrote:
> This is what I thought of first, but the user of a "mirror" or "local"
> database will want to set up his/her username/password, hostname, etc. So,
> I probably need finer, more flexible control than this; the level of the
> Rose::DB subclass seems the right
On 8/7/06 4:04 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 8/7/06 3:40 PM, Sean Davis wrote:
>> On 8/7/06 1:31 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
>>> I am trying to write some code to access a publicly available data source.
>>> It consists of a few dozen different databases (m
On 8/7/06 3:40 PM, Sean Davis wrote:
> On 8/7/06 1:31 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
>> I am trying to write some code to access a publicly available data source.
>> It consists of a few dozen different databases (mysql), all with the same
>> table structure, pretty much. I would also
On 8/7/06 1:31 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
> I am trying to write some code to access a publicly available data source.
> It consists of a few dozen different databases (mysql), all with the same
> table structure, pretty much. I would also like to allow users to query a
> loca
I am trying to write some code to access a publicly available data source.
It consists of a few dozen different databases (mysql), all with the same
table structure, pretty much. I would also like to allow users to query a
local mirror of the data source, as well. Therefore, I would like to make
