SQL Search Question

Thu, 10 Mar 2011 15:18:28 -0800

I need to use the SQL "where" statement to filter results from 2 different fields (from the same table). What I'm trying to do is check all the records of a certain table and only return results that match either field. I tried using an "or" statement, however that just renders the search useless. I can successfully narrow the results searching only 1 field, but not when I add the OR statement where I think it should go.

So, I have a multi-record table, called WEBINARS which contains many fields. I want the page to search the PRESENTER field AND CO_PRESENTER field (both are simple lists) and only display records that match a single presenter name. Here is the code I tried, which does not work.

    list($webinarsRecords, $webinarsMetaData) = getRecords(array(
    'tableName'   => 'webinars',
    'allowSearch' => '0',
    'where' => 'Presenter="name1"' or 'Co_Presenter="name1"',
  ));

Any thoughts? Again, I want to search 2 fields for the same value and only return the matching results.

Thanks in advance!

Missing Records after Upgrade

Wed, 29 Sep 2010 14:13:02 -0700

So I just got around to upgrading from CMS Builder v1.36 to v2.06. The upgrade went VERY smooth until I went to the back end to add a few FAQs. When i reached the FAQ page in the admin section, the system tells me there are no records in that section. I know the records are there as they are still displaying on the front end (public) site of the side, and when i go to the SECTION EDITORS tab, it lists the number of records correctly as 6, however it simply will not show them to me on the back end.

I did some more checking, and the same is true for ALL of my multi-record sections in the database; meaning the admin section doesn't show them, but the front end displays just fine.

Any ideas on this? I'm afraid to do anything to the CMS system until I get this resolved as there is information in those records I can't easily replicate.

Thanks!

Scott Friend

Integration with Trellis Desk

Fri, 27 Mar 2009 13:06:07 -0700

I'm using a free support desk system called Trellis Desk in my site. On the Trellis desk pages, I'm still using CMS builder to control the main menu at the top of the screen as well as an information block in my header, so I have to keep the CMS Builder code in those pages. My problem is that no matter where I place the CMS code on the index.php page, it does not allow CMS Builder to display the content. Trellis works fine, but it's like CMS is just being ignored.

Here is the code for my entire Trellis Desk index.php page. Perhaps someone is familiar with this?

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

  
  require_once "/hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php";

  list($latest_newsRecords, $latest_newsMetaData) = getRecords(array(
    'tableName'   => 'latest_news',
    'where'       => whereRecordNumberInUrl(1),
    'loadUploads' => '0',
    'limit'       => '1',
  ));
  $latest_newsRecord = @$latest_newsRecords[0]; // get first record
  
  list($main_menuRecords, $main_menuMetaData) = getRecords(array(
    'tableName'   => 'main_menu',
    'where'       => whereRecordNumberInUrl(1),
    'loadUploads' => '0',
    'limit'       => '1',
  ));
  $main_menuRecord = @$main_menuRecords[0]; // get first record
  
  list($text_barRecords, $text_barMetaData) = getRecords(array(
    'tableName'   => 'text_bar',
    'where'       => whereRecordNumberInUrl(1),
    'loadUploads' => '0',
    'limit'       => '1',
  ));
  $text_barRecord = @$text_barRecords[0]; // get first record
  
  list($website_themeRecords, $website_themeMetaData) = getRecords(array(
    'tableName'   => 'website_theme',
    'where'       => whereRecordNumberInUrl(1),
    'loadUploads' => '0',
    'limit'       => '1',
  ));
  $website_themeRecord = @$website_themeRecords[0]; // get first record


#=============================
# Safe and Secure
#=============================

ini_set( 'register_globals', 0 );

if ( function_exists('date_default_timezone_get') )
{
     date_default_timezone_set( date_default_timezone_get() );
}

if ( @ini_get( 'register_globals' ) )
{
	while ( list( $key, $value ) = each( $_REQUEST ) )
	{
		unset( $$key );
	}
}

#=============================
# Itsy Bitsy Stuff
#=============================

define( 'IN_HD' , 1 );

#ini_set( 'display_errors', 1 );
error_reporting( E_ERROR | E_WARNING | E_PARSE );

#=============================
# Define Our Paths
#=============================

define( "HD_PATH", "./" );
define( 'HD_INC', HD_PATH ."includes/" );
define( 'HD_SRC', HD_PATH ."sources/" );
define( 'HD_SKIN', HD_PATH ."skin/" );

define( 'HD_DEBUG', false );

#=============================
# Main Class
#=============================

require_once HD_INC . "ifthd.php";
$ifthd = new ifthd();

#=============================
# Are We Banned?
#=============================

$banned_users = explode( "\r\n", strtolower( $ifthd->core->cache['config']['ban_names'] ) );
$banned_emails = explode( "\r\n", strtolower( $ifthd->core->cache['config']['ban_emails'] ) );
$banned_ips = explode( "\r\n", strtolower( $ifthd->core->cache['config']['ban_ips'] ) );

if ( in_array( strtolower( $ifthd->member['name'] ), $banned_users ) || ( $ifthd->member['email'] && in_array( strtolower( $ifthd->member['email'] ), $banned_emails ) ) || in_array( strtolower( $ifthd->input['ip_address'] ), $banned_ips ) )
{
	$ifthd->skin->error('no_perm_banned');
}

#=============================
# Other Junk
#=============================

$choice = array(
				'article'		=> 'article',
				'kb'			=> 'article',
				'myaccount'		=> 'account',
				'feed'			=> 'feed',
				'portal'		=> 'portal',
				'pages'			=> 'pages',
				'news'			=> 'news',
				'register'		=> 'register',
				'tickets'		=> 'tickets',
			   );

#=============================
# Require & Run
#=============================

$required = $choice[ $ifthd->input['act'] ];

if ( ! isset( $required ) )
{
	$required = 'portal';
}

require_once HD_SRC . $required .".php";

$run = new $required();
$run->ifthd =& $ifthd;

$run->auto_run();

?>

Re: [Dave] SQL Error

Fri, 27 Mar 2009 12:49:51 -0700

Yep, that did it too. I feel better running it like that instead of just randomly removing lines of code.

Thanks again! :-)

Re: [ross] SQL Error

Thu, 26 Mar 2009 11:43:53 -0700

Ross,

Thanks for the assistance. Your right on in the fact that this is a "details" page. I keep my site very simple and as a result ALL of the content pages on my site are simple detail pages. What I ended up doing was making a duplicate of the "viewer_functions.php" file gave it a unique name. On all the pages that ONLY rely on CMS Builder to pull it's content, I reference the original file. On all the pages that interact with an additional PHP application to pull both content and database functions I reference the duplicate file. The only difference between the two files is that in the duplicate I removed the offending code, which were lines 409 and 410 in viewer_functions.php which were calling the URLENCODE issues you were speaking of. My basis on doing this was that since my site does not need to encode the URL's through CMS Bulder when it's combined with my third part PHP apps, there would be no need to even allow it to do so on those pages.

So far everything is working OK. All the pages (both the ones using the original file and the duplicate file) are stable and are not throwing errors. I'm still in the development stages of the site, so I may infact find something that this doesn't "jive" with my adjustement.

Can you think of any downsides to what I have done?

SQL Error

Wed, 25 Mar 2009 13:15:34 -0700

I just started using CMS Builder, and it's working fine with most of my pages. However, a few areas of my site use additional PHP applications (aMember Subscription System, Trellis Helpdesk Sotware, etc.) and that seems to throw my systems though a loop. I'm getting the following error when i try to order a subscription through my aMember software. If I remove the references to the CMS Builder software, the site works fine, so I know its not aMember. THe best I can see it seems to be a conflict between the Trellis Desk and aMember and how they call their PHP database. ANY help would be greatly appreciated.

WARNING:

I also receive this error ABOVE my page layout in text format:

WARNING: urlencode() expects parameter 1 to be string, array given in line 409 of file viewer_functions.php
Notice: Undefined property: db_mysql::$debug_sql in /hsphere/local/home/c163167/eclipsewebinars.com/login/plugins/db/mysql/mysql.inc.php on line 3089 Strict Standards: Only variables should be assigned by reference in /hsphere/local/home/c163167/eclipsewebinars.com/login/common.inc.php on line 284 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 409 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 410 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 409 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 410 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 409 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 410 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 409 Warning: urlencode() expects parameter 1 to be string, array given in /hsphere/local/home/c163167/eclipsewebinars.com/cms/lib/viewer_functions.php on line 410

Most of the lines in the error above are from aMember UNTIL you get to the "WARNING" message in the second to last line. Again, if I remove the CMS Builder scripts from the page, the error goes away and the site works fine (minus my content of course!).

Thanks again!