CodingForums.com - View Single Post

Abd · 09-25-2002, 02:37 PM

Hi All,

trying to select some field from a Sybase Database, see below for my piece of code, the select statement is not returning any record if AND is use. How can I resolve this, any help. See code below;

SELECT * from nitel_bill_payment where sequence_number = " &pcode& " AND bill_number = "&bill&"

where &pcode& and &bill& are textboxes name

Thanks

Abd

09-25-2002, 02:37 PM	PM User \| #1
Abd New Coder Join Date: Aug 2002 Location: Lagos, Nigeria Posts: 99 Thanks: 0 Thanked 0 Times in 0 Posts	Using AND in Select Script Hi All, trying to select some field from a Sybase Database, see below for my piece of code, the select statement is not returning any record if AND is use. How can I resolve this, any help. See code below; SELECT * from nitel_bill_payment where sequence_number = " &pcode& " AND bill_number = "&bill&" where &pcode& and &bill& are textboxes name Thanks Abd __________________ Abdul