| 
 Posted by Adi Zebic on 08/02/05 03:27 
Jack Scott a écrit : 
> Try this: 
> $insertQuery = "Insert into TABLE  
> 		( 
> 			col_one, 
> 			col_two 
> 		)values ( 
> 			'" . $this -> firstName . "', 
> 			'" . $this-> lastName . "' 
> 		)"; 
> $db =& new DB; 
> $res = $db->query($insertQuery); 
> if(DB::isError($res)){ 
>     exit("Insert query failed: ".__FUNCTION__."() <br>in file 
> ".__FILE__."<br>on line ".__LINE__."<br>".$res->getDebugInfo()); 
> }else{ 
>     return; 
> } 
>  
> you need to have quotes arround your varchar items and you should also 
> specify which column you want the values to go into. 
 
Yess! That's the right one :-) 
 
> It is also good practice to check if there is an error and try to get 
> the most information available. 
 
"DB" class do the right thing with try/catch. 
 
THANK YOU VERY VERY MUCH Jack Scott! 
 
ADI
 
  
Navigation:
[Reply to this message] 
 |