Workspaces - text containing two single quotes together get stripped

[Martyn Houghton]

We are using a workspace to record SQL Statements, at the moment as part of our test data transfer to Service Manager, but going forward we use SQL Statements in a lot of our own support service, so will need to include them in workspace posts etc.

I noticed that when they are pasted in two single quotes next each to each other are stripped. Example SQL below and screen shot.

This means that when you copy them back out again to apply the fix, they are corrupted.

Cheers

Martyn

Original Source SQL

select keysearch as login_id, firstname as first_name, surname as last_name, company.companyname, email as email_1, '' as email_2, isnull(telephone,'') as telephone_1, mobiletel as telephone_2, isnull(JobTitle,'') as job_title, 'Transfered from Support Works' as description, isnull(userdb.notes,''),isnull(company.country,''), 'English (British)' as language, isnull(webflag&1,0) as Portal_Account from userdb left join company on userdb.fk_company_id=company.pk_company_id

[TrevorKillick]

Hi Martyn

This is part of wiki markup two quotes makes text italic

https://wiki.hornbill.com/index.php/Wiki_Markup

If you want to post content like this i would advice using

[code:sql]
select * from table;
[/code]

The new line before and after the

 sections is important.
Kind Regards
Trevor Killick

[Martyn Houghton]

Trevor

Thanks for the quick reply I will try using the encasing section headers.

Can I propose a change to the markup to for italic to use a less common combination, even if it is four single quotes to stick with same approach, i.e. ''' is bold '''' is italic. That way you would avoid the changing of any code, not just sql that may contain two single quotes together..

Cheers

Martyn

[Martyn Houghton]

Trevor

The [code:sql] does indeed allow the insertion as is without corruption. Think the option for code snippets in the WiKi, needs to be updated to include the sql option as it is not listed at the moment.

If you can still raise the proposed change to alter the markup for italics not to be two single quotes together.

Thanks

Martyn

[James Ainsworth]

Hi Martyn,

The markup that we are following is based on wiki markup which uses the two single quotes to represent italics. We will want to make sure that these are kept consistent with this format.

More information about the markup that we use can be found here

Regards,

James

[Martyn Houghton]

James

Thanks for the clarification. I'll just need to remember now to insert the code snippet markers.

Cheers

Martyn

[Steve Giller]

Does the Hornbill wiki support {{{ ... }}} as unformatted text?

[TrevorKillick]

Hi Steve

I just gave it a try and it does not is that a wiki thing, if so i can ask development to consider adding it in?

Kind Regards

Trevor Killick

[Steve Giller]

It was something I noticed that Creole uses, I was more asking out of interest for when we migrate rather than expecting to have it added.

It might be useful for some people to achieve unformatted text without using the code tags, of course, unless there's already an alternative.

[TrevorKillick]

Hi Steve

Thanks for the suggestion it doesn't look like there is anything to do the suggested so i will put the suggestion through to development.

Kind Regards

Trevor Killick

[TrevorKillick]

Hi Steve, Martyn

Development have raised the following change CH00141233 which will introduce <nowiki></nowiki> allowing you to post text unformatted.

Kind Regards

Trevor Killick