MyGeneration DAL help

[baden100]

I'm having trouble creating a query that compares values in the same table, ie:

Code:
SELECT [fields]
FROM

WHERE column1 = column2


It's simple to compare a field value to another value, ie
WHERE column1 = 332.55;

But having issues with the first one:
Code:
entCards.Where.AprCashNUM.Value = 10;
entCards.Where.AprCashNUM.Operator = WhereParameter.Operand.LessThan;
entCards.Where.BalTransFee.Conjuction = WhereParameter.Conj.And;
entCards.Where.IntroductoryRateNUM.Value = entCards.Where.AprPurchNUM.Value;


Something like this. So in this query I want all values less than 10 (which works) and vwhere IntroRate = AprPurch.


Can someone help me with this?


Thanks.

 

[vbkris]

thats strange, that query must work. do u have sample data???

Known is handfull, Unknown is worldfull

 

[SQLBill]

That code looks strange. That IS for Microsoft SQL Server isn't it? (That's what this forum is for).

-SQLBill

Posting advice: FAQ481-4875

 

[baden100]

Hey guys... yeah, I know this is for SQL Server, and I'm using MyGeneration's d00dad's DAL architecture for SQL Server.

Thought someone here may be able to lend a hand to this.

 

[SQLBill]

I'm having trouble following your WHERE code. I'm not at all familiar with MyGeneration.

But, isn't that code in the wrong order? Shouldn't it be:

entCards.Where.AprCashNUM.Operator = WhereParameter.Operand.LessThan; 
entCards.Where.AprCashNUM.Value = 10;
entCards.Where.BalTransFee.Conjuction = WhereParameter.Conj.And; 
entCards.Where.IntroductoryRateNUM.Value = entCards.Where.AprPurchNUM.Value;

(remember, I don't know MyGeneration code. So I could be wrong)

Why don't you think it's working? Are you getting an error? Are you getting wrong data results? If you are getting an error, please post it. If you are getting wrong data results, can you provide 1)sample data, 2)what you are getting returned, and 3) what you want returned?

-SQLBill

Posting advice: FAQ481-4875