|
SELECT Sum(Amount) as "Total Expenditures", Month(eDate) as "Month"
FROM Expenditure
GROUP BY Month(eDate)
ORDER BY Month(eDate)
Above is my current SQL statement. I would like to change it so that it would generate a table that shows zeros for months that have zero "Total Expenditures". Currently it only shows amounts for months that have
total > 0. I think I could do it once I get it into my datatable but the query would be nicer.
Thanks
"It has become appallingly obvious that our technology has exceeded our humanity."
- Albert Einstein (1879-1955)
"I think there is a world market for maybe five computers."
- Thomas Watson (1874-1956), Chairman of IBM, 1943
"640K ought to be enough for anybody."
- Bill Gates (1955-), in 1981
"Half this game is ninety percent mental."
- Yogi Berra
|
|
|
|
|
 How about a WHERE clause like 'WHERE Sum(things) = 0' at the end.
The warlord
|
|
|
|
|
That would only retrieve months with zero expenditures. I want both months with zeros and months with amounts > 0 in one table.
|
|
|
|
|
I am trying to use the GetFileOpen command and I have it working fine. I just want it to default to open to the same folder. c:/Assembly/ here is the code I have.
fileToOpen = Application _<br />
.GetOpenFilename("Assembly (*.exe), *.exe", , "Open Clave Drawings") How do I get it to always open the C:\Assembly folder?
Thanks,
Steve
|
|
|
|
|
I'm assuming this is code for an Office application...
The short version is you can't set that in the control directly. But, you might want to try launching the file that contains your worksheet or database from that folder first to see if that takes care of it.
The long version is you could write your own Open File dialog to get the exact functionality you want.
RageInTheMachine9532
|
|
|
|
|
I want to migrate a Application from ASP and VB6 to .NET
The main Part of the appication resides in a DLL written in VB accessing Request, Response and Session Object of the ASP-Page. It returns also a string back to the calling ASP-Page.
In a first step, I want to call the VB6.DLL from a .aspx Page.
Can I pass the scripting context in a similar way I did with asp?
Is it possible to write something like:
...
Dim IgPage As New IG4ASPA11.ASPPage
IGOutput = IgPage.OnStartPage(xxxxx)
IGOutput = IgPage.OnePage
....
What would I have to write instead of xxxxx?
Your help is very much appreciated
Beat
I add some relevant code from the old VB6 / ASP-Application
VB6-Code START -----------------
Class Module ASPPage
Public Sub OnStartPage(PassedScriptingContext As ScriptingContext)
' is autmatically called
Set MyScriptingContext = PassedScriptingContext
...
End Sub
Sub OnePage()
' complex application accessing Session, Request, Response and Applicaiton Object
....
MyScriptingContext.Response.Write "Some Direct Response Text"
...
OnePage = MyOutput
End Sub
VB6-Code END -----------------
ASP-Code START------------------
Code from the calling ASP-Page
Set ig4asp = Server.CreateObject("IG4asp.ASPpage")
zResp = ig4asp.onepage
Response.write zResp
ASP-Code END------------------
Beat
|
|
|
|
|
Hello everybody!
I'm a beginner developer in .Net and I need to know if I can convert Bitmaps to Metafiles in anyway. ( The Save method of the Image Class does´nt work beetwen vectorial images and pixelized images ).
Advanced Thanks! 
|
|
|
|
|
There is no indiginous class to the .NET Framework that will convert between vector and bitmap images. Your going to have to either search for a 3rd party control (I haven't been able to find one) or write one yourself. The main problems are going to be getting scaling right since vector images can be scaled to any size without loss of quality and bitmap images can't.
RageInTheMachine9532
|
|
|
|
|
Thanks for reply, I'm going to try it.
|
|
|
|
|
hello all, this is my first mesage here!
Well i'm have a litle problem... i'm trying to catch a key whit the
Overrides Sub OnKeyPress and the code that I'm write was this:
<br />
If e.KeyChar = Microsoft.VisualBasic.ChrW(?) Then<br />
<br />
abol_x = bol_x<br />
bol_x += 10<br />
mov_bola()<br />
e.Handled = True<br />
End If<br />
the first problem that i'm have is to now the char code to the cursors keys.. is a map whit that anywere?
the idea is to move a ball whit this and that is done whit the sub mov_bola, and only if i'm press the up cursor key i'm whant to execute this code
Others things the ball is disign in runtime using GDI+ and designed in a picturebox
any sugestion to help me on this is apreciated
Thanks 
The Limit is your mind
|
|
|
|
|
Hi. I’ve never coded in VB but I want to do one small plug-in for MSProject. I want a tool button that (when pressing it) saves the current project in a file c:\temp.xml file (The XML format is important).
Is VB the “right way” to solve my problem? Open for suggestions.....
Thanks
APe
|
|
|
|
|
can someone pls tell me how do i make a particular word in a rtf blink??
i mean...
like when we do rtf.seltextbold then any text after that, will be bold
like when we do rtf.selcolor = vbred then any text after that will be red in color..
can someone pls tell me what do i do so that after doin that the rest of the text will be flashing???
tks a lot...
Have a Super Blessed Day!
-------------------------
For God has not given us a spirit of fear, but of power and of love and of a sound mind.
2 Timothy 1:7
"For God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life."
John 3:16
"Therefore you also be ready, for the Son of Man is coming at an hour you do not expet."
Luke 12:40
|
|
|
|
|
Simple, rtf doesn't support blinking text.
But, displaying a web page in your form does...
RageInTheMachine9532
|
|
|
|
|
I would like make my own form so i set Control Box = False
and i use a label for Title Bar but i don't know how to drag and drop my form. I would appreciate if any one help me on this matter.
Many Thanks
|
|
|
|
|
I have a DropDownList where the ValueField is a guid as a string. I then need to pass this as a guid into a stored procedure. If I try and cast a string to a guid I get the following error: Value of type 'String' cannot be converted to 'System.Guid'. What do I need to do to get this to work?
Jim
|
|
|
|
|
The String object can't convert a string to a GUID because it doesn't know how. However, the GUID object does know how to parse up certain format strings into GUID's. The following code segment demonstrates this:
Dim guidString As String = "936DA01F-9ABD-4d9d-80C7-02AF85C822A8"
Dim objGUID As Guid
objGUID = New System.Guid(guidString)
Debug.WriteLine("String GUID: " & guidString)
Debug.WriteLine("GUID object: " & objGUID.ToString)
Documentation on the GUID object can be found here[^]. This same documentation can also be found in the Visual Studio help, in the Index, under 'Guid'.
RageInTheMachine9532
|
|
|
|
|
Great! Thanks for you help, I was going down the wrong track trying to cast a string. I managed to get this to work but I guess the datakeys are already in the correct format. Dim FileUID As Guid = CType(dgMyDataGrid.DataKeys(e.Item.ItemIndex), System.Guid)
Jim
|
|
|
|
|
do you have XML program example?
please E-mail:michael_jjw@163.com
thinks!!
|
|
|
|
|
You didn't say what you were specifically looking for, so here[^] are some examples of the some of the basics from Microsoft.
RageInTheMachine9532
|
|
|
|
|
|
Is there a command to pause a script?
Thanks
|
|
|
|
|
I am currently working on a project for work. In this project we have a bunch of lessons, etc on .pdf(Adobe). As you all know it takes a long time for Adobe to open so I want to try and open it in the background when the project is opened. Can anyone tell me how to do this? I want to try and open it in minimized state so it doesn't cover up the project.
Any help would be greatly appreciated.
Michael Thompson
President, Founder
Coded Future
http://www.codedfuture.com
|
|
|
|
|
(digging into deep dark recesses of mind)... if you get the Adobe SDK (if I remember, you have to pay for the latest ?V6 version, but previous ones are free after registration), you can programmatically create an 'Adobe' object, load a document, and Im sure there's some way of doing this minimized in the background .. I could try to look tonight (currently 8:45am down here in Aus and Im at my office, whereas I played with this for an outside commercial contract at home)
If you want me to take a quick look, post back - your best bet is still go to the Adobe Website, and assuming youre using V5.x, download the SDK and read the docco (hard going but worth it)
hth, Garth
|
|
|
|
|
Thanks Garth,
If it wouldn't be much of a problem I would appreciate it. I am waiting for a response from Adobe as we speak (or type) about it as well as getting a "Go-Ahead" to put their .exe on the disk. I really appreciate the quick response. Thanks,
Michael Thompson
President, Founder
Coded Future
http://www.codedfuture.com
|
|
|
|
|
Michael - my feeling is it will do what you want - Im going to try to direct mail you, the relevant reference manual and one of the examples which (I think) demonstrates what you want ...
Garth
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
