[PHP-DB] Re: Nested SQL query problem...

2002-05-30 Thread Hugh Bothwell
"Srinivasan Ramakrishnan" <[EMAIL PROTECTED]> wrote in message 004701c206df$5a00f100$[EMAIL PROTECTED]">news:004701c206df$5a00f100$[EMAIL PROTECTED]... > The slabs do not continue for an infinite number, hence I may only have slab > pricing for 1-10, 11-100, and 101-200 with the assumption that i

[PHP-DB] Re: Nested SQL query problem...

2002-05-29 Thread Frank Flynn
Fundamentally you're problem is not having a way to represent "infinite" as the max value (TInt_EndSlab). The problem, which you clearly state, comes when you have slabs: 1-10, 11-100, and 101-200 and look for 500. Under this scheme there is no record that matches, nor can there be one because 5

[PHP-DB] Re: Nested SQL query problem...

2002-05-29 Thread Zubarev Andrey
Hello Srini, Don't speak english! :-) >For example, what is the cost of 500 licenses of Product_ID 143 ? >The slabs do not continue for an infinite number, hence I may only have slab >pricing for 1-10, 11-100, and 101-200 with the assumption that if there are >no higher slabs and I wanted say th