Try this: (tested on SQL 2000) SELECT TOP 6 Title FROM ( SELECT P\_Title As Title FROM tblProjects WHERE Status='True' UNION ALL SELECT Title FROM tblProjectDocs WHERE Status='True' ) As Titles ORDER BY Title DESC If you miss out the "As Titles" before the "ORDER BY", you'll get an "Incorrect syntax" error message.

If you are using SQL Server then: SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'yourtablename' AND COLUMN_NAME = 'your column name'

Try: Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open strConnect oConn.Execute "UPDATE tblProjectCats SET Title ='Title', Description = 'Desc' WHERE ID=1", , adExecuteNoRecords Or adCmdText objConn.Close Set objConn = Nothing

The RegExp object was added to VBScript in version 5, and to JavaScript in version 3. Just of the top of my head, you need something like: <a\s[^>]*?href=['"]([^'">]*?)['"][^>]*?>(.*?)</a> to be replaced with: $2 [$1] (with IgnoreCase = True, Global=True, MultiLine = False)

If you are using the FSO object then just append a " " at the end of your WriteLine method. HTH Nick Parker

this should get records updated only in the last seven days as well but I haven't checked this yet as I'm late for work :D strSql = "" strSql = strSql & "SELECT * FROM Table WHERE Cat_ID =" & ActiveID strSql = strSql & " AND modifiedDate >= '"& DateAdd("d", now(), -7) &"' ORDER BY modifiedDate " RS1.Open strSql, DB1, adopenstatic HTH

It works fine, but MapPath cannot map file names with wildcards. You need to map the directory first and then add a file name, like this: set fso = Server.Createobject("Scripting.FileSystemObject") fso.DeleteFile Server.MapPath("\files\") & "\file" & EditCatID & "*.asp" set fso = nothing Philip Patrick Web-site: www.saintopatrick.com "Two beer or not two beer?" Shakesbeer Need ASP hosting? Check out 123HostNow.com