Re: [PHP-DB] Problem with inserting into BLOB SUB_TYPE TEXT (Intebase 6)

2001-03-09 Thread Klaas

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!

2001-03-09 Thread Kevin Connolly

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?

2001-03-09 Thread Rouvas Stathis

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

2001-03-09 Thread omar cromwell mercado

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

2001-03-09 Thread Steve Brett

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?

2001-03-09 Thread Michael Gerholdt

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?

2001-03-09 Thread Adi Wibowo


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?

2001-03-09 Thread Chris Andrew

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

2001-03-09 Thread Vanstaen Laurent

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

2001-03-09 Thread Cal Evans

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

2001-03-09 Thread Mike Hammonds

** 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

2001-03-09 Thread Jim Frasch

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

2001-03-09 Thread Michael J. Upchurch

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

2001-03-09 Thread Rick St Jean

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

2001-03-09 Thread newbrightconceptz2321


-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

2001-03-09 Thread narsu

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

2001-03-09 Thread AK47

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]