vb.net - Use of colon (not bind) in SQL select query -

vb.net - Use of colon (not bind) in SQL select query -

language: vb.net database: sqlite ide: visual studio 2012

i'm parsing folder , placing file name - finish path in table.

i'm getting next error visual studio debugger:

cannot interpret token ':' @ position 14.

the line of code is:

rowsfound = me.select("filename = """ + fi.fullname + """")

which evaluates to:

rowsfound = me.select("filename = "g:\dropbox\virtualdj\tracklisting\2008-02-02 11th birthday.m3u"")

position 14 location of drive letter delimiter in path.

while not primary key, i'm using total path/file name unique identifier , when rescanning files, checking see if file exists before adding new datarow.

i've had no problem prototyping in access 2010, needed move vb.net can't id3 library work vba. however, not beingness able passed basic lookup stuff bit of showstopper.

any help appreciated.

cheers,

roy

try surrounding path single quotes :

me.select("filename = '" + fi.fullname + "'")

from comment mentioned apostrophe beingness part of filename, need escape :

me.select("filename = '" + fi.fullname.replace("'","''") + "'")

vb.net sqlite datatable