HELP PLZ ASAP.. ABOUT FETCHING DATA IN LIVELINK 1

[chokz1009]

Hi to everyone, can you give me a sample code that will fetch data into the database then display it on the webforms...

i don't know how to fetch a data the display it on the webforms.. thanks in advanced... ^_^

 

[appnair]

on the livelink server where you have put the webforms module if you search there should be about lot of examples

..\module\webform_9_7_2\examples

One is supposed to play with those examples and figure out your exact need.I suppose you know that you can create a form template and store it in a table.Once you figure out the examples it should help you display your own data as well

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[chokz1009]

Thanks sir appnair, im new in livelink dev thats why i don't know how to do some basic fetching data...

 

[chokz1009]

hi appnair, so far I got the returned value one of my webforms but still I'm totally annoying:

this is the sample line how to fetch the data:

<!-- File: webattribute/attrstring.html -->
<INPUT CLASS="valueEditable" TYPE="text" NAME="_1_1_3_7_1" TITLE="Middle Name" ID="_1_1_3_7_1" VALUE="[LL_FormTag_1_1_3_7_1 /]" SIZE="32" MAXLENGTH="32" ONCHANGE="markDirty();">
<!-- End File: webattribute/attrstring.html -->

based on my observation this line below is fetching the last data inserted in the database..
VALUE="[LL_FormTag_1_1_3_7_1 /]"

Also this line is the column from DB that i want to fetch.
TITLE="Middle Name"

my question is how to fetch a data from DB using a different where clause..?

example i want to fetch the data id = "1" then the data fetched will shown on my forms.. do i need to make a javascript or i need to update some other html or javascript code inside the livelink.?

 

[appnair]

which of the examples did you try which I said.the one that ends in xml or ones that end with html.The ones that end with html is what is referred as "unsafe lookups" which is basically like a text box in a html page where you type "select * from mytable" all the connection params are in the form itself for everybody to see so it is considered unsafe.In the safer forms(xml example) basically the connection info is encapsulated within the server,so you basically create connection info in livelink admin pages under webform data connection,but you can still pass valid queries.What you really want to know is when you hit tab then you are executing a livelink request handler probably webform.datalookup or something of that sort.Now the result set is given to you in the javascript object.for debugging you want to make the vanishing javascript window that posts to your form visible so you can understand the flow.Now if your real form template is posting to a table and if middlename is a field in your table you should be able to follow the OT example and write your own stuff.I don't think you need other than javascript anything else.


See these in the file Example_template.html
// This example assumes that the current LES server has five things:
// A database connection object that points to the current LES database.
// A database lookup object named ExampleLookup1 whose SQL statement to
// execute is:
// select FirstName, LastName, MailAddress, GroupID from KUAF where Name=:A1

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[119854945]

hi appnair,

i tried hard to search the codes of VBA for livelink for long time, and right now i only saw your inputs about this topic working good.

my question is after i display the billing which is used LiveLink Archive to present it. i want to use VBA to save the current open file in Livelink Archive but have no any idea about what the codes it is. i only know how to open a file in LiveLink as below:
**************************************************************
Sub OpenDocInViewer()
Dim Viewer
sFileName = "C:\Documents and Settings\jjy018\Desktop\data-archived__P1.pdf"
Do
Set Viewer = CreateObject("AlViewer.App")
Set Doc = Viewer.CreateDocument()
Viewer.OpenDocumentFromFiles sFileName, sFileName, sDocType, sFileName, ""
Set Viewer = Nothing
Loop
End Sub
****************************************************************
But what is the code for save the opened file in Livelink?

What i could do for this issue is enclosed in the attachment, another thing i want to achive is to to let the livelink applicaton invisible after it is launched, because it would not impact other application's working when the VBA is running

need your help!

 

[chokz1009]

@appnair, i use the lookupexample.html

but still error "no data returned always pop-up"...

Can u help me out in this problem.. T_T..

Cant understand list codes below After the comment those are my question:

<!-- cols is string that contains the columns to select. Its value can be * -->
var cols = encodeURI( 'DataID,First_Name,Last_Name,Middle_Name' );

<!-- A where clause for the select statement -->
in this line i will put the parameter or my where clause of the query.
var where = encodeURI( "username='" + userName + "'" );

<!-- The URL to call -->
in this line i can't understand why it is.
var url = "[LL_CGIPATH /]?func=webform.datalookup"

<!-- Add to the URL the connection name -->
this line the connection i use SQL so i get the dabatase name which is the "PacificOutDoorDB". Am right?
url = url + "&server=PacificOutDoorDB"

<!-- Add to the URL the name of the variable in which to store the results -->
in this line i didn't know what is the use of the line..
url = url + "&varName=SQLData&funcname=updateFields"

<!-- Add to the URL the table name, the columns to select, and the where clause -->
i understand this line
url = url + "&tableName=SampTbl&columns=" + cols + "&where=" + where;

<!-- Create an object in which to store the results -->
also this one i didn't know the value of the SQLData.
SQLData = new Object;

also this one i don't know what happened after this line executed.
window.open( url, "dataWin", "width=1,height=1,top=6000,left=6000" );

thanks in advanced appnair,

 

[ggriffit]

All you are doing is building up a URL that can be passed to Livelink in a new window that will show the results of your SQL Statement, as such you need to pass variables to indicate what function you need to run - the one to return the SQL - which SQL to run and which parameters the SQL needs, on the return side you will need to let the code know which field to put the value you select in.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[appnair]

@chokz1009.
If I were you I would connect to the livelink schema using a GUI tool such as SQLdeveloper/SQLmgmtstudio or anything like that.then run the same statement as in the lookupexample.html.That would be the most easy.Once you figure that out then it becomes easy to do external databases or internal databases

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[chokz1009]

hi appnair, again and again... ^_^

i would like to know if the lookup.html and webformtemplate.html are seperated or it is possible to unite in one html file..? thanks.. until now i'm stock in the dblookup in webforms.. T_T

 

[appnair]

the whole point of the examples sitting under the webform module is to show a form designer how to expose his form data in livelink.It goes without saying that a form template is a pre-cursor to your form.when you export your template to html you are free to add your own javascript.By the same token one can re-use the code that OT supplied,one can also peruse form designer guides in the OT which may have a step by step type of documentation.I do not know but I have always been able to understand these examples that they provide.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[chokz1009]

appnair, i already got my problem using lookup in web forms thanks a lot for your help, But i have a problem again..

Here's my prob..

how do i get the user name or id onload of the webform page..? so i can send it as a parameter to my lookup.. thanks..

 

[appnair]

same way as the example.Either when you create the template you can define it as a user field then use replacement tags.I really think you should get the forms documentation.It is just too much to explain these tips ,tricks and tweaks that are well explained in the documentation.beliive me it is one of the earliest tweaks one used to do

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair