[Phplib-trackers] [ phplib-Bugs-474478 ] ac_store.inc and MS-SQL7

[<no...@so...>]

Bugs item #474478, was opened at 2001-10-24 07:24
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403611&aid=474478&group_id=31885

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Jaros³aw Zabie³³o (zbiru)
Assigned to: Nobody/Anonymous (nobody)
Summary: ac_store.inc and MS-SQL7

Initial Comment:
I changed "val='%s'" to "val like '%'" because MSSQL7 
cannot use variable='values' as a part of WHERE 
subquery. val should be also defined as TEXT, not 
VARCHAR(xxx). Open file ac.store.inc and change

old:

$squery = sprintf("select count(*) from %s where val 
= '%s' and changed='%s' and sid='%s' and name='%s'",

new:

$squery = sprintf("select count(*) from %s where val 
like '%s' and changed='%s' and sid='%s' and name='%s'",


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403611&aid=474478&group_id=31885