Re: [sqlite] Basic insert statement - syntax problem

[Asko Kauppi]

Still, shouldn't the 'mri_output' (table name) be quoted?
17.2.2005 kello 11:45, Anirban Sarkar kirjoitti:
 I am really very sorry.
I mistyped the entire sql statement.
This is what my actual code looks like:
sqlite db1 "cesc_simputer.db"
#Inserting data into mri_output table
  set connection_no { }
  set insert_normal "insert into mri_output (pwd,ac_my,con_no) values 
('$pass','$ac_mth$ac_yr','$sel_con')"
  db1 eval insert_normal {} {

  }
Please note that the problem is with the syntax of the sql statement.
Regards,
Anirban Sarkar
----- Original Message -----
From: "Asko Kauppi" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, February 17, 2005 2:46 PM
Subject: Re: [sqlite] Basic insert statement - syntax problem

The error messages provided by SQLite seem to be very helpful, can you
use them?
like: if (rc) glua_errorN( "sqlite3 error %d: %s", rc,
sqlite3_errmsg(db) );
Aside that, shouldn't the table name (mri) have quotes ('mri')?
What's the $con_no doing without quotes as well.  Use ?1 for binding
stuff if that's what you need.
-ak
17.2.2005 kello 11:04, Anirban Sarkar kirjoitti:
  Hi all,
I am having syntax problem with a basic sqlite insert statement. I
know it's very simple but just could'nt make out where I am going
wrong.
set insert_details "insert into mri (pwd,con_no) values
('$pwd',$con_no)"
Where am I going wrong?
Thanks and regards,
Anirban Sarkar