Posts by Guilherme Vahldick • 86 points

• 1

  votes

  1

  answer

  97

  views

  Q: Problem with Adodb’s Insert_id function

  In my code I perform two insertions using the Adodb 5 library, with the Mysql driver for PHP. But at certain times occurs the function Insert_ID() return an id (primary key) of a Insert previous to…

  php database

  asked 10 years, 3 months ago Guilherme Vahldick 86

• 6

  votes

  2

  answers

  1593

  views

  A: Checking empty column with CASE in Mysql

  You can use the COALESCE function for this. SELECT COALESCE(NULLIF(nomeCli,''), nomeFantasiaCli) FROM cliente

  mysql

  answered 10 years, 10 months ago Guilherme Vahldick 86