473,327 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Tabular Data Control question

Hello,

I am using the TDC Active X object to display a results set from a txt
file. I have a simple search form which builds up a filter string
before the tdc control is reset.

e.g.

var filterstr = 'name = *SMITH*';
window.parent.frames(2).document.all.tdc.filter=fi lterstr;
window.parent.frames(2).document.all.tdc.Reset();

My text file is made up of free text columns and the search will only
match on exact case matches. How do i get around the problem of case
sensitvity in my filter? Is there an equivalent of the upper() or
toUpperCase() function that i could wrap around my columns names to to
ensure that case is not an issue?

e.g.

var filterstr = 'upper(name) = *SMITH*';
window.parent.frames(2).document.all.tdc.filter=fi lterstr;
window.parent.frames(2).document.all.tdc.Reset();

This falls over but does anyone know if this is possible and, if so,
the correct way to do this?

Cheers

James
Jul 20 '05 #1
1 2419
I have solved this...

var filterstr = 'name = *SMITH*';
window.parent.frames(2).document.all.tdc.CaseSensi tive=false;
window.parent.frames(2).document.all.tdc.filter=fi lterstr;
window.parent.frames(2).document.all.tdc.Reset();

je********@hotmail.com (James Broome) wrote in message news:<37**************************@posting.google. com>...
Hello,

I am using the TDC Active X object to display a results set from a txt
file. I have a simple search form which builds up a filter string
before the tdc control is reset.

e.g.

var filterstr = 'name = *SMITH*';
window.parent.frames(2).document.all.tdc.filter=fi lterstr;
window.parent.frames(2).document.all.tdc.Reset();

My text file is made up of free text columns and the search will only
match on exact case matches. How do i get around the problem of case
sensitvity in my filter? Is there an equivalent of the upper() or
toUpperCase() function that i could wrap around my columns names to to
ensure that case is not an issue?

e.g.

var filterstr = 'upper(name) = *SMITH*';
window.parent.frames(2).document.all.tdc.filter=fi lterstr;
window.parent.frames(2).document.all.tdc.Reset();

This falls over but does anyone know if this is possible and, if so,
the correct way to do this?

Cheers

James

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: bobdedogh | last post by:
can anyone add live hyperlinks to the sortable table made by the code supplied by Machi, or know of a simple alternative bob Machi wrote Mar 10 1999, 8:00 am >>>>>>>>>>>>>> .... Hello...
1
by: Christopher | last post by:
Hi... I would be very grateful If You could resolve my question, my question is "How do tabular a ListBox that their property DrawMode is OwnerDrawFixe?". I do know as tabular a listbox, but I...
1
by: tolaskram | last post by:
We're developing an ASP.NET 2.0 (C#) application that needs to display array data in a tabular format. Some might say "simply use the GridView control," which might work for us. But, we have a...
2
by: t | last post by:
Hi, I have the following problem. The web-based software I am to create is going to display tabular data. Lots of data so I need some pagging mechanism. I thought about creating three classes:...
0
by: dave k | last post by:
I want to copy data from selected fields in a record on a tabular form (called 'ProductUpdate') to the next record when those two records have a common field - called 'BaseFund' . The selected...
38
by: Sanders Kaufman | last post by:
I'm converting my table-based layouts to css-positioned divs - but the ONLY reason I'm doing it is because it's *considered* a best practice. I don't really see where anything goes hinky when...
5
by: Lars Eighner | last post by:
Is a calendar tabular data, logically meriting table markup? -- Lars Eighner <http://larseighner.com/ <http://myspace.com/larseighner> Countdown: 465 days to go. What do you do when...
3
scubak1w1
by: scubak1w1 | last post by:
Hello, I am wanting a "pretty output" of tabular data generated on the fly and saved in an array (PHP)... That is, I have a link so users can chart (JpGraph) and download (CSV) tabular data,...
1
by: LBLB | last post by:
In terms of processing speed, what is the best method for displaying tabular data from a database in a Windows forms C# app? We generally use data grids (Infragistics WinGrid), but have an instance...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.