preserveSingleQuotes fails

-

hi,
we moving our comparatively large cf5 extranet cf7, , running issue sql code worked fine in cf5, , used preservesinglequotes(), not being not-escaped in cf7 , failing. i've had resort

replace(preservesinglequotes(sql),"''","'")
which preservesinglequotes meant avoid. has else seen behavior in cf enterprise 7.0.2?

more details: it's been seen on both win server 2k3 , xp pro, accessing oracle 9i, , in @ least cases (although not all) sql stored in session variable.

coming late,

but, have lot of trouble "preservesinglequotes",

which did not have before v7, seems ?

 

example :

<cfset sql = "select * get_mou_f1 mou_ocean = '#form.ocean_mer#'">
<cfquery name="get_mou_f1"  dbtype="query">
    #preservesinglequotes(sql)#
</cfquery>

 

where form.ocean_mer contains single quote.

 

can confirme has see cf version ?

is there update implement cf v7.

 

thanks answer , cooperation.

pierre.



More discussions in Database Access


adobe

Comments

Post a Comment

Popular posts from this blog

CAN'T INSTALL MAMBELFISH 1.5 FROM DIRECTORY - Joomla! Forum - community, help and support

-
hi, i want install mambelfish 1.5 component in joomla! 1.0.4 stable [ sundial ] site, reason following error: failed create directory "/home/virtual/site13/fst/var/www/html/components/com_mambelfish/" i new joomla! , still not familiar it. great if build multilingual sites using joomla!. just clarify... media/ writeable administrator/components/ writeable components/ writeable images/stories/ writeable how install component? use  upload package file or use  install directory ? Board index Joomla! Older Version Support Joomla! 1.0 Extensions - 1.0.x Components
Read more

error: expected initializer before 'void'

-
whenever try compile code following error : 'error: expected initializer before 'void'' code: [select] #include <afmotor.h> af_dcmotor motor1(1, motor12_64khz); // create motor #1, 64khz pwm af_dcmotor motor2(2, motor12_64khz); // motor #2 void setup() {  serial.begin(9600);           // set serial library @ 9600 bps  serial.println("motor test!"); } void loop() { go(); backup(); halt(); }   void go() {  serial.println("all motors ahead - fast");    motor1.run(forward);  motor2.run(forward);  motor1.setspeed(255);  motor2.setspeed(255);  return; } void backup() {  serial.println("all motors backward - fast");  motor1.run(backward);  motor2.run(backward);  motor1.setspeed(255);  motor2.setspeed(255);  return; } void halt() {  uint8_t i;  for (i=255; i!=0; i--) ...
Read more

CPU load monitoring using GPIO and leds - Raspberry Pi Forums

-
Image
hello ! wrote today article on blog cpu load monitoring (using gpio , leds) on raspberry's. simple (written in little shell script), think can useful (for people want learn leds stuff on r. pi) there 5 leds turning on , off regarding cpu load: - cpu < 20%: 1 led - cpu < 40%: 2 leds - cpu < 60%: 3 leds - cpu < 80%: 4 leds - cpu < 90%: 5/5 leds - cpu >= 90%: 5 leds flashing here article: written in french, can watch youtube video , download code @ bottom of article. http://www.chteuchteu.com/2012/10/26/ra ... e-au-gpio/ if find errors in code, can post comment on article. ! up code enhancements ? raspberrypi
Read more