|
Hi,
I hv a query which retrives the data frm data base and also calculates sm value for few colums i get the value as infinity.so how can i hv it in my query so that it should display zero and find the sum of that column.
Here is my query...Pls sm one help...
OleDbCommand cmdMtdDays = new OleDbCommand("with member COSt as sum({[Dimension Time].[Day Text].[" + FromFilter + "]},[Measures].[Out Standing Amt]) member AV_MTD as sum(" + QueryFilterMTD + ",[Measures].[Inv Amt]) member COSMTD as (AV_MTD/" + day + ") member MTDDAYS as (iif(COSt=0,null,(COSt/COSMTD))) select {MTDDAYS} on columns, nonempty([DLOMAS].[OMVALU].[OMVALU]) on rows from COS", con);
Regards,
Annu
|
|
|
|
|
Don't Repost.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
I would fix those keys on your keyboard which are not working, it'll be easier to write SQL queries.
|
|
|
|
|
hi
is it possible to make XmlWriter output with formatting like below ?
I have gotten it working mostly (with XmlWriterSetting.Indent=true). However, I can not find a way to make ">" or "/>" into a new line. MS vcproj file seems to be in below format, so it should be possible ?
<element1
Attr1=""
>
<element2>
Attr2=""
/>
</element1>
thanks !
|
|
|
|
|
i am using Visual Studio 2005 and i'm using the following code to send mail:-
try
{
MailMessage mail = new MailMessage();
mail.To = varunmcaju@gmail.com;
mail.From = varun_mcaju@rediffmail.com;
mail.Body = "Sending mail through .NET SMTP mail";
SmtpMail.SmtpServer = "127.0.0.1";
SmtpMail.Send(mail);
MessageBox.Show("Mail sent successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
when i run this code it gives no error ...but the mail is never delivered.
Then i checked the C:\Inetpub\mailroot\Queue folder and found the following message
"This is an automatically generated Delivery Status Notification.
Unable to deliver message to the following recipients, due to being unable to connect successfully to the destination mail server.
varunmcaju@gmail.com "
why is it unable to connect to the destination server ...any ideas? thanks in advance
|
|
|
|
|
MailMessage objEmail = new MailMessage();
objEmail.To = txtTo.Text;
objEmail.From = txtFrom.Text;
objEmail.Cc = txtCc.Text;
objEmail.Subject = "Test Email";
objEmail.Body = txtName.Text + ", " +
txtComments.Text;
objEmail.Priority = MailPriority.High;
//SmtpMail.SmtpServer = "localhost";
try{
SmtpMail.Send(objEmail);
Response.Write("Your Email has been sent sucessfully -
Thank You");
}
catch (Exception exc){
Response.Write("Send failure: " + exc.ToString());
}
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
thanks for the reply SSK , but there's not much of a difference between my code and your code .What i wanted to know was that why is the mail not being sent?
|
|
|
|
|
What was your point of sending the code. I see no difference between the two except that his is for Windows and yours in Web.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
varun_mca_ju wrote: Unable to deliver message to the following recipients, due to being unable to connect successfully to the destination mail server.
Code is perfect and I do not see any changes desired.
Seems like your SMTP Server is not properly configured.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
thanks for the reply Manas..my SMTP settings are as follows :
General-> IP Address -> [All Unassigned]
Access->Relay->Relay Restrictions->Only the list below->access granted to 127.0.0.1 and also to the IP address of my computer, also the SMTP server is running....do i have to make any changes to the configuration?
|
|
|
|
|
It sounds like your mail server is not registered in DNS and servers outside your domain cannot do a reverse DNS lookup on it. This is a common method of preventing spam from spoofed mail server addresses.
Register the name in DNS (MX record) with your ISP and the problem should go away.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Does your ISP allow sending mail using your own SMTP server? It's not uncommon that the port is blocked to prevent spam, in that case you have to use the SMTP server that the ISP provides instead.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
same problem has occured with me but the next day i have found that mail is sent.wait for a while.....
Maniiiiiiiiiiiiiii
|
|
|
|
|
I want to design TreeView like list-friend on YahooMessage 8.0.
The node include:
1. Busy icon
2. Avatar icon
3. Display name
4. Status message
Please.
|
|
|
|
|
samulong wrote: Custom TreeView
It doesn't make the TreeView to be Custom.
samulong wrote: I want to design TreeView like list-friend on YahooMessage 8.0.
Whats the problem thn...
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
samulong wrote: I want to design TreeView like list-friend on YahooMessage 8.0
So do it, why would anyone else be interested.
Oh, I get it. What you really want is somebody else to do it for you.
Tough. Try rentacoder.com, where you pay to get software written
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I need ideas for chat application have webcam or source code in C#. Who can help me?
dsadsadsadsa
|
|
|
|
|
Try it in Google you won't get the answers here. we can help you but we cannnot do your homework.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Im making a program where you can draw and it send the information to that same program on a different PC across the network and vice versa. Basically, a networked version of MS Paint.
Im drawing like this: onmousemove im drawing an ellipsis. Which create the illusion of a line when you drag across(lots of little circes together). And ever time you move the mouse(every time it draws a single elipsis i make it connect and send the X and Y of the mouse. This is in its own thread. Now obviously this is a terribly inefficient way. What way should I use?
p.s. heres my current client code:
ASCIIEncoding ASCII = new ASCIIEncoding();
Byte[] sendStream = new Byte[256];
TcpClient client = new TcpClient(ipTxtBx.Text, 1234);
Stream my = client.GetStream();
sendStream = ASCII.GetBytes(params4Threads);
my.Write(sendStream, 0, sendStream.Length);
Thanks alot
|
|
|
|
|
Hello,
how do i get the image of a thumbnail from a file (*.doc, *.pdf) which shows me the Windows Explorer? The Images must be somewhere saved, how do i get them?
Thanks
|
|
|
|
|
softwarejaeger wrote: how do i get them
read this[^]
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I wrote a simple program to replace iTunes and Zune software for personal use only. I run this program on 3 computers, my laptop, desktop, and a computer at home.
I have a server setup that I want to store all my music and then have these different locations sync with.
Here is the problem:
I use all locations and put music on each computer, depending on where I am at.
I want to be able to add a song on my laptop, and different song on my desktop, and then when they sync, all 3 locations have the 2 new songs.
I am using an XML file for the song data on each computer, so here is what I was thinking. Add a new field called last sync (or something of the sort). Then when each computer syncs, it gets songs added after last sync, and adds song that have been added since.
Now I am pretty sure that will work fine, but any opinions on a better way, improvements, and/or issues with this design?
Any and all help is welcomed, and thank you for your time. Keep in mind I am not asking for the code on how to do this, just help with design patterns/ideas.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Expert Coming wrote: Keep in mind I am not asking for the code on how to do this, just help with design patterns/ideas.
*Cough* Microsoft Sync Framework[^] *Cough*.
|
|
|
|
|
Cool, thanks. Never even heard of that.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Hi
Is there anyway to save Microsoft Word Embedded Object to my local drive programmatically?
I am using InLineShapes and OLEObject but do not know how to save those embedded objects,
Please.
|
|
|
|