Search Postgresql Archives

Type of value has a mismatch with column typeCouldn't store <True> in viewimages_yn Column. Expected type is BitString.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Type of value has a mismatch with column typeCouldn't store <True> in
viewimages_yn Column.  Expected type is BitString.


Iam getting this error when iam using bit field and assinging to datatable..

The code is below.....

 Dim sql As String = "select * from Users where UserName = @param1"
        Dim cmd As DbCommand = m_objDatabase.GetSqlStringCommand(sql)       
        m_objDatabase.AddParameter(cmd, "@param1", DbType.[String], 30,
ParameterDirection.Input, False, 0, 0, [String].Empty,
DataRowVersion.[Default], "Steven")
        'm_objDatabase.AddInParameter(cmd, "param2", DbType.[String],
"Eastern")
        Dim ds As DataSet = m_objDatabase.ExecuteDataSet(cmd)


Iam getting error as
Type of value has a mismatch with column typeCouldn't store <True> in
viewimages_yn Column.  Expected type is BitString.

please help me to solve this error...


Thank and Regards
Reena







--
View this message in context: http://postgresql.1045698.n5.nabble.com/Type-of-value-has-a-mismatch-with-column-typeCouldn-t-store-True-in-viewimages-yn-Column-Expected-ty-tp4806517p4806517.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux