Basic SQL database question
m.schonewille at economy-x-talk.com
Fri Mar 9 10:18:04 CST 2007
You probably want to read this first:
Then read everything about the databases and sql in the Rev docs.
A useful tip: whenever you want to get data from the SQL server, even
if you are only asking for a constant or a list of tables, use
revDataFromQuery. To give the SQL server a command that shouldn't
return data, use revExecuteSQL.
It is easiest to set up the server with a database and a table,
first. You can create new tables from within Revolution, but it would
be pretty hard to create new databases as well.
After installing MySQL, make sure to use old style password
configuration, like this:
set password for "tempUser" <at> "localhost"=OLD_PASSWORD("mypass");
also see: <http://article.gmane.org/gmane.comp.ide.revolution.user/
Consultancy and Software Engineering
Get your store on-line within minutes with Salery Web Store software.
Download at http://www.salery.biz
Op 8-mrt-2007, om 20:49 heeft Ronald Zellner het volgende geschreven:
> I saw the response about using raw SQL, and I wasn't sure exactly
> what that meant. Would it be essentially the same as the PHP code
> in a web-based file? I found a lot of information on SQL queries,
> but I can't find much on creating new records. Is there more
> information or an example available?
> Ron Zellner
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode