[PHP-DB] Re: subtracting one query from the other

2002-06-27 Thread Dan Koken
Not sure what your data looks like or what exactly you are trying to do. But what is wrong with the old standard compare for NULL. Something like -- SELECT first_record.id as first_id, second_record.id as second_id FROM second_record LEFT JOIN first_record ON first_record.id =

[PHP-DB] encryption of critical data

2002-06-27 Thread youx
Hi, Can someone provide me some information about encryption and decryption of critical data such as credit number card in order to stock them on a mysql database in a secure way. What I want to do is making a web interface secured via SSL in order to be able to consult some people

[PHP-DB] SQL question!

2002-06-27 Thread Bruno Gimenes Pereti
Hi, I need a sql query to join multiple lines into only one line. Ok, I wouldn´t understand this question so I´ll give an example (I´m doing it on mysql but I need it to mssql). Supose I have 3 tables: mysql select * from test1; ++---+ | id| nome | ++---+ | 1| Bruno

[PHP-DB] MySQL Update failing...

2002-06-27 Thread NIPP, SCOTT V (SBCSI)
In need of some help. I have a PHP form page that is updating a MySQL database that is not working. Here is the code for the three pages that work together for this application. The oncall_new.php works fine to insert new records into the database, and the oncall_log.php works fine to

RE: [PHP-DB] MySQL Update failing...

2002-06-27 Thread Ryan Jameson (USA)
I didn't get your attachements. Maybe paste them in a row into the email? -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:07 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL Update failing... In need of some help. I

RE: [PHP-DB] MySQL Update failing...

2002-06-27 Thread NIPP, SCOTT V (SBCSI)
Figured it out. Thanks to anyone who started looking at this. The problem was not having my variables in the correct order in the $updateSQL. Once I corrected this, the posting now works fine. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent:

[PHP-DB] Re: PHP and msql Error

2002-06-27 Thread user
The error is in your MySql statement. Sounds like you are calling the wrong data field / column. Check you spelling and syntax to make sure all of that is in order. If you can't find it, copy it and post it. We'll help you out gl -- Seth Comp Boy wrote: I am getting the following

[PHP-DB] XML

2002-06-27 Thread Peter Lovatt
Hi I am looking at a project using XML to import and export data into MySql directly or using php. The datasets are quite large (40-50 million records) I haven't used XML before. Does it take long to work out how to use php/XML? Are there any problems working with large datasets? Thanks

Re: [PHP-DB] XML

2002-06-27 Thread B i g D o g
MySQL has xml support...have you looked at the docs at mysql.com for anything that might help you input the data directly... B i g D o g - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 3:03 PM Subject:

[PHP-DB] Oracle Stored Proc, PHP

2002-06-27 Thread Fenn Rider
I am trying to work with a stored procedure that has no arguments and returns a cursor. I cannot seem to get a grasp on how the ociparse, ociexecute, ociBindByName, etc. work with this type of stored proc. Has anyone tried this? -Fenn -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] encryption of critical data

2002-06-27 Thread Peter Lovatt
HI If you are using MySql look at ENCODE() on mysql.com http://www.mysql.com/doc/M/i/Miscellaneous_functions.html Most databases support some sort of encryption. Encrypting by php is probably more secure - somebody might be able to sniff data going to the database if it still plain text, but

[PHP-DB] RE: XML

2002-06-27 Thread Ed Carp
I am looking at a project using XML to import and export data into MySql directly or using php. The datasets are quite large (40-50 million records) XML is a metadata technology - you wrap data in XML. You don't use XML to import or export data. You don't store XML in a database, you store

[PHP-DB] Re: XML

2002-06-27 Thread MikeParton
On the other hand, proclaimed native XML databases (eg, Software AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the database...no need to wrap and unwrap the metadata, document/data structure from the data. - Original Message - From: Ed Carp [EMAIL PROTECTED] To: Peter

[PHP-DB] RE: XML

2002-06-27 Thread Ed Carp
On the other hand, proclaimed native XML databases (eg, Software AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the database...no need to wrap and unwrap the metadata, document/data structure from the data. Isn't that more than a bit stupid? Databases are for storing data, not

[PHP-DB] Re: XML

2002-06-27 Thread Jeremy Zawodny
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote: On the other hand, proclaimed native XML databases (eg, Software AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the database...no need to wrap and unwrap the metadata, document/data structure from the data. That

[PHP-DB] Re: XML

2002-06-27 Thread MikeParton
All depends on what you're trying to accomplish and the drivers behind the path you wish (or need or have been mandated) to take. Having said that, I make no claims with respect to the smartness of others (I find I too often question that in myself to serve as a judge of others). Nice little

[PHP-DB] Re: XML

2002-06-27 Thread MikeParton
Would be interesting to hear from Peter on why he feels the urge to store XML docs in MySQL (or, better said: I would be interested in hearing what he is trying to accomplish and why he...or someone...feels XML stored in a relational database is the way to go). mysql, sql, xql, xquery,

[PHP-DB] Re: XML

2002-06-27 Thread Paul DuBois
At 21:33 -0400 6/27/02, MikeParton wrote: Would be interesting to hear from Peter on why he feels the urge to store XML docs in MySQL (or, better said: I would be interested in hearing what he is trying to accomplish and why he...or someone...feels XML stored in a relational database is the way

[PHP-DB] Re: XML

2002-06-27 Thread MikeParton
If: An XML database is analogous to a pure data database Then: An XML document is the analog of a table XML Entities are analogs of columns XML Attributes are analogs of column properties (aren't these metadata?) So: Not sure there is much more metadata in an XML database than in a data

[PHP-DB] RE: XML

2002-06-27 Thread Ed Carp
Not sure there is much more metadata in an XML database than in a data database. In a standard database, the data and metadata are stored separately, not so with XML. When the next new latest and greatest thing comes along, you'll have to strip all that metadata out of your data. It also

[PHP-DB] how can i save a photo in mysql use php?

2002-06-27 Thread Msolutions
hi all how can i save a photo in mysql use php? can you tell me the data type too? thx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] how to save a picture in mysql?

2002-06-27 Thread Msolutions
hi all i am a newer in here, can you give me a example for save a picture in mysql use php? and type me which data type use in mysql thx chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL Indexing Size

2002-06-27 Thread tatang
hi all I want to know storage required for my database. How i can determine size required for indexing a column ? (my column's type that indexed is varchar(15)) Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Indexing Size

2002-06-27 Thread olinux
hmm... index it - and you will know olinux --- [EMAIL PROTECTED] wrote: hi all I want to know storage required for my database. How i can determine size required for indexing a column ? (my column's type that indexed is varchar(15)) Thanks -- PHP Database Mailing List

Re: [PHP-DB] how can i save a photo in mysql use php?

2002-06-27 Thread Jason Wong
On Friday 28 June 2002 11:29, Msolutions wrote: hi all how can i save a photo in mysql use php? can you tell me the data type too? In most cases you shouldn't store a binary file in a database. It is more efficient to store a pointer (eg the name of the file) then have the actual file in