Re: [PHP-DB] how to get ERROR message

2001-07-06 Thread Dobromir Velev
Hi, dud you try to use something like this $result=mssql_query(exec x) or die(mssql_get_last_message()); instead of $result=mssql_query(exec x) or die(query failed); Removing the or die part must display an error message too, but it won't end the script execution. Dobromir Velev

[PHP-DB] SQL error:

2001-07-06 Thread Jennifer Arcino Demeterio
hello!!! i'm getting this error. what does this mean? hope someone can help. i'm using sql7 in NT4 server Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_DEPT'., SQL state S0002 in SQLExecDirect in F:\Web

[PHP-DB] UPLOAD

2001-07-06 Thread Enrico Comini
My problem is to browse a local pc (win) and upload a file in a remote database. There is a simple solution (js ie)? Thanks, Enrico

Re: [PHP-DB] SQL error:

2001-07-06 Thread Andrei Skorokhod
Which user are you connected as? Who owns the table? unless you connected as the user who owns the table or table is owned by dbo you have to specify username.TBL_DEPT (where username is the name of the user who owns the table) At 16:47 06.07.2001 +0800, you wrote: [EMAIL PROTECTED] -- PHP

RE: [PHP-DB] Newbie:Backend scripts

2001-07-06 Thread Mats Remman
windows 2000 has a command called 'at' .. which is somewhat like crontab. and there is no reason to run lynx and whatever. php for windows has an exe for a reason 'php.exe c:\path\to\phpfile.php' schedule that every two hours. Mats Remman PHP Developer/Mysql DBA Coretrek, Norway +47 51978597

[PHP-DB] Re: Cookie is set?

2001-07-06 Thread Angela Meehan
Here's the way I check: -Set a cookie on the user's machine. I name mine sessionid. -Redirect to a new page using header(location: acceptcookies.php); -On the new page, check to see if the variable has a value. For example, I would check to see if $sessionid== and if it's true then their

[PHP-DB] TEXT fields without line breaks

2001-07-06 Thread Mat Marlow
Hi all, (I'm not sure if this is the right place to submit this but I'm having problems with the php.general group) I am in desperate need for a solution to HTML text fields not storing new lines. I'm storing news articles in a database but all the text just ends up in a big block because it

Re: [PHP-DB] TEXT fields without line breaks

2001-07-06 Thread John S. Huggins
The line breaks may be there, but HTML will not render them. Try this: $outputstring = nl2br($stringfromDB); print(p$outputstring/p); or something like this to see if the newlines will convert to br and render correctly. John On Fri, 6 Jul 2001, Mat Marlow wrote: -Hi all, -(I'm not

RE: [PHP-DB] TEXT fields without line breaks

2001-07-06 Thread Kevin Johnson
Ive encountered this at my last job and we were using perl as our backend. Before inserting into the database, check for \n or \r and replace with a combo of chars that are mostly likely not to be typed into the text field. Examples: ][, or |43; or whatever... Then when you reread back from the

[PHP-DB] front end for mysql for use on my website

2001-07-06 Thread Ed Peddycoart
I am looking for a front end for mysql for use on my website. What I want is something that I can run, from the server (my webhost will not allow remote connections to the mysql server), that allows me to insert, delete, and modify records into a mySql database. Requirements are that it be

Re: [PHP-DB] front end for mysql for use on my website

2001-07-06 Thread John S. Huggins
Try phpMyAdmin. On Fri, 6 Jul 2001, Ed Peddycoart wrote: -I am looking for a front end for mysql for use on my website. What I want -is something that I can run, from the server (my webhost will not allow -remote connections to the mysql server), that allows me to insert, delete, -and modify

Re: [PHP-DB] PHP MSSQL, IIS Question -- Size Question

2001-07-06 Thread Frank M. Kromann
What version of php are you using ? Handling of binary data from MSSQL Server was changed from php4.0.5 to php4.0.6. As far as I can tell You should not have any problems with php4.0.6 - Frank I am preparing a report for a database at my company that will be shown on the web. It has

[PHP-DB] Stress tesing a DB

2001-07-06 Thread Ted Rolle
I'm gathering data on open-source databases... is there a program that can provide comparisons between databases, such as MySQL and PostgreSQL? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] Re: Interbase: how can I insert null values with placeholders?

2001-07-06 Thread Jeremy Bettis
I found this bug and fixed it but my patch has not been included in the cvs source yet. (Note, someone should give me cvs access to the interbase source.) The problem is that the interbase extension has been pretty much untouched since php3 and I don't think that the null value was added until

[PHP-DB] Distributed Tables vs. fewer Monster Tables

2001-07-06 Thread John S. Huggins
I am putting the finishing touches on a forum program which has a direct lineage (look and feel at least) to Matt Wright's WWWBoard perl script. Remember that? Today I have one table per forum. The forums on my live test site are huge. http://www.astronomy.net/forums/ I have long dreamed of

[PHP-DB] Redhat TUX

2001-07-06 Thread Sharmad Naik
I have heard about a new server developed by Redhat called TUX. Is php supported in this? -Thanks -- Donot rely on the Operating System which don't have any sources for. -Seen somewhere on the Net ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \|