Any sample scripts to connect and query with MySQL database?

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
alex298
Posts: 101
Joined: Mon May 01, 2006 1:17 pm

Any sample scripts to connect and query with MySQL database?

Post by alex298 » Mon May 01, 2006 1:54 pm

Hello,

I decide to use RR and MySQL with my project. I have some experience in using SQL with other computer languages. However I have problem to get start with RR. My problem is:

Are there any sample scripts and tutorials to use RR connect and query with MySQL database?

Thanks and best regards
Alex
Nice to meet all of you.

malte
Posts: 1098
Joined: Thu Feb 23, 2006 8:34 pm
Location: Ostenfeld germany
Contact:

Post by malte » Mon May 01, 2006 2:04 pm

Hi Alex,

you might want to look at Sarahs mySQL stacks, which you can download here:

http://troz.net/Rev/tutorials.php

All the best,

Malte

alex298
Posts: 101
Joined: Mon May 01, 2006 1:17 pm

Post by alex298 » Mon May 01, 2006 2:27 pm

Malte,

Thanks :)

I download the MySQLtests.rev and play around. However I have another question:

All computers in the LAN are running windows OS. The MySQL database is installed on a server and the RR stack is running on a client. What is the path of the MySQL database?

Thanks and best regards
Alex
Nice to meet all of you.

Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Location: Aalst, Belgium
Contact:

Post by Janschenkel » Mon May 01, 2006 2:59 pm

Hi Alex,

When you connect to a MySQL database, you specify the host of the database as an IP-address or its hostname). So suppose that the server is called "gandalf.example.net", you'll connect to it like:

Code: Select all

get revdb_connect("mysql","gandalf.example.net",.....)
    or
get revdb_connect("mysql","192.168.2.50",.....)
Ask your network administrator if you don't know exactly what the server is named or what IP-number it has.

Hope this helped,

Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

Post Reply

Return to “Databases”