[PHP-DB] MS SQL server 2k and php4 on win32
Well, I just started working on implementing SQL Server support in my database abstraction class. I downloaded and installed the SQL2k evaluation from MS and I can connect through DBArtisan and through the SQL Server Query tool. However when I try to do it through PHP, it just sits there, and causes IIS to get b0rked. the mssql7 dll is enabled, maybe that's the problem? Maybe it's a path order problem? I moved the SQL Server "binn" path to the front of my path statement, but no change. Any ideas? (yes, I searched the archive first, but didn't find anything helpfull =/) - Sean Finkel Webmaster - Rabid Wolf .:: Hungry For Knowledge ::. http://www.rabid-wolf.com - -- 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]
RE: [PHP-DB] Can you recommend a development tool?
On the contrary... I use Dreamweaver for layouts and then use either it's integrated editor for PHP or fire it up in Textpad. No code reofmatting and it works seamlessly. Sean -Original Message- From: Daniel Rezny [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:01 AM To: John Coonrod Cc: (php-db list) Subject:Re: [PHP-DB] Can you recommend a development tool? Hello John, Thursday, February 08, 2001, 5:12:21 PM, you wrote: JC Can anyone out there recommend a graphical development tool (like FrontPage) JC that you find useful for developing php-based web pages? I'm looking at how JC to empower my staff who are a bit new to all this. JC JC Dr. John Coonrod, Vice President, [EMAIL PROTECTED] JC The Hunger Project, 15 East 26th Street, NY, NY 10010 www.thp.org www.allaire.com and theirs HOMESITE editor. In my opinion this is the best editor and my favourite. So try it. Do not try any WYSIWYG editors. Generating plain code is the best. -- Best regards, Daniel -- 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] -- 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]
RE: [PHP-DB] Viewing the DB
This was taken from one of the doc's on IBM's site: SYSTABLES contains a row for every table and view in the SQL collection. It tells you if the object is a table or view, the object name, the owner of the object, what SQL collection it is in, and so forth. The following sample statement displays information for the CORPDATA.DEPARTMENT table: SELECT * FROM CORPDATA.SYSTABLES WHERE NAME = 'DEPARTMENT' so a "select * from schema.systables" should get you a list of all table names (theoretically) ;P Sean -Original Message- From: Scott Fletcher [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 3:48 PM To: [EMAIL PROTECTED] Subject:Re: [PHP-DB] Viewing the DB I'm using IBM DB2. No Oracle, No mySQL. Scott ""Scott Fletcher"" [EMAIL PROTECTED] wrote in message 94mt56$skf$[EMAIL PROTECTED]">news:94mt56$skf$[EMAIL PROTECTED]... Does anyone know what is the sql command that would allow me to view all of the tables in the database? Scott -- 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] -- 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] -- 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]
RE: [PHP-DB] MS-SQL Error Message Replacement
well, one way would be to place a check before the delete statement. check to see if there are any child records and then only send the delete statement if it is ok to delete :) -Sean -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 7:22 PM To: [EMAIL PROTECTED] Subject:[PHP-DB] MS-SQL Error Message Replacement I'm working with MS-SQL 7 and IIS 4 as well as PHP4.0.4 --- My question is that when a message is received while attempting to delete a row in [table x] while it is tied to [table y.column a] by a foreign key relationship [see below] Warning: MS SQL message: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_COMPONENT_INDEX_page'. The conflict occurred in database 'corplan', table 'COMPONENT_INDEX', column 'pid'. (severity 16) in D: \Inetpub\wwwroot\admin\intranet.php on line 122 Warning: MS SQL: Query failed in D:\Inetpub\wwwroot\admin\intranet.php on line 122 How can I put in my own custom message when these errors occur? Should I be looking for a failed query message and then acting on that? I like the protection that the foreign key relationship enables, because you can't delete "parent" objects without removing the children first. I'm sure this really isn't a difficult question, I'm looking for for suggestions on how I should approach this. Thanks, Ryan Sinn US Bank -- 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] -- 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]
