Search results for query: *

I've figured out the problem guys, this post can go away now! Thanks! Damann

The error happens at this line: getDataOracleCommand = (OracleCommand) DAP.ConstructCommand Here is the original code again: oracleConnection = (OracleConnection) DAP.GetConnection("OracleDBConnString"); getDataOracleCommand = (OracleCommand)...

Hello Guys, I'm getting this error whenever I try to call an oracle storeprocedure like this in a .NET (C#) app. oracleConnection = (OracleConnection) ESDataAccessProvider.GetConnection("OracleDBConnString"); getDataOracleCommand = (OracleCommand)...

Great! Thanks for the valuable post! Thanks, Damann

Hey guys, I am working on a .NET app that needs to output a file in fixed width format (basically every field/column in the file has a "fixed" length/width). Usually my console apps output in comma delimeted format which is easy to string/concat together. But I'm a little stumped on how to...

Hey thanks man, that did work! The pwd returned is binary though, is there a way to decrypt it somehow? Isn't there a stored Procedure to do this? Please let me know... Thanks, Damann

Hey Guys, Is there a meta query (hopefully I'm using the right terminology here) in MSSQL that I can use to query and return all user accounts and passwords that has access to a particular database? In the same breath does a query exist that I can use to return all databases on a particular...

Im using Visual Studio.NET 2003...

Any other thoughts on this one?

Hello guys, Just curious as to why onreadystatechange is not apart of iFrame tag? MSDN is showing that I shoud be able to use this, but it doesnt show up in my list of options after I do <iFrame <- doesnt show up in my dropdown here... Any reason why? Anyway to get it in there by chance...

Hey guys, Thanks for your comments. I saw the document from MSDN with it erroring out because the page in the iFrame potentially being from another domain, but it actually isn't - the iframe is opening a page from the same domain from what I can tell. The thing that's hard to understand is...

Hello all, Just wondering why I'm getting a JavaScript Access Denied error when I make the below calls. The error actually shows up on the second line below: var objFrame = document.frames("iFramesID"); var objFrameElement = objFrame.frameElement; - Access Denied error happens here. The...

I overlooked one small thing - today's no longer 4/2/2005 so I had to change the date... I gave both of you guys praises for your valuable posts... Thanks again... damann

Still doesnt work guys... Can someone take a closer look and see if anything's missing here? Thanks a bunch...

DECLARE @tD DATETIME; SET @tD = GETDATE(); SELECT count(*) FROM CUSTOMER WHERE status = 'A' AND customerID = '106' AND EFFDT = @tD Hello all, See above code, for some strange reason this doesnt work... If I take out the @tD variable at the end of the select and hard code a date in like so...

I got it fixed now... It was being reset in the SP to the previous value, that's why... Thanks a bunch for all your help though!!!! Regards, Damann

Hello all, I'm passing DBNull.value as a parameter in my store procedure, yet it's not updating the field in the DB (SQL Server 2000). Here's the line of code that does it here: updateSqlCommand.Parameters["@dDate"].Value = DBNull.Value Is this because it's a date field? If it is, then how...

I'm doing this instead guys... fooTextBox.Text = foo.ToString("0.000000"); This fixes the problem... Thanks, Damann

Ok let me try that...

I am converting it back to a string that's what's wierd about it... private decimal foo; -- declaring var. This section of the code enters user input var into the DB. ------ if(fooTextBox.Text!="") foo = Convert.ToDecimal(fooTextBox.Text.Text); updateDB.Parameters["@vFoo"].Value = foo...