Thank you Vacunita. I did catch what you said. My issue is that I have no idea where to start to "marry it all" together as you put it.
I have found many tutorials on vanilla HTML5. Lots of Stuff on jQuery. And plenty of stuff on HTML5 and jQuery together. But none of it together with SQL...
Thanks Frank!
I've used W3 to take a quick look at HTML5. I've played around with Java and JQuery but all about how it does fancy things to a web page. Their tutorials all point to presentation such as hide, fade, callback, etc.
I'm at a loss as to how to put it together to build a data rich...
I am currently a classic ASP and VB.NET programmer...
I would like to learn how to use HTML5, CSS and jquery to access my SQL Server. The web pages will sit on an existing IIS Server and will be accessed by multiple means 1) a computer's browser, 2) mobile phones (both android and iOS) and 3)...
Thanks Brett! I think I've read about 700 posts on the attendant... but still don't have any clue where/what to do. I figured there was at least a couple of ways.
Would you have a recommendation?
-Dennis
=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)
I know... I know... but I did do a search already and couldn't find my answer ;o)
Definity Prologics G3si Release 8 with an s8500 and ONE attendant console (x599).
I have a total of 6 - but am concerned with only two trunk groups each with 4 members. TG1 is dedicated inbound and TG2 is...
This may or may not help (and answer the "nothing has changed" issue)...
I was setting up another VPN connection last night (point to point hardware connection Cisco Pix => VPN 3002 appliance).
The VPN box was successfully connecting... my IP phone would connect... then say the Discover...
I followed that to the 'T' and it still showed up as a graphic with the file name instead of the contents??
INSERT OLE OBJECT
(x) CREATE FROM FILE
BROWSE to the file
(x) LINK
When you run the report, it displays a graphic that says:
TEST14BATCH.TXT
You can resize this graphic... but no...
I tried that... but it shows up as a "picture" with the name of the file and not the true text contents of the file.
-Dennis
=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)
I have a CR 10 report file.
Every time the report is run, I would like to include the contents of a text file (NOT Data in a .csv format or anything like it - but rather text. About 2 pages of straight up text - in no real structured format).
This text file changes, so I would like it to...
I have an S8500 that we connect Avaya IP Phones and some softphones... I would like to get some SIP phones such as the 3Com 3108 Wireless Phone #3C10408A. How do I check to ensure that SIP Enablement Services is "on" and configured? Also, does anyone know if there is any decent Avaya Docs on...
But Cisco doesn't make a client for Windows Smartphone :o( and I want to VPN in to my company server for access to my exchange, files and my VOIP system.
-Dennis
=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)
Does anyone at least know what this (unanswered ACD call being redirected back into the Queue when the agent doesn't answer) is called - so I can google it?
=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)
Does anyone know if there is a way to report/track when an agent does not answer their phone, gets put into aux automatically, and the customer goes back in to the queue?
-Dennis
=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)
Thanks for the heads up RiverGuy! I actually do that already. My ASP Page shows BOTH DATES.
Here is the header on today's ASP page:
ORDERS SO FAR TODAY
Wednesday, November 28, 2007
--------------------------------------
COUNT VALUE
--------------------------------------...
December 31, 2005 is the 7th day of week 53.
The script returns @newDay as 01/01/2005.
So... my guess is that we should add a check for @newday's year??
If it is the same year as DATEPART(YEAR,GETDATE()), then we need to disregard it??? Or perhaps SQL always returns 01/01 of the current year...
The compare would be 0 count and $0.00 as there was NO 53rd week last year. Not sure what SQL would return for myResult (the calculated day) though?
Anyone know a date in the 53rd week of the year that I can run the script against?
-Dennis
=====================
Remember - YOU ARE...
...select @newday = dateadd(day, @day,
dateadd(week, @wk -1, @startyear
- datepart(dw, @startyear)))
--display final date
select
count(*) as myCount, sum(ORDER_TOTAL) as myDollar, @newday as myResult
from
ORDERTABLE
where
ORDERTABLE.the_status = 'S'
AND
ORDERTABLE.the_date =...
sorry... no relation! ;o)
And DateAdd -52 weeks? Will it land on a Thursday such as the example?
=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)
There is a GREAT FAQ on dates in SQL found here by Robyn Page
According to the FAQ, DATEPART allows you to figure out what week and day it is:
Does anyone know how to figure out the same date last year based on that? For example the above date used is: October 12th, 2006 which DATEPART...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.