icons – Indicating that a select box has new values

The desktop version of my site has a select box (Angular Material) with a list of client names. That list gets updated (new clients added or clients have new info) and I would like to draw the user’s attention to said select box and indicate that there are new values.

On mobile we have an icon button with a drop-down list. The icon has a little orange dot when there are new items in the list.

But I am baffled at how best to handle the select box in the desktop version. I thought about adding an icon perhaps or add an orange triangle on the top right part of the select.

Could you please advise me on how best to handle this in a UX point of view?

convert sql to Laravel Query Builder ->where (level ,[select max(seq) from old_sells where id=a.id ])

i have sql query which works as expected in raw sql but not in query builder

 where  a.price = '399' and 
              b.seq=(select max(seq) from sells_2020 where pa_no=a.pa_no) 
              order by  a.pa_no

this works fine in sql but i dont have but not in Query builder
i try this ,

->where('a.price',399)
  ->where('b.seq','=',DB::raw('select max(seq) from sells_2020 where pa_no=a.pa_no'))
               ->OrderBy('a.pa_no')

So how can i convert this to query builder ?

unity – I can’t select my local package in Asset Store Tools

I made a local package and I’m trying to upload it to the AssetStore.
-My package is stored in the [root]/Packages folder.
-My Demo scene is stored in the [root]/Assets folder.

When I try to upload my package in the Asset Store Tools, I’ve an error if I select my sources in the Packages folder.
If i select my Demo scene folder instead, I have no error. But I don’t want to upload only my Demo scene.
If I check ‘include dependecies’ it only add a json manifest file.

The error message is : The path selected must be inside the currently active project.

All answers about this error on google didn’t helped me.
-Set the package as a Full project => I made a tool not a full project.
-The Project have to be in C: Hard drive => it is.
-The Project folder must have the package’s name => it is. My project folder’s name PropertyInterface as my asset.

I’m using Unity 2019.1.0f2.

It’s the first time i try to upload my work in the Asset store. I’m pretty confused.

Thanks for your help.

mysql cursor not fetching data from select query inside stored procedure

I have written the following procedure but the the cursor is not displaying or inserting any data. I have ran the select query separately and it returns data properly.

I tried checking other solutions on stack overflow and dba stack exchange but the solutions are not fixing the issue.

The most close answer found was This

As advise in the answers in the above mentioned links I renamed all the variables with _ in varibalename but still it cursor doesn’t display or insert data

Any help would be appriciated.

DELIMITER $$

CREATE PROCEDURE getUniquePartnerIds()
BEGIN

DECLARE temp_partnerId INTEGER DEFAULT 0;
DECLARE is_finished INTEGER DEFAULT 0;

DECLARE cursor_Partnerid CURSOR FOR 
SELECT DISTINCT(partnerId) FROM multiplepartners WHERE partnerId NOT IN (SELECT partnerId FROM partner_language);

DECLARE CONTINUE HANDLER FOR NOT FOUND SET is_finished = 1;
        
OPEN cursor_Partnerid;
        
get_PartnerId: LOOP
FETCH cursor_Partnerid INTO temp_partnerId;
SELECT temp_partnerId;
IF is_finished = 1 THEN LEAVE get_PartnerId;
END IF;     
        
-- INSERT INTO `partner_language`(`partnerid`)
-- VALUES (temp_partnerId);     
END LOOP get_PartnerId;
CLOSE cursor_Partnerid;
    
END$$

DELIMITER ;

select – Duvida sobre SQL

Boa tarde pessoal, estou aprendendo SQL e tenho que fazer um exercicio que é:
Selecionar o nome e sobrenome dos empregados e consultores que trabalham no departamento “Financeiro”.

Acontece que eu estou tentando usar essa query

SELECT nmemp, snemp, nmconsult FROM emp, consult 
WHERE consult.coddepto = emp.coddepto AND
emp.coddepto in(Select coddepto from depto where nmdepto = 'financeiro')

Tentei usar join tambem mas não adiantou

SELECT nmemp, snemp,nmconsult FROM emp 
LEFT JOIN consult ON consult.coddepto = emp.coddepto 
LEFT JOIN depto ON  nmdepto = 'financeiro' AND consult.coddepto = depto.coddepto 

O resultado esta dando errado como na imagem abaixo, gostaria de saber o que estou errando,
pois não estou conseguindo encontrar meu erro

inserir a descrição da imagem aqui

Abaixo segue as imagens com os nomes das tabelas que precisam ser usadas

Nome da tabela = consult
https://i.stack.imgur.com/rNnI4.png

Nome da tabela = depto
https://i.stack.imgur.com/8tna7.png

Nome da tabela = emp
https://i.stack.imgur.com/oCnf6.png

html – Select multiple, insertar varios datos en un solo campo (Postgresql php) 1 a N

Lo que sucede es que yo le pongo la información de la tabla cursos a el select múltiple,ahora lo que quiero hacer es que los cursos que se seleccionen se inserten en la tabla de los estudiantes, es decir, que es una relación de 1 a N

Estas son las dos tablas que tengo.

CREATE TABLE Cursos (
cod_cur varchar(6),
nomb_cur varchar(30),
cod_doc varchar(10));
ALTER TABLE Cursos ADD CONSTRAINT rk_cursos PRIMARY KEY(cod_cur);
CREATE TABLE Estudiantes (
cod_est varchar(10),
nomb_est varchar(30),
telefono varchar(10),
email varchar(50),
cod_programa varchar(10),
cod_cur varchar(10));
ALTER TABLE Estudiantes ADD CONSTRAINT ek_estudiantes PRIMARY KEY(cod_est);
ALTER TABLE Estudiantes ADD CONSTRAINT PERTENECE FOREIGN KEY (cod_programa) REFERENCES 
Programas(cod_programa) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE Estudiantes ADD CONSTRAINT PERTENECE FOREIGN KEY (cod_cur) REFERENCES 
Programas(cod_cur) ON DELETE NO ACTION ON UPDATE NO ACTION;`

Aquí esta el código en donde inserto los datos,lo que me esta insertado es la palabra “array” en la columna cod_cur en la tabla docentes,no entiendo muy bien porque sucede esto.

<?php
include("conexion.php");
$con=conectar();


$cod_est=$_POST('cod_est');
$nomb_est=$_POST('nomb_est');
$telefono=$_POST('telefono');
$email=$_POST('email');
$cod_programa=$_POST('cod_programa');
$cod_cur=$_POST('cod_cur');
print_r ($cod_cur);

if ($cod_programa=="Seleccione el programa...") {
    $cod_programa="na";
} else{
$i=0;
$cod_programa_aux="";
while ($cod_programa($i)!=" ") {
$cod_programa_aux.=$cod_programa($i);
$i++;
}
$cod_programa=$cod_programa_aux;
}

$query="SELECT insertar_estudiante('$cod_est','$nomb_est','$telefono','$email','$cod_programa','$cod_cur');";
$ejecutar=pg_query($con,$query);

if(!$ejecutar){
    echo"Error";
}else{
    if ($cod_programa=="na") {
            header("Status: 301 Moved Permanently");
            header("Location: /ProyectoNOTAS/registrar_estudiante.php");        }
            else {
                header("Status: 301 Moved Permanently");
                header("Location: /ProyectoNOTAS/info_estudiante.php");}
}

?>

Y este es el select multiple en donde estan los cursos de los cuales se seleccionan algunos para asignarlos al estudiante

  <?php
          $query2 = 'select cod_cur, nomb_cur from cursos order by cod_cur asc';
          $resultado = pg_query($con, $query2) or die("Error en la consulta sql");
          $numReg = pg_num_rows($resultado);
          if ($numReg > 0) {
          ?>
          <select id="ms" multiple="multiple" class="control" width="80" type="cod_cur" name="cod_cur()" >
          <?php
            while ($fila = pg_fetch_array($resultado)) {
              ?>
            <option><?php echo $fila('cod_cur'), " - ", $fila('nomb_cur') ?> </option>;
          <?php
            }
            ?>
          </select>
          <br>
          <?php
          } else {
          ?>
          <h1 align="center"> <?php echo "No hay registros"; ?> </h1>
          <?php
          }
          pg_close($con);
          ?>
          <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
          <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.0/umd/popper.min.js" integrity="sha384-cs/chFZiN24E4KMATLdqdvsezGxaGsi4hLGOzlXwp5UZB1LY//20VyM2taTB4QvJ" crossorigin="anonymous"></script>
          <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.0/js/bootstrap.min.js" integrity="sha384-uefMccjFJAIv6A+rW+L4AHf99KvxDjWSu1z9VI8SKNVmz4sk7buKt/6v9KI65qnm" crossorigin="anonymous"></script>
          <script src="CSS/multiple-select.js"></script>
          <script>
          $(function() {
          $('#ms').change(function() {
              console.log($(this).val());
          }).multipleSelect({
              width: '100%'
          });
          });
          </script>

How to select part of the text of a link in Safari 14.0 on macOS 10.15.7

I asked a very similar question before: Select and copy part of the text from a link in Safari

How can I copy only a section of text from a hyper link? For example in google results:

enter image description here

How can I copy “Inosuke Hashibira” from that link?

Previously, the only solution was to use a custom extension or userscript.

Now two years have passed, and I can’t figure out how to add custom extensions anymore. I also don’t really want to go through all the trouble of installing a userscript manager just for this, especially since Safari’s not very friendly to extension developers and often breaks them every update, and (probably because of this) developers don’t seem to care for supporting Safari.

How can I select part of a link in Safari nowadays?

mysql 5.7 – Can you use a SELECT … FOR UPDATE cursor in a stored procedure to enforce row-level locking?

From https://www.oreilly.com/library/view/mysql-stored-procedure/0596100892/re37.html:

    CREATE PROCEDURE needy_bonus(  )
    BEGIN
      DECLARE  v_employee_id INT;
      DECLARE  v_salary      NUMERIC(8,2);
      DECLARE  v_last_emp    INT DEFAULT 0;

      DECLARE emp_csr CURSOR FOR
       SELECT employee_id,salary
         FROM employees
        WHERE salary <45000
          FOR UPDATE;

      DECLARE CONTINUE HANDLER FOR NOT FOUND SET  v_last_emp=1;

      START TRANSACTION;
        OPEN emp_csr;
        emp_loop:LOOP
          FETCH emp_csr INTO  v_employee_id, v_salary;
          IF  v_last_emp THEN
            LEAVE emp_loop;
          END IF;
          CALL grant_raise( v_employee_id, v_salary);
        END LOOP emp_loop;
        CLOSE emp_csr;
        SET  v_last_emp=0;

      COMMIT;

    END;

Does this method really work for row-level update locking in a stored procedure? I ask because I’m doing this myself and I’m getting some consistency issues. Is it possible I need to set the transaction isolation mode to REPEATABLE READ? I’m currently using READ COMMITTED.