Re: [chris] css and category menus

Wed, 16 Sep 2009 08:57:21 -0700

yeah that's what I ended up doing.

It all seems to work! Thank you Chris! Your help is much appreciated!

Re: [chris] css and category menus

Tue, 15 Sep 2009 21:20:27 -0700

hey chris,
seems to work ok so far. Is there a way to determine if an item has sub items. I don't want it to print the IE conditional statement if an item does not have children.

Re: [chris] css and category menus

Tue, 15 Sep 2009 15:03:56 -0700

Hmm. Would a simple solution be to add the IE6 LI start code to the
tags around the entire menu?

I'm not sure I understand what you mean.

my point is that I DON'T want the IE6 conditional if statements to be added to the

nested

Re: [chris] css and category menus

Tue, 15 Sep 2009 14:30:46 -0700

I haven't tested it yet, but what do the pipes | around the in the $match variable do?

Also, won't that match ALL

css and category menus

Mon, 14 Sep 2009 23:19:30 -0700

ok I'm trying to use the code from http://www.cssplay.co.uk/menus/dd_valid.html for styling my (category) menu... Problem is, to be compatible with IE6, it uses conditional if statements between the

and



  HOME

  ABOUT


  PRODUCTS

    
      Product 1

      Product 1

tags if parents of sub menu's. Adding the beginning conditional if won't be a problem as I can just check if it's not the parent menu, then print the conditional code, then just print $categoryRecord['_listItemStart'].

But the problem comes when printing the end tag, since $categoryRecord['_listItemEnd'] will print the end tag of the last sub-item, the end tag of the sub items list and the end tag of the parent item all at once.

Is it possible to insert the condition if statement BEFORE the close

Re: [chris] Unknown option 'where' specified

Thu, 10 Sep 2009 13:30:13 -0700

How about setting up two top-level categories in your section: "Top Menu" and "Bottom Menu", then assigning all your records underneath to either one or the other. You can supply the "rootCategoryNum" option to getCategories, supplying the "num" of either your "Top Menu" or "Bottom Menu" record, which would return all the records underneath.

Ok I was playing around with this... and I keep getting this error:

Unknown option 'rootCategoryNum' specified

Is 'rootCategoryNum' a new option in the latest version ?

Re: [chris] Unknown option 'where' specified

Wed, 09 Sep 2009 08:41:48 -0700

Hey Chris,
I'm currently using v1.26, do paid users get free upgrades? and if so, can I upgrade without breaking anything in the process?

Re: [chris] Unknown option 'where' specified

Mon, 07 Sep 2009 18:12:33 -0700

Personally, I'd be tempted to keep them as separate sections and use a Menu Group to keep them conceptually together, which might be simpler.

can you explain this in more detail? Not sure I understand.

Unknown option 'where' specified

Sun, 06 Sep 2009 13:54:32 -0700

Currently I have 2 menus, a top and a bottom, set up as separate Category sections so they can be displayed separately. But to avoid confusion, I want to set up only 1 menu section and have a list field named "Position" and be able to select either Top or Bottom.

This is all fine, except the getCategories function doesn't support the 'where' option. I get this error if I use the 'where' option:
Unknown option 'where' specified

This is my code:

	list($categoryRecords, $selectedCategory) = getCategories(array(
	'tableName'			=> 'menu',
	'categoryFormat'		=> 'showall',
	'where'			=> 'position="top"',
	));

Is this at all possible? My other option would be just to query the entire category section and just do an if statement for the top and bottom menus... for example, for the top menu, I would do something like this.

//top menu
foreach ($categoryRecords as $categoryRecord):
	if ($categoryRecord['position'] == "top") {
		//display item
	}
endforeach;

But I'd really prefer a more graceful solution.

/atomicrabbit

Re: [ross] populate list field based on another list field's selection

Sun, 24 May 2009 18:38:46 -0700

Thanks ross, worked like a charm...

it's weird though -- that's the FIRST thing I tried and for whatever reason, it didn't work the first time. [:/]

Anywho, all is well now. Thanks again!

Re: [ross] populate list field based on another list field's selection

Wed, 13 May 2009 12:44:48 -0700

Ok let me give you an example. If I use the normal query,

list($locRecords, $locMetaData) = getRecords(array(
    'tableName'   => 'locations',
    'where'       => 'country="whatever"',
  ));

It will return the fields in the locations table based on the where statement and I'll be able to loop through the images field using $locRecords['image']['isImage'], $locRecords['image']['thumbUrl'], etc variables. BUT since I need to use multiple where statements, I cannot use the above code. As far as I know, it doesn't support multiple where statements -- i.e. "where w=x AND y=z", which is what I need so I'm forced to use a standard MySQL statement to query the database:

$locRecords = mysql_query_fetch_all_assoc("SELECT * FROM cms_locations WHERE country='" . $_REQUEST['c'] 
 . "' AND province_state='" . $_REQUEST['ps'] . "' AND city='" . $_REQUEST['ci'] . "' ORDER BY country, province_state, city");

BUT, using this does not give me the variables such as $locRecords['image']['isImage'] or $locRecords['image']['hasThumbnail'] or $locRecords['image']['thumbUrl'] (as far as I know)... how do I get those variables using a standard MySQL statement as opposed the to first code snippet.

Re: [Dave] populate list field based on another list field's selection

Sun, 10 May 2009 10:49:35 -0700

Hey Dave, I'm having a bit of trouble. I'm using a normal MySQL state as opposed to the getRecords() function to retrieve the values from the database to display on the page because I needed multiple WHERE statements. This is the line of code:

$locRecords = mysql_query_fetch_all_assoc("SELECT * FROM cms_locations WHERE country='" . $_REQUEST['c']
 . "' AND province_state='" . $_REQUEST['ps'] . "' AND city='" . $_REQUEST['ci'] . "' ORDER BY country, province_state, city");

The problem is I can't use the same code to loop through an image field because the normal MySQL statement doesn't add all the extra variables like 'thumbUrlPath' or 'isImage' or 'hasThumbnail', etc etc. Is there a way I can get those variables still using a normal MySQL statement, or is there a way to use the getRecords() function and add multiple WHERE statements?

Re: [Dave] populate list field based on another list field's selection

Sat, 09 May 2009 13:36:38 -0700

Yes, I know MySQL syntax, I just wasn't sure if I could use it with the CMS backend. That's all I needed to know.

Thanks Dave.

Re: [Dave] populate list field based on another list field's selection

Fri, 08 May 2009 07:34:48 -0700

is there an easy way to input the province/state entries into the database without having to do each one manually?

Can I just use a MySQL insert statement in a php page??

Re: [Dave] populate list field based on another list field's selection

Wed, 06 May 2009 18:40:49 -0700

The query may require two values (one for "value" and one for "label" in the pulldown)

yeah thats what I was thinking

Try this:

Query: SELECT state, state FROM cms_states WHERE country = ''

that worked like a charm, dave. Thanks!!!! [:)]

Re: [Dave] populate list field based on another list field's selection

Tue, 05 May 2009 21:28:22 -0700

thanks for the replies Ross and Dave.

Dave, I think your idea makes sense, although I don't think I need to create a Country section, I can just create a Country list field in the state section.

But regardless, I will try your solution and post the results!

Edit: ok it seems to return the proper values from the MySQL select statement, but it gives me the following error when I change the Country list pulldown

Error: 
Notice: Undefined offset:  1 in /home/.sites/4/site38/web/cmsAdmin/lib/database_functions.php on line 507

So I'm not sure whats going on here, but right off the bat, it seems like only the values are being populated, not the visible text between the tags

- Adam

populate list field based on another list field's selection

Mon, 04 May 2009 21:23:24 -0700

Ok 'll try to keep this as simple as possible:

I created a section called Locations which will hold the company's locations around North America, so I've created a Country list field and a Province/State list field.

When inputting data, what I want to do is have the Province/State list field automatically updated with appropriate values when the Country list field is changed.

So if I'm adding an entry in the locations section, and I select Canada from the country field, I want the Provinces/States field to automatically be populated with Canada's provinces & territories only. And if I select US, I want it to be automatically populated with USA's states.

One way I thought of doing this is by creating a separate section that holds provinces and states and have three main fields:

Country, PS_Abbreviation, Province/State

So I would add all provinces and states from Canada and the US in the separate section and give each the appropriate country, so for example:

Canada, ON, Ontario
Canada, BC, British Columbia
United States, AL, Alabama
United States, AK, Alaska
etc etc

And MAYBE set the Province/State list field to populate using a MySQL statement using the values from the separate section, but I don't know how I'd reference the Country field that is selected.

Note: I want to do this all within the CMS backend, not on a html viewer page I create.

I hope this makes sense.