Помогите с sql ! - оно говорит result must not contain more then one row ...

Bitmag 22.05.2002 17:59

пишу:
$stxt[^string:sql{
select
MID(Text,LOCATE('$form:searchstr',Text)-100,300) as Text
from
pages1
where
Text like '%$form:searchstr%'}]
}

а оно мне:

result must not contain more then one row
select MID(Text,LOCATE('1',Text)-100,300) as Text from pages1 where Text like '%1%'

c:/web/narpos/search.html(154)
exception.type=sql.execute

---