Comments by Ryanm1324 (Top 23 by date)

When I try to use the one and query the Oracle 7.3.4 db I keep getting this:
"ORA-3134: Connections to this server version are no longer supported." "Oracle Data Provider for .NET"
Sorry, Im not sure what Im doing wrong

This error occurrs though:

The provider is not compatible with the version of Oracle client

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

I mention it because that is the exact error showing in Visual Studio.

Where I have a control, this error shows. So one of them is a label and instead of showing the label, it shows:
Error Creating Control - lblMsg
Error HRESULT E_FAIL has been returned from a call to a COM component.

I dont need a COM component.

Thanks for your help. I got it to work using the hidden field approach.

This seems to run the page_load event twice and on the second one qsUIMODE is NULL. The modal window then closes, but I need it to be open

I updated jQuery and used $("*[id$='btnSearch']").click();
It is now working.
Thank you for all your help with this. I will for sure be using Chrome to debug now.

When I put if(jQuery().pluginName) before the call to click the button it does not get run. Does this mean that the jQuery is being loaded. I have <script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script> but is this correct

Here is the button
<asp:Button ID="btnSearch" runat="server" Text="Reload"
onclick="btnSearch_Click"/>
But when I view it in the chrome debugger it is
<input type="submit" name="ctl00$MainContent$btnSearch" value="Reload" id="MainContent_btnSearch" />
Should I be using MainContent_btnSearch?

It shows Uncaught TypeError: Cannot call method 'click' of null Default.aspx:173
NewTxOkay Default.aspx:173
(anonymous function)

ok Ill try that

Ive never done that. What do I need to do

The button is there. It calls a click event in the codebehind which just has gridview.databind();

I tried that just now and it still gives me Microsoft JScript runtime error: 'null' is null or not an object

I tried to go through these examples, but keep getting t1.balanceItem, t1.change, and t1.balance invalid identifier.

Here is how it converted into SQL:

SELECT t1."Employee", t1."Limit",
(CASE
WHEN t1."Dependant1" IS NULL THEN 0
ELSE t1."Dependant1"
END) AS C1, t1."LimitName", t1."FirstName", t1."Title", t1."FirstName" AS "FirstName1", t1."MiddleName", t1."LastName",
DECODE(sum(t1."Balance"),null,'N','Y'),DECODE( sum(t1."Change"),null,'N','Y'), DECODE(sum(t1."BalanceItem"),null,'N','Y')
FROM (
SELECT t2.EMPLOYEE AS "Employee", t3.LIMIT AS "Limit", t4.DEPENDANT AS "Dependant1", t3.LIMIT_NAME AS "LimitName",
t4.DEPENDANT_NAME AS "DependantName", t4.TITLE AS "Title", t4.FIRST_NAME AS "FirstName", t4.MIDDLE_NAME AS "MiddleName",
t4.LAST_NAME AS "LastName", t2.BALANCE AS "Balance", t2.CHANGE AS "Change", t2.BALANCE_ITEM AS "BalanceItem"
FROM PHSP.EMPLOYEE_LIMIT t2
INNER JOIN PHSP.LT_LIMIT t3 ON t2.LIMIT = t3.LIMIT
LEFT OUTER JOIN PHSP.DEPENDANT t4 ON t2.DEPENDANT = t4.DEPENDANT
WHERE t2.EMPLOYEE = 1021493
GROUP BY t2.EMPLOYEE, t3.LIMIT, t4.DEPENDANT, t3.LIMIT_NAME, t4.DEPENDANT_NAME, t4.TITLE, t4.FIRST_NAME, t4.MIDDLE_NAME,
t4.LAST_NAME, t2.BALANCE, t2.CHANGE, t2.BALANCE_ITEM
) t1
group by t1."Employee", t1."Limit",t1."Dependant1", t1."LimitName",t1."Title", t1."FirstName" , t1."MiddleName", t1."LastName"
ORDER BY t1."LimitName"

Is there something else needed when trying to get the sum

Thanks

I somewhat have it working right now except for the decode (SUM(... last three columns. Not too sure about that part.
This is what I have so far:

from e in empLimHeader.EmployeeLimits
where e.Employee == Convert.ToDouble(txtEmployee.Text)
join l in empLimHeader.LtLimits on e.Limit equals l.Limit
join d in empLimHeader.Dependants on e.Dependant equals d.Dependant1
group d by new
{
e.Employee,
l.Limit,
d.Dependant1,
l.LimitName,
d.DependantName,
d.Title,
d.FirstName,
d.MiddleName,
d.LastName//,
// e.Balance,
//e.Change,
// e.BalanceItem
} into limHeader
orderby limHeader.Key.LimitName
select new
{
employee = limHeader.Key.Employee,
limit = limHeader.Key.Limit,
dependantNum = (limHeader.Key.Dependant1 == null ? 0 : limHeader.Key.Dependant1),
limitName = limHeader.Key.LimitName,
dependant = limHeader.Key.DependantName,
title = limHeader.Key.Title,
firstName = limHeader.Key.FirstName,
middleName = limHeader.Key.MiddleName,
lastName = limHeader.Key.LastName//,
// hasCash = (limHeader.Sum(a => limHeader.Key.Balance) == null ? 'N' : 'Y'),
// hasCashChange = (limHeader.Sum(a => limHeader.Key.Change) == null ? 'N' : 'Y'),
//hasItem = (limHeader.Sum(a => Convert.ToDouble(limHeader.Key.BalanceItem.ToString())) == null ? 'N' : 'Y')
};