select ccy,ex_rate,rate_dt as start_dt,(select top 1 cur2.rate_dt from tblcurrencyrate cur2 where cur.ccy = cur2.ccy and cur2.rate_dt > cur.rate_dt order by cur2.rate_dt) as end_dt from tblcurrencyrate cur --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

Asad Hussain wrote: Is there a way to edit the msi database with c#. I want to write a program that will change just one registry entry within the msi database and then email the msi to the client. If you download the platform SDK[^], you get a tool called "Orca" which you can use to edit the MSI database. If you know what you want to change (in general, changes to the Registry table are very straigtforward), it's very easy to effect and save the change. If you are determined to do the changes programatically, this article[^] provides the interop signatures and sample code you'll need. Once you've opened the database, you just use SQL to UPDATE the tables you want. Share and enjoy. Sean

Asad Hussain wrote: Here is my web.config file on the web service. Where? It's not likely a firewall problem, as the response comes from the web server. As the web server is responding, the request must have reached it. Have you allowed anonymous access to the web service? --- b { font-weight: normal; }

If you are asking about hosting the asp.net runtime in a windows service and not IIS, then you can. Look at the Cassini project for an example. I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

You can not use non default constructor with SAO you have to use default constructor if you need to use non default constructor use CAO instead MCAD

It shouldn't be too difficult for you then. I managed my MCAD with only about 3 months real C# experience. I relaxed and took another 18 months to upgrade to the MCSD. I found it easier to try a few sample papers first, like trancender, just to get into the mind set of the exam. Trancenders are good also because they explain the answers, so if you get one wrong it explains the answer and explains why the others are wrong. My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

A remote object is like another object, you can indeed pass it as a constructor parameter. Regards Senthil _____________________________ My Blog | My Articles | WinMacro

Asad Hussain wrote: Is there a way to add credit card billing to my website?? Obviously :-) Asad Hussain wrote: Are there service providers that I can use to integrate that to my site? You need to talk to a bank who will provide the credit card service, likely they would be able to recommend providers in your area. The easiest way to take credit card payments on your site is Paypal. It depends I guess on what volume of payments you're hoping for, as to what options are viable for you. Christian Graus - Microsoft MVP - C++

Each messenger will be different; you may need to use proprietary protocols to interoperate with each. Maybe the GAIM[^] project will help you get started? Tech, life, family, faith: Give me a visit. I'm currently blogging about: Homosexuality in Christianity Judah Himango

No. Christian Graus - Microsoft MVP - C++

Go to the file system editor, select the application directory and enter [MAININSTALLDIR] (resp. the name for your variable) for DefaultLocation (the standard value is [ProgramFilesFolder][Manufacturer]\[ProductName], but you want the directory you found in the registry). Regards, mav

This seems overly complex and there are some errors. It seems that the masks should go: F8, 7C, 3E, 1F Also, there's two tests for (i % 5) == 3 Instead of changing the mask, why not shift the byte under test and 'or' in the necessary bits from a look ahead byte (which is 0 if at the end of the array). It's a bit complicated (no pun intended) because you have to figure out when to get the next byte, but you should be able to do the whole thing in a loop. Marc MyXaml Advanced Unit Testing YAPO

Asad Hussain wrote: it opens up a link to www.mirc.com or something In opinion, you windows might inffect with spyware. Normally windows do not cotain any specific application like the client. Try to increase your server security by: - Update the anti-virus definition. - Update the security patch or service pack from windows update website. - Download and install windows defender[^] in order to clean any virus in your server.

What do you mean by "not all windows close this way"? Are you talking about close JUST the IE windows or all applications? Also, before you close the IE window, you might want to try checking the .Busy property and wait until the borwser window is finished. I'm not syaing that this will solve the problem, but it might... RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

gotcha... i'll look into it.

suhweet!!!!

check this out. http://blogs.msdn.com/mollman/archive/2004/09/07/226483.aspx[^]

Hi there, To set the expired time for an image file, in the IIS snap-in you right click on the image file to open the Properties dialog box. On the HTTP headers tab, you select the Enable Content Expiration checkbox and set the expired time you want. You can also do that in code as well.