Re: [Jason] Question about searching

Mon, 31 May 2010 16:58:23 -0700

Hi Jason, that is great too, but I need 2 select boxes:

One with all Manufacturers and when users select one, list all Models of that Manufacturer.

Re: [Jason] Question about searching

Mon, 31 May 2010 16:19:05 -0700

Hey Jay,

I want to be able to have a dependent combo box with 2 levels Manufacturer (Marca) and Model (Model).

I attach my php file for you. You can see here:
http://www.pixalar.com/dev/cassano/usados/index.php
As u can see I have all Manufacturers and Models up in CMS.

Re: [Jason] Question about searching

Mon, 17 May 2010 17:33:32 -0700

Hello Jason,

I'm searching the forum for a solution for this too.

I have to make a combo search for a car agent website.

Combo Box with Manufacturer and when you choose one, list all Models, I already have it in CMS (with about 1200 records of Models) using the thread and a script that Chris made in other post.

What I need in fact is the whole search page for users.

Combo box with Manufacturer and Models, and then search by Price from and Price To.

How can i make it? What do you need to help me up with this one?

Thank you, Juan.

If Selected then Show Image

Thu, 12 Mar 2009 23:17:04 -0700

Dave,

I need to set up a Promotion advise to the products list.

So i've added a list field called "Promotion" with 2 options to select from: Yes or No.

If product is under Promotion, I'll select "Yes" and then I want to show it in the webpage with an Image, and if not under promotion, i do not want any image to display.

How can I do it with the php if function?

Thank you, Juan.

Re: [Dave] Record Count

Wed, 03 Dec 2008 15:30:00 -0800

Yes Dave!!! You rock, thank you!

Re: [Dave] Record Count

Tue, 25 Nov 2008 08:42:45 -0800

It's not working with new versions of CMS Builder.

How can I show total records listed in List Page?

Thank you, Juan.

Re: [jposwald] Help with Google Maps

Mon, 24 Nov 2008 22:55:59 -0800

FYI

Hi Jake, great data, thank you!

See how Google Maps API works here:

http://www.utahreoexperts.com/featured-homes/detail/?CROWD-PLEASER-4

It's all controlled under IT CMS and maps gets centered automatically!

But I need to know how can I put all featured homes under only 1 Google Maps and if you click on it then redirect to selected home.

This is Featured Homes listing:

http://www.utahreoexperts.com/featured-homes/

So under that page create the same google map box as I have in Property Details but with all Property Records on CMS.

Is that posible? Thank you, Juan.

Re: [Dave] Divide a single list into multiple groups

Tue, 18 Nov 2008 11:27:42 -0800

Dave,

I really love CMS. It allows me to get my clients very happy, and i'm happy to with that!

I want to make you an answer regarding this item.

I have 2 sections in CMS called "Featured Homes" and "Meet our Team"

I want to put a field under Detailed Property to show which agent of "our team" is seeling that home.

This is the url:

http://www.utahreoexperts.com/featured-homes/detail/?SELLER-MOTIVATED-TOWNHOME-6

I know how to create a pull list field called "Agent" and get it from Get options from database, under "Featured Homes" section.

But Im stuck to get that record and echo into Detailed Property.

What should i do?

Thank you Dave, Juan.

Re: [Jake] Help with Google Maps

Tue, 18 Nov 2008 11:11:09 -0800

Hi Jake, great data, thank you!

See how Google Maps API works here:

http://www.utahreoexperts.com/featured-homes/detail/?CROWD-PLEASER-4

It's all controlled under IT CMS and maps gets centered automatically!

But I need to know how can I put all featured homes under only 1 Google Maps and if you click on it then redirect to selected home.

This is Featured Homes listing:

http://www.utahreoexperts.com/featured-homes/

So under that page create the same google map box as I have in Property Details but with all Property Records on CMS.

Is that posible? Thank you, Juan.

Re: [Dave] Limit Upload Display - Mind Blank!

Sun, 02 Nov 2008 23:57:30 -0800

Thank you!

Re: [Dave] 'Where' to find an answer!

Wed, 22 Oct 2008 14:48:32 -0700

Dave,

I'm running 1.22 version.

Re: [Dave] 'Where' to find an answer!

Wed, 22 Oct 2008 11:22:50 -0700

I have this:

  
  require_once "/home/content/d/e/r/derekseal/html/utahreoexperts/cmsAdmin/lib/viewer_functions.php";
  
  // load upload
    list($uploadRecords, $uploadMetaData) = getRecords(array( 
    'tableName'   => 'uploads', 
    'where'       => 'tableName = "videos" && fieldName = "video"',
    'orderBy'     => 'RAND()',
    'limit'       => '1', 
  )); 
  $upload = @$uploadRecords[0]; // get first record 
  
  // load record 
  $recordNum = @$upload['recordNum']; 
  list($videosRecords, $videosMetaData) = getRecords(array( 
    'tableName'   => 'videos', 
    'where'       => "num = '$recordNum'", 
    'limit'       => '1', 
  )); 
  $videos = @$videosRecords[0]; // get first record
 
?>

And then I put variables to list as:

But it seems to take me the uploads but no the videosRecord, as you can see in:

http://www.utahreoexperts.com/selling-your-home/videos-about-selling-a-home/video/?Video-1-Selling.-3

Please help with this one.

Cheers, Juan.

Re: [Mr Jim] List Records Trouble

Tue, 21 Oct 2008 19:29:29 -0700

Mr Jim thank your help approach, what i wanted was another thing, but I already found it in post 65540 thank you!!!

Re: [Dave] Uploading flash, mp3 etc.

Tue, 21 Oct 2008 18:28:47 -0700

thank you dave

List Records Trouble

Tue, 21 Oct 2008 16:22:21 -0700

Dear IT,

I have a problem listings records.

It only list me the first record, and not the others ones I've add in same category.

In where cause I put num 1 because it's the section of list that I need to show (I have 3 sections for that variable).

It works but only show me the first one.

  
  require_once "/home/content/d/e/rhtml/utahreoexperts/cmsAdmin/lib/viewer_functions.php";

  list($frequently_asked_questionsRecords, $frequently_asked_questionsMetaData) = getRecords(array(
    'tableName'   => 'frequently_asked_questions',
    'where'       => whereRecordNumberInUrl(1),
    'where'       => " num = '1' ", 
    'perPage'     => '10',
    'loadUploads' => '0',
    'allowSearch' => '0',
  ));

?>

This is the URL:
http://www.utahreoexperts.com/first-time-home-buyers/faq-frequently-asked-questions/

The code of the list page is:












 
Q. 
 
 A. 
 
Back to Top

Thank you!!!!!

Re: [Dave] Uploading flash, mp3 etc.

Tue, 21 Oct 2008 14:23:50 -0700

Any one has the code for .MOV Quicktime?

Re: [Dave] $_GET

Sun, 19 Oct 2008 16:51:32 -0700

That makes sense for me too thank you!

Re: [kevbarker] SWF in wysiwyg

Sun, 12 Oct 2008 19:38:18 -0700

Great Thank you boys!!

SWF in wysiwyg

Mon, 22 Sep 2008 17:07:35 -0700

Dear Dave,

Is it any script that I have to put in the php file to see a Shockwave video?

Because I uploaded one in wysiwyg but it only appears the Shockwave logo and video do not appears.

http://www.worldwidetrainings.com/SC_Preguntas_Frecuentes.php?id=1

Best Regards, you rock!

Re: [Perchpole] Paypal Standard

Tue, 01 Jul 2008 17:28:16 -0700

Hey PerchPole!! Thank you that works perfect!!

Paypal Standard

Tue, 01 Jul 2008 15:20:06 -0700

Dave I have this in my Paypal form,

When I click on the button Paypal page says:

Error in Price Format

I think I doing bad the next step:

I have to put another type of code, but I do not know which one.

Thank you, Juan.

Re: [Dave] Notice: Announce your new CMS Builder websites here!

Mon, 26 May 2008 14:38:43 -0700

Premium E-Learning Site.

http://www.worldwidetrainings.com

Made 100% with CMS Builder.

Best Regards,

Pixalar | Online Ventures Company

Re: [jposwald] MultiSearch

Mon, 26 May 2008 14:08:48 -0700

Dave, can I have dynamic links in Search.php? I mean make an if condition in each "viewer url" variable.

Thank you!

Re: [Dave] MultiSearch

Fri, 23 May 2008 19:48:28 -0700

Yesss, great thank you Dave!!!

Re: [Dave] MultiSearch

Fri, 23 May 2008 14:23:29 -0700

Dave sorry but I don't understand,

Do I have to delete as is?:

       require_once "/home/content/w/w/t/wwtrainingsk2/html/cmsAdmin/lib/viewer_functions.php";
      $searchOptions = array();
      $searchOptions['keywords'] = @$FORM['q'];
      $searchOptions['perPage']  = "20";
      $searchOptions['debugSql'] = "0"; $searchTables = array();
      $searchTables['cursos_el_'] = array(
        'viewerUrl'       => 'EL_Listado_ver.php',
        'titleField'      => 'nombre',
        'summaryField'    => 'descripcion',
        'searchFields'    =>  array('nombre','descripcion'),
      );      $searchTables = array();
      $searchTables['cursos_pr_'] = array(
        'viewerUrl'       => 'PR_Listado_ver.php',
        'titleField'      => 'nombre',
        'summaryField'    => 'descripcion',
        'searchFields'    =>  array('nombre','descripcion'),
      );
   
      $searchTables = array();
      $searchTables['cursos_en_'] = array(
        'viewerUrl'       => 'EN_Listado_ver.php',
        'titleField'      => 'nombre',
        'summaryField'    => 'descripcion',
        'searchFields'    =>  array('nombre','descripcion'),
      );
   
      $searchTables = array();
      $searchTables['soluciones_'] = array(
        'viewerUrl'       => 'Soluciones_ver.php',
        'titleField'      => 'id',
        'summaryField'    => 'descripcion',
        'searchFields'    =>  array('id','descripcion'),
      );
   
      $searchTables = array();
      $searchTables['certificaciones_'] = array(
        'viewerUrl'       => 'Certificaciones_ver.php',
        'titleField'      => 'nombre',
        'summaryField'    => 'descripcion',
        'searchFields'    =>  array('nombre','descripcion'),
      );
list($searchRows, $searchDetails) = searchMultipleTables($searchTables, $searchOptions);
    ?>
And only put this?      require_once "/home/content/w/w/t/wwtrainingsk2/html/cmsAdmin/lib/viewer_functions.php";
      $searchOptions = array();
      $searchOptions['keywords'] = @$FORM['q'];
      $searchOptions['perPage']  = "20";
      $searchOptions['debugSql'] = "0";  [font "Verdana"]$searchTables = array();  list($searchRows, $searchDetails) = searchMultipleTables($searchTables, $searchOptions);
    ?>