Database Insert problem

**(6)** · 10-17-2004, 05:56 PM

When i insert filenames of mp3's using VB6 into an access databse that have a file name like ..

What's
or
a&e

i get an error

I understand that its the characters ( ' & that are causing me greif but i am unable to find a solution to my problem. I hope someone can help me out. I will still be searching the forums and search engines for a soulution until someone can help.

Thanks in advance..

**Grayscale** · 10-17-2004, 06:13 PM

Uhh can you post a snippet of your code? It's obviously a parse error.

**hijinks21** · 10-17-2004, 06:48 PM

i dunno about with that.. but in mysql you single quote it like

insert into table(col1, col2) values('bla $& bla', ' what's up?')

**(6)** · 10-17-2004, 06:59 PM

Originally Posted by hijinks21

i dunno about with that.. but in mysql you single quote it like

insert into table(col1, col2) values('bla $& bla', ' what's up?')

Im entering info from a variable so if i single quote a variable called 'file'
Its going to just enter the word file.
I tried using a replace function to replace the ' or & smbol with a quuote around it but that did work .