Re: How to get Data via Internet from another Database?

[Mark Stosberg <mark@summersault.com>]

******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******


Hans-Joachim,

 I'm not sure if this answers your question, but it answers the generic
question "Can I get data from another database on the internet?" The
answer to this is "yes". This functionality is built into DBI, as well
as some databases like Postgres. For instance, I use postgres on a
remote machine for my minivend data. I still need to have some parts of
postgres on my local machine, namely the psql frontend, so that proper
function calls can be created and sent. No database data needs to be on
the local machine. 
 In your case, you need to know what the remote database type is, and
make sure you have the pieces you need to connect to that database on
your local machine, plus all the associated DBI and DBD modules. 

 Good Luck!

 -mak

Database             products products.asc SQL
Database             products DSN  dbi:Pg:dbname=minivend
host=remote_host.domain.com port=5432

Hans-Joachim Leidinger wrote:
> 
> ******    message to minivend-users from "Hans-Joachim Leidinger" <hans-joachim.leidinger@home.gelsen-net.de>     ******
> 
> Dear reader,
> 
> sorry for my bad englisch. I hope you can help me.
> 
> I have Minivend with a special products-Database (i.e. only
> Sci-Fi-books). Any visitor in my shop wish to buy other book (i.e.
> Fantasy-Book). I have a connection via Internet to another Database of
> books (over 1.000.000 books).
> 
> To get any Data from the big bookstore, there are some condition...
> 
> 1.
> URL to call the big-bookstore:
> http://www.bigstore.de/cgi-bin/bigsearch.exe?opacdb=bigstoredatabase&Akt
> ion=Start&Caller=<my member-number>&uid=<uid>
> 
> (The visitor search a book to buy and is finish (after selection the
> book). The visitor click the back-button to my shop. The button have a
> return-URL to my shop. The basketinformation from the bigstore is behind
> the return-URL.
> I.e. I get Data from the bigstore with the format
>     <my return-link>&UID=<my
> member-number>,<date>,<time>&onum1=<n1>&otitle1=<t1>&ocode1=<i1>&oprice1
> =<p1>(Data of 1.title)....etc..
> 
> description:
> n = order_quantity
> t = title
> i = code
> p = price
> 
> for example
> 
> http://www.myshop.de/simple.cgi/uid=aHfser:123&onum1=1&title1=The white
> house fantasy!&ocode=12345&oprice=9.99 DM&onum2=....etc.)
> 
> 2. To erase all userinformation (vivistorinformation) in the bigstore,
> the action is to call
> 
> http://www.bigstore.de/cgi-bin/bigsearch.exe?opacdb=bigstoredatabase&Akt
> ion=Start&Caller=<my member-number>&uid=<uid>&option=delete
> 
> How can i do, to get the basketinformation into the minivendbasket? How
> can i tell minivend, to get the item-information from the bigstore into
> the basket of minivend?
> 
> Another question!
> 
> If minivend find product more than the number of mv_matchlimit and i use
> the tag [more-list], how can i do, to use a button (left-arrow and/or
> right-arrow)? For example:
> 
>             <button-immage-left-arrow> Previous 1  2  3  .... Next
> <button-immage-right-arrow>
> 
> I hope, anybody give me usefull information to help me!
> 
> Thank you very mutch!
> 
> Your Joachim
> 
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-- 
http://flip.summersault.com/
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list