phpesp-devel — Discussion of the development of phpESP

[phpesp-dev] Notes on PEAR

[Stefan C. <sch...@ea...>]

I use PHP 4.3.3 and the PEAR DB lib that comes along.

I've noticed a few very annoying things when it comes down to moving to 
another DB :

- DB doesn't support sequences (it is said it emualtes them, but it's seems to 
be not implemented)
- DB doesn't support "num_rows" and alike for ODBC (although the API is there)

So my idea is that pear doesn't help very much on the portability issues : 
code has to be rewritten anyway.

stF 

Re: [phpesp-dev] PEAR DB port - call for developers

[Jeremy B. <je...@we...>]

Charlie & all,

I am willing to help, but my priorities here at work keep getting 
shifted around.  A few weeks ago, this would have been priority #1, but 
now it's way down on the list.  I'm not sure when/if I'll be able to 
help out, but I will follow the progress and post to the list when I 
can.

Thanks,
Jeremy

On Friday, October 24, 2003, at 09:21 AM, Charlie Smith wrote:

> Thanks for your reply Stephan.  Please keep postings copied to the 
> group if possible.
>
> I believe it in our best interest to work together as well.
>
> Calling for help -   W  O  U  L  D     A N Y O N E    B E       
> INTERESTED IN ASSISTING WITH THE
> PORT OF MYSQL TO PEAR DB?  If so, please respond, and I'll try and 
> divy out assignments.

Re: [phpesp-dev] ODBC portDear Charlie,

[Charlie S. <Sm...@ld...>]

Thanks for your reply Stephan.  Please keep postings copied to the group if=
 =
possible.

I believe it in our best interest to work together as well.

Calling for help -   W  O  U  L  D     A N Y O N E    B E       INTERESTED =
IN ASSISTING WITH THE
PORT OF MYSQL TO PEAR DB?  If so, please respond, and I'll try and divy out=
 =
assignments.

Stephan,   is the odbc stuff able to be abstracted to PEAR DB?

>>> "Stefan Champailler" <sch...@ea...> 10/23/03 03:38PM >>>
Dear Charlie,

Thanks a lot for your long comment. I thought people had lost their interes=
t=
=20
in working together, that's why I went my way... Another reason, a bit more=
=20
convincing I think is that I have modified the code quite a lot and I'm now=
=20
quite away from the original. However, Ill be happy to contribute in anyway=
 =
I=20
can. As soon as I see the end of the project, Ill show some "diffs" of my=20
code against the base.

Anyway, here's what I'm doing so far. As I said previously, I'm converting =
the=20
code to something that makes the least possible use of row counts. Parts of=
=20
the code can be rewritten to avoid it (and we actually increase efficiency,=
=20
but I'll assume it is pointless here). I'm almost done. The only thing =
that's=20
left to do is to get rid for "insert_id" stuff and alike. I'll do that by=20
simulating Oracle sequences in the beginning and then, once I move to =
Oracle,=20
remove the simulation. Here are the functions I have created (might be =
bugged=20
as I still don't have made a full regression test). I use phpDocumentor for=
=20
documenting (a really cool tool).

On the counting issue, I also prefer to use "SELECT COUNT(*) ..." rather =
than=20
=66etching the whole information "just" for coutning it. I try to push as =
much=20
as the code into the DB, without using stored procedure though (because I=20
don't know them very much, because it's not portable).

On another front, I'm also looking at some of the database constructs. I =
think=20
that some of the auto_increment are not necessary as well as sompe of the=20
"id" fields. But I prefer to look into that before posting misleading=20
information.

So, Charlie, I think we can just say that we have taken two quite different=
=20
directions, but what I suggest is that we share our experience here so that=
=20
other can eventually read it. I'll continue to post my progress on the port=
=20
as well as some of my interrogations..

cheers,

stF




/** Make a query against the ODBC persistent connection.
  * This is equivalent to calling odbc_prepare/execute.
  * A lot of error reporting is done if necessary.
  * @return mixed false in case of error. Results ressource if successfull.=
 =
*/

=66unction odbc_query( $sql) {
    global $ESPCONFIG;

    if( !empty( $ESPCONFIG['odbc_cid'])) {

        $psql =3D odbc_prepare( $ESPCONFIG['odbc_cid'], $sql);

        error_log("PSQL is $psql : $sql");

        if( $psql !=3D false) {

            $res =3D odbc_execute( $psql);

            if( $res) {
                error_log("Executed $sql =3D $sql"); // debug

                return $psql;
            } else {
                odbc_free_result( $psql);
                error_log("odbc_query() : Unable to execute the following=20
*prepared* SQL :");
                error_log("odbc_query() : $sql");
                error_log("odbc_query() : ODBC reported : =
".odbc_errormsg());
                return false;
            }
        } else {
            error_log("odbc_query() : Unable to prepare the following SQL =
:");
            error_log("odbc_query() : $sql");
            error_log("odbc_query() : ODBC reported : ".odbc_errormsg());
            return false;
        }
    } else {
        error_log("odbc_query() : Ooops tried to query without a proper=20
connection to the DB.");
        return false;
    }
}

/** Same semantic as mysql_fetch_assoc()
 *  A row is fetched.
 *
 *  @param resource Query Id.
 *  @return mixed False if no row are available. An associative
 *  array with the row fields in it. */

=66unction odbc_fetch_assoc( $qid) {

    if( ($row =3D odbc_fetch_row( $qid))
        && odbc_num_fields( $qid) > 0)
        return odbc_extract_assoc( $qid);
    else
        return false;
}

/** Extracts the data in a fetched row into an associative array.
 *  Each field of the row gets an entry in the associative array.
 *  No test has been done for field sharing the same name.
 *
 *  @param resource Query Id.
 *  @return An associative array with all the fields of the row
 *  or an empty array if there is no field. */

=66unction odbc_extract_assoc( $qid) {
    $a =3D array();
    for( $i=3D1; $i <=3D odbc_num_fields( $qid); $i++)
        $a[ odbc_field_name($qid, $i) ] =3D odbc_result( $qid, $i);
    return $a;
}

/** Same semantic as mysql_fetch_array()
 *  A row is fetched.
 *
 *  @param resource Query Id.
 *  @return mixed False if no row are available. An indexed
 *  array with the row fields in it. */

=66unction odbc_fetch_row_array( $qid) {

    if( ($row =3D odbc_fetch_row( $qid) && odbc_num_fields( $qid) > 0))
        return odbc_extract_array( $qid);
    else
        return false;
}


/** Extracts the data in a fetched row into an indexed array.
 *  Each field of the row gets an entry in the associative array,
 *  in the order it appears in the row. Array's indexes are zero based.
 *
 *  @param resource Query Id.
 *  @return An indexed array with all the fields of the row
 *  or an empty array if there is no field. */

=66unction odbc_extract_array( $qid) {
    $a =3D array();
    for( $i=3D1; $i <=3D odbc_num_fields( $qid); $i++)
        $a[ $i - 1 ] =3D odbc_result( $qid, $i);
    return $a;
}

=66unction odbc_get_first_cell( $qid) {
    if( odbc_fetch_row( $qid) && odbc_num_fields( $qid) > 0)
        return odbc_result( $qid, 1);
    else
        return false;
}


=66unction odbc_get_first_cell_into( $qid, &$value) {
    if( ($row =3D odbc_fetch_row( $qid))
        && odbc_num_fields( $qid) > 0) {
        $value =3D odbc_result( $qid, 1);
        return true;
    } else
        return false;
}


> Stephan,
>    The mysql_num_rows fucntion as well as the OCIRowCount only return the
> number of rows fetched in the query so far. So, as you've found, all the
> rows of a particular query have to be fetched for the numrows function to
> return what most people would want to see - a number of the rows matching=
 =
a
> specific query.
>
>    I was wondering how much of this you want to work together on.  If =
you'd
> asked earlier, I would have given you the code that follows.  Hopefully, =
we
> can see the value of working together on this.
>
>    I'd like a count and names of individuals that would like to
> participate.  I believe there was a Jeremy Buckman that showed some
> interest in this.  Also, I've asked to be put on the developer's list  for
> this project, with no reply.    Is there an objection to this proposal.
>
> Here is the code I wrote to return the number of rows matching a =
particular
> query: Hope this helps.  I've also written oracle queries to match all of
> the mysql queries in phpesp.   It's really just a matter of unit testing
> now.  If we could have some volunteers to do this, that would be great.  =
=20
> Also, volunteering means, locating the appropriate PEAR db call, and doing
> the code to move from the mysql/Oracle calls to the PEAR equivalent if it
> exists.   I really dont want to offent anyone here, and I've not been able
> to pay much attention to this lately, as my other work responsibilities
> have caused me to put this on the back burner.   However, I believe that
> with some effort on all of our parts and - working together - we could
> proceed to the PEAR port.  However, I'm so busy, It really doesn't bother
> me to wait, right now.  Just maybe could make life simpler if we share.
>
> Here is the oracle function for returning num rows:
> # Function:  oracleNumRows
> # Author: Charlie Smith
> # Date: 5/30/03
> # Description:
> #   Get number of rows matching query.
> #
> # Input Values         Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $query               Oracle query/statement
> # $connected           resource identifier
> #
> # Return Values        Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $mcount              number of rows in $query
> #
> function oracleNumRows($query, $connected) {
>
>   $cwsStmt =3D oracleExecuteQuery($query, $connected);
>   while($result =3D @oracleFetchArray($cwsStmt)) {
>   }
>   $mCount =3D OCIRowCount($cwsStmt);
>   return $mCount;
> }
>
> # Function:  oracleFetchArray
> # Author: Charlie Smith
> # Date: 5/30/03
> # Description:
> #   Fetch record from table.
> #
> # Input Values         Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $stmt                prepared oracle query
> #
> # Return Values        Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $row                 array of values for record retrieved
> #
> # NOTE: The known flags to OCIFetchInto are:
> # OCI_ASSOC Return an associative array.
> # OCI_NUM Return an numbered array starting with zero. (DEFAULT)
> # OCI_RETURN_NULLS Return empty columns.
> # OCI_RETURN_LOBS Return the value of a LOB instead of the descriptor.
> #
> function oracleFetchArray($stmt) {
>
>   @OCIFetchInto ($stmt, $row, OCI_ASSOC);
>   # In case you want to return just one field value, uncommand
>   # and add parameter for name of field.
>   # return $row[$alias_name];
>   return $row;
> }
>
> # Function:  oracleExecuteQuery
> # Author: Charlie Smith
> # Date: 5/30/03
> # Description:
> #   Executes query on connected resource.
> #
> # Calling routines: oracleNumRows
> #
> # Input Values         Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $query               Oracle query/statement
> # $connected           resource identifier
> #
> # Return Values        Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $stmt                Used statement asscociated with parsed/prepared
> resource.
>
> #
> function oracleExecuteQuery($query, $connected) {
>   global $ORACLE_USER, $ORACLE_PASS, $ORACLE_SID;
>
>   if(!$connected) {
>     $connected =3D @OCIPLogon($ORACLE_USER, $ORACLE_PASS, $ORACLE_SID);
>
>     if($error =3D OCIError()) {
>       die("<font color=3Dred>ERROR!! Couldn't connect to server!</font>");
>     }
>   }
>
>   $stmt =3D @OCIParse($connected, $query);
>   if($error =3D OCIError()) {
>     die("<font color=3Dred>ERROR!! Statement syntax error!
> $error[message]</font>" );
>   }
>   @OCIExecute($stmt);
>   if($error =3D OCIError($stmt)) {
>     die("<font color=3Dred>ERROR!! Could not execute statement =
query:$query!
> $erro r[message] </font>");
>   }
>
>   return $stmt;
> }
>
> >>> "Stefan Champailler" <sch...@ea...> 10/22/03 01:55PM >>>
>
> More on the ODBC port...
>
> Since we can't rely on the odbc_num_rows function for counting the result
> of select statement, I had to get rid of them all. It took me 1.5 days so
> far. Now I have to see where I've broken stuff.
>
> I stumbled across a piece of code that is very strange as well. It's in
> order.inc, the part of the code that actually change the order of a
> question. I've a feeling that the SQL statement used is not right. But,
> somehow, everything seems to work (I didn't investigate completely). So
> either its wrong, either is quite clever (I need three SQL operation to =
get
> the same result). So if someone can explain me how this part of the code =
is
> working, it'll be helpful.
>
> stF
>
> > Yes, you read well, ODBC port :)
> >
> > I'm doing it like that because I have to reduce the risks... Since it's
> > gonna work on Oracle, I'll share my experience with you. Right now, I'm
> > converting all the mysal_ statements to odbc_ statements. It's not that
> > simple. Especially the mysql_num_rows which doesn' translate easily into
> > odbc_num_rows (this one is not guaranteed to work on every ODBC
> > driver...).
> >
> > More on that later.
> >
> > stF
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by OSDN developer relations
> > Here's your chance to show off your extensive product knowledge
> > We want to know what you know. Tell us and you have a chance to win $100
> > http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54=20
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...=20
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>
> -------------------------------------------------------
> This SF.net email is sponsored by OSDN developer relations
> Here's your chance to show off your extensive product knowledge
> We want to know what you know. Tell us and you have a chance to win $100
> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>
>
> =
---------------------------------------------------------------------------
>--- This message may contain confidential information, and is intended only
> for the use of the individual(s) to whom it is addressed.
>
>
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=3D=3D=3D



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

[phpesp-dev] PEAR DB port - call for developers

[Charlie S. <Sm...@ld...>]

Thanks for your reply Stephan.  Please keep postings copied to the group if=
 =
possible.

I believe it in our best interest to work together as well.

Calling for help -   W  O  U  L  D     A N Y O N E    B E       INTERESTED =
IN ASSISTING WITH THE
PORT OF MYSQL TO PEAR DB?  If so, please respond, and I'll try and divy out=
 =
assignments.

Stephan,   is the odbc stuff able to be abstracted to PEAR DB?

>>> "Stefan Champailler" <sch...@ea...> 10/23/03 03:38PM >>>
Dear Charlie,

Thanks a lot for your long comment. I thought people had lost their interes=
t=
=20
in working together, that's why I went my way... Another reason, a bit more=
=20
convincing I think is that I have modified the code quite a lot and I'm now=
=20
quite away from the original. However, Ill be happy to contribute in anyway=
 =
I=20
can. As soon as I see the end of the project, Ill show some "diffs" of my=20
code against the base.

Anyway, here's what I'm doing so far. As I said previously, I'm converting =
the=20
code to something that makes the least possible use of row counts. Parts of=
=20
the code can be rewritten to avoid it (and we actually increase efficiency,=
=20
but I'll assume it is pointless here). I'm almost done. The only thing =
that's=20
left to do is to get rid for "insert_id" stuff and alike. I'll do that by=20
simulating Oracle sequences in the beginning and then, once I move to =
Oracle,=20
remove the simulation. Here are the functions I have created (might be =
bugged=20
as I still don't have made a full regression test). I use phpDocumentor for=
=20
documenting (a really cool tool).

On the counting issue, I also prefer to use "SELECT COUNT(*) ..." rather =
than=20
=66etching the whole information "just" for coutning it. I try to push as =
much=20
as the code into the DB, without using stored procedure though (because I=20
don't know them very much, because it's not portable).

On another front, I'm also looking at some of the database constructs. I =
think=20
that some of the auto_increment are not necessary as well as sompe of the=20
"id" fields. But I prefer to look into that before posting misleading=20
information.

So, Charlie, I think we can just say that we have taken two quite different=
=20
directions, but what I suggest is that we share our experience here so that=
=20
other can eventually read it. I'll continue to post my progress on the port=
=20
as well as some of my interrogations..

cheers,

stF




/** Make a query against the ODBC persistent connection.
  * This is equivalent to calling odbc_prepare/execute.
  * A lot of error reporting is done if necessary.
  * @return mixed false in case of error. Results ressource if successfull.=
 =
*/

=66unction odbc_query( $sql) {
    global $ESPCONFIG;

    if( !empty( $ESPCONFIG['odbc_cid'])) {

        $psql =3D odbc_prepare( $ESPCONFIG['odbc_cid'], $sql);

        error_log("PSQL is $psql : $sql");

        if( $psql !=3D false) {

            $res =3D odbc_execute( $psql);

            if( $res) {
                error_log("Executed $sql =3D $sql"); // debug

                return $psql;
            } else {
                odbc_free_result( $psql);
                error_log("odbc_query() : Unable to execute the following=20
*prepared* SQL :");
                error_log("odbc_query() : $sql");
                error_log("odbc_query() : ODBC reported : =
".odbc_errormsg());
                return false;
            }
        } else {
            error_log("odbc_query() : Unable to prepare the following SQL =
:");
            error_log("odbc_query() : $sql");
            error_log("odbc_query() : ODBC reported : ".odbc_errormsg());
            return false;
        }
    } else {
        error_log("odbc_query() : Ooops tried to query without a proper=20
connection to the DB.");
        return false;
    }
}

/** Same semantic as mysql_fetch_assoc()
 *  A row is fetched.
 *
 *  @param resource Query Id.
 *  @return mixed False if no row are available. An associative
 *  array with the row fields in it. */

=66unction odbc_fetch_assoc( $qid) {

    if( ($row =3D odbc_fetch_row( $qid))
        && odbc_num_fields( $qid) > 0)
        return odbc_extract_assoc( $qid);
    else
        return false;
}

/** Extracts the data in a fetched row into an associative array.
 *  Each field of the row gets an entry in the associative array.
 *  No test has been done for field sharing the same name.
 *
 *  @param resource Query Id.
 *  @return An associative array with all the fields of the row
 *  or an empty array if there is no field. */

=66unction odbc_extract_assoc( $qid) {
    $a =3D array();
    for( $i=3D1; $i <=3D odbc_num_fields( $qid); $i++)
        $a[ odbc_field_name($qid, $i) ] =3D odbc_result( $qid, $i);
    return $a;
}

/** Same semantic as mysql_fetch_array()
 *  A row is fetched.
 *
 *  @param resource Query Id.
 *  @return mixed False if no row are available. An indexed
 *  array with the row fields in it. */

=66unction odbc_fetch_row_array( $qid) {

    if( ($row =3D odbc_fetch_row( $qid) && odbc_num_fields( $qid) > 0))
        return odbc_extract_array( $qid);
    else
        return false;
}


/** Extracts the data in a fetched row into an indexed array.
 *  Each field of the row gets an entry in the associative array,
 *  in the order it appears in the row. Array's indexes are zero based.
 *
 *  @param resource Query Id.
 *  @return An indexed array with all the fields of the row
 *  or an empty array if there is no field. */

=66unction odbc_extract_array( $qid) {
    $a =3D array();
    for( $i=3D1; $i <=3D odbc_num_fields( $qid); $i++)
        $a[ $i - 1 ] =3D odbc_result( $qid, $i);
    return $a;
}

=66unction odbc_get_first_cell( $qid) {
    if( odbc_fetch_row( $qid) && odbc_num_fields( $qid) > 0)
        return odbc_result( $qid, 1);
    else
        return false;
}


=66unction odbc_get_first_cell_into( $qid, &$value) {
    if( ($row =3D odbc_fetch_row( $qid))
        && odbc_num_fields( $qid) > 0) {
        $value =3D odbc_result( $qid, 1);
        return true;
    } else
        return false;
}


> Stephan,
>    The mysql_num_rows fucntion as well as the OCIRowCount only return the
> number of rows fetched in the query so far. So, as you've found, all the
> rows of a particular query have to be fetched for the numrows function to
> return what most people would want to see - a number of the rows matching=
 =
a
> specific query.
>
>    I was wondering how much of this you want to work together on.  If =
you'd
> asked earlier, I would have given you the code that follows.  Hopefully, =
we
> can see the value of working together on this.
>
>    I'd like a count and names of individuals that would like to
> participate.  I believe there was a Jeremy Buckman that showed some
> interest in this.  Also, I've asked to be put on the developer's list  for
> this project, with no reply.    Is there an objection to this proposal.
>
> Here is the code I wrote to return the number of rows matching a =
particular
> query: Hope this helps.  I've also written oracle queries to match all of
> the mysql queries in phpesp.   It's really just a matter of unit testing
> now.  If we could have some volunteers to do this, that would be great.  =
=20
> Also, volunteering means, locating the appropriate PEAR db call, and doing
> the code to move from the mysql/Oracle calls to the PEAR equivalent if it
> exists.   I really dont want to offent anyone here, and I've not been able
> to pay much attention to this lately, as my other work responsibilities
> have caused me to put this on the back burner.   However, I believe that
> with some effort on all of our parts and - working together - we could
> proceed to the PEAR port.  However, I'm so busy, It really doesn't bother
> me to wait, right now.  Just maybe could make life simpler if we share.
>
> Here is the oracle function for returning num rows:
> # Function:  oracleNumRows
> # Author: Charlie Smith
> # Date: 5/30/03
> # Description:
> #   Get number of rows matching query.
> #
> # Input Values         Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $query               Oracle query/statement
> # $connected           resource identifier
> #
> # Return Values        Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $mcount              number of rows in $query
> #
> function oracleNumRows($query, $connected) {
>
>   $cwsStmt =3D oracleExecuteQuery($query, $connected);
>   while($result =3D @oracleFetchArray($cwsStmt)) {
>   }
>   $mCount =3D OCIRowCount($cwsStmt);
>   return $mCount;
> }
>
> # Function:  oracleFetchArray
> # Author: Charlie Smith
> # Date: 5/30/03
> # Description:
> #   Fetch record from table.
> #
> # Input Values         Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $stmt                prepared oracle query
> #
> # Return Values        Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $row                 array of values for record retrieved
> #
> # NOTE: The known flags to OCIFetchInto are:
> # OCI_ASSOC Return an associative array.
> # OCI_NUM Return an numbered array starting with zero. (DEFAULT)
> # OCI_RETURN_NULLS Return empty columns.
> # OCI_RETURN_LOBS Return the value of a LOB instead of the descriptor.
> #
> function oracleFetchArray($stmt) {
>
>   @OCIFetchInto ($stmt, $row, OCI_ASSOC);
>   # In case you want to return just one field value, uncommand
>   # and add parameter for name of field.
>   # return $row[$alias_name];
>   return $row;
> }
>
> # Function:  oracleExecuteQuery
> # Author: Charlie Smith
> # Date: 5/30/03
> # Description:
> #   Executes query on connected resource.
> #
> # Calling routines: oracleNumRows
> #
> # Input Values         Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $query               Oracle query/statement
> # $connected           resource identifier
> #
> # Return Values        Description
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # $stmt                Used statement asscociated with parsed/prepared
> resource.
>
> #
> function oracleExecuteQuery($query, $connected) {
>   global $ORACLE_USER, $ORACLE_PASS, $ORACLE_SID;
>
>   if(!$connected) {
>     $connected =3D @OCIPLogon($ORACLE_USER, $ORACLE_PASS, $ORACLE_SID);
>
>     if($error =3D OCIError()) {
>       die("<font color=3Dred>ERROR!! Couldn't connect to server!</font>");
>     }
>   }
>
>   $stmt =3D @OCIParse($connected, $query);
>   if($error =3D OCIError()) {
>     die("<font color=3Dred>ERROR!! Statement syntax error!
> $error[message]</font>" );
>   }
>   @OCIExecute($stmt);
>   if($error =3D OCIError($stmt)) {
>     die("<font color=3Dred>ERROR!! Could not execute statement =
query:$query!
> $erro r[message] </font>");
>   }
>
>   return $stmt;
> }
>
> >>> "Stefan Champailler" <sch...@ea...> 10/22/03 01:55PM >>>
>
> More on the ODBC port...
>
> Since we can't rely on the odbc_num_rows function for counting the result
> of select statement, I had to get rid of them all. It took me 1.5 days so
> far. Now I have to see where I've broken stuff.
>
> I stumbled across a piece of code that is very strange as well. It's in
> order.inc, the part of the code that actually change the order of a
> question. I've a feeling that the SQL statement used is not right. But,
> somehow, everything seems to work (I didn't investigate completely). So
> either its wrong, either is quite clever (I need three SQL operation to =
get
> the same result). So if someone can explain me how this part of the code =
is
> working, it'll be helpful.
>
> stF
>
> > Yes, you read well, ODBC port :)
> >
> > I'm doing it like that because I have to reduce the risks... Since it's
> > gonna work on Oracle, I'll share my experience with you. Right now, I'm
> > converting all the mysal_ statements to odbc_ statements. It's not that
> > simple. Especially the mysql_num_rows which doesn' translate easily into
> > odbc_num_rows (this one is not guaranteed to work on every ODBC
> > driver...).
> >
> > More on that later.
> >
> > stF
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by OSDN developer relations
> > Here's your chance to show off your extensive product knowledge
> > We want to know what you know. Tell us and you have a chance to win $100
> > http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54=20
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...=20
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>
> -------------------------------------------------------
> This SF.net email is sponsored by OSDN developer relations
> Here's your chance to show off your extensive product knowledge
> We want to know what you know. Tell us and you have a chance to win $100
> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>
>
> =
---------------------------------------------------------------------------
>--- This message may contain confidential information, and is intended only
> for the use of the individual(s) to whom it is addressed.
>
>
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=3D=3D=3D



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [phpesp-dev] ODBC port

[Charlie S. <Sm...@ld...>]

Stephan,
   The mysql_num_rows fucntion as well as the OCIRowCount only return the =
number of rows fetched in the query so far.
So, as you've found, all the rows of a particular query have to be fetched =
=66or the numrows function to return what most people would want to see - a=
 =
number of the rows matching a specific query.

   I was wondering how much of this you want to work together on.  If you'd=
 =
asked earlier, I would have given you the code that follows.  Hopefully, we=
 =
can see the value of working together on this.   =20

   I'd like a count and names of individuals that would like to participate=
.=
  I believe there was a Jeremy Buckman that showed some interest in this.  =
Also, I've asked to be put on the developer's list  for this project, with =
no reply.    Is there an objection to this proposal. =20

Here is the code I wrote to return the number of rows matching a particular=
 =
query:
Hope this helps.  I've also written oracle queries to match all of the mysq=
l=
 queries in phpesp.   It's really just a matter of unit testing now.  If we=
 =
could have some volunteers to do this, that would be great.    Also, =
volunteering means, locating the appropriate PEAR db call, and doing the =
code to move from the mysql/Oracle calls to the PEAR equivalent if it =
exists.   I really dont want to offent anyone here, and I've not been able =
to pay much attention to this lately, as my other work responsibilities hav=
e=
 caused me to put this on the back burner.   However, I believe that with =
some effort on all of our parts and - working together - we could proceed t=
o=
 the PEAR port.  However, I'm so busy, It really doesn't bother me to wait,=
 =
right now.  Just maybe could make life simpler if we share.

Here is the oracle function for returning num rows:
# Function:  oracleNumRows
# Author: Charlie Smith
# Date: 5/30/03
# Description:
#   Get number of rows matching query.
#
# Input Values         Description
# =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# $query               Oracle query/statement
# $connected           resource identifier
#
# Return Values        Description
# =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# $mcount              number of rows in $query
#
=66unction oracleNumRows($query, $connected) {

  $cwsStmt =3D oracleExecuteQuery($query, $connected);
  while($result =3D @oracleFetchArray($cwsStmt)) {
  }
  $mCount =3D OCIRowCount($cwsStmt);
  return $mCount;
}

# Function:  oracleFetchArray
# Author: Charlie Smith
# Date: 5/30/03
# Description:
#   Fetch record from table.
#
# Input Values         Description
# =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# $stmt                prepared oracle query
#
# Return Values        Description
# =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# $row                 array of values for record retrieved
#
# NOTE: The known flags to OCIFetchInto are:
# OCI_ASSOC Return an associative array.
# OCI_NUM Return an numbered array starting with zero. (DEFAULT)
# OCI_RETURN_NULLS Return empty columns.
# OCI_RETURN_LOBS Return the value of a LOB instead of the descriptor.
#
=66unction oracleFetchArray($stmt) {

  @OCIFetchInto ($stmt, $row, OCI_ASSOC);
  # In case you want to return just one field value, uncommand
  # and add parameter for name of field.
  # return $row[$alias_name];
  return $row;
}

# Function:  oracleExecuteQuery
# Author: Charlie Smith
# Date: 5/30/03
# Description:
#   Executes query on connected resource.
#
# Calling routines: oracleNumRows
#
# Input Values         Description
# =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D         =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# $query               Oracle query/statement
# $connected           resource identifier
#
# Return Values        Description
# =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
# $stmt                Used statement asscociated with parsed/prepared =
resource.

#
=66unction oracleExecuteQuery($query, $connected) {
  global $ORACLE_USER, $ORACLE_PASS, $ORACLE_SID;

  if(!$connected) {
    $connected =3D @OCIPLogon($ORACLE_USER, $ORACLE_PASS, $ORACLE_SID);

    if($error =3D OCIError()) {
      die("<font color=3Dred>ERROR!! Couldn't connect to server!</font>");
    }
  }

  $stmt =3D @OCIParse($connected, $query);
  if($error =3D OCIError()) {
    die("<font color=3Dred>ERROR!! Statement syntax error! =
$error[message]</font>"
);
  }
  @OCIExecute($stmt);
  if($error =3D OCIError($stmt)) {
    die("<font color=3Dred>ERROR!! Could not execute statement query:$query=
!=
 $erro
r[message] </font>");
  }

  return $stmt;
}



>>> "Stefan Champailler" <sch...@ea...> 10/22/03 01:55PM >>>
More on the ODBC port...

Since we can't rely on the odbc_num_rows function for counting the result o=
=66=
=20
select statement, I had to get rid of them all. It took me 1.5 days so far.=
=20
Now I have to see where I've broken stuff.

I stumbled across a piece of code that is very strange as well. It's in=20
order.inc, the part of the code that actually change the order of a =
question.=20
I've a feeling that the SQL statement used is not right. But, somehow,=20
everything seems to work (I didn't investigate completely). So either its=20
wrong, either is quite clever (I need three SQL operation to get the same=20
result). So if someone can explain me how this part of the code is working,=
=20
it'll be helpful.

stF


> Yes, you read well, ODBC port :)
>
> I'm doing it like that because I have to reduce the risks... Since it's
> gonna work on Oracle, I'll share my experience with you. Right now, I'm
> converting all the mysal_ statements to odbc_ statements. It's not that
> simple. Especially the mysql_num_rows which doesn' translate easily into
> odbc_num_rows (this one is not guaranteed to work on every ODBC =
driver...).
>
> More on that later.
>
> stF
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by OSDN developer relations
> Here's your chance to show off your extensive product knowledge
> We want to know what you know. Tell us and you have a chance to win $100
> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20



-------------------------------------------------------
This SF.net email is sponsored by OSDN developer relations
Here's your chance to show off your extensive product knowledge
We want to know what you know. Tell us and you have a chance to win $100
http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54=20
_______________________________________________
phpESP-devel mailing list
php...@li...=20
https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20


---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [phpesp-dev] CSV Download/Export all values less by 1

[Brian W. <br...@uc...>]

There's been a fair amt of discussion of this.  search the maillinglist 
archives for your keywords 'csv'...'export'

I think the short answ is: "That is how it is for now."  You can 1) use a 
macro in excel (or similar app) to correct this 2) make your own php mod to 
the correct function.

-Brian

At 01:12 PM 10/22/2003 -0400, Prabhu wrote:


>When I make an export/download of the results all values are less by 1. 
>These are all ranks and the ranks get subtracted by 1 after the download. 
>I am using phpESP 1.6.1
>  Can any body hint me if this is a bug (if so how to solve it) or is 
> there anything else i am missing?
>
>Thanks,
>  Prabhu
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by OSDN developer relations
>Here's your chance to show off your extensive product knowledge
>We want to know what you know. Tell us and you have a chance to win $100
>http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54
>_______________________________________________
>phpESP-devel mailing list
>php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpesp-devel

Brian Wood
Programmer/Analyst
UC Berkeley Human Resources

[phpesp-dev] CSV Download/Export all values less by 1

[Prabhu <psh...@pr...>]

When I make an export/download of the results all values are less by 1. =
These are all ranks and the ranks get subtracted by 1 after the =
download. I am using phpESP 1.6.1 =20
 Can any body hint me if this is a bug (if so how to solve it) or is =
there anything else i am missing?

Thanks,
 Prabhu

Re: [phpesp-dev] ODBC port

[Stefan C. <sch...@ea...>]

More on the ODBC port...

Since we can't rely on the odbc_num_rows function for counting the result of 
select statement, I had to get rid of them all. It took me 1.5 days so far. 
Now I have to see where I've broken stuff.

I stumbled across a piece of code that is very strange as well. It's in 
order.inc, the part of the code that actually change the order of a question. 
I've a feeling that the SQL statement used is not right. But, somehow, 
everything seems to work (I didn't investigate completely). So either its 
wrong, either is quite clever (I need three SQL operation to get the same 
result). So if someone can explain me how this part of the code is working, 
it'll be helpful.

stF


> Yes, you read well, ODBC port :)
>
> I'm doing it like that because I have to reduce the risks... Since it's
> gonna work on Oracle, I'll share my experience with you. Right now, I'm
> converting all the mysal_ statements to odbc_ statements. It's not that
> simple. Especially the mysql_num_rows which doesn' translate easily into
> odbc_num_rows (this one is not guaranteed to work on every ODBC driver...).
>
> More on that later.
>
> stF
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by OSDN developer relations
> Here's your chance to show off your extensive product knowledge
> We want to know what you know. Tell us and you have a chance to win $100
> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel

[phpesp-dev] CSV Download/Export all values less by 1

[Prabhu <psh...@pr...>]

When I make an export/download of the results all values are less by 1. =
These are all ranks and the ranks get subtracted by 1 after the =
download. I am using phpESP 1.6.1 =20
 Can any body hint me if this is a bug (if so how to solve it) or is =
there anything else i am missing?

Thanks,
 Prabhu

[phpesp-dev] [ phpesp-Bugs-827943 ] GNU Gettext test: %%%% Gettext Test Failed

[SourceForge.net <no...@so...>]

Bugs item #827943, was opened at 2003-10-22 03:41
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=827943&group_id=8956

Category: Admin
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Gaf (grouaf)
Assigned to: Nobody/Anonymous (nobody)
Summary: GNU Gettext test: %%%% Gettext Test Failed

Initial Comment:
Hello,
I can't use the french language.
I have the gettext enable but the test don't pass.
Here is the beginning of my phpinfo where phpESP is
running on :
PHP Version 4.3.1

System 	Linux PPR 2.4.22 #3 Thu Oct 9 22:27:44 CEST
2003 i686
Build Date 	Oct 21 2003 23:29:43
Configure Command 	'./configure' '--with-iodbc'
'--with-gd' '--with-zlib-dir=/usr/include/zlib.h'
'--with-jpeg-dir=/usr/local/include/jpeglib.h'
'--with-gettext' '--with-pear'
'--with-apxs2=/usr/Apache/bin/apxs'
Server API 	Apache 2.0 Filter
GetText Support 	enabled


I'm not a coder so I can't help your more than test it...
And this is my first bug report, so please don't be so
rude :)
Anyway, anything else works fine until now.
Thanks for all.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=827943&group_id=8956

[phpesp-dev] [ phpesp-Bugs-827824 ] CSV Download/Export all values less by 1

[SourceForge.net <no...@so...>]

Bugs item #827824, was opened at 2003-10-21 21:37
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=827824&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Prabhu Shanmugam (pshan427)
Assigned to: Nobody/Anonymous (nobody)
Summary: CSV Download/Export all values less by 1

Initial Comment:
When I make an export/download of the results all 
values are less by 1. These are all ranks and the 
ranks get subtracted by 1 after the download. I am 
using phpESP 1.6.1 

Can any body hint me if this is a bug (if so how to 
solve it) or is there anything else i am missing?

Thanks,
Prabhu

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=827824&group_id=8956

[phpesp-dev] ODBC port

[Stefan C. <sch...@ea...>]

Yes, you read well, ODBC port :)

I'm doing it like that because I have to reduce the risks... Since it's gonna 
work on Oracle, I'll share my experience with you. Right now, I'm converting 
all the mysal_ statements to odbc_ statements. It's not that simple. 
Especially the mysql_num_rows which doesn' translate easily into 
odbc_num_rows (this one is not guaranteed to work on every ODBC driver...).

More on that later.

stF

Re: [phpesp-dev] PhpEsp Memory Error Message

[Matthew G. <gr...@mu...>]

Php has limits configured for maximum execution time as well as a
memory limit.  You might be bumping in to one of these.
Check your php.ini files and look for:
max_execution_time = 30
memory_limit = 8M

On Sun, 2003-10-19 at 22:34, Sam...@cs... wrote:
> I keep on getting the following error message:
>             Allowed memory size of 8388608 bytes exhausted (tried to allocate 
> 19 bytes) 
> 
> I have spent two days trying to find out how to fix the bug. Does anyone have 
> any ideas about how to fix this bug.
> 
> Sara
> 
> 
> -------------------------------------------------------
> This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo
> The Event For Linux Datacenter Solutions & Strategies in The Enterprise 
> Linux in the Boardroom; in the Front Office; & in the Server Room 
> http://www.enterpriselinuxforum.com
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] PhpEsp Memory Error Message

[<Sam...@cs...>]

I keep on getting the following error message:
            Allowed memory size of 8388608 bytes exhausted (tried to allocate 
19 bytes) 

I have spent two days trying to find out how to fix the bug. Does anyone have 
any ideas about how to fix this bug.

Sara

[phpesp-dev] [ phpesp-Feature Requests-826150 ] Other languages?

[SourceForge.net <no...@so...>]

Feature Requests item #826150, was opened at 2003-10-18 17:39
Message generated for change (Comment added) made by jimmerman
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=826150&group_id=8956

Category: gui
Group: None
>Status: Deleted
Priority: 5
Submitted By: David Klein (cadey)
Assigned to: Nobody/Anonymous (nobody)
Summary: Other languages?

Initial Comment:
Hi,

It could be nice if phpESP could support new languages 
like french ! Is it a short file to translate? I could help 
you to do it if you need ?

I'm refered as CADEY in SOURCEFORGE.NET and my 
email is : LISTES_AT_LAPOSTE_DOT_NET

David

----------------------------------------------------------------------

>Comment By: James Flemer (jimmerman)
Date: 2003-10-19 11:01

Message:
Logged In: YES 
user_id=39444

phpESP does support French (fr-FR).  Simply make sure you
have the latest version, make sure you have working gettext
support in PHP, and set your browser language preference to
French (fr-FR).  Please use the phpesp-general mailing list
for more support on this topic.

Also supported: da-DK, de-DE, el-GR, en-US, es-ES, fr-FR,
hu-HU, it-IT, ja-JP, nl-NL, pt-BR, pt-PT, sv-SE.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=826150&group_id=8956

[phpesp-dev] [ phpesp-Feature Requests-826150 ] Other languages?

[SourceForge.net <no...@so...>]

Feature Requests item #826150, was opened at 2003-10-19 00:39
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=826150&group_id=8956

Category: gui
Group: None
Status: Open
Priority: 5
Submitted By: David Klein (cadey)
Assigned to: Nobody/Anonymous (nobody)
Summary: Other languages?

Initial Comment:
Hi,

It could be nice if phpESP could support new languages 
like french ! Is it a short file to translate? I could help 
you to do it if you need ?

I'm refered as CADEY in SOURCEFORGE.NET and my 
email is : LISTES_AT_LAPOSTE_DOT_NET

David

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=826150&group_id=8956

[phpesp-dev] [ phpesp-Bugs-824475 ] GUI Design Preview Vote is 404 not found

[SourceForge.net <no...@so...>]

Bugs item #824475, was opened at 2003-10-16 09:42
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=824475&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Shirai,Kaoru (shirai-kaoru)
Assigned to: Nobody/Anonymous (nobody)
Summary: GUI Design Preview Vote is 404 not found

Initial Comment:
Link "vote" is broken on this page: 
http://phpesp.sourceforge.net/preview/


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=824475&group_id=8956

[phpesp-dev] [ phpesp-Feature Requests-820097 ] add a comments box to each question

[SourceForge.net <no...@so...>]

Feature Requests item #820097, was opened at 2003-10-08 12:24
Message generated for change (Comment added) made by winstonford
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=820097&group_id=8956

Category: survey format
Group: None
Status: Open
Priority: 5
Submitted By: winston ford (winstonford)
Assigned to: Nobody/Anonymous (nobody)
Summary: add a comments box to each question

Initial Comment:
Would like to add a comments box, just a textarea, for each 
question.  So regardless of the question format, the 
respondent would be able to type in comments further 
explaining or qualifying his or her answer.

When creating or editing a question, you currently have 
options:

Length....Precision....Required?

maybe add an bool option after Required?.....Comments?

If Comments? dropdown was selected "yes", then question 
would have a textarea titled "Comments" next to question.

Any ideas on how to implement appreciated.  Whip-arse app 
yall are building here.

thanks,
Winston

----------------------------------------------------------------------

>Comment By: winston ford (winstonford)
Date: 2003-10-13 20:13

Message:
Logged In: YES 
user_id=694984

our quick fix was to hide the generated number through css and 
use the 'field name' field to tie the comments box (essay) to the 
relevant question.  this also worked for multi-part questions which 
the client wanted to show as the same question.

not elegant, but done.  will report how it works.  results are being 
mapped to access for a custom generated report in word.

----------------------------------------------------------------------

Comment By: winston ford (winstonford)
Date: 2003-10-08 20:13

Message:
Logged In: YES 
user_id=694984

Yes, we're using !other. Great feature, but does not accommodate 
every question.  Effectively, we need to accept comments on 
every question, even, for instance, when someone chooses and 
fills out the "other" option.   

----------------------------------------------------------------------

Comment By: Matthew Gregg (greggmc)
Date: 2003-10-08 12:32

Message:
Logged In: YES 
user_id=14116

Have you looked at the !other option?  That allows a comment
field for radio/checkbox question types. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=820097&group_id=8956

[phpesp-dev] [ phpesp-Bugs-822227 ] Another quote problem

[SourceForge.net <no...@so...>]

Bugs item #822227, was opened at 2003-10-12 15:47
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=822227&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Elie De Brauwer (amo-ej1)
Assigned to: Nobody/Anonymous (nobody)
Summary: Another quote problem

Initial Comment:
Create a new survey,
add a question, with the name "blah"
click on new field
now lick on the button '1' to go back and look at the
question you added before, the name is now _BLAH




----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=822227&group_id=8956

[phpesp-dev] Administration GUI

[Karol W. da P. <da...@ho...>]

Are you able to say when the new designs for the administration will be 
available? I plan to use phpESP software für some projects and need some 
"more professional" GUI, so I would have to do the redesign by myself if you 
won't be releasing something the next weeks...

besides that: thanx 4 thix cool piece of software...

_________________________________________________________________
MSN - More useful every day http://www.msn.de

Re: [phpesp-dev] CVS forking patch ?

[Kon <ang...@ip...>]

As Matthew said the patch still needs some work especially when it comes
to dealing with saved/resumed surveys and navigating back/forward
through surveys. I would have looked at it by now but am trying to get
advanced reporting included into the tool.

So if anyone wants to devote some time to it please fell free to do so
and I'd be more than willing to help out where I can.


Kon


On Fri, 2003-10-10 at 23:51, Matthew Gregg wrote:
> The patch is available here[1].  It should apply against the current
> CVS.  I would not want to apply it to the main CVS tree in its current
> state.  However, anyone that wants to work on it can check out CVS,
> apply the patch and fix it up.  If you're able to work on it, please
> do.
> 
> 
> [1] http://bfs.itlab.musc.edu/~greggmc/stuff/newfork.patch
> 
> On Fri, Oct 10, 2003 at 09:34:47AM +0200, Eric Bont wrote:
> > Hi,
> > 
> > Maybe it's a good idea to place Kon's 'forking' patch to the CVS tree ?
> > Then we can all try to test/bugfix it.
> > 
> > Eric
> > 
> > _________________________________________________________________
> > Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
> > 
> > 
> > 
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > SourceForge.net hosts over 70,000 Open Source Projects.
> > See the people who have HELPED US provide better services:
> > Click here: http://sourceforge.net/supporters.php
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> > 

Re: [phpesp-dev] CVS forking patch ?

[Matthew G. <gr...@mu...>]

The patch is available here[1].  It should apply against the current
CVS.  I would not want to apply it to the main CVS tree in its current
state.  However, anyone that wants to work on it can check out CVS,
apply the patch and fix it up.  If you're able to work on it, please
do.


[1] http://bfs.itlab.musc.edu/~greggmc/stuff/newfork.patch

On Fri, Oct 10, 2003 at 09:34:47AM +0200, Eric Bont wrote:
> Hi,
> 
> Maybe it's a good idea to place Kon's 'forking' patch to the CVS tree ?
> Then we can all try to test/bugfix it.
> 
> Eric
> 
> _________________________________________________________________
> Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
> 
> 
> 
> This SF.net email is sponsored by: SF.net Giveback Program.
> SourceForge.net hosts over 70,000 Open Source Projects.
> See the people who have HELPED US provide better services:
> Click here: http://sourceforge.net/supporters.php
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> 

-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] CVS forking patch ?

[Eric B. <eri...@ho...>]

Hi,

Maybe it's a good idea to place Kon's 'forking' patch to the CVS tree ?
Then we can all try to test/bugfix it.

Eric

_________________________________________________________________
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/

[phpesp-dev] question

[Stefan C. <sch...@ea...>]

In the acl, is this right :

pall - all the groups for which the current user can create respondent 
accounts AND designers accounts

puser - all the groups for which the current user can create respondent 
accounts only

Stefan ?

[phpesp-dev] bugs in privileges

[Stefan C. <sch...@ea...>]

As a general warning, be very carefull with the user privileges and designer 
management, there are a lot of small glitches... Especially, when you give a 
designer the right to create/edit other designers. I've just spent 3 hours 
fixing that and I'm still not done...


stF