Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Using #id# on SQL sentence

Locked
esstein
Posts: 17
Joined: Tue Mar 08, 2011 12:45 am

Using #id# on SQL sentence

Unread post by esstein »

Hi,

When I use the Apostrophe on the SQL sentence, the value after save changes like this:
select '#id#'
... after save the form shows:
select \'#id#\'
What is happening?

Thnaks,
Evandro
Last edited by esstein on Wed Jun 06, 2012 7:30 pm, edited 1 time in total.
zazzium
Posts: 84
Joined: Mon Jul 04, 2011 12:52 am

Re: Using #id# on SQL sentence

Unread post by zazzium »

Hi,

Turn off "Magich quates" in php settings.
esstein
Posts: 17
Joined: Tue Mar 08, 2011 12:45 am

Re: Using #id# on SQL sentence

Unread post by esstein »

zazzium wrote:Hi,

Turn off "Magich quates" in php settings.
Thanks zazzium, it help me a lot.

I added the command bellow on /public_html/.htaccess and nuBuilder is working ok:

Code: Select all

php_flag magic_quotes_gpc Off
Evandro
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Using #id# on SQL sentence

Unread post by admin »

.
Locked