Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating HTML Pages
Message
From
26/09/2000 09:14:04
Julie Ball
Gardner Publications, Inc.
Cincinnati, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Creating HTML Pages
Miscellaneous
Thread ID:
00420851
Message ID:
00420851
Views:
56
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
Map
View

Click here to load this message in the networking platform