Issue using TeamSite::PT::iw_sql_open

jyoti35

I need to pick up some database entires and show it on my page. However my project is structured such that page tpl file includes other small module tpl files.. as a result a direct in-line comment to read data from db doesnt work for me.

To sort this out, i am using the TeamSite:T::iw_sql_open, so that i can use it in my module tpl files and access data on the main page tpl. I am using the following code to acheive this -

beg- iw_sql_open data_source = "dbiracle:"
user_name = "starcms"
password = "cmsstar"
aux_env = "ORACLE_HOME => '/export/home0/oracle/app/oracle/product/9.2.0',
ORACLE_SID => 'TTDT'">
close - iw_sql_open
(the tags get parsed automatically and hence usage of "beg" and "close")
All the above parameters are correct, i.e. the username, pwd, SID, Oracle home etc. But when i run it, it doesnt give me any results. I have not included anything other than to be able to access the DB?

Is this not sufficient enough? Any other suggestions? I tried debugging using the iwpt_compile.ipl but there is not much useful information there as well

Adam Stoller

I need to pick up some database entires and show it on my page. However my project is structured such that page tpl file includes other small module tpl files.. as a result a direct in-line comment to read data from db doesnt work for me. To sort this out, i am using the TeamSite:T::iw_sql_open, so that i can use it in my module tpl files and access data on the main page tpl. I am using the following code to acheive this - beg- iw_sql_open data_source = "dbiracle:" user_name = "starcms" password = "cmsstar" aux_env = "ORACLE_HOME => '/export/home0/oracle/app/oracle/product/9.2.0', ORACLE_SID => 'TTDT'"> close - iw_sql_open (the tags get parsed automatically and hence usage of "beg" and "close") All the above parameters are correct, i.e. the username, pwd, SID, Oracle home etc. But when i run it, it doesnt give me any results. I have not included anything other than to be able to access the DB? Is this not sufficient enough? Any other suggestions? I tried debugging using the iwpt_compile.ipl but there is not much useful information there as well

I tend to use <iw_perl>...</iw_perl> blocks and use Perl's DBI to do my DB interactions - most often you need a BEGIN { ... }; block to do the environment setting information to which I would probably add a PATH environment setting in addition to the two you show above.

Doing it this way allows me to make a simple command-line script first, with the same code in it - to verify the DB calls and results, then use the same code within my PT.

If you have the DBD:racle built - you should probably use it - otherwise you can probably use the built-in ODBC connection parameters - I believe it's something like DBI->connect("DBI:DBC::$dsn", $user, $password)

I've just done this at my current customer's site with minimal problems - but I don't have a copy of the sources with me right now to reference the code used.