This is a movie that all the information comes from an access database.
All the data are save on external casts and the records on access only have the path:
videos.CST/aseguir.mov
This code works fine to give one video:
myDBValue = dGRSGetFieldValue("video" rsvideo)
str = the itemDelimiter
the itemDelimiter = "/"
myCast = myDBValue.item[1]
myVideo= myDBValue.item[2]
the itemDelimiter = "."
myCast = myCast.item[1]
myVideo = myvideo.item[1]
the itemDelimiter = str
set the member of sprite 12 to member (myvideo,myCast)
Now we want the same but giving 3 images.
This is the sql query:
set sqlString="SELECT imagem FROM (gesto INNER JOIN imgpicto ON gesto.IDgesto = imgpicto.IDgesto) WHERE gesto.Designacao Like '" & pesquisa & "'"
set rsImagem = DGCreateRecordset(sqlString, dbHandle)
And the final code:
myDBValue = dGRSGetFieldValue("imagem" rsImagem)
str = the itemDelimiter
the itemDelimiter = "/"
myCast = myDBValue.item[1]
myImage = myDBValue.item[2]
the itemDelimiter = "."
myCast = myCast.item[1]
myImage = myImage.item[1]
the itemDelimiter = str
set the member of sprite 18 to member (myImage,myCast)
set the member of sprite 19 to member (myImage,myCast)
set the member of sprite 20 to member (myImage,myCast)This code gives 3 images but the same one. How can we tell lingo to retrives the 3 different images that are on DB?
Thank you.
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
[To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
