ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:ifnull

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
reference:ifnull [2015/07/20 13:53] – [Usage] mnewnhamreference:ifnull [2015/11/22 03:51] – [Usage] mnewnham
Line 21: Line 21:
  
 /* /*
- * ifnullString returns 'CASE WHEN pants_field is null THEN 'chinos' ELSE pants_field END ";+ * ifnullString returns 'CASE WHEN pants_field is null  
 +                              THEN 'chinos'  
 +                              ELSE pants_field  
 +                              END ";
 */ */
  
-$SQL = "UPDATE attire SET pants_field = $ifNullString";+$SQL = "UPDATE attire  
 +           SET pants_field = $ifNullString";
  
 $db->Execute($SQL); $db->Execute($SQL);
 </code> </code>
v5/reference/connection/ifnull.txt · Last modified: 2016/01/16 23:34 by mnewnham