This topic is locked

Using Lower Case table names

2/25/2004 7:22:18 PM
ASPRunnerPro General questions
author

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.

Sergey Kornilov admin 2/25/2004

Hi,
what is the "attribute list"? Do you mean fields list?
Does it work fine with tables that not in lowercase?

501016 2/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

501017 2/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.

501018 2/26/2004

Update
I don't want to have get round this using views if I can help it.