Replace if empty record

[graficus]

Is this do-able?

<%
if shopdynamictitle = "" then ' if nothing is in dynamic
shopdynamictitle = "myowntitle"
end if
%>

I need to check if dynamic (meta tag) title is empty. If so then insert my own static.

[Baleric]

yes that is do-able.

<%

if shopdynamictitle = "" then 

'if variable is equal to nothing.

       shopdynamictitle = "myowntitle"
else 

'if variable it is NOT equal to nothing.

      shopdynamictitle = blahblahblah  
end if

%>

[degsy]

you could do it in the query.

Here is an example using Access

SELECT IIF(IsNull(doctitle),"No Title",doctitle) as fixedTitle
FROM table;