[ic] Null query result cause internal error

Danilo Ingami kosmo at trslab.it
Thu Jan 29 10:12:41 EST 2004


Hi list members,
I need to evaluate if a record is present in a table wile i build a 
multiple checkbox table.
I do that with this code

[data table=prodmods col=prodmod_id key=1 foreign.0="model_id=99" 
foreign.1="sku=166"]

and it works well if  the model_id and sku will be found in the prodmods 
table, and I see the performed queries in the mysql log.

Query       select prodmod_id from prodmods WHERE model_id = '882' AND 
sku = '166'
Query       select prodmod_id from prodmods where prodmod_id = 10

but if I search for a non existent model_id or sku I'll got an error, 
the code stopping to run and in the mysql log I'll see that queries:
Query       select prodmod_id from prodmods WHERE model_id = '99' AND 
sku = '166'
Query       select prodmod_id from prodmods where prodmod_id =

the second query is the problem, but why IC make that?

I have tried to put an if  before the data, and with this code
[if type=data table=prodmods col=prodmod_id key=1 
foreign.0="model_id=99" foreign.1="sku=166"]
    true
[else]
    false
[/else]
[/if]
I'll got always a false result.

how can I escape from there?
any help will be really appreciated.
thanks
danilo


More information about the interchange-users mailing list