Hi Ronald,
You probably want to read this first:
<http://dev.mysql.com/doc/refman/5.1/en/tutorial.html>
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/
64012/match=password+mysql>
Best regards,
Mark
--
Economy-x-Talk
Consultancy and Software Engineering
http://economy-x-talk.com
http://www.salery.biz
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?
Thanks,
Ron Zellner
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
