View source for RDO REAL ESCAPE STRING()

==Purpose==
Escape special characters in a string for use in an SQL statement


==Syntax==
RDO_REAL_ESCAPE_STRING(<expC> [, <expN>])

MYSQL_REAL_ESCAPE_STRING(<expC> [, <expN>])


==See Also==
[[RDO_AFFECTED_ROWS()]], [[RDO_CLOSE()]], [[RDO_CONNECT()]], [[RDO_DATA_SEEK()]], [[RDO_ERRNO()]], [[RDO_ERROR()]], [[RDO_EXEC()]], [[RDO_FETCH_ARRAY()]], [[RDO_FETCH_ASSOC()]], [[RDO_FETCH_FIELD()]], [[RDO_FETCH_LENGTHS()]], [[RDO_FETCH_OBJECT()]], [[RDO_FETCH_ROW()]], [[RDO_FIELD_FLAGS()]], [[RDO_FIELD_LEN()]], [[RDO_FIELD_NAME()]], [[RDO_FIELD_SEEK()]], [[RDO_FIELD_TABLE()]], [[RDO_FIELD_TYPE()]], [[RDO_FREE_OBJECT()]], [[RDO_FREE_RESULT()]], [[RDO_GET_CLIENT_INFO()]], [[RDO_GET_HOST_INFO()]], [[RDO_INFO()]], [[RDO_LIST_DBS()]], [[RDO_NUM_FIELDS()]], [[RDO_NUM_ROWS()]], [[RDO_PING()]], [[RDO_QUERY()]], [[RDO_RESULT()]], [[RDO_SELECT_DB()]], [[RDO_STAT()]], [[RDO_THREAD_ID()]], [[RDO_UNBUFFERED_QUERY()]]


==Description==
The RDO_REAL_ESCAPE_STRING() function is used to escape special characters in a string for use in an SQL statement.


{| class="wikitable"
!Keywords||Description
|-
|<expC>||Query string
|-
|<expN>||Connection reference from [[RDO_CONNECT()]]
|-
|}


==Example==
<code lang="recital">
conn = rdo_connect("recital", "localhost", "?", "?","southwind")
city_name = "Xi'an"
res = rdo_query("SELECT * FROM customers WHERE city = '" + ;
      rdo_real_escape_string(city_name,conn) + "'")
rdo_close(conn)
</code>


==Products==
Recital, Recital Server
[[Category:Documentation]]
[[Category:Functions]]
[[Category:SQL]]
[[Category:Remote Data Connectivity]]
[[Category:Remote Data Connectivity Functions]]