SELECT SUM(A.amount) FROM (
SELECT amount, notes FROM credit WHERE customer_Id = $cust_id
UNION ALL
SELECT amount, notes FROM payment WHERE customer_Id = $cust_id
UNION ALL
SELECT sum( amount ), '' AS totalpaid FROM payment WHERE customer_Id = $cust_id
UNION ALL
SELECT sum( amount ), '' AS totaltaken FROM credit WHERE customer_Id = $cust_id
) A

;

Regards, Arun Kumar.A

SELECT id FROM details WHERE id = (
SELECT A.detail_id FROM (
SELECT detail_id, COUNT(detail_id) view_count FROM views WHERE
(TO_DAYS(NOW()) - TO_DAYS(viewed_on)) <= 2
GROUP BY detail_id ORDER BY view_count DESC LIMIT 1
) A
);

Regards, Arun Kumar.A

Hi All, While designing aspx pages in VS 2005, .gif images are not displayed for the image controls. But, if I set .JPG images , I can see the images in the Design Mode. By the way, I can see all types of images at RunTime. Can anyone help me on this issue? Thanks in advance...

Regards, Arun Kumar.A

:)

Regards, Arun Kumar.A

Thank you very much..

Regards, Arun Kumar.A

There are two divisions: ISL-> India Software LAB. (Research work on their own products). GBS->Global Business Services.(Mainframe or SAP) I will be put to work at GBS at first and later can switch to ISL.

Regards, Arun Kumar.A

Hi friends, IBM visited our college yesterday. They selected 14 out to 650. I got selected. Thought of sharing with you......

Regards, Arun Kumar.A

No Idea of how to do this with GridView... But I think DataList control will fulfill all your need...

Regards, Arun Kumar.A

I would use Repeater control...

Regards, Arun Kumar.A

Try this:

string optionalFiters="";

if(TxtFname.Text!="")
  optionalFiters+="  and First_Name= '" & TxtFname.Text + "'";

if(TxtLname.Text!="")
  optionalFiters+="  and Last_Name= '" & TxtLname.Text + "'";

if(DpdownSex.SelectedItem.Text!="")
  optionalFiters+="  and Sex= '" & DpdownSex.SelectedItem.Text + "'";

Regards, Arun Kumar.A

Thank you very much. You have been most helpful.:):):)

Regards, Arun Kumar.A

I didn't ask you to write the program.. Please read the original post.. I have asked just the idea.. Not the program..

Regards, Arun Kumar.A

So you didn't understand the question properly. Have you noticed that repeating patterns are enclosed within parenthesis. For example: 0.565656 => 0.(56) 0.111111 => 0.(1) 0.123412341234=> 0.(1234)

Regards, Arun Kumar.A

Hi All, Can anyone please give me an idea to write a program(any language) to print 0.123123123 as 0.(123) and 0.346346346 as 0.(346) if both the numerator and denominator are given?

Regards, Arun Kumar.A

Please have a look at Indexes and Clusters. I think it will reduce the time from O(n) to O(log n).

Regards, Arun Kumar.A

CREATE PROCEDURE [dbo].[GetValueFromMyTable] ( @ColID INT) AS BEGIN SELECT ColName = CASE @ColID WHEN @ColID=1 THEN Col1 WHEN @ColID=2 THEN Col2 ELSE col3 END, FROM tableName

Regards, Arun Kumar.A

Try This: Assign the redirect() function to the onClick attribute of the button. function redirect() { document.location.href = "check.aspx?t1=" + document.getElementByID("txtName").Value; }

Regards, Arun Kumar.A

ASPnoob wrote:

I don't know how to modify the line strSQL = String.Format("SELECT UserName FROM myTable WHERE (UserName='{0}');", txtUserName.Text) to make the KillChars function work.

You can use the killChars like this: strSQL = String.Format("SELECT UserName FROM myTable WHERE (UserName='{0}');", killChars(txtUserName.Text)) But you should use killChars to prevent SQL Injection. The best way you can do this is by using stored procedure. I would suggest you to read this http://www.codeproject.com/cs/database/SqlInjectionAttacks.asp[^].

Regards, Arun Kumar.A

nilam11 wrote:

reply immediatly

Please request humbly.

Regards, Arun Kumar.A

ASPnoob wrote:

I had done some search on String.Format and some of the sites I visited said that the 1st value within the parentheses serves as the place holder for the 2nd value.

What you have got from the search is right. But you have a small misunderstanding with that.

ASPnoob wrote:

strSQL = String.Format("SELECT UserName FROM MembersInfotbl WHERE (email='{0}');", txtUserName.Text)

if the textbox has some value say XXX@YYY.COM, then strSQL will be SELECT UserName FROM MembersInfotbl WHERE (email='XXX@YYY.COM');

Regards, Arun Kumar.A