Re: still: using fetchrow_hashref()

2001-06-27 Thread Chas Owens
Remember that count(*) will only work in those cases where nothing gets inserted in the time between the two select statements. You may experience odd bugs. Comment the area around this code well. On 27 Jun 2001 16:20:29 +0200, Marcus Willemsen wrote: > Thanks tried the row count with SELECT C

Re: still: using fetchrow_hashref()

2001-06-27 Thread Marcus Willemsen
Thanks tried the row count with SELECT COUNT(*) and it works perfectly Thanks a lot

Re: still: using fetchrow_hashref()

2001-06-26 Thread Chas Owens
""rows"" $rv = $sth->rows; Returns the number of rows affected by the last row affecting command, or -1 if the number of rows is not known or not availĀ­ able. Generally, you can only rely on a row count after a non-"SELECT" "execute" (for some specifi

still: using fetchrow_hashref()

2001-06-26 Thread Marcus Willemsen
Thanks for the advise. I'll give it a try. Is there a possiblity to determin the size of the search result, i.e. did the search yield five headlines three or whatever number? And how do I access the elements. Grateful for answers Marcus At 09:51 25.06.2001 -0700, you wrote: >You might cons

Re: using fetchrow_hashref()

2001-06-25 Thread C.J. Collier
You might consider Apache::DBI. I hear it does what you're interested in doing, but I haven't done much research on it. Good luck! Check out search.cpan.org :) C.J. cpan> i Apache::DBI Module id = Apache::DBI DESCRIPTION Persistent DBI connection mgmt. CPAN_USERID MERGL (Edmund Merg

using fetchrow_hashref()

2001-06-25 Thread Marcus Willemsen
Hi I'm new to Perl and programming in general, I wrote (with the help of Learning Perl) the following cgi-scripte to get headlines out of a database called Message. And it works okay. The next step would be to enable a user to click on the headline that interest him and to display the rest of