Hi !
I need to access my MS-SQL-Sever V7.0. In a lot of messages I the extension
php_mssql70.dll is mentioned, but the latest release of php is shipped with
php_mssql.dll instead. Is that okay ?
The use of the mssql_open() function fails every time and my firewall log
doesn't show any access at
Hi,
I need to access my MS-SQL-Sever V7.0. In a lot of messages I the extension
php_mssql70.dll is mentioned, but the latest release of php is shipped with
php_mssql.dll instead. Is that okay ?
it's the same, just try to check your php.ini [extensions] block, to reflect the
exact name of your
Hi!
In MySQL-4.0.0 you can delete from several tables in a join:
DELETE t1, t2 FROM t1, t2, t3 WHERE ...;
But 4.0.0 is still alpha, and it will take some months for it to
stabilize. No compact or defrag is normally needed with
MySQL.
Regards,
Heikki
http://www.innodb.com
Shaun Honsvick
Maybe I'm slow...I'm trying to decipher what you're trying to do. Show us your table
layout
Show us your search criteria and code
Show us a dump of your table so we can see what the data look like
ahhh give the chap a break, this is 4th (or so) posting. he thinks we're all
wonderful! Let's not
Sorry, natürlich benutze auch ich mssql_connect(). Der Zugriff funktioniert
aber leider nur, wenn sich der SQL-Server und der WEB-Server auf dem
gleichen Host befinden. Ein Zugriff über das Internet auf einen anderen
Server ist nicht möglich. Und genau das ist mein Problem.
Thorsten Hock
([EMAIL
Hi there,
I encounter the following problem when trying to build a LAMP Box with
Mysql-4.0.0+PHP-4.0.5+Apache-1.3.22.
1. Mysql Installed ok
2. when trying to make php with
./configure --with-apache=/home/user/apache_1.3.22 --with-mysql=/usr/local/
db/mysql
Hi, i'm trying to import tables containing TEXT fields from MSSQL 2K, so far
tried different ways, one of them DTS, but unsuccessfully.
It gives error: Query-based insertion or updating of BLOB values is not
supported.
Any help will be very much appreciated :)
Moshe
--
PHP Database Mailing
i don't think frames are the problem.
check again if you printing anything in same frame before session_start();
Tjaybelt [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have a site that is successfully using sessions and authentication.
However, I am working
Hi Andreas,
the problem is that not every row of the $ergRouten statement has a row in
the $ergDispatch statement.
I also tired a UNION query, but this took longer for execution than it does
now and brings me more timeout problems then I have now.
Michael
Andreas Karajannis [EMAIL PROTECTED]
Hi Andreas,
what I forgot: the queries connect both to different databases, so they use
a different connection.
Michael
Andreas Karajannis [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Michael J. Eisner wrote:
i have a loop going through a result
Bonjour la liste
?
$result2 = mysql_db_query($dbname,select * from gifs);
while($colonne2 = mysql_fetch_array($result2))
{
switch($colonne[LIV_TYPE_EVT])
{
case $colonne2[ID_EVT];
//echo $colonne2[IMG];
echo img src
?
$result2 = mysql_db_query($dbname,select * from gifs);
while($colonne2 = mysql_fetch_array($result2))
{
switch($colonne[LIV_TYPE_EVT])
{
case $colonne2[ID_EVT];
//echo $colonne2[IMG];
echo img src = $colonne2[IMG];
break;
No need to defrag/compact...MySQL will reuse the space.
Since posting my original message, I've learned that version 4.0 (alpha) of
MySQL was released on 15 October. In Paragraph 6.4.6 of the MySQL manual,
we read:
The multi table delete format is supported starting from MySQL 4.0.0.
Switch to odbc. There are some limitations with mssql extension.
Regards, john
M0sh3 [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi, i'm trying to import tables containing TEXT fields from MSSQL 2K, so
far
tried different ways, one of them DTS, but
Hello,
Currentlu testing the dbm functions (for a wrapper class), stopped with dbm.
Configure does not recognize the dbm library (db-3.3.11).
gdbm, db3 has been recognized.
Wich library do I need to use the dbm function (with or without dba), any
link ?
thank's
pa
--
PHP Database Mailing
Hmm! Sometimes tracing needs to be turned off and then back on. The driver
manager in Windows can be buggy.
Also, select some drive level file to be safe, like c:/sql.log
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data
Hi all.
I'm trying to find a way to use apache authentication trough php/mysql.
I mean that users/passwords need will be stored in mysql database but Apache
will athomatically request authentication for any access to protected folder
_and its subfolders_.
For not to make something like access.php
Hello *
I am trying to batch load data into MySQL 3.23.39 from
data that I am preparing using MS Excel, converting to
tab-delimited txt file and uploading using
phpMyAdmin...
...the problem is in trying to load the NULL value for
some columns...if I leave the column empty it just
gets truncated,
I can't connect to an ODBC data source. I have done this before many
times. I am now trying to connect to a new driver for new data. This
is the first time I have tried to access a file DSN. I have the driver
setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to
connect
Anthony,
Is the DSN usable from the ODBC Administrator control panel?
E.g. test it there first. Also, you mention File DSNs? PHP can only use
System DSNs on Windows, AFAIK.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data
yes, I can use the source from other programs. The source is a System
DSN, based on a file DSN for the driver. The I_USR_servername user
has the correct access rights to the files being accessed and to the
file DSN driver.
Andrew Hill wrote:
Anthony,
Is the DSN usable from the ODBC
Can anyone tell me why my results will display when I just use text, but
won't display when I try to put them into a table. I keep getting a message
saying there is a parse error on line 50 of my script, but as far as I acn
see, line 50 is commented out.
Georgina
html
head
titleProject Database
Imbalance of double-quotes on line 43!
Thus // comments have all been included in quoted string and hence strange text output.
=dn
- Original Message -
From: GEORGINA ELAINE BAILEY [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 19 October 2001 18:26
Subject: [PHP-DB] PHP and Oracle
Null values are displayed as NULL. NULL is NOT the same as .
is an empty string. NULL means no value is assigned.
-Original Message-
From: Adv. Systems Design [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 11:15 AM
To: PHP List
Subject: [PHP-DB] inserting NULL value
select max(idfield) from table
-Original Message-
From: Brad Harriger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 7:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Access to MySQL Conversion question
I have several MS Access databases that I need to convert to
Hi,
I have a form with two dropdown fields. When ever one of them is changed, a
javascript function is called that reloads the whole PHP-Page.
The first dropdown has values in the form like '19.10.2001' or '25.10.2001'
the second one only one charakter like 'V', 'M' or 'F'.
When I change the
Anthony,
Then enable ODBC tracing in the ODBC Administrator and see where the calls
are failing.
Or try a different ODBC driver - you can download free ones from our site
for most databases.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Hi,
disregard this post - i found the error - a little mistyping :-(
Michael
Michael J. Eisner [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
I have a form with two dropdown fields. When ever one of them is changed,
a
javascript function is
First post, yay. Anyways, I have a win2k server box,
with all the critical updates and blah blah blah to secure it,
and I have PHP installed and tested, and phpinfo(); works.
Then I attempted to install SQL 2000, and thats where everything
went downhill. I test my script, and on the server
When I input some value inside the textbox in the search engine and click
send, I will find what I want ; however, when I click Back in the
brower, the value what I input was dismissed, how to restore this as it is
so trouble that I need to type it again in the text box.
Thanks
Keldo
--
PHP
With a basic php document, I am trying to create a table. I have a good
code for the table (I think) but I cannot connect to the SQL server. I
have the SQL server name, SQL username, SQL password, and SQL database
name. I have tried too many options to list here. It is not a localhost.
I'm using
Is it possible to put variable operators in queries?
=I can see no reason why not - you're not actually putting the 'variable' in the
'query', just using a PHP-variable to
build a PHP-string which will be sent to MySQL as a SQL query...
I tried this (the real variable comes from a form)
Hello,
Is it possible to put variable operators in queries?
I tried this (the real variable comes from a form)
$Date_Operator =(=);
sql=SELECT * FROM poeple WHERE age $Date_operator 20;
$result_id = mysql_query($sql);
It doesn't work like this. I also tried:
sql=SELECT * FROM poeple WHERE
33 matches
Mail list logo