Hi all,
I am bashing my head on this. The script looks OK, but I keep getting this error.
Error number -2147217900
Error description [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933: SQL command not properly ended
URL /site2/CONTRACT_INFO_list.asp
SQL query select "CONTRACT_NUM", "SUPPL_NUM", "MAINT_BILL_START_DT", "MAINT_BILL_END_DT", "MAINT_BILL_CANCEL_DT", "SUPPL_TYPE", "SOURCE_SITE_ID", "SUPPL_STATUS_CD", "SUPPL_CANCEL_DT", "SUPPL_EFFECTIVE_DT", "APP_PRODUCT_CD", "CONTRACT_RELEASE_NUM", "CONTRACT_LEVEL_CD", "CONTRACT_QUANTITY", "CONTRACT_AMT", "BOOK_VALUE_AMT", "ALLOC_AMT", "OVERRIDE_AMT", "ISO_CURRENCY_CD", "SITE_ID", "SUPPL_CREATION_DT" From "ODSTRANSACTION"."CONTRACT_INFO" where "SITE_ID" = 1000000000994
Any suggestions?
Thanks!!
Cleve
Hi all,
I am bashing my head on this. The script looks OK, but I keep getting this error.
Error number -2147217900
Error description [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933: SQL command not properly ended
URL /site2/CONTRACT_INFO_list.asp
SQL query select "CONTRACT_NUM", "SUPPL_NUM", "MAINT_BILL_START_DT", "MAINT_BILL_END_DT", "MAINT_BILL_CANCEL_DT", "SUPPL_TYPE", "SOURCE_SITE_ID", "SUPPL_STATUS_CD", "SUPPL_CANCEL_DT", "SUPPL_EFFECTIVE_DT", "APP_PRODUCT_CD", "CONTRACT_RELEASE_NUM", "CONTRACT_LEVEL_CD", "CONTRACT_QUANTITY", "CONTRACT_AMT", "BOOK_VALUE_AMT", "ALLOC_AMT", "OVERRIDE_AMT", "ISO_CURRENCY_CD", "SITE_ID", "SUPPL_CREATION_DT" From "ODSTRANSACTION"."CONTRACT_INFO" where "SITE_ID" = 1000000000994
Any suggestions?
Thanks!!
Cleve
I looked at the actual ASP page and found that there was a "where rownum <1000" stuck in the SQL. I added this manully to test the app w/o pulling all records. I thought it would only be on the main page though. It also didn;t show in the error message.
OK now.
Thanks,
Cleve
