General information
Category:
Internet applications
Title:
Creating HTML Pages
I am attempting to create HTML pages for records that is entered into a database. I have a program that selects the records that I would like to display on a HTML page. The problem that I am incountering is a "String is too long to fit" error. I know that the problem is because I have memo fields displayed, but how can I get aroung this. I have included a few lines of my program so you can get an idea of how I am coding it.
*** CREATE PRODUCT INDEX BY CATEGORY
_PEJECT = 'NONE'
_PLENGTH=32676
_PLINENO= 1
l_break = SPACE(25)
GO TOP
SELECT newsinfo
Save_code = ' '
SCAN
IF mag_id='PT' AND current='X'
SELECT newsinfo
IF Save_code != alltrim(news_type)
filename = alltrim(news_type)+'.html'
Save_code = alltrim(news_type)
SET DEVICE TO FILE 'C:\Websites\' + filename
_PLINENO = 1
****newsinfo.story is the memo field****
@_PLINENO,0 SAY ALLTRIM(newsinfo.story)
ENDIF
ENDSCAN
_PEJECT = 'AFTER'
SET DEVICE TO SCREEN
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only