I have a field that I am displaying out to a webpage through a form in webpublisher 10. It is a "expanded record link"... which is, I think, what I want it to be... as it shows the title of a report surrounded by a link to the full record for that item.

Unfortunately the system puts out some code before the block of fields:
<p><font size="3" color="#000000">
and some code at the end of the block of fields:
</font>
which is not desired (and breaks my CSS layout).

All of the other fields in the block of fields are set, in the HTML tab of the box properties window, as "Raw HTML"... but I need to keep the title field as an "expanded record link" to get the functionality I need.

Does anyone know how to get rid of those unwanted bits of code that get put in?

I have looked in the box properties > format tab > added text tab area, but there is nothing there.

Please help, loosing my mind trying to find where this is ;~P

Instead of using an expand record link, consider using a canned query as described in Support Knowledgebase article 2104.

The Knowledgebase is accessible from www.inmagic.com by choosing Support>Customer Extranet from the menus.

Note that you can use QY= instead of QI0/QF0/QB0 as described in the article, if you like. For example &QY=Find+ID+CT+<yourfieldvalue>.

The canned query will bring up only the one record with the specified ID. In other words, there will be no Next Record/Previous Record buttons as there are with an expanded record link.

MCW,

Another option is to separate the HTML code that you want to add around the Title field, e.g. table cell code, class, etc., into a text line above the Title field. Treat that text line as Raw HTML and treat your Title field as Expand record link. Do not put any other HTML code in with the Title field. Put "ending" HTML code, if required, in another text line below the Title field.

This also applies to other "web" "Treat content item as" options, e.g. Email Link, HTML file reference, and "See Also" search link.

Thank you both. I used the canned query in the end, works a treat.

Regards

Mike

As an addendum, here's some script I use to emulate the ExpandRecord feature without a) losing next/previous info or b) messing my CSS. Feel free to plunder.

It acts exactly the same as webpublisher's expand. Extra value is that you can easily call this fxn from any event, so your expand links can be images if you want.

Just wrap the js call around the RECORDNUMBER variable in form designer:

<script type="text/javascript">
ExpandRecord([RECORDNUMBER], false);
</script>

  

/*
ExpandRecord() emulates the WebPublisher expand link
2006, Peter Tyrrell, Andornot Consulting
*/

function ExpandRecord(recordnum, newWindow)
{
	var params = dbtw_params;
	var snipA = "";
	var snipZ = "";
	var myUrl = window.location.href.replace(window.location.search, "");
	
	if (recordnum == 1)
	{
		snipA = params.indexOf("RN=") + 3;
		snipZ = params.indexOf("&", snipA);
		params = params.substring(0, snipA) + (recordnum) + params.substring(snipZ, params.length);
		myUrl += "?AC=PREV_RECORD" + params;
	}
	else
	{
		snipA = params.indexOf("RN=") + 3;
		snipZ = params.indexOf("&", snipA);
		params = params.substring(0, snipA) + (recordnum-2) + params.substring(snipZ, params.length);	
		myUrl += "?AC=NEXT_RECORD" + params;
	}
	
	if (newWindow && newWindow == true)
	{
	    window.open(myUrl);
	}
	else
	{
	    window.location.href = myUrl;
	}
}

Hi,
I realise this is an old question and I'm having the same problems. I was able to fix it using Denise's method but I'd really like to understand the canned query syntax. How do I create a query to expand a record by clicking on its title? Excuse my ignorance. Thanks in advance.

Risa