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)
It would be EXTRAORDINARILY helpful if you could give an example of the actual string you're parsing. All we've got now is a variable that contains Mystery Text. Since my crystal ball is currently in the shop for repairs I can't guess what 'rsImagem' contains, nor can anyone else, which makes it pretty difficult for anyone to offer you assistance.
And the final code:
[...]
This code gives 3 images but the same one. How can we tell lingo to retrives the 3 different images that are on DB?
Have you looked into repeat loops? Have you looked into ways to load lists or property lists with variables? Have you looked into rudimentary text parsing with Lingo via 'offset' or more advanced parsing using an Xtra such as PRegEx?
Warren Ockrassa | President, nightwares LLC [EMAIL PROTECTED] nightwares LLC | Consulting Programming http://www.nightwares.com/ Developer | Structor, a presentation development/programming tool Info and demo | http://www.nightwares.com/structor/ Author | Director 8.5 Shockwave Studio: A Beginner's Guide Chapter samples | http://www.nightwares.com/director_beginners_guide/
[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!]
