Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating HTML Pages
Message
 
 
To
26/09/2000 09:14:04
Julie Ball
Gardner Publications, Inc.
Cincinnati, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00420851
Message ID:
00421303
Views:
13
Julie,

TEXTMERGE is much better at doing this kind of stuff than dBaseII style printing commands. You can also use the DO (_genhtml) program to quickly convert a cursor to an HTML file.

>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
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform