~query~

HCL Domino Domino Forum
1

Hello,

I have a LotusScript to retrieve data from ms sql, the Script is below:

if

LS = SELECT title FROM book , i can't run script

but

LS = SELECT * FROM book , it work

Help please!!

2

Subject: ~query~

Hi Boon,

Are you trying to get the value of the column “title” from the table “Book”

your LS is declared as??

3

Subject: RE: ~query~

i have agent by LS in the code below

            Dim uisession As New NotesSession

Dim uidb As NotesDatabase

Set uidb = 	uisession.CurrentDatabase

Dim uidoc As NotesDocument

Set uidoc=uisession.DocumentContext

Set con = New ODBCConnection

Set qry = New ODBCQuery

Set result = New ODBCResultSet





Dim conn_status As Boolean

Dim  tsql As String



conn_status=con.ConnectTo(sDsn, sDsnUserName, sDsnUserPass)		



If conn_status=True Then

	con.AutoCommit=True

	Set qry.Connection = con

			

	

	

	tsql = "SELECT   *  FROM book "

’ tsql = "SELECT title FROM book "

	qry.SQL = tsql

	Set result.Query = qry

	

	Call result.Execute()

                            . 

                            . 

                            . 

                            . 

                            . 

                            . 

                            .

thank

4

Subject: RE: ~query~

hi thish jil i successfully of LS, thank a lot