Euphoria and MySql
- Posted by Michelle <michellerogers at bellsouth.net> Mar 24, 2007
- 446 views
I was previously using Euphoria quite a bit. But, for awhile now, I have concentrated on PHP and so I am afraid I may have forgotten some of the tiny things that make Euphoria work. I am trying to use the EMySqLib wrapper for MySql with Euphoria. I have been able to create a database and a table. However, I have run into some problems inserting data into the table. I have a feeling that the problem is more of a syntax error with Euphoria, instead of a MySql problem. The reason is because I can get the exact same thing to work in PHP AND..it works in Euphoria if I don't try to insert variable data for the mysql data. Here's the example:
global function RunQuery(object query) object result integer dbid dbid=OpenDBConnection() result = mysql_select_db({"kituwah"}) result = mysql_query({query}) CloseDBConnection(dbid) return result end function thetabletype="characters" query="INSERT INTO characters (type,whereat,online) VALUES (thetabletype,'getName',3)" ConsoleMsg("creating a new character now....") result=RunQuery(query)
The problem is not in the RunQuery function, because it works correctly in creating a table, etc. Also, if i delete the "type" from the fieldlist and delete the "thetabletype" from the values list, this works. So, I think I have some sort of syntax problem, that I've forgotten while working with PHP. Can anyone help me figure out how to send variable data in a mysql query, using Euphoria?