[Mono-devel-list] Can't filter by a binary parameter..

Curtis Wensley cwensley at mail.sydneyplus.com
Fri Feb 4 19:32:00 EST 2005


Hi,
 
I'm trying to port an asp.net app over to mono/apache/linux, but having a
bit of trouble.  I must warn everyone at this point as I may be asking many
more questions later. (;
 
For Oracle, I have a SQL statement that searches for a record based on a
Binary column, but it does not find any records:
 
----------
string password;
string name;
byte[] bytes = ASCIIEncoding.Unicode.GetBytes(password);

database.Provider.AddParameter(comm, "name", DbType.String, name);
database.Provider.AddParameter(comm, "password", DbType.Binary, bytes);
comm.CommandText = "select fKey from tsysUsers where fName=:name and
fPassword=:password";
----------

This code works perfectly in .NET on windows, but not in mono.  Is is just
because Binary parameters havn't been implemented?  If so, could I help
implement it?
 
I'm running a build of the lastest svn version.

Thanks,
Curtis.
 




More information about the Mono-devel-list mailing list