Hi Scubapro, Thanks for the reply. But this is not making any difference in the rankings. But we found that the current ranking is somehow ok for us. Thanks for you efforts Regards

jophin

Hi guys, I am having an inlined table valued function to search the users in my site. The search is optional ie. sometimes user will search with first name, sometimes he searches with last name, and sometimes both. As of now I am using if-else statements to check whether first name is ''(empty),or last name is ''(empty) or both are ''(empty). I have two questions? 1. Is there any other way, so that I can avoid these if-else statements and make it a single query? 2. If I am using a function as shown below, I have to specify all the return parameters. Is there any way I can avoid this and return the complete table(I do not want to use stored procedures)? I'm using a freetext search,because I want to get the search results according to relevence(ranked results). ALTER FUNCTION [dbo].[Search] ( @FirstName Varchar(400),@LastName Varchar(400) ) RETURNS @SearchResults TABLE ( -- Add the column definitions for the TABLE variable here UserName Varchar(400), EmailAddress Varchar(400) ) AS BEGIN IF (@FirstName<>'' AND @LastName<>'') begin insert into @SearchResults Select Top 100 Percent UserName,EmailAddress From UsersFirst t JOIN FreetextTable(UsersFirst, FirstName, @FirstName) K On t.Id = K.[Key] JOIN UsersSecond U on t.UserId=U.Id JOIN FreetextTable(UsersSecond, LastName, @LastName) As L On U.Id = L.[Key] ORDER BY K.[Rank] DESC; end ELSE IF (@FirstName<>'') begin insert into @SearchResults Select Top 100 Percent UserName,EmailAddress From UsersFirst t JOIN FreetextTable(UsersFirst, FirstName, @FirstName) K On t.Id = K.[Key] JOIN UsersSecond U on t.UserId=U.Id ORDER BY K.[Rank] DESC; end return END Thanks In Advance

jophin

Hi Scubapro, Select t.*,k.[Rank] From table1 t Join Containstable(table1, column3, 'abcd|efgh|ijkl|mnop') As k On t.Id = k.[Key] Order By k.[Rank] DESC column1 column2 column3 Rank 1 asdc abcd|efgh|ijkl|mnop 99 2 asdad abcd|efgh|ijkl 99 3 cdsdfc abcd 80 4 efsef abcd|efgh 30 5 asasda abcd|efgh|ijkl 30 6 dsas abcd|efgh|ijkl|mnop 30 I am not able to do an order by for the column3 because its data type is ntext. My actual requirement is that row1 and row2 should not have equal ranks because,Row1 is an exact match and Row2 is not. It is fine for me if, Rank of Row2=Rank of Row5 and Rank of Row1=Rank of Row6 because they are having equal values for column3. Kind Regards jophin

Hi guys, I am doing a FULLTEXT search as shown below Select t.*,k.[Rank] From table1 t Join Containstable(table1, column3, 'abcd|efgh|ijkl|mnop') As k On t.Id = k.[Key] Order By k.[Rank] DESC But I want the results to be ranked distinctly. Currently my results are listed something like the below column1 column2 column3 Rank 1 asdc abcd|efgh|ijkl|mnop 99 2 asdad abcd|efgh|ijkl 99 3 cdsdfc abcd 80 4 efsef abcd|efgh 30 5 asasda abcd|efgh|ijkl 30 6 dsas abcd|efgh|ijkl|mnop 30 Also please note that row1 and row6 are having same values for column3 but the ranks are 99 and 30 respectively. Thanks in Advance Jophin jophin

Hi, In my website when users are downloading their Microsoft office 2007 files like the ones with .docx , .xlsx,.pptx extensions they are getting downloaded as .zip folders.This problem is happening only in google chrome browser.Thanks in advance for any suggestions and solutions. Regards

jophin

Hi, In my website when users are browsing the site through Chrome and trying to download files like text file or ppt file, it is downloaded as a .aspx file for example down.aspx(The name of my download page).For a jpg or bmp file it is downloaded as down.aspx.jpg or bmp respectively.Is there something we can do from the download code .I am using asp.net with back end as vb.net Pls help. Thanks in advance Jophin

jophin

modified on Friday, September 25, 2009 5:05 AM

Hi Abhijit, Sorry for this late reply.I think I did not explained my problem properly. I tried app themes and it is working fine for me.So I am able to apply different themes according to the users who are signing in.But In my aspx pages there are some html images like the following . But I wanted to load different images according to the theme which is getting applied. So now I am planning to do something like the following for my green theme and for my red theme and in the class I will provide the src for the image . I am not sure whether this is the proper way of doing it. So if this is not the right way can you suggest me a better way. Regards Jophin

jophin

Thank you very much Brij, I tried this and it works .But still I am having another issue, there are palces in which images are loading from client side. Because of this I am having two problems. 1. They are not getting loaded because the previous location of images folder is changed are changed. 2. How I can make these images also dynamic according to the theme applied Thanks in Advance Jophin

jophin

Thank you Abhijeet, Let me have a try. Regards Jophin

jophin

Hi, I need to change my web application in such a way that , I need to apply different styles(different css files,different images) for the same pages for different users.So when different users sign in they will see the same pages in different colors .Is it possible Regards Jophin

jophin

Hi, For my asp.net website project i needed to find the ISP of the user who is accessing the website. Please help. Thanks in advance Jophin

jophin

Hi , I am having a tree view control.I want to change the css class (Background color) of the selected node of the tree view . I tried like this But this is not working . Any solutions . Thanks in advance Jophin

jophin

Hi , I am having a page in which I am dynamically loading a usercontrol on click of LoadUserControl button . On click of the LoadUserControl button the user control is loaded dynamically . In the user control one update button is there . On click of the update button , the update button event is firing . After that we again load this user control by clicking the LoadUserControl button . Then if we click on the update button of the user control the update button event is not firing . Please help . Thanks in advance Jophin

jophin

Hi Artem, Thank you for the immediate reply . But now I am using Server.UrlPathEncode() . It works fine. Regards Jophin

jophin

hi Artem, I tried this . Now the filename is proper but spaces are replaced by '+' signs. Is there any solution for that .Thanks in advance .Please dont consider my poor english . Regards Jophin

jophin

Hi , I am downloading a file with filename having french characters . My code is like this , strFilename = "dossier de téléchargement.docx" Response.AddHeader("Content-Disposition", "attachment;filename=""" &strFilename) But when we are using Internet Explorer after downloading , the filename is converted to 'dossier_de_téléchargement.docx' . Please help Thanks in advance Jophin

jophin

I am having an arraylist with string values stored in it.I want to access that arraylist in javascript so that i can manipulate the values stored in it.

jophin

we want to load images to our web page at the time when we scroll down . because there may be 100-1000 images .so loading all the images all together id inefficient. thanks

jophin

We are not getting the cursor position in Light Boxes in MOZILLA.But in IE not a problem

jophin

In our project we are facing problems of wrapping text in panels and all.With There is no problem with Internet Explorer. But with MOZILLA text is not Wrapped.

jophin