Martyn Houghton Posted May 16, 2016 Posted May 16, 2016 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 Posted May 16, 2016 Posted May 16, 2016 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 RegardsTrevor Killick
Martyn Houghton Posted May 16, 2016 Author Posted May 16, 2016 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 Posted May 16, 2016 Author Posted May 16, 2016 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 Posted May 16, 2016 Posted May 16, 2016 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 Posted May 17, 2016 Author Posted May 17, 2016 James Thanks for the clarification. I'll just need to remember now to insert the code snippet markers. Cheers Martyn
Steve Giller Posted May 17, 2016 Posted May 17, 2016 Does the Hornbill wiki support {{{ ... }}} as unformatted text?
TrevorKillick Posted May 17, 2016 Posted May 17, 2016 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 Posted May 17, 2016 Posted May 17, 2016 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 Posted May 17, 2016 Posted May 17, 2016 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 Posted May 17, 2016 Posted May 17, 2016 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now