Hi, I am using ASP to list tables in ORACLE - a lot of these tables have been created in lower case - so for normal SQL - select * from MYSCHEMA."mytable" is ok. When I use the ASPRunner wizard - and select one of these lowercased tables - the attribute list is blank. Any thoughts? Setup:
ORACLE 817 on AIX 4.3.2
Windows XP Pro + SP1a + IIS + Oracle 817 ODBC driver.
Hi, what is the "attribute list"? Do you mean fields list? Does it work fine with tables that not in lowercase?
5010162/26/2004
Hi, Yes - I do mean the 'fields' list (ie. columns). The code works fine for tables/fields that have not been created specifically as mixed/lower case (which ORACLE/DB2 will by default treat as uppercase). Normal table creation:
create table MY_DEFAULT_TABLE ( FIELD1,..,) vs. Mixed/lower case table creation:
create table "My_lower_case_table" ("field1",..,) I'm not sure if this is a code bug/ASP limitation. Anyway any thoughts/tips are always welcome. Thanks
5010172/26/2004
Update. I can illustrate the problem by a different example: I want to select two fields: $COID and S_PART_NUMBER. We know the $ symbol is a special character - to get around it we surround the field we are selecting in quotes, ie. select "$COID",S_PART_NUMBER from mytable ; However, if I manually edit the SQL in ASPRunner to this - I get this error when viewing the web page because of the way the string is built. Microsoft VBScript compilation (0x800A0408)
Invalid character
/ASPRunner/include/PART_LIST_variables.asp, line 15, column 19 gstrSQL = "select "$COID", S_PART_NUMBER From EH101.PART_LIST " I think the same thing is happening when I use table names or fields which are created as lower case. If try to use 2 single quotes (ie. ''$COID'') or [] (ie. [$COID]) in the "Edit SQL manually" - section I get an error and cannot proceed. Please Note:
I get this problem whether I use the Microsoft or ORACLE ODBC drivers. Any help always appreciated.
5010182/26/2004
Update I don't want to have get round this using views if I can help it.