[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