* Pretty print SQL broken? Or am I doing something wrong?
@ 2009-06-07 6:38 Gerben Wierda
2009-06-08 7:59 ` Berend de Boer
0 siblings, 1 reply; 10+ messages in thread
From: Gerben Wierda @ 2009-06-07 6:38 UTC (permalink / raw)
To: mailing list for ConTeXt users
[-- Attachment #1: Type: text/plain, Size: 730 bytes --]
verb-sql.tex seems not to work correctly. Is it broken or am I doing
something wrong?
I call it as this:
\definetyping[SQL][option=color,numbering=line,bodyfont=9pt]
\defineoverlay[ifsqoverlay][\overlayfigure{IfSQ-overlay.pdf}]
\setupcolors[state=start]
\setuplayout[leftmargin=10mm,rightmargin=0mm,footer=0mm,header=5mm]
\setuppapersize[A4,landscape][a4,landscape]
\setupbackgrounds[page][background=ifsqoverlay]
\setuptyping[SQL][palet=colorpretty]
\starttext
\typefile[SQL][]{test2.txt}
\stoptext
I get rather strange coloration. I would expect comments to be colored
differently, but only start and end character are. When I run PL/SQL
through the formatter, variable names as bar_foo get only the _
colored, etc.
[-- Attachment #2: testsql2.pdf --]
[-- Type: application/pdf, Size: 56173 bytes --]
[-- Attachment #3: Type: text/plain, Size: 1 bytes --]
[-- Attachment #4: Type: text/plain, Size: 487 bytes --]
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-07 6:38 Pretty print SQL broken? Or am I doing something wrong? Gerben Wierda
@ 2009-06-08 7:59 ` Berend de Boer
2009-06-08 22:12 ` Gerben Wierda
0 siblings, 1 reply; 10+ messages in thread
From: Berend de Boer @ 2009-06-08 7:59 UTC (permalink / raw)
To: mailing list for ConTeXt users
>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
Gerben> verb-sql.tex seems not to work correctly. Is it broken or
Gerben> am I doing something wrong?
What if you use lowercase?
--
Cheers,
Berend.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-08 7:59 ` Berend de Boer
@ 2009-06-08 22:12 ` Gerben Wierda
2009-06-11 12:06 ` Gerben Wierda
2009-06-11 12:22 ` Berend de Boer
0 siblings, 2 replies; 10+ messages in thread
From: Gerben Wierda @ 2009-06-08 22:12 UTC (permalink / raw)
To: mailing list for ConTeXt users
On 8 Jun 2009, at 09:59, Berend de Boer wrote:
>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>
> Gerben> verb-sql.tex seems not to work correctly. Is it broken or
> Gerben> am I doing something wrong?
>
> What if you use lowercase?
For 'SQL' I assume I should use 'sql'. When I do that, exactly the
same happens.
Yours,
Gerben
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-08 22:12 ` Gerben Wierda
@ 2009-06-11 12:06 ` Gerben Wierda
2009-06-11 13:05 ` Hans Hagen
2009-06-11 12:22 ` Berend de Boer
1 sibling, 1 reply; 10+ messages in thread
From: Gerben Wierda @ 2009-06-11 12:06 UTC (permalink / raw)
To: mailing list for ConTeXt users
Nobody has a solution for my problem with non-working colouration of
code?
G
On 9 Jun 2009, at 00:12, Gerben Wierda wrote:
>
> On 8 Jun 2009, at 09:59, Berend de Boer wrote:
>
>>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>>
>> Gerben> verb-sql.tex seems not to work correctly. Is it broken or
>> Gerben> am I doing something wrong?
>>
>> What if you use lowercase?
>
> For 'SQL' I assume I should use 'sql'. When I do that, exactly the
> same happens.
>
> Yours,
>
> Gerben
>
> ___________________________________________________________________________________
> If your question is of interest to others as well, please add an
> entry to the Wiki!
>
> maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
> webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
> archive : https://foundry.supelec.fr/projects/contextrev/
> wiki : http://contextgarden.net
> ___________________________________________________________________________________
>
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-08 22:12 ` Gerben Wierda
2009-06-11 12:06 ` Gerben Wierda
@ 2009-06-11 12:22 ` Berend de Boer
2009-06-15 22:27 ` Gerben Wierda
2009-06-15 22:38 ` Gerben Wierda
1 sibling, 2 replies; 10+ messages in thread
From: Berend de Boer @ 2009-06-11 12:22 UTC (permalink / raw)
To: mailing list for ConTeXt users
>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
Gerben> exactly the same happens.
I mean "select" instead of "SELECT".
--
Groetjes,
Berend.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-11 12:06 ` Gerben Wierda
@ 2009-06-11 13:05 ` Hans Hagen
2009-06-15 22:25 ` Gerben Wierda
0 siblings, 1 reply; 10+ messages in thread
From: Hans Hagen @ 2009-06-11 13:05 UTC (permalink / raw)
To: mailing list for ConTeXt users
Gerben Wierda wrote:
> Nobody has a solution for my problem with non-working colouration of code?
the sql filter in mkii was not written by me ...
(in mkiv we hav eno sql filter yet)
Hans
-----------------------------------------------------------------
Hans Hagen | PRAGMA ADE
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: 038 477 53 69 | fax: 038 477 53 74 | www.pragma-ade.com
| www.pragma-pod.nl
-----------------------------------------------------------------
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-11 13:05 ` Hans Hagen
@ 2009-06-15 22:25 ` Gerben Wierda
0 siblings, 0 replies; 10+ messages in thread
From: Gerben Wierda @ 2009-06-15 22:25 UTC (permalink / raw)
To: mailing list for ConTeXt users
On 11 Jun 2009, at 15:05, Hans Hagen wrote:
> Gerben Wierda wrote:
>> Nobody has a solution for my problem with non-working colouration
>> of code?
>
> the sql filter in mkii was not written by me ...
So, who did? Or is there documentation on how this works so I can look
at it myself?
G
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-11 12:22 ` Berend de Boer
@ 2009-06-15 22:27 ` Gerben Wierda
2009-06-15 22:38 ` Gerben Wierda
1 sibling, 0 replies; 10+ messages in thread
From: Gerben Wierda @ 2009-06-15 22:27 UTC (permalink / raw)
To: mailing list for ConTeXt users
On 11 Jun 2009, at 14:22, Berend de Boer wrote:
>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>
> Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
> Gerben> exactly the same happens.
>
> I mean "select" instead of "SELECT".
Maakt geen verschil.
Gerben
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-11 12:22 ` Berend de Boer
2009-06-15 22:27 ` Gerben Wierda
@ 2009-06-15 22:38 ` Gerben Wierda
2009-06-24 9:18 ` Berend de Boer
1 sibling, 1 reply; 10+ messages in thread
From: Gerben Wierda @ 2009-06-15 22:38 UTC (permalink / raw)
To: mailing list for ConTeXt users
On 11 Jun 2009, at 14:22, Berend de Boer wrote:
>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>
> Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
> Gerben> exactly the same happens.
>
> I mean "select" instead of "SELECT".
Sorry, English: makes no difference.
G
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: Pretty print SQL broken? Or am I doing something wrong?
2009-06-15 22:38 ` Gerben Wierda
@ 2009-06-24 9:18 ` Berend de Boer
0 siblings, 0 replies; 10+ messages in thread
From: Berend de Boer @ 2009-06-24 9:18 UTC (permalink / raw)
To: mailing list for ConTeXt users
>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>>
Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
Gerben> exactly the same happens.
>>
>> I mean "select" instead of "SELECT".
Hi Gerben,
Just following up publicly on the files you sent me, this works for me:
\setuptyping[SQL][palet=colorpretty]
\def\typeSQLfile{\typefile[SQL]}
\starttext
\typeSQLfile{test2.txt}
\stoptext
So changes:
1. Don't define the typing, it's already.
2. use SQL, not sql.
3. Your SQL keywords must be lowercase not UPPERcase, else they won't
get highlighted.
4. comments inside your SQL file trip up the parser, don't know why,
but just leave them out.
--
Groetjes,
Berend.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!
maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage : http://www.pragma-ade.nl / http://tex.aanhet.net
archive : https://foundry.supelec.fr/projects/contextrev/
wiki : http://contextgarden.net
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 10+ messages in thread
end of thread, other threads:[~2009-06-24 9:18 UTC | newest]
Thread overview: 10+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2009-06-07 6:38 Pretty print SQL broken? Or am I doing something wrong? Gerben Wierda
2009-06-08 7:59 ` Berend de Boer
2009-06-08 22:12 ` Gerben Wierda
2009-06-11 12:06 ` Gerben Wierda
2009-06-11 13:05 ` Hans Hagen
2009-06-15 22:25 ` Gerben Wierda
2009-06-11 12:22 ` Berend de Boer
2009-06-15 22:27 ` Gerben Wierda
2009-06-15 22:38 ` Gerben Wierda
2009-06-24 9:18 ` Berend de Boer
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).