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
