Two query issues -- need help

2001-02-20 Thread Matteo Dell'Orto
Hi all, I have two little problems: 1.In a query, I get errors when a record's field contains the ' character. In fact the query starts like ! sql query "insert into dbase values ('@qfield1', '@qfield2'...). 2.I need to split query results in multiple pages (e.g. with a next button) so that my

RE: Two query issues -- need help

2001-02-20 Thread Alan Halls
-- From: Matteo Dell'Orto [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 10:32 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Two query issues -- need help Hi all, I have two little problems: 1.In a query, I get errors when a record's field contains the ' character. In fact th

Re: RE: Two query issues -- need help

2001-02-20 Thread Ed Carp
Alan Halls ([EMAIL PROTECTED]) writes: Here is what our company uses to do the page division on adoptablekids.com I have used it for a few other applications with minimum changes This code would give you five per page. sql detail=rhs pgsize="5" select * from profile