Okay, I am using Full Text Search feature for implementing search. But I am having a problem with it.
FOR EXAMPLE...
Their are three rows of data and their TAG column contains below data respectively...
1. Computer
2. Class
3. Computer Class
Whenever user search for "Computer Class" my query returns records in below order
1. COMPUTER
2. Class
3. Computer...
SwapnilD
Last Activity: Sep 12 '13, 02:12 PM
Joined: Jan 11 '10
Location: Mumbai
-
Search data based upon keyword or tags entered by USER
I am developing a website for local business classified.
Where Service Provider / Traders will post advertisement of their business / shop etc.
and end user will search for their needs and locate all the adv. based upon their search.
Basically this will be SIMILAR to JUSTDIAL.COM
While posting and adv. I have provided input field to enter KEYWORDS/TAGS to locate their adv. successfully.... -
Hi, thanks for answer, exactly what I was searching. I asked same question on another forum and what I got was differences between both (which I was already aware of).Leave a comment:
-
Why use Functions in SQL if even if we have stored procedures
Recently, in a interview, I have been asked this question.
"WHY USE FUNCTIONS IF WE HAVE STORED PROCEDURES"
I answered we cannot perform DML operations using FUNCTIONS, We can use it to retrieve data only.
But Interviewer asked me, Stored procedures could also retrieve data then why use FUNCTIONS?
I ANSWERED: Don't know, I only use PROCEDURES...
I would like to... -
How to Child Control ID from Parent control ID in ASP.NET 4.0
I have a Datalist (datalist1) control which populates a list of Categories in a Linkbutton.
When user clicks specific Linkbutton, I would like to populate subcategories into another DATALIST (datalist2) control which will be inside datalist1 control.
But I am unable to retrieve ID of child DATALIST, I am getting error: The name datalist2 does not exist in the current context
BELOW IS THE SAMPLE code
/-------------... -
Hi,
thanks for prompt reply.
Code provided by you is working fine in all browsers but IE.
In IE sync is off..
In I.E. Close button is jumping off the "poptitle" DIV.Leave a comment:
-
Design simple popup using CSS/HTML
Hi ALL,
I am developing a website for which I need a popup which will display information. I need this popup to be designed in CSS / HTML.
I am ASP.NET developer and not a designer, although I have basic knowledge of of HTML and CSS. But, not able to figure out how to design such a popup.
It would be great if anyone help me to achieve this.
For your reference I have attached a popup screen shot... -
Hi, thanks for answer, much depreciated.Leave a comment:
-
Need guidelines for INDEXING database table
I am developing a "Local business search" website, just like
OLX, JUSTDIAL or QUIKR...etc.
Since its a search based site (i.e. read intensive website),
I have to ensure that search data get retrieved quickly and efficiently. That's why I have decided to use INDEXING on tables.
I would like to use INDEXING on "ADVERTISEM ENT" table, because all the search data will be retrieved from... -
How to get address from Latitude/Longitude?
I'm passing Multiple Lat/lan parameters to GOOGLE map to generate a MAP and also showing markers for all the locations based upon Lat/Lng.
on mouseover event of Marker I'm showing pop up with some info, but along with the info I would also like to show the addrees based upon the lat/lng.
Below is the snippet of code which displays a popup on hover of markers ...
...Code:var map = new GMap2(document.getElementById("map_canvas")); -
I like your solution, but I have some questions...
Applying date/time stamp means having a column to insert a date in temp table?
If yes, how can I make a use of it.
How can I execute a function automatically/frequently?Leave a comment:
-
How to schedule the task to execute ASP page
I am creating a feature which will allow users to import data of excel sheet to database.
First, data will be imported from excel sheet and will be displayed in a tabular format.
User performs a mapping porcess for database fields and click Submit button.
Then a stored procedure inserts all the data of each row into more than 15 tables.
Above mentioned process might cause an issue if users... -
Dear Joseph,
Thanks for your reply.
I solved it, Actually, I was using VbCrlf after each row, this was causing the issue, I have removed VbCrlf and I am not having blank spaces after each row.
Thanks again.
SwapnilLeave a comment:
-
Not able to remove blank spaces from string
I'm implementing a feature which reads comma separated txt file from server(one line at a time).
Format of file is fixed, There are 3 columns on each row.
After reading the row from file I insert it in a database table.
But first value of each row aoutomatically appends two blank spaces, even if there are no blank spaces at the begining of each row.
I tried to use "TRIM/LTRIM/Replace"... -
I tried it with asp but still getting error.
Please note for above code xmlHTTP has third parameter as TRUE. In this case I get error "The data necessary to complete this operation is...Code:Dim xmlhttp = CreateObject("MSXML2.ServerXMLHTTP") xmlhttp.open ("GET", url, true) xmlhttp.send ("") Response.write (xmlhttp.responseText) xmlhttp = nothingLeave a comment:
-
Okay, do you know another way do the above mentioned task?Leave a comment:
-
Sorry, I didn't explain it well.
I want to get the source code of page dynamically/problematically/through javascript etc.
below is code I tried to achieve the task but it does not and giving me error "ACCESS DENIED"
...Code:<script language=javascript> var xmlHttp function DecodeThisVIN() { url = "www.XYZ.COM"Leave a comment:
-
How do I Get The HTML Source of Any Web Page
How can I get the HTML source of any web page. -
How to implement VIN Decoder functionality
How do I implement a VIN decoder functionalitry in my website. There are few softwares provide VIN decoder functionality to which I can integrate my website to decode the VIN. But I don't want to subscribe any of them.
Can someone suggest me how to implement VIN decoder functionality?
Thanks -
Webservice not working
I have created a web service on my local machine (C:\Inetpub\www root\Converter) using vb.net version 1.1.
Purpose of webservice: this webservice will be invoked by a third party website (say abc.com). User will add a message in a webpage of abc.com this message will be sent to the Webservice.
Below mentioned is the code that I have written for a web service to store the parameters/message sent by third party application....
No activity results to display
Leave a comment: