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

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

Bugs item #474478, was opened at 2001-10-24 09:24
You can respond by visiting: 
https://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'",


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

>Comment By: Chris Johnson (chaska)
Date: 2002-07-03 15:25

Message:
Logged In: YES 
user_id=279065

What's he saying?  val is defined as TEXT, as far as I can 
tell.  Why would one use LIKE with val, but not with the 
other string variables, changed, sid and name?

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

Comment By: Chris Johnson (chaska)
Date: 2002-07-03 15:25

Message:
Logged In: YES 
user_id=279065

What's he saying?  val is defined as TEXT, as far as I can 
tell.  Why would one use LIKE with val, but not with the 
other string variables, changed, sid and name?

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

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