Infopath search engine

[Savage]

Hi my name is Simon,

I have recently created an infopath form based on a database. I found this
ok considering this is the first time i have used the progrem.

I have a database which contains my companies suppliers and what they do. I
have created a search engine which searches my database on four different
areas.

id number
name
group
description

i have the id, name and group working if i use the exact wording in the
database. my description is not working.

How can i get it to work and can i get it to search for the closest matches.

 

[Paresh]

Hi my name is Simon,

I have recently created an infopath form based on a database. I found this
ok considering this is the first time i have used the progrem.

I have a database which contains my companies suppliers and what they do.I
have created a search engine which searches my database on four different
areas.

id number
name
group
description

i have the id, name and group working if i use the exact wording in the
database. my description is not working.

How can i get it to work and can i get it to search for the closest matches.

Hi Siman,

Can you please provide more details as to what are you trying to
achieve using InfoPath form?

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh/default.aspx

 

[Savage]

Hi Siman,

Can you please provide more details as to what are you trying to
achieve using InfoPath form?

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh/default.aspx

Hi Paresh,

I am trying to give the serveral sites that i look after the ability to
search for a supplier which they require to complete a job.

I am letting them search by 4 different fields which are:

id number
name
group
description

The only one not working is the description and i want them to be able to
type in a word in the search field and then the search engine will produce a
list with all the suppliers which have matching or very similiar words in the
description column.

hope this helps

 

[Paresh]

Hi Paresh,

I am trying to give the serveral sites that i look after the ability to
search for a supplier which they require to complete a job.

I am letting them search by 4 different fields which are:

id number
name
group
description

The only one not working is the description and i want them to be able to
type in a word in the search field and then the search engine will produce a
list with all the suppliers which have matching or very similiar words inthe
description column.

hope this helps- Hide quoted text -

- Show quoted text -

Have you written any managed code that returns the search results?

Thanks,
Paresh

 

[Savage]

No i havn't i am not very experienced with codes. I have managed to do it all
so far just using queries.

 

[Paresh]

No i havn't i am not very experienced with codes. I have managed to do itall
so far just using queries.







- Show quoted text -

I think you will need to modify the query to get the desired
results.
This group is not meant for database related issues, however, I would
like to give you a small example.

If you are using a query as follows:
select * from <tablename> where description = 'some text'

then you will need to modify the query to
select * from <tablename> where description like '%some text%'

Thanks,
Paresh