Odp: [PHP-DB] Someone using the tool DeZign
Od: "Ruprecht Helms" <[EMAIL PROTECTED]> Temat: [PHP-DB] Someone using the tool DeZign > does someone using DeZing as Tool for modelling databases? > I have some trouble with the ImportER Access. I use this tool and I found it usable and comfortable in my work. AFAIK, ImportER Access is not as mature as other tools from Heraut, but what problem exactly do you have? Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Linux/PHP/Interbase
Od: "Todd Cary" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Linux/PHP/Interbase > I am still trying to find out which RPM I need to install... I think it's apache-devel, i also have RH 6.2 now! But, to be honest, you should go for apache 1.3.20, if it's possible, all up to 1.3.19 had some leaks... Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Linux/PHP/Interbase
Od: "Todd Cary" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Linux/PHP/Interbase > [Configuring SAPI modules] > checking for AOLserver support... no > checking for Apache module support via DSO through APXS... > Sorry, I was not able to successfully run APXS. Possible reasons: > 1. Perl is not installed; > 2. Apache was not compiled with DSO support (--enable-module=so); > 3. 'apxs' is not in your path. Looks like you do not have apache-devel module installed. Or, you didn't compile apache with --enable-module=so option! Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Linux/PHP/Interbase
Od: "Todd Cary" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Linux/PHP/Interbase > Many thanks for your answer! However, I have one additional request: how to > compile PHP under Linux 7.1? As I said previously, Linux/Unix is new to me > and it has been quite a few years since I did any programming with "C/C++" - > Delphi has been my mainstay for my clients. > > Could you share with me the steps in compiling programs under Linux? This > might force me to brush the dust off of those "C" books on my shelf!! In most case it's done by: $:./configure (here's the place to put some options) $: make $: make install-strip (or simply make install, if stripping debug info option isn't available). If you look for particular ./configure options, type ./configure --help |less >conf.opt then go for your favorites. As for Delphi and Linux - they are different, but... not at all... I think that getting to Linux world is much more easier if you work with Delphi than if you work with VC++... Anyway, don't hesitate to ask me privately if you have any questions that you wouldn't like to ask in public. Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Re: interbase or postgres
Od: "Michael" <[EMAIL PROTECTED]> Temat: [PHP-DB] Re: interbase or postgres > J-E-N wrote: > > > > just want to here comments from you guys. i will be doing a shopping cart and i'm still looking for the best database which i could use aside from Oracle.i'm still thingking which is better. interbase or postgres? > > Just a few comments - > Postgresql has a larger range of data types and built in string > functions, > Interbase has no text datatype and (I think) "like" doesnt use an index. The "text" datatype is present, but is a BLOB subtype (as usually in C world - it's not a text, it's "null-terminated string"). > I don't think you'd do badly using either but I'd lean towards > postgresql. It seems to be deveoping at a faster rate than Interbase and > probably has the edge performance wise. While Postgres has better future, IB is better now. IB has long way away as a commercial product, being utilized by most critical user (US Army used IB in it's M60TTS and M1 to M1IPM tanks). Anyway, i like IB. It's always the same - under Linux, Solaris, NT, NetWare... Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] InterBase
Od: "Sergey Larionov" <[EMAIL PROTECTED]> Temat: [PHP-DB] InterBase > "Warning: InterBase: arithmetic exception, numeric overflow, or string > truncation Cannot transliterate character between character sets in > /home/larionov/public_html/base.php on line 6" > How I can turn off tranliteration? You cann't just "turn it off" - this message means that client charset is different than db charset. If you have database created with default character set, say, WIN1252, you will get this message when you try to retrieve row using, say, WIN1250 and the row contains characters from outside of WIN1250 character set. This also happens when you do not specify character set when creating columns in tables then connect specifying character set - all characters above #127 will be trated as illegal and raise this error. That's why the best approach is to specify default character set when creating database - all character and text blob columns will use this character set and no special processing will be nacessary during connecting, just set the appropriate lc_ctype variable in database parameter buffer (i.e. in ibase_connect parameters). Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Interbase/PHP/Apache implimentation
Od: "Jordan" <[EMAIL PROTECTED]> Temat: [PHP-DB] Interbase/PHP/Apache implimentation > So my question is this: Can DBMS support be enabled using the extension=php_interbase.dll directive > in the php.ini file (as opposed to MySQL, where support is built in) ONLY while in CGI mode? Will > the distribution version of php4apache.dll not look at the php.ini file, to enable Interbase > support? > > If that is the case, is there anywhere one might find a version of the php4apache.dll file which > enables Interbase support? > I will use CGI if I must, but my preference is to use the Apache Module I have 2 installations: on NT4 at work and W98 at home, both working as a module. Except of OS the configuration is same: Apache 1.3.19, PHP 4.0.5, Borland's IB 6.0.1. If you are interested, i can send you my php.ini files privately, although this one from my work in tuesday. Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Interbase BLOB Insertion Problem
Od: "Xanir" <[EMAIL PROTECTED]> Temat: [PHP-DB] Interbase BLOB Insertion Problem > begin declare section; > based on test.v1 document; > based on test.v1.segment BlobV1Buffer; > based on test.state CA; > unsigned short BlobV1Len; > end declare section; This is DSQL statement, you cann't use it in ISQL! For detailed description of IB BLOB hadling in PHP go to www.open-database.de Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Performance of Stored Procedures ?
Od: "Robert Boehrs" <[EMAIL PROTECTED]> Temat: [PHP-DB] Performance of Stored Procedures ? > i've just made some simple test with oracle and stored procedures. I've used > a simple select-statement within the stored procedure and the same query for > a direct query within php. > The direct query was about 50% faster. Is that normal? Will the stored > procedures become faster with more complex queries? Most of performance benefit you will get when performing complex computations on data, such calculating taxes, rebates and other things. Selects are not too good examples. Cheers Jarek Zgoda -- 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] Oracle Database Class
Hi, try this: http://php.weblogs.com/ADODB Jarek Neil wrote: > > Hi All > > I want to build a site using classes and was wondering is there an Oracle > Database class that I can use instead of writing one from scratch. I don't > want to use abstraction layers. Can aynone direct me to a place where I can > dowload such a class definition? > > Neil Craig > QEDI (Pty) Ltd > > -- > 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 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] *.xls
HI, We are trying to do some functions to export data from database to Excel format. We have specyfication of the excel file format, and we are trying to generate binary file bite by bite, but we have problems with borders and frames. Maybe someone hes experienced similar problems? best regards Jarry Steve Brett wrote: > > i'd also be interested in this ... i have some code that will create .csv > files for download, whihc is the way i normally do it. > > Steve > > > -Original Message- > > From: Aivar Annamaa [mailto:[EMAIL PROTECTED]] > > Sent: 08 May 2001 13:02 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] *.xls > > > > > > Hi > > Does anyone know some lib for generating excel files. > > I ask it here because database people could use such thing. > > > > Aivar Annamaa > > > > > > > > -- > > 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 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 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]
Odp: [PHP-DB] invalid select results from sybase with php - SOLVED
Od: "David OlszyĆski" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] invalid select results from sybase with php - SOLVED > I couldn't believe it: The problem is that php can't handle such big > numbers! :-O > Damned language! ;-) Nothing new - PHP also cann't handle NUMERIC type with scale > 9 in InterBase, they will be always seen as integers... Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Migrating from InterBase 4.0 to 6.0
Od: "Steve Farmer" <[EMAIL PROTECTED]> Temat: [PHP-DB] Migrating from InterBase 4.0 to 6.0 > I need to migrate a database from InterBase 4.0 to 6.0 . Question is > has anybody done this and what are the snafus !! > > The migration docs for 6.0 only seem to mention migration from 5.0 !! > > I would imagine a complete export from 4.0 and import into 6.0 would > be the way to go. It is not directly "in topic"... There should be no problem with migration, if you have IB 4.0.2 - after restoring database in IB 6 you will get the same result. For specific IB help go to www.mers.com site or try asking at one of their newsgroups at news.mers.com Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] ? interbase ?
Od: "Bart A. Verbeek" <[EMAIL PROTECTED]> Temat: [PHP-DB] ? interbase ? > 1.> Can interbase be installed and run on every Unix-type (BSD)? > I've taken a look on the borland site but they only speak of Linux and > windows. Official Borland builds run only on Win32 and Linux. There are several other platforms supported by Firebird Project (firebird.sourceforge.net). > 3.> Is it possible to run MySQL and Interbase on the same server? Yes, they use different ports (MySQL 3360, IB 3050). > 5.> Does PHP have the same capabilities for Interbase as for MySQL? Bit less, but Interbase has bit more capabilities than MySQL. > 6.> How difficult is it to install a binary (not found on Borland site) or > to compile it from source for a BSD-server? You can find binaries at firebird.sourceforge.net and www.ibphoenix.com. > 9.> Why would anyone choose Interbase when they can use MySQL on the same > server? IB is best used when you don't want separate data accessible from www and your corporate data or your site data will be often updated concurrently by many users. Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Re: PostgreSQL versus MySQL
Od: "Bob Hall" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Re: PostgreSQL versus MySQL > > > The implication is that MySQL is not an RDBMS. The only attempt I > > > know of to define an RDBMS was Codd's, and no DBMS has ever met the > > > criteria he published in a paper in the late 80s (1986?). Even though > > > Oracle doesn't meet the criteria of the best known definition (only > > > definition?) of an RDBMS, we all seem to agree that Oracle is an > > > RDBMS. An RDBMS is a DBMS designed to manage a relational database, > > > and a database is relational because it stores data in linked, > > > normalized tables. > > > >The only thing I question in this is that without transaction support, > >what exactly is MySQL "managing"? > > The data in the normalized tables. Of 12 Codd's rules (1985), MySQL doesn't meet four: 5 - full internal language implementation with transactional processing support; 6 - using views for data modification; 10 - autonomous referential integrity mechanism built into database; 11 - autonomous data distribution. Of SQL-92 instructions MySQL doesn't implement following: CREATE | DROP SCHEMA, DECLARE LOCAL TEMPORARY TABLE, CREATE | ALTER | DROP DOMAIN, CREATE | DROP CHARACTER SET, CREATE | DROP COLLATION, CREATE | DROP TRANSLATION, CREATE | DROP VIEW, ALLOCATE | DECLARE | OPEN | CLOSE CURSOR, COMMIT, ROLLBACK, FETCH, CLOSE, CREATE | DROP ASSERTION, SET CONSTRAINTS MODE, SET SESSION AUTHORIZATION, SET TRANSACTION MODE, SET NAMES, SET SCHEMA, SET TIME ZONE, ALLOCATE | SET | GET | DEALLOCATE DESCRIPTOR, DESCRIBE, PREPARE, DEALLOCATE PREPARE, EXECUTE, EXECUTE IMMEDIATE, GET DIAGNOSTICS This set is about 85% of SQL-92 standart, but i didn't see any DBMS that implements that all. Of SQL-92 keywords, about 65% is absent in MySQL, but they are not too often used even if they are present with significant exception of trigger and procedural language. Cheers Jarek Zgoda -- 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] Character set?!
If i try to connect to MySQL from PHP i receive an error, that says that "character set #9 couldn't be initialized". PHP tries to look for a directory with charsets somewhere in /usr/local/..., but the charsets are installed in /usr/share/mysql/charsets - that's where they are installed from rpm. I added to my.cnf a line in [client] section (as in manual) and daemon is running with --default-character-set=latin2. All other (non-PHP) applications connect without problems and everything is running OK. What else can i do to enable using latin2 charset? Cheers Jarek Zgoda -- 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] Oracle functions and procedures via OCIParse and OCIExecute
Hi! I wonder if you have had the same problems with invoking oracle functions and procedures via OCIParse, OCIExecute functions? When I am trying to invoke a function or execute a procedure I receive an OCIStmtExecute error. The same statements works perfrectly direct in sqlplus. It't waird! Jarek -- 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] Problem with IB's LEN
I have in my Interbase6 table a column defined as NUMERIC(18,2), but PHP shows it as integer value. During tests i discovered, that largest precision allowed for large exact numeric is 9 (NUMERIC(9,2)). Is there any switch that allows use larger precisions? Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] An Error on Interbase Database
Od: "Ahmet Bagci" <[EMAIL PROTECTED]> Temat: [PHP-DB] An Error on Interbase Database We are writing a program with php that use interbase database. we have a problem. The error message is follow: ISC ERROR CODE:335544333 ISC ERROR MESSAGE: internal gds software consistency check(wrong record length(183)) ATATEMENT: TIBOInternalDatabase: "ibqsingle.IBOqribqSingle" this message is from Interbase Workbench. Go to www.ibphoenix.com and look for article on repairing corupted databases. Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Problems with character sets
Od: "magor" <[EMAIL PROTECTED]> Temat: [PHP-DB] Problems with character sets > Hello everybody, >I have problems concerning character sets.I use InterBase database. > I have data in columns with character set NONE, but the data is in fact in > win1250 coding. I have other columns with character set WIN1250. I want to > from these NONE columns to these WIN1250 columns, but InterBase does not let > me. There's only one thing you can do without moving whole data to new - properly defined - database. Try to change RDB$CHARACTER_SET_ID in RDB$RELATION_FIELDS, but first do a backup - it's a system table... Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB]
Od: "signup" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] > However, the answer about needing to define a PK before you can use it as a > FK being a limitation of SQL may have been a bit misleading (sorry, Jarek). > It is more of a building block of relational theory rather than a > limitation of SQL. It depends from POW: for database designer it's a part of RDB theory, but for programmer it's a limitation. That's why programmers need CASE tools ;-) Cheers Jarek -- 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]
Odp: [PHP-DB] Interbase and PHP support.
Od: "Mike" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Interbase and PHP support. > > The BLOB functionality in the PHP interface is unstable. > > The process running the blob function crashes when trying to insert a > > blob ID into a table. > > That is a pretty large flakiness. > > There was one quite critical bug related to this that I fixed on July 9th > and it appeared in 4.0.2. If you are using that version, please file a bug > report with an example. BLOB functionality in this module isn't well > tested, and without some help/testing from users, could remain flaky > forever. I think that it has been finally adressed in 4.04 with php_ibase.dll version 1.48 - i had similar problems. Cheers Jarek Zgoda -- 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] Tokenizing memo field
I maitain a database of pascal code snippets in text blob. It is inserted from object. I would like to add some syntax - coloring to display, but i have problem with strtok function - it does not allow using CR+LF (or LF) as string tokenizer. Is there any way to get the contents of this field into an array, like loading file contents with file(). Cheers Jarek Zgoda -- 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]
Odp: [PHP-DB] Text Control.
Od: "simon" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Text Control. > Ian wrote: > > > Dear Sir / Madam, > > > > Problem :- > > Data from HTML > WRAP="virtual"> is likes, > > This is a testing messages:- > > 1. MSG A. > > 2. MSG B. > > 3. MSG C. > > > > So, I insert $test into MYSQL database. After that, I login into MYSQL and > > select the test field, the display is same as above. But, when I used PHP > > coding to select the test field and display it in HTML page, output likes, > > This is a testing messages:- 1. MSG A. 2. MSG B. 3. MSG C. > > > > How to display $test in the requested format? > You could try using the nl2br function, thus converting all newline > characters to tags. > > http://uk.php.net/manual/function.nl2br.php Eventually you can show contents of this field using tags - it's specially useful in situation like this: - in you enter text like MSG A MSG B <- note two [spaces] here MSG C <- here are four [spaces] - when you show it in html document you see exactly the same thing. Cheers Jarek Zgoda -- 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]