Monthly Archives: November 2012

Using Fading Div tag messages to show ajax call results without requiring click.

We use xajax calls to server functions to update databases or insert records from a web page. Usually when they finish they return javascript to close the dialog or div tag and show an alert — this can be maddening … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Security Invoker for MYSQL views

When moving mysql databases between machines. It is best if all stored procedures, functions, and views need to have the following line after their create statement: DEFINER=CURRENT_USER SQL SECURITY INVOKER Example: CREATE OR REPLACE DEFINER=CURRENT_USER SQL SECURITY INVOKER VIEW MYVIEW … Continue reading

Posted in Uncategorized | Leave a comment