t;
> -Original Message-
> From: sqlite-users-boun...@sqlite.org on behalf of Darren Duncan
> Sent: Mon 12/14/2009 2:44 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Using Parameters with views
>
> Do bind parameters work for you if you r
"=" breaks it.
-Original Message-
From: sqlite-users-boun...@sqlite.org on behalf of Darren Duncan
Sent: Mon 12/14/2009 2:44 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Using Parameters with views
Do bind parameters work for you if you replace the view wit
Do bind parameters work for you if you replace the view with a subselect?
Does this work for you?
select * from (
select t1.*,
(select count(*) from song_artist t2 where t1.artist_id=t2.artist_id) as CNT
from artists
) where CNT=:PARAM
-- Darren Duncan
Cariotoglou Mike wrote:
> I don't
I don't know if this has come up before, is so please point me to the
right direction :)
I believe that using parameterized queries with views does not work
as expected.
consider this (more or less self-explanatory) schema:
create table artists(artist_id)
create table songs(song_id)
create table
4 matches
Mail list logo
