2. PHPRunner General questions
  3. table column type text displays only as downloadable file in view
This topic is locked

table column type text displays only as downloadable file in view

 		3/28/2006 11:00:40 PM
PHPRunner General questions
B
 briguy1974 author

If I have a column in my table set to be type "TEXT" (or MEDIUMTEXT,LONGTEXT,BLOB,etc...) on the "VIEW" screen the column always shows up as a link (using file.gif) to a downloadable file (file.bin). I don't want this, I want to be able to view it as text. No matter how I set the field up in the "formatting" screen in PHPRunner, it always defaults to trying to make it into a binary file. Why is this? How do I get it to work to display just the plain old text. For example, if someone is suppossed to be entering a short essay, I want them to be able to view the text of the essay, not make it into a link to a downloadable file (file.bin).
Sergey Kornilov admin 3/29/2006

Hi,
you can change field type on text (not BLOB) and select empty line in View as dropdown box on the Formatting tab.
B
 		briguy1974 author 3/29/2006

I wish it was that easy, but your suggestion does not work for me.
MySQL table column has field "essay" which is set to by type "text".
On the "Formatting" screen, "View as" is set to blank in dropdown box, I re-build the project and I get same original result: the column always shows up as a link (using file.gif) to a downloadable file (file.bin).
Sergey Kornilov admin 3/29/2006

Please zip and send to support@xlinesoft.com a full set of generated PHP files, your database creation script with sample data.

I'll find what's wrong with your project running it on my test box.
Sergey Kornilov admin 3/29/2006

Due to utf8_bin collate TEXT fields are treated as BLOBs by MySQL. Here is the correct table creation script:

CREATE TABLE <table name>(

id tinyint(6) unsigned NOT NULL auto_increment,

... ,

essay text ,

PRIMARY KEY (id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;