Difference between revisions of "ENCODE()"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Function to return a string from a character string or memo field where qualifying characters have been replaced with their html entity equivalents  
 
Function to return a string from a character string or memo field where qualifying characters have been replaced with their html entity equivalents  
 
  
 
==Syntax==
 
==Syntax==
 
ENCODE(<expC> | <memofield>)
 
ENCODE(<expC> | <memofield>)
 
  
 
==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_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
 
  
 
==Description==
 
==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 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:
 
The following characters are converted to their HTML entity equivalents:
Line 25: Line 21:
 
* &lt;
 
* &lt;
 
* &gt;
 
* &gt;
 
  
 
==Example==
 
==Example==
Line 43: Line 38:
 
</pre>
 
</pre>
  
==Products==
 
Recital Server, Recital
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]

Revision as of 11:02, 10 February 2012

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_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>