[PHP-DB] MDB2 insert Oracle BLOB field problem

with this? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Transfer data between tables in MySQL

Hi, I have to transfer all data between two tables ( with identical structure ) Is this possible with one query, or I must read from table1 and manually insert into table2? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Transfer data between tables in MySQL

From: Rosen [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Transfer data between tables in MySQL Date: Wed, 29 Nov 2006 13:44:24 +0200 Hi, I have to transfer all data between two tables ( with identical structure ) Is this possible with one query, or I must read from table1

Re: [PHP-DB] Transfer data between tables in MySQL

From: Rosen [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Transfer data between tables in MySQL Date: Wed, 29 Nov 2006 13:44:24 +0200 Hi, I have to transfer all data between two tables ( with identical structure ) Is this possible with one query, or I must read from table1

Re: [PHP-DB] Problem with executing Oracle query for creating procedure

Christopher Jones [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end

[PHP-DB] Problem with executing Oracle query for creating procedure

help me with this? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem with Oracle

manually the ; from the end of every row and execute separate every command everything is ok. I have and script files fo creating procedures/functions and there in not a problem with ;. Where is the problem ? Why can not be used ; as command separator from PHP ? Thanks in advance! Rosen -- PHP

[PHP-DB] Problem with Oracle query

), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Problem with Oracle query

' in the Recs table Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL

[PHP-DB] Problem with insert BLOB into Oracle

it, there is no problems, but when try to insert I receive an error:Error: ORA-01465: invalid hex number Can someone help ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Case sensitive search

of strings is case-insensitive. How can I perform a case sensitive search in text fields ? Tnanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Temporary table name

Hi, I need to create temporary table in mysql. And I generate random name - i.e. TMP21567. How can I check is this name already exist in database ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Temporary table name

Thanks, But is there a way to do this without additional table in which to store the names of created temporary tables ? Thanks, Rosen Tim Van Wassenhove [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], Rosen wrote: Hi, I need to create temporary table

Re: [PHP-DB] Temporary table name

Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? Thanks in advance Rosen John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: I need

Re: [PHP-DB] Temporary table name

:[EMAIL PROTECTED] Rosen wrote: Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? How long does it exist for? If it's only used during the life of the script, then use

Re: [PHP-DB] Temporary table name

Thanks, I'll try it. John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: No, I don't use it only in range of one script - it must be as normal table - several scripts to work with this table and after the last script finish - it delete the table. This may

Re: [PHP-DB] Table locking

for all users in database ? Thanks in advance ! Rosen John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: And if I perform LOCK tables ... nobody can;t write on these tables, until I don't perform UNLOCK TABLES ? If something happens ( I mean if some my

Re: [PHP-DB] Table locking

else to insert data in table2, because will be a problem with orders. Now I insert data first in table2 and then insert main record in table1 with the range of id's of detail order data. Could be some solution for this ? Thanks in advance. Rosen John W. Holmes [EMAIL PROTECTED] wrote in message

[PHP-DB] Table locking

Hi, I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to understand, thath another user is filling table, and to wait before begin to fill data? Thanks in advance! -- PHP Database Mailing List

Re: [PHP-DB] Table locking

] wrote in message news:[EMAIL PROTECTED] Rosen wrote: I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to understand, thath another user is filling table, and to wait before begin to fill data? Most

Re: [PHP-DB] Table locking

Thanks, but can you give me a sample PHP script with MySQL database, whitch do this? Thanks Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Friday 09 July 2004 07:09, Rosen wrote: Is thath mean, thath, when one user is addind records to table, and lock it - when

Re: [PHP-DB] Table locking

And if I perform LOCK tables ... nobody can;t write on these tables, until I don't perform UNLOCK TABLES ? If something happens ( I mean if some my queryes fails) ? Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Friday 09 July 2004 07:24, Rosen wrote: Thanks, but can

[PHP-DB] PHP DB class

Hi, Can someone help me - I'm looking for PHP class for transaction managment and record lock/unlock in InnoDb MySQL tables ? Tnaks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PostgreSQL on Windows

Hi, Can I start PostgreSQL server and client on Windows machine ? Thanks in advance! Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Paradox tables

Hi, Is there a way with PHP to process data from Paradox tables ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Paradox tables

Thanks, I need someone, who created this to know is this reliable ( I mean Paradox PHP ) Thanks, Rosen Jeffrey N Dyke [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] if you can connect via odbc, you can use php with it. i just googled - paradox, database, php and the first link

[PHP-DB] Exporting database

Hi, Can someone tell me where can I find a function or class for export MySQL database (structure data ) into text file ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem with MySQL 4.0.4 beta

Hi, I just installed MySQL server on WIndows 98 and when server starts the window with mysqld-opt opens and stop responding. And server didn't start. Any ideas for this? Thanks, ROsen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Append into another table

Hi, how can I append from one table to another with same structure some selected records Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Import/Export data

Hi, How can I import/Export data to MySQL database using PHP following formats: EDI, Access, Excel ? Where can I find information about this ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with SQL query on several tables

Thanks, but I want wo JOIN data from three tables and then to order all data by datestamp. Can I Do It ? Thanks, Rosen Andrey Hristov wrote in message 071401c17759$f5873c80$0b01a8c0@ANDreY... Mysql says that in the join there are some columns with namer datestamp so you have to choose

[PHP-DB] Help you with our programming skills and experience

Hello, We are a team of experienced programmers with skills of PHP/Perl/JAVA/C++/VB/Servlet/JSP/ASP/PowerBuilder/XML/ DHTML/WAP WML with database of MySQL/MS Access/ MS SQL/ORACLE/DB2/Sybase/Informix. We are experienced in programming for various E-Commerce web site and standalone

[PHP-DB] Date field

Hi, Can someone tell me how do stote date field in MySQL DB ? Thanks, Rosen M. -- 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 manager

Hi, can anybody tell me for some cool MySQL database manager ? Thanks, Rosen Marinov -- 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 ! MySQL Problem

Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] Help ! MySQL Problem

Thanks, but it doesn't work ! "Brinzoi Constantin Aurelian" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Thu, 8 Mar 2001, Rosen wrote: Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values (

[PHP-DB] About MySQL connections

Hi, I use "mysql_pconnect" function to connect to MySQL server. When I call function second time I receive error: "Warning: MySQL Connection Failed: Too many connections in /website/transfer.php on line 17" Please HELP! Rosen MArinov -- PHP Database Mailing List

Re: [PHP-DB] Transfering data between MySQL servers

Thanks, but i have mean to transfer with SQL script. Can I do it ? Thanks, Rosen Marinov ""Rosen"" [EMAIL PROTECTED] wrote in message 95u3f9$4p0$[EMAIL PROTECTED]">news:95u3f9$4p0$[EMAIL PROTECTED]... Hi, I have MySQL server on my local machine with some d

[PHP-DB] HELP ! Connect to MySQL

Hi, When I try to connect to MySQL server i get error code "10060" ! Please HELP! -- 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]