error in search query [RESOLVED]

[kulitag]

i have data in different tables, then i want to query them by calling their product name, everything seem going well until i have a data with an apostrophe in it's name.

[dglienna]

Can you substitute two apostrophes instead?

[kulitag]

no can do sir coz the system is for the use of other user. the just encode the products. it's for my inventory system.

[pnish]

I think what dglienna means is that you do something like this:

Dim sql As String
Dim PName As String
PName = "Woka'[color=black]s Widget"[/color]
 
sql = "Select [blah] From [Inventory] "
sql = sql & "Where [Product Name] = '" & Replace$(PName, "'", "''") & "'"

The Replace$() function is searching the product name for a single apostrophe " ' ", and replacing it with two apostrophes, " ' ' " (I've expanded these to make it easier to see what's going on). Your query should then work OK with names containing apostrophes.

[kulitag]

will it work if i search a record with no apostrophe?

[pnish]

Yes. No problem.

[dglienna]

Thanks. I was suggesting the same thing. You explained it well.

[kulitag]

ei guys thanx for the time. i really appreciate it. GOD BLESS