Either OCI or JDBC. We don't use ODBC. And we're migrating to
entirely JDBC for more than one reason.
On Jul 28, 2005, at 10:43 AM, Robert Garcia wrote:
Are you connecting to Oracle via OCI, JDBC, or ODBC? I have found
issues that I come across in one, may not be a problem in another.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jul 28, 2005, at 7:34 AM, Dale Graham wrote:
Yes, and after I said this, I happened to be looking at the
Witango help manual, and it says that the zero row IS returned for
direct DBMS as well as Witango actions.
All I know is that for Oracle, this is NOT the case, direct DBMS
does not return the zero row information, which is a real pain
sometimes. (I should have specified the DB, my bad)
On Jul 28, 2005, at 10:05 AM, Robert Garcia wrote:
I am working on a project now, where I use several DBMS actions,
and the zero row column is intact. I wonder if certain DBs do or
don't support? I am using primebase on this one. Sounds like a
question for support.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jul 28, 2005, at 3:23 AM, Dale Graham wrote:
Zero row data is NOT returned if you use a direct DBMS action as
opposed to a Witango action.
Though it is tedious, you CAN, however, assign the value of the
zero rows via manual coding. (Help yourself out, do a Witango
select on 1 row's data - get the zero row from that, and use it
to help set up the manual coding)
I have had best success with a piece-by-piece method:
<@assign name="request$myarray[0,1]" value="idnumber">
<@assign name="request$myarray[0,2]" value="lastname">
etc
Though it also possible to do this as follows, sometimes this
fails for me, so I have started avoiding it..
<@assign name="request$myarray[0,*]" value="<@array
value='idnumber,lastname' cdelim=',' rdelim=';'>">
On Jul 27, 2005, at 9:23 PM, MJPinckard wrote:
Well I can't seem to extract anything from @@resultset[0,1] -
it's empty
I'd be delighted to use a stored procedure, but at this point,
it is beyond my Oracle abilities to create... anyone have a
good primer on making stored procedures (or code I can utilize)?
cheers,
Maggie
Peter Dobbs wrote:
You receive the column names in position 0 of the resultset.
i.e. @@local$resultset[0,1] is the column name of column 1.
Also, if you want to do something like this, make a stored
procedure to do
it and call the stored procedure from a directDBMS action. No
point of
bringing the info into Tango unless you are not comfortable
with stored
procedures in which case doing it in tango will work just fine!
p.
-----Original Message-----
From: MJPinckard [mailto:[EMAIL PROTECTED] Sent: Wednesday,
July 27, 2005 7:46 PM
To: Witango
Subject: Witango-Talk: duplicating a row in Oracle
I'm trying to add an option for users to clone their user
session.
I have a table with ~500 columns (yeah I know, but that's how
it's structured, legacy code...ugh).
I want to duplicate this row, changing only the primary key
(session_id). Since it is not inconceivable that the column
structure might change someday, I'd like to make the code as
generic as possible (not coding each column into an update or
insert action).
Using directDBMS, I can easily extract all the existing data
using the following code.
select * from Input where session_id=someNumber
But this gives me data only (no column names) and in any event
I can't figure out how to get the data into another row. I've
tried a variety of different ways (using both INSERT and
creating a row in another action then performing an UPDATE)
but can't get anything to work.
Has anyone any suggestions about how I might accomplish this?
I'm about to give in and manually code all 500 columns into an
insert action... but surely there has got to be an easier way...
Mac OS X server
Witango 5.0.9 (I think)
Oracle db using Oracle OCI drivers.
Thanks for any assistance.
Cheers,
Maggie Pinckard
Principal Research Associate
Lawrence Berkeley National Laboratory
_________________________________________________________________
_______
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
_________________________________________________________________
_______
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
__________________________________________________________________
______
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
___________________________________________________________________
_____
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
____________________________________________________________________
____
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
