Syntax to link query result field to external page

[Former Member]

Hi All,

I am trying to link a query result field to external page. I have taken first field as URL type and the second field as External Page in result fields.

In Query Definition, I am not sure what shall be the syntax to specify the external page name as "http://google.com".

As, when I am trying to give <%LOAD_PAGE(http://google.com)%>, I am getting SQL expression error.

Please guide me to resolve this.

Thanks,

Saloni

[former_member207877 · Accepted solution]

Hello Saloni,

Add two result fields with data types in the below order

1) URL

2) External Page

In URL give as 'Google" and in External page column give an entry as 'http://google.com)' in data base column.

Upon preview you can see that google is clickable field and then upon clicking, it will be re directed to google.

Regards,

Raj

[Former Member · Accepted solution]

Hi Raj,

Thanks for the inputs. It worked

Regards,

Saloni

[former_member190023]

Hi Saloni,

You simply have to supply the url in oracle-string specific format.

For example:

• 'www.google.com'
• 'http://google.com'

Bogdan