[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

>