Jump to content

bless

Members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

 Content Type 

Posts posted by bless

    Trouble creating search form for a database.

    in ASP

    Posted

    So you already have the database, and you need the search function?What you probably want to do is get what they type into the search bar, split the words up by spaces, and create a SQL statement to check both the name and info fields in the database for each of the keywords. Of course, this will require that you enter appropriate keywords for each chemical. You might want an extra 'keywords' field in the database for this purpose. So the chemicals that are a part of Mr. Clean or Formula 409 or whatever would have the product names in either their info or keywords fields.If you will be writing the ASP using Javascript, I can probably give you some code examples to help you out, but if you are using VBscript then I wouldn't be much help with the code. I'm sure someone else can though.
    thanks for the reply, yes i already have the database set up, i like your sugesstion on the extra field for keywords, and i would prefer to use javascript rather than VB. So i'll probably only be checking the name field because whoever is going to be using this will know what they are looking for its a matter of them being able to type there chemical correctly in the search, and give them there result. If you could send some example it would be greatly appreciated. thankscdeagazi@confederationc.on.caif anyone else can help i could still use it.

    Trouble creating search form for a database.

    in ASP

    Posted

    Hello all i hope i can find some help here.I did some looking and couldn't really find anything, this could be either my eyes didn't see it or i wasn't searching proper context. anyways ive made a database with MSDS's (material saftey data sheets), it consists of a Name, a location link, and an info space. all i need to do is create a search bar so a user can type in the product they want i.e Mr. Clean for example and my database will give them results. whether it parses 3 or 4 letters doesn't matter. if any one knows a good reference or can help me on this it would be greatly appreciated. oh and im using microsoft access and trying to stay with asp the college im working for tends to stick to what they are used to. im more of a designer/css kinda guy so i need the help i can getthankscarlo

×
×
  • Create New...