Display records that start with a number

Mon, 18 Sep 2017 11:33:19 -0700

So others may benefit, here is what I ended up with that works:

in the dropdown:

Select the First letter of the Business Name 0-9 A B C

and changes to viewer:

$regex = $_GET['alphasearch']; // load records from 'categories' list($categoriesRecords, $categoriesMetaData) = getRecords(array( 'tableName' => 'categories', 'perPage' => '5', 'loadUploads' => false, 'allowSearch' => true, 'where' => "Bus_name REGEXP '^".$regex.".*' OR Bus_name LIKE '".$regex."'", 'orderBy' => 'Bus_name',

Display records that start with a number

Mon, 18 Sep 2017 09:40:16 -0700

I have a dropdown:

Select the First letter of the Business Name 0-9 A B C

snippet from ialphalist.php

list($categoriesRecords, $categoriesMetaData) = getRecords(array( 'tableName' => 'categories', 'perPage' => '5', 'loadUploads' => false, 'allowSearch' => true, 'where' => "Bus_name LIKE '$_GET[alphasearch]'", 'orderBy' => 'Bus_name',

The letters display results as expected, I am trying to get if the first character is a number to work. I thought that using the "REGEXP" statement was supposed to work, maybe I have it formatted wrong? What do I need to change to get this to work?

Formatting of 'where' clause

Fri, 08 Sep 2017 11:00:32 -0700

I am trying to get the formatting right for my where clause. Here is what I am doing:

I have a dropdown menu populated by the database. I make a selection from the dropdown and "GET" that value to another file.

The second file is the experimental multi record viewer. I am trying to add a where clause to show only records with the same Bus_categories:

$Bus_categories = $_GET['Bus_categories']; list($categoriesRecords, $categoriesMetaData) = getRecordsAPI(array( 'tableName' => 'categories', 'perPage' => '10', 'loadUploads' => false, 'allowSearch' => true, 'debugSql' => true, 'where' => htmlencode($record['Bus_categories']),

Does this make sense?

UPDATE: I tried using the current list page code rather than the Experimental code and it works. Either I needed to do a different way or there is a bug in the experimental code.

CMS Builder and if statements

Mon, 09 Sep 2013 11:40:35 -0700

Thanks for replying Jason. I placed your code in my php file and on clients that have a logo, it DOES show up! Good! However, if the client DOES NOT have a logo I need the 'clientname' to display and it DOES NOT. I have included the code I am using for the entire page just in case there is something in my code elsewhere that is causing your code to fail.

$libraryPath = 'cmsadmin/lib/viewer_functions.php'; $dirsToCheck = array('/home1/mydir/public_html/mydir/','','../','../../','../../../'); foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }} if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); } $info =mysql_real_escape_string ($_GET['clientname']); // load record from 'client' list($clientRecords, $clientMetaData) = getRecords(array( 'tableName' => 'client', 'where' => "`clientname` = '$info'", 'loadUploads' => true, 'allowSearch' => false, 'limit' => '1', )); $clientRecord = @$clientRecords[0]; // get first record if (!$clientRecord) { dieWith404("Record not found!"); } // show error message if no record found ?> http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> http://www.w3.org/1999/xhtml">





  
  
    

    
  
  
  $upload): ?>
      ">" width="" height="" alt="" />
     
    
  




      ,&z=17">

       , 

       

     

           Open-Days: 

    


  $upload): ?>
        " width="" height="" alt="" />

CMS Builder and if statements

Mon, 09 Sep 2013 07:57:12 -0700

I am attempting to build a detail page and I am confused as to the proper syntax to use when using "if" statements. Would someone be so kind as to show me what I need to do to my code to get it to display properly on the page? Individual items were displaying properly before I attempted to add in the "if" statements. Here is what I have so far:

if echo htmlencode($clientRecord['clientlogo']==''):

`echo htmlencode($clientRecord['clientname'])`


 else:
 foreach ($clientRecord['clientlogoupload'] as $index => $upload):
       " height="" alt="" />
  
 
<>

Imported new table in CSV format into database... error

Wed, 22 May 2013 10:21:35 -0700

Thanks for replying Greg! I have gotten the problem fixed. I purchased the CSV import Add On and after consulting with the folks in the office, I removed/renamed columns that were named reserved names.

Imported new table in CSV format into database... error

Tue, 21 May 2013 11:56:12 -0700

I imported some data as a table into the database. I tried to match all of the columns with the columns in admin. I got this error:

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,,,,,,,,) ORDER BY `order`, num' at line 3 (at old_alias_functions.php line 142 in function mysql_select_query)

Can anyone help me with what I need to do?

Working with lists

Tue, 23 Apr 2013 11:34:47 -0700

I am interested in using CMS Builder to search product lists. I have several hundred clients, each client has hundreds or thousands of products. I want to be able to import each clients list of products (like in a CSV file). I want to be able to search for a single product and retrieve all of the clients that have that product. Can CMS Builder do this?