Difference between revisions of "ENCODE()"

From Lianjapedia
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[ASC()]], [[AT()]], [[ATNEXT()]], [[CHR()]], [[CHRTRAN()]], [[DECODE()]], [[HTML_ENTITIES()]], [[HTML_ENTITY_DECODE()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
+
[[ASC()]], [[AT()]], [[ATNEXT()]], [[CHR()]], [[CHRTRAN()]], [[DECODE()]], [[HTML_ENTITIES()]], [[HTML_ENTITY_DECODE()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_ESCAPE()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
  
 
==Description==
 
==Description==
Line 40: Line 40:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:String Data]]
 
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]
 
[[Category:Lianja VFP Extensions]]
 
[[Category:Lianja VFP Extensions]]
 
[[Category:VFP Function Extensions]]
 
[[Category:VFP Function Extensions]]

Latest revision as of 11:48, 1 December 2014

Purpose

Function to return a string from a character string or memo field where qualifying characters have been replaced with their html entity equivalents

Syntax

ENCODE(<expC> | <memofield>)

See Also

ASC(), AT(), ATNEXT(), CHR(), CHRTRAN(), DECODE(), HTML_ENTITIES(), HTML_ENTITY_DECODE(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), STR(), STR_ESCAPE(), STR_REPLACE(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The ENCODE() function will search <expC> or <memofield> and return a string where qualifying characters have been replaced with their html entity equivalents.

The following characters are converted to their HTML entity equivalents:

  • Tab (chr(9))
  • Line feed (chr(10))
  • Carriage return (chr(13))
  • "
  • &
  • '
  • <
  • >

Example

<!-- dispmemo.rsp -->
<html>
<body>
<%
open database southwind
use example
goto 1
 ? "<pre>" + encode(notes) + "</pre>"
close databases
%>
</body>
</html>