|
If there are two fields firstname and latsname with values s and a.if we concatenate using sql we get s,a.Suppose a is null then how i check a is null and print s itself using sql select query.
|
|
|
|
|
How can a be null if its a value in a field, do you mean if one of the fields is null?
|
|
|
|
|
Yes if one of the field is null then how we can concatenate it by checking the null refrence.
|
|
|
|
|
SELECT ISNULL(firstName,'') + ISNULL(lastName,'') ...
|
|
|
|
|
Thanks for your kind reply sir.The answer is very helpful to me.
|
|
|
|
|
also i want to put a comma between the fields.if the field is not null insert a comma and if the value is null dont display the comma.How is it done with this isnull statement.
I attach a query below.in this the street and area is null.Please send a query that help to me.
SELECT ISNULL(Building, '') + ISNULL(Street, '') + ISNULL(Area, '') + ISNULL(District, '') + ISNULL(State, '') + ISNULL(Country, '') + ISNULL(PostalCode, '')
AS Expr1
FROM SA_Address
WHERE (AddressID = 13)
|
|
|
|
|
this gets a little more complex, and I would suggest that this is display logic so should therefore be in the presentation layer rather than the database layer. So if it were me I would be selecting each field from the address table and dealing with the presentation in the presentation layer.
If you insist upon doing it in the wrong place, you want something like
SELECT
CASE WHEN Building IS NULL THEN ''
ELSE Building + ',' END +
CASE WHEN Street IS NULL THEN ''
ELSE Street + ',' END +
CASE WHEN Area IS NULL THEN ''
ELSE Area + ',' END +
... (etc)
|
|
|
|
|
Thanks for your kind reply sir.in isnull no way to check like that.Is any way to check in isnull itself.
|
|
|
|
|
Actually, yes there is.
SELECT ISNULL(Street + ',','') + ISNULL(Building + ',','') ...
My brain farted first time round!
|
|
|
|
|
hi guys, I want to use a validator, and I want to validate that the input is exactly 5 digits, how should I do that?? Thx ahead
|
|
|
|
|
 IAM AN ASP.NET BEGINNER.
I PUT THIS CODE TO THE HTML PAGE AND SAVED SA ASP FILE.
BUT RESULT IS NOT DISPLAYED WHY??
<html>
<body>
<%
response.write("<h2>You can use HTML tags to format the text!</h2>")
%>
<%
response.write("<p style='color:#0000ff'>This text is styled with the style attribute!</p>")
%>
</body>
</html>
BY RANI
rani
|
|
|
|
|
works for me
is the code above everything in your page
Is the page not displaying or is it the code not displaying?
j
|
|
|
|
|
Dear All,
I use the following code,A little group
DirectorySearcher mySearcher = new DirectorySearcher(entry);
mySearcher.Filter="(&(objectClass=user)(sAMAccountName=test))";
mySearcher.PropertiesToLoad.Add("memberOf");
SearchResult mysr=mySearcher.FindOne();
int iCount = mysr.Properties["memberOf"].Count;
Response.Write(iCount); //A little Group
Thank you!
|
|
|
|
|
My first page use master page
when i use PostBackUrl then on target page control are not found and given nullreference error.
anujsharma
|
|
|
|
|
The postback url must be posting back to a different state because the controls are not found. Are you transferring sessions from page to page?
|
|
|
|
|
IAM NEW TO ASP.NET ,IAM USING VB.NET.I WANT TO SUDY ASP.NET
I HAVE VISUAL STUDIO 2005 THAT I AM WORKING VB.NET.
IF IT IS ENOUGH,THEN HOW CAN I START?CAN U GIVE ME A SMALL CODE.
OR I WILL GIVE U..
<%@ Page Language=VB Debug=true %>
<script runat=server>
Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
If Not IsPostBack Then
Panel1.Visible = True
Panel2.Visible = False
lblTitle.Text = "Quiz Page"
End If
End Sub
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim TotalCorrect as Integer
Panel1.Visible = False
Panel2.Visible = True
lblTitle.Text = "Results Page"
If DDLAnswer1.SelectedItem.Text = "Second" Then
TotalCorrect = TotalCorrect + 1
End If
If DDLAnswer2.SelectedItem.Text = "False" Then
TotalCorrect = TotalCorrect + 1
End If
If DDLAnswer3.SelectedItem.Text = "False" Then
TotalCorrect = TotalCorrect + 1
End If
lblResult.Text = "You scored " & TotalCorrect _
& " out 3 correct."
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Quiz Sample Page</TITLE>
</HEAD>
<BODY>
<form runat="server">
<Font Face="Tahoma">
<asp:Label
id="lblTitle"
runat="server"
/>
<asp:Panel
id="Panel1"
runat="server"
>
<asp:Label
id="lblQuestion1"
runat="server"
Text="Question 1"
/>
<BR>
<asp:DropDownList
id="DDLAnswer1"
runat=server>
<asp:ListItem>Hour</asp:ListItem>
<asp:ListItem>Minute</asp:ListItem>
<asp:ListItem>Second</asp:ListItem>
</asp:DropDownList>
<BR><BR>
<asp:Label
id="lblQuestion2"
runat="server"
Font-Bold="True"
Text="Question 2."
/>
<BR>
<asp:DropDownList
id="DDLAnswer2"
runat=server>
<asp:ListItem>True</asp:ListItem>
<asp:ListItem>False</asp:ListItem>
</asp:DropDownList>
<BR><BR>
<asp:Label
id="lblQuestion3"
runat="server"
Font-Bold="True"
Text="Question 3"
/>
<BR>
<asp:DropDownList
id="DDLAnswer3"
runat=server>
<asp:ListItem>True</asp:ListItem>
<asp:ListItem>False</asp:ListItem>
</asp:DropDownList>
<BR><BR>
<asp:button
id="butOK"
text="OK"
Type="Submit"
OnClick="SubmitBtn_Click"
runat="server"
/>
</asp:Panel>
<asp:Panel
id="Panel2"
runat="server"
>
<asp:Label
id="lblResult"
runat="server"
Font-Bold="True"
/>
</asp:Panel>
</Font>
</Form>
</BODY>
</HTML>
IT IS AN ASP CODE FROM WHERE I PUT THIS CODE AND HOW CAN I EXECUTE???
BY RANI 
rani
|
|
|
|
|
This puts the code in the same page as the ASPX. How nasty.
I recommend buying a book and working through the examples in there, rather than grabbing code off the web and trying to work out how to run it. The answer to your question is that VS2005 has a web server built in, so just hitting F5 should launch your page.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I want to do login control using AJAX.anybody know plz reply me...
Rajendran.AL
|
|
|
|
|
I didnt know there was a login control for ajax...
|
|
|
|
|
There isn't, nor should there be. Excepting of course that AJAX is just a way to use javascript, so you can write any control you like with it.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Well, I would not do that. b/c the only way to log in with pure AJAX, is to make the person logged in, in javascript, which can be hacked.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
I want to create database driven organization chart using Asp.Net and Sql Server. Please help me as soon as possible.
|
|
|
|
|
|
Good, first you need the desire to have something, the next step is to try to get it. In your case, start programming.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
