Sorry for double posting. While this would be an ideal - it is clearly not
supported atm. But may be I can somehow emulate it by, say, initialising
table with the usual way and then doing something like
db.inet.var1.var2='rad....@inet' ?
If there is any coding needed - that's ok too, I can submit a patch (just
like before).
On Tue, Dec 22, 2009 at 7:15 PM, Alexey Nezhdanov <snak...@gmail.com> wrote:
> I do not know actually as I am not the Oracle expert (or even regular
> user). Will find out tomorrow.
> Suppose - I can't - can you give any clue how to make an alias in web2py?
> The ideal would be something like this:
>
> db.define_table('inet', internal_name='rad....@inet',
>
> Field('ip','string',length=16),
> migrate=False
> )
>
>
> On Tue, Dec 22, 2009 at 5:47 PM, mdipierro <mdipie...@cs.depaul.edu>wrote:
>
>> No. "." and "@" are not allowed in table names. Can you alias in
>> Orcale?
>>
>> On Dec 22, 12:15 am, Alexey Nezhdanov <snak...@gmail.com> wrote:
>> > Hello.
>> > I've googled this group for my problem, but didn't find the answer.
>> > It seems that problem was mentioned once [1] [2], but I do not know if
>> any
>> > solution was done.
>> >
>> > I need to connect to existing database so things like 'schemas are not
>> > portable' are not really acceptable - I should be able to connect,
>> period.
>> > What is worse - there are actually two servers - DB2 and Oracle. I do
>> not
>> > have direct access to DB2 database and have to connect through Oracle.
>> > So the sql query looks like this:
>> >
>> > SELECT ip FROM rad....@inet
>> >
>> > so here is scheme RAD, table NAS at the 'INET' DB2 database.
>> >
>> > web2py refuses me to do this:
>> >
>> > db.define_table('rad....@inet',
>> > Field('ip','string',length=16),
>> > migrate=False
>> > )
>> >
>> > So what should I do? Is there any way out?
>> > Thanks
>> >
>> > [1]
>> http://groups.google.com/group/web2py/search?group=web2py&q=oracle+ta...
>> > [2]
>> http://groups.google.com/group/web2py/browse_thread/thread/3c27af0533...
>> >
>> > --
>> > Regards
>> > Alexey Nezhdanov
>>
>> --
>> Regards
>>
> Alexey
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
