Re: Sqlite -mysql add records
- Posted by Jim Smiley <sixs at ida.net> Apr 11, 2007
- 479 views
Chris Burch wrote: > > 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 > > > <a href="http://euallegro.wikispaces.com">http://euallegro.wikispaces.com</a> > <a > href="http://members.aol.com/chriscrylex/euphoria.htm">http://members.aol.com/chriscrylex/euphoria.htm</a> > <a href="http://uboard.proboards32.com/">http://uboard.proboards32.com/</a> > <a > href="http://members.aol.com/chriscrylex/EUSQLite/eusql.html">http://members.aol.com/chriscrylex/EUSQLite/eusql.html</a> Chris, I want to take a look at sqlite and use it instead of mysql. What is a good way to start? I have used in apackage that I tried in PHP. It had aprogram that allowed building the sqlite files as I remember. Any suggestins