headers
mother_taraza | 7 Mar 2007 10:00
Picon

Text Field Default Value

Hi:

I'm new to MetaL and wish to ask you guys something that has been
puzzling me over the last two days.

I'm using the lastest stable MySQL 5 release (comunity edition) +
Apache (with PHP -also the latest-). I've read the documentation quite
deeply but when trying to create the MetaNews sample database...
install.php warns about not being able to give a text column a default
value. Such thing it explicitly banned in the MySQL docs... so I'm
afraid MySQL 5 it is not compatible with MetaL... 
Could this be true?

I'm quite interested in using MetaStorage for my next personal
project(s) so I'll be glad to hear from you ASAP.

Regards.

------------------------ Yahoo! Groups Sponsor --------------------~--> 
Great things are happening at Yahoo! Groups.  See the new email design.
http://us.click.yahoo.com/lOt0.A/hOaOAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Permalink | Reply | 1 comment |
headers
Manuel Lemos | 7 Mar 2007 20:39
Picon
Favicon

Re: Text Field Default Value

Hello,

on 03/07/2007 06:00 AM mother_taraza said the following:
> Hi:
> 
> I'm new to MetaL and wish to ask you guys something that has been
> puzzling me over the last two days.
> 
> I'm using the lastest stable MySQL 5 release (comunity edition) +
> Apache (with PHP -also the latest-). I've read the documentation quite
> deeply but when trying to create the MetaNews sample database...
> install.php warns about not being able to give a text column a default
> value. Such thing it explicitly banned in the MySQL docs... so I'm
> afraid MySQL 5 it is not compatible with MetaL... 
> Could this be true?
> 
> I'm quite interested in using MetaStorage for my next personal
> project(s) so I'll be glad to hear from you ASAP.

If you do not specify a text variable length, it will attempt to create
a table with a TEXT field. TEXT fields are basically character LOBs, so
they may not have default values.

If you specify a variable length, it will create a VARCHAR field that
can have a default value.

--

-- 

Regards,
Manuel Lemos
(Continue reading)

Permalink | Reply | 0 comments |
headers
manfred.schreck | 20 Mar 2007 09:32
Picon

Custom Identifier - how does it work?

Hello,

I am using Metabase for a while, and I am happy with it.
Now I am in a situation, that I have to use a custom identifier. The 
scenario is that I use Metabase to synchronize data between existing 
db/php app and a newly created web application. The existing app 
cannot be changed, and a table containing user information has a 
login filed as the primary key. An id field cannot be added.

Now my question: How can I get Metabase to work with a field login 
insted of id? 

Here is my config for that class, that still uses id as the primary 
key:
<class>
  <id>login</id>
  <name>z_user</name>
  <variable>
    <name>login</name>
    <length>10</length>
    <type>text</type>
  </variable>
  <variable>
    <name>passwort</name>
    <type>text</type>
    <length>255</length>
  </variable>
  <variable>
    <name>email</name>
    <type>text</type>
(Continue reading)

Permalink | Reply | 3 comments |
headers
Manuel Lemos | 21 Mar 2007 03:23
Picon
Favicon

Re: Custom Identifier - how does it work?

Hello,

on 03/20/2007 05:32 AM manfred.schreck said the following:
> Hello,
> 
> I am using Metabase for a while, and I am happy with it.
> Now I am in a situation, that I have to use a custom identifier. The 
> scenario is that I use Metabase to synchronize data between existing 
> db/php app and a newly created web application. The existing app 
> cannot be changed, and a table containing user information has a 
> login filed as the primary key. An id field cannot be added.
> 
> Now my question: How can I get Metabase to work with a field login 
> insted of id? 

I am a bit confused with your references to Metabase.

Do you mean you have an application using Metabase and you want to
integrate with something that uses classes generated by Metastorage?

--

-- 

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/
(Continue reading)

Permalink | Reply | 2 comments |
headers
manfred.schreck | 21 Mar 2007 09:17
Picon

Re: Custom Identifier - how does it work?

--- In metal-dev <at> yahoogroups.com, Manuel Lemos <mlemos <at> ...> wrote:
>
> Hello,
> 
> on 03/20/2007 05:32 AM manfred.schreck said the following:
> > Hello,
> > 
> > I am using Metabase for a while, and I am happy with it.
> > Now I am in a situation, that I have to use a custom identifier. 
The 
> > scenario is that I use Metabase to synchronize data between 
existing 
> > db/php app and a newly created web application. The existing app 
> > cannot be changed, and a table containing user information has a 
> > login filed as the primary key. An id field cannot be added.
> > 
> > Now my question: How can I get Metabase to work with a field 
login 
> > insted of id? 
> 
> I am a bit confused with your references to Metabase.
> 
> Do you mean you have an application using Metabase and you want to
> integrate with something that uses classes generated by 
Metastorage?
> 
> 
> -- 
> 
> Regards,
(Continue reading)

Permalink | Reply | 1 comment |
headers
Manuel Lemos | 22 Mar 2007 01:44
Picon
Favicon

Re: Re: Custom Identifier - how does it work?

Hello,

on 03/21/2007 05:17 AM manfred.schreck said the following:
> --- In metal-dev <at> yahoogroups.com, Manuel Lemos <mlemos <at> ...> wrote:
>> Hello,
>>
>> on 03/20/2007 05:32 AM manfred.schreck said the following:
>>> Hello,
>>>
>>> I am using Metabase for a while, and I am happy with it.
>>> Now I am in a situation, that I have to use a custom identifier. 
> The 
>>> scenario is that I use Metabase to synchronize data between 
> existing 
>>> db/php app and a newly created web application. The existing app 
>>> cannot be changed, and a table containing user information has a 
>>> login filed as the primary key. An id field cannot be added.
>>>
>>> Now my question: How can I get Metabase to work with a field 
> login 
>>> insted of id? 
>> I am a bit confused with your references to Metabase.
>>
>> Do you mean you have an application using Metabase and you want to
>> integrate with something that uses classes generated by 
> Metastorage?

> sorry I meant Metastorage.

Currently Metastorage does not support defining custom object identifier
(Continue reading)

Permalink | Reply | 0 comments |

Gmane