* [babel] Bug when exporting to LaTeX
@ 2009-11-30 14:13 Sébastien Vauban
2009-11-30 15:50 ` Eric Schulte
0 siblings, 1 reply; 3+ messages in thread
From: Sébastien Vauban @ 2009-11-30 14:13 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
Hi,
Just found that:
--8<---------------cut here---------------start------------->8---
*** ECM
- faire un script Bash (et =isql=) envoyant un /listing/ de stagiaires;
#+srcname: envoi-stg
#+begin_src sql
DECLARE @dateFmtStyleIn int; SET @dateFmtStyleIn = 120 -- ODBC canonical
DECLARE @dateFmtStyleOut int; SET @dateFmtStyleOut = 103 -- French dd/mm/yyyy
DECLARE @firstDayOfThisMonth smalldatetime
SET @firstDayOfThisMonth = CONVERT(smalldatetime,
CAST(YEAR(GETDATE()) AS char(4)) + '-'
+ CAST(MONTH(GETDATE()) AS char(2)) + '-'
+ '01' + ' 00:00:00',
@dateFmtStyleIn)
DECLARE @now smalldatetime
SET @now = CONVERT(smalldatetime,
CAST(YEAR(GETDATE()) AS char(4)) + '-'
+ CAST(MONTH(GETDATE()) AS char(2)) + '-'
+ CAST(DAY(GETDATE()) AS char(2)) + ' '
+ CAST(DATEPART(hh, GETDATE()) AS char(2)) + ':'
+ CAST(DATEPART(mi, GETDATE()) AS char(2)) + ':'
+ '00',
@dateFmtStyleIn)
SELECT pfiID
FROM dossier
#+end_src
--8<---------------cut here---------------end--------------->8---
gets converted to:
--8<---------------cut here---------------start------------->8---
\subsubsection{ECM}
\label{sec-3.1.7}
\begin{itemize}
\item faire un script Bash (et \texttt{isql}) envoyant un \emph{listing} de stagiaires;
\lstset{language=SQL}
\begin{lstlisting}
DECLARE @dateFmtStyleIn int; SET @dateFmtStyleIn = 120 -- ODBC canonical
DECLARE @dateFmtStyleOut int; SET @dateFmtStyleOut = 103 -- French dd/mm/yyyy
DECLARE @firstDayOfThisMonth smalldatetime
SET @firstDayOfThisMonth = CONVERT(smalldatetime,
CAST(YEAR(GETDATE()) AS char(4)) + '-'
\begin{itemize}
\item CAST(MONTH(GETDATE()) AS char(2)) + '-'
\item '01' + ' 00:00:00',
\end{itemize}
\item CAST(MONTH(GETDATE()) AS char(2)) + '-'
\item CAST(DAY(GETDATE()) AS char(2)) + ' '
\item CAST(DATEPART(hh, GETDATE()) AS char(2)) + ':'
\item CAST(DATEPART(mi, GETDATE()) AS char(2)) + ':'
\item '00',
@dateFmtStyleIn)
SELECT pfiID
FROM dossier
\end{lstlisting}
--8<---------------cut here---------------end--------------->8---
when exporting to LaTeX.
Note the \items in the code...
Best regards,
Seb
--
Sébastien Vauban
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 3+ messages in thread* Re: [babel] Bug when exporting to LaTeX
2009-11-30 14:13 [babel] Bug when exporting to LaTeX Sébastien Vauban
@ 2009-11-30 15:50 ` Eric Schulte
2009-12-01 10:09 ` Sébastien Vauban
0 siblings, 1 reply; 3+ messages in thread
From: Eric Schulte @ 2009-11-30 15:50 UTC (permalink / raw)
To: Sébastien Vauban; +Cc: emacs-orgmode
Hi Sébastien,
Sébastien Vauban <wxhgmqzgwmuf@spammotel.com> writes:
[...]
> when exporting to LaTeX.
>
> Note the \items in the code...
>
I think you may need to update your version of Org-mode (and make sure
that you are loading Org from your git directory and not from the base
of your instillation see [1]). The above snippet exports correctly to
the following for me.
--8<---------------cut here---------------start------------->8---
\subsection*{ECM}
\label{sec-1.1}
\begin{itemize}
\item faire un script Bash (et \texttt{isql}) envoyant un \emph{listing} de stagiaires;
\end{itemize}
\lstset{language=SQL}
\begin{lstlisting}
DECLARE @dateFmtStyleIn int; SET @dateFmtStyleIn = 120 -- ODBC canonical
DECLARE @dateFmtStyleOut int; SET @dateFmtStyleOut = 103 -- French dd/mm/yyyy
DECLARE @firstDayOfThisMonth smalldatetime
SET @firstDayOfThisMonth = CONVERT(smalldatetime,
CAST(YEAR(GETDATE()) AS char(4)) + '-'
+ CAST(MONTH(GETDATE()) AS char(2)) + '-'
+ '01' + ' 00:00:00',
@dateFmtStyleIn)
DECLARE @now smalldatetime
SET @now = CONVERT(smalldatetime,
CAST(YEAR(GETDATE()) AS char(4)) + '-'
+ CAST(MONTH(GETDATE()) AS char(2)) + '-'
+ CAST(DAY(GETDATE()) AS char(2)) + ' '
+ CAST(DATEPART(hh, GETDATE()) AS char(2)) + ':'
+ CAST(DATEPART(mi, GETDATE()) AS char(2)) + ':'
+ '00',
@dateFmtStyleIn)
SELECT pfiID
FROM dossier
\end{lstlisting}
--8<---------------cut here---------------end--------------->8---
Best -- Eric
>
> Best regards,
> Seb
Footnotes:
[1] http://article.gmane.org/gmane.emacs.orgmode/19662/
^ permalink raw reply [flat|nested] 3+ messages in thread* Re: [babel] Bug when exporting to LaTeX
2009-11-30 15:50 ` Eric Schulte
@ 2009-12-01 10:09 ` Sébastien Vauban
0 siblings, 0 replies; 3+ messages in thread
From: Sébastien Vauban @ 2009-12-01 10:09 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
Hi Eric,
"Eric Schulte" wrote:
> Sébastien Vauban <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org> writes:
>
> [...]
>> when exporting to LaTeX.
>>
>> Note the \items in the code...
>
> I think you may need to update your version of Org-mode
Done every couple of days, or so...
> (and make sure that you are loading Org from your git directory and not from
> the base of your instillation see [1]).
Similar symptom. Though, the cause must be different, as, yes, I'm loading Org
from my `~/Downloads/emacs/site-lisp/org-mode' git directory.
> The above snippet exports correctly to the following for me.
>
> \subsection*{ECM}
> \label{sec-1.1}
>
>
> \begin{itemize}
> \item faire un script Bash (et \texttt{isql}) envoyant un \emph{listing} de stagiaires;
> \end{itemize}
> \lstset{language=SQL}
> \begin{lstlisting}
> DECLARE @dateFmtStyleIn int; SET @dateFmtStyleIn = 120 -- ODBC canonical
> DECLARE @dateFmtStyleOut int; SET @dateFmtStyleOut = 103 -- French dd/mm/yyyy
>
> DECLARE @firstDayOfThisMonth smalldatetime
> SET @firstDayOfThisMonth = CONVERT(smalldatetime,
> CAST(YEAR(GETDATE()) AS char(4)) + '-'
> + CAST(MONTH(GETDATE()) AS char(2)) + '-'
> + '01' + ' 00:00:00',
> @dateFmtStyleIn)
>
> DECLARE @now smalldatetime
> SET @now = CONVERT(smalldatetime,
> CAST(YEAR(GETDATE()) AS char(4)) + '-'
> + CAST(MONTH(GETDATE()) AS char(2)) + '-'
> + CAST(DAY(GETDATE()) AS char(2)) + ' '
> + CAST(DATEPART(hh, GETDATE()) AS char(2)) + ':'
> + CAST(DATEPART(mi, GETDATE()) AS char(2)) + ':'
> + '00',
> @dateFmtStyleIn)
>
> SELECT pfiID
> FROM dossier
> \end{lstlisting}
I'm sorry. I did not test sufficiently my code block. This works as well for
me.
Though, when that is part of my bigger document, I have the problem. I will
try to understand what makes it working or failing.
But, yes, an Org file limited to the above does not show any problem...
Best regards,
Seb
--
Sébastien Vauban
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2009-12-01 10:09 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2009-11-30 14:13 [babel] Bug when exporting to LaTeX Sébastien Vauban
2009-11-30 15:50 ` Eric Schulte
2009-12-01 10:09 ` Sébastien Vauban
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
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 read-only IMAP folder(s) and NNTP newsgroup(s).