1
Vote

Problems with MySQL and myAppSQL.SQL containing a semicolon not commiting a sql-statement

description

The configureMySQL.vbs Script breaks up the myAppSQL.sql file into statements using the following statement:
SetupQuery = split(sSQLScript, ";")
If there's a semicolon in a string, which is often the case when having html stored in the database (e.g. > or ä ) this results in an illegal SQL statement.
 
One possible workaround would be to change the split query to
split(sSQLScript, ";"& vbCrLf)
permitting the ; as commit-command only at the end of a line. But this raises problems if the line-end-character ist not CRLF or if there's a space or comment behind.

comments