...ive checked both versions, but they all have the same "error" inside.
Lets start in the beginning.
For several months my webserver has used mysql 3.23.38 AND php4.0.1 on
Apache 1.3.12.
I had never ANY problems so the motto was: Never touch a runnning system
(oh murphy you are so damn
How I can format date in php query from MSSQL?
Jack
--
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]
Hi
Have a look in Books Online - the e-docs for MSSQL - search for the convert
function and all will be revealed.
Peter
- Original Message -
From: Jack [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 5:49 PM
Subject: [PHP-DB] Date format in MSSQL
How I can
Hi,
I've read that Oracle (oci8) doesn't support the adodb function RecordCount
: it returns -1. Is it true with adodb 1.20 ? is there a smart workaround?
thanks in advance,
Philippe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
hi everybody,
when i call to my file (my_file.php), the next error occurs:
[the scenario]
Winnt 4.0 SP6
IIS 4
php 4.0.5
[my_file.php]
?php
$con = odbc_connect('the_dsn', '', '');
odbc_close($con);
?
[the error: i translated it from the spanish (or at least i tried to...)]
Anyone using the Ingres routines in PHP 4.0.6 to access Ingres II? We
have the problem that the database always sees the connection as coming
from the username under which we run Apache, no matter what is specified
in the ingres_connect() routine.
Versions: PHP 4.0.6, Apache 1.3.20, Solaris 8,
Hello everyone...
Could someone give me a tip ang tell me if i can insert more than one
queries in a mysql_query() statement??
etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db)
Thanks.
___
PGP KEY ID: 0xA86600E9
___
Could someone give me a tip ang tell me if i can insert more than one
queries in a mysql_query() statement??
etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db)
No, you can't. You've got to execute them one at a time.
--
-Ryan :: ICQ - 595003 :: GigaBoard -
Hi everybody,
All of the sudden I got an error one of mysql tables.
Got error 127 from table handler.
Can't browse it not even from phpmyadmin get the same error. Anybody had
this before? What do I do to recuperate my table?
I really appreciate any help,
Thanks,
Cami
--
PHP Database Mailing
the only time i've had this (not sure if it was 127) but i couldn't get the
properties etc was after i named a table with a name that was a keyword.
check the list in the docs as the list is quite long.
i called mine 'returns'
doh!
Steve
Cami [EMAIL PROTECTED] wrote in message
[EMAIL
Cami,
Here's what I found on the error and what to do about it:
http://www.mysql.com/doc/R/e/Repair.html
Hope that helps!
My 2 ¢
John Pickett
http://www.bvstudios.com/
Co-Author: Inside Dreamweaver 4
http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist
- Original Message -
EOF shoud do the trick for my purpose (just want to know if my select
returns a row or not).
If not EOF just after a select, this means that the select returns at least
one row. No more need to use recordcount.
Thanks Philippe. Well, you're welcome, Philippe
Regards,
... Philippe
Philippe
Thanks everybody for pointing me to the right place.
I manage to recover it.
Thank God.
Cami
-Original Message-
From: Cami [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error 127
Hi everybody,
All of the sudden I got an error
you know i did this last week and can't remember the functions is used.
i had exactly the same problem but had to dump the records as plain text
files.
i used get_html_translation_table . if you look at the example in the
compiled html help file for php there is a section of code that uses this
Make sure ahead of time whether the cable ISP gives you a static IP address
or a dynamic one... Most of them in the US only give you dynamic IP's. They
don't change all that often, but it does make it tough to host a domain name
if your IP address is liable to change at any given moment. Also,
I can connect my oracle server from apache with php function
OCILogon(user,pwd,dbname);
without problems...
but sometimes when i reload the same web page i get the ORA-24327 error
OCISessionBegin: Error while trying to retrieve text for error ORA-24327
My machine is a Sun solaris
whit APACHE
Hi guys
I've got a form in my web site which is working just fine, that is, it does
everything I want, however whenever I load the page I get the following
warning messages:
Warning: Unable to open '' for reading: No such file or
At 02:08 PM 7/19/01 -0500, Wilmar Pérez wrote:
Hi guys
I've got a form in my web site which is working just fine, that is, it does
everything I want, however whenever I load the page I get the following
warning messages:
Warning:
On Thursday 19 July 2001 19:25, Andrew Chase wrote:
Make sure ahead of time whether the cable ISP gives you a static IP address
or a dynamic one... Most of them in the US only give you dynamic IP's.
They don't change all that often, but it does make it tough to host a
domain name if your IP
Friends,
I have a design, up and running scripts connected to MySQL.
How do I retrieve date formats and have it displayed as dd-mm- ?
I store them as DATE.
CK Raju
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Can anyone suggest a good utility for converting database from MS Access to MySQL?
Thanks.
--
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
yeah, cut and paste, jk, im curious too
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 2:15 PM
Subject: [PHP-DB] Converting MS Access to MySQL
Can anyone suggest a good utility for converting database from MS Access
to MySQL?
Thanks.
You can use ODBC to go from Access to MySQL. Get the MyODBC driver for
Windows and setup your datasource so you can get to it via Access. You can
do a direct export from Access to the MySQL database that way. There may be
some differences, but I'm not sure of what all of them would be.
Hope
cant... since the function returns a code if the call is true or not.
if you try multiple statements, you cant know which failed and which was
good...
Koutsogiannopoulos Karolos wrote:
Hello everyone...
Could someone give me a tip ang tell me if i can insert more than one
queries in a
Hi there,
can anyone tell me, how I have to handle special characters in an
odbc-query?
for example: 'select * from $table where primary-key=\'1\' ' doesn't
work because of the dash in primary-key
Thx
Kobi
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
Is there a way to encode a string in PHP exactly like MySQL does it in its
PASSWORD() Function?
Reason being Is I have a table with PASSWORD() encoded fields that I need to
compare from PHP.
Thanks,
Andrew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
?php
$date = 2001-07-19; // as if it just came from the db
$date_array = explode('-',$date);
$date = $date_array[1] . - . $date_array[2] . - .
$date_array[0];
?
That should do it =
Good luck!
Ben
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
27 matches
Mail list logo