List Info

Thread: How do you restrict "position" field to int greater than zero?




How do you restrict "position" field to int greater than zero?
user name
2006-04-26 15:52:17
-- LAYOUT POSITIONING PER INDEX INTEGER VALUE
CREATE TABLE /*! IF NOT EXISTS */
customer_layout_positioning (
customer_id int not null,
layout_id int not null,
additional_layout_id int,
field_name varchar(125) not null,
position int not null,
primary key (customer_id, layout_id, position)
) /*! TYPE=MyISAM */;


This is a table that will determine HTML positioning of a
reference
field column value elsewhere. However, I want the
"position" field to
be of integer value that is nonzero (even greater than
zero). How do I
do that?

Thanx
Phil


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Php/MySQL Developement" group.
To post to this group, send email to
Php-Mysql-Developementgooglegroups.com
To unsubscribe from this group, send email to
Php-Mysql-Developement-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/Php-Mysql-Developement
-~----------~----~----~----~------~----~------~--~---

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )