|
no i mean sort by their average
but thank you anyway
|
|
|
|
|
Sorry I did not understand you the first time.
You can use this:
SELECT
A,
B,
AdividebyB
FROM
(
SELECT A, B, A/B AS AdividebyB FROM tbl
)
AS tblTMP
ORDER BY AdividebyB
|
|
|
|
|
wow thank you so much!
it worked!
|
|
|
|
|
|
i am facing a problem to validate the inputted user name expression. There is no build in validation expression in RegularExpressionValidator control for this.
please help me to create a custom validation expression that meet the following condition.
" user name may consist of a-z, 0-9, underscores, and a single dot (.) "
Thanks
|
|
|
|
|
rana_inam wrote: There is no build in validation expression in RegularExpressionValidator control for this.
Of course not, that's not what it does.
[\w\d_]+\.?[\w\d_]*
That matches any number of letters, number and underscores, either side of a single optional dot. It requires at least one character before the dot, this also stops it matching an empty string.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi
I have implemented Forum in my site using asp.net 2.0.
Now i want to implemented text editor with the forum?
How can i implement text editor with asp.net. Is there
any software/tool available for asp.net? How can i
implement text editor?Please help me?
Thanks
Rahul.
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Get it Text Editor
bEST rEGARD
pATHAN
please don't forget to vote on the post that helped you.
|
|
|
|
|
Thanks
I will tr it?
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
|
Hi
I will try that but source code is not available with that download
of free text box then it is difficult it to integrate.
Thanks
Rahul
People Laugh on me Because i am Different
but i Laugh on them Because they all are same.
|
|
|
|
|
i am displaying search results with indexing server based on catalog name.if i want to search only directory within that catalog.how can we search.here ia m using asp.net with c#.net 2005
another problem is i want to display googles search results in datagrid component when i active google check button.any code plz send me.
venkat
|
|
|
|
|
Hello all,
I have created a SharePoint website with several pages and installed features (xml files for the context menu). I would like to know how I can deploy it to antoher SharePoint server? What is the best way to do it? I am new to SharePoint web application. I am using SharePoint Services 2007 and visual studio 2008.
Any suggestion would be greatly appreciated.
Thanks a lot.
Best regards,
Bin
|
|
|
|
|
There are shed loads of links about the IE6 needed to get the opacity fix for PNG images in IE6 (e.g.[^]), but does anybody know of a neat ASP.NET image control that handles this without the need to mod the CSS or run JS scripts (explicitly).
The hacks seem to work ok for static PNG, but I am dropping PNGs left right and center (not literally) on partial updates and the javscript hack is not playing ball with them.
Any ideas?
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
I added a dropdownlist to a gridview by turning category id into a insert template and binding it to sqldatasource control but it will not show the category id. any suggestions
|
|
|
|
|
Normally, when I have used dropdowns in a gridview, I use a templated column. This allows me to control when the dropdown is there. I would assume you only want the dropdown when the line is in edit mode. Then when the gridview is bound to the sqldatasource you just bind the text of the dropdown to the correct value.
Hope that helps.
Ben
|
|
|
|
|
I used a template in my detailsview. I put the sqldatacontrol in this template with the dropdownlist. Still no working ,poor me
|
|
|
|
|
I have an odd issue and I'm hoping there is a way to do what I want. I'd like to have any HTML (.html and .htm) files go through a templating process first. So if a user tries to go to http://test/test.htm the server gives them the file that's been processed and had a template applied (default.master). I want this to only work on one of the sites in IIS not all of them. I was trying to work with the 404 error redirects but since the file is there that won't work.
Basically when the server sees a .htm or .html I want it to redirect to TEST.aspx with the old path and name as part of the URL querrystring. The TEST.aspx will read the old file and remove everything before and after the body tags. Then put the remainder in between the Content tags of the aspx file which will let ASP.NET 2.0 process it and add the master page.
I think I explained this well, if not please ask questions.
Thanks
|
|
|
|
|
You should look at writing a HttpHandler[^] that handles requests for HTML files within your website.
Paul Marfleet
|
|
|
|
|
I am not sure whether or not this is in the right forum. Feel free to move it if it is not.
I am having an issue formulating a form based file upload in HTML to an ASPX page on an IIS server. I am referencing RFC 1867 to get the appropriate syntax, and I guess RFC 1521 that outlines the MIME data streams. Here is the issue, the post itself is being formulated and works fine as long I do not add the filename="" parameter to the end of the content-disposition header. The second that filename="" parameter gets added to the content-disposition header for that particular parameter the ASPX page no longer recognizes it in the parameters collection. Is there something that I am doing wrong here?
Here is a sample of the syntax being sent.
WORKS:
Content-Disposition: form-data; name=""
DOES NOT WORK:
Content-Disposition: form-data; name=""; filename=""
Also, once this gets working I just have a couple other questions...
#1) What should be the "proper" Content-Type parameter value for an XML file? Content-Type: text/XML?
#2) If I send the Content-Transfer-Encoding: base64 parameter, will the ASPX page barf?
#3) I am assuming that I can get the extended field parameter attributes somehow through ASPX, is this so?
Please help...
~LizardWiz()
|
|
|
|
|
LizardWiz wrote: I am having an issue formulating a form based file upload
Presumably you mean download?
Paul Marfleet
|
|
|
|
|
No I mean upload.
Isn't there something in HTML that looks like this < INPUT type = "file" >?
~LizardWiz()
|
|
|
|
|
LizardWiz wrote: Isn't there something in HTML that looks like this < INPUT type = "file" >?
That is HTML.
If you are using ASP.NET 2.0, you can use the FileUpload[^]control to add file upload capabilities to your web page. .NET takes care of the low-level details for you.
Paul Marfleet
|
|
|
|
|
I am not formulating this post using an HTML page. I am formulating it in C++ from a windows service. When I use the syntax provided to me in RFC 1867,the ASPX page does not add the parameter into the form parameters collection. So my question is, how do I get the ASPX page to add the parameter into the forms parameter collection? And how can I access the extended parameter attributes?
~LizardWiz()
|
|
|
|
|
From my webservice class method i am returning an array of Person object When i run the webservice it crashes and says Person class doesn't have paramterless constructor. Although I have serialized Person class. But if i add a default constructor with no input values then i don't get this runtime error. Does anybody no why do i need to add a paramterless constructor. Please help me thanks
<br />
<br />
public Person[] Globe(string name)<br />
{<br />
Person p1 = new Person("p1);<br />
Person p2 = new Person("p2);<br />
<br />
Person[] p= new Person[2];<br />
p[0]=p1;<br />
p[1]=p2;<br />
<br />
return p <br />
}
|
|
|
|