I am creating a procedure in a package that calls a procedure in a package and sends out a cursor. The cursor coming out is a join of many tables. I need to then loop thru the cursor, however when I try to declare a variable to the cursor%rowtype I get that the cursor is not defined yet. Is...
Hi all,
any idea why this code wouldn't continue to postback after it runs the javascript?
submit.Attributes.Add("onclick", "this.disabled=true;this.value='Please wait...';return true;");
Thanks!
Can I do something like this within my query?
if h.notes = "Issue" then
left outer join ISSUES i on h.record_id = i.id
else
left outer join ISSUES2 i on h.record_id = i.id
end;
thanks.
I have a regularexpressionvalidator attached to a textbox in a usercontrol. I add the usercontrol dynamically to my page. It works fine.
However, if I add the usercontrol multiple times to my page (so let's say my page has the usercontrol on it 4 times) then when the regularexpressionvalidator...
I have some code like below:
P_USERSTableAdapter adapter = new P_USERSTableAdapter();
adapter.Connection.ConnectionString = p_connectionString;
P_USERSDataTable table = adapter.FINDBYLOGINID(p_loginId);
There are 2 items in this tableadapter commandcollection. The regular...
I would like to change this value in my code however its a read only property. Is there a way to dynamically set this value? I need it to point to different places depending on where the user is.
Thanks!
I have a Belkin router and every once in a while it seems to drop the connection and i can't get on the internet. However, I can still get to https sites (secured sites) just not regular http sites. If I restart the router everything starts working properly again. Does anyone know why this would...
I'm writing a procedure in a package. This procedure takes 3 in parameters:
appno number
userno number
action varchar2
I need to select rows from a table based on these 3 parameters however if the parameter is passed in null I don't want it in my where clause.
I thought of doing something like...
If I do this:
select 'here' as col1
select 'here2' as col1
it outputs two different resultsets. Is there a way to make this output one resultset with two rows (instead of two resultsets with one row each)?
Thanks!
I know this is doable:
select @MyVariable = ColumnName from MyTable where MyId = SomeInteger
Can you do it with multiple outputs? Something like this:
select @MyVariable1, @MyVariable2 = ColumnName1, ColumnName2 from MyTable where MyId = SomeInteger
Thanks!
Hello. I have the following circumstance and I can't change the table design.
Table 1 columns
ID - identity field
Types - varchar field of comma delmited number (example: 1,2,3)
Table 2 columns
TypeID - identity field
Type - varchar (examples: NEWS or TRAVEL or WHATEVER)
Let's say NEWS is...
I saw this question posted on another board over a year ago and didn't get any answer. I'm running into the same problem though and was hoping someone here could answer it. Thanks!...
I have a masterpage with a login link and would like the modalpopup window to show up with a login control when...
Where I work Viewstate is shut off for every project in the web.config. I'm told it's because viewstate is inefficient and unnecessary.
I was wanting to know if other programmers felt that way and what your reasons behind it might be? Or do you disagree with the statement?
i'm using Visio Professional 2003 version and creating a database diagram. I'm adding all the columns and datatypes using Visio's database properties window. When it creates the shape on the paper it has the PK and Column name, but doesn't show the datatype. How can I add the datatype into my...
I'm trying to create a new website in visual studio 2005. First I create the virtual directory in IIS and then I go create the website in visual studio using the http choice and I choose Local IIS. It then tells me that I must be a member of the administrators group on the local computer to use...
I hope someone can help with my div css code. I have a datagrid on the right side of the screen and some dropdowns on the left. Everything looks fine however if you shrink the browser screen, instead of getting a horizontal scroll, the divs overlap each other. Any ideas on how I can fix this...
I have a text file that looks like this:
test1
test2
test3
test4
and so on. How would I handle the situation if I had to delete "test3" from the text file. I really don't want to read this file and write to another one. Any ideas?
Thanks!
I'm trying to hide a div using the following code, however the items within the div are not disappearing. I know the logic of the javascript is working. I don't get any errors. Can anyone tell me what's wrong? Thanks!
Javascript:
function OnChange(dropdown)
{
var myindex =...
I have a textarea I create like this:
<asp:TextBox onkeydown="HandleKeyDown(this);" runat="server" ID="Comments" Rows="10" TextMode="MultiLine" Width="100%"></asp:TextBox>
In the javascript function I am able to figure out when the tab key is pressed. Now, I have some text like this in the...
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.