in reply to Update Sqlite References

You don't need VALUES in the latter case of UPDATE.

Try something like: 

$dbh->do('UPDATE Data SET Tag1=?, Tag2=? WHERE ID=$ID_read', 
         undef,
         standardize($Tag1), standardize($Tag2)
);

[download]
But consider using a placeholder for the WHERE clause also, and pass $ID_read as a bind variable. Edit: I see you found that was the problem, cool!

Hope this helps!


The way forward always starts with a minimal test.

Replies are listed 'Best First'.
Re^2: Update Sqlite References
by kennethk (Abbot) on Jan 05, 2017 at 20:24 UTC
    As an add on, the tutorials on SQL on w3schools (see http://www.w3schools.com/sql/sql_update.asp) may be helpful in getting up to speed. Note that it's got a platform bias built in so much of their CSS/Javascript isn't portable, but it's good for introduction.

    #11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.

[reply]

In Section Seekers of Perl Wisdom