0

Hi GUys

Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable:

e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my SQL query i want whatever has been entered to be pattern matched to the data stored in the database, would the query possibale be something like this:

SELECT functionme FROM MsgeTble WHERE alternme LIKE "*$srch*"

Im pretty novice in databases :confused:

Please any suggestions would be grateful! Thanks

6
Contributors
6
Replies
13
Views
12 Years
Discussion Span
Last Post by ChrisPadgham
0

Hi GUys

Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable:

e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my SQL query i want whatever has been entered to be pattern matched to the data stored in the database, would the query possibale be something like this:

SELECT functionme FROM MsgeTble WHERE alternme LIKE "*$srch*"

Im pretty novice in databases :confused:

Please any suggestions would be grateful! Thanks

HI...

There is 2 ways.
i) u can write in the Qurey
just u have to enter in the last field like this : [Enter the Name]
and in Criteria: u have the write the filed name
like:
[Enter the Name]
Field Name

ii) u can write in the code
set db = currentdb
set rec = db.oprecordset("Select * from MsgeTble WHERE ename = " & text1.value & "")

if not(rec.bof and rec.eof) then
rec.movefirst
while not rec.eof
text1.value = rec.field("aaa")
rec.movenext
wend
end if


*********************

kindly try this if not work than reply me...

Bye...
Rupesh

0

select statement
select * from table_name where column_name='&column_name';

for insert
insert into table_name values ('&column_name1','&column_name2');

0

Here is a piece of code that does something similar to what you want I thnk.

Dim WhereClause As String
Dim AndStr As String

AndStr = ""
If Me.SearchName <> "" Then
    WhereClause = "(FirstName like '*" & Me.SearchName & "*' OR Surname like '*" & Me.SearchName & "*')"
    AndStr = " AND "
End If
If Me.SearchSuburb <> "" Then
    WhereClause = WhereClause & AndStr & "Suburb like '*" & Me.SearchSuburb & "*'"
    AndStr = " AND "
End If
If Me.SearchCompany <> "" Then
    WhereClause = WhereClause & AndStr & "CompanyName like '*" & Me.SearchCompany & "*'"
    AndStr = " AND "
End If

If Me.searchRep <> "" Then
    WhereClause = WhereClause & AndStr & "Rep='" & Me.searchRep & "'"
        AndStr = " AND "
End If

If Me.SearchStatus <> "" Then
    WhereClause = WhereClause & AndStr & "Status='" & Me.SearchStatus & "'"
    AndStr = " AND "
End If
PerformSearch:
Me.Filter = WhereClause
Me.FilterOn = True

Edited by ChrisPadgham: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.