OpenEuphoria

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.