MacConsult <[EMAIL PROTECTED]> said, on 8/9/00 6:35 AM:
>Is there any way to get data from a remote server running a SQL
>Database? I understand that programs such as FileMaker use ODBC to send
>SQL commands to the server. Any suggestions?
>Saludos,
>
>Javier Miranda V.
>MC Multimedia
Disclaimer: I haven't connected to any database from MetaCard yet--I
haven't needed to.
But I think the solution I would try would be PHP. Depending on the
actual database you use, ASP, ColdFusion, or Lasso might be other options
to consider. In any case, by using one of these products, you abstract
the SQL database into HTML, at the cost of doing some of your development
outside MetaCard. But they all take care of the hassle of interfacing to
the SQL database backend, and return the result in form you should be
able to easily get at within MetaCard.
Again, I haven't tried this yet, so there may be issues I'm not
considering that make this less than optimal. At the least, you add an
additional layer of complexity and an additional point of failure.
geoff
Archives: http://www.mail-archive.com/metacard%40lists.best.com/
Info: http://www.xworlds.com/metacard/mailinglist.htm
Please send bug reports to <[EMAIL PROTECTED]>, not this list.