Hi all,
I've recently encountered the following problem. When I try to DELETE from
the Informix database using PHP I receive the following error:
Execute immediate fails : DELETE FROM table01 WHERE id=5 (E [SQLSTATE=IX
000 SQLCODE=-668]
The same SQL statement used directly in dbaccess works
Hi
Does anyone know some lib for generating excel files.
I ask it here because database people could use such thing.
Aivar Annamaa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the lis
i'd also be interested in this ... i have some code that will create .csv
files for download, whihc is the way i normally do it.
Steve
> -Original Message-
> From: Aivar Annamaa [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2001 13:02
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] *.xls
>
>
>
Anyone can tell me how can i generate the scripts of my database to create it in
another mysql server.
Or better wich other ways i´ve to do it.
Thanks in advance,
Gabriel.
Read your database documentation. It is usually a dump command, such as
mysql-dump, or pgsql-dump.
These commands usually write out a script that will recreate the database
along with the data. There may be command line switches to get just the script.
HTH- Miles
At 11:26 AM 5/8/01 -0300,
man mysqldump
-Original Message-
From: Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 9:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Fwd: URGENT : How can i generate scripts of database
Anyone can tell me how can i generate the scripts of my database to create
it in ano
BACKGROUND:
I was recently given a task to add a table to a MS SQL Server and a few PHP
pages to insert, edit, delete and display records from this table.
The site is currently running off an Linux Server with PHP 4.03 and a
Windows NT box running MS SQL Server 7.0. The SQL Server is unreachable
Progress databases prefer the odbc_prepare, odbc_execute sequence over the
odbc_exec functions ( I don't know why )
> -Original Message-
> From: indrek siitan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 11:38 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-DB] P
mysqldump might be difficult though if you don't have telnet access to your
mysql.database, but if you only have php access. whats the best thing to do
in that case? has anyone tried the exporting options of myphpadmin?
> -Original Message-
> From: Michael Geier [mailto:[EMAIL PROTECTED]]
Hi,
> Progress databases prefer the odbc_prepare, odbc_execute sequence
> over the odbc_exec functions ( I don't know why )
ok, changed the code to following:
--- 8< ---
" . odbc_result($sth,"Trkoodi") . " - " .
odbc_result($sth,"Trnimi");
}
}
else
{
echo "execute failed.";
}
--- 8< --
Hi,
You may wish to try OpenLink's ODBC drivers, available at
http://www.openlinksw.com/.
We have excellent support for Progress databases.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology
Hi,
> Does anyone know some lib for generating excel files.
For which database? In MySQL you could do a LOAD DATA OUTFILE file.xls.
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To con
I was wrestling with this for a while.
There is a db2 distribution for linux from IBM
There was some extensive discussion on the list in February
and March of this past year, including a set of files from
Alessandro Grigiante and compiling php with --with-ibm-db2=
(i.e. using db2 instead of
Marc,
OpenLink's MT ODBC can talk to a local DB2 Connect on Linux, so you are able
to use odbc_functions to get to the DB/2 on AS/400 in a fairly
straightforward manner. If you run into problems let me know, or open a
free support case at http://www.openlinksw.com/support/suppindx.htm
Best rega
Hi,
I'm trying to write a PHP app that accesses a Progress database.
version info:
- Windows 2000 Pro + Apache 1.3.14
- PHP 4.0.4pl1 (4.0.5 just wouldn't work on my machine)
- Progress 8.3.B
- Merant Progress ODBC drivers v 3.50
the ODBC drivers seem to be fine - I made a MS Access database
15 matches
Mail list logo
