Re: Euphoria and MySql
- Posted by Michelle <michellerogers at bellsouth.net> Mar 24, 2007
- 440 views
Michelle wrote: > > > 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: > > }}} <eucode> > > 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) > > </eucode> {{{ > > > 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? bah..i fixed my own problem... but if anyone else ever needs similiar help..I fixed it like this:
thetabletype="characters" query="INSERT INTO characters (type,whereat,online) VALUES ('" query=query&thetabletype query=query&"','getName',3)" ConsoleMsg("creating a new character now....") result=RunQuery(query)
*kicks herself* sorry, i knew it was a stupid mistake, i just couldn't get back in Euphoria-mode enough to figure it out.