While input of date - literal does not match format string

Question

I have this line of code in asp.net through which inserting date into a table

CMPI_EFF_DATE = cc.GetDataSet("SELECT TRM_EFF_STDT as TRM_EFF_STDT FROM TRM_MST WHERE TRM_CODE = " + ddlTrm.SelectedValue + "").Tables[0].Rows[0]["TRM_EFF_STDT"].ToString(),

and i am using oracle database . but while inserting data into it it show's an error

 literal does not match format string

You should be using parameterized queries, which would probably solve this issue in addition to closing a potential SQL Injection vulnerability. — Clockwork-Muse
– Clockwork-Muse, Commented May 31, 2014 at 6:55

Vladimir Semashkin · Accepted Answer · 2014-05-31 05:35:13Z

2

Is ddlTrm.SelectedValue string value? if it's true, I thing you should put value in quotes like this

"'" + ddlTrm.SelectedValue+"'"

Full example:

CMPI_EFF_DATE = cc.GetDataSet("SELECT TRM_EFF_STDT as TRM_EFF_STDT FROM TRM_MST WHERE TRM_CODE = '" + ddlTrm.SelectedValue+"'").Tables[0].Rows[0]["TRM_EFF_STDT"].ToString()

answered May 31, 2014 at 5:35

Vladimir Semashkin

1,2801 gold badge10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

शेखर · Accepted Answer · 2014-05-31 05:14:47Z

1

I think you are wrong here ddlTrm.SelectedValue + "")

It should be ddlTrm.SelectedValue )

CMPI_EFF_DATE = cc.GetDataSet("SELECT TRM_EFF_STDT as TRM_EFF_STDT FROM TRM_MST WHERE TRM_CODE = " + ddlTrm.SelectedValue).Tables[0].Rows[0]["TRM_EFF_STDT"].ToString(),

answered May 31, 2014 at 5:14

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

2 Comments

Nisar Over a year ago

Still ... same error literal does not match format string

शेखर Over a year ago

if the selected value is string and trm_code is string then you need to use' in your query.

Collectives™ on Stack Overflow

While input of date - literal does not match format string

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related