Welcome to RCF - WHF

Glenn I · Apr 22, 2005

I think the code is far too long. I may just have to split it over a couple pages or find another way to display it. I don't think there is a problem with the html because it displays perfect at http://www.theaussieaviator.net/codes.htm

You could probably get the code by going to view --> Source

Nightrider · Sep 25, 2004

I compressed the code and got it to display down to the S section in a new Airport Codes page:

http://theaussieaviator.net/template.php?page=9&sid=5be92964cc45018418 ca6b16051686a9

There definitely seems to be a size restraint and it appears to be in the database...

munky2

Glenn I · Apr 22, 2005

Yeah noticed that...a pain in the butt. I tried something but only got down to the E's lol

Any idea where the restraint is? If it's too hard to do I won't worry about it.

Nightrider · Sep 25, 2004

There might be a limit to the number of characters that can be stored in a Text field in MySql. There should be BLOB (Binary Large Objects) field types available too that could store even more. I just created a Test table using the blob field instead of the text field and I was able to store the entire page. I imagine that if you convert your page_content field to a blob type, it would work for you too...

headbang

Glenn I · Apr 22, 2005

yeah ok...and how do I do that?

Nightrider · Sep 25, 2004

You should be able to go into phpMyAdmin and change the field type. I could quickly do it for in MySql-Front, but I can't connect to your database any more. And since I can't connect to your FTP Server anymore, I can't update the MySql-Front settings so I could do it...

I am heading to bed, but you should be able to go into phpMyAdmin and modify the table structure. Just change the text type to blob. You could even try MediumBlob and LongBlob. But before you do anything, make sure you have a good Database backup...

munky2

Glenn I · Apr 22, 2005

Take a look http://www.theaussieaviator.net/template.php?page=7&sid=8f9e8ec933e6b9 5eb835dddc534ca7ee

Now I can go public with it. I learnt a new trick from the master prayer

Thanks mate blob8

rb2d2 · Sep 25, 2004

That's beautiful, Aussie, just beautiful. You did good, NR will be so happy for you!

sunny

Nightrider · Sep 25, 2004

That's awesome news. I am surprised that the text field type has a limit to what it will store. I thought the Text type was very similar to the Blob type. Apparently not...

Congratulations Glenn!!!

Applause

Glenn I · Apr 22, 2005

I went with blob at first but that didn't help so I jumped it up to longblob and it worked.

Thanks again