May 19, 200421 yr Newbies We have a simple products database. We do a lot of searches by product name. Here is an example. Name: Panasonic AYDVM83MQ If I do a search for " 83MQ " I get an error stating "No records match this request" This happens for all sorts of searches. It will find it if i search for "AYDVM83MQ" but no one is going to remember that much of the name. Is this a fault in the database? It seems that it should find it. Any help would be great. thank you.
May 19, 200421 yr Hollister: Welcome to the Forums. You need to insert wildcards into your searches. If you search for "*83MQ*" it will find what you're looking for. You can script your find so that the stars are added to what the user enters, or you can just let the user know about the syntax. -Stanley
May 19, 200421 yr Author Newbies DOH! my goodness. why did I not think of that. I so much associate * with the command line. OMG! thank you very much.
Create an account or sign in to comment