PHP & SQL Server 2005

PHP & SQL Server 2005

am 25.04.2007 12:48:00 von Dale Attree

------=_NextPart_000_005C_01C78737.F670D810
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

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?



Kind Regards,

Dale



************************************************************ ***********************************

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.

************************************************************ ***********************************


------=_NextPart_000_005C_01C78737.F670D810--

Re: PHP & SQL Server 2005

am 26.04.2007 08:06:13 von Alf C Stockton

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

RE: PHP & SQL Server 2005

am 26.04.2007 08:13:28 von Dale Attree

$RP = $_SERVER['REQUEST_URI'];

$res = mssql_query($sql,$dblink) or
die($RP.'
'.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

RE: PHP & SQL Server 2005

am 26.04.2007 08:21:00 von Gustav Wiberg

Hi there!

"$RP =3D $_SERVER['REQUEST_URI'];"

Shouldn't this be $RP =3D $_SERVER['REQUEST_URL']; ?

Best regards
/Gustav Wiberg


-----Original Message-----
From: Dale Attree [mailto:dale@jacklin.co.za]=20
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 =3D $_SERVER['REQUEST_URI'];

$res =3D mssql_query($sql,$dblink) or
die($RP.'
'.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]=20
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.
>=20
> =20
>=20
> 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."
>=20
> =20
>=20
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that=20
the insert failed.
Look in the table and see if the insert was successful.

--=20
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

--=20
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 unauth=
orised.

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 reli=
ance on it. If you have received this e-mail in error, please notify us imm=
ediately 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.

************************************************************ ***************=
********************

--=20
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

RE: PHP & SQL Server 2005

am 26.04.2007 08:32:00 von Gustav Wiberg

Hi again

Is it the the same with updates?

Maybe its something about limitation in table?=20
http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-lim itation-in-sql-=
2000-and-2005.aspx

Best regards
/Gustav Wiberg

-----Original Message-----
From: Dale Attree [mailto:dale@jacklin.co.za]=20
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]=20
Sent: 26 April 2007 08:21 AM
To: 'php-windows@lists.php.net'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005

Hi there!

"$RP =3D $_SERVER['REQUEST_URI'];"

Shouldn't this be $RP =3D $_SERVER['REQUEST_URL']; ?

Best regards
/Gustav Wiberg


-----Original Message-----
From: Dale Attree [mailto:dale@jacklin.co.za]=20
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 =3D $_SERVER['REQUEST_URI'];

$res =3D mssql_query($sql,$dblink) or
die($RP.'
'.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]=20
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.
>=20
> =20
>=20
> 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."
>=20
> =20
>=20
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that=20
the insert failed.
Look in the table and see if the insert was successful.

--=20
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

--=20
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.

************************************************************ ***************=
*
*******************

--=20
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--=20
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 unauth=
orised.

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 reli=
ance on it. If you have received this e-mail in error, please notify us imm=
ediately 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

RE: PHP & SQL Server 2005

am 26.04.2007 08:42:00 von Gustav Wiberg

Hi again!

Maybe it's something about rights for the IUSR?=20
Else I don't know...=20

Best regards
/Gustav Wiberg=20

-----Original Message-----
From: Dale Attree [mailto:dale@jacklin.co.za]=20
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]=20
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?=20
http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-lim itation-in-sql-=
2
000-and-2005.aspx

Best regards
/Gustav Wiberg

-----Original Message-----
From: Dale Attree [mailto:dale@jacklin.co.za]=20
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]=20
Sent: 26 April 2007 08:21 AM
To: 'php-windows@lists.php.net'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005

Hi there!

"$RP =3D $_SERVER['REQUEST_URI'];"

Shouldn't this be $RP =3D $_SERVER['REQUEST_URL']; ?

Best regards
/Gustav Wiberg


-----Original Message-----
From: Dale Attree [mailto:dale@jacklin.co.za]=20
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 =3D $_SERVER['REQUEST_URI'];

$res =3D mssql_query($sql,$dblink) or
die($RP.'
'.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]=20
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.
>=20
> =20
>=20
> 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."
>=20
> =20
>=20
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that=20
the insert failed.
Look in the table and see if the insert was successful.

--=20
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

--=20
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.

************************************************************ ***************=
*
*******************

--=20
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--=20
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.

************************************************************ ***************=
*
*******************

--=20
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 unauth=
orised.

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 reli=
ance on it. If you have received this e-mail in error, please notify us imm=
ediately 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

Re: PHP & SQL Server 2005

am 26.04.2007 13:30:25 von Dan Shirah

------=_Part_42479_6308171.1177587025352
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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-lim itation-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.'
'.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
>
>

------=_Part_42479_6308171.1177587025352--