How to design a pattern serach in MS Access database from FrontPag

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

?How to design a pattern search in MS Access database from FrontPage? I have
custom SQL code :
Select * from My_database where "check" like '*::check::*'
This does not work.

Select * from My_database where "check" = '::check::'
This work.

So, I know all the database connection or select statement works fine.
Can export tell me how to make a 'pattern search' work with MS Access
database through FrontPage?

Thanks!
 
Try:

Select * from My_database where check LIKE '%" & check & "%' "


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thank you, and I'll try it on Monday.

Thomas A. Rowe said:
Try:

Select * from My_database where check LIKE '%" & check & "%' "


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
Click to expand...
 
Sorry, I wasn't able to access the web to respone. This does not work. It
did not find any record from the database.

I was using :
Select * from myDatabase where "chk name" Like '%" & "Chk name" & "%'
Also
Select * from myDatabase where "chk name" LIKE '%" & ''chk name'' & "%'
Also
Select * from myDatabase where "chk name" LIKE '%" & ''::chk name'' & "%'

None of them work. Just another question, does it matter that if there is a
" " between the "chk name" and the second '&'. I also using two ' when I use
::chk name::

Thanks for your help!
 
You didn't follow my example, and field names can not have spaces

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Back
Top