FengShui1998
MIS
Hello,
I have an SQL query that returns alot of columns from several tables. In object result, I can access some columns such as PIN = objRs("PIN") or other column names. However when I try to access another column like phone = objRs("Phone") the ASP page blows up. In VbScript, I have no problems accessing "phone" so I don't think this is an SQL problem. If I reduce the number of fields or columns in the query, the ASP works fine. Is there a setting for the number of fields returned in an SQL query for an ASP page. There's only one record that's returned so it is not the number of records.
Any help would be greatly appreciated
Thanks,
fengshui_1998
I have an SQL query that returns alot of columns from several tables. In object result, I can access some columns such as PIN = objRs("PIN") or other column names. However when I try to access another column like phone = objRs("Phone") the ASP page blows up. In VbScript, I have no problems accessing "phone" so I don't think this is an SQL problem. If I reduce the number of fields or columns in the query, the ASP works fine. Is there a setting for the number of fields returned in an SQL query for an ASP page. There's only one record that's returned so it is not the number of records.
Any help would be greatly appreciated
Thanks,
fengshui_1998
