ASP custom Functions, DLookup of VBA domain functions
Source: Internet
Author: User
Function
Function DLookup (strFieldName, strTableName, strwhere, objconn)
' Refer to the DLookup function in Access VBA
' Because the environment is different, add the objconn parameter, direct adodb.connection direct redeployment to
Dim strSQL
Dim RS
Set rs = server. CreateObject ("Adodb.recordset")
' Next to call a custom function outside the Checksql ()
strFieldName = Checksql (strfieldname)
If strwhere <> "" Then
strwhere = "where" & Strwhere
End If
Strsql= "Select" &strfieldname& "from" &strtablename& "" & Strwhere
' Debugstop strSQL
On Error Resume Next
Rs. Open strSQL, objconn, 1, 1
If Err <> 0 Then
Response.Write Err.Description
Response.End ()
End If
If Rs. EOF and Rs. BOF Then
DLookup = ""
Else
' To call a custom function NZ
' For details, refer to the information in ACCESS VBA help
DLookup = Nz (rs (strfieldname), "")
End If
Rs. Close
End Function
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service