From: | scomp(at)canada(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Going crazy comparing bytea columns |
Date: | 2006-03-01 18:40:39 |
Message-ID: | 4405eaa7.238.999.19861@canada.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am new to Postgresql, so pls be patient.
I am using npgsql with C# to insert a bytea value into a
column which will serve as an encrypted password. This works
well. However, when I retrieve the value, it is different.
In other words, "select pwd from table where pwd like @pwd"
does not work.
Is it not possible to compare bytea columns?
...get dbConn...
NpgsqlCommand cmd = new NpgsqlCommand("select pwd from table
where usr = @usr and pwd like @pwd",dbConn);
cmd.Parameters.Add(new NpgsqlParameter("usr",DbType.String);
cmd.Parameters.Add(new
NpgsqlParameter("pwd",NpgsqlTypes.NpgsqlDbType.Bytea);
cmd.prepare()
... set param values, call executereader...
Thanks,
JM
----------------------------------------
Upgrade your account today for increased storage; mail
forwarding or POP enabled e-mail with automatic virus
scanning. Visit our member benefits page at
https://members.canada.com/benefits.aspx for more
information.
From | Date | Subject | |
---|---|---|---|
Next Message | koder | 2006-03-01 18:56:26 | Installing PosygreSQL 8.1 on Windows2003 server in terminal session (remote desktop) |
Previous Message | falcon | 2006-03-01 18:39:24 | a web framework for postgresql? |