Re: [PHP-DB] Database Paging

2001-03-06 Thread Manuel Lemos
ges: http://phpclasses.UpperDesign.com/browse.html/package/130 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] limit in informix

2001-03-12 Thread Manuel Lemos
Metabase also supports Informix. Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] DB Abstraction

2001-03-18 Thread Manuel Lemos
from a database independent schema description format that you can edit by hand in a custom XML format. Metabase is freely available and has been downloaded by over 4.400 users from here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components

Re: [PHP-DB] managing large result sets

2001-03-29 Thread Manuel Lemos
near the HTML tables. http://phpclasses.UpperDesign.com/browse.html/package/130 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Manuel Lemos
irst time the schema was installed or it was changed for the last time. No sweat, no risk mistake. Look at Metabase here: http://phpclasses.UpperDesign.com/browse.html/package/20 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additiona

Re: [PHP-DB] metabase support

2001-04-01 Thread Manuel Lemos
without schema management, but it provides great schema maintenance aid. When support for primary/foreign keys is added explicitly you will be able to upgrade your schemas without worry. So, you can use Metabase with schema management as it is now. Regards, Manuel Lemos Web Programming Components

Re: [PHP-DB] Validating forms

2001-04-02 Thread Manuel Lemos
PHP form generation and validation class that does precisely what you want and more: http://phpclasses.UpperDesign.com/browse.html/package/1 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-07 Thread Manuel Lemos
it uses the isNaN(parseInt(value)) Javascript functions. For the server side it uses the strcmp($value,strval(intval($value))) PHP functions . Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL

Re: [PHP-DB] using LIMIT

2001-04-07 Thread Manuel Lemos
rows in HTML tables with optional links to go to the next, previous, first, last, etc... result pages. It uses MetabaseSetSelectedRowRange($database,$first,$limit) function to choose the rows that it displays in each page. Regards, Manuel Lemos Web Programming Components using PHP Cl

Re: [PHP-DB] Oracle session cursor

2001-04-16 Thread Manuel Lemos
umentation and a tutorial from here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP

Re: [PHP-DB] Database Name in Metabase (Manuel Lemos)

2001-05-15 Thread Manuel Lemos
of the MetabaseSetupDatabase function. The database name is set with the MetabaseSetDatabase function. Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re: [PHP-DB] Metabase Tutorials

2001-05-16 Thread Manuel Lemos
document along with the main document in Metabase page. These documents have been updated and you may find more complete versions here: http://groups.yahoo.com/group/metabase-dev/files/beta/documentation/ Just let me know if you still have any doubts. Manuel Lemos -- PHP Database Mailing List

Re: [PHP-DB] Return Row count with OCI

2001-05-23 Thread Manuel Lemos
the MetabaseNumberOfRows function. You may download Metabase for free from here: http://phpclasses.UpperDesign.com/browse.html/package/20 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] db abstraction: sql design

2001-06-20 Thread Manuel Lemos
: Query result table display class http://phpclasses.UpperDesign.com/browse.html/package/130 Database access class http://phpclasses.UpperDesign.com/browse.html/package/231 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED

RE: [PHP-DB] db abstraction: sql design

2001-06-20 Thread Manuel Lemos
. For instance, not all databases takes dates formatted in the same way. AFAIK, PEAR-DB is like Perl-DBI and so it does not support datatype conversion and many other things important for assuring SQL code portability. Metabase and ADO-DB support datatype conversion. Regards, Manuel Lemos Web

Re: [PHP-DB] MSSQL limit capability

2001-06-20 Thread Manuel Lemos
/package/130 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp -- -- PHP Database Mailing List (http

Re: [PHP-DB] advantages/disads of primary keys and indices?

2001-06-23 Thread Manuel Lemos
tables will hold many values, but beware that indexes also take disk space. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e

Re: [PHP-DB] advantages/disads of primary keys and indices?

2001-06-23 Thread Manuel Lemos
with the new entry value. Anyway, some times it may pay to slow down inserts and updates for very large tables. You have to check if the indexes/primary keys that you are adding are used as the first condition of the WHERE clause. Regards, Manuel Lemos Web Programming Components using PHP

Re: [PHP-DB] advantages/disads of primary keys and indices?

2001-06-23 Thread Manuel Lemos
the three fields: username, siteid and bannerid. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp

Re: [PHP-DB] advantages/disads of primary keys and indices?

2001-06-23 Thread Manuel Lemos
Hello, Thank you! this wont slow updates or inserts? Not the updates. The update query will use the index to lookup find the table line that it will update. Then, since you will not change any of the indexed columns the index does not need to be updated too. Manuel Lemos - Original

[PHP-DB] Re: MySQL Database Locking - needed?

2001-07-10 Thread Manuel Lemos
application code. Metabase is free and is available here: http://phpclasses.UpperDesign.com/browse.html/package/20 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] Re: Performance: why it take so long time?

2001-07-15 Thread Manuel Lemos
is smaller if I do some calculation in the code than if I don't use it) I think your are noticing the Oracle server connection overhead. You'd better use persistent connections to avoid this overhead after the first connection. Regards, Manuel Lemos Web Programming Components using PHP Classes

[PHP-DB] Re: NEXT - PREVIOUS coding

2001-07-16 Thread Manuel Lemos
in HTML tables eventually spliting the results in pages that you may go using links like you want. http://phpclasses.UpperDesign.com/browse.html/package/130 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

[PHP-DB] Re: remote database exchange

2001-07-17 Thread Manuel Lemos
subscribers there are in a given mailing list. http://phpclasses.UpperDesign.com/browse.html/package/177 Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e

Re: [PHP-DB] Re: remote database exchange

2001-07-17 Thread Manuel Lemos
recommend one because I haven't tried any. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: database abstraction for php3

2001-07-25 Thread Manuel Lemos
they access to databases. http://groups.yahoo.com/group/metabase-dev/surveys?id=639035 Metabase is a database abstraction package that supports many DBMS and is freely available here: http://phpclasses.UpperDesign.com/browse.html/package/20 Manuel Lemos -- PHP Database Mailing List (http

[PHP-DB] Re: database abstraction for php3

2001-07-25 Thread Manuel Lemos
they access to databases. http://groups.yahoo.com/group/metabase-dev/surveys?id=639035 Metabase is a database abstraction package that supports many DBMS and is freely available here: http://phpclasses.UpperDesign.com/browse.html/package/20 Manuel Lemos -- PHP Database Mailing List (http

[PHP-DB] Re: NEXT - PREVIOUS coding

2001-08-12 Thread Manuel Lemos
up on scren at a time, then a NEXT link should be visible which could show the remaining 10 records. Their can be n no. of records. Maybe you would like to try this PHP class that does exactly what you are asking. http://phpclasses.UpperDesign.com/browse.html/package/130 Regards, Manuel Lemos

[PHP-DB] Re: oracle (oci8) intro

2001-08-21 Thread Manuel Lemos
, and it will return a result set with just the range of rows that you selected. Metabase is free and is available here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] oracle (oci8) intro

2001-08-21 Thread Manuel Lemos
that is using server side cursors, but I could not figure how to return to the client side, a server side cursor that I could use skip rows and get only those that I want. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] Re: Database Transactions and HTTP statelessness

2001-08-28 Thread Manuel Lemos
/package/108 Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: Oracle takes 5 seconds to logon in PHP, ASP is instant??? Wussup?

2001-08-29 Thread Manuel Lemos
Hello, Bawy wrote: ? $db = newora; $c2 = ocilogon(cst,cst,$db); echo done; ? This takes 5 seconds to appear, what is wrong? An ASP script I wrote connects instantly. TNSPING shows newora to be OK and responds instantly. Try OCIPlogon. Regards, Manuel Lemos -- PHP Database Mailing

[PHP-DB] Re: Really weird problem: cross-server databasing *g*

2001-09-02 Thread Manuel Lemos
. In that case, you may want to try this SOAP server PHP base class that you can use to develop new SOAP services without having to learn too much about the protocol. http://phpclasses.UpperDesign.com/browse.html/package/251 Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: ODBC DataBase Paging Solution

2001-09-16 Thread Manuel Lemos
://phpclasses.UpperDesign.com/browse.html/package/20 Query result display class http://phpclasses.UpperDesign.com/browse.html/package/130 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http

[PHP-DB] Re: Application-based locking with PHP?

2001-09-23 Thread Manuel Lemos
is freely available here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http

[PHP-DB] Re: importing BLOBs from MSSQL

2001-10-25 Thread Manuel Lemos
databases including MSSQL. Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-20 Thread Manuel Lemos
for different languages or just wrap around each other, so they are really not competing in the same language domain. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV]Adoption of Metabase

2001-11-27 Thread Manuel Lemos
clearly with some detail complex concepts like prepared queries, transctions, blobs, etc... Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail

[PHP-DB] Re: Common DB Abstraction Layer:

2001-11-27 Thread Manuel Lemos
Hello, Tomas V.V.Cox wrote: Manuel Lemos wrote: Hello, John Lim wrote: Each designer has a different point of view, like Tomas has written a really excellent oci8 select limit emulation, but looking at the code, it's so complicated that i decided not to incorporate

[PHP-DB] Re: Oracle row limit support

2001-11-28 Thread Manuel Lemos
Hello, Tomas V.V.Cox wrote: Manuel Lemos wrote: But it does not work with computed columns like those that apply functions (COUNT, SUM, SUBSTRING, etc...). The code assumes that you are actually selecting only real table fields. I think it also does not work with columns

[PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread Manuel Lemos
database abstraction that handles CLOB/BLOBs very well with any supported database including Oracle. Take a look at the example described in Metabase tutorial document. http://phpclasses.UpperDesign.com/browse.html/20 Regards, Manuel Lemos John Kolvereid wrote: Hi, I tried the following

[PHP-DB] Re: Mass Mailing

2001-12-03 Thread Manuel Lemos
interface for managing ezmlm mailing lists. It even comes with a SOAP interface for managing subscriptions programmatically eventually from a remote machine. http://phpclasses.UpperDesign.com/browse.html/package/177 Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net

[PHP-DB] New Object Oriented Programming (OOP) mailing list for PHP programmers

2001-12-20 Thread Manuel Lemos
to the page http://groups.yahoo.com/group/php-objects/ . If you send the message to the above address I think you do not need to have a Yahoo account if you don't have one and don't want to subscribe to it. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

Re: [PHP-DB] Unveilled Metabase OOP direct to driver object API

2001-12-24 Thread Manuel Lemos
, just take a look first at Metabase tutorial document. Regards, Manuel Lemos SF At 06:20 24/12/2001 -0200, Manuel Lemos wrote: Hello, If you are reading this and do not know what is Metabase, be aware that it is PHP database abstraction package for developing truely portable database

Re: [PHP-DB] How to speed up querries in a humangous db?

2001-12-26 Thread Manuel Lemos
, which is a very inefficient thing. Just tell the exact definition of your indexes so we can tell you if the query will execute a full scan or not. Alternatively, if you are using MySQL, you may use the EXPLAIN SQL command to tell if the query will use any indexes or not. Regards, Manuel Lemos

[PHP-DB] Re: I think i saw this somewhere....

2002-01-06 Thread Manuel Lemos
. Then also add virtual domain entries for www and * to Apache configuration. In your site, you can always check each domain is being accessed by checking the environment variables. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Re: Record Page Through sqlServer Woes

2002-01-10 Thread Manuel Lemos
is here: http://phpclasses.upperdesign.com/browse.html/package/130 An example of output of this class can be seen here: http://phpclasses.upperdesign.com/browse.html/file/414/view/1/name/test_database_table_page.html Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: Query Optimizing on sum() function

2002-01-10 Thread Manuel Lemos
or paypal are accepted. Just kidding! :-) Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-12 Thread Manuel Lemos
would be of less risk. Don't forget the Hotmail platform change fiasco. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-12 Thread Manuel Lemos
above for the advice. :-) Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Manuel Lemos
ideas? You don't have that problem if you use MySQL with Gemini tables of NuSphere. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Manuel Lemos
a cluster server is too busy? I think you should address these questions directly to MySQL AB. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Manuel Lemos
, for busy sites is always a good idea to avoid read only database accesses or else your site will not scale. Besides content caching, it is always important to avoid database accesses for simple but repetitive things like session authentication. Regards, Manuel Lemos -- PHP Database Mailing List (http

[PHP-DB] New Metabase Aniversary release

2002-01-21 Thread Manuel Lemos
suggesting what you have in mind even if you feel that you don't have the time or the skill to do it yourself. Metabase is free Open Source package and can be found with full documentation and tutorials here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos -- PHP

[PHP-DB] Re: [PEAR-DEV] Re: [metabase-dev] RE: [PEAR-DEV] New MetabaseAniversary release

2002-01-23 Thread Manuel Lemos
Hello, Tomas V.V.Cox wrote: El mar, 22-01-2002 a las 19:02, Manuel Lemos escribió: Hello Lukas, Lukas Smith wrote: FYI: there has been a lot of discussion about this project in the last couple months (especially december irrc) on the pear-dev mailinglist. So some questions

[PHP-DB] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-22 Thread Manuel Lemos
elections so you can get a definitive yes or no answer on what you plan to do before you have a go. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] Re: [PEAR-DEV] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Manuel Lemos
parties means, the proposing authors and some PEAR representatives preferrably elected in a democratic process to evaluate proposals and make decisions regarding them. Currently there is nobody elected as PEAR representative but if I got it right it should happen some time soon. Regards, Manuel

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-28 Thread Manuel Lemos
language nor database to clutter the access). Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-28 Thread Manuel Lemos
functions do not let you define the connection timeout parameters or check if the current persistent connection is still alive. Anyway, nothing that a good middleware could not do better for you. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] Re: Cross DB application

2002-04-15 Thread Manuel Lemos
Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Cross DB application

2002-04-15 Thread Manuel Lemos
type of ODBC data source (MS Access, IBM DB2, SAP-DB, etc...) to handle database specific issues that the ODBC API does not handle by itself. Regards, Manuel Lemos Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-15 Thread Manuel Lemos
poster would not mind to have the major headache of doing that, he would not have posted, don't you think? Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-15 Thread Manuel Lemos
but eventually less scalable method is to store the session data in a shared memory cache, so you minimize database accesses to just one after the server is restarted. This is probably the one you want to use as long you know how to deal with shared memory and semaphores. Regards, Manuel Lemos

Re: [PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-15 Thread Manuel Lemos
Hello, Brad Hubbard wrote: On Tue, 16 Apr 2002 14:01, Manuel Lemos did align ASCII characters thusly: Probably the fastest way to keep session profile information is by serializing the data array into a string that will be encrypted and then stored in cookie. The security weakness

Re: [PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-16 Thread Manuel Lemos
Hello, Brad Hubbard wrote: On Tue, 16 Apr 2002 14:51, Manuel Lemos did align ASCII characters thusly: then stored in cookie. The security weakness of this method is that if the secret key leaks, hackers may use to forge new sessions. Is this documented anywhere? Anyway what

[PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-16 Thread Manuel Lemos
the features that PHP ADO DB misses? Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-18 Thread Manuel Lemos
makeup. I think you will be the better judge of that if you try looking at least at each package documentation. It is pointless to ask to people here when most of them only know one or the other package. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-18 Thread Manuel Lemos
. BinaryCloud http://binarycloud.tigris.org/ Metabase http://www.phpclasses.org/metabase Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Search Script

2002-04-25 Thread Manuel Lemos
and would appreciate any help on this. Maybe you would like to see these classes that seem to do what you are looking for: http://www.phpclasses.org/search%20query Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ODBC problem in 4.2.0

2002-04-30 Thread Manuel Lemos
that uses conditional programming based on the PHP version that is running. Regards, Manuel Lemos Regards, John Ryan Jameson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... BTW... I'd just like to point out that this kind of thing is bound t

[PHP-DB] Re: php mail problem.

2002-05-07 Thread Manuel Lemos
/browse.html/package/9.html http://www.phpclasses.org/browse.html/package/14.html -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: database absraction layer

2002-05-07 Thread Manuel Lemos
/package/20.html Regards, Manuel Lemos code snippet.. .. function connect(){ if($this-type == mysql){ $this-conid = mysql_connect($this-host,$this-user,$this-pass); } elseif($this-type == pgsql

[PHP-DB] Re: Simulating a FORM POST thing (HELP!)

2002-05-28 Thread Manuel Lemos
is a file upload?!?!?! For the record, its a GIF file you've to upload. Is there any way to do this in PHP?? You may want to try this class that does precisely that. http://www.phpclasses.org/httpclient -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Book about Metabase

2002-06-13 Thread Manuel Lemos
the database independent access to databases using Metabase API. A review of the book will be published in the next weeks here not by me (I don't want you to think it would be biased) but by Alex Black of BinaryCloud fame. http://www.phpclasses.org/products.html/id/0735712271.html -- Regards, Manuel

[PHP-DB] Re: Excel to MySQL??

2002-06-29 Thread Manuel Lemos
Windows. Anyway, if you are running PHP under Windows, you may as well use COM objects to access to Excel spreadsheets. In that case you may want to try this class: http://www.phpclasses.org/browse.html/package/86.html -- Regards, Manuel Lemos -- PHP Database Mailing List (http

[PHP-DB] Re: Unified DB Query function

2002-07-01 Thread Manuel Lemos
SQL. Why do you re-invent the wheeel and don't you use a database abstraction package that handles the database differences of you, like for instance Metabase: http://www.phpclasses.org/metabase -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Re: Unified DB Query function

2002-07-01 Thread Manuel Lemos
the xDefinition methods in metabase ? What do you mean by xDefinition methods? -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Unified DB Query function

2002-07-01 Thread Manuel Lemos
Hello, On 07/01/2002 05:03 PM, Casey Allen Shobe wrote: On Monday 01 July 2002 01:55 pm, Manuel Lemos wrote: Why do you re-invent the wheeel and don't you use a database abstraction package that handles the database differences of you, like for instance Metabase. Because I had never

[PHP-DB] Re: SQL mailing list

2002-07-09 Thread Manuel Lemos
know that you may leave any SQL questions after the beep. beep :-) -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Unified DB Query function

2002-07-25 Thread Manuel Lemos
support, if you are willing to do anything about it, I can help you to pin point the problems that need to be addressed. Otherwise it is quite pointless to even consider using ODBC in PHP unless it is your really alternative. Regards, Manuel Lemos Best regards, Andrew Hill Director

Re: [PHP-DB] MSSQL functions vs. ODBC functions

2002-07-25 Thread Manuel Lemos
ODBC API does not provide information or functions to deal with the underlying database in a independent manner. Maybe you should try developing real database independent applications with it so you can have a real picture of how frustrating it can be. Regards, Manuel Lemos Best regards

Re: [PHP-DB] Re: Unified DB Query function

2002-07-31 Thread Manuel Lemos
details that PHP ODBC support is uncapable of providing. Regards, Manuel Lemos -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Unified DB Query function Hello, On 07/25

Re: [PHP-DB] Mail problem

2002-08-01 Thread Manuel Lemos
to put all recipients in Bcc: because queuing via SMTP is much slower than using a local mailer like sendmail and it would take you a long time to queue if you send separate messages for each recipient. -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Re: Database abstraction layer needed?

2002-08-17 Thread Manuel Lemos
types, a database independent abstraction layer is probably not very interesting. So what do you want the abstraction layer to abstract? -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: htdig interface class

2002-08-28 Thread Manuel Lemos
, just let me know because I wrote that class. -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: convert mysql table to Excell or Access file

2002-08-28 Thread Manuel Lemos
Hello, On 07/12/2002 07:36 PM, Alex Shi wrote: Can MySQL table be converted to Access or Excell format? Alex You may want to try this class that can write Excell files just with PHP, so it can run under Linux/Unix too: http://www.phpclasses.org/biffwriter -- Regards, Manuel Lemos

[PHP-DB] Re: MIME encoding and simplified chinese....help!

2002-10-14 Thread Manuel Lemos
don't know what class are you using, but if it is this class, all you need to do is to specify the chinese encoding that you want to use in the optional charset argument of the SetHeader function. -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: MIME encoding and simplified chinese....help!

2002-10-14 Thread Manuel Lemos
. I don't know what class are you using, but if it is this class, all you need to do is to specify the chinese encoding that you want to use in the optional charset argument of the SetHeader function. I meant this class: http://www.phpclasses.org/mimemessage -- Regards, Manuel Lemos -- PHP

[PHP-DB] Re: TOO MANY CONNECTIONS!!

2002-10-23 Thread Manuel Lemos
://www.phpclasses.org/filecacheclass -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Automattic Rollback on User Cancel with MySQL

2002-10-19 Thread Manuel Lemos
://www.phpclasses.org/metabase -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: String extraction from blobs. Extracted string to be placedinto field within another table.

2002-10-20 Thread Manuel Lemos
to be updated or inserted by another query, with minimal memory usage, thus allowing to manipulate large sized blobs. Metabase is a database independent abstraction layer so it works with many supported databases: http://www.phpclasses.org/metabase -- Regards, Manuel Lemos -- PHP Database

[PHP-DB] Re: Performance problems?

2002-11-01 Thread Manuel Lemos
in memory just to returned the results sorted. If you just want the highest id, use MAX(id) . -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Performance problems?

2002-11-02 Thread Manuel Lemos
) and another to fetch just the row with the resulting id from the first query, you will most likely run that faster than the query with order by that you did. Using order by in result sets with a large number of rows is considered to be a SQL sin. :-) -- Regards, Manuel Lemos -- PHP Database

[PHP-DB] Re: Abstraction layer or not?

2002-11-05 Thread Manuel Lemos
this here: http://www.meta-language.net/news-2002-11-01-persistence.html http://www.phpclasses.org/metabase -- Regards, Manuel Lemos ?xml version=1.0 encoding=iso-8859-1? !-- (#) $Id: cms.component,v 1.3 2002/11/06 01:52:52 mlemos Exp $ -- component namecms/name descriptionContent management

[PHP-DB] ANNOUNCE: Metastorage object persistence API generator

2002-12-05 Thread Manuel Lemos
_ Released Metastorage generator Manuel Lemos, 2002-12-05 16:11:44 GMT Metastorage is an application that is capable of generating persistence layer APIs. It takes a component definition defined in the Component Persistence Markup Language (CPML), a XML based format, and generates

[PHP-DB] ANNOUNCE: Metastorage object persistence API generator

2002-12-05 Thread Manuel Lemos
_ Released Metastorage generator Manuel Lemos, 2002-12-05 16:11:44 GMT Metastorage is an application that is capable of generating persistence layer APIs. It takes a component definition defined in the Component Persistence Markup Language (CPML), a XML based format, and generates

[PHP-DB] Metastorage generates Entity-Relationship class diagrams in UML

2002-12-09 Thread Manuel Lemos
in the Metastorage documentation. Here you may find the complete announcement with example graphics and the relevant links: http://www.meta-language.net/news-2002-12-09-metastorage.html -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] form validation

2002-12-20 Thread Manuel Lemos
ideas, or does everyone just use javascript with say...alert boxes. This will be my last resort. You may want to use this class that does exactly what you need. -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form validation

2002-12-22 Thread Manuel Lemos
Hello, On 12/22/2002 07:48 AM, Antonio Bernabei wrote: I am intersted, but maybe I lost the link to the class you mentioned Sorry, I forgot to mention the URL: http://www.phpclasses.org/multipageforms -- Regards, Manuel Lemos I am developing a db form that gets passed to another form. I

[PHP-DB] Re: calendar system

2002-12-27 Thread Manuel Lemos
that. http://www.phpclasses.org/calendargenerator -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   >