----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Girdhar77 Message 4 in Discussion hi arjun, the query which you saw in the asp.net unleaseh is using the full text search service of sql server 2000. for that to happen , you need to have a primary key defined in that particular table and the datatype of the col. to be searched is either text,ntext. Freetext and freetext table are the keywords for sql.You will find them in any sql server 2000 book. As far as I remember , the full text service is installed by default,you only need to generate a catalog for the same. There is one wizard to do that. this is all i know,rest you explore. rgds. rishi -----Original Message----- From: scorpion_arjun [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 3:30 PM To: BDOTNET Subject: Re: Search Page ----------------------------------------------------------- New Message on BDOTNET ----------------------------------------------------------- From: scorpion_arjun Message 3 in Discussion hello rankit , thanks for ur suggestion. but is therre an query like : SELECT * FROM <table-name> where FREETEXT (<column-name>,'<search-text>') I saw it in the ASP unleashed book. I want some suggestions for implementing a search facility in my web-site usibng vb-script and am not familiar with C# and javascript. and some code snippets wud be helpful, Thank you. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED] ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. ********************************************************************* ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
