Is there some type of inherent limitation on the use of OR boolean operators in the ON clause of Full/Left/Right Joins?
I have a query that returning significantly less data (only one side of the join) when I use two clauses in the ON with an OR. Running the query with either one of the two...
Hi Guys,
I have an GUI with some highly specific search settings. The users can specifically select which elements they want to see (for instance, show me all of the data related to Elements 1, 2, 5 and 15.) The elements they are selecting are dynamic and change based on which set of data they...
Hey Guys,
I'm not a DBA, so this kind of stuff is way out of my realm of knowledge. We have a server that is running 3 seperate Oracle instances. Most of the time, everything is just fine, but every once and a while, the three instance will start taking turns pegging the processor. Average load...
Hi Guys,
I am toying with a third party app that I don't have a lot of access to, but I'm trying to adjust the CSS to improve the look/feel of my site.
I can create CSS for the site, but some elements point to classes that I do not have access to change. Specifically, there are blocks that...
Hi Guys,
I'm trying to pull a set of values out of a table. I have a list of primary keys in a coma delimited string. How can I use that string to retrieve the values I want? I tried the following, but I am getting an "ORA-01722: invalid number" error. The p_Assessment_IDs parameter contains...
Hi guys,
I'm trying to find a way to get a SQL statement to return a description of a table. This is coming through ADO.Net, so just using DESC <tablename> isn't going to work.
I've tried:
select dbms_metadata.get_ddl( 'TABLE', 'ANSWER', 'HTSCME' ) from dual;
and
select column_name,data_type...
Hey Guys,
I'm having a heck of a time trying to get some dynamic code working. I am pulling the structure of an Oracle table out of the database and generating text based on it. The only problem is, when I pull back an empty table an look at the columns' data type, Integer columns are showing...
A table I was working on had a 2 column primary key. Due to some design changes I needed to switch to a 3 column primary key. So I dropped the original PK, and created a new one. Only when I tried to create the new constraint (with the same name as the original one), toad popped an error telling...
Hey guys, I'm having a brain fart this afternoon.
I have a method that takes a parameter byRef. I need to use that variable, and modify it, and I want to sender to see the same changes. The problem is I need to use the variable out side of the scope of that specific method.
here's a short...
Does anyone have, or know where I could find a good example for audio recording with DX9 with .Net 2.0? I've found a few examples, but they are all using .Net 1.1 and seem to be rather out dated.
Thanks,
-Rick
VB.Net Forum forum796 forum855 ASP.NET Forum
[monkey]I believe in killer...
Hi Guys,
We have a server connected to a SCSI tape drive that uses Legato for back ups. Earlier today my co-worker rebooted the server with out rebooting the SCSI tape drive. Now when I try to mount the tape for the backup I get a message box that says: "Server (server name): open error: drive...
I am receiving the following error after a while...
I had never seen this error before yesterday. I just started testing some new software, everything was going great, then all of a sudden the software started bombing out while trying to connect to the Oracle database. I went to log in to the...
Hey Guys, I'm having a problem with an ASP.Net page, but it sounds like the issue is in the JavaScript.
Here is a super stripped down sample:
In the code behind page:
Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles...
The battle continues...
So I have an image button. in the code behind I add an OnClick attribute to it, the OnClick calls a JavaScript method called "PlaySound". PlaySound then checks to see what state the sound is in (Playing/Stopped/Finished/Paused). If the sound is paused, I need to click on...
Hey Guys,
I have a custom user control. This control has a number of properties I have added to it. I'm having a mind blank this morning as to how to get those properties to retain their state over a post back.
-Rick
VB.Net Forum forum796 forum855 ASP.NET Forum
[monkey]I believe in...
I have a page that has an AJAX ModalPopupExtender on it. That extender opens a div that has an AJAX UpdatePanel on it. That update panel has a combo box, a list box and an ImageButton on it. The immage button (an OK button) is referenced by the popup extender as the default accept/close button...
Hey Guys,
Is there a way to set the back color of a list item in a CheckListBox?
-Rick
VB.Net Forum forum796 forum855 ASP.NET Forum
[monkey]I believe in killer coding ninja monkeys.[monkey]
I know I've seen the code before, but I can't seem to track it down at the moment. Anyone have a handy function to convert an integer to a bit array?
ie:
14 -> 1110
-Rick
VB.Net Forum forum796 forum855 ASP.NET Forum
[monkey]I believe in killer coding ninja monkeys.[monkey]
Hey Guys,
I have a data repeater, I am trying to put a user control into that repeater. The problem I am running into is trying to uses quotes (") in the server tag, for example:
<uc1:wucSlide ID="WucSlide2" runat="server" IndexPos="<%#DataBinder.Eval(Container.DataItem, "IndexPos") %>"...
Hi Guys,
I was using the following code to attempt to give my users access to a sound file on my web server. The problem I ran into is that the the 'Stop' button will correctly stop the wav file, but the 'Play' button will not re-start the audio.
Thoughts?
<BGSOUND id='WucAudio1'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.