[PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

2007-03-22 Thread Lasitha Alawatta
Hi All, I have a sql script unable to execute. Because I need to insert double-coats ( ) also to one field(SPParams field). Ones I execuit this using mysql_query($sql), it gives Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING error message. $strSql = ;

Re: [PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

2007-03-22 Thread Jean-Marc Guillermin
Hi Laitha, And with backslashes before them ?? jm - Original Message - From: Lasitha Alawatta [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Thursday, March 22, 2007 2:06 PM Subject: [PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error Hi All, I have a sql script unable to

[PHP-DB] How do I use chunks for nText fields?

2007-03-22 Thread David Balch
Hi, I've got a PHP 5 based website, talking to a MS SQL server database, using odbc_exec() and related methods. Some of the database fields are type nText, and return only part of the field value plus a pointer to the next part. My database guy pointed to a Microsoft example of how to deal with

Re: [PHP-DB] How do I use chunks for nText fields?

2007-03-22 Thread Frank M. Kromann
Keep calling odbc_resilt() untill everything is returned: $str = ; while ($tmp = odbc_result($rs, $column)) { $str .= $tmp; } You can also use odbc_longreadlen() to set the number of bytes returned by each call to odbc_result(). - Frank Hi, I've got a PHP 5 based website, talking to a

[PHP-DB] Embedded php in javascript

2007-03-22 Thread Onochie Anyanetu
Hi, I am trying to create a pop up alert warning for deleting an entry in my database. What I have is: form name=myform input type=button value=Delete Venue onClick=if(confirm('Are you sure you want to delete ID # ? echo $UID; ?? There is no undo.')) {alert('Value deleted? mysql_query(DELETE

Re: [PHP-DB] Embedded php in javascript

2007-03-22 Thread Chris
Onochie Anyanetu wrote: Hi, I am trying to create a pop up alert warning for deleting an entry in my database. What I have is: form name=myform input type=button value=Delete Venue onClick=if(confirm('Are you sure you want to delete ID # ? echo $UID; ?? There is no undo.')) {alert('Value

Re: [PHP-DB] Embedded php in javascript

2007-03-22 Thread Charles Morris
Chris is right, you also must understand that javascript runs client-side, (In the browser), and PHP is server-side (runs on the server). You can generate javascript with PHP, but hardly the other way around ;). -- Charles Morris [EMAIL PROTECTED] Network Administrator, Software