Search results for query: *

How is it determined when the "current" link is chosen? -vza

ChrisHunt... I appreciate your response, I will give these methods a try and see if I can work it out... -vza

Thanks for the responses! I am not too familiar with javascript...what would be the best way to do implement something like this? -vza

div.navMenu a:active { color: #000000; background-color: #FFCC00; background: #FFCC00; } I currently have created a <div> tag within my jsp page which contains numerous links to Navigate around my site. I have inserted the following style definition in my CSS style...

r937, Sorry for the delay....I appreciate the response... select sum(unix_timestamp( coalesce(ll.endtime,now()) - unix_timestamp(ll.starttime)) as DEVICE_TIME from loghistories lh inner join loglocations ll on (lh.uuid = ll.historyid) where...

I tried the replacement but still no go. -vza

I have a MySQL query used to compute the total time a device is within a expected location. The loglocations table contains a history of every device's location history within the DB. the starttime/endtime are datetime fields which represent how long a device is in a partcular location for that...

is there any way this line could be re-written using the unix_timestamp function? -vza

amrita, Maybe I should rephrase: Here is an entry within the histories table (some fields have been excluded which are unnecessary): Fieldname: Sample Entry: macaddress 00:02:2D:A5:F1:E6 locationName Services starttime 2005-07-21 11:04:34 endtime 2005-07-21...

amrita, I appreciate all your assistance with this issue! This query works perfectly for record counts.... but I ran into another issue: I can't really compute total percentage times for a device without taking into account the amount of time a Device is actually within a location... is...

I will try this out... So if I had the user enter a start time and and end time (through the Application) in two variables how could i incorporate that into the query so it count all entries within the user entered time frame (comparing with the two datetime fields?) as opposed to just one date...

Question: I am creating an Java Application which takes in a text file with Wireless Devices and Locations these Devices are supposed to be in, and compare it to device history data stored within within a SQL database. A feature of the Application is to compute the total percentage of time the...

Madere, You were right. I created wwdConnect at the beginning of my class: private Properties wwdConnect; Then when I wanted to define it within my class, I used the following: Properties wwdConnect = new Properties(); Which ultimately created a new instance to my Properties variable and...

I think I figured it out.... For some reason when i run the saveProperties method my Properties table is now null, even though the Properties table is populated before the saveProperties method is called...is there a reason why the values are not carried over?? Properties wwdConnect = new...

Madere, when I comment out the following line: wwdConnect.store(output, "Connection"); my saveProperties method is skipped entirely... (When debugging nothing in the method is executed unless the previous line in uncommented. I did notice something while I was compiling: DBConnectWindow.java...

Madere, I took your advise and tried to utilize the Properties class: Properties wwdConnect = new Properties(); wwdConnect.setProperty("URL", "DB_URL"); wwdConnect.setProperty("Username", "DB_USER"); wwdConnect.setProperty("Password", "DB_PASS"); This is my Save Properties method...

I want to store connection properties (URL/Username/Password) for a DB to a file and also have the ability to access these properties as needed. What would be the best way to do this? -vza

I have an VB app which transfers converted Excel spreadsheets to a format acceptable foe insertion into a Access database. I use the TransferSpreadshet Function to transfer the spreadsheet (once it has been altered) into the DB. Everything worked fine when inserted into a test (temporary)...

zemp, My mistake..rsFollow was changed to rsTable...I forgot to change rsFollow to rsTable when pasting code...my apologies I am pretty sure everything is opened correctly, I get no errors besides the update error when debugging.. Here is my corrected code: ' Variables Dim Value As Long...

zemp, I had a version of this earlier and I was still getting same error... Thanks -vza