I know this may be a little bit of an odd thing for me to be getting excited about, but I just peeled a banana, and it stripped off naturally into 5 strips!!! I usually get 2 or 3 strips, maybe 4 at a push, but 5!!! Do I have some kind of super banana???
If your wife wants to learn to drive, don't stand in her way...
Hi guys I'm quite new to c# I'm writing a little jobby to spit the contents of a SqlDataReader out into an HTML table as a string. How can I find the datatype of each field in the data reader so that I can format it correctly? (dates, money etc) Thanks :-D
If your wife wants to learn to drive, don't stand in her way...
Hi guys I'm fairly new to ASP.NET, so I'm sorry if this is a silly question... I was wondering if anyone knows if there is a way of having a nice, smooth colour change effect on a section of header without using flash? I was thinking of maybe an animated giff, but it may need to be a bit too big to be efficient... Any idea's?
If your wife wants to learn to drive, don't stand in her way...
Hi The .NET Framework 3.5 is included in the installation, which installs ok before it goes on to install my app. You are right in asuming that there are no third party refs. It is simply my little 2mb app supposedly shipping with .net 3.5 and the SqlCe dll's. Should my installation process or app move these files to the system32 folder? It's a little odd. I'm sure it is something simple. :confused:
Huh? oh yeah... I knew that.. :oS
I have a windows app that uses SQL Server Compact Edition. It's fine on any machine that has VS on it but when I install it onto other machines, I get an error about the DLL's. Because I don't want to rely on an internet connection during the installation I am including all the set up files etc for SqlCe, which it does nicely, but the DLL files stay in the SqlCe folder in Program Files, and cannot be found. If I move these DLL's into c:\windows\system32 everything is fine. Have I missed something in the publishing of my app in VS2008? (I'm sorry if this is a daft question. I'm pretty new to this) Thanks, :-D
Huh? oh yeah... I knew that.. :oS
Just what I was after. Thanks Luc. :-D
Huh? oh yeah... I knew that.. :oS
Hi Guys Can anybody tell me how to get a program to run from the command line in windows regardless of what directory your in? (Like you can with Notepad, and Calc etc) I'm using Win XP Pro and Win Server 2003 Thanks :)
If you notice this notice, you will notice that this notice is not worth noticing...
Hi Everyone. I'm a newbie to ASP.NET and have just started experimenting CSS. I have set CSS to format some navigational hyperlinks in the web page which works very nicely. Now I have added a SiteMapPath control to the top of my master page, and it has taken on my hyperlink properties which is not good... Is there a way I can format one set of hyperlinks one way, and the other another??? Thanks in advance... :-D
If you notice this notice, you will notice that this notice is not worth noticing...
I love the way that a question about audio conferencing sparks such an in depth discussion about McDonalds. Speaking of which, why is it that you always get hungry again about 30 mins after eating a McD's meal??? :^)
If you notice this notice, you will notice that this notice is not worth noticing...
Thats spot on. Thank you. :-D
Hi Mika I dont have the exact code with me at the moment. It was similar to this...
SELECT
Field1
,Field2
,SUM(
SUM(CASE WHEN Field3 IS NOT NULL OR Term - @WeeksPassed > 0 THEN 0 ELSE 1 END))
/
SUM(CASE WHEN Field4 IS NOT NULL OR Term - @WeeksPassed > 0 THEN 0 ELSE 1 TotalPaid END))
)
FROM
Table1
GROUP BY
Field1
,Field2
The idea is to get a total of how many Term - 20's are over 0 which were representing a loan term. Anything less than 0 would mean it has gone over term and should not be counted. This was to be divided by the sum of total paid to calculate performance. Please excuse the SQL code if it is full of errors as I am 250 miles from home and have no way of testing if it is right. :sigh: Thanks
Hi All I'm a newbie to SQL coding, and I have a problem which I'm hoping you can help with regarding the Division by zero error. I have a calculated field in a sql statement where the results from 1 case statements is divided by another. Is there a way to catch the division by zero error and insert a '0' without the code throwing an exception? Thank you in advance.
Hi Mika Thank you for your help. I have fixed my problem by simply attaching the MDF files to SQL 2005 which gives me the usual SQL server control and its on constantly. Thanks again... :-D
Hi everybody. I'm more of a c# kinda guy so not all that well up with the hard core sql stuff. The problem I have is I have recently uninstalled all instances of SQL Server off my machine. Then I installed SQL Server 2005, and found that my web applications which relied on SQL express stopped working :doh: So I went to microsoft, and downloaded Express 2005 which did not do the trick. (it tells me it cant start up a user instance) Anyhoo, this upset me somewhat, and as much as I play about with permissions and settings for express I just can't get it working. So, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this... Please can somebody help???? Is it actually possible??? Thanks in advance. (sorry about the rambling story...)