|
shane i tried that but get errors on compiling the name querystring does not exist in the class or namespace >>> Shane_Cessna@xxxxxxx 18/05/2005 14:37:22 >>> Rohan, have you tried: @querystring = "Select * from ctx4nthg where REF = "; @newstring = @querystring + @filter; new iDB2Command(@newstring,connDB2); hope this helps... Shane 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 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.