Hello, just to close this issue and to document how I resolved this problem:
It has something to do with the "dbvarname" attribute to "cfprocparam". This one fails: <cfstoredproc procedure="is_authorized" datasource="#Application.DSN#" returncode="yes"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="fp_user" value="#session.username#"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="fp_proc" value="READ_ALTDAT_MENUE"> </cfstoredproc> This one works: <cfstoredproc procedure="is_authorized" datasource="#Application.DSN#" returncode="yes"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="fp_user" value="#session.username#"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" value="READ_ALTDAT_MENUE"> </cfstoredproc> Difference: "dbvarname" removed in the second <cfprocparam>. In theory it also works well with all dbvarname attributes removed. I don't really know what "dbvarname" attributes are meant to be used for? Maybe this is a bug in OpenBD? Yours Manuel -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
