Re: Parameters

Paul Watson wrote: > Only guessing but do you need to quote the place holder? No - placeholders are not quoted. SELECT * FROM SomeWhere WHERE SomeColumn = '?'; SELECT * FROM SomeWhere WHERE SomeColumn = ? ; These are two very different queries - one takes a placeholder, and the other does not. >Daniele wrote: >>Jonathan Leffler wrote: >>>That looks like the correct syntax - why do you think it might not be? >> >>Because when I parse the query I receive no error but when I try to >>assign a value to the parameters Sql Server give me the message: >> >>- "Provider cannot derive parameter information and SetParameterInfo >>as not been called." >> >>I think that the odbc driver doesn't implement this type of query.... How do you assign the value to the parameters? Presumably not using SetParameterInfo() - but using what? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

> How do you assign the value to the parameters? Presumably not using > SetParameterInfo() - but using what? I use the Sql Server DTS tools. When you create a Task (DataPump, ExecuteQuery, DataDriven, etc....) in a DTS Package there is a button that let you assign a value to the parameters of the query. I don't know how this tool works, and how It find the parameters in the query. I think it use the odbc function "SetParameterInfo" or some other function that are not implemented in the odbc driver for Informix 5. Thanks for your help. If you have some idea... I'm here.... :-) Bye Daniele