|
Well Madhu I have done this while using mySQL as Database. The query wud be ...
SELECT *, MATCH (firstname, lastname, ID, Date) AGAINST ('Search Text Here...' IN BOOLEAN MODE ) AS score FROM table_name
WHERE MATCH (firstname, lastname, ID, Date) AGAINST ('Search Text Here...' IN BOOLEAN MODE ) order by score desc
If you are using other than mySQL then sorry...
Lets work it Out.........!
|
|
|
|
|
I use SQl Server 2000/2005 (T-SQL).
|
|
|
|
|
|
I am using SQL server full text indexing. It works fine.
When querying the DB using a big string,
I could not able to query just few letters from the word.
EX: table tblNames:
FirstName LastName
Test Student
Ex: “test student” this works fine if I use the full word.
I am trying to query “ts st” or “ts” using below SQL
select oid, firstName, LastName from tblNames
WHERE FREETEXT (*,'ts st')
Can Anybody help me how to do this.
Thanks,Madhu
|
|
|
|
|
Hi,
I've created a custom web control.I was wondering if i could set the possible values for a property when it's chosen in the aspx file.Like asp:Button: and a dropdown appears with false and true.
Thanks
|
|
|
|
|
Hi Developer
I have a table "cars_ads" with following columns...
ad_id, make, model, description
Now I need to show distinct makes sorted by number of ads in that specific make.
Lets say We have 3 Ads for BMW, 7 Ads for Mercedez and 12 for Honda then result should be like...
Honda(12)
Mercedez(7)
BMW(3)
What wud b the most efficient way to achieve this...?
-- modified at 13:23 Wednesday 4th April, 2007
Lets work it Out.........!
|
|
|
|
|
I cannot remember exactly the syntax, but just give you idea...to archive this, you GROUP BY model, then count all cars for each model
<< >>
|
|
|
|
|
Thanks dear it works for me...
select model,count(model) from ads group by model
Lets work it Out.........!
|
|
|
|
|
Hi,
I've got a gridview control on a page which is bound to a custom collection. All the properties of the objects in my collection are readwrite apart from the ID which is bound as readonly. I've added edit buttons to each row but i can't find the 'Enable Edit' Property on the datagrid. All the axamples i've found appear to use design time binding.
Is it possible to bind a collection of objects to a grid at runtime and edit them in situ?
Thanks for help / links etc
Russell
|
|
|
|
|
HI all,
There's any measure or method for a better display and functionality of Asp.net controls in Mozilla browser.coz all the controls are working fine in IE but the textboxes are compressing,validators are not working in the Mozilla.
Pls help me in this issue.
thanks in advance
Have a Nice Day Dudes
Have a Nice Day Dudes
|
|
|
|
|
Well Dude, check the link: http://aspnet.4guysfromrolla.com/articles/050504-1.aspx[^]
Hope it wil help u out...
For Mozilla I think you need to apply server side validation. If you find any solution for Client Side Validation with Mozilla let me know. Thanks
Lets work it Out.........!
|
|
|
|
|
hi friends
i m developing one web based app. in vb.net
in the app. i want to manually debug through break point-F9
but when the error goes into the error line, app. wont stop but it gives disassembly error like:
Microsoft Development Environment
there is no source code available for the current location
Ok Show Disassembly Help
pls help me on this problem
thnx in advance
regards
saravanan
|
|
|
|
|
What line are you trying to debug? Is it your code, from another assembly, or from a third party?
only two letters away from being an asset
|
|
|
|
|
Did you compile your web app in debug mode?
Ben
|
|
|
|
|
hi there:
If you want to step into a dll, you have to reference the project which created that dll into your solution.
<< >>
|
|
|
|
|
Hi,
I'm also faced similar problem earlier. What I have done is stopped all .net applications including ending the task of aspnet_wp.exe and compiled it again in debug mode. It will work. You can see ASPNet_wp.exe on right-clicking the task bar and in the Processes Tab of Task Manager. Check whether the settings in IIS correctly and the system you are debugging have administrative rights.
Happy Coding!!
Meeram395
|
|
|
|
|
Hi Guys,
Have a good day. I need your help. I don't know if what's wrong with this small asp code
<%
Dim CheckX
Dim CheckY
Sub DisplayCheckBox
If Request.form("x") <> "" Then
CheckX = "Checked"
Else
CheckX ="Not"
End if
If Request.form("y") <> "" Then
CheckY ="Checked"
Else
CheckY ="Not"
End If
End Sub
%>
>
x: <%= CheckX %>y: <%= CheckY %>
hifiger2004
|
|
|
|
|
Is it ASP or ASP.NET ?
What is the problem you are facing ?
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
I am using classic asp
hifiger2004
|
|
|
|
|
I am using classic asp. I just wonder how to get the value of the checkbox once the button submit will be clicked.
Actually, this is only a sort of small test asp program for checkbox value. Because if I am successful with this test program I will bring the concept to my actual program using class asp that will save all the multiple checkbox that were selected into the mssql2000.
Thanks in advance.
hifiger2004
|
|
|
|
|
I am using reporting services for generating report.How can I create report in a word format with all word features such as Table Of Contents,Object embedding(.doc,.xls etc.,),bullets and numbering,inserting HTML input into word document etc?
SenthilSelvi
|
|
|
|
|
I want the text that is appearing on the link should open in the explorer but it is not doing that way. Like if www.rediff.com is being displayed then i want this to open in explorer but it opens http://localhost/WebsiteLogix/www.rediff.com
Please help me out.
Mohinder Singh
|
|
|
|
|
for this you need to use fully qualified name. attach HTTP:// with that
|
|
|
|
|
Instead of www.rediff.com, use http://www.rediff.com and it will work fine.
|
|
|
|
|
Hi All,
I want to develop a <b>Fundraising thermometer</b> using asp.net and c#. I am able to develop this using a Background Image as Thermometer. Here i want the image developed at each and every stage to be stored in the database. So I need the Image also to be generated.
Please Help in this issue
Thanks in Advance
ukrajudotnet
ukraju
dotnet
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
