Flokke
Last Activity: Jun 10 '11, 09:41 AM
Joined: Dec 10 '10
Location:
-
Thx. Maybe I'll try that some time. -
Thank you NeoPa.
What I think the best solution is:
I'll ask the creators of the database (I didn't create it myself because it is also used in a stand-alone app and uploaded by customer on regular bases) to create an additional field (eg ItemCD2) where the value is placed without '.' or ' '. I think that would be easy because the Replace function works in Access.
Then I could do the search on ItemCD2......Leave a comment:
-
Hello Jared
That's what I also think. adodb is standard, but dao isn't I think.Leave a comment:
-
Hello NeoPa
I got following: Server.CreateOb ject Failed
Code:set oRSonderdeel = server.CreateObject("DAO.recordset") sqltext = "SELECT * FROM tblItem WHERE replace('ItemCD',' ','') LIKE '%"& artnr & "%' ORDER BY ItemCD"Leave a comment:
-
Thank you. I will have to find a workaround I suppose.
@Jared: removing the spaces isn't an option because there are also articles with . in them; Like 123.456.789 (and I also need to be able to find them when giving in: 123456789).Leave a comment:
-
exactly Jared. I want to type in 'sdef' or 's d e f' where i can get the spaces off. but i need to have a match with ' sd ef' or other. So I thought to remove the spaces in both and it should work, but the replace in the query doesnt work. thx for your help.
FlokkeLeave a comment:
-
Using Replace in query
Hello
I'm using an Access (could be 2000 or higher. Didn't make it) database.
I have a search box on a website where visitors can search for item numbers (tblItem > ItemCD).
Everything is fine if I use
...Code:artikelnummer2 = request.form("f_zoek") artikelnummer = trim(artikelnummer2) IF artikelnummer <> "" THEN set oRSonderdeel = server.CreateObject("ADODB.recordset")
No activity results to display
Leave a comment: