[PHP-DB] Starters question: mysql PHP.INI

2004-02-19 Thread jeroen . lankheet
Dear all, I'm trying to get the horde applications working. The horde people have redirected my question to this list. Here it comes: How should I change the PHP.INI file in order to work with mysql session data, instead of files? I ask this, because googling did not reveal any parameters

[PHP-DB] Re: SUM and JOIN together

2004-02-19 Thread Justin Patrin
Rogue wrote: Hi all, Not sure how to handle this situation and was hoping someone with a bigger brain then me could help. 2 tables tbl_hoursbought id | client | hours 1 | test | 5 2 | test | 10 tbl_hoursused

[PHP-DB] Re: Subject: Starters question: mysql PHP.INI

2004-02-19 Thread Neil Smith [MVP, Digital media]
I think you have to look up session_set_save_handler() in the PHP documentation, but I thought it was usually done manual (Ie, per page) process rather than in php.ini, though you can set it there if you like : Your specified save handler functions then take care of handing off data to and

[PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
I'm getting the error Changed database context from MS SQL. I see where this is supposedly just an informational message. I've tried setting mssql.min_error_severity = 11 mssql.min_message_severity = 11 but to no avail. What am I missing? I don't mind the message so much, but php treats this

Re: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Adam Voigt
This may not be the case, but I've seen this before when the PHP library didn't know how to express MS SQL's error, so it simply returns the last message sent which was the informational context change. If it is infact an error, you should be able to plug the query directly into Enterprise Manager

[PHP-DB] Stored procedure with UNION---no unique id, how to page?

2004-02-19 Thread Karen Resplendo
I have a stored procedure in msSQL that UNIONs 3 queries. There is no unique identifier that is sequential that I can use to page on webpage because the data comes from different tables/databases. Is there a way to save the resultset into a temp table and add an @@Identity(autonumber) to it?

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
Thanks, Adam. I don't get the error in Enterprise manager. MS has a KB article out that says that this message is informational. I seem to remember that the article also says the message comes out some times, and not other times, but that you should just forget it. The particular SELECT

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Adam Voigt
Try putting the error suppressor (@) before the query, eg: @mssql_query Or, try setting the error reporting: error_reporting(0); On Thu, 2004-02-19 at 14:38, Michael Flanagan wrote: Thanks, Adam. I don't get the error in Enterprise manager. MS has a KB article out that says that this

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
Adam, Thanks for the suggestions. I don't want to ignore all error handling. Later, I might get an error that I really don't want php to swallow due to either of your suggestions. Has anyone else run into this and solved it? Any idea why the following lines in the php.ini file don't work?

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Frank M. Kromann
You are getting a message from the SQL Server. If you increase the values of mssql.min_error_severity and mssql.min_message_severity (default is 10) you will get more messages if you descrease the value you will get less messages. - Frank Adam, Thanks for the suggestions. I don't want to

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
Frank, thanks! My problem was that I was increasing the value. I decreased the value to 4, and I still get the error/message. Any idea what value will work, without throwing away valuable messages? There are some messages I want to consider an error. Any doc someplace that describes the

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Robert Twitty
Hi Michael You might get better results using the odbtp extension with support for the mssql functions. Since you are using Windows, use php_odbtp_mssql.dll instead of php_mssql.dll. -- bob On Thu, 19 Feb 2004, Michael Flanagan wrote: Adam, Thanks for the suggestions. I don't want to ignore

[PHP-DB] Re: Stored procedure with UNION---no unique id, how to page?

2004-02-19 Thread Frank Flynn
On 2/19/04 4:09 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: From: Karen Resplendo [EMAIL PROTECTED] Date: Thu, 19 Feb 2004 11:37:48 -0800 (PST) To: [EMAIL PROTECTED] Subject: Stored procedure with UNION---no unique id, how to page? I have a stored procedure in msSQL that UNIONs 3

Re: [PHP-DB] Stored procedure with UNION---no unique id, how to page?

2004-02-19 Thread John W. Holmes
Karen Resplendo wrote: I have a stored procedure in msSQL that UNIONs 3 queries. There is no unique identifier that is sequential that I can use to page on webpage because the data comes from different tables/databases. Would you be able to use mssql_data_seek() to jump to the result set row

[PHP-DB] Multiple values for a column

2004-02-19 Thread Shiloh Madsen
I need to figure a way to create a table column that will allow for me to be able to say IF column = and then specify more than a single value. for instance, select all from the table where the column in question is either 1, 3, 4, and/or 7. However, I want this column to be able to hold more

[PHP-DB] Re: Starters question: mysql PHP.INI

2004-02-19 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Dear all, I'm trying to get the horde applications working. The horde people have redirected my question to this list. Here it comes: How should I change the PHP.INI file in order to work with mysql session data, instead of files?

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
Hi Robert, I've seen your name on a few of the ODBTP posts. You're one of the developers of same, yes? Are you familiar with the 'Changed database context' message? Do you know for sure that ODBTP handles that correctly? Thanks. Michael -Original Message- From: Robert Twitty

[PHP-DB] /path/to/sqlite

2004-02-19 Thread David J Jackson
Howdy, I'm trying to use Sqlite on a remote hosted website, with sqlite placed in the my home directory (public_html is there also). Can I specify the path for sqlite in as part of include_path= statement --- /home/username/sqlite.bin /home/username/public_html # virutal_document_root TIA,

[PHP-DB] Need some help please!

2004-02-19 Thread JeRRy
Hi, I have this code, comments below: ? include(../pages/setup.php);? ? login();? ? include(../pages/header.php);? !DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head STYLE .general3 {background-color:#33;z-index:4} .general2 {background-color:#55;z-index:3}

Re: [PHP-DB] Multiple values for a column

2004-02-19 Thread Jason Wong
On Friday 20 February 2004 09:14, Shiloh Madsen wrote: I need to figure a way to create a table column that will allow for me to be able to say IF column = and then specify more than a single value. for instance, select all from the table where the column in question is either 1, 3, 4, and/or

[PHP-DB] Re: Need some help please!

2004-02-19 Thread Justin Patrin
PHP is serverside, meaning that the only way you can do anything having to do with PHP is to have the client go to a page. Otherwise, the PHP isn't called and so doesn't have a chance to run. If you *really* want to do things interestingly you can maybe have your javascript go to a URL without

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Robert Twitty
Hi Michael Yes, I am the developer of ODBTP, and changing the database context will not cause a problem. -- bob On Thu, 19 Feb 2004, Michael Flanagan wrote: Hi Robert, I've seen your name on a few of the ODBTP posts. You're one of the developers of same, yes? Are you familiar with the

[PHP-DB] MySQL Update and Sort Queries

2004-02-19 Thread Ng Hwee Hwee
hi all, 1) Question on UPDATE My situation is this: I want to update Table1 with values that can be found in Table2.. in short, I would like to do the following: $query = update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no; however,

[PHP-DB] PEAR DB 1.6.0 has been released

2004-02-19 Thread Daniel Convissor
[This has be cross-posted. Be careful when following up, please.] Greetings: Crack open the beer, PEAR DB 1.6.0 is here! (Hey, I'm a bit giddy with excitement that my intense work during the past seven weeks has come to fruition.) For those unfamiliar with PEAR DB, it's a package of PHP

[PHP-DB] Re: PEAR DB 1.6.0 has been released

2004-02-19 Thread Jakes
What is performance like using this class? I've gone through the class and it just seams to be over kill, for a DB API (13 databases). Are there any time stats showing the different time in using a single DB API class to the PEAR class. Thanks Daniel Convissor [EMAIL PROTECTED] wrote in