[solved] SQL / ADODB lite Help for Dummies (Dummy actually!)

[chrisbt]

When I put a '<' less than operator in my where clause it gets converted to a '<' before the query is executed.

Code: Select all

$sql = "SELECT p.id FROM cms_module_products AS p WHERE p.weight<'100'";
$res = $db->GetCol($sql);

The debug output shows:

Code: Select all

SELECT p.id FROM cms_module_products AS p WHERE p.weight<'100'

I'm sure there is a nice easy way to solve this I just can't find it.

Thanks. Chris.

[Jos]

You mean you see this in the cmsms debug mode?

I'm pretty sure that it's just a display issue. The query will be executed with <

The GetCol function I'm not familiar with. Are you sure it is a adodb lite command?

I know these are:
$db->Execute($sql, [$inputarray])
$db->GetAll($sql)
$db->GetArray($sql)

[chrisbt]

Thanks Jos. Yes the output in was in CMSMS debug mode.

GetCol did seem to work even though it's not listed in the adodb lite functions. I'll swap to one of the other functions to try to get my query functioning as required.