emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* [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

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).