CAPI.AllocConnect (using SQL Server 2000)

Please tell me exact syntax for CAPI.AllocConnect (using SQL Server 2000) as I am facing difficulties regarding this.Also I want that there should be something dynamic to get connection information to pass on toCAPI.Execinstead we are hardcoding SQL server name, passwords etc etc.Because I want that module should working on any Livelink system without changing anything (connection info etc)

Find more posts tagged with

Comments

Ponpriya_balawubramanian

Thanks. I solve this CAPI.Exec matter.Now I have used the following Weblingo code to display the result of my "fResultSet" (result contain output of SQL Statement) Dynamic feature.;for i = 1 to Length(.fResultSet) ;rec1 = .fResultSet[i] `rec1` ;endRecords are retrieved fine. But there is " R<'name'= " stuff in the beginning of the result set(R<'name'='Admin'>)like that included with the result set. How can I remove it? Is the only way by trimming using Javascript?I have 3 fields in my result set. Now suppose I only want to display two i.e. "Name" and "Id". What change I need in the above code?

Pierre_Nocera

Message from Pierre Nocera <pnocera@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">Thanks. I solve this CAPI.Exec matter.

;if isnoterror(.fResultSet) && isdefined(.fResultSet)

;for rec1 in .fResultSet

<tr>

</tr>

;end

the R< means this is a record. When you see a A< you can be sure it's an Assoc

Don't forget to test for error or undefined value before accessing your Dynamic feature, or your Livelink thread may get frozen when it happens

Pierre

De: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Date: mar. 12/09/2006 10:09
ÿ: eLink Recipient
Objet : Thanks. I solve this CAPI.Exec matter.

Thanks. I solve this CAPI.Exec matter.
Posted by Balawubramanian, Ponpriya on 09/12/2006 04:08 AM

Thanks. I solve this CAPI.Exec matter.

Now I have used the following Weblingo code to display the result of my "fResultSet" (result contain output of SQL Statement) Dynamic feature.

;for i = 1 to Length(.fResultSet)
;rec1 = .fResultSet[i]
<tr>
<td>`rec1`</td>
</tr>
;end

Records are retrieved fine. But there is " R<'name'= " stuff in the beginning of the result set

(R<'name'='Admin'>)

like that included with the result set. How can I remove it? Is the only way by trimming using Javascript?

I have 3 fields in my result set. Now suppose I only want to display two i.e. "Name" and "Id". What change I need in the above code?

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Topic: CAPI.AllocConnect (using SQL Server 2000)
https://knowledge.opentext.com/knowledge/llisapi.dll/open/7988942

Discussion: Development Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/786303

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.development@elinkkc.opentext.com.

Ponpriya_balawubramanian

Yes, everything solved. Now page is working as required.Now please let me know how I can set Header and Footer of page (Personal, Enterpise links etc and Top link) as all livelink pages usually have.

Ponpriya_balawubramanian

I am facing difficulty in setting Header and Footer of page (Personal, Enterpise links etc) as all livelink pages usually have. Header displays without search bar and no link is working. Please help.