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@xxxxxx> 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@xxxxxxxxxxxxx] Sent: Thursday, April 26, 2007 8:37 AM To: 'Gustav Wiberg' Subject: RE: 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@xxxxxx] Sent: 26 April 2007 08:32 AM To: 'php windows' (php-windows@xxxxxxxxxxxxx) Subject: RE: 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@xxxxxxxxxxxxx] Sent: Thursday, April 26, 2007 8:24 AM To: 'Gustav Wiberg' Subject: RE: PHP & SQL Server 2005 Doesn't matter. That variable is not related to my problem. -----Original Message----- From: Gustav Wiberg [mailto:gustav@xxxxxx] Sent: 26 April 2007 08:21 AM To: 'php-windows@xxxxxxxxxxxxx' Subject: RE: 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@xxxxxxxxxxxxx] Sent: Thursday, April 26, 2007 8:13 AM To: 'Alf Stockton' Cc: php-windows@xxxxxxxxxxxxx Subject: RE: 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@xxxxxxxxxxxxxx] Sent: 26 April 2007 08:06 AM To: Dale Attree Cc: php-windows@xxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxxxxxxxxxx) 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
