#49 ac_store.inc and MS-SQL7

[Jarosław Zabiełło]

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'",

[Anonymous]

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?

[Anonymous]

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?

[Nobody/Anonymous]

Logged In: NO

Check the date of my first comment: 2001-10-24. The 'val'
variable was varchar at that time.