headers
Arne Kroeger | 1 Mar 2006 11:33
Favicon

oracle ADODB_ASSOC_CASE function

Hi folks,

I had to use this driver and I needed the ADODB_ASSOC_CASE function.  
I realized after readings posts etc. that this driver has not  
implement this function, so I made it by myself and I hope that you  
can use it.

./adodb/drivers/oracle.php
line: 272

    function _fetch($ignore_fields=false) {
// should remove call by reference, but ora_fetch_into requires it in  
4.0.3pl1
		if($this->fetchMode & ADODB_FETCH_ASSOC){
		
             $lowercase = (ADODB_ASSOC_CASE == 0);
             $uppercase = (ADODB_ASSOC_CASE == 1);
             $probe = array();
              <at> ora_fetch_into($this->_queryID,& 
$probe,ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC);
             $arr2 = array();
             $arrK = array_keys($probe);
             $arrV = array_values($probe);
             if (is_integer($arrK[$h])) $arrK[$h] = $arrV[$h];
             else {
			    if ($lowercase){
			        $counter = count($arrK);
			        $Full = array();
			        $ev = array();
			            for ($i = 0; $i < $counter; $i++){
(Continue reading)

Permalink | Reply | 0 comments |
headers
Darius | 2 Mar 2006 10:17
Picon

Re: adodb execute method

Hi all,

we have also the same problem.
With selectLimit(..) I retrieve only needed rows. But there need to know count of all rows.
In MySQL I can do this with SQL_CALC_FOUND_ROWS. What is solution in AdoDB ?

Best regards,
Darius


Marcin Szkudlarek wrote:
 
 > Thanks for reply. You are right - I want to implement paging but it"s
 > not that simple. I want to select 100 rows from 50k table but I don"t
 > know how much rows I have to fetch to get the 100 .. it could be in
 > the WORST case the last 100 from the whole 50k table. I"t because I"m
 > checking access rights to every row in php and then diplaying it or
 > not. So your example with selecting only first 100 rows from the table
 > woudn"t work here. If there isn"t a way to fetch the result row by row
 > I"ll have to reimplement some ugly code.
 
> You have just described the classic poorly designed application.  ;-)
 
 >If there"s something in the data that you can look at and determind
 >access rights in PHP, then you should move that logic to your SQL query
 >and select only the rows you"re interested in.
 
 >
 > Best regards,
 >
(Continue reading)

Permalink | Reply | 501 comments |
headers
Alfredo Yong | 2 Mar 2006 13:28
Picon

Re: Re: adodb execute method

Hi Darious,
 
I use a code like this:
 
$SQL = "select * from table1";
$SQLCount = "select count(*) from ($SQL)";
 
Then I use $SQLCount to know the row count, and $SQL with a SelectLimit
 
But Im afraid the cost of this two queries is more than double the original ($SQL) query
 
Any better idea?

greetings,
 
On 3/2/06, Darius <darius <at> m2t.lt> wrote:
Hi all,

we have also the same problem.
With selectLimit(..) I retrieve only needed rows. But there need to know count of all rows.
In MySQL I can do this with SQL_CALC_FOUND_ROWS. What is solution in AdoDB ?

Best regards,
Darius


Marcin Szkudlarek wrote:

> Thanks for reply. You are right - I want to implement paging but it"s
> not that simple. I want to select 100 rows from 50k table but I don"t
> know how much rows I have to fetch to get the 100 .. it could be in
> the WORST case the last 100 from the whole 50k table. I"t because I"m
> checking access rights to every row in php and then diplaying it or
> not. So your example with selecting only first 100 rows from the table
> woudn"t work here. If there isn"t a way to fetch the result row by row
> I"ll have to reimplement some ugly code.

> You have just described the classic poorly designed application.  ;-)

>If there"s something in the data that you can look at and determind
>access rights in PHP, then you should move that logic to your SQL query
>and select only the rows you"re interested in.

>
> Best regards,
>
> Marcin Szkudlarek
>
> On Fri, 24 Jun 2005, Emil Zegers wrote:
>
>> What do you exactly mean by "fetching the rows"?
>>
>> If you want to do a row count then your query could be something like
>> "SELECT COUNT(*) FROM TABLENAME"
>>
>> If you want to get only a certain amount of rows you can do something
>> like "SELECT TOP 100 * FROM TABLENAME".
>>
>> Also take a look at paging options.
>>
>> If you do want to get the data in a recordset for manipulation you
>> really have to fetch it.
>>
>> You can limit the data (and thus the query time) by selecting only the
>> columns needed.
>>
>> Regards,
>>
>> Emil
>>
>> -----Original Message-----
>> From: adodb-general-admin <at> li...
>> [mailto:adodb-general-admin <at> li ...] On Behalf Of Marcin
>> Szkudlarek
>> Sent: vrijdag 24 juni 2005 11:49
>> To: adodb-general <at> li...
>> Subject: [ADodb-general] adodb execute method
>>
>> Hi!
>>
>> I"m using ado 4.62 with oracle 8.17. My question:
>> is there a way to execute select query without getting all the results?
>> I have a table with about 50k records and calling only the execute
>> method takes about 1,8s. What I want to achieve is fetching the rows
>> without having to get all the data at once.
>>
>> Thanks.
>>
>> Marcin Szkudlarek



--
Alfredo Yong
Sistemas web
Permalink | Reply | 501 comments |
headers
Darius | 3 Mar 2006 10:21
Picon

Re: Re: adodb execute method

Hi Alfredo,
 
my code looks like this:
 
$sql = "Select * from table order by x"
$sqlCount = "Select count(*) from table" (without order and limit)
 
But it'is not good for performance.
 
Best regards,
Darius

----- Original Message -----
To: Darius
Sent: 2006 m. kovo 2 d. 14:28
Subject: Re: [ADodb-general] Re: adodb execute method

Hi Darious,
 
I use a code like this:
 
$SQL = "select * from table1";
$SQLCount = "select count(*) from ($SQL)";
 
Then I use $SQLCount to know the row count, and $SQL with a SelectLimit
 
But Im afraid the cost of this two queries is more than double the original ($SQL) query
 
Any better idea?

greetings,
 
On 3/2/06, Darius <darius <at> m2t.lt> wrote:
Hi all,

we have also the same problem.
With selectLimit(..) I retrieve only needed rows. But there need to know count of all rows.
In MySQL I can do this with SQL_CALC_FOUND_ROWS. What is solution in AdoDB ?

Best regards,
Darius


Marcin Szkudlarek wrote:

> Thanks for reply. You are right - I want to implement paging but it"s
> not that simple. I want to select 100 rows from 50k table but I don"t
> know how much rows I have to fetch to get the 100 .. it could be in
> the WORST case the last 100 from the whole 50k table. I"t because I"m
> checking access rights to every row in php and then diplaying it or
> not. So your example with selecting only first 100 rows from the table
> woudn"t work here. If there isn"t a way to fetch the result row by row
> I"ll have to reimplement some ugly code.

> You have just described the classic poorly designed application.  ;-)

>If there"s something in the data that you can look at and determind
>access rights in PHP, then you should move that logic to your SQL query
>and select only the rows you"re interested in.

>
> Best regards,
>
> Marcin Szkudlarek
>
> On Fri, 24 Jun 2005, Emil Zegers wrote:
>
>> What do you exactly mean by "fetching the rows"?
>>
>> If you want to do a row count then your query could be something like
>> "SELECT COUNT(*) FROM TABLENAME"
>>
>> If you want to get only a certain amount of rows you can do something
>> like "SELECT TOP 100 * FROM TABLENAME".
>>
>> Also take a look at paging options.
>>
>> If you do want to get the data in a recordset for manipulation you
>> really have to fetch it.
>>
>> You can limit the data (and thus the query time) by selecting only the
>> columns needed.
>>
>> Regards,
>>
>> Emil
>>
>> -----Original Message-----
>> From: adodb-general-admin <at> li...
>> [mailto:adodb-general-admin <at> li ...] On Behalf Of Marcin
>> Szkudlarek
>> Sent: vrijdag 24 juni 2005 11:49
>> To: adodb-general <at> li...
>> Subject: [ADodb-general] adodb execute method
>>
>> Hi!
>>
>> I"m using ado 4.62 with oracle 8.17. My question:
>> is there a way to execute select query without getting all the results?
>> I have a table with about 50k records and calling only the execute
>> method takes about 1,8s. What I want to achieve is fetching the rows
>> without having to get all the data at once.
>>
>> Thanks.
>>
>> Marcin Szkudlarek



--
Alfredo Yong
Sistemas web
Permalink | Reply | 0 comments |
headers
Alejandro Michelin Salomon ( Adinet | 3 Mar 2006 12:32
Picon
Picon
Favicon

Re: Re: adodb execute method


Hi Alfredo :

Try this :

SELECT COUNT(*)
  FROM table1

Alejandro Michelin Salomon
Porto Alegre
Brasil

Message: 2
Date: Thu, 2 Mar 2006 07:28:32 -0500
From: "Alfredo Yong" <alfredoyong <at> gmail.com>
Reply-To: alfredo <at> alfredoyong.com
To: Darius <darius <at> m2t.lt>
Subject: Re: [ADodb-general] Re: adodb execute method
Cc: adodb-general <at> lists.sourceforge.net

------=_Part_5594_22239041.1141302512018
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi Darious,

I use a code like this:

$SQL =3D "select * from table1";
$SQLCount =3D "select count(*) from ($SQL)";

Then I use $SQLCount to know the row count, and $SQL with a SelectLimit

But Im afraid the cost of this two queries is more than double the original
($SQL) query

Any better idea?

greetings,

On 3/2/06, Darius <darius <at> m2t.lt> wrote:
>
> Hi all,
>
> we have also the same problem.
> With selectLimit(..) I retrieve only needed rows. But there need to 
> know count of all rows. In MySQL I can do this with 
> SQL_CALC_FOUND_ROWS. What is solution in AdoD=
B
> ?
>
> Best regards,
> Darius
>
>
> Marcin Szkudlarek wrote:
>
> > Thanks for reply. You are right - I want to implement paging but 
> > it"s not that simple. I want to select 100 rows from 50k table but I 
> > don"t know how much rows I have to fetch to get the 100 .. it could 
> > be in the WORST case the last 100 from the whole 50k table. I"t 
> > because I"m checking access rights to every row in php and then 
> > diplaying it or not. So your example with selecting only first 100 
> > rows from the table woudn"t work here. If there isn"t a way to fetch 
> > the result row by row I"ll have to reimplement some ugly code.
>
> > You have just described the classic poorly designed application.  
> > ;-)
>
> >If there"s something in the data that you can look at and determind 
> >access rights in PHP, then you should move that logic to your SQL 
> >query and select only the rows you"re interested in.
>
> >
> > Best regards,
> >
> > Marcin Szkudlarek
> >
> > On Fri, 24 Jun 2005, Emil Zegers wrote:
> >
> >> What do you exactly mean by "fetching the rows"?
> >>
> >> If you want to do a row count then your query could be something 
> >> like "SELECT COUNT(*) FROM TABLENAME"
> >>
> >> If you want to get only a certain amount of rows you can do 
> >> something like "SELECT TOP 100 * FROM TABLENAME".
> >>
> >> Also take a look at paging options.
> >>
> >> If you do want to get the data in a recordset for manipulation you 
> >> really have to fetch it.
> >>
> >> You can limit the data (and thus the query time) by selecting only 
> >> the columns needed.
> >>
> >> Regards,
> >>
> >> Emil
> >>
> >> -----Original Message-----
> >> From: adodb-general-admin <at> li... [mailto:adodb-general-admin <at> li...] 
> >> On Behalf Of Marcin Szkudlarek
> >> Sent: vrijdag 24 juni 2005 11:49
> >> To: adodb-general <at> li...
> >> Subject: [ADodb-general] adodb execute method
> >>
> >> Hi!
> >>
> >> I"m using ado 4.62 with oracle 8.17. My question:
> >> is there a way to execute select query without getting all the 
> >> results=
?
> >> I have a table with about 50k records and calling only the execute 
> >> method takes about 1,8s. What I want to achieve is fetching the 
> >> rows without having to get all the data at once.
> >>
> >> Thanks.
> >>
> >> Marcin Szkudlarek

--
Alfredo Yong
Sistemas web

------=_Part_5594_22239041.1141302512018
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>Hi Darious,</div>
<div>&nbsp;</div>
<div>I use a code like this:</div>
<div>&nbsp;</div>
<div>$SQL =3D &quot;select * from table1&quot;;</div> <div>$SQLCount =3D
&quot;select count(*) from ($SQL)&quot;;</div> <div>&nbsp;</div> <div>Then I
use $SQLCount to know the row count, and $SQL with a SelectLimi= t</div>
<div>&nbsp;</div> <div>But Im afraid the cost of this two queries is more
than double the ori= ginal ($SQL) query</div> <div>&nbsp;</div> <div>Any
better idea?</div> <div><br>greetings,<br>&nbsp;</div>
<div><span class=3D"gmail_quote">On 3/2/06, <b class=3D"gmail_sendername">D=
arius</b> &lt;<a href=3D"mailto:darius <at> m2t.lt">darius <at> m2t.lt</a>&gt; wrote:=
</span> <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex;
MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi all,<br><br>we
have also the = same problem.<br>With selectLimit(..) I retrieve only needed
rows. But ther= e need to know count of all rows. <br>In MySQL I can do this
with SQL_CALC_FOUND_ROWS. What is solution in Ad= oDB ?<br><br>Best
regards,<br>Darius<br><br><br>Marcin Szkudlarek wrote:<br=
><br>&gt; Thanks for reply. You are right - I want to implement paging 
>but =
it&quot;s
<br>&gt; not that simple. I want to select 100 rows from 50k table but I do=
n&quot;t<br>&gt; know how much rows I have to fetch to get the 100 .. it co=
uld be in<br>&gt; the WORST case the last 100 from the whole 50k table. I&q=
uot;t because I&quot;m <br>&gt; checking access rights to every row in php
and then diplaying it o= r<br>&gt; not. So your example with selecting only
first 100 rows from the = table<br>&gt; woudn&quot;t work here. If there
isn&quot;t a way to fetch th= e result row by row <br>&gt; I&quot;ll have to
reimplement some ugly code.<br><br>&gt; You have=  just described the
classic poorly designed application.&nbsp;&nbsp;;-)<br>= <br>&gt;If
there&quot;s something in the data that you can look at and dete= rmind<br>
&gt;access rights in PHP, then you should move that logic to your SQL query=
<br>&gt;and select only the rows you&quot;re interested in.<br><br>&gt;<br>=
&gt; Best regards,<br>&gt;<br>&gt; Marcin Szkudlarek<br>&gt;<br>&gt; On Fri=
, 24 Jun 2005, Emil Zegers wrote: <br>&gt;<br>&gt;&gt; What do you exactly
mean by &quot;fetching the rows&qu= ot;?<br>&gt;&gt;<br>&gt;&gt; If you want
to do a row count then your query = could be something like<br>&gt;&gt;
&quot;SELECT COUNT(*) FROM TABLENAME&qu= ot; <br>&gt;&gt;<br>&gt;&gt; If you
want to get only a certain amount of rows y= ou can do something<br>&gt;&gt;
like &quot;SELECT TOP 100 * FROM TABLENAME&= quot;.<br>&gt;&gt;<br>&gt;&gt;
Also take a look at paging options.<br>&gt;&= gt; <br>&gt;&gt; If you do
want to get the data in a recordset for manipulation=  you<br>&gt;&gt;
really have to fetch it.<br>&gt;&gt;<br>&gt;&gt; You can l= imit the data
(and thus the query time) by selecting only the<br>&gt;&gt; c= olumns
needed. <br>&gt;&gt;<br>&gt;&gt; Regards,<br>&gt;&gt;<br>&gt;&gt;
Emil<br>&gt;&gt;<=
br>&gt;&gt; -----Original Message-----<br>&gt;&gt; From: 
br>adodb-general-admi=
n <at> li...<br>&gt;&gt; [mailto:<a href=3D"mailto:adodb-general-admin <at> li">adodb=
-general-admin <at> li
</a>...] On Behalf Of Marcin<br>&gt;&gt; Szkudlarek<br>&gt;&gt; Sent: vrijd=
ag 24 juni 2005 11:49<br>&gt;&gt; To: adodb-general <at> li...<br>&gt;&gt; Subje=
ct: [ADodb-general] adodb execute method<br>&gt;&gt;<br>&gt;&gt; Hi!<br>
&gt;&gt;<br>&gt;&gt; I&quot;m using ado 4.62 with oracle 8.17. My question:=
<br>&gt;&gt; is there a way to execute select query without getting all the=
results?<br>&gt;&gt; I have a table with about 50k records and calling onl=
y the execute <br>&gt;&gt; method takes about 1,8s. What I want to achieve
is fetching th= e rows<br>&gt;&gt; without having to get all the data at
once.<br>&gt;&gt;<=
br>&gt;&gt; Thanks.<br>&gt;&gt;<br>&gt;&gt; Marcin 
br>Szkudlarek</blockquote>
</div><br><br clear=3D"all"><br>-- <br>Alfredo Yong<br>Sistemas web=20

------=_Part_5594_22239041.1141302512018--

--__--__--

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

End of ADodb-general Digest

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.1/273 - Release Date: 2/3/2006

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.1/273 - Release Date: 2/3/2006

--

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.1/273 - Release Date: 2/3/2006

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
Permalink | Reply | 0 comments |
headers
Stephen Musgrave | 8 Mar 2006 03:40

Session cookie expiration issue

Hello -

I am using ADO DB for the first time and am also using the Session features.  I am having a problem with session ending while the users are active.

The session is set at 20 minutes.  Session is used to log into a password protected area.  Twenty minutes after the session id cookie is set, the user is forced to log out because their cookie has expired, even if they have remained active during that twenty minutes.  I have looked at the expiry field for that user and that date keeps on getting set 20 minutes into the future.  In analyzing the cookie expire date after loading a page, it doesn't change from the previous value.  In fact, it's never updated after it is originally set.  At 20:01, the cookie expires.

Why isn't the cookie expiration time being reset with every refresh?  Am I misunderstanding something here?  Do secure cookies have anything to do with it?

PHP:  4.4.2
MySQL:   5.0.18


Thanks,


Stephen


Permalink | Reply | 0 comments |
headers
José Luis Gordo Romero | 17 Mar 2006 21:09
Picon
Gravatar

function Lens_ParseArgs adodb-datadict.inc.php problem (Oracle)

Hello,

I call the function CreateTableSql (adodb-datadict.inc.php) with a
field definition like:

vfs_created D NOTNULL DEFAULT TO_DATE('1970-01-01','YYYY-MM-DD')
(Generate with the dbdate function)

The function CreateTableSql call to the _GenFields function that uses the
Lens_ParseArgs function to strip the table fields definition.
Lens_ParseArgs convert TO_DATE('1970-01-01','YYYY-MM-DD') in two items:
TO_DATE and '1970-01-01','YYYY-MM-DD'
Then _GenFields only treat TO_DATE and the table is not created.
vfs_created DATE DEFAULT 'TO_DATE' NOT NULL

I miss something??

PHP 5.1
V4.65 22 probed with 4.8 too.

Thanks in advance!

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
Permalink | Reply | 0 comments |
headers
Renne Rocha | 25 Mar 2006 21:27
Picon
Gravatar

Problem with RecordCount function

  Hello,

  I am trying to use ADODB to access a PostgreSQL 8.1.2 database. e
connection works well. But after using a select query I tried to get
the number of the rows in the result. I use the function RecordCount,
but I receive an error message saying that this function doesn't
exist.

  I searched on the internet, but I found that postgres permit the use
of this function. What could I do to solve this problem?

  A piece of my code:
<?php
      $db = NewADOConnection($database_type);
      $db-> Connect($host, $user, $password, $database);
      $query = "SELECT * FROM usuarios WHERE usuarios.str_usuario =
'".$str_usuario."'";
      if($db->Execute($busca) === false)
      {
        print $db->ErrorMsg().'<BR>';
        return false;
      } else
      {
        if($db->RecordCount()==0) { return false; }
        return true;
      }
?>

  The error message:
  Fatal error: Call to undefined function: recordcount() in
/srv/www/htdocs/class.usuario.php on line 60

  Thanks for any help.

  Renne

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
Permalink | Reply | 0 comments |
headers
Alejandro Michelin Salomon ( Adinet | 26 Mar 2006 19:10
Picon
Picon
Favicon

RE: Problem with RecordCount function (Renne Rocha)


Hi Renne :
<?php
      $db =3D NewADOConnection($database_type);
      $db-> Connect($host, $user, $password, $database);
      $sSql = "SELECT * FROM usuarios WHERE usuarios.str_usuario =3D
'".$str_usuario."'";

      $rs = $db->Execute( $sSql );

	if( !$rs )
	{
          print $db->ErrorMsg().'<BR>';
          return false;
      } else {
         $rs->RecordCount()
      }
     return true;
?>

RecordCount is Resultset properti, not a connection properti.

Try this.

Alejandro Michelin Salomon
Porto Alegre
Brasil

-->-----Mensagem original-----
-->De: adodb-general-admin <at> lists.sourceforge.net 
-->[mailto:adodb-general-admin <at> lists.sourceforge.net] Em nome 
-->de adodb-general-request <at> lists.sourceforge.net
-->Enviada em: domingo, 26 de março de 2006 01:02
-->Para: adodb-general <at> lists.sourceforge.net
-->Assunto: ADodb-general digest, Vol 1 #107 - 1 msg
-->
-->
-->Send ADodb-general mailing list submissions to
-->	adodb-general <at> lists.sourceforge.net
-->
-->To subscribe or unsubscribe via the World Wide Web, visit
-->	https://lists.sourceforge.net/lists/listinfo/adodb-general
-->or, via email, send a message with subject or body 'help' to
-->	adodb-general-request <at> lists.sourceforge.net
-->
-->You can reach the person managing the list at
-->	adodb-general-admin <at> lists.sourceforge.net
-->
-->When replying, please edit your Subject line so it is more 
-->specific than "Re: Contents of ADodb-general digest..."
-->
-->
-->Today's Topics:
-->
-->   1. Problem with RecordCount function (Renne Rocha)
-->
-->--__--__--
-->
-->Message: 1
-->Date: Sat, 25 Mar 2006 17:27:36 -0300
-->From: "Renne Rocha" <rennerocha <at> gmail.com>
-->To: adodb-general <at> lists.sourceforge.net
-->Subject: [ADodb-general] Problem with RecordCount function
-->
-->  Hello,
-->
-->  I am trying to use ADODB to access a PostgreSQL 8.1.2 
-->database. e connection works well. But after using a select 
-->query I tried to get the number of the rows in the result. I 
-->use the function RecordCount, but I receive an error message 
-->saying that this function doesn't exist.
-->
-->  I searched on the internet, but I found that postgres 
-->permit the use of this function. What could I do to solve 
-->this problem?
-->
-->  A piece of my code:
--><?php
-->      $db =3D NewADOConnection($database_type);
-->      $db-> Connect($host, $user, $password, $database);
-->      $query =3D "SELECT * FROM usuarios WHERE 
-->usuarios.str_usuario =3D '".$str_usuario."'";
-->      if($db->Execute($busca) =3D=3D=3D false)
-->      {
-->        print $db->ErrorMsg().'<BR>';
-->        return false;
-->      } else
-->      {
-->        if($db->RecordCount()=3D=3D0) { return false; }
-->        return true;
-->      }
-->?>
-->
-->  The error message:
-->  Fatal error: Call to undefined function: recordcount() in 
-->/srv/www/htdocs/class.usuario.php on line 60
-->
-->  Thanks for any help.
-->
-->  Renne
-->
-->
-->
-->--__--__--
-->
-->_______________________________________________
-->ADodb-general mailing list
-->ADodb-general <at> lists.sourceforge.net
-->https://lists.sourceforge.net/lists/listinfo/adodb-general
-->
-->
-->End of ADodb-general Digest
-->
-->
-->-- 
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.385 / Virus Database: 268.3.1/292 - Release 
-->Date: 24/3/2006
-->
-->
-->-- 
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.385 / Virus Database: 268.3.1/292 - Release 
-->Date: 24/3/2006
--> 
-->

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.1/292 - Release Date: 24/3/2006

--

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.1/292 - Release Date: 24/3/2006

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
Permalink | Reply | 0 comments |

Gmane