Re: PHP & SQL Server 2005

This could also be caused by a mismatch in the fields. Try opening up your SQL Management Studio and then paste your INSERT statement into a new query, execute it and see if it works. On 4/26/07, Gustav Wiberg <gustav@hmn.se> wrote:

Hi again! Maybe it's something about rights for the IUSR? Else I don't know... Best regards /Gustav Wiberg -----Original Message----- From: Dale Attree [mailto:dale@jacklin.co.za] Sent: Thursday, April 26, 2007 8:37 AM To: 'Gustav Wiberg' Subject: RE: [PHP-WIN] PHP & SQL Server 2005 It is a brand new database, now data in it. When I execute the queries through the studio manager, they work. -----Original Message----- From: Gustav Wiberg [mailto:gustav@hmn.se] Sent: 26 April 2007 08:32 AM To: 'php windows' (php-windows@lists.php.net) Subject: RE: [PHP-WIN] PHP & SQL Server 2005 Hi again Is it the the same with updates? Maybe its something about limitation in table? http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2 000-and-2005.aspx Best regards /Gustav Wiberg -----Original Message----- From: Dale Attree [mailto:dale@jacklin.co.za] Sent: Thursday, April 26, 2007 8:24 AM To: 'Gustav Wiberg' Subject: RE: [PHP-WIN] PHP & SQL Server 2005 Doesn't matter. That variable is not related to my problem. -----Original Message----- From: Gustav Wiberg [mailto:gustav@hmn.se] Sent: 26 April 2007 08:21 AM To: 'php-windows@lists.php.net' Subject: RE: [PHP-WIN] PHP & SQL Server 2005 Hi there! "$RP = $_SERVER['REQUEST_URI'];" Shouldn't this be $RP = $_SERVER['REQUEST_URL']; ? Best regards /Gustav Wiberg -----Original Message----- From: Dale Attree [mailto:dale@jacklin.co.za] Sent: Thursday, April 26, 2007 8:13 AM To: 'Alf Stockton' Cc: php-windows@lists.php.net Subject: RE: [PHP-WIN] PHP & SQL Server 2005 $RP = $_SERVER['REQUEST_URI']; $res = mssql_query($sql,$dblink) or die($RP.'<br>'.mssql_get_last_message()); It is hitting the die() and therefore not inserting into the DB. -----Original Message----- From: Alf Stockton [mailto:alf@stockton.co.za] Sent: 26 April 2007 08:06 AM To: Dale Attree Cc: php-windows@lists.php.net Subject: Re: [PHP-WIN] PHP & SQL Server 2005 Dale Attree wrote: Hi guys. I am able to do select queries without any hassles, but as soon as I try execute an insert query, I get "The statement has been terminated." Any suggestions? The "The statement has been terminated." does not necessarily mean that the insert failed. Look in the table and see if the insert was successful. -- Regards,

Alf Stockton            www.stockton.co.za

You can do very well in speculation where land or anything to do with dirt is concerned. My email disclaimer is available at www.stockton.co.za/disclaimer.html -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php **************************************************************************** ******************* The information contained in this e-mail is confidential and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient you must not use, copy, distribute or disclose the e-mail or any part of its contents or take any action in reliance on it. If you have received this e-mail in error, please notify us immediately by e-mail (postmaster@jacklinenterprises.com) or telephone (+27 11 265 4200). This message is free of all known viruses. It has been screened for viruses by Blockmail. **************************************************************************** ******************* -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php **************************************************************************** ******************* The information contained in this e-mail is confidential and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient you must not use, copy, distribute or disclose the e-mail or any part of its contents or take any action in reliance on it. If you have received this e-mail in error, please notify us immediately by e-mail (postmaster@jacklinenterprises.com) or telephone (+27 11 265 4200). This message is free of all known viruses. It has been screened for viruses by Blockmail. **************************************************************************** ******************* -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php *********************************************************************************************** The information contained in this e-mail is confidential and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient you must not use, copy, distribute or disclose the e-mail or any part of its contents or take any action in reliance on it. If you have received this e-mail in error, please notify us immediately by e-mail (postmaster@jacklinenterprises.com) or telephone (+27 11 265 4200). This message is free of all known viruses. It has been screened for viruses by Blockmail. *********************************************************************************************** -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php