Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MXSVivien

  1. MXSVivien

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

    Run-time error '-2147467259 (80004005)': Unspecified error
  3. MXSVivien

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

    That hasn't worked either Skip :(
  10. MXSVivien

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

    Help Required with SQL Statement Please!!!

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

Part and Inventory Search

Back
Top