Re: [WEB400] Querystring for Pulling data Into Webservice

["Rohan Sootarsing" <Rohan.Sootarsing@xxxxxxxxxxxxx>]

ok sorry i should have kiven you more information

this is the rest of the code
[WebMethod]
                public DataSet CTX(string filter)
                {
                        try
                        {
                                iDB2Connection connDB2=new
iDB2Connection(
                                        "DataSource=TDC01;" +
                                        
"userid=RDS;password=sootarsing;DefaultCollection=QGPL;");
                                DataSet ds = new DataSet();
                                iDB2DataAdapter adpt = new
iDB2DataAdapter();
                                adpt.SelectCommand = new
iDB2Command("Select * from ctx4nthg where REF =" + @filter ,connDB2);
                                adpt.Fill(ds);
                                return ds;


And this is how it works with MS SQL 

[WebMethod]
public DataSet GetProducts(string filter)
{
  try
  {
    using(SqlConnection sc = new SqlConnection(
      ConnectionSettings.AppSettings["ConnStr"]))
    {
        SqlCommand cmd = new SqlCommand("usp_GetProducts", sc);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@filter", SqlDbType.VarChar, 35);
        cmd.Parameters["@filter"].Direction =
ParameterDirection.Input;
        cmd.Parameters["@filter"].Value = filter;
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return ds;

Sorry I dont know enough about this to know what i need to do to make
it work for the DB2 connection

Thanks in advance 
Rohan


>>> Pete@xxxxxxxxxx 18/05/2005 14:35:33 >>>
And @filter is ?  A parameter? A literal? A variable in your program?

Seems to me that you'd need a prepared statement so you can pass the 
parameter OR you need some code that generates the SQL string and 
resolves the parameter into and actual value first.

Pete Helgren


Rohan Sootarsing wrote:

>Hi Guys I have a webservice using the following query it works
absolutly
>fine 
>
>new iDB2Command("Select * from ctx4nthg where REF = '123456'"
>,connDB2);
>
>This works fine but I want it to return different results depending
on
>the value of something called filter
>
>i have tried 
>new iDB2Command("Select * from ctx4nthg where REF =" + @filter
>,connDB2);
>and 
>new iDB2Command("Select * from ctx4nthg where REF =@filter"
,connDB2);
>can anyone give me some tips
>
>Rohan
>
>
>
>______________________________________________________________________________
>This message has been checked for viruses by Corpex
>using the ArmourPlate Virus Scanning Service. To find out
>how to protect your company visit http://www.armourplate.com 
>or call Corpex on +44 (0)207 430 8000.
>  
>
-- 
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400 
or email: WEB400-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

______________________________________________________________________________
This email has been checked for viruses by ArmourPlate,
http://www.armourplate.com, the multi-scanner anti-virus facility from
Corpex. 


______________________________________________________________________________
This message has been checked for viruses by Corpex
using the ArmourPlate Virus Scanning Service. To find out
how to protect your company visit http://www.armourplate.com
or call Corpex on +44 (0)207 430 8000.