General ⇒ Display source code in latex

[Dooley]

Hey all,

I have a few questions on inserting source code into a latex document.
I'm using the package listings, but its not going great.

Firstly I'm having a basic problem, the code I'm using doesn't go onto a new line,
so all of my code gets cut off.

Here's how I set the system to implement SQL.

Code: Select all

\lstset{language=SQL,frame=ltrb,framesep=5pt,basicstyle=\normalsize,
  keywordstyle=\ttfamily\color{OliveGreen},
 identifierstyle=\ttfamily\color{CadetBlue}\bfseries, 
 commentstyle=\color{Brown},
 stringstyle=\ttfamily,
 showstringspaces=ture}

And here is where I display some source code.

Code: Select all

\begin{lstlisting}
 "SELECT username FROM members WHERE username = '$inputuser' AND user_password = '$input_password' LIMIT 1;"
\end{lstlisting} 

For some reason this is also putting in an odd character where there should be spaces.

My second question is does anyone know if its possible to use multiple languages in one document. I would like to use both PHP and MySQL.

Thanks!

[localghost]

Add a corresponding option in the parameter list for your listings.

Code: Select all

\lstset{
  breaklines=true,                                     % line wrapping on
  language=SQL,
  frame=ltrb,
  framesep=5pt,
  basicstyle=\normalsize,
  keywordstyle=\ttfamily\color{OliveGreen},
  identifierstyle=\ttfamily\color{CadetBlue}\bfseries,
  commentstyle=\color{Brown},
  stringstyle=\ttfamily,
  showstringspaces=ture
}

You can also give that parameter as an optional argument to the lstlisting environment as local setting.

Code: Select all

\begin{lstlisting}[breaklines=true]
  "SELECT username FROM members WHERE username = '$inputuser' AND user_password = '$input_password' LIMIT 1;"
\end{lstlisting}

Now you only have to choose how you use that.


MfG
Thorsten¹