Multiple Records Onto One Label S’abonner

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;" "select ...", cn, 3


while not rs.eof

    wscript.echo rs(0)







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.