After a week vacation, I'm back to work. Curitiba is very good! :) I hope to go there more often.
Hi, all! We have received some users questions about how to send a list of values to be used in queries using the "in" operator. Something like: select foo, bar from table where foo in (blah1, blah2, blah3); Npgsql supports array-like parameter values and the first idea to have this working would try to use it directly: NpgsqlCommand command = new NpgsqlCommand("select * from tablee where field_serial in (:parameterlist)", conn); ArrayList l = new ArrayList(); l.Add(5); l.Add(6); command.Parameters.Add(new NpgsqlParameter("parameterlist", NpgsqlDbType.Array | NpgsqlDbType.Integer)); command.Parameters[0].Value = l.ToArray(); NpgsqlDataReader dr = command.ExecuteReader(); but unfortunately this won't work as expected. Npgsql will send a query like this: select * from tablee where field_serial in ((array[5,6])::int4[]) And Postgresql will complain with the followin...
Comments
I would like to tell everyone I know about a new web site for web design and hosting... If you are looking on ways to mkae money starting a business and need a site to host it on . Visit http://webhost-er.com/ Today
buy aceon
aceon online
drug aceon
buy aceon online
100 mg aceon
avapro
avapro hct
buy avapro
avapro medicine
avapro weight loss
order avapro
cheap avapro
avapro drug
avapro generic
generic avapro
avapro buy generic
avapro canada
avapro online cheap
avapro order
best avapro deal
order avapro online
buy avapro and overseas
buy avapro on the net
canada online avapro
avapro and hairloss
online pharmacy for avapro
cheap avapro online
avapro best buy
avapro treatment
buy avapro generic
prepscription avapro
on line avapro
avapro medication
avapro 150 mg
avapro cough
avapro 300mg