Executing UDF with an input parameter

[zuza]

Hi there,

I want to execute UDF with input parameter claimno = request.form(claimno) ... how do I have to write the statement, for instance:
str="select top 1 statusnew from getNewStatusByDS(" & "'Claimno'" & ") order by datemax desc"

Or in different way ... maybe completely wrong.

ciao,
ZuZa.

 

[ChrisHirst]

assuming your function is getNewStatusByDS() and it returns some value.

probably;

str="select top 1 statusnew from " & getNewStatusByDS(Claimno) & " order by datemax desc"
[code]





Chris.

Indifference will be the downfall of mankind, but who cares?
[URL unfurl="true"]www.candsdesign.co.uk[/URL] A website that proves the cobblers kids adage.
[URL unfurl="true"]www.cram-system.com[/URL] Nightclub counting systems

So long, and thanks for all the fish.

 

[zuza]

Thnx,

this one is OK.

str = "SELECT top 1 statusnew from getNewStatusByDS('" & claimno & "')" & " order by datemax desc"
[code]

Rgds.