escape_sql vise versa?

[Lil Troll]

Is there opposite of escape_sql? Like for example retrieve_sql so that i can minimize the use of variables like permanent ones. I cant figure out myself. (pity me noob)

Escape sql
Syntax:

escape_sql(<value>)
Description:

Converts the value to a string and escapes special characters so that it is 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(.@str$);	// Escaped string: John\'s Laptop

Or should i be sticking in variables because sometimes sql ingame is often slow.

Edited August 31, 2013 by Lil Troll

[GmOcean]

Escape SQL, doesn't put anything into SQL, it just enables us, to use Special Characters in our SQL Strings. What your looking for is:  query_sql"SELECT Blah blah blah",@var;

 

Special Characters: Anything not a Letter or a Number.

[Lil Troll]

Escape SQL, doesn't put anything into SQL, it just enables us, to use Special Characters in our SQL Strings. What your looking for is:  query_sql"SELECT Blah blah blah",@var;

 

Special Characters: Anything not a Letter or a Number.

Thanks sir! Im now enlightened I thougt there was a simplier version of select sql.