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