Re: Re: [rcrofoot] Using Geocoder as a stand-alone function

Mon, 07 Oct 2013 07:04:51 -0700

In response to: [url "http://www.interactivetools.com/forum/forum-posts.php?postNum=2212596#post2212596"]Re: [rcrofoot] Using Geocoder as a stand-alone function[/url], ...

Hello 2 years later -

Using Geocoder 1.00 as a stand-alone function in my test page seems to work great...

My questions:

1) Should I be concerned that the return LAT & LNG values are accurate to 6 places vs. Google's return values of 7 places?

My concern is that for a given address:

Geocoder returns a latitude of 41.169848 and longitude of -73.532146.

Google returns a latitude of 41.1711970 and longitude of -73.5307970.

Why the discrepancy???

2) Is there an upgrade that will provide enhanced accuracy?

Many thanks! Great Products!

Rick Crofoot

ERROR - Notice: Undefined index: scheme in...

Wed, 29 May 2013 13:43:32 -0700

Thanks Steve...

The addition of the "@" symbol error suppression on those two lines did it...

Rick

ERROR - Notice: Undefined index: scheme in...

Wed, 29 May 2013 06:19:04 -0700

Hello Again -

I am re-posting the below from yesterday because my contact info was not correct and couldn't determine if anyone responded:

Hello -

I am getting these errors when running my PHP page in a cron job or from a unix command line (from a browser it works fine):

Notice: Undefined index: scheme in /usr/www/users/decaro/kellyassociates/cmsAdmin/lib/common.php on line 642

Notice: Undefined index: host in /usr/www/users/decaro/kellyassociates/cmsAdmin/lib/common.php on line 648

The PHP page contains code that references two CMS Builder Section Editors...

I've never encountered this in previous jobs...Any idea what might be going on???

Many thanks, Rick

Call list(...) multiple times in same page...

Tue, 27 Sep 2011 22:51:14 -0700

Hello-

I'm trying to return a relevant set of records from CMSB based on what the user specifies...For example if they click on "Under 1,000,000", I execute this, which resides in a javascript function called "pricegroup1":

// load records
list($properties_for_saleRecords, $properties_for_saleMetaData) = getRecords(array(
'tableName' => 'properties_for_sale',
'where' => 'list_price<1000000',
'orderBy' => 'list_price DESC',
));
?>

If they click on "1,000,000 to 1,499,999", I WANT to execute this, which resides in another javascript function called "pricegroup2":

list($properties_for_saleRecords, $properties_for_saleMetaData) = getRecords(array(
'tableName' => 'properties_for_sale',
'where' => 'list_price>=1000000 and list_price<1500000',
'orderBy' => 'list_price DESC',
));

It's only when I add the 2nd list() block to my PHP page that things stop working, and my browser says there's a javascript error...no ending semicolon on a line number that doesn't even exist...

If I remove the where clause from the 2nd list() bloc, the js error goes away, but of course, the correct data isn't returned. Also, if I simplify the where clause to 'where' => 'list_price<1500000', the error returns...If I change this to 1000000, the error goes away again...

My question is: Is it legal to have more than 1 list() block on a page....I'm stuck...

I hope this is somewhat clear...

Thanks for the help...Rick

CMSB Install Question...

Thu, 08 Sep 2011 23:55:30 -0700

Hello -

Regarding installation of CMSB, when I ran admin.php (final installation step), I accepted the mysql server default of "localhost"...Is this ok?

I usually deal with a different hosting company, and I am given a mysql server name such as "db144.soandso.com"...

The hosting co. I had to use for this install gave me no db server name...The CMSB install went fine...Just curious as to whether this will haunt me later on down the line...

Thanks, Rick

Undefined index error

Tue, 06 Sep 2011 12:59:06 -0700

Hello -

Could you please help me find out why this error is occurring:

Notice: Undefined index: pdf_brochure in /usr/www/users/brother/search_details_new_canaan.php on line 102 Warning: Invalid argument supplied for foreach() in /usr/www/users/brother/search_details_new_canaan.php on line 102

The correct CMSB record is being accessed, but the inner foreach won't work...The code is directly from the CMSB code generator...Here's the code:

// determine if this listing id is in cmsb to retrieve title & body copy
// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/usr/www/users/brother/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records
list($properties_for_saleRecords, $properties_for_saleMetaData) = getRecords(array(
'tableName' => 'properties_for_sale',
'loadUploads' => '0',
'allowSearch' => '0',
'where' => 'mls_number=\''.$listing_id.'\'',
));
?>

Download

Thanks, Rick

Re: [Jason] Access CMSB from a remote server

Fri, 02 Sep 2011 16:43:16 -0700

Thanks Jason...

You jogged my memory into coming up with a pretty simple solution...If it works that is!

Have a great weekend...Rick

Access CMSB from a remote server

Thu, 01 Sep 2011 11:18:37 -0700

Hello -

Befor I potentially spend (waste) alot of time on this on my own, I'm wondering if anyone has ever tried to access CMSB data from a PHP code page running on another server...

For example: My CMSB install and section editors/data are on "Server A"...On the site I working on, I need to jump over to "Server B" to do some special processing, but during the special processing, need to refer back to CMSB (on Server A) to get a piece of data...I can't get the piece of data before going over to Server B because it's only during the special processing on Server B that I know what data to get...

My first thought is to modify the "load viewer library" code that CMSB generates (on a PHP page on Server B) from:

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/usr/www/users/brother/','','../','../../','../../../');

To something like this (URL now trying to access Server A where CMSB lives):

// load viewer library
$libraryPath = 'http://www.sitea.com/cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('http://www.sitea.com/','','../','../../','../../../');

Does anyone happen to know if this approach is going to be something that'll be legal?

Thanks for the help,

Rick

Re: [robin] Add link to Welcome screen...

Wed, 17 Aug 2011 13:00:41 -0700

Thanks to you and Tim for the reply...

I'll take your suggestion and try the plugin...

Rick

Add link to Welcome screen...

Tue, 16 Aug 2011 16:52:42 -0700

Hello -

I'd like to be able to execute a block of PHP code after user clicks "Save" on a record...

Instead of creating a plugin (whick I don't know how to do yet) to fire on the "Save" button click event, I recall that Dave once told me I could place a link on the Welcome page...I think that would work for me temporarily,until I can find the time to experiment with creating a plugin...

Could you refresh my memory and tell me what page to use so that I can place a link of my own on the CMSB Welcome page after a user logs in...

Many thanks, Rick

Re: [Jason] Execute php code on record save...

Tue, 16 Aug 2011 11:41:09 -0700

Hi Jason -

Thanks for the tips re: plugins...

I tried a few weeks ago to implement what I needed but was unsuccessful...I'm going to attempt to write the plugin I need one more time, but because I'm under a heavy workload, I may not have the time to focus...

What would the cost be to have you do it...Is there an hourly rate, or a minimum???...I've written the PHP code...I just need a plugin to execute it when user saves a record in CMSB...

OR, is there a detailed tutorial available, that can walk me thru the process of building it myself...

Thanks for the help...Rick

Using Geocoder as a stand-alone function

Fri, 05 Aug 2011 18:22:18 -0700

Hello -

I'd like to use the functionality of your geocoder "Sample form with automatic geocoding", but without the form, but am a little confused as to how to do this...

Ideally, I would set up a function that accepts an address (or zip code), and have the function return the lat/long values...

I suspect there's a way to use the geocoder to do this with PHP and without the form...Any help appreciated!

Thanks, Rick

Re: [Jason] Execute php code on record save...

Wed, 27 Jul 2011 12:59:01 -0700

So as I understand it, I'm really creating a plugin and putting it in the plugins folder...

Then in /usr/www/users/brother/cmsAdmin/lib/menus/save.php, after the line doAction('record_postsave', $tableName, $isNewRecord, $oldRecord, $_REQUEST['num']);, I'll be adding addAction('record_postsave', '_pluginName_myFunctionName', null, 4); using my plugin & function name of course...Sounds interesting...Can't wait to try it...Rick

Re: [Jason] Execute php code on record save...

Wed, 27 Jul 2011 12:33:32 -0700

Thanks Jason...This will help alot...

One last question: Where is the record_save hook...In one of the cmsb php pages???[/#000000]

Thanks, Rick

Re: [robin] Execute php code on record save...

Wed, 27 Jul 2011 11:35:41 -0700

Hi Robin -

Thanks for responding...

I'm having a problem accessing the download for the mysql console plugin...My 2 user names & passwords don't work on that screen...

Could you possibly outline what I need to do??? For instance where is [font "Verdana"]record_postsave and is it a built-in event handler...[/#000000]

[font "Verdana"]Also, might there be a more direct way to do this...Can I add another button (or link) on a section editor page that I can access after I save a record???[/#000000]

[font "Verdana"]Just trying to get this done asap...lots of pressure right now...[/#000000]

[font "Verdana"]Thanks, Rick[/#000000]

Execute php code on record save...

Tue, 26 Jul 2011 19:25:11 -0700

Hello -

I'd like to be able to automatically execute some PHP code when my client clicks "Save" after modifying a record in CMSB...Is there a built-in event handler somewhere that I could insert my code???

Seems like you can do everything else with CMSB, so why not this!

Thanks in advance for the help...

Rick

Re: [Jason] Field Label values

Tue, 12 Apr 2011 12:39:57 -0700

Thanks Jason...I kind of suspected something like that...

I ended up just hardcoding the values, but I like your idea about entering into 'info1'...

Thanks for the quick reply...Rick

Field Label values

Tue, 12 Apr 2011 12:05:03 -0700

Hello-

I'm trying to display a regular old Field Label value, but all I seem to be able to access is the table fieldname value...Here's what I have:

{
echo $upload['fieldName'].":
";
}
$count++; ?>...etc...

The above code displays "presentations" which is the table fieldname...I'm trying to get the label of the field which is "Presentation Templates"...

I tried echo $upload['fieldLabel'], but no luck...

Can you tell me how retrieve the actual label value of a field...and not the table fieldname...

Many thanks, Rick

WYSIWYG fields...

Wed, 15 Sep 2010 16:59:16 -0700

Hello-

When using a WYSIWYG field type in a section editor, it looks as though an automatic

tag is rendered below the field in my web page...Is there a way to remove this...???

I was originally using a text field and could display things in-line, but my client wants to control the styles herself, and as a result, using the WYSIWYG field has messed up my formatting...

Using v2.01.

Thanks for the help as always...

Rick

Re: [chris] Undefined index: QUERY_STRING in viewer_functions.php on line 289

Tue, 31 Aug 2010 19:30:28 -0700

Thanks Chris...That did it...!!!

Rick

Re: [chris] Undefined index: QUERY_STRING in viewer_functions.php on line 289

Tue, 31 Aug 2010 16:08:46 -0700

Version 1.09

Undefined index: QUERY_STRING in viewer_functions.php on line 289

Tue, 31 Aug 2010 11:18:07 -0700

Hello-

I am executing a php file containing cms builder code via the linux shell and get this error for every record processed:

Notice: Undefined index: QUERY_STRING in /usr/www/users/decaro/kellyassociates/decaro/cmsAdmin/lib/viewer_functions.php on line 289

When the php code is run as a url in my browser, everything is fine...

In either case the desired result is correct, so I'm not all that concerned about the errors, but was wondering if you knew offhand what this is all about...

Thanks, Rick

Re: [Dave] cms_accesslist table

Mon, 10 May 2010 19:04:19 -0700

Thanks, Dave...

Jason helped me out quite a bit already, and your info just reinforces things a bit more...

Hope you're all well and that business is good...You have a great product with great forum support!

Rick

Re: [Jason] Adding records using SQL to create new user/password

Mon, 10 May 2010 18:58:48 -0700

Thank you, Jason...

That's exactly what I needed info about...

Rick

Re: [Jason] Adding records using SQL to create new user/password

Mon, 03 May 2010 18:58:38 -0700

Hi Jason-
My client has a text file of user names & passwords that are updated on a daily basis from an external database...It consists of approx. 800 names/passwords...Each of these users needs to be registered in cms builder so they can post their own material when necessary...So, I thought that re-writing the main table (section editor), and then updating the cms_accesslist using sql would be the way to go...I'm confident that would work, but wondered if you have any recommendations or snags you can alert me to...Also, not sure where the value for randomSaveId field in cms_access table is coming from...Is it getting automatically generated as a unique value...And what is it used for...
Thanks, Rick