Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

How Do I: Create a Search Form?

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
50,744
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 22, 2009

How Do I: Create a Search Form?

Link to this comment:

Share to:

Top Comments

  • @TheFlop123456 Dude it did that to me too,but guess what in the LIKE section you have to put a space like this LIKE @tablename +'%' instead of just putting the LIKE and the @ together like this LIKE@<-----that one is a no no.Stupid sintax i research that the whole day....

  • Great! Thanks!

see all

All Comments (39)

Sign In or Sign Up now to post a comment!
  • This is great except I want to look up just one number from a database and do a calculation on it. How can I do it without using the query builder? All I want to do is have a user enter the number of miles and then look up the price that corresponds to (less than or equal to) a number of miles in the database.

  • @egymke0 problem solved..thanks~~

  • Adding a powerful custom search engine to your website truly enhances the user experience. We've made it very easy to implement on your website by removing all the hassles of development, maintenance, and hardware requirements. Visit getwebsitesearch(dot)com for more info.

  • Is there anyway to create a query to search more than one column? for ex. search last name, first name and address? thanks

  • @elmo89

    Easy to use ? not name of value when use access so

    "WHERE [filed name] LIKE '%' + ? + '%' so you can get asking about what '?'.

  • @egymke0 i am having the same problem as u..how u solve it?

  • Problem of Like @Searchpara become to '@Searchpara' and get nothing

    if you are used old Access not SQL you have to do like

    LIKE '%' + ? + '%'

    it is work with me for any query please connect with me

  • very usefull.... plz keep posting......... thanks

  • i am having the same problem. The system changes LIKE @Last_Name + '%' to LIKE '@Last_Name' + '%' . what should i do in order to fix it??

  • dont you fucking hate videos that require you to see a first one? youtube needs to make an option to set videos as part of a series and only show the first one in searches and suggested vids

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more