Database searching

[Boobbbbbb]

Hi all - total newbie to DB programming, so bear with me....

I am using a Recordset object, and am trying to implement a search, but am
not having luck finding what I need.

I would like to enter a partial name, and seek records that contain that
string, rather than equal it. All I can find for relational operators are
=, <=, >=, >, and <.

How would I go about doing a "contains" search?

Thanks!

[Slaatje]

sql: like *blabla*

Boobbbbbb heeft geschreven in bericht ...

Hi all - total newbie to DB programming, so bear with me....

I am using a Recordset object, and am trying to implement a search, but am
not having luck finding what I need.

I would like to enter a partial name, and seek records that contain that
string, rather than equal it. All I can find for relational operators are
=, <=, >=, >, and <.

How would I go about doing a "contains" search?

Thanks!

[Lee Johnson]

"Boobbbbbb" wrote

OK... So I tried to use '*' as wildcards in this program line:
datNLA.Recordset.Seek "=", "*Boo*"
and it does not work. :( Would I have to convert this to a SQL query? If so, how? Again, I'm a total noob to doing this kind of thing in VB.

Assuming you've dim your database and necessary variables used below, then:
(replace the parts in <> with the appropriate info')

Sub SearchDatabase()
'sub to search a database and assign the results to variables.

'Make up the search term:
strSQLString = "SELECT * FROM <table> WHERE <field> LIKE '<search term /
variable>' "

'Search the database with it:
Set rs<yourRecordSetQuery> = db<yourdatabase>.OpenRecordset (strSQLQuery,
dbOpenForwardOnly)

'Assign appropriate variables using returned search results:
While Not rs<yourRecordSetQuery>.EOF

arr<YourArray>[intCount] = rsQuery![<field>]
intCount = intCount + 1

rs<YourRecordSetQuery>.MoveNext

Wend

End Sub

[Jeff North]

On Sat, 19 Jul 2003 14:39:49 GMT, in comp.lang.visual.basic
"Boobbbbbb" <ar****************@earthlink.net> wrote:

| Hi all - total newbie to DB programming, so bear with me....
|
| I am using a Recordset object, and am trying to implement a search, but am
| not having luck finding what I need.
|
| I would like to enter a partial name, and seek records that contain that
| string, rather than equal it. All I can find for relational operators are
| =, <=, >=, >, and <.
|
| How would I go about doing a "contains" search?

What database are you using?
In Access you can use
SELECT * FROM table WHERE fieldname like '*" & searchtext & "*'";

If mySQL /SQL Server use:
SELECT * FROM table WHERE fieldname like '%" & searchtext & "%'";

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------