[PHP] Warning: Sybase message: Incorrect syntax near 't'.
Hi am trying to add data from html form, and it seems like the line 14 in
my script,
$sybase_query=INSERT into problem
VALUES('$product','$pro_title','$description','$solution');
$sybase_result=sybase_query($sybase_query);
Warning: Sybase message: Incorrect syntax near 't'. (severity 15) in
/var/www/html/process.php on line 14
Warning: Sybase message: Unclosed quote before the character string ')'.
(severity 15) in /var/www/html/process.php on line 14
when trying to insert the following data
Product :Test Director
Problem Title : Doesn\'t work
Description: I dont knw why
Solution : dondd
Caleb Carvalho
Application Engineer
LoadRunner/APM
-
Enterprise Testing and Performance Management Solutions
-
Mercury Interactive
410 Frimley Business Park
Frimley, Surrey. GU16 7ST
United Kingdom
Telephone : +44 (0)1276 808300
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
PHP General 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] Warning: Sybase message: Incorrect syntax near 't'.
-Original Message-
From: Caleb Carvalho [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 4:04 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Warning: Sybase message: Incorrect syntax near 't'.
Hi am trying to add data from html form, and it seems like
the line 14 in my script,
$sybase_query=INSERT into problem
VALUES('$product','$pro_title','$description','$solution');
$sybase_result=sybase_query($sybase_query);
Warning: Sybase message: Incorrect syntax near 't'. (severity 15) in
/var/www/html/process.php on line 14
Problem Title : Doesn\'t work
If I'm remembering right, Sybase would prefer to see this as
Problem Title : Doesn''t work
(That is, a single-quote within a string that you're passing off to
Sybase should be escaped by another single-quote, not by a slash.)
---
Mark Roedel | Blessed is he who has learned to laugh
Systems Programmer| at himself, for he shall never cease
LeTourneau University | to be entertained.
Longview, Texas, USA | -- John Powell
--
PHP General 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] Warning: Sybase message: Incorrect syntax near 't'.
Hi,
I suggest to you:
var_dump($sybase_query);
It may help you to make wellformed query-string.
- Original Message -
From: Caleb Carvalho [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 01, 2001 11:04 AM
Subject: [PHP] Warning: Sybase message: Incorrect syntax near 't'.
Hi am trying to add data from html form, and it seems like the line 14 in
my script,
$sybase_query=INSERT into problem
VALUES('$product','$pro_title','$description','$solution');
$sybase_result=sybase_query($sybase_query);
Warning: Sybase message: Incorrect syntax near 't'. (severity 15) in
/var/www/html/process.php on line 14
Warning: Sybase message: Unclosed quote before the character string ')'.
(severity 15) in /var/www/html/process.php on line 14
when trying to insert the following data
Product :Test Director
Problem Title : Doesn\'t work
Description: I dont knw why
Solution : dondd
Caleb Carvalho
Application Engineer
LoadRunner/APM
--
---
Enterprise Testing and Performance Management Solutions
--
---
Mercury Interactive
410 Frimley Business Park
Frimley, Surrey. GU16 7ST
United Kingdom
Telephone : +44 (0)1276 808300
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
PHP General 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 General 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]
