Re: [IBPP-DISCUSS] problem setting statement parameter

[Mark Di N. <ma...@mm...>]

forget that. stupid me saw it right after i sent the email.

Mark Di Nicola wrote:
> i'm trying to set a parameter for a statement but when i go to execute 
> the statement i get
> 
> *** IBPP::LogicException ***
> Context: Statement::Execute
> Message: All parameters must be specified.
> 
> it seems like what i'm doing is pretty straight forward...
> 
> void UpdateFile::process02Record(int itemID)
> {
>  std::string sql = "SELECT 'A', ACTORS.DISPLAYNAME "
>              "FROM ACTORS "
>              "JOIN ACTORITEM ON ACTORS.ACTORID = ACTORITEM.ACTORID "
>              "WHERE ACTORITEM.ITEMID = ? "
>              "ORDER BY ACTORITEM.ACTORID";
> 
>  IBPP::Statement st = dataMgr.createStatement();
>  st->Prepare(sql);
>  st->Set(1, itemID);
>  st->Execute(sql); <-- exception occurs here because 
> mInRow->MissingValues() == true
>  ...
> 
> is there something i'm doing wrong?
> 
> TIA
> 
> 
>