Address1字段可能包含"5 Elm Close“--正常排序和顺序将按数字排序,下面将通过查看第二个字符串"Elm”(使用Server)进行排序。SELECT tblcontact.ContactID, tblcontact.Forename, tblcontact.Surname, GROUP BY tblcontact.ContactID, tblcontact.F
var squery = "INSERT INTO SITE (shortName,addressLine1,addressLine2,city,state,zipcode,phoneNumber) VALUES"+ req.body.shortName+", "+ req.body.addressLine21:</l