OpenEuphoria

Re: mysql add records

• Posted by Chris Burch <chriscrylex at aol.com> Apr 11, 2007
• 548 views

Jim Smiley wrote:
> 
> 

Hi

Don't use the mysql wrapper, but if there's any similarity to sqlite

> Hi,
> I copied the wrong line . Below is the working code that inserts a record
> using
> SQL YOG
> -----------------
> INSERT INTO works (workid,subjectid,personid,title) VALUES ('','1','1','1abc')

query1 = "INSERT INTO works (workid,subjectid,personid,title) VALUES
('','1','1','1abc')"

> ---------------------------------------
> None  of these commands seem to work.
>      result=run_query(query1)error says attempt to subscript an atom

result = run_query(query1, database_to_run_query_on) 

where database_to_run_query_on is the actual name, or handle, of a previously
opened / connected database.

>  result=mysql_db_query(query1)missing db or query
result = mysql_db_query(query1, database_to_run_query_on)

>  result=mysql_db_query(query1)error says empty query
etc

Chris

> ---------------------------------------------------
> JIm



http://euallegro.wikispaces.com
http://members.aol.com/chriscrylex/euphoria.htm
http://uboard.proboards32.com/
http://members.aol.com/chriscrylex/EUSQLite/eusql.html