Search results for query: *

Thank you.... When do I set the recordset Set objRecordSet = objCommand.Execute I put it after the End With statement and got the same error.

Run-time error '-2147467259 (80004005)': Unspecified error

Nope PHV, that didn't work either. Thanks though... What the dickens is wrong with it??????? I do really appreciate all of your help :) But I am now tempted to throw my laptop out of the window, but unfortunately I can't because I'm hooked!!!! Goodness! I'm not gonna have a good weekend if...

Right.... I created simple query strSQL = "SELECT StartDate, EndDate, TimePeriod From VAKPIs" I've run a check on the field type for the StartDate and EndDate fields and it returned a value of 135, checking this I found that they are ADDBTIMESTAMP fields. Checking the values in VBA, in break...

LOL Remou... I'm trying not to, it's just very frustrating when you are up against a brick wall I'm using Version 8.5 that uses MS SQL, the older versions used MySQL Report data isn't stored in SQL though it's stored in the WTD files I've looked in the knowledgebase,there nothing of help...

Seeing as SQL is used to retrieve the data, I would have assumed that WebTrends would use similar data types?

Hi Remou, I tried your first suggestion a while back, that didn't work and I just tried your second suggestion strSQL = "SELECT HourOfTheDay, BookingEngineStart, BookingEngineEnd, BookingEngineTime, OnlineCheckInStart," & _ "OnlineCheckInEnd, OnlineCheckInTime, BookingUpgradeStart...

I just tried this and it didn't work either strSQL = "SELECT HourOfTheDay, BookingEngineStart, BookingEngineEnd, BookingEngineTime, OnlineCheckInStart," & _ "OnlineCheckInEnd, OnlineCheckInTime, BookingUpgradeStart, BookingUpgradeEnd, BookingUpgradeTime," & _...

That hasn't worked either Skip :(

Thank you Skip, I just tried this, but still no joy: strSQL = "SELECT HourOfTheDay, BookingEngineStart, BookingEngineEnd, BookingEngineTime, OnlineCheckInStart," & _ "OnlineCheckInEnd, OnlineCheckInTime, BookingUpgradeStart, BookingUpgradeEnd, BookingUpgradeTime," & _...

Hi, Thanks Andy & Harley, Here's the code. Basically I'm trying retrieve WebTrends data using ODBC. I believe it is stored in an SQL Server database. I have been able to retrieve data from the database using string variables, but for some reason the date variables are giving me a headache...

Hi, I hope someone can help, I've been trying ro run this SQL query, but I keep getting an unspecified error message: strSQL = "SELECT HourOfTheDay, BookingEngineStart, BookingEngineEnd, BookingEngineTime, OnlineCheckInStart," & _ "OnlineCheckInEnd, OnlineCheckInTime...