OpenEuphoria

Euphoria and MySql

• Posted by Michelle <michellerogers at bellsouth.net> Mar 24, 2007
• 561 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?