Re: [PHP-DB] Problem with inserting into BLOB SUB_TYPE TEXT (Intebase 6)
I got version 1.48. (standard in 4.04pl1) but i got the same problem. any solutions? Klaas "Lutz Brueckner" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... "Jarek Zgoda" [EMAIL PROTECTED] wrote: Make sure that you are using a recent version of the interbase module. phpinfo() should show you a revision 1.45. Before there was a bug that causes a crash when inserting blobs. Unfortunately, it shows me 1.44 - it's a standard module downloaded with whole 4.03pl1 release. Where could i download this newer version? snaps.php.net Lutz -- ibWebAdmin 0.4alpha *** web-based InterBase database administration *** download the latest version from http://home.knuut.de/lb/ *** -- 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-DB] Help! Want to unsubscribe!
Hi, I am trying to unsubscribe from this mailing list (I keep going over my allotted space on the mail server!) but can't seem to do it! I have gone to the remove link on the phpbuilder web page (twice) but still the mails arrive! Anybody know how to unsubscribe? Thanks to everyone who has helped me during my stay! -Kev.
Re: [PHP-DB] How to migrate Oracle 4.01 database?
Oracle.4.01!!! That's a blast from the past!!! Best bet: export everything and import into Ora.8i. It worked for me doing an Ora.6.xx to Ora.8.1.6.1 migration:-) GOOD LUCK. -Stathis. wrote: Hi, I have a database based on Oracle 4.01. Now I want to migrate it to Oracle 8i. Does anyone have reference to me? thanks. Sincerely, Weiping Tsen [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-DB] BLOB in postgres
Hi php+postgres users, How do I define a BLOB data type in postgres? My php script gets binary data such as image and executables and I want to store it into the database but I couldnt find a BLOB data type in postgres. Any hints? Thanks. Omar __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- 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] my sql text query
hi, i'm currently writing an e-commerse site using php for the shopping cart stuff and mysql as the db. i've got a text filed of type text that holds descriptions for the items but only need to display it if a description exists, so many of the fields are null. the field was added to the table when the table was already populated and when try to read it i get errors saying the index is not defined ... if i change it to varchar(255) there is no problem ? can anyone help ? Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, please delete this message, and notify us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my firm or employer unless otherwise indicated by an authorised representative independently of this message." Egton Medical Information Systems Limited. Registered in England. No 2117205. Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth, Leeds, LS18 4RF -- 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] Whence Cometh Line Break?
I've discovered that this little bit of code is introducing a line break into my SQL string and it is causing it to break. the month comes through as '[linebreak here]Mar' ? $i = date("M",mktime(0,0,0,date("m")-1,date("d"),date("Y")));? input type="radio" name="month" value="?=$i?"nbsp;?=$i? (these are two unbroken lines in original code.) Where does a line break come from in value="?=$i?" ?? I'm mystified! Thanks, Mike -- 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] How to migrate Oracle 4.01 database?
On Fri, 9 Mar 2001, [gb2312] ³Âΰƽ wrote: Hi, I have a database based on Oracle 4.01. Now I want to migrate it to Oracle 8i. Does anyone have reference to me? Hi, I (we) have a database based on Oracle 6. And we want to migrate to Oracle 8i. After some consultations with Oracle Support in my country they suggest that we should upgrade to Oracle 7 and then Oracle 8. Why? There is no tool to upgrade a database from version below 7 and differences between the two (6 vs 8) is so big, so there is no safe way than clean install Oracle 8i server onto another server, create a database with exact scheme, and retrieve every row of data from an old database and save it (insert) into a new database. It work for us now. And we glad seeing the result is so good. Adi Wibowo --- * Work matter: [EMAIL PROTECTED] * Private matter : [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] Whence Cometh Line Break?
Rather than use =, have you tried echo value="? echo $i ?" Chris -Original Message- From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] Whence Cometh Line Break? I've discovered that this little bit of code is introducing a line break into my SQL string and it is causing it to break. the month comes through as '[linebreak here]Mar' ? $i = date("M",mktime(0,0,0,date("m")-1,date("d"),date("Y")));? input type="radio" name="month" value="?=$i?"nbsp;?=$i? (these are two unbroken lines in original code.) Where does a line break come from in value="?=$i?" ?? I'm mystified! Thanks, Mike -- 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-DB] MySQL type of a field
Hi all Does anyone know how to get the MySQL type of a field in a table, and not the PHP type ?? I just can't understand the example on php.net. Thank you in advance. Laurent Vanstaen -- 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] my sql text query
Nope, you change the field to not null then it won't allow null values in the database. Since the data already has null values, the Alter Table would probably fail. I'm still trying to figure out what any of this has to do with an index? Do you have an index on this description field? Cal http://www.calevans.com -Original Message- From: Phil Driscoll [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 7:59 AM To: Steve Brett; [EMAIL PROTECTED] Subject: Re: [PHP-DB] my sql text query Good heavens, another PHP developer in Leeds:) I think (I haven't tried this!) you could change the field type to not-null - then your array should get populated with empty strings for any records where this field is not set. Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org -- 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-DB] Displaying Graphics dynamically
** Reply Requested When Convenient ** I want to create a dynamic web pages using PHP and MySQL. How do I: 1). Insert a binary object (mp3, jpg, gif, pdf ...etc) into a MySQL database with PHP 2). display the objects stored in the database on my page Mike Hammonds, CNE5, MCP-NT Fellon-McCord Associates, Inc. Office: 502.214-6324 Fax: 502.426.8800 [EMAIL PROTECTED] Show Me the Code!! ICQ#94969305 BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Mike Hammonds EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] TEL;PREF;FAX:(502)426-8800 X-GWUSERID:mhammonds ORG:;IS Department N:Hammonds;Mike TEL;WORK:(502)214-6324 TITLE:IS MAnager END:VCARD -- 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] Fox Pro
Does PHP have the ability to interface with an MS Fox Pro database? TIA -jim -- 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] Fox Pro
Check out the ADODB library at http://php.weblogs.com/ADODB. It includes support for FoxPro. Michael J. Upchurch Partner2Partner Communications, LLC -Original Message- From: Jim Frasch [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:39 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Fox Pro Does PHP have the ability to interface with an MS Fox Pro database? TIA -jim -- 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] Fox Pro
I don't think that there are functions, but I do know that there are odbc drivers for it, and you can use the odbc connect. Rick At 02:39 PM 3/9/01 -0500, Jim Frasch wrote: Does PHP have the ability to interface with an MS Fox Pro database? TIA -jim -- 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] ## # Rick St Jean, # [EMAIL PROTECTED] # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ## -- 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: Weekly Update
-WEEKLY UPDATES- BREAKING NEWS... RECORDS WERE BROKEN... AND MILLIONAIRRES WILL BE MADE!! THE ADVANTAGES OF BEING ON OUR TEAM ARE: -YOU WILL GET PAYED NEXT WEEK! -WE WILL BUILD ONE SIDE OF YOUR BUSINESS FOR YOU! -WE WILL PROVIDE YOU WITH FREE NETWORKER LEADS SPECIFIC TO THIS OPPORTUNITY -WE WILL TRAIN YOU, DO CALLS FOR YOU, AND PLUG YOU INTO OUR PROVEN SYSTEM -YOU CANNOT FAIL CHECK US OUT ON THE WEB AT http://www.geocities.com/success352003/ *** THIS EMAIL COMPLIES WITH ALL REGULATIONS AND IS NOT SPAM. TO PERMANENTLY REMOVE YOURSELF FROM THE LIST SIMPLY EMAIL [EMAIL PROTECTED] WITH "REMOVE" AS THE SUBJECT LINE. *** -- 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] Resource for PHP and other technologies
I developed this site http://www.hytes.com for techical resource for developers. Please take a look and let me know your feedback. Thanks Narsu -- 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] can't compile dbm support for dba
I'm running apache 1.3.14+Ben-SSL/1.42 and php-4.0.4pl1 on a RedHat 6.1 linux box. I'm in trouble trying to authenticate users via mod_auth_dbm. Which DBA format should I use to generate user databases? I've tried with: 1) dba and gdbm format 2) dba and ndbm format 3) dba and db2 format I always read: ... [error] [client 192.168.0.11] (22)Invalid argument: could not open dbm auth file: /www/auth/passwd_db in apache logs. I've also tried with older deprecated dbm functions but the result is still the same. I guess the problem is that apache uses the "dbm" format. I've tried to build php whith the option: --with-dbm but I always get this error: configure: error: cannot find necessary header file(s) What shoul'd I do to compile this "dmb" support into php4 ? I've always thought that "dbm" was provided by "gdbm" but ... --- Gabriele Carioli -- 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]