Escape sql
From Hercules Wiki
Contents |
Syntax
- escape_sql(<value>);
Description
Converts the value to a string and escapes special characters so that it's safe to use in query_sql(). Returns the escaped form of the given value.
Examples
set .@str$, "John's Laptop"; set .@esc_str$, escape_sql(.@name$); // Escaped string: John\'s Laptop