<![CDATA[FrontAccounting forum — Mysql storing quotes as ']]> https://frontaccounting.com/punbb/viewtopic.php?id=4536 Tue, 19 Nov 2013 16:56:13 +0000 PunBB <![CDATA[Re: Mysql storing quotes as ']]> https://frontaccounting.com/punbb/viewtopic.php?pid=18477#p18477 i dont see what's wrong.
&# 039;  stands for an apostrophe, it's normal for sql query to use apostrophe.
executed in php your query will provide something like :
INSERT INTO 2_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date, order_type, ship_via, deliver_to, delivery_address, contact_phone, freight_cost, from_stk_loc, delivery_date, payment_terms, total) VALUES ('50','0','2', '30','3', '','auto','','2013-11-19', '1', '1','Ventas Al Contado','Km. 15.5 Carretera a Masaya.', '55555555', '0', 'DEF', '2013-11-19','5','2300').
as long as there is no error in the execution  of your erp, that should be fine.
you'r talking about x_sql_trail, it's used to store all executed queries, for audit or tracking purposes. if you see it as an issue, you can always modify  the function db_query($sql, $err_msg = null) (connect_db.php) to force using an apostrophe instead of   &# 039;

]]> Tue, 19 Nov 2013 16:56:13 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=18477#p18477 <![CDATA[Mysql storing quotes as ']]> https://frontaccounting.com/punbb/viewtopic.php?pid=18474#p18474 Hello. I apologize if this is not the correct place to ask this, but why are my SQL queries being saved inside X_SQL_TRAIL tables with the single quotes represented as &#039; For example:

INSERT INTO 2_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
        order_type, ship_via, deliver_to, delivery_address, contact_phone,
        freight_cost, from_stk_loc, delivery_date, payment_terms, total)
        VALUES (&#039;50&#039;,&#039;0&#039;,&#039;2&#039;, &#039;30&#039;,&#039;3&#039;, &#039;&#039;,&#039;auto&#039;,&#039;&#039;,&#039;2013-11-19&#039;, &#039;1&#039;, &#039;1&#039;,&#039;Ventas Al Contado&#039;,&#039;Km. 15.5 Carretera a Masaya.&#039;, &#039;55555555&#039;, &#039;0&#039;, &#039;DEF&#039;, &#039;2013-11-19&#039;,&#039;5&#039;,&#039;2300&#039;)

This is very annoying. Is there anyway to fix this? Thank you. I am using version 2.3.18.

Bosco

]]> Tue, 19 Nov 2013 00:49:13 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=18474#p18474