Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Dynamic Web Charts › Start and end date ???

Start and end date ???

Thread began 10/11/2010 8:44 am by nmabey414064 | Last modified 10/14/2010 12:43 pm by nmabey414064 | 2397 views | 8 replies

10/11/2010 8:44 amnmabey414064

Start and end date ???

The graph is displayed but there are no bars displayed. The tootlip only says "undefined".
I am connecting to a MSAccess database. The code looks like this:

Set WADWCStats_cmd = Server.CreateObject ("ADODB.Command")
WADWCStats_cmd.ActiveConnection = MM_diagramm9_STRING
WADWCStats_cmd.CommandText = "SELECT Stats_Date AS XLABEL, Stats_Date AS YVALUE FROM Stats WHERE Stats_Date >= #07-July-2010# AND Stats_Date <= #14-July-2010#"
WADWCStats_cmd.Prepared = true

Is there any SQL Date Problem using VB and MSAccess?

Can the dates also be set dynamic? eg. the customer choose dates with a datepicker or they are forwarded through input fields?

Thanks a lot, please be patient I am new to this all!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.