Do you know how to escape apostrophes in eA-scripts?
For example:
query_sql("SELECT `id` FROM `item_db` WHERE `name_japanese` = '"+.@ITEM$+"'",.@ID);
if ( !.@ID ) {
mes "There is no such item.";
close;
}
If .@ITEM is "Gentleman's Pipe" - I've got errors in MySQL:
: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Pipe'' at line 1
Question
milky_milk
Hello there.
Do you know how to escape apostrophes in eA-scripts?
For example:
If .@ITEM is "Gentleman's Pipe" - I've got errors in MySQL:
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.