Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

2016-11-22 Thread Lester Caine
On 22/11/16 18:01, Delmar Wichnieski wrote: > 2016-11-22 12:42 GMT-02:00 Lester Caine : > >> > needs help to move >> > the string to a variable that it can check if the UTF8 data is a single >> > character or multiple characters. >> > >> > >

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

2016-11-22 Thread Lester Caine
of a UTF8 native PHP6. Normalization in http://www.unicode.org/reports/tr15/ is a minefield even for the Firebird collation process ... Just how long is the normalized string? > 2016-11-22 11:21 GMT-02:00 Lester Caine : > >> > On 22/11/16 12:58, Delmar Wichnieski wrote: >>

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

2016-11-22 Thread Lester Caine
nsfer the simple php strings to mbstring objects. UTF8 is a gambol in PHP if it is going to be transferred properly as a simple string variable and will give string length as bytes rather than characters ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wi

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Lester Caine
x27;full' text as it is getting information from the local user settings. > The time stamps (minute, hour, day, etc) that precede the /usr are loaded by > my host. just fyi. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Lester Caine
On 20/09/16 09:14, Karl DeSaulniers wrote: > Pardon my ignorance, but what do you mean full path? Full path to php application. Cron jobs run as 'root' and so need and user account settings added manually if they do not match the 'root' environment. -

Re: [PHP-DB] Cron job anomaly

2016-09-20 Thread Lester Caine
r your response. Need a mysql guy to deal with that ;) I have seen it myself when trying to use mysql and it's to do with the 'network path' but I'm on firebird which simply uses the '(user name removed)' -- Lester Caine - G8HFL - Contact - h

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Lester Caine
eatures that cut in. Are they listed in the script, or loaded from the environment ... which is of cause different for the cron jobs ... and why you needed the full path. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine El

Re: [PHP-DB] Connecting to database fails

2016-08-13 Thread Lester Caine
On 14/08/16 00:00, Rich Shepard wrote: > Ah, yes. Pat likes MySQL/MariaDB so he does not build php to support > postgres. I'll rebuild it and that should solve the problem. I've been with Firebird/Interbase since before PHP existed ;) -- Lest

Re: [PHP-DB] Connecting to database fails

2016-08-13 Thread Lester Caine
installed. Database drivers are not installed by default as you only really need the ones you are actually using. Should be php5-pgsql -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk Enq

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

2016-01-26 Thread Lester Caine
eric ODBC inerface and this does have it's own restrictons based on what platform you are using. It may be worth trying the generic ODBC interface and see if this works any differently. The ODBC driver uses the same style of working as the Firebird/Interbase driver for binding variables and

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

2016-01-26 Thread Lester Caine
#x27; format, but I can't find the notes now on what combination works and what does't :( -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model

Re: [PHP-DB] SQL injection

2015-06-21 Thread Lester Caine
I'd only expect a continued 'attack' if the URL was returning something useful so to carry on just did not make sense ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.c

Re: [PHP-DB] SQL injection

2015-06-21 Thread Lester Caine
>> The question is more of interest in just what it was trying to >>> >> achieve? I presume hack MySQL? So Firebird would barf anyway, but >>> >> just trying to something that has generated some several hundred >>> >> error log entries in the la

[PHP-DB] SQL injection

2015-06-21 Thread Lester Caine
CHAR(111,108,111,108,111,115,104,101,114),1))a)%20--%20and%201%3D1 The question is more of interest in just what it was trying to achieve? I presume hack MySQL? So Firebird would barf anyway, but just trying to something that has generated some several hundred error log entries in the last two days ... -- Lester Caine - G

Re: [PHP-DB] SQL Injection

2015-05-16 Thread Lester Caine
t; to pick to do what I want with. There are so many. Hence my question here. That probably sums up 'hosted' plans. The number of available database engines has declined in recent years, and where a site 'outgrows' MySQL, there are a few custom developments, but bottom line .

Re: [PHP-DB] SQL Injection

2015-05-16 Thread Lester Caine
unning 50+ databases and with Firebird each is isolated in it's own directory and automatically backs up to the website storage area. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk Enqu

Re: [PHP-DB] SQL Injection

2015-05-16 Thread Lester Caine
er of code which hides the underlying execute(sql_query, array_of_data); -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Works

[PHP-DB] SQL injection attempt

2015-03-11 Thread Lester Caine
ts ignored. Presume this is some MySQL hack attempt ( bit lost on Firebird anyway ;) ) but the question as usual is it malicious in the content of MySQL, or just fishing? In my case it just white screens anyway so I don't know why they keep trying to send the same style of url th

Re: [PHP-DB] MySQLi

2014-09-14 Thread Lester Caine
27;translate'. My own database is Firebird which has SQL functions that have yet to appear in MySQL, some of those are exposed in MySQLi so you can ignore them when upgrading but it is always those fringe cases that take the most time to resolve? :( -- Lester Caine - G8HFL

Re: [PHP-DB] MySQLi

2014-09-13 Thread Lester Caine
clear all of those problems before moving forward. Unless you caa ensure your server will always be switched bak to a compatible mode of working. And all that before even looking at MySQL ... I've never used it, so hopefully someone else will cover that side. -- Lester Caine - G8HFL ---

Re: [PHP-DB] Query does not work

2014-07-02 Thread Lester Caine
of a program? This is not showing that you have, only that you can't see the actual data returned. I prefer firebird to mysql, and the normal process is to use the mysqli_fetch_assoc style working so that the keys of the array are the returned field names in which case the print_r output gives mo

Re: [PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Lester Caine
l question :) The original post was fairly complete in what it was asking, and the answers reasonably worded ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquir

Re: [PHP-DB] Workout Schedule Calendar

2014-03-01 Thread Lester Caine
directly accessible. Legally, the 'Data protection Act' comes into play here in the UK, but we have sites with over a million visits recorded over the past approaching 20 years, and the system still works as fast as when it was first installed :) ( I use Firebird but any of the options wil

Re: [PHP-DB] Billing Module in PHP

2014-01-09 Thread Lester Caine
'nextdue' based on the last payment which will show the period paid for, and even this is a little redundant since it is available from the last payment record, but I see no need for a third table? Just set the right 'relations' between the ma

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Lester Caine
Matt Pelmear wrote: On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually bring things under

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Lester Caine
y the current threads are not that far off topic ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Ra

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
wrong. I'm with him on the statement that MySQL should have returned an error. Certainly Firebird would have done and so identifying the problem might have been easier. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electroni

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Lester Caine
g with the errors and warnings in the third party libraries - it flags them as well :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Enginee

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Lester Caine
ng HTML so not as good when editing code. My Eclipse setup does a very similar job on the html/js and css so I've not used it in many years. I don't think the colour selections were very good if memory serves. -- Lester Caine - G8HFL - Contact - http://ls

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
Firebird, and have always built the SQL using parameters, so that the SQL is pure text, and values are passed in an array. This is something MySQL was a lot later in catching onto, but many of the simple security problems are totally eliminated using that approach. -- Leste

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Lester Caine
provides pop-up crib sheets onthe parameters for a selected function, and of cause the auto complete can be configured to match your preferred way of working ... I'm still on tabs for indenting -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?pa

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
ommits cross database, and I know that others have found the restrictions imposed by PDO prevent things working well in older style Firebird Applications. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Serv

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
ldwide and is a much better alternative to many later database engines. Many Oracle users are porting over to Firebird to reduce costs. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquiryS

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
s be -1.0, so once we know what IS in the database we can look at which end has gone wrong ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engin

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Lester Caine
duced number of final fields in the result. Of cause it IS often better to work with named fields rather than using '*' which does allow better handing of the process anyway. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.C

Re: [PHP-DB] PDO user question

2012-09-09 Thread Lester Caine
then always produce a full set of records except for the last page ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop

[PHP-DB] Nubbie pointers on MySQL users ...

2012-08-21 Thread Lester Caine
the local machine name 'rdm2' with the same user names. Where am I going wrong? Is there something I'm missing setup wise? ( And I don't know who you manage with raw SQL for transfers, on Firebird I can backup and restore a 500Mb database in seconds ;) ) -- Lester Caine -

Re: [PHP-DB] php & adodb book suggestins

2012-01-27 Thread Lester Caine
x27;t have much to do with the code itself, it's more of that "at home" feel. I also have these thoughts that if PEAR went belly up, so could ADOdb. Scary thought indeed. :-/ I do my own mods to ADOdb ;) So it does not bother me, certainly a LOT less than having to cope with all t

Re: [PHP-DB] php & adodb book suggestins

2012-01-26 Thread Lester Caine
David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: > David McGlone wrote: > > can anyone suggest any good up to date books out there on php& adodb. > The only documentation on ADOdb is the website > http://adodb.sourceforge.net/#docs ...

Re: [PHP-DB] isError ADODB

2012-01-05 Thread Lester Caine
k > Hoping that fixes it for you. > Best, Thanks Karl. I finally got to try this and it wasn't the answer. I'll keep plugging to see what I can do. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Servic

Re: [PHP-DB] Abstraction library

2011-12-30 Thread Lester Caine
David McGlone wrote: On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: > On Fri, 2011-12-30 at 12:27 +0000, Lester Caine wrote: > > David McGlone wrote: > > > Hi everyone I got a quick question. I'm wondering if anyone is using a > > > DB abstrac

Re: [PHP-DB] Abstraction library

2011-12-30 Thread Lester Caine
ing PDO drivers if you want ;) ). It even includes it's own cache which can help with repetitive stuff. It is still actively supported, and is used by a number of large projects. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine

Re: [PHP-DB] Fatal Error - Undefined function mysqli_connect

2011-09-04 Thread Lester Caine
ted extension for newer versions, so am trying to rewrite the code to use mysqli_connect. For what it's worth, mysqli_init() also produces "Call to undefined function mysqli_init()" in my error logs. That would explain the problem ;) Need the mysqli extension enabled instead of my

Re: [PHP-DB] Fatal Error - Undefined function mysqli_connect

2011-09-04 Thread Lester Caine
commented out in the php.ini. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Lester Caine
t was not only Firebird that was affected by the problem. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Lester Caine
jacked all the top spots. http://syntaxhelp.com/SQLServer/Recursive_CTE is a nice example of what you outlined ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Mo

Re: [PHP-DB] php_interbase.dll , PHP 5.3.x VC9 needed, which works with Embarcadero Interbase

2011-05-31 Thread Lester Caine
se ... not sure who is actually testing that, on the whole we have all moved over to Firebird so that we do not have any licensing problems. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk En

[PHP-DB] Re: [PHP-WIN] Re: PHP Search DB Table

2010-12-14 Thread Lester Caine
Oliver Kennedy wrote: $query = "SELECT * FROM clients WHERE clientid = '%".$term"%'"; $query = "SELECT * FROM clients WHERE clientid = '%".$term."%'"; Note missing '.' But that should be the same as $query = "SELEC

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread Lester Caine
sending more emails to that address. I had one for this list this morning as well ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers

Re: [PHP-DB] Upgrading PHP Version 5.1.6

2010-03-05 Thread Lester Caine
is is the case, then it is worth adding a PHPINIDir to the new httpd.conf pointing to a copy of php.ini in your new copy of PHP. http://php.net/manual/en/install.windows.apache2.php -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Lester Caine
a problem. -Sara Lester Caine wrote: Sara Leavitt wrote: Hi Lester, Our application is not using php transactions (e.g., COMMIT, ROLLBACK etc.), so I think we are safe there. Are you saying that even if both the mysql_pconnect and PDO connection are persistent that they will be

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Lester Caine
, and basically data entered on on connection will not be visible on the other until properly committed. Having that activity hidden in the drivers can lead to a little 'confusion' as to what state data is actually in Even just opening two connections via the MySQL driver will hav

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Lester Caine
you can't connect two processes to the same connection. You would not know which process was accessing things. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://e

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

2009-10-05 Thread Lester Caine
will provide these additional facilities. I use Firebird myself so can't comment on the 'fine detail' on postgres, but some of the Firebird options can't easily be supported in PDO ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/

Re: [PHP-DB] Need help in PHP file Management System

2009-09-20 Thread Lester Caine
directory for each user, and stores all their files within their own base folder. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers

Re: [PHP-DB] PgSql PDO

2009-09-11 Thread Lester Caine
via pgsql_connect() pdo_pgsql::_construct() is throwing an PDO_Exception "could not find driver" am I missing something here ? pls help Perhaps you could show the code. You should be using =new rather than _construct() I think. -- Lester Caine - G8HFL ---

Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Lester Caine
lem using the same build with php 5.2.8 and Postgres 8.3.4, so I ended up using the mod_php5.so module for apache build with these versions, but would like to get to the bottom of it. The obvious question would have to be was postgres actually listed in phpinfo? It would need to have been anab

Re: [PHP-DB] Strange string from MEMO field in FireBird

2008-12-13 Thread Lester Caine
ow you are creating the results. Which functions you are using. There is a support list for Firebird and PHP http://groups.yahoo.com/group/firebird-php/ which also has useful messages in the archive. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/lsces/wiki/?page=co

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-26 Thread Lester Caine
Liam Friel wrote: 2008/10/20 Lester Caine <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> Jason Pruim wrote: So my question is... When is it best to use more tables? All the info will be related to each other, so I think I would be looking at either a

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Lester Caine
/contact record. The type of info field flags things like primary phone. Address details often need the same treatment as well, but I use UK post code as a key for the bulk of that information so it just goes into a another info field. -- Lester Caine - G8HFL -

Re: [PHP-DB] Performance (lots of tables / databases...)

2008-09-27 Thread Lester Caine
y also limit your options. Properly indexed tables will be fast and a single connection accessing that data will be faster than having to make multiple connections to different databases, and if it only has to manage a small number of table most links would probably be cached.

Re: [PHP-DB] databases and XML

2008-09-09 Thread Lester Caine
scripts to dump it to various databases. So what large volume are you thinking about? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/lsces/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Enginee

Re: [PHP-DB] australian city db -lat/lon?

2007-08-15 Thread Lester Caine
Bastien Koert wrote: http://www1.auspost.com.au/postcodes/ The Australian postcode table does not have lat and lon - at least not on the copy I have, am I missing something? -- Lester Caine - G8HFL - Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact

Re: [PHP-DB] Php 5 and Mysql on Windows

2006-10-03 Thread Lester Caine
[EMAIL PROTECTED] wrote: That solved it. Awesome. Thanks you so much. Brian - A 'phpinfo()' test page is almost essential. When you make changes to the php.ini file you can check they have taken ;) -- Lester Caine - G8HFL - L.S.Caine Electronic Servi

[PHP-DB] Re: adodb is slow

2005-06-06 Thread Lester Caine
e.net/ Look for Speed Up Your PHP Code with the ADOdb extension -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Lester Caine
pgsql driver in ADOdb supports LIMIT so it's only the calculation of COUNT(*) that needs replacing with a faster pre-calculated count. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] accessing mysql on non default port - windows

2005-02-05 Thread Lester Caine
Jeff wrote: thats no good. man if its something simple, i'm not seeing it. well it was something simple...and now i see it. old_passwords. Don't you just love informative error messages ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Ma

[PHP-DB] Re: Integrating Interbase.so and PHP

2005-01-15 Thread Lester Caine
distributions in the archive, a starting point would be which distribution, and PHP4 or 5 -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP connect to mysql problem

2005-01-06 Thread Lester Caine
nect : Client does not support authentication protocol requested by server; consider upgrading MySQL client Which version of MySQL do you have loaded, and which version of the MySQL package have you installed in PHP. MySQL4.1 needs different combination to MySQL4 or earlier ? -- Lester Caine -

Re: [PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Lester Caine
that file as it would be worth a look at. In any case, that IS the sort of thing we like to play with on the firebird-php list ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: PHP and Firebird

2004-12-01 Thread Lester Caine
p.net/manual/en/function.ibase-trans.php Just add a another pair of arguments for each connection you want to combine in a 2-phase commit. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Firebird and PHP

2004-11-19 Thread Lester Caine
http://groups.yahoo.com/group/firebird-php You will get Firebird related help there. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-01 Thread Lester Caine
is one of the major reasons the rest of the world gets p*d of Americans ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Apache 1.3.31, php 5.0.2 and firebird 1.5

2004-10-25 Thread Lester Caine
_php and there is a tikifirebird site which should be active next month running on Apache2, PHP5 and Firebird 1.5 watch on the firebird-php list for details ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubsc

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-30 Thread Lester Caine
straction layers. Interesting thing from my point of view - both done on Apache2 ADOdb is not giving me any problems, but this does show that a switch to raw ibase will give me a performance boost if I need it. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Ma

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
Lester Caine wrote: No, that's true; no Firebird yet. Drivers needed :) It's basically a slightly modified version of the JDBC API for PHP. Now THAT might be the correct way forward. I already use the Firebird-Jaybird interface when running plug-ins on Eclipse without any probl

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
gainst Firebird, but keeping track with the changes to MySQL has had to be dropped - which version/sub version etc. ... Of cause what is actually needed is a good standard XML SQL interface - hopefully before Microsoft patent it ;) -- Lester Caine - L.S.Caine Electronic

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
irebird installs and runs 24/7 without DBA's or manual intervention. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
other packages are simply MySQL wrappers with cobbled support for a couple of other engines. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
roblems they were quickly cleared. Unlike some of the other options I tried. Now *I* am happy with ADOdb and see no reason to change, so I don't keep up with other packages and can't contrast. So answering some of your questions is difficult. -- Lester Caine

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-01 Thread Lester Caine
are a couple of years out of date. The ADOdb accelerator does make a difference if speed is a problem, but I don't have any major bottlenecks (YET) ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-01 Thread Lester Caine
ilable that use ADOdb or have moved to it (or are moving) in later updates. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Dear php experts

2004-08-29 Thread Lester Caine
ne give me functional code for it? I'd probably start from one of the working systems ;) Have a look at the list at http://www.opensourcecms.com/ -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscri

[PHP-DB] Re: Lotus Notes DB to MySQL?

2004-08-27 Thread Lester Caine
mport her old data first. If memory serves me correctly, you can export from Notes as a CSV text file, and then import that. It's been some time since I had to do it, but I am sure that was the path I used to get the contacts data into an Interbase database. -- Le

Re: [PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-22 Thread Lester Caine
driver? If so, then you can create the reports you want in OpenOffice and save them as OpenOffice documents. You can then just create a link to the document. Not the most efficient way of doing things, but it should work, I don't have any problem with Firebird via it's JDBC driver.

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
database I use can ask privately if they are interested ;) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
database I use can ask privately if they are interested ;) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) -- Lester Caine - L.S.Caine Electronic Services

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
because of that other better engines do not get supported, and we get told - Move to MySQL if you want to host here. It is only the right tool for some jobs, otherwise why are they going hell for leather to add all these supposedly unnecessary features TO MySQL ;) -- Lester Caine

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
e the engine takes care of the business rules of managing data. SQLite is a different matter and the obvious new base for beginners, but for real applications ... -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubs

[PHP-DB] Re: LAMP

2004-08-02 Thread Lester Caine
as to catch up with the better FREE database engines ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Call to undefined function mysql_connect()

2004-08-01 Thread Lester Caine
tives ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: generating reports in php

2004-07-30 Thread Lester Caine
reports from FastReports ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting PHP for Windows to talk to MS SQL?

2004-07-25 Thread Lester Caine
[EMAIL PROTECTED] wrote: I discovered that PHP was not looking at C:\php\php.ini. Rather, somehow it was looking at C:\Windows\php.ini. Anyway, now all is well. Yep - that is the right place on windows. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database

[PHP-DB] Re: content managment systems

2004-06-16 Thread Lester Caine
ou will be able to select which modules you want to load on the next version. www.tikipro.org -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Lester Caine
found shot dead, Inspector Jacques Clouseau is the first off' at line 8 I would think it fairly obvious that the extra "'" in the text you are loading is causing a problem, use an "`" instead, or "escape" the single "'&q

[PHP-DB] Re: Firebird

2004-03-31 Thread Lester Caine
ns are well worth having. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Firebird support

2004-03-19 Thread Lester Caine
about a conversion, and perhaps when PHP5 is stable that will form the basis. But in the meantime just use the Interbase one. -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: How to simplify DB creation?

2004-03-19 Thread Lester Caine
Michal Masa wrote: We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists, validation, sorting and searching?

Re: [PHP-DB] Root-Server Firebird PHP

2003-12-11 Thread Lester Caine
make: *** [all-recursive] Error 1 i see an error, but i dont now what i must do. Can anybody help me? Thank you. Frank -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   >