Dates, Drop Fields and many more

[Russell B Woodhall]

Folks

I'm using ASPDb to access a Oracle 8 table with dates and all are returned in the format YY/MM/DD, although our W95 and database settings are DDMMYYYY. How can I change the formats?

I seem to be able to get filter dropdowns working with numeric data but not Varchar fields. What datatypes work with this feature?

I'm using a view to pull together eight small description tables to a main table to avoid displaying meaningless codes to users. My view is fully optimised but the performance is slow. I am assuming that the table is being cached somewhere, can I optimise ASPDb any more? We're only talking about 2600 records and setting dbRecordCount doesn't make much difference.

I want users to be able to enter filter text strings in any case. I use SQL function in my Oracle view to change the table field from upper to proper case. Are there any parameters I can use in filters to change the input case type?

So many questions!! Thanks for your help

Great product!!

Russell

[Frank]

Russell,

1. Use MagicCell to control the format (incl date) of the cell display. Shoul dnot have to change the data in the DB as long as th4e datatype is of date type.

2. What data type you experience problemn in drop down. Use the datatype.asp utilility to find out. Let me know and I'll make sure the datatype is supported.

3. Performance - Note that the first action involves the loading of the DLL. It does that also after a time out. So it is the next action (clicks) that counts. Use PureAsp.asp utility to Open the view and compare the performance with ASPDB. Post the code and let's take a look. Make sure you are using X.dbDBType="ORCACLE,Server" if you are using it on a server. the regular dbDBType="ORACLE" is for ORACLE Client (they behaves differently) only asn is slow due to the counting.

4. I tried to use mix case in filter in both ORACLE and MS-SQL and has no luck. If you know of a way to do it in the native environment of both, please let me know and I'll implement it into ASPDB.


Frank





On 2/10/99 12:08:19 PM, Russell B Woodhall wrote:
> Folks

I'm using ASPDb to access a Oracle 8 table with dates and all
> are returned in the format YY/MM/DD, although our W95 and database settings
> are DDMMYYYY. How can I change the formats?

I seem to be able to get
> filter dropdowns working with numeric data but not Varchar fields. What
> datatypes work with this feature?

I'm using a view to pull together
> eight small description tables to a main table to avoid displaying
> meaningless codes to users. My view is fully optimised but the performance
> is slow. I am assuming that the table is being cached somewhere, can I
> optimise ASPDb any more? We're only talking about 2600 records and
> setting dbRecordCount doesn't make much difference.

I want users to
> be able to enter filter text strings in any case. I use SQL function in my
> Oracle view to change the table field from upper to proper case. Are there
> any parameters I can use in filters to change the input case type?

So
> many questions!! Thanks for your help

Great product!!

Russell

[Russell B Woodhall]

Franks

Thanks for your help

1.

On 2/10/99 1:43:34 PM, Frank wrote:
> Russell,

1. Use MagicCell to control the format (incl date) of the cell
> display. Shoul dnot have to change the data in the DB as long as th4e
> datatype is of date type.

2. What data type you experience problemn in
> drop down. Use the datatype.asp utilility to find out. Let me know and
> I'll make sure the datatype is supported.

3. Performance - Note
> that the first action involves the loading of the DLL. It does that also
> after a time out. So it is the next action (clicks) that counts. Use
> PureAsp.asp utility to Open the view and compare the performance with
> ASPDB. Post the code and let's take a look. Make sure you are using
> X.dbDBType="ORCACLE,Server" if you are using it on a server. the
> regular dbDBType="ORACLE" is for ORACLE Client (they behaves
> differently) only asn is slow due to the counting.

4. I tried to use mix
> case in filter in both ORACLE and MS-SQL and has no luck. If you know of a
> way to do it in the native environment of both, please let me know and
> I'll implement it into ASPDB.


Frank





On 2/10/99 12:08:19
> PM, Russell B Woodhall wrote:
> Folks

I'm using ASPDb to access a
> Oracle 8 table with dates and all
> are returned in the format YY/MM/DD,
> although our W95 and database settings
> are DDMMYYYY. How can I change
> the formats?

I seem to be able to get
> filter dropdowns working with
> numeric data but not Varchar fields. What
> datatypes work with this
> feature?

I'm using a view to pull together
> eight small
> description tables to a main table to avoid displaying
> meaningless
> codes to users. My view is fully optimised but the performance
> is
> slow. I am assuming that the table is being cached somewhere, can I
>
> optimise ASPDb any more? We're only talking about 2600 records and
>
> setting dbRecordCount doesn't make much difference.

I want users to
>
> be able to enter filter text strings in any case. I use SQL function in
> my
> Oracle view to change the table field from upper to proper case.
> Are there
> any parameters I can use in filters to change the input case
> type?

So
> many questions!! Thanks for your help

Great
> product!!

Russell

[Russell B Woodhall]

Franks

Thanks for your help

1. MagicCell worked well, your manual just wasn't very helpful.
2. I'm using an Oracle VARCHAR field.
3. Your suggestion to use the 'Oracle,Server' parameter improved performance. Using ASPDB, my page which starts with a filter, takes about 17 seconds to appear. Using PureASP, it took 12 to show the grid. I mislead you with my query, I actually join 15 minor tables to the main 2,600 row table, not just eight. The performance when accessing just the main table is virtually instant. {Perhaps my use of joining 16 tables is a little *****ious to judge ASPDB). I can email to you my code, if you still want to see it.
4. The Oracle function to put captitals at the start of text is INITCAP. In SQLBase, the function is @PROPER. According to TECHNET, there is no similar MSSQL6.5 function. I would have thought this was a fairly universal function requirement these days. I'll have to return back some fields to uppercase for filtering purposes, but it makes presentation poor. Are there any more undocumented FORMAT values other than Currency and Date?

Again, thanks your help Frank,

Russ

On 2/10/99 1:43:34 PM, Frank wrote:
> Russell,

1. Use MagicCell to control the format (incl date) of the cell
> display. Shoul dnot have to change the data in the DB as long as th4e
> datatype is of date type.

2. What data type you experience problemn in
> drop down. Use the datatype.asp utilility to find out. Let me know and
> I'll make sure the datatype is supported.

3. Performance - Note
> that the first action involves the loading of the DLL. It does that also
> after a time out. So it is the next action (clicks) that counts. Use
> PureAsp.asp utility to Open the view and compare the performance with
> ASPDB. Post the code and let's take a look. Make sure you are using
> X.dbDBType="ORCACLE,Server" if you are using it on a server. the
> regular dbDBType="ORACLE" is for ORACLE Client (they behaves
> differently) only asn is slow due to the counting.

4. I tried to use mix
> case in filter in both ORACLE and MS-SQL and has no luck. If you know of a
> way to do it in the native environment of both, please let me know and
> I'll implement it into ASPDB.


Frank





On 2/10/99 12:08:19
> PM, Russell B Woodhall wrote:
> Folks

I'm using ASPDb to access a
> Oracle 8 table with dates and all
> are returned in the format YY/MM/DD,
> although our W95 and database settings
> are DDMMYYYY. How can I change
> the formats?

I seem to be able to get
> filter dropdowns working with
> numeric data but not Varchar fields. What
> datatypes work with this
> feature?

I'm using a view to pull together
> eight small
> description tables to a main table to avoid displaying
> meaningless
> codes to users. My view is fully optimised but the performance
> is
> slow. I am assuming that the table is being cached somewhere, can I
>
> optimise ASPDb any more? We're only talking about 2600 records and
>
> setting dbRecordCount doesn't make much difference.

I want users to
>
> be able to enter filter text strings in any case. I use SQL function in
> my
> Oracle view to change the table field from upper to proper case.
> Are there
> any parameters I can use in filters to change the input case
> type?

So
> many questions!! Thanks for your help

Great
> product!!

Russell