the last one worked. thanksalot dennis ----- Original Message ----- From: "Pierre van Rooden" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 13, 2002 11:56 AM Subject: Re: list constraint question
> dennis kobus wrote: > > how can i list users whose lastname start with 'a' (or b..or in short $register)? > > > > <mm:list... constraints="substr(users.lastname,1,1)=$register" ....> > > doesn't work. > > <mm:list... constraints="substr([users.lastname],1,1)='$register'" .. > > > (note the quotes), or: > > <mm:list... constraints="[users.lastname] like '$register%'" .. > > > > > -- > Pierre van Rooden > Mediapark, C 107 tel. +31 (0)35 6772815 > "So long, and thanks for all the fish" > >
