pass parameters to CGI call out

In my DCT, I want to populate the second field based on the first. (not using FormAPI Smiley Wink

I have a combo box where user will select any values say "A" and the next field is browse button. When user will click on the browse button a cgi callout is being used which extract the files from the database/table matching criteria "A" and display to the user and user should be able to select the files. But I am not clear how do I pass "A" as an parameter dynamically to my cgi callout..
can anyone assist on this ?

Find more posts tagged with

Comments

Adam Stoller

What version of TeamSite are you using?
Is this a TeamSite Templating / FormsPublisher DCT callout or a Metadata Capture DCT callout?

If the former (TST DCT) - you should be able to access the data for field "A" by looking in $cgi->{form}{"A"} - so you don't need to pass anything.

If the latter (MDC DCT), and you're using 6.5 - you'll need a patch from Interwoven (unless this got fixed in SP2? - I lost my access to the support site, can't get the release notes anymore) to allow you to retrieve named fields in MDC DCT callouts.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

amar_maheshwary

Hi, thanks for your reply
I am using teamsite6.5 + Win2k

This is TST DCT ..so if my DCT is something this structure
container == article
== item = article_name

then in the cgi i ll be able to access this

$cgi->{form}{"article/article_name"} ??

Johnny

Try it yourself - you can set the callout to be the showenv.cgi - which is a debugging cgi supplied by Interwoven. It displays everything that was passed through.

You can use that in any setting to find out what's going on.

John Cuiuli

report.zip

amar_maheshwary

Thanks, I am able to resolve this :-) by just writing a small loop

foreach ( @Param ){
$param{$_} = $cgi->param($_);
print "<b>$cgi->param($_)</b></br>";
}

able to access everything in my form from the cgi

amar_maheshwary

continuing in the same problem

when I am trying to run my cgi script o fetch data from database on click of button it throws me following error

Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (SQL-28000)(DBD: db_login/SQLConnect err=-1)

and if I run the same cgi script from command line it runs perfectly fine .. the only difference can be user id who is running the script but it has no relation to the database becasue parameters (dsn,user id, password) to the function connecting to db are same

any pointers why its happening

amar_maheshwary

any ideas/pointers why its happening

Adam Stoller

This comes up over and over again - and if you search the forums you'll probably find the information you're looking for. Essentially it's a case of envirionment variables - there are a number of environment variables available to you at the command line when you run the script manually, that are *not* available to the script when it is run programmatically within TeamSite - as such you need to determine which envirionment variables are missing and set them - within a BEGIN{...} block in your code.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

amar_maheshwary

Hi Adam,

I set all the ENV variables in my script but its still throwing the same error ... see below the list of variables and the error

BEGIN {
$ENV{'PATH'} = 'C:/iw-home/bin';
$ENV{'SYSTEMROOT'} = 'C:/WINNT';
$ENV{'USERNAME'} = 'user1';
$ENV{'USERPROFILE'} = 'C:/Documents and Settings/user1';
$ENV{'USERDNSDOMAIN'} = 'COMPUTERWORLD.COM';
$ENV{'HOMEDRIVE'} = 'C:';
$ENV{'CLIENTNAME'} = 'ISCEMEAIMS';
$ENV{'COMMONPROGRAMFILES'} = 'C:/Program Files/Common Files';
$ENV{'APPDATA'} = 'C:/Documents and Settings/gbernstein/Application Data';
$ENV{'PROGRAMFILES'} = 'C:/Program Files';
$ENV{'OS'} = 'Windows_NT';
$ENV{'PROMPT'} = '$P$G';
$ENV{'NUMBER_OF_PROCESSORS'} = '1';
$ENV{'HOMEPATH'} = '/Documents and Settings/user1';
$ENV{'PATH'} = 'C:/iw-home/bin';
$ENV{'USERDOMAIN'} = 'COMPUTERWORLD';
$ENV{'JAVA_HOME'} = 'C:/j2sdk1.4.2_09';
$ENV{'TEMP'} = 'C:/DOCUME~1/user1/LOCALS~1/Temp/1';
$ENV{'SYSTEMDRIVE'} = 'C:';
$ENV{'COMSPEC'} = 'C:/WINDOWS/system32/cmd.exe';
$ENV{'LOGONSERVER'} = '\\CWDC1';
$ENV{'SESSIONNAME'} = 'RDP-Tcp#74';
$ENV{'WINDIR'} = 'C:/WINDOWS';
$ENV{'USERNAME'} = 'user1';
$ENV{'IWACCESSHOME'} = 'C:/Interwoven/CSF/AccessService';
$ENV{'COMPUTERNAME'} = 'CWFTS1';
$ENV{'IW_HOME'} = 'C:/iw-home';
$ENV{'CLASSPATH'} = 'c:/oraclelib/ojdbc14.jar';
}

Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (SQL-28000)(DBD: db_login/SQLConnect err=-1)

I checked couple of other posts which are showing the similar ENV variable problems but i m not able to resolve after settng all the variables why its still throwing the same error

amar_maheshwary

To my surprise, I reset all the environment variables while running from command line even though still its able to display the connect and fetch the values :-(

viewer.properties.txt

web.xml.txt

jbonifaci

I don't think this is a case of environment variables. If you read the error message, it appears that you are not passing a valid user id. Are you logging the dsn, userid and password? If not, do so, and make sure that the information being logged is valid. My guess is that it is not.

~Jeff

amar_maheshwary

Thanks Jeff,
User id password dsn information is right because i am able to run the same script from command line perfectly

jbonifaci

Are you reading this information in from somewhere or is it hard coded within the file? If you're reading them in from somewhere (I would hope you wouldn't have them hard coded unless it is only for debugging), they may not be read in properly when run from your cgi for some reason.

amar_maheshwary

No, I just hardcoded the env variables to see if it resolves the problem to make
Command line and GUI env identical

earlier I had two ENV variables set

$ENV{'PATH'} = 'C:/iw-home/bin';
$ENV{'SYSTEMROOT'} = 'C:/WINNT';

but then as suggested by Adam, I dumped all the variables in my .ipl file to get rid off the error .... but it doesnt help
Is this only becasue of ENV variables or can be some issues with Active Directory of IIS or something .... just a weird thot