U SqlQuery : <select contact.cont_name, contact.cont_title, contact.cont_fname, contact.cont_lname,
contact.cont_addr1, contact.cont_addr2, contact.cont_city, contact.cont_zone, contact.cont_country,
contact.cont_zip, contact.cont_phone, contact.cont_fax, contact.cont_mobile, contact.cont_email,
contact_type.ctype_name, company.comp_name, position_type.ptype_name, contact.cont_picture from contact,
outer company, outer contact_type, outer position_type where contact.cont_id = ?
and company.comp_id = contact.cont_org and contact.cont_position = position_type.type_id
and contact.cont_type = contact_type.type_id>
b <<< Bind List >>> SqlQuery INT : |1|
S SSExecute : 00c57430 (Unnamed): Converted SQL=< SELECT contact.cont_name , contact.cont_title ,
contact.cont_fname , contact.cont_lname , contact.cont_addr1 , contact.cont_addr2 , contact.cont_city ,
contact.cont_zone , contact.cont_country , contact.cont_zip , contact.cont_phone , contact.cont_fax ,
contact.cont_mobile , contact.cont_email , contact_type.ctype_name , company.comp_name , position_type.ptype_name ,
contact.cont_picture FROM contact LEFT OUTER JOIN company ON company.comp_id = contact.cont_org
LEFT OUTER JOIN contact_type ON contact.cont_type = contact_type.type_id LEFT OUTER JOIN position_type
ON contact.cont_position = position_type.type_id WHERE contact.cont_id = ? >
b <<< Bind List >>> SqlQuery CHAR(20) : |ALEX |
CHAR(5) : |Mr |
CHAR(20) : |Alex |
CHAR(20) : |Williams |
CHAR(40) : |1 The High Street |
CHAR(40) : |Totton |
CHAR(20) : |Southampton |
CHAR(15) : |Hants |
CHAR(30) : |UK |
CHAR(15) : |SO15 5QR |
CHAR(15) : |023 80232345 |
CHAR(15) : |023 80399685 |
CHAR(15) : |*Null*|
CHAR(50) : |a.williams@querix.com |
CHAR(15) : |*Null*|
CHAR(100) : |Querix (UK) Ltd |
CHAR(15) : |*Null*|
BYTES : ||
u SqlQuery : Returns 0
U SqlQuery : <select contact.cont_name, contact.cont_title, contact.cont_fname, contact.cont_lname,
contact.cont_addr1, contact.cont_addr2, contact.cont_city, contact.cont_zone, contact.cont_country,
contact.cont_zip, contact.cont_phone, contact.cont_fax, contact.cont_mobile, contact.cont_email,
contact_type.ctype_name, company.comp_name, position_type.ptype_name, contact.cont_picture from contact,
outer company, outer contact_type, outer position_type where contact.cont_id = ? and company.comp_id = contact.cont_org
and contact.cont_position = position_type.type_id and contact.cont_type = contact_type.type_id>
S SSExecute : 00c57430 (Unnamed): Converted SQL=< SELECT contact.cont_name , contact.cont_title ,
contact.cont_fname , contact.cont_lname , contact.cont_addr1 , contact.cont_addr2 , contact.cont_city ,
contact.cont_zone , contact.cont_country , contact.cont_zip , contact.cont_phone , contact.cont_fax ,
contact.cont_mobile , contact.cont_email , contact_type.ctype_name , company.comp_name ,
position_type.ptype_name , contact.cont_picture FROM contact LEFT OUTER JOIN company ON company.comp_id = contact.cont_org
LEFT OUTER JOIN contact_type ON contact.cont_type = contact_type.type_id
LEFT OUTER JOIN position_type ON contact.cont_position = position_type.type_id WHERE contact.cont_id = ? > |