headertagscontroller v2 , help please

[Guest]

Hi,

 

Can't seem to get past the sable changes bit.

 

products_head_title_tag varchar 50

 

goes in fine, but the next 2:-

 

products_head_desc_tag longtext 300

products_head_keywords_tag longtext 300

 

both come up with :-

 

ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT (300) not null

MySQL said: You have an error in your SQL syntax near '(300) not null ' at line 1

 

Any idea what I'm doing wrong?

 

regards

 

len

[Kent C]

Ref: http://www.mysql.com/doc/en/BLOB.html

 

I remember that I also had problems since MySQL-Front wouldn't let me do this. I eventually created the 2 fields as

lontext not null

 

I did not find any references that stated that I could not specify the field length.

 

HTH

[Guest]

hi kent,

thanks a lot, will give it a try

 

regards

 

len