Bill
I don't know ColdFusion, so I don't know how you're connecting CF to
Universe or what CF is doing - but UniVerse SQL *definitely* supports joins.
And if you can't get CF to build it, if you can get it to call stored
procedures you can also lovingly hand craft your UniVerse SQL <grin> and
wrap it into a subroutine as in the example below:
SUBROUTINE MySub
SQL = "SELECT ..."
Ok = SQLExecDirect(@HSTMT, SQL)
RETURN
And call it using the SQL CALL statement:
set dbConn = CreateObject("ADODB.Connection")
dbConn.Open conStr, userId, pass
WScript.echo "Connected"
Set dbCmd = CreateObject("ADODB.Command")
Set dbCmd.ActiveConnection = dbConn
' set the command text to a SQL query
dbCmd.CommandText = "CALL MySub"
dbCmd.CommandType = 1
' Execute the command
tab = chr(9)
Set rs = dbCmd.Execute
Do While Not rs.EOF
Wscript.Echo rs(0) & tab & rs(1) & tab & rs(2)
rs.MoveNext
Loop
Brian
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Bill Brutzman
Sent: 26 July 2011 15:35
To: U2 Users List
Subject: [U2] What - No Joins?
So I am still dabbling with ColdFusion. It is satisfying to be able to
connect Flex <-> CF <-> UniVerse and see data.
When data appears in say two tables, the traditional CF way to grab the data
is with al SQL INNER JOIN statement.
It seems like all that I can do with CF and UniVerse is something like...
SELECT * FROM LATE_LIST and then SELECT * FROM SALES_ORDERS and then
combine the two resulting arrays in CF.
CF will show I-Descriptors in the list of table contents when invoked via an
@SELECT in the dictionary... but, my CF program did not grab any data from
this same I-Descriptor.
In advance of my printing out Rocket's UniVerse SQL tech manual... tips and
tricks would not hurt my feelings.
--Bill
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
