Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
Click here to go to dev.live.com for Windows Live developer resources
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  DAL works on local but not on production...?
Previous Previous
 
Next Next
New Post 5/14/2006 6:57 PM
User is offline Ryno
282 posts
9th Ranked




DAL works on local but not on production...? 
I'm stumped here.  I'm sure I'm forgetting something basic but...  I've got a custom module that works on my local machine.  It works on my production server too except the DAL keeps bringing back empty objects.  I know the table it uses has been copied over because I can use the host SQL page to bring it up.  But yet the DAL on the server keeps coming back with an empty object when I run the following Stored Procedure.  I don't know why?  I used CodeSmith's "ScriptTable" to transfer the Table to my server with the data.  I've used it before and haven't had any problems.  I'm stumped on this one though.  My SP is below and thanks to anyone that can point out my mistake:

CREATE PROCEDURE dbo.GetRynoStatAverages
    @StatType int,
    @Year int,
    @CommissionCode int,
    @AFSC char(10)
AS

If @AFSC='0' SET @AFSC=null

DECLARE @RecCount int
DECLARE @NumPriorE decimal(18,0)
/********** HAD to make this a decimal above because it's a SQL quirk *********
*******If you have A/B where A and B are both integers, the result will be 0 ******/
DECLARE @PctE decimal(18,0)
DECLARE @NumAAS decimal(18,0)
DECLARE @PctAAS decimal(18,0)
DECLARE @NumAAScc decimal(18,0)
DECLARE @PctAAScc decimal(18,0)
DECLARE @NumROTCcc decimal(18,0)
DECLARE @PctROTCcc decimal(18,0)
DECLARE @NumApplyENJPT decimal(18,0)
DECLARE @PctApplyENJPT decimal(18,0)
DECLARE @NumOnWaiver decimal(18,0)
DECLARE @PctOnWaiver decimal(18,0)
DECLARE @NumOTSasE decimal(18,0)
DECLARE @PctOTSasE decimal(18,0)
DECLARE @NumPriorGuardE decimal(18,0)
DECLARE @PctPriorGuardE decimal(18,0)
DECLARE @NumMale decimal(18,0)
DECLARE @PctMale decimal(18,0)
DECLARE @NumTechDegree decimal(18,0)
DECLARE @PctTechDegree decimal(18,0)
DECLARE @NumRated decimal(18,0)
DECLARE @PctRated decimal(18,0)
DECLARE @NumPPL decimal(18,0)
DECLARE @PctPPL decimal(18,0)
DECLARE @NumInstrument decimal(18,0)
DECLARE @PctInstrument decimal(18,0)
DECLARE @NumCommercial decimal(18,0)
DECLARE @PctCommercial decimal(18,0)
DECLARE @NumCFI decimal(18,0)
DECLARE @PctCFI decimal(18,0)
DECLARE @NumCFII decimal(18,0)
DECLARE @PctCFII decimal(18,0)
DECLARE @NumApplyPilot decimal(18,0)
DECLARE @PctApplyPilot decimal(18,0)
DECLARE @NumTrainingGrad decimal(18,0)
DECLARE @PctTrainingGrad decimal(18,0)
DECLARE @NumFCIqualified decimal(18,0)
DECLARE @PctFCIqualified decimal(18,0)
DECLARE @NumOnScholarship decimal(18,0)
DECLARE @PctOnScholarship decimal(18,0)

IF (@Year<>0)
BEGIN

    SELECT @RecCount = (SELECt Count(*) FROM RynoStats
                    WHERE [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

IF (@RecCount = 0)
BEGIN
RETURN @RecCount
END

    SELECT @NumPriorE = (SELECT COUNT(*) FROM RynoStats
                             WHERE [PriorE] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctE = @NumPriorE / @RecCount * 100

    SELECT @NumAAS = (SELECT COUNT(*) FROM RynoStats
                             WHERE [AASmember] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctAAS = @NumAAS / @RecCount * 100

SELECT @NumAAScc = (SELECT COUNT(*) FROM RynoStats
                             WHERE [AAScc] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctAAScc = @NumAAScc / @RecCount * 100
   
SELECT @NumROTCcc = (SELECT COUNT(*) FROM RynoStats
                             WHERE [ROTCcc] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctROTCcc = @NumROTCcc / @RecCount * 100

SELECT @NumApplyENJPT = (SELECT COUNT(*) FROM RynoStats
                             WHERE [ApplyENJPT] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctApplyENJPT = @NumApplyENJPT / @RecCount * 100

SELECT @NumOnWaiver = (SELECT COUNT(*) FROM RynoStats
                             WHERE [WaiverType] <> 0 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctOnWaiver = @NumOnWaiver / @RecCount * 100

SELECT @NumOTSasE = (SELECT COUNT(*) FROM RynoStats
                             WHERE [OTSasE] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctOTSasE = @NumOTSasE / @RecCount * 100

SELECT @NumPriorGuardE = (SELECT COUNT(*) FROM RynoStats
                             WHERE [PriorGuardE] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctPriorGuardE = @NumPriorGuardE / @RecCount * 100

SELECT @NumMale = (SELECT COUNT(*) FROM RynoStats
                             WHERE [MaleNotFemale] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctMale = @NumMale / @RecCount * 100

SELECT @NumTechDegree = (SELECT COUNT(*) FROM RynoStats
                             WHERE [TechnicalDegree] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctTechDegree = @NumTechDegree / @RecCount * 100

SELECT @NumRated = (SELECT COUNT(*) FROM RynoStats
                             WHERE [Rated] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctRated = @NumRated / @RecCount * 100

SELECT @NumPPL= (SELECT COUNT(*) FROM RynoStats
                             WHERE [PPL] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctPPL = @NumPPL / @RecCount * 100

SELECT @NumInstrument = (SELECT COUNT(*) FROM RynoStats
                             WHERE [Instrument] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctInstrument = @NumInstrument / @RecCount * 100

SELECT @NumCommercial = (SELECT COUNT(*) FROM RynoStats
                             WHERE [Commercial] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctCommercial = @NumCommercial / @RecCount * 100

SELECT @NumCFI = (SELECT COUNT(*) FROM RynoStats
                             WHERE [CFI] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctCFI = @NumCFI / @RecCount * 100

SELECT @NumCFII = (SELECT COUNT(*) FROM RynoStats
                             WHERE [CFII] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctCFII = @NumCFII / @RecCount * 100

SELECT @NumApplyPilot = (SELECT COUNT(*) FROM RynoStats
                             WHERE [ApplyPilot] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctApplyPilot = @NumApplyPilot / @RecCount * 100


SELECT @NumtrainingGrad = (SELECT COUNT(*) FROM RynoStats
                             WHERE [traininggrad] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @Pcttraininggrad = @Numtraininggrad / @RecCount * 100

SELECT @NumFCIqualified = (SELECT COUNT(*) FROM RynoStats
                             WHERE [FCIqualified] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctFCIqualified = @NumFCIqualified / @RecCount * 100

SELECT @Numonscholarship = (SELECT COUNT(*) FROM RynoStats
                             WHERE [scholarship] <> 0 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC AND
                             [COMMYEAR] = @YEAR)

    SELECT @PctOnScholarship = @NumOnscholarship / @RecCount * 100

SELECT
    AVG(GPA) AS GPA,
    AVG(PCSM) AS PCSM,
    AVG(PFT) AS PFT,
    AVG(OM) AS OM,
    AVG(RSS) AS RSS,
    @PctE AS PRIORE,
    @pctAAS as AASmember,
    @pctAAScc as AAScc,
    @pctROTCcc as ROTCcc,
    AVG(CampScore) AS campscore,
    AVG(AFOQT_Pilot) as AFOQT_PILOT,
    AVG(AFOQT_Nav) AS AFOQT_NAV,
    AVG(AFOQT_Quant) AS AFOQT_QUANT,
    AVG(AFOQT_Verbal) AS AFOQT_VERBAL,
    AVG(AFOQT_AA) AS AFOQT_AA,
    @pctApplyENJPT as ApplyENJPT,
    AVG(CCRankYou) AS CCRankYou,
    AVG(CCRankTotal) AS CCRankTotal,
    AVG(FlyHours) AS FLYHOURS,
    @pctOnWaiver as OnWaiver,
    AVG(CommYear) AS CommYear,
    @pctOTSasE as OTSasE,
    @pctPriorGuardE as PriorGuardE,
    AVG(Age) AS Age,
    @pctmale as MaleNotFemale,
    @pctTechDegree as TechnicalDegree,
    @pctRated as Rated,
    @pctPPL as PPL,
    @pctInstrument as Instrument,
    @pctCommercial as Commercial,
    @pctCFI as CFI,
    @pctCFII as CFII,
    @pctApplyPilot as ApplyPilot,
    @pctTrainingGrad as TrainingGrad,
    @pctFCIqualified as FCIqualified,
    COUNT(*) AS RecCount,
    MAX(gpa) as gpah,
    MIN(gpa) as gpal,
    MAX(pcsm) as pcsmh,
    MIN(pcsm) as pcsml,
    MAX(pft) as pftH,
    MIN(pft) as pftL,
    MAX(om) as omh,
    MIN(om) as oml,
    MAX(rss) as rssh,
    MIN(rss) as rssl,
    MAX(afoqt_pilot) as afoqt_piloth,
    MIN(afoqt_pilot) as afoqt_pilotl,
    MAX(afoqt_nav) as afoqt_navh,
    MIN(afoqt_nav) as afoqt_navl,
    MAX(afoqt_quant) as afoqt_quanth,
    MIN(afoqt_quant) as afoqt_quantl,
    MAX(afoqt_verbal) as afoqt_verbalh,
    MIN(afoqt_verbal) as afoqt_verball,
    MAX(afoqt_aa) as afoqt_aah,
    MIN(afoqt_aa) as afoqt_aal,
    MAX(ccrankyou) as ccrankyouH,
    MIN(ccrankyou) as ccrankyouL,
    MAX(flyhours) as flyhoursh,
    MIN(flyhours) as flyhoursl,
    MAX(age) as ageh,
    MIN(age) as agel,
    @PctOnScholarship as OnScholarship

   
FROM RynoStats
WHERE
    [STATTYPE] = @StatType AND
    [COMMISSIONCODE] = @CommissionCode AND
    [AFSC] = @AFSC AND
    [COMMYEAR] = @YEAR
GROUP BY
    [COMMYEAR]
ORDER BY
    [COMMYEAR]

END

IF (@Year=0)
BEGIN

SELECT @RecCount = (SELECt Count(*) FROM RynoStats
                    WHERE [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)

IF (@RecCount = 0)
BEGIN
RETURN @RecCount
END

    SELECT @NumPriorE = (SELECT COUNT(*) FROM RynoStats
                             WHERE [PriorE] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctE = @NumPriorE / @RecCount * 100

    SELECT @NumAAS = (SELECT COUNT(*) FROM RynoStats
                             WHERE [AASmember] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctAAS = @NumAAS / @RecCount * 100

SELECT @NumAAScc = (SELECT COUNT(*) FROM RynoStats
                             WHERE [AAScc] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctAAScc = @NumAAScc / @RecCount * 100
   
SELECT @NumROTCcc = (SELECT COUNT(*) FROM RynoStats
                             WHERE [ROTCcc] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctROTCcc = @NumROTCcc / @RecCount * 100

SELECT @NumApplyENJPT = (SELECT COUNT(*) FROM RynoStats
                             WHERE [ApplyENJPT] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)

    SELECT @PctApplyENJPT = @NumApplyENJPT / @RecCount * 100

SELECT @NumOnWaiver = (SELECT COUNT(*) FROM RynoStats
                             WHERE [WaiverType] <> 0 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )
    SELECT @PctOnWaiver = @NumOnWaiver / @RecCount * 100

SELECT @NumOTSasE = (SELECT COUNT(*) FROM RynoStats
                             WHERE [OTSasE] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctOTSasE = @NumOTSasE / @RecCount * 100

SELECT @NumPriorGuardE = (SELECT COUNT(*) FROM RynoStats
                             WHERE [PriorGuardE] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)

    SELECT @PctPriorGuardE = @NumPriorGuardE / @RecCount * 100

SELECT @NumMale = (SELECT COUNT(*) FROM RynoStats
                             WHERE [MaleNotFemale] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)

    SELECT @PctMale = @NumMale / @RecCount * 100

SELECT @NumTechDegree = (SELECT COUNT(*) FROM RynoStats
                             WHERE [TechnicalDegree] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctTechDegree = @NumTechDegree / @RecCount * 100

SELECT @NumRated = (SELECT COUNT(*) FROM RynoStats
                             WHERE [Rated] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctRated = @NumRated / @RecCount * 100

SELECT @NumPPL= (SELECT COUNT(*) FROM RynoStats
                             WHERE [PPL] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)

    SELECT @PctPPL = @NumPPL / @RecCount * 100

SELECT @NumInstrument = (SELECT COUNT(*) FROM RynoStats
                             WHERE [Instrument] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctInstrument = @NumInstrument / @RecCount * 100

SELECT @NumCommercial = (SELECT COUNT(*) FROM RynoStats
                             WHERE [Commercial] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctCommercial = @NumCommercial / @RecCount * 100

SELECT @NumCFI = (SELECT COUNT(*) FROM RynoStats
                             WHERE [CFI] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)
    SELECT @PctCFI = @NumCFI / @RecCount * 100

SELECT @NumCFII = (SELECT COUNT(*) FROM RynoStats
                             WHERE [CFII] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctCFII = @NumCFII / @RecCount * 100

SELECT @NumApplyPilot = (SELECT COUNT(*) FROM RynoStats
                             WHERE [ApplyPilot] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctApplyPilot = @NumApplyPilot / @RecCount * 100

SELECT @NumtrainingGrad = (SELECT COUNT(*) FROM RynoStats
                             WHERE [traininggrad] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )
    SELECT @Pcttraininggrad = @Numtraininggrad / @RecCount * 100

SELECT @NumFCIqualified = (SELECT COUNT(*) FROM RynoStats
                             WHERE [FCIqualified] = 1 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC)

    SELECT @PctFCIqualified = @NumFCIqualified / @RecCount * 100

SELECT @Numonscholarship = (SELECT COUNT(*) FROM RynoStats
                             WHERE [scholarship] <> 0 AND
                    [STATTYPE] = @StatType AND
                    [COMMISSIONCODE] = @CommissionCode AND
                             [AFSC] = @AFSC )

    SELECT @PctOnScholarship = @NumOnscholarship / @RecCount * 100


SELECT
    AVG(GPA) AS GPA,
    AVG(PCSM) AS PCSM,
    AVG(PFT) AS PFT,
    AVG(OM) AS OM,
    AVG(RSS) AS RSS,
    @PctE AS PRIORE,
    @pctAAS as AASmember,
    @pctAAScc as AAScc,
    @pctROTCcc as ROTCcc,
    AVG(CampScore) AS campscore,
    AVG(AFOQT_Pilot) as AFOQT_PILOT,
    AVG(AFOQT_Nav) AS AFOQT_NAV,
    AVG(AFOQT_Quant) AS AFOQT_QUANT,
    AVG(AFOQT_Verbal) AS AFOQT_VERBAL,
    AVG(AFOQT_AA) AS AFOQT_AA,
    @pctApplyENJPT as ApplyENJPT,
    AVG(CCRankYou) AS CCRankYou,
    AVG(CCRankTotal) AS CCRankTotal,
    AVG(FlyHours) AS FLYHOURS,
    @pctOnWaiver as OnWaiver,
    AVG(CommYear) AS CommYear,
    @pctOTSasE as OTSasE,
    @pctPriorGuardE as PriorGuardE,
    AVG(Age) AS Age,
    @pctmale as MaleNotFemale,
    @pctTechDegree as TechnicalDegree,
    @pctRated as Rated,
    @pctPPL as PPL,
    @pctInstrument as Instrument,
    @pctCommercial as Commercial,
    @pctCFI as CFI,
    @pctCFII as CFII,
    @pctApplyPilot as ApplyPilot,
    @pctTrainingGrad as TrainingGrad,
    @pctFCIqualified as FCIqualified,
    COUNT(*) AS RecCount,
    MAX(gpa) as gpah,
    MIN(gpa) as gpal,
    MAX(pcsm) as pcsmh,
    MIN(pcsm) as pcsml,
    MAX(pft) as pftH,
    MIN(pft) as pftL,
    MAX(om) as omh,
    MIN(om) as oml,
    MAX(rss) as rssh,
    MIN(rss) as rssl,
    MAX(afoqt_pilot) as afoqt_piloth,
    MIN(afoqt_pilot) as afoqt_pilotl,
    MAX(afoqt_nav) as afoqt_navh,
    MIN(afoqt_nav) as afoqt_navl,
    MAX(afoqt_quant) as afoqt_quanth,
    MIN(afoqt_quant) as afoqt_quantl,
    MAX(afoqt_verbal) as afoqt_verbalh,
    MIN(afoqt_verbal) as afoqt_verball,
    MAX(afoqt_aa) as afoqt_aah,
    MIN(afoqt_aa) as afoqt_aal,
    MAX(ccrankyou) as ccrankyouH,
    MIN(ccrankyou) as ccrankyouL,
    MAX(flyhours) as flyhoursh,
    MIN(flyhours) as flyhoursl,
    MAX(age) as ageh,
    MIN(age) as agel,
    @PctOnScholarship as OnScholarship
   
FROM RynoStats
WHERE
    [STATTYPE] = @StatType AND
    [COMMISSIONCODE] = @CommissionCode AND
    [AFSC] = @AFSC

END
GO


I use DNN version 4.8.1
 
New Post 5/14/2006 7:55 PM
User is offline Ryno
282 posts
9th Ranked




Re: DAL works on local but not on production...? 
Modified By Ryno  on 5/14/2006 10:57:20 PM)
I know the database table is there.  A different controller class is able to fill a different info object with it.  So that's good.

But it still doesn't explain why this stored procedure isn't filling an object like it does on my local machine.  I've copied the database and stored procedure and PA over several times now...rebuilt it several times...I just can't figure it out.  I'm about to call uncle.

I trimmed down this SP just to see if it worked at all...  And even when I hardcoded the values to return it still sent an empty object back.

I use DNN version 4.8.1
 
New Post 5/14/2006 8:53 PM
User is offline Ryno
282 posts
9th Ranked




Re: DAL works on local but not on production...? 
Figured it out.  My AFSC field wasn't registering as null when I transferred the data over.  Who would have thought it all worked like it was supposed to and I had made a mistake?

I use DNN version 4.8.1
 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  DAL works on local but not on production...?
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


BataviaSoft DotNetNuke Solutions
BataviaSoft offers custom DotNetNuke solutions especially for the European and the South East Asian market.
www.bataviasoft.com
Viva Portals, L.L.C.
Expert module development and graphic design.
www.continure.com
DNN Photo Gallery
DNN Photo Gallery is a truly unique photo management module released January 1st 2006. With DNN Photo Gallery you can REALLY integrate images into your existing portal and make them look like they were designed for your site.
DNN Photo Gallery

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP