Problem in passing query string as parameter

[2001 JI Open Discussion]

By: hitendra prabhakar - hitendrap

Problem in passing query string as parameter

2002-09-05 06:37

When i try to pass the entire Query string as a parameter .....it gives Incorrect syntax error.But if i put the same query directly in the query string tag...it works perfectly..

Could anybody tell me why is this happening???

 

Thanks in advance!!!

hitendra

 

 

By: Teodor Danciu - teodord

RE: Problem in passing query string as parameter

2002-09-05 06:48

 

Hi,

 

Does your SQL query, which you send as

a parameter, contains itself other parameter

references? May I see it?

 

You have to decide whether you build the query

yourself entirely or you use parameters in it.

Not both.

 

Thank you,

Teodor

 

 

 

By: hitendra prabhakar - hitendrap

RE: Problem in passing query string as parameter

2002-09-05 21:57

Hi,

The Query which i pass as a parameter is just a simple Select * from ..... and there is no other parameter i try to pass to it....

i try to pass this entire query as a parameter and there is no *where* condition in my query..

 

My Query is really simple:"Select * from workelement_details"

....thats it...

i hope u got the entire thing...

Thanks,

hitendra