Tom Blough

Ranch Hand
+ Follow
since Jul 31, 2003
Merit badge: grant badges
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Tom Blough

Most people don't have time to wade through a bunch of code, so if you could distill your problem down to a few lines of code, you might get some more responses. Also, please post any exceptions you code generates.

One thing you might look at is updates and inserts routinely fail because of problems related to the keys.
You can connect from a Windows machine to an MDB file that resides on a Linux machine using this method, but you cannot connect from a Linux machine to a MDB file residing on another computer this way.

This "DSN-less" connection is not really DSN-less. Instead of configuring an explicit System or Machine DSN using the ODBC manager on a Windows box, when the JDBC:ODBC bridge contacts the ODBC service with the DSN string, the ODBC service creates the connection on the fly.

Linux does not have the Windows ODBC service, so it cannot create the DSN on the fly.

Cheers,
[ February 01, 2006: Message edited by: Tom Blough ]
On the remote machine, share the folder that contains the mdb file (in this case it would be the "data" directory). Then, just use the fully qualified path to access it.



Cheers,
[ January 31, 2006: Message edited by: Tom Blough ]
If you have access to Access and both MDB files, use import/link to add a symbolic link to one of the tables in the other database. You can then use a simple SQL to accomplish the task in the MDB that contains both the tables:



Cheers,

Originally posted by Ken Blair:
I didn't say there was no reason to convert to CHM, I just pointed out you can search the Javadoc using Google. A lot of people forget (or don't know to begin with) that you can specify a site.



Really??? I just tried it on the airplane yesterday and I got a DNS error when trying to connect to Google. Perhaps your solution only works when you have an internet connection and the lister was looking for something that worked ALL the time?

Google is great when you are connected. For a complete list of Google advanced operators - http://www.google.com/help/operators.html.

Cheers,
18 years ago

Originally posted by srini vasan:


Java doc is there then why you need Chm.



Because you can't search the API documentation in Javadoc format?
18 years ago
Good point Jim. Just as we strive for abstraction in our class design, we should also look to abstraction in our algorithm design.

Cheers,
18 years ago

Originally posted by Grant Gainey:
[Edited to add the generic]



Great minds think alike
18 years ago
If you are using Java 1.5, you might also look at For-Each. If you just need to move through the elements, then for-each works great. If you multiple iterators to access an element (i.e. multidimensional lists), or want to delete items, then you can't use the for-each construct.



Cheers,
[ December 14, 2005: Message edited by: Tom Blough ]
18 years ago
Or, use regular expressions:



The regular expression removes anything between and including the < and > and since regular expressions are greedy, it will continue to do it to the end of the line.

Cheers,
[ December 14, 2005: Message edited by: Tom Blough ]
18 years ago
Jeff,

Unfortunately, I can't rely on a collision using my key. The key is a data stamp generated from a machine on our factory floor that uses both upper and lowercase letters. Each date code is unique, but Access thinks "dqKez" is the same as "dqKeZ" as far as unique primary keys are concerned (it's not case sensitive for key comparison).

Access IS case sensitive on queries, so the work-around is check if it exists first, and add only if it does not. If the search returns the key, then I handle the exception case.

Cheers,
Due to Access' lack of case sensitivity on the primary key, I need to check if a record exists before I insert a new record. Is it faster to return a count, or to return actual data from a table? I.E. which of the following queries will be faster?

1) SELECT COUNT(*) FROM table WHERE id = 'Test';

or

2) SELECT id FROM table WHERE id = 'Test';

I don't really need the info returned - I'll just check to see if ResultSet.next is true.

Thanks,
In Oracle you should be able to use something like:

SELECT SUM( TO_DATE( hoursfield, 'HH24:MI,SS')) AS tot_hrs;

Cheers,
Try converting to your database's time format (or date) and then just add the values. The SQL functions for date/time are still pretty much database specific.

What database are you using?

Cheers,
You are creating a new TimerTask each time. Either re-use your timer task, or add code to start the timer only if it is not already running.

Cheers,
18 years ago