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@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
