[Zope] Finding out how many rows is selected in database
Gitte Wange
gitte@mmmanager.org
05 Apr 2001 21:33:37 -0100
On 05 Apr 2001 15:05:57 -0400, Thomas B. Passin wrote:
> Gitte Wange wrote -
>
>
> Well if you make MySQL select the next_id for you - what happens then if
> there
> are no records in the table? Will it then return 1 (if you say select
> max(id)+1)
> ???
>
> It ***should*** return null (that is, 1+null-->null). SQLAnywhere does (I
> just tested it for you). But I don't know if MySQL acts correctly or not.
> I don't have it installed. Just make a table with one column, don't
> populate it, and try it out.
>
> Cheers,
>
> Tom P
FYI - MySQL also returns null
So I presume that you can make a test like this:
<dtml-if FindAnyRecords>
<dtml-call expr="InsertRecordWithNext_id(next_id=next_id)">
<dtml-else>
<dtml-call expr="InsertRecordWithNext_id(next_id=1)">
</dtml-if>
I have sensed that some people on this list is a bit "anoyed" (perhaps a
wrong word) about my postings - I am sorry to say this but the Zope
documentation isn't the best :-)
Regards,
Gitte