Problems writing a function

[cyberprof]

I'm trying to write a function to place in a loop

I want to pass a date through the function to return a true or false value

This is what I have so far..

------------------------
Do until rst.EoF
dte = rst("Date")

IF TSExists(Dte) = "True" THEN
Do this
ELSE
Do this
END IF

rst.movenext
LOOP
------------------------

<% Function TSExists(Dte)

TSExists = "False"
pass 'dte' through a query
If recordcount <> 0 Then TSExists = "True"

END Function %>

When I run the page I receive this error:

Type mismatch: 'TSExists'

Any help will be appreciated

J

 

[trollacious]

Try it without the quotes:

IF TSExists(Dte) = True THEN

Lee

 

[cyberprof]

Same error, "Type Mismatch

 

[RhythmAddict112]

Does the same thing happen when you pass a static value (not a request form/querystring) into the function?

Pass a date you know exists into the function and lets see what happens..

 

[trollacious]

I would lose the quotes on ALL references and make TSExists totally boolean:

TSExists = False

or

TSExists = True

 

[cyberprof]

There should always be a value in 'dte', but I will try.

 

[cyberprof]

OK, I've changed it totally boolean and I passed a manual date through the function TSExists("12/01/05"), but still the same error.

 

[cyberprof]

This might seem wierd, but I've been trying a few different options and I've got it working just be changing TSExists to TSE

Doesn't make sense!!!

 

[cyberprof]

Is 'Exists' a keyword in some way

 

[RhythmAddict112]

Not to my knowledge. Don't think it'd make a difference, according to the code above you dont have exists anywhere unless there is "TS" in front of it.

Let's see your actual code with the query in the function, etc