I want to add a searching function in my website, to search product stored in a table in sqlserver 2005. The keyword may contain some special character like --,(,), etc. The codes I compiled won't work well.
Is there any open source code with such functionality? code for mysql is also welcome :) thanks
mentor
Last Activity: Dec 25 '08, 03:06 AM
Joined: Mar 8 '07
Location: china
-
any sql code to search database tables ?
-
How to handle control event in Content Page ?
The GridView in Cotent page cause an updating event, but the handling methond won't be executed. The Row Count of the GridView is Zero, but in fact it's not zero.
Why?
...Code:<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <asp:GridView ID="gvtitles" runat="server" CssClass="wtable" AutoGenerateColumns="False" -
So I see that ajax will use the page's connection to the server. That's Ok, Thanks !... -
How to Divide 160G web server HDD drive
IIS+ASP.NET + MSSQL + Mailserver. Target flow is about 10K IP/day. Now 5G data + 50G pics. How to format the 160G Hard disk space ?
Besids, How to manage the serveral million pics so that they can be accessed quickly by client browser? -
how Server judge an Ajax Request belongs to a Session
When user is authenticated, the server store "UserName" in session. Then throug ajax, the user request another page which require authentication. How the ajax request tell the server that one has been authenticated, or how the server know it's from 'UserName"?
Should ajax set SessionId in Header or Cookie ? How to get and set the SessionId ?
I learned the browser could send back to server a sessionid,... -
Thanks. That's what I want. It's been solved....Leave a comment:
-
Correct the code above:...Leave a comment:
-
Combine keyword and search result ?
Supposed col1 has been indexed,
will return col1, col2. Now I want to relates the results with each keyword, i.e, to clarify which result corresponds to which keyword.Code:SELECT col1, col2 FROM table1 WHERE col1 CONTAINS ( key1 OR key2 OR key3)
How to do this?
Can we get the following results?
For...Code:key1, col1, col2; key1, col1, col2; key2, col1, col2
-
Are you sureis in the format of dd/mm/yyyy ?...Code:value1 = Request.QueryString["value1"]
Leave a comment:
-
Request.QuerySt ring["value1"] may cause problem. make sure the querystring value1 is in correct datatime format.
Also you should pay attention to urlEcond to get some proper character.
Suppose to set value1 ="2008-02-13", it should be ok.Leave a comment:
-
get form value from another page
in first page,
[HTML]<form id="form1" runat="server" action="page2.a spx">
<TEXTAREA id="txt1" runat=server></TEXTAREA>
<INPUT type=submit value=submit name=rev_submit >[/HTML]
in second page(c#)
In this way, data can be posted to second page. But I found when the first page is posted back,...Code:string str = Request.Form["txt1"];
-
Thanks. I'll check it....Leave a comment:
-
Any good cache manage tool for .net ?
I'm running a small web site with IIS and asp.net on only one machine. There are alot of pics and posts. To improve performance, proper cache scheme is needed.
I found memcached is good for distributed system, but not apropriate to my situation. Could anyone please give some advice? How about squid ? -
Any good cache tool for .net ?
I'm running a small web site with IIS and asp.net on only one machine. There are alot of pics and posts. To improve performance, proper cache scheme is needed.
I found memcached is good for distributed system, but not apropriate to my situation. Could anyone please give some advice? How about squid ? -
it's solved. there is something wrong with the comparerLeave a comment:
-
c# SortedList can't inserted items,even not repeated
In the folling codes, Product is a class with SortedList Memeber Components.
...Code:Product prod = new Product(); prod.Components = new sortedList( new IntComparer() ); prod.Components.Add(0,1); prod.Components.Add(1,2); private class IntComparer : Comparer <int> { public override int Compare(int x, int y) { if -
Sorry I fogot to mention. I'm using asp.net2.0 and c#....Leave a comment:
-
codes for searching with 'AND' 'OR' logic ?
I'm trying setting up a site similar to eshop.
There may be 1 million items in sqlserver2005. In order to search some products, user may input some words int a textbox to search product name and description with or without logical operator, or may input bar code for bar code search.
I think the program should first trim out spaces, recoginze 'AND' 'OR' operator. But how to implement both 'and' & 'or' search efficiently?... -
how to implement product search in DB with millions item within eshop ?
I'm trying setting up a site similar to eshop.
There may be 1 million items in sqlserver2005. In order to search some products, user may input some words to search product name and description with or without logical operator, or may input bar code for bar code search.
How should such function be implemented? Should I use conditional select with 'where' 'like' ? OR should I use tools something like lucene ?
... -
How to append a Node created in another document ?
I tried this way, but don't work.
in current document, first get the node
then, import the node to the other target document, and append it,Code:var aNode = document.getElementById("anode");
IE6 reports the method importNode() not supported. Is there any other way? thanksCode:newNode = targetdocument.importNode(aNode); targetdocument.body.appendChild(newNode);
No activity results to display
Leave a comment: