Just recently, I was able to integrate a Fingerprint device to my application. Can now scan fingerprints and save them to database using the INSERT TO syntax.
But I can't get my application to match scanned fingerprint to one already stored in the database, so that I could use fingerprint verification instead of the traditional ID Searching. How it now works: - After scanning the the fingerprint, the image is stored as fp_image of type byte() - a normal INSERT TO code inserts the fp_image to the mysql table. - in the mysql table, the image is stored in column 'fin_pr' of data type LONGBLOB.
What I tried:
Since a normal INSERT TO did the saving to the database, I assumed that, after scanning the fingerprint from the user, I could then use the normal SELECT FROM syntax to compare the scanned fingerprint and match it to the one that is already in the table. So I did this code:
SqlRetrieve = "SELECT * FROM demographic WHERE fin_pr = @finger" cmd.Parameters.AddWithValue("@finger", fp_image) cmd.Connection = con cmd.CommandText = SqlRetrieve
But this does not return any rows, (meaning like, the fingerprint is not found) while I know there is such a fingerprint in the table. Seems like I need to do more?
