I am doing something very similiar to your kiosk project. My case is museum visitors slide their cards with barcode on and then Director sends this id number to mySQL database and then return data back to Director.(a cgi script is middleware between mysql and director) Below is what I have been doing:(I am using Win2000 machine)
I downloaded ActivePerl from ActiveState.com. They have this binary Perl installation file which contains things you need to write and execute Perl. But you'll need to manually install DBI-mySQL module in order to communicate with database(check their documentation). Next I set up application setting under IIS to recognise .cgi file extensions and send them to the perlis.dll that runs the cgi code. In Director, you use getNetText() to call your cgi script and netTextResult to get back your results.(at the end of your cgi code, put : print "content-type:text/plain\n\n$string"; this will return the searching results back to Director) Hope these help! Yachun =) ----- Original Message ----- From: Rodrigo Peres <[EMAIL PROTECTED]> To: Lingo <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 3:38 PM Subject: Re: <lingo-l> Multiuser Xtra and databases > This project will be running from Kiosk. It will among other things check > prices. The client use the barcode in package, and the system go to the > database and get the price, description and present on screen. > I've never heard about PHP executable where I can find it?? Or Perl > executable?? And how can I send it with instalation CD?? And more important > deal with webserver is ok, but how can I talk to the .exe to grab the > retieved information from database? > If this is too much of topic, please respond in private, I don't want to > bother the rest of list with this! > > Many thank's > > Rodrigo > > on 6/17/03 3:58 PM, Evan Adelman at [EMAIL PROTECTED] wrote: > > > is that really the case? if the solution involves ASP, you're probably > > right, you need a webserver. but php, perl, and the like are actually > > separate executables that you could include (1. the distribution > > licenses are pretty loose if i remember, and 2. all the perl executables > > and lib that come in the distro i have are 13MB - good enough to include > > on a cd) > > > > if writing in those languages is a problem, then that's a different matter. > > > > chiming in for no particular good, > > evan > > > > Rodrigo Peres wrote: > > > >> First, thank's for the answers use PHP or ASP is not the case here, because > >> I need a quick response and this aproach can delay things a little. The > >> other problem is that there's no way to put a webserver in this project. > >> > >> on 6/17/03 2:00 PM, Mathew Ray at [EMAIL PROTECTED] wrote: > >> > >> > >> > >>> I agree with Troy...I am using php/mysql and it works pretty well. I've > >>> heard you can do similar things with flash and coldfusion, but it seems much > >>> more expensive without a big payoff. If you are using some complicated > >>> SOAP-compliant app or something, flash may be easier to interface with, but > >>> for simple database stuff posting to a web form and getting a reply is > >>> usually good enough. > >>> > >>> Although, I seem to remember reading something quite a while ago about MUS > >>> being able to access databases and stuff, but I can't recall in what > >>> capacity or technically how it was done :0/ Overall though, the end product > >>> is much more flexible if done with some sort of full-featured middleware > >>> like php or asp. > >>> > >>> ~Mathew > >>> > >>> ----- Original Message ----- > >>> From: "Troy Rollins" <[EMAIL PROTECTED]> > >>> To: <[EMAIL PROTECTED]> > >>> Sent: Tuesday, June 17, 2003 12:12 PM > >>> Subject: Re: <lingo-l> Multiuser Xtra and databases > >>> > >>> > >>> > >>> > >>>> On Tuesday, June 17, 2003, at 12:01 PM, Rodrigo Peres wrote: > >>>> > >>>> > >>>> > >>>>> Is it possible to use multiuser xtra to connect to databases like > >>>>> mysql, > >>>>> oracle etc. I need to connect and retrieve some data. If possible I'd > >>>>> like > >>>>> to run away from third part xtras, but... > >>>>> > >>>>> > >>>> You'll probably want to use a PHP/ASP intermediary. > >>>> > >>>> > >>>> > >>>>> ps: DirectorMX doesn't use multiuser anymore?? > >>>>> > >>>>> > >>>> Yes it does (on all platforms), but the xtra has been moved to the > >>>> "goodies" folder on the distribution CD. Macromedia needs to reconsider > >>>> this. That xtra can serve many purposes - more than what the Flash > >>>> Communications Server alone can offer. > >>>> > >>>> > >>>> > >>>> -- > >>>> Troy > >>>> RPSystems, Ltd. > >>>> http://www.rpsystems.net > >>>> > >>>> > >>> > >>> [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!] > >>> > >>> > >>> > >> > >> -------------------------------------------------- > >> Rodrigo Peres > >> www.rodrigoperes.com.br > >> escrit�rio/office: +55(11) 3781.7017 > >> celular/mobile: +55(11) 9108.6169 > >> -------------------------------------------------- > >> > >> [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!] > >> > >> > >> > > -------------------------------------------------- > Rodrigo Peres > www.rodrigoperes.com.br > escrit�rio/office: +55(11) 3781.7017 > celular/mobile: +55(11) 9108.6169 > -------------------------------------------------- > > [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!] > [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!]
