# Set the socket parameters
host = "localhost"
port = 21567
buf = 1024
addr = (host,port)

# Create socket and bind to address
UDPSock = socket(AF_INET,SOCK_DGRAM)
UDPSock.bind(addr)

# Receive messages
while 1:
	data,addr = UDPSock.recvfrom(buf)
	if not data:
		print "Client has exited!"
		break

// if objRS2.recordcount = 0
if objRS.recordcount = 0 then  
response.write "No records found"
else
propcode2 = objRS("propcode")
proptitle2=objRS("proptitle")
end if

SELECT TOP 3 * FROM ORDERS ORDER BY ORDER_DATE_TIME DESC

strSQL = "SELECT RFCInfo.Name, RFCInfo.Date, RFCInfo.RFCNo, RFCInfo.InvNo, RFCInfo.Deleted, InvoiceDetail.Quantity, InvoiceDetail.Description, InvoiceDetail.ExtendedPrice, InvoiceInfo.GST, InvoiceInfo.PST, InvoiceInfo.Total FROM RFCInfo INNER JOIN (InvoiceDetail INNER JOIN InvoiceInfo

Select * from Employees where name like '%John%'

sql = "SELECT DISTINCT name, extension FROM Employees WHERE name = '" & Request.Form("name") & "'"

MyConnection.Open "Driver={Microsoft Access Driver (*.mdb)};" & _

strYourString = Mid(strYourString, 1, Len(strYourString)-1)

SELECT DATEPART(week, GETDATE()) AS 'Week Number'
GO