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.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?
Can someone here please shed some light on this?
- The device is Secugen's Hamster IV
- I have their SDK and I'm using it.
- I'm on VB.NET + mysql
- I can save the fingerprint to the table, and I'm sure its there.
Thanks and long live Daniweb!