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]
>
>
