select

grstad · June 17th, 2005, 11:59 AM

Can anybody fullfill this sentence for me. I mean to put in the right number of ' and "

objrs2.Open "Select * from idtab where antkuberid <= '" request.form("kube")'", loginbase, adlockreadonly, adcmdtable

It should also have antkuberid > 0 in it

Thanks!

happygv · June 17th, 2005, 06:56 PM

Is this what you mean?

Code:

objrs2.Open "Select * from idtab where antkuberid <= " & request.form("kube"), loginbase, adlockreadonly, adcmdtable

Hope that helps.

_________________________
- Vijay G
Strive for Perfection

grstad · June 18th, 2005, 09:34 AM

Yes, probably. I have not yet tried it in the browser, but my problem was that I got a error-message that told me to end the querry in a proper way. In other words; get the number of the ' and the " right. I do not anderstand the use of ' and " !!

In addition I also want to incorporate the condition antkuber > 0 into the querry.

Thank you for your attention.

happygv · June 18th, 2005, 06:32 PM

Code:

objrs2.Open "Select * from idtab where antkuber > 0 and antkuberid <= " & request.form("kube"), loginbase, adlockreadonly, adcmdtable

Hope this is what you wanted. But I would suggest you to validate the value of "KUBE" using ASP, so that when you send it across for execution in SQL statement, you will know for sure that the value is > 0 and in that case you don't have to use the "antkuber > 0" condition there.

Hope that helps.
Cheers

_________________________
- Vijay G
Strive for Perfection

grstad · April 28th, 2006, 09:07 AM

... thank you for responding! I did forget to say this. It is never too late!

Med vennlig hilsen
grstad