<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
thx mate,<br>
<br>
but also ' must be escaped ' has to become \'<br>
<br>
I got it, thanks for the help, u got me to the right way :)<br>
<br>
Olivier<br>
<br>
trixter aka Bret McDanel a écrit :
<blockquote cite="mid1153143143.26522.24.camel@trixter.home.tld"
type="cite">
<pre wrap="">On Mon, 2006-07-17 at 15:17 +0200, olivier.taylor wrote:
</pre>
<blockquote type="cite">
<pre wrap="">email message attachment (where is the error?)
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">SELECT\ left(Customer.balance,instr(Customer.balance,'.')-1)\ FROM\
Customer\ Inner\ Join\ subscriber\ ON\ subscriber.customer_id\ =\
Customer.id\ WHERE\ subscriber.username\ =\ ${CALLERIDNAME}
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
asterisk translates , to | then processes it. try \, instead see if
that cures your errors.
</pre>
</blockquote>
</body>
</html>