Waspman
Posts: 948
|
Posted: 11/17/2013, 3:53 AM |
|
Anyone know why the LIKE doesn't work?
CCDLookup("field","table","id=".CCToSQL(CCGetFromGet("id", ""),ccsText)." and yearrange LIKE %".CCToSQL($pyear2,ccsText)."%", $db1);
Ta.
_________________
http://www.waspmedia.co.uk |
|
|
Lucius
Posts: 220
|
Posted: 11/17/2013, 9:20 AM |
|
I would guess that CCToSQL adds quotes, so your query WHERE looks like:
Quote :and yearrange LIKE %'your-var'%
Try adding the %'s inside ToSQL function:
CCDLookup("field","table","id=".CCToSQL(CCGetFromGet("id", ""),ccsText)." and yearrange LIKE ".CCToSQL("%".$pyear2."%",ccsText), $db1);
|
|
|
|