CMS Builder

Hi,
'View Website' is changed in the Admin area. Login as Admin and under General Settings -

Admin > General Settings > 'View Website' URL

HTH,
Mickey

Thanks Mickey [:)] - found it and changed it!

Do you know how to add a hyperlink to text that's in a field?
I'm sure it's easy but I can't see it - I have a text field for a job description and there is a downloadable pdf that needs to be linked to it?

Thanks again and Happy New Year to you and yours

Jim

>Do you know how to add a hyperlink to text that's in a field?

You generally wouldn't add a hyperlink to a text field, the way you'd do that is to use a wysiwyg field (which has a link button) or use two fields, one for the text and one for the link. Then have have the view display the link around the text.

If that doesn't work for you let me know what you're trying to do and we'll help you out.

Hi Dave,



thanks for that - re: the horizontal rule - it appears between each of the job listings, but I can't see the <hr> tag in the code? I just wanted to make it red.

Also - on the hyperlink - I tried to use the wysiwyg bar to add a link but the link icon remained greyed out? I have to add a link to a downloadable pdf with each job ref.

(I reckon the wysiwyg bar could do with a tad more explanation btw! )

I have another challenge for you too :-) - in my job listing page I have navigation to 8 diff coountries and 9 diff job types.
What I'd like to do - rather than have to create a seperate table for each country / job type - can I make the links conditional and just use one table? So for example if I click on the 'Russian' jobs can I use a query something like ' list only jobs with 'Russia' in the location field'..? Does this make sense?

Thanks for your help and Happy New Tear

Jim

>I can't see the <hr> tag in the code?

It's in there. Search for "<hr" with whatever html editor you're using. That way you'll find it whether it's <hr> or <hr />. It's in the list viewer page.

>Also - on the hyperlink - I tried to use the wysiwyg bar to add a link but the link icon remained greyed out?

Try selecting the text you want to link. The button will appear once you select something.

>I have to add a link to a downloadable pdf with each job ref.

You can't upload files through the wysiwyg yet, but that feature has been requested. The way to do it is create an upload field for it. It will automatically display all your uploads (once you add the field the code generator will output an extra block that does that, just copy and paste it into your page).

Alternatively, we're releasing a new version this week that _does_ allow upload through the wysiwyg. So if you want to wait and use that you could do that.

>(I reckon the wysiwyg bar could do with a tad more explanation btw! )

I'll add this to the feature request list. Maybe we can have a help button on there by default that shows wysiwyg help.

>in my job listing page I have navigation to 8 diff countries and 9 diff job types.

It's not that hard to do custom searches. Do you care how the urls look? If the urls were like this would that work for you? (filename doesn't matter)

jobViewer.php (lists all jobs)
jobViewer.php?country=usa&type=administrative (lists administrative jobs in the usa)

Do you need anything more complicated than that?

Also, let me know what your country and jobType fields are called and I'll write up some code for you.

Hi Dave,



yep found the hr tag and changed that -

Re: the downloadable pdfs - I tried selecting the text but the link icon remained greyed out - am I doing something wrong?

>You can't upload files through the wysiwyg yet, but that feature has been requested. The way to do it is create an upload field for it. It will automatically display all your uploads (once you add the field the code generator will output an extra block that does that, just copy and paste it into your page).


Sorry - I don't quite understand this - I want people to be able to download the pdf - not upload one?

>It's not that hard to do custom searches. Do you care how the urls look? If the urls were like this would that work for you? (filename doesn't matter)

jobViewer.php (lists all jobs)
jobViewer.php?country=usa&type=administrative (lists administrative jobs in the usa)

Um - again - I'm being thick here - are you saying that if I have a link in the nav to the North American jobs, then a link:
jobViewer.php?country=usa&type=administrative - would query the DB and post the result?

Not sure what you mean by 'do I mind how the urls look' - do you mean this is what would appear in the location bar in the browser?
If so, then no I don't really care...

The country ( location) fields will be:

• Africa
• Bulgaria
• China
• Malaysia
• Russia
> South Africa
• Tanzania
• UK
• USA

Job fields:

• Business development
• Operations
• Commercial & legal

• Analyst
• Consultant
• Senior consultant
• Principal
• Graduate recruitment

• HR
• Finance
• Operations
• Marketing
• General administration
• Project administration
Software specialists

Thanks for all your help Dave -

best,

Jim

>tried selecting the text but the link icon remained greyed out - am I doing something wrong?

What browser are you using? Do any of the other wysiwyg buttons or features work? Try another brower and see if that makes a difference (a recent Firefox or IE)

>I want people to be able to download the pdf - not upload one?

Right, so you already have the pdf somewhere on the web, you can just put in the url to it. If not, you'll need to have an upload field so you can upload it first, and then link to it.

I'm going to do a separate post for the search instructions. I'm still working on that one. :)

Here's how to setup the job search. Create pulldowns (list fields) for "country" and "type" with the options you listed.

Then, update your 'jobList.php' file (or whatever you named that file).

Insert the following after this line "$options = array();"

// get page number and keywords
$pageNumber = @$FORM['page'] ? $FORM['page'] : 1;
$country = @$FORM['country'];
$type = @$FORM['type'];

// create custom where query
$where = "";
if ($country) { $where .= "country = '" .escapeMysqlString($country). "'"; }
if ($where && $type) { $where .= " AND "; }
if ($type) { $where .= "type = '" .escapeMysqlString($type). "'"; }

Then, update these two options:

$options['pageNum'] = $pageNumber;
$options['where'] = $where;

Finally, add this after the line with "getListRows(...)"

// update page links
$pageLink = "{$_SERVER['PHP_SELF']}?country=" .urlencode($country). "&type=" . urlencode($type);
$listDetails['prevPageLink'] = "{$pageLink}&page={$listDetails['prevPage']}";
$listDetails['nextPageLink'] = "{$pageLink}&page={$listDetails['nextPage']}";
$listDetails['firstPageLink'] = "{$pageLink}&page=1";
$listDetails['lastPageLink'] = "{$pageLink}&page={$listDetails['totalPages']}";

Give that a try and let me know how it works.