Hi,

I don't know why, but in a lot of records in my db the "isNew"-Field is empty ...maybe because of importing or whatever. But this field must have a value and now I look for a way to change the value of the empty fields to "No". I guess this could be done by mysql, but I don't know how ...

Kai
___________________________________________
http://www.westalgarve.de
http://www.portugalforum.org
http://www.portugal-links.de

Ya,

Had the same thing happen to me awhile back, this worked for me.

Use SQL Monitor

UPDATE lsql_Links SET isNew = 'No' WHERE isNew = '';

thx a lot, that did it!

Kai
___________________________________________
http://www.westalgarve.de
http://www.portugalforum.org
http://www.portugal-links.de