Hi all. I've searched the forum for an answer to this, someone had a similar problem but never came back with the code for a solution to be posted so hope I'm not wasting anyone's time!
I am using string strSQL to take on an SQL statement that takes data from several tables to output to Excel. However, the string seems to cut the text short at around 250 characters. From what I can tell it should accept more characters than this and it certainly used to work... can anyone explain to me why it might be cutting it short? Here's the code:
I am using string strSQL to take on an SQL statement that takes data from several tables to output to Excel. However, the string seems to cut the text short at around 250 characters. From what I can tell it should accept more characters than this and it certainly used to work... can anyone explain to me why it might be cutting it short? Here's the code:
PHP:
strSQL = "SELECT TBLStaff.StaffName, TBLStaff.Initials, TBLOrg.Organisation, TblContact.Title, [FirstName] & ' ' & [LastName] AS Contact, [Department] & ', ' & [Address1] & ', ' & [Address2] & ', ' & [Address3] & ', ' & [Town] & ', ' & [Postcode] AS Address "
strSQL = strSQL & "FROM TBLOrg RIGHT JOIN (TBLStaff RIGHT JOIN (TblContact RIGHT JOIN TBLTender ON TblContact.ContactID = TBLTender.ContactID) ON TBLStaff.StaffID = TBLTender.StaffID) ON TBLOrg.OrgID = TBLTender.OrgID WHERE "
strSQL = strSQL & "(((TBLTender.TenderID)="
strSQL = strSQL & intTenderID & "));"