5 posts by 3 authors in: Forums > CMS Builder
Last Post: April 13, 2010   (RSS)

Hi there, having probs with the 'where' part of this statement:

$numType = $yacht_typeRecord['url'];
list($yachtsRecords, $yachtsMetaData) = getRecords(array(
'tableName' => 'yachts',
'where' => "type LIKE '$numType'",
'useSeoUrls' => true,
'allowSearch' => false,
'debugSql' =>'true',
));


The record 'type' has multiple values seperated by tabs such as:
" motor catamaran "

any pointers?

Many thanks

Re: [aquaman] Syntax for 'where'

By Jason - April 13, 2010

Hi,

Try changing your first line to this:
$numType="%\t".$yacht_typeRecord['url']."\t%";

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Syntax for 'where'

That worked great, thanks :)

Re: [InHouse] Syntax for 'where'

Thanks for the tips, really helps to see working examples - still getting a handle on the correct syntax to use.