Basic SQL database question

[Mark Schonewille]

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
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution