On Thu, 17 Feb 2005, Anirban Sarkar wrote:
>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.
What is the syntax error message? Do any of the substituted values contain
apostrophe "'" characters?
>
>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
>>
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
