Im just trying to display the companyname who is having the size greater than 0 and sizeprice greater than the given price and less that another given price. So 'siz' mentions the size, if it come B1 so i thought it can be concatenete to get the another column B1price, so i gave so.Based upon the selection this siz wil vary like b1,b2,b3,b4... wen the siz varies, the sizeprice will also vary like b1price,b2price,b3price,b4price....
On Mon, Jun 22, 2009 at 3:47 PM, ramesh das <[email protected]> wrote: > i think you are doing some mistake here which is red > "Select distinct sno,companyname,mobileno from Real where Emi='" & emira > & "' and count('" & siz & "')>0 and '" & siz & "'price<='" & price & "' > and '" & siz & "'price>'" & rentprice & "' and area='" & > area.SelectedItem.Text" > regards > http://www.sourcecode4you.com/ > Dim emira, siz, price, rentprice As String" > emira = emi.SelectedItem.Text (Place) > > siz = size.SelectedItem.Text (Eg: 0,1, 2, 3) > > Dim strsql As String > > strsql = > "Select distinct sno,companyname,mobileno from Real where Emi='" & emira & > "' and count('" & siz & "')>0 and '" & siz & "'price<='" & price & "' and '" > & siz & "'price>'" & rentprice & "' and area='" & area.SelectedItem.Text & > "'" > > On Mon, Jun 22, 2009 at 3:58 PM, Jeena Ajiesh <[email protected]>wrote: > >> Hi all, >> While i was trying to select some records from db it show 1 error, >> >> *An aggregate may not appear in the WHERE clause unless it is in a >> subquery contained in a HAVING clause or a select list, and the column being >> aggregated is an outer reference. >> * >> How can i solve this problem? >> >> My sql query is as follows >> >> Dim emira, siz, price, rentprice As String >> >> emira = emi.SelectedItem.Text (Place) >> >> siz = size.SelectedItem.Text (Eg: 0,1, 2, 3) >> Dim strsql As String >> >> strsql = >> "Select distinct sno,companyname,mobileno from Real where Emi='" & emira >> & "' and count('" & siz & "')>0 and '" & siz & "'price<='" & price & "' >> and '" & siz & "'price>'" & rentprice & "' and area='" & >> area.SelectedItem.Text & "'" >> Can anyone help me to modify this query? >> >> -- >> **************** >> Thanks & Regards, >> Jeena Ajiesh >> Email: [email protected] >> [email protected] >> >> > -- **************** Thanks & Regards, Jeena Ajiesh Email: [email protected] [email protected]
