Search results for query: *

Hey everyone, I have two tables: Contacts Number Name Address ... Groups ContactID Group Name I need to create a query that outputs a single list of all info for contacts and a column for each group which can change over time (Group names and whether a contact is in the group) Here is what...

Greetings, I am stuck on this one. I have a table: Date Hour Attribute Value 1/1/2016 1 A 0 1/1/2016 1 B 1 1/2/2016 0 C 1 1/3/2016 23 A 1 ... I need to produce a chart that shows dates on the Y axis...

Greetings, I have an IPO 500 V2 out of the box that appeared to be on 9.0.x. I upgraded firmware to 9.1.1. The firmware loaded fine and shows as 9.1.1. I go into the IPO for the initial config using Manager and it prompts me for the type. I select Basic and when the config opens, I get a bunch...

Greetings, I have a query: SELECT Sum(ColumnValue) AS SOCount, ColumnPK INTO #TT1010 FROM (SELECT SUBSTRING(DATENAME(mm, DT.dtime), 0, 4) AS ColumnLabel, Data.ColumnValue, CASE WHEN datepart(mm, DT.dtime) < 10 THEN '0' + CAST(datepart(mm, DT.dtime) AS VARCHAR(1)) + '/' +...

I have a query: SELECT O.Range, COUNT(*) AS NumOfOpportunities, CAST (SUM(O.ExpectedAmount) AS MONEY) AS ExpectedAmount FROM ( SELECT CASE WHEN DATEDIFF(D, EstimatedCloseDate, GETDATE()) BETWEEN 0 AND 30 THEN '0-30 Days' WHEN DATEDIFF(D, EstimatedCloseDate, GETDATE()) BETWEEN 31 AND 60 THEN...

Group, Does anyone have a company they can recommend to have a Partner R6 and a 308 module repaired? I am also going to look for refurb but I figured since they are no longer made, getting the ones I have repaired for a client would be good too. Thanks! Ed

Hey, I have an IPO500 v1 running 8.0(43) and VMPro running 8.0 (1001). Everything was fine until yesterday when I used Manager v10.1.57 to pull a config and add a new DID to a line. I can not not get into the AA, *17 hangs, shows connected on phone but no sound. Calls from outside just get...

I have an IPO where I need to turn on an external light when the user is using the extension (Think on-air light). The phone in this case is a 1616. Anyone have any ideas? Thanks! Ed

Group, I have the following tables: tblServiceOrders (This is a table of tickets) SONum Date tblItemsServiced (This is a table of items on the ticket linked by SONum) SONum SerialNum tblCustomerAssets (This is a table of assets the customer owns which may/may not be on a SerialNum...

I have a IPO500 V1 upgraded from 7.x to 7.1.31 and VM Pro which was at 6.something to 7.0.32. VM Pro no longer works from internal IP extensions on the same subnet nor does AA work when calling from outside to the SIP trunks. Outgoing SIP calls are fine. By not work, I mean that you get dead...

Hey, I am trying to set up an iPhone to use with IPO. A post from last year had a response that they used the One-X lite app from the app store. I am struggling with some of the settings and was hoping someone may have done this recently and offer some help. Thanks!

Hey, I have a system running 6.0.18 with embedded VM. Customer called and said display shows Voicemail Not Running. I logged in remotely and Monitor showed there was no SD Card (Even though there obviously was). I rebooted remotely and NG. I went to site and pulled power on the IPO, removed...

I have 2 tables, tblParts and tblAttributes. Each row in tblAttributes has a column that links to tblParts, an attribute name, and a value. Here is some sample data: tblParts ID Desc 1 Small Widget 2 Medium Widget 3 Large Widget tblAttributes ID PartID Attribute Desc 1 1...

Hey, I am a Crystal Guy, so please be gentile! I have an RDL file which I was told is the report file. However, when I open it I get .xml. How do I get the UI to show the RDL as a file w/ boxes, fields, lines, colors, etc, instead of xml? Thanks! Ed

I am writing a small VB app in 2010 that will send a get request string created via TCP port 80. I created a sub based on some MSDN samples I googled: Shared Sub Connect(ByVal server As [String], ByVal message As [String], ByRef formdebug As TextBox) Try ' Create a...

Happy New Year All! I was wondering if anyone had experience storing files in a table. By this I mean storing the actual file content in a row, such as a .pdf file or a .jpg. The items themselves would be anywhere from 50K to about 2-3 megs. I take it this is not the most efficient when the...

I am setting up a system for a client who is using 9620L phones throughout. Having done 16XX and 14XX phones primarily on my installs, it was kind of funny NOT to see a hold button; it is now a softkey on the 96XX phones! In terms of programming, the phone defaults with 3 call appearances...

Hey guys, I have customer running an IPO v1 on 6.0.18 and is using a 1616 phone. The display on the phone shows incoming caller info (name and number) when the phone is hung up. However, if the user is on the phone, the CA rings once, the LED for the CA lights up, but the display never...

Hey, I am working on my first newsletter in inDesign using a 3 column layout on 8.5x11 paper. From everyone's experience, should the text in each column line up across columns? Rignt now, I am not experiencing that when I have an article carry over to the next column as either I have an article...

Hey, I am hoping you guys could assist. I have a .png file that has a gradient in it. When I enlarge the graphic to the pixel level, I see about 3-5 diff shades of blue. I would like to change them to shades of red. First, does anyone have an idea on how I can calculate the equivalent colors...