[geeklog-devel] MS SQL Upgrade

[Randy Kolenko]

We'll have to replace the mysql_real_escape_string function with an
mssql equivalent.
Since there is none, we'll have to revert to **shudder** addslashes
dependent upon magic quotes being on/off.




> -----Original Message-----
> From: Michael Jervis [mailto:mjervis at gmail.com] 
> Sent: Friday, May 23, 2008 8:07 AM
> To: Geeklog Development
> Subject: [geeklog-devel] MS SQL Upgrade
> 
> 
> Just got keys and indicies to sort for the polls plugin 
> upgrade now, plus this:
> 
> Warning: mysql_real_escape_string()
> [function.mysql-real-escape-string]: Access denied for user 
> 'ODBC'@'localhost' (using password: NO) in 
> O:\development\geeklog\glsql\sql\updates\mssql_1.4.1_to_1.5.0.
> php on line 452
> 
>     $move_sql = "SELECT pid, topic FROM {$_TABLES['polltopics']}";
>     $move_rst = DB_query ($move_sql);
>     $count_move = DB_numRows($move_rst);
>     for ($i = 0; $i < $count_move; $i++) {
>         $A = DB_fetchArray($move_rst);
>         $A[1] = mysql_real_escape_string($A[1]); <- HERE
> ****************************
>         $P_SQL[] = "INSERT INTO {$_TABLES['pollquestions']} (pid,
> question) VALUES ('{$A[0]}','{$A[1]}');";
>     }
> 
> Suggestions?
> 
> -- 
> Michael Jervis
> mjervis at gmail.com 
> 504B03041400000008008F846431E3543A820800000006000000060000007765
> 62676F642B4F4D4ACF4F0100504B010214001400000008008F846431E3543A82
> 0800000006000000060000000000000000002000000000000000776562676F64
> 504B05060000000001000100340000002C0000000000
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net 
> http://eight.pairlist.net/mailman/listinfo/geeklog-devel
>