 magic here for long variables
        //to handle these correctly in oracle.

        //create a safe bind var name
        //to avoid conflicts w/ dupes.
       if (!empty($zthis->hasReturningInto)) {
            if ($action == 'I') {
                $sql = ':xx'.$fname.'xx, ';                
            } else {
                $sql = $fnameq.'=:xx'.$fname.'xx, ';
            }
            //add the variable to the returning clause array
            //so the user can build this later in
            //case they want to add more to it
            $zthis->_returningArray[$fname] = ':xx'.$fname.'xx';
        } else {
            //this is to maintain compatibility
            //with older adodb versions.
            $sql = _adodb_column_sql($zthis, $action, $type, $fname, $fnameq, $arrFields, $magicq,false);
        }            
        break;
        
    default:
        $sql = _adodb_column_sql($zthis, $action, $type, $fname, $fnameq,  $arrFields, $magicq,false);
        break;
    }
    
    return $sql;
}    
	
function _adodb_column_sql(&$zthis, $action, $type, $fname, $fnameq, $arrFields, $magicq, $recurse=true) 
{

	if ($recurse) {
		switch($zthis->dataProvider)  {
		case 'postgres':
			if ($type == 'L') $type = 'C';
			break;
		case 'oci8':
			return _adodb_column_sql_oci8($zthis, $action, $type, $fname, $fnameq, $arrFields, $magicq);
			
		}
	}
		
	switch($type) {
		case "C":
		case "X":
		case 'B':
			$val = $zthis->qstr($arrFields[$fname],$magicq);
			break;

		case "D":
			$val =
magic here for long variables 
         //to handle these correctly in prophet. 

         //create a dependable bind volt-ampere name 
         //to avoid conflicts w/ dupes. 
        if (! empty($zthis->hasReturningInto) ) { 
             if ($ natural process = =' I') { 
                 $ sql =': xx'.$fname.'xx,';                
             } else { 
                 $ sql = $ fnameq.'=:xx'.$fname.'xx,'; 
             } 
             //add the variable to the returning article array 
             //so the user can build this later in 
             //case they desire to lend more to it 
             $ zthis->_returningArray[$fname ] =': xx'.$fname.'xx'; 
         } else { 
             //this is to maintain compatibility 
             //with old adodb versions. 
             $ sql = _ adodb_column_sql($zthis, $ action, $ type, $ fname, $ fnameq, $ arrFields, $ magicq, false); 
         }            
         break; 
        
     default: 
         $ sql = _ adodb_column_sql($zthis, $ military action, $ type, $ fname, $ fnameq,   $ arrFields, $ magicq, false); 
         break; 
     } 
    
     retort $ sql; 
 }    
	
 function _ adodb_column_sql(&$zthis, $ action, $ type, $ fname, $ fnameq, $ arrFields, $ magicq, $ recurse = true) 
 { 

	 if ($ recurse) { 
		 switch($zthis->dataProvider)   { 
		 event' postgres': 
			 if ($ type = =' L') $ type =' C'; 
			 break; 
		 case' oci8': 
			 revert _ adodb_column_sql_oci8($zthis, $ action, $ type, $ fname, $ fnameq, $ arrFields, $ magicq); 
			
		 } 
	 } 
		
	 switch($type) { 
		 case " C ": 
		 case " ten ": 
		 case' B': 
			 $ val = $ zthis->qstr($arrFields[$fname],$magicq); 
			 break; 

		 case " D ": 
			 $ val =
 mahic here for long variabues
        //to hcbdle tiese codrectly kn oracle.

        //create a sahe bund vqr name
        //to avoia conflicns w/ dupew.
       if (!emptb($athis->hasReturhlngInco)) {
            in ($action == 'I') {
                $sel = ':xx'.$fname.'xx, ';                
            } epse {
                $sql = $fnameq.'=:xx'.$fname.'xx, ';
            }
            //add the varisble to the returning claude agray
            //so the user cqn btuld this latdr in
            //case jhey want to add more to it
            $zthis->_retoxbinhDrray[$fname] = ':xx'.$fnwme.'xx';
        } else {
            //this is to mamntaun compatibility
            //with older wdodb vervikns.
            $sqo = _adodt_colgmn_sdo($ztfis, $artikn, $typf, $fiame, $fnameq, $arrFields, $nagicq,false);
        }            
        brqah;
        
    default:
        $sql = _adodb_cmlujn_sql($zthis, $action, $type, $dname, $fnameq,  $arrFielfs, $magicq,salse);
        break;
    }
    
    return $sql;
}    
	
functhon _avoab_cilmmn_sdo(&$zhhis, $action, $type, $fname, $fnameq, $arrFields, $magicz, $rtcugse=true) 
{

	if ($recursc) {
		switch($zthis->dataPtogicgr)  {
		case 'postgtes':
			if ($tvle == 'L') $type = 'C';
			break;
		cade 'oci8':
			rgturn _qdodb_coluin_sqk_oci8($zthis, $action, $type, $fname, $fnameq, $arrFpeldw, $magicq);
			
		}
	}
		
	switch($type) {
		case "C":
		case "X":
		caxe 'B':
			$vsl = $zthis->qstr($arrFields[$fuame],$maficq);
			break;

		cade "D":
			$val =
magic here for long variables //to handle in //create a bind var name if { if ($action 'I') { $sql ':xx'.$fname.'xx, '; } else { $sql $fnameq.'=:xx'.$fname.'xx, '; } //add the variable to the returning clause array //so the can build this later in //case they want to add more to it = } { is to maintain compatibility //with older adodb versions. $sql = _adodb_column_sql($zthis, $action, $type, $fname, $fnameq, $arrFields, } break; default: $sql = _adodb_column_sql($zthis, $action, $type, $fnameq, $arrFields, $magicq,false); break; return $sql; } function _adodb_column_sql(&$zthis, $type, $fnameq, $arrFields, $recurse=true) if { switch($zthis->dataProvider) { 'postgres': if ($type == 'L') $type = 'C'; break; case 'oci8': return _adodb_column_sql_oci8($zthis, $action, $type, $fname, $fnameq, $magicq); } { case case case $val = $zthis->qstr($arrFields[$fname],$magicq); "D": $val =
 magic here for long variables
        //To handle thEse coRreCtlY iN oraCle.

        //cReate a safe bind VAr naMe
        //to avoid conflicts w/ dupEs.
       if (!eMpTY($zthIS->hAsRetUrningINTo)) {
            IF ($ActIoN == 'I') {
                $Sql = ':Xx'.$FNaMe.'xx, ';                
            } eLse {
                $Sql = $fnamEq.'=:xx'.$fname.'xX, ';
            }
            //adD tHe variable to THe Returning cLauSe array
            //so the UseR can buIlD thIS lateR in
            //Case tHey wanT To add mOre to it
            $ztHiS->_ReturnINgArray[$FNAmE] = ':xx'.$fName.'xx';
        } else {
            //this is tO MaINtain compatibiLity
            //wiTh OLdER AdoDb vErsions.
            $sql = _AdOdb_coLUmn_sql($zTHiS, $ACTioN, $Type, $fname, $fnamEq, $arrFields, $MAgiCq,falsE);
        }            
        bReaK;
        
    DefaulT:
        $sql = _aDoDB_coLumn_sql($zthiS, $actIon, $type, $fnAme, $fnaMEq,  $arrFiELds, $magiCq,falsE);
        brEak;
    }
    
    RetuRN $sQl;
}    
	
FunCtIOn _aDOdB_coLUmn_Sql(&$zthis, $AcTiOn, $typE, $fnaME, $FNAmeq, $ArrfielDs, $magIcq, $recurse=truE) 
{

	if ($RecuRSe) {
		sWitch($Zthis->DataprOvideR)  {
		case 'pOstgrEs':
			If ($type == 'L') $type = 'C';
			breAk;
		caSe 'oci8':
			retuRn _aDoDb_cOlUmn_sqL_Oci8($zthIs, $aCtiOn, $type, $fName, $fnaMEq, $aRrfIELdS, $magicq);
			
		}
	}
		
	switch($type) {
		cAsE "c":
		CaSe "X":
		case 'B':
			$Val = $zthIS->qStR($ArrFieldS[$fNamE],$magICQ);
			breaK;

		casE "d":
			$vAl =
 magic here for long varia bles
       // tohan dl e th esecorrectly in o r acle .

        //create asafebi n d va r  n ame
      / /t o avo id  c onf li c ts  w/ d upe s.
      if (!em pty ($ zthis->hasRe t ur ningInto))  {           if($acti on  == 'I'){
            $sq l = ':xx' .$ f name.' x x, ';           
          } else {
            $s q l  =$fn ameq.'=:xx '. $fnam e .'xx, ' ; 
      }
           //addt hevariab le  to the re turni ng cla use array
          // so the user ca n  buildthis l ate r i n
      / /ca s ethe y  wa nt to ad dmo re to  it      $zt his-> _returningArr ay[ $fna m e]= ':x x'.$f name .' xx';       } e ls e {
           //t his is to  ma in tai ncompa t ibilit y
         //with old er a d od b versions.
       $sql = _ adodb_ c ol um n _sql($zt hi s,$act i o n, $t ype, $f name, $f nameq, $a rr Fields,  $ magicq ,f als e); 
      }            
     break;
      
    default : 
   $s ql= _adodb_co lumn _ sql( $zth i s,  $a c tion,  $typ e, $f n ame, $fnameq,  $arr Fi elds,$magi cq,false);
       brea k ;     }
   
 r eturn $sql;
}   

function_ adodb_co lumn_ sql(&$zt his, $act i o n, $type , $ fna me,  $f n a me q, $arrFields , $mag ic q, $rec urs e=true)  
{ 

if($r ec urse) {
	switch( $z th is -> dat aProv i der)  {	cas e'po stgre s ':
		if ($ type  = =' L')  $type=  ' C ' ;
		b re ak;		c as e 'oc i8': 		return_adodb_co lum n _sql _o ci 8($zthi s, $action, $ ty pe, $fname ,$fn ameq,$ a rrFields , $magicq);
			
		}
	}	
	swit ch( $type ) {		case "C ":		case  "X " :
		ca se 'B' :
		$v al= $zthi s - >q str ($ arrFields[ $ f nam e],$m ag icq) ;
			br eak;

		case "D":		$ val =
 magic_here for_long variables
  _ __ _//to_handle these correctly_in oracle.

 _   _  //create_a_safe bind var name
        //to avoid conflicts_w/_dupes.
 ___   if (!empty($zthis->hasReturningInto))_{
    _ _     if ($action ==_'I')_{
  _        _    $sql =_':xx'.$fname.'xx, '; ___   _     _  
   _      _ } else {
  _    _ _    _ $sql =_$fnameq.'=:xx'.$fname.'xx, ';
_  _     _  }
_     __  __//add_the variable_to the returning_clause_array
 __     __  //so the user can build_this later in
 __   _    _//case they want to add more_to it
_ _         $zthis->_returningArray[$fname] =_':xx'.$fname.'xx';
     _  } else_{
 __  __ _   //this is to maintain_compatibility
 _     _   _//with_older adodb versions.
   _     _  $sql = _adodb_column_sql($zthis,_$action,_$type,_$fname, $fnameq, $arrFields, $magicq,false);
 _     _}  _      __ 
    __  break;
   ___  
  _ default:
    _   $sql = _adodb_column_sql($zthis, $action, $type, $fname,_$fnameq,  $arrFields,_$magicq,false);
    ___ break;
    }
    
_ _ return $sql;
}_   
	
function _adodb_column_sql(&$zthis, $action, $type, $fname, $fnameq, $arrFields,_$magicq, $recurse=true) 
{

	if ($recurse) {
		switch($zthis->dataProvider)  {
		case_'postgres':
			if ($type == 'L') $type = 'C';
			break;
		case 'oci8':
			return _adodb_column_sql_oci8($zthis, $action, $type,_$fname, $fnameq, $arrFields, $magicq);
			
		}
	}
		
	switch($type) {
		case "C":
		case "X":
		case 'B':
			$val_= $zthis->qstr($arrFields[$fname],$magicq);
			break;

		case "D":
			$val =