Hi David, In Witango 5.5 parameters that can be bound are automatically bound for search/insert/update/delete actions. In previous versions some but not all were automatically bound.
If using a Direct DBMS however you can also use the <@bind> metatag which instructs the Witango Server to generate the appropriate calls. I have attached a simple example demonstrating the <@bind> metatag in a Direct DBMS which calls a stored procedure. This essentially allows you to retrieve more than one result from the stored procedure. I have included the stored procedure, which does a select all, then an insert and then retrieves the ID of the record just inserted. Thus the stored procedure returns all the records in the table and the value of the identity. The resultset of the DBMS is the array generated by "select * from people" while (using <@bind>) the value of the identity is assigned to the variable "int_sample_id". The resultset will be assigned to the first result of the sql while proceeding results can be retrieved/assigned using <@bind>. I hope this answers your question - if I can be of further assistance please do not hesitate to contact me. Fergal Fergal Donlon Technical Engineer Witango Technologies, Suite 4, Level 1, 44 Miller Street, North Sydney, 2060 ----- Original Message ----- From: "David Simmeth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 12, 2004 1:41 PM Subject: Witango-Talk: Bind variables > Is it possible to use bind variables when making SQL queries through > witango? We are using Witango 5 on Windows 2000 with an ODBC connection to > Oracle 8. > > -- David > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
bind_metatag.taf
Description: Binary data
