%@LANGUAGE="VBSCRIPT"%>
<%
Dim rsLeftPic__MMColParam
rsLeftPic__MMColParam = "Left"
If (Request("MM_EmptyValue") <> "") Then
rsLeftPic__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsLeftPic
Dim rsLeftPic_numRows
Set rsLeftPic = Server.CreateObject("ADODB.Recordset")
rsLeftPic.ActiveConnection = MM_LondonKeyholding_STRING
rsLeftPic.Source = "SELECT * FROM Pictures WHERE PictureLocation = '" + Replace(rsLeftPic__MMColParam, "'", "''") + "'"
rsLeftPic.CursorType = 0
rsLeftPic.CursorLocation = 2
rsLeftPic.LockType = 1
rsLeftPic.Open()
rsLeftPic_numRows = 0
%>
<%
Dim rsRightPic__MMColParam
rsRightPic__MMColParam = "Right"
If (Request("MM_EmptyValue") <> "") Then
rsRightPic__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsRightPic
Dim rsRightPic_numRows
Set rsRightPic = Server.CreateObject("ADODB.Recordset")
rsRightPic.ActiveConnection = MM_LondonKeyholding_STRING
rsRightPic.Source = "SELECT * FROM Pictures WHERE PictureLocation = '" + Replace(rsRightPic__MMColParam, "'", "''") + "'"
rsRightPic.CursorType = 0
rsRightPic.CursorLocation = 2
rsRightPic.LockType = 1
rsRightPic.Open()
rsRightPic_numRows = 0
%>
<% Dim rrSource_rsLeftPic, rrRecCount_rsLeftPic, re_rsLeftPic
Set re_rsLeftPic = New regexp
re_rsLeftPic.Pattern = "SELECT (.*) FROM "
re_rsLeftPic.Global = False
re_rsLeftPic.IgnoreCase = True
rrSource_rsLeftPic="Select Count(*) as RecCount From " & re_rsLeftPic.Replace(rsLeftPic.Source,"")
rrRecCount_rsLeftPic=CInt(rsLeftPic.ActiveConnection.Execute(rrSource_rsLeftPic)("RecCount"))
Set rrSource_rsLeftPic = Nothing
Set re_rsLeftPic = Nothing
%>
<% Dim rrSource_rsRightPic, rrRecCount_rsRightPic, re_rsRightPic
Set re_rsRightPic = New regexp
re_rsRightPic.Pattern = "SELECT (.*) FROM "
re_rsRightPic.Global = False
re_rsRightPic.IgnoreCase = True
rrSource_rsRightPic="Select Count(*) as RecCount From " & re_rsRightPic.Replace(rsRightPic.Source,"")
rrRecCount_rsRightPic=CInt(rsRightPic.ActiveConnection.Execute(rrSource_rsRightPic)("RecCount"))
Set rrSource_rsRightPic = Nothing
Set re_rsRightPic = Nothing
%>
London Keyholding Company - Request Quote
|
|
|
|
|
Request Quotation
If you would like a quotation please complete the form below and we will get back to you as soon as possible.
*Required Fields
|
|
| Kings Cross Head Office |
Key House,
15 Kings Exchange,
Tileyard Road,
London
N7 9AH |
| Tel. 020 7691 9876 |
| Fax. 020 7691 9889 |
| Email - Click Here |


|
|
Key House, 15 Kings
Exchange, Tileyard Road, London N7 9AH |
0800
587 7091 020 7691 9889 |
|
|
|
<%
rsLeftPic.Close()
Set rsLeftPic = Nothing
%>
<%
rsRightPic.Close()
Set rsRightPic = Nothing
%>