|
|
[Q]The SQL is something like[/Q]Your SQL, as it stands, looks OK to me, except
you have an unnecessary extra set of ( ) around your select statement.
insert into fu_dokument_status (oid, benutzer, status, datum)
select 123, 'asdf', 'gelesen', sysdate
from dual
where not exists (select *
from fu_dokument_status
where oid=123
and benutzer='asdf'
and status='gelesen' )
Having said that, you obviously provided the SQL [i]after[/i] parameter
substitutions have been made, and it would have been much more useful to see
the actual CF code that you are using, you know, what is actually contained in
your CFQUERY. I suspect that there may be something else going on with the way
that it is written. Generic "something like" isn't terribly helpful.
Phil
|
|