HOW TO improve calendar's stored procedures?

Talk and info about common issues and learn how to do almost anything with ApPHP Calendar

Moderator: alexandrleonenko

administrator
Site Admin
Site Admin
Posts: 5997
Joined: Jan 7th, '09, 23:18
Contact:

HOW TO improve calendar's stored procedures?

Postby administrator » May 17th, '11, 14:07

You may change Calendar's stored procedures to handle more special characters, like apostrophes and etc.
To do this you have to add more code in these procedures.

For examples:

Code: Select all

IF INSTR( x , ''' )
THEN SET TextString = REPLACE(TextString, ''','"') ;
END IF ;

IF INSTR( x , '&' )
THEN SET TextString = REPLACE(TextString, '&','&') ;
END IF ;

IF INSTR( x , '<' )
THEN SET TextString = REPLACE(TextString, '&lt;','<') ;
END IF ;

IF INSTR( x , '&gt;' )
THEN SET TextString = REPLACE(TextString, '&gt;','>') ;
END IF ;

Return to “ApPHP Calendar {HOW TO}”