Juha,
Can the IP be stored as a character field rather than as an int?
Paul
On Thu, 17 Feb 2005 23:46:08 +0200, Juha Heinanen jh@lohi.tutpro.com wrote:
Richard writes:
When you create the table field, you can use attribute "unsigned".
sure and that is what gw table is using (ser_mysql.sh):
# # Table structure for table 'gw' #
CREATE TABLE gw ( gw_name VARCHAR(128) NOT NULL, ip_addr INT UNSIGNED NOT NULL, port SMALLINT UNSIGNED, grp_id INT UNSIGNED NOT NULL, PRIMARY KEY (gw_name), KEY (grp_id) ) $TABLE_TYPE;
the problem is that
VAL_INT(ROW_VALUES(row)
for ip_addr field produces wrong value if the first bit of the value in db is 1.
-- juha
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers