SQL Server :: Querying Indexing Catalog Causes Error On The Word "weight"?
Oct 7, 2010
On our web server we have a search form that fires off multiple searches and combines the results into 1 page. The main search is of the indexing catalog for our web site. We have used this for several years and it works just fine. The company just sponsored a weight loss program and we have discovered that the word "weight" returns an error. The word "weigh" works fine but if we add that "t" on the end it fails. Here is the error:
Incorrect syntax near 'weight'. Expected '!', '(', NOT, ISABOUT, FORMSOF, STRING, PREFIX_STRING. SQLSTATE=42000
This is the query at the time of execution:Select DocTitle,URL from SCOPE() where (CONTAINS(CONTENTS, 'weight') OR CONTAINS(DocTITLE, 'weight')) order by Rank DescDoes anyone have an idea of how to get past this problem? I'm guessing that "weight" is probably a key word or something similar.
View 1 Replies
Similar Messages:
Sep 20, 2010
I am trying to open a Word document from a .Net web application. The code (in brief) contains ...
using Word = Microsoft.Office.Interop.Word;
using System.Reflection;and, the code that actually creates the document includes:
object oMissing = System.Reflection.Missing.Value;
object oEndOfDoc = "\endofdoc"; // endofdoc is a predefined bookmark [code]......
which suggests something wrong with the bookmarks. So I took references to the bookmarks out and started using a file called Hello.doc as my template. No bookmarks - just the word 'hello' in it.This fell over too - but the StackTrace indicated it was when SaveAs was called.So, the question is ... why does it work on my development box but not on the server. The server has Word installed on it.
View 1 Replies
Mar 8, 2011
I have this table in SQL that I'm trying to do some comparison work with Ok, onto the schema. It's like this:
[Code]....
Now, what I want to do is query my database in this manner:Display any records that conflict only Non-priority conflict based on: priority based on the time of day
[Code]....
View 4 Replies
Apr 20, 2010
I am building UI for a large product catalog (millions of products).
I am using Sql Server, FreeText search and ASP.NET MVC.
Tables are normalized and indexed. Most queries take less then a second to return.
The issue is this. Let's say user does the search by keyword. On search results page I need to display/query for:
Display 20 matching products on first page(paged, sorted)
Total count of matching products for paging
List of stores only of all matching products
List of brands only of all matching products
List of colors only of all matching products
Each query takes about .5 to 1 seconds. Altogether it is like 5 seconds.
I would like to get the whole page to load under 1 second. There are several approaches:
Optimize queries even more. I already spent a lot of time on this one, so not sure it can be pushed further.Load products first, then load the rest of the information using AJAX. More like a workaround. Will need to revise UI.Re-organize data to be more Report friendly. Already aggregated a lot of fields.
I checked out several similar sites. For ex. [URL]. Not only they display the same information as I would like in under 1 second, but they also include statistics (number of results in each category).
The following is the search for keyword "white" [URL] How do sites like zappos, amazon make their results, filters and stats appear almost instantly?
View 3 Replies
Jan 29, 2011
I am trying to convert a asp page to asp.net.
I changed everything except this one line Set dbC = Server.CreateObject("ADOX.Catalog")
Can anyone suggest an equivalent to this ADOX.Catalog in asp.net This dbC is being used in the following way in asp
[code]....
View 2 Replies
Oct 27, 2010
I have a gridview that contains one linkbutton within itemtemplate. I bind this gridview with a table from my database that displays different items. When the gridview displays records and when the user clicks on an item of gridview then how can i change that item's fontweight to bold and change that same item's color.
View 3 Replies
Mar 8, 2011
I am just trying to figure something out. At work we have alot of data access code Ex:
[Code]....
Pretty standard stuff really, but I was at a training course recently where the Developers insisted on wrapping code, that seemed nothing more than expose exactly the same functionality.
I was interested in your thoughts as to whether this was a good idea. So the above would inherit from a DbHelper class with some thing like:
[Code]....
These would just expose the same but maybe a bit more generic i.e. using DbCommand as opposed to SqlCommand.
View 1 Replies
Feb 7, 2011
I am trying to increase the line weight of my line chart in crystal report, is that doable , yes or no ?
View 2 Replies
Nov 1, 2010
I'm using SSRS 2005 and I would like to change the text weight of a textbox (in a table) dynamically based on a condition from normal weight to bold.
View 1 Replies
Aug 8, 2010
I'm going to design a database for an image gallery in ASP.NET Web App . Because of some reasons I've decided to store the image in Data Base , Not the address .
In the application i need two or more different size and weight image for each image that the admin insert .For instance , One of them is small and lightweight thumbnail , and the other is Original big one .
My question is : Should i have two column ( one for lightweight and small thumbnail and one for big and full size one ) in DataBase Or Is there any way i could load different size and wight image from Big and original image column ?
View 1 Replies
Feb 23, 2011
I want to check that a specific url is indexed in google using asp.net.Is google provide any api, webmethod anything regarding this.
View 2 Replies
Mar 23, 2011
I have a gridview that has the following colums Category, Weight , and an option to delete row. I user would like to be able to highlight two columns in excel Category, Weight and then past them from clipboard to gridview.
View 1 Replies
Aug 27, 2010
I'm using asp.net 2.0 (VS2005) on a windows 2008 server.
i'm using MS Office 2007
when open word docuemnt from server using the following code -
Response.ContentType = "application/ms-word";
Response.AppendHeader("Content-Disposition", "attachment; filename= " + strDocName);
Response.TransmitFile(Server.MapPath(Defpath1));
Response.End();
it works fine when i run it in debug mode, but gives the following error when running through IIS Problems during Load Problems came up in the following areas during loadMissing file:
QTnicFLJ5JKZN8dyEzUEsK2jPtygbkw....
View 1 Replies
Feb 25, 2011
I am writing a program that uses a .dotx template and does a merge of data in an aspx page. The program works perfect on my Dev workstation locally but when I deploy it to a test IIS server, it fails on the second line below giving me an Object Reference error.
I ran into problems earlier because the Word Com object was not on the IIS server so I loaded Word onto the server and set permission in DCom and got past that problem. But now I get this error on the line that starts with wRange = . As I said, the program works perfectly locally in debug mode.
Microsoft.Office.Interop.Word.DocumentClass
System.NullReferenceException: Object reference not set to an instance of an object
lines of code:
Document BaseDocument = oWord.Documents.Open(ref oTemplate, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing);
wRange = BaseDocument.Bookmarks.get_Item(ref endOfDoc).Range;
View 2 Replies
Jul 17, 2010
I am using below code to generate word document using assp.net/c#.net, please tell me where i am missing it is generating word file and all contents are their.but problem is that when i open it it gives me error:"The Office Open XML file filename.doc cannot be opened because there are problems with the contents"
and after clicking ok i get my required file.remove this error.
in error details:The file is corrupt and cannot be opened after it again gets a error message:"word found unreadable content in myfile.do you want to recover the contents of this document? if you trust the source of ths document,click yes"
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Office;
[code]...
View 1 Replies
Jun 20, 2010
I have implemented URL rewriting and I would like someone to answer if my new URLs will be indexed by google or not.
BACKGROUND:
I have many databound linkbutton which redirects to URL like: www.example.com/product.aspx?PLU=4985783028
What I intended to do is to make above URL look like www.example.com/MY-Nice-Product1-For-Sale-4985783028.xyz . Whuich internally should rewritten as above. I could have easily implemented such URL rewriting but all my databound link button redirects to
/product.aspx?PLU=4985783028 and when this the page at this URL is served to browser it will look like
/product.aspx?PLU=4985783028 and not /MY-Nice-Product1-For-Sale-4985783028.xyz
WHAT I DID:So I implemented my own method of Rewrite. Steps for which I did is as follows
1. I wrote code inside Global.asax in Application_BeginRequest event.
2. I checked for URL if its product.aspx or not (using fullOrigionalpath.Contains)
3. If its product.aspx I would takeout the "PLU" Query parameter and by string manipulation and then call a function to determine product name from the unique ID ("PLU").
4. And then I would redirect the page to "/productname-PLU.xyz" (e.g. here productname is
"MY-Nice-Product1-For-Sale" . AND PLU is "4985783028" so that is redirects to "/MY-Nice-Product1-For-Sale-4985783028.xyz")
5. Once redirected, again, "Application_BeginRequest" event will be called. and there I would check if URL contains. ".xyz" extension.
6. If so, I would takeout PLU by string manipulation and then rewrite URL to right URL which looks like
"/product.aspx?PLU=4985783028"
7. Then after user will see "/MY-Nice-Product1-For-Sale-4985783028.xyz"
on their browser addressbar
This is how I achieved my goal so that all old URL redirects works too and all new URL works too and in both case user will see new URL.
Following is the code
[Code]....
So finally the question is "Will my new URL be indexed by Gooogle?" because the basic intention of doing this was to help with SEO .
View 10 Replies
Jan 18, 2014
I have perform indexing on date column in many of my sql tables. My question while applying indexing date we have sort option as well to perform the indexing in descending or ascending order.
While index the date column sort should be asc or desc.
If I sort desc will it increase performance because 98 percent time user is retrieving current data.
View 1 Replies
Feb 2, 2010
I have a catalog that hase standard pricing now i need to increase this to 5% for each product. this is the way i bind the data:
Price:<%#Eval("Price",
"{0:c}")%>
View 3 Replies
Mar 23, 2011
Is there a way to prevent search engines from indexing a site by modifying the ASP.NET Web.config file?
View 2 Replies
Apr 27, 2010
Developing a web site in .Net 4. Very close to being complete with most functionality, so I thought I would attack what seemed to be a tough one (something I have not done): site content search.
I've been digging around for an hour or so, and I'm a little perplexed. How do I perform content search on an ASP.net website?
A few things I'll throw out there before you answer with something I've already seen and cannot implement:
I am developing on a Win7x64 computer using VS2010 w/TFS.Site has been converted to .net 4, and is in C#.Will not have access to put site on Windows Server 2008 for another month, but would really like to implement search if at all possible beforehand.All that said, can I implement searching via indexing? I've looked at using Windows Search, but nothing looked like it worked right. This site will be served up on a Windows Web Server 2008. Do I need to somehow develop against a Server 2008 to implement search via indexing?
View 3 Replies
Feb 9, 2010
I am having a little trouble with an 'IndexOutOfRangeException'. I think it is because when the code tries to get the DateModified col from the database it sometimes contains NULLS (the users haven't always updated the page since they created it).
Here is my code;
s = ("select datemodified, maintainedby, email, hitcount from updates where id = @footid")
Dim x As New SqlCommand(s, c)
x.Parameters.Add("@footid", SqlDbType.Int)
x.Parameters("@footid").Value = footid
c.Open()
Dim r As SqlDataReader = x.ExecuteReader
While r.Read
If r.HasRows Then
datemodified = (r("DateModified"))
maintainedby = (r("maintainedby"))
= (r("email"))
hitcount = (r("hitcount"))
End If
End While
c.Close()
I thought (after a bit of msdn) that adding;
If r.HasRows Then
End If
after adding I am still getting the same old IndexOutOfRangeException
(ps, I have tried datemodified as string / datetime)
View 4 Replies
Jul 22, 2010
my webpage perform content search using Windows Indexing Servicemy production machine is Windows XP everything finethen i tested my published Website in Windoes 7the Summary Fields always empty
View 1 Replies
Nov 21, 2010
I am wondering if there are any good articles you could point me to that would present the implementation details or options for delivering advanced search capabilities. Like what we see at [url] and similar Web sites offering vast numbers of products to be searched. The search process for these starts with a simple "Search" text box - usually with auto-suggest. Then the user can drill down and narrow the search by [for example] price, manufacture, size, capacity, and other relevant attributes of the product being searched.
When I navigate such sites and search for products, drilling down into the various categories, it's easy to think that there is some complex engine behind the scenes that generates dynamic SQL to satisfy the various and potentially extensive criterion required to satisfy the search requests.
Or could it be simpler than that? In any case, I understand this question may not have a specific answer; so I'm hoping for some article or reference implementation I could study. Short of that, if any of you have implemented advanced search of a product catalog (presumably searching products stored in a reasonably normalized database; through 3NF or so); any critical implementation considerations would be appreciated. I'm particularly interested in the meta data that may have to be present in the underlying data set in order to satisfy some of the search requests.
View 2 Replies
Apr 25, 2010
I have created SQL CLR database project in 2010. when I try to deploy it to sql server 2008, it gives me error like Msg 6528, Level 16, State 1, Procedure UmAlQuraConverter, Line 2 Assembly 'SqlClassLibrary' was not found in the SQL catalog of database so, how to add SqlClasslibrary to sql catalog
View 1 Replies
Jul 6, 2010
i m developing a product Catalog. All fine, i want to manage wish list for product, which user wish to see, now my question is that how can i manage this wish list, coz i have no uniqueness of the user, coz ny one whether it is registerd or not can wish the product in my scope, i thought to distinguish the user by their IP address becoz this wish list is temporaray, how can i delete the record when user close the browser if go to the IP address for distinguish..
View 2 Replies
