Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread John LeSueur
Asko Kauppi wrote: 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 s

Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread Christian Smith
age? Do any of the substituted values contain apostrophe "'" characters? > >Regards, >Anirban Sarkar > >- Original Message - >From: "Asko Kauppi" <[EMAIL PROTECTED]> >To: >Sent: Thursday, February 17, 2005 2:46 PM >Subject: Re: [sql

Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread Paolo Vernazza
17.2.2005 kello 11:45, Anirban Sarkar kirjoitti: 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',

Re: Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread Anirban Sarkar
Thanks Lawrence, once again. Regards, Anirban - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, February 17, 2005 3:46 PM Subject: Re: Re: [sqlite] Basic insert statement - syntax problem > > > > > From: "Anirban Sarkar" <[EMAIL PROTE

Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread Asko Kauppi
n Sarkar - Original Message - From: "Asko Kauppi" <[EMAIL PROTECTED]> To: 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) glu

Re: Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread lawrence.chitty
> > From: "Anirban Sarkar" <[EMAIL PROTECTED]> > Date: 2005/02/17 Thu AM 09:45:03 GMT > To: > Subject: Re: [sqlite] Basic insert statement - syntax problem > > #Inserting data into mri_output table > set connection_no { } > set insert_norma

Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread Anirban Sarkar
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: Sent: Thur

Re: [sqlite] Basic insert statement - syntax problem

2005-02-17 Thread Asko Kauppi
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 stu