Click here to Skip to main content
15,510,484 members

Comments by Member 10558090 (Top 13 by date)

Member 10558090 12-Apr-17 5:55am View    
You're probably right. This will save me a lot of time. I changed varibile in VarChar
and use this query: INSERT INTO ProvaTimbrature (Data, Ora, Codice_Tessera, Verso, Giustificativo, Tipo_Operazione, Lettore, Cognome, Nome, Causale, Matricola_Dipendente, Campo1, Campo2, Controllo) SELECT Data, Ora, Codice_Tessera, Verso, Giustificativo, Tipo_Operazione, Lettore, Cognome, Nome, Causale, Matricola_Dipendente, Campo1, Campo2, Controllo FROM tmpProvaTimbrature WHERE tmpProvaTimbrature.Controllo NOT IN (SELECT Controllo FROM ProvaTimbrature)
Finally, it works.
Member 10558090 11-Apr-17 4:08am View    
"Record in your database the last file size and, next time, start reading from such a position"

Which statment need I to use?
Member 10558090 11-Apr-17 3:52am View    
Alternatively I could do so. Take the last record of the table based on the "Date" fields and "Hour" and start reading from there. It's possible?
Member 10558090 20-Mar-17 12:45pm View    
Code is correct because work for every sku present on website that I want to analyze. The problem is when a sku not exists into website.
I show you two links, maybe I'll explain:

WORKS: http://www.trovaprezzi.it/prezzo_desktop_x3j70et$23abz.aspx
NOT WORKS: http://www.trovaprezzi.it/prezzo_desktop_blablabla.aspx


Substantially, page exists, but not contains html tag that I search. So, DocumentNodes.SelectedNodes responde null.
Member 10558090 4-Nov-15 5:46am View    
I solved conversion problem, but price and availability didn't change.