Multiple Records Onto One Label S’abonner

0
Avatar
Legacy Poster

Pulling multiple records onto one label is not supported in the currently released version of BarTender. So I heard that a VBScript can help me to achieve this. I never touch this before, so sorry for my lack of comprehension


 


I am trying to create a VBScript that connect to my database and execute the following query :


 


select Quantite, description_device

from utilise, medical_devices

where utilise.id_operation = 25

and utilise.id_dispositif = medical_devices.id_device


 


I created this :


 


 

Dim cn, rs


set cn = CreateObject("ADODB.Connection")

set rs = CreateObject("ADODB.Recordset")

cn.connectionString = "Driver={MySQL ODBC 5.3 Driver};Server=myip;Database=mydb;User=myuser; Password=mypassword;"

cn.open

rs.open "select ...", cn, 3

rs.MoveFirst

while not rs.eof

    wscript.echo rs(0)

    rs.next

wend

cn.close
 

 

 


 


 


But even the first line fail with this error :

 

<Line 1: Value = Dim cn, rs: Syntax error>
 

 


 


How to proceed to get this script running?

Vous devez vous connecter pour laisser un commentaire.