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...

...lh inner join loglocations ll on (lh.uuid = ll.historyid) where lh.macaddress = '00:02:2D:A5:F1:E6' and ll.locationName = 'Services*' I was able to run this protion of the query and get a value: mysql> source sum.sql +-------------+ | DEVICE_TIME | +-------------+ | 3925894 |...

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...

...opposed to just one date? Here is what I have so far: Select lh.macaddress, (Sum(Case When ll.locationName = 'Locale1' Then 1 Else 0 End)/ (count(*) * 1.0) * 100) As Percent From loglocations ll Inner Join loghistories lh On (lh.id = ll.historyId) where ?? (date info would go here) Group By...

...time the Device was located within the proper location ((which is # of times device is in proper location/total # of times device is in a location) * 100) over a certain time duration which is inserted by the user. One table has a macaddress field and a ID field. The other table has a...

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

...the table...I am confused...Help specifically states that this function can be used to append data to an existing table... Here is my code: ' ***Transfer*** xlstr = ConvertForm.ExcelText.Text Range = GetUsedRange(xlstr, &quot;Sheet1&quot;) ' Create Access Appilcation...

...' RecordSets Dim RsTable As New ADODB.Recordset Dim RsMAX As New ADODB.Recordset ' Open Recordsets RsTable.Open &quot;Select * From Table1&quot;, CnAX, adOpenDynamic RsMAX.Open &quot;Select MAX(Entry_ID) As MAXID From Table1&quot;, CnAX, adOpenDynamic Do Until RsTable.EOF = True...

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