'0'" order by achternaam
was that it?
Olaf van Zandwijk wrote:
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>
> <html>
> <head>
> <title>Huize Marsupilami - Colofon</title>
> <link rel="stylesheet" href="marsupilami.css" type="text/css">
> </head>
>
> <body topmargin="0" marginheight="0" marginwidth="0" bottommargin="0">
> <table cellspacing="0" cellpadding="0" border="0" width="100%">
> <tr class="paginakop">
>
> <if variable="form.room">
> <td align="right" class="paginakop">Bewonersinformatie</td>
> </if>
> <else>
> <td align="right" class="paginakop">(Oud-) Bewonersoverzicht</td>
> </else>
>
> </tr>
> </table>
>
> <if variable="form.room">
> <emit source="sql" host="webfront" query="SELECT *,
> UNIX_TIMESTAMP(geb_datum) AS t,
> LCASE(voornaam) AS foto,
> (TO_DAYS(now()) - TO_DAYS(geb_datum))/365.25 as leeftijd
> FROM persoon
> WHERE kamer='&form.room;'
> LIMIT 1">
>
> <h4>&sql.voornaam; &sql.tussen; &sql.achternaam;</h4>
>
> <img src="images/photos/bewoners/&sql.foto;.jpg" alt="&sql.voornaam;"
> height="108" width="80">
> <table border="0">
>
> <tr class="persoonkop"><td class="persoonkop">Voornaam<td></tr>
> <tr class="persoon"><td>&sql.voornaam;<td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Tussenvoegsel /
> Achternaam<td></tr>
> <tr class="persoon"><td>&sql.tussen; &sql.achternaam;<td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Leeftijd<td></tr>
> <tr class="persoon"><td>&sql.leeftijd;<td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Kamer<td></tr>
> <tr class="persoon"><td>&sql.kamer;<td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Geboortedatum<td></tr>
> <tr class="persoon"><td>
> <date unix-time='&sql.t;' part='date' type='number' />
> <date unix-time='&sql.t;' part='month' type='string' lang='nl' />
> <date unix-time='&sql.t;' part='year' type='number' />
> <td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">E-mail<td></tr>
> <tr class="persoon"><td><a
> href="mailto:&sql.email;">&sql.email;</a><td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">ICQ nummer<td></tr>
> <tr class="persoon"><td>&sql.icq_nr;<td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">ICQ status<td></tr>
> <tr class="persoon"><td><img
> src="http://wwp.icq.com/scripts/online.dll?icq=&sql.icq_nr;&img=5"
> alt="&sql.voornaam; &sql.tussen; &sql.achternaam;"></td></tr>
> </table>
>
>
> <table border="0">
>
> <tr class="persoonkop"><td class="persoonkop">Nickname<td></tr>
> <tr class="persoon"><td>&sql.nick; <td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Homepage<td></tr>
> <tr class="persoon"><td><a href="&sql.homepage;"
> target="_new">&sql.homepage;</a> <td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Quote of the Person<td></tr>
> <tr class="persoon"><td>&sql.quote; <td></tr>
>
> <tr class="persoonkop"><td class="persoonkop">Lijfspreuk<td></tr>
> <tr class="persoon"><td><i>&sql.spreuk;</i> <td></tr>
>
> </table>
>
> </emit>
> </if>
>
> <else>
>
> <h4>Bewoners</h4>
>
> <p>
>
> <table border="0">
> <tr class="persoonkop"><td> </td><td>Voornaam |</td><td>Tussenv.
> |</td><td>Achternaam |</td><td>Kamer<td></tr>
> <emit source="sql" host="webfront" query="select * from persoon where
> kamer not like '0' order by achternaam">
> <tr class="persoon"><td><a
> href="main.rxml?page=bewoner&room=&sql.kamer;">info</a>
>
</td><td>&sql.voornaam;</td><td>&sql.tussen; </td><td>&sql.achternaam;</td><td>&sql.kamer;</td</tr>
> </emit>
> </table>
>
> </p>
>
> <br />
>
> <h4>Oud-Bewoners</h4>
>
> <p>
>
> <table border="0">
> <tr class="persoonkop"><td>Voornaam |</td><td>Tussenv.
> |</td><td>Achternaam |</td></tr>
> <emit source="sql" host="webfront" query="select * from persoon where
> kamer like '0'" order by achternaam>
> <tr
>
class="persoon"><td>&sql.voornaam;</td><td>&sql.tussen; </td><td>&sql.achternaam;</td></tr>
> </emit>
> </table>
>
> </p>
>
> </else>
>
> <br/>
>
> </body>
> </html>
>
>
> Rolf Johansson wrote:
>
>> Olaf van Zandwijk <<olaf[at]scintilla.utwente.nl>> writes:
>>
>>> I've got an error in a rxml page, and I can't figure out why. I
>>> request a page "bewoner.rxml?room=106". This gives me the backtrace
>>> below. When I don't give the 'room' argument, the RXML backtrace is
>>> '<else>' instead of '<if variable="form.room">'
>>> What is the possible cause of a 'Indexing the NULL value with "type".' error?
>>>
>> Maybe you could post the bewoner.rxml source too? It's kind of hard guessing
>> what could be the cause.
>>
>> /Rolf
>>
>
>
|