I have a Recordset that collects all the field entries and chuck them into 

variables. I then have an "If then" which says "OK, if a variable is empty 

then call this function". That bit seems to work fine, the problem it 

appears is with the function. However I cant see for the life of me why it 

doesn't work.



I recieve no SQL errors it simply returns a blank value and not the one I 

specify to return if the function comes back objRS.EOF. It is sometimes 

returning some really strange results, finding the first and writing that 

as the rest, sometimes returning the desired effect for maybe one calling 

and so on. Any ideas would be hugely appreciated. Thanks.



Main Page: http://www.munkeh.co.uk/index.txt



Functions: http://www.munkeh.co.uk/functions.txt



 > Saunton_imageFind()

 > Croyde_imageFind()

 > Woolacombe_imageFind()

 > Putsborough_imageFind()

Hard to tell. Try changing the 0 below to the actual name of the field you

want to retrieve. Does this help? Hard to tell:





    ''' Currently

   Saunton_imageFind = objRS(0) '/* set return value of the function */



    ''' Specifying the field name

   Saunton_imageFind = objRS( "saunton_imageurl" ).value   '/* set return

value of the function */





----- Original Message -----

From: munkeh <munkeh@b...>

To: Access ASP <access_asp@p...>

Sent: Thursday, October 25, 2001 11:05 AM

Subject: [access_asp] Simple Function Problem?





> I have a Recordset that collects all the field entries and chuck them into

> variables. I then have an "If then" which says "OK, if a variable is empty

> then call this function". That bit seems to work fine, the problem it

> appears is with the function. However I cant see for the life of me why it

> doesn't work.

>

> I recieve no SQL errors it simply returns a blank value and not the one I

> specify to return if the function comes back objRS.EOF. It is sometimes

> returning some really strange results, finding the first and writing that

> as the rest, sometimes returning the desired effect for maybe one calling

> and so on. Any ideas would be hugely appreciated. Thanks.

>

> Main Page: http://www.munkeh.co.uk/index.txt

>

> Functions: http://www.munkeh.co.uk/functions.txt

>

>  > Saunton_imageFind()

>  > Croyde_imageFind()

>  > Woolacombe_imageFind()

>  > Putsborough_imageFind()

>