HI there,

I working with ASP and Access.

I wish to not output my query results within the HTML and output from a procedure or function (i am not sure which one to use) which is called from with in the htl,

By this I mean, where my result set would be output , i wish to use say a
<%= getResults() %>

and the procedure/function use document.write("")

MY QUESTIONS : do I use a function or procedure? Whats is the syntax? and do I use
document.write("html")
Are there any other rules I should remember?

cheers

Steve

Your post is very contradictory so 'fraid I don't totally understand what you are asking

"I wish not to output my query results" then use <%=getResults()%> which would actually output the function results with the HTML

using a function or subroutine is up to you.
The difference is a function can return a value while a subroutine doesn't.
A function would be written as (simple example)

<%
function getResults()
dim a,b
a = 3
b = 5
getResults = a * b
end function
%>

For useage a function can be;
<%=getResults() %>
The "=" sign is shorthand for response.write() in an inline call (surrounded by delimiters "<% %>"
so in code segments it would be
response.write(getResults())
to output the return value or
variable = getResults()
to set a variable to the return value.
A subroutine can process values but any output must be done within the sub

<%
sub getResults()
dim a
dim b
a = 3
b = 5
response.write a * b
end sub
%>

And a subroutine can be called as
getResults()

This would simply write the value of a * b wherever the routine was called and the same syntax is used for inline or code segment calls.

HTH


NOTE the above is assuming you are using vbScript for the asp language and not JScript.

Thats great. Thanks very much.
Steve