Hi all, Basically i have 2 queries..

1. Is there any simple way to fetch the data directly from the database (using the URL and credentials) from the csp file without creating a link table for that particular Table...?? If there is, could you please share the syntax of using them ..?

2. Can we have an object return type from the below mentioned method to a javascript function.. ???

Hi,

Currently i am building a CSP application using Intersystems cache to automate few tasks in Ensemble. Basically, I have 2 .csp class files, file1.CSP and file2.CSP in namespaces namespace1 and namespace2 respectively. On satisfaction of a condition I forward the request from file1.csp to file2.csp. while forwarding it prompts me to enter the log-in credentials again as the second .csp file is in a different namespace. Is there any way i can bypass the login screen while forwarding the request from 1 csp to another (as i am using the same credentials for both the namespaces) ?

Hi,

I am using the &sql () tag to retrieve the value from the Cache DB.

below is the piece of code i am using:

script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String" &sql( select columnA, into :tempVariable1 from TABLE where COLUMNC = pVariable

quit tempVariable1

i have to return the ColumnA value back to the calling procedure.

can i know how it can be done ? since i am getting an javascript error.