Hi, Hope I can get some help with the SQL statement below. I want to
make both conditions to apply but for some unknown reasons, if the first
"ID" is true, it does not bother with the latter even if it is not
true. ID is a number and the latter is a "text".
Can anyone help ? Been working my head out and it is almost 2.00 AM here
in Sydney.
CK
<!--#include file ="_OpenConnection.inc"-->
<%
'check to see if a previous bid by current bank has been submitted to
the same offer
Dim rsK
Dim strSQL3
Const adOpenStatic = 3
Const Adlockreadonly = 1
Const adcmdtext = 1
strSQL3 = "Select ID AND Bank_Login_Name FROM Bankbids WHERE ID ="&
request("OrderID")'" & Bank_Login_Name = '" & request("Bank_Login_Name)
& "'"
Set rsk = Server.CreateObject("ADODB.Recordset")
rsk.Open strSQL3,conn, adOpenstatic,_
adlockReadonly, adCmdText
If Not rsk.eof then
response.write " You have already bid this Deposit"
else
response.write "go ahead and make my day"
end if
rsk.close
set rsk=nothing
%>
<!--#include file ="_CloseConnection.inc"-->
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
