Recent content by jondel81

I have a 384i system. In this post thread937-754081 they talk about a CAR (virtual) extension. How do I set that up? ------ http://www.carealotpets.com

The following code works. Dim db_cust, strSQLQuery db_cust = Server.CreateObject("ADODB.Recordset") strSQLQuery = "UPDATE CUST SET CITY = 'VIRGINIA BEACH', STATE = 'VA' WHERE (LEFT(ZIP_COD, 5) = '23455') Try db_cust.open(strSQLQuery, MM_CALPMAIN_STRING, 3, 3) db_cust = Nothing Catch exc As...

I don't think that is possible. I belive that drag feature is a feature in Internet Explorer. Even this box (which is not asp.net) has the ability to drag text. ------ http://www.carealotpets.com

What is the best way to append a dataset to a mssql table? ------ http://www.carealotpets.com

Not sure exactly what system I have, but the phones are Nitsuko and I use 384I410 program to edit the tables. ------ http://www.carealotpets.com

I changed some extensions around and added them to a ACD group via (1901). All but the ones I added to the group display the ACD Alarm. What table to I need to change to add the new ACD extensions to get the alarm? ------ http://www.carealotpets.com

This is what I came up with. Works okay. SELECT ItemGroups.Title, ItemGroups.Group_Name, ITEM.NBR, ITEM.DESCR, ITEM.TYP, ITEM.USR_DEF_1, ITEM.CAT, ITEM.SUB_CAT, ITEM.USR_DEF_4, ITEM.ECOMMERCE_FLG, ITEM.TXBL_FLG, ITEM.TAX_COD, ITEM.WEIGHT, ITEM.STAT, ITEM.REG_PRC...

Here is what I have so far in terms of querys. I would like to combind them and make a DTS. ECC_ITEMS: SELECT ITEM.NBR, ITEM.DESCR, ITEM.DESC_LIN_1, ITEM.DESC_LIN_2, ITEM.TYP, ITEM.USR_DEF_1, ITEM.CAT, ITEM.SUB_CAT, ITEM.USR_DEF_4, ITEM.ECOMMERCE_FLG, ITEM.TXBL_FLG, ITEM.TAX_COD, ITEM.WEIGHT...

Having problem completing this query. I have a list of items. Some items need to be grouped by a list, some by a range. I was thinking of useing two tables, one for the items, and one for the groups. The groups would have something like groupid, title, listnumbers, rangelow, and rangehigh...

Our time clock program keeps it data in a fixed field text file. I am trying to come up with a way for a vb.net file to access the file and show the summary of the time as well as each time the person clocks in or out. I think the major problem I am having is manipulation of the data. For...

You notice it does call "TheQuery" twice. Do I need to put the "TheQuery" in twice? If so were? Something like this? I could not get it to work. SELECT TheQuery.GroupID, GroupItems.NBR FROM (here) TheQuery RIGHT JOIN (here) AS GroupItems ON TheQuery.GroupID = GroupItems.GroupID WHERE...

TheQuery: SELECT DISTINCT ItemFile.GroupID, ITEM.NBR FROM ITEM, ItemFile WHERE (((ITEM.NBR) Between [ItemFile].[Range_Low] And [ItemFile].[Range_High])); UNION SELECT Group_Items.GroupID, Group_Items.NBR FROM Group_Items; Second Query: SELECT TheQuery.GroupID, GroupItems.NBR FROM TheQuery RIGHT...

No problem.. sound times my brain dosn't function correctly too.. ------ http://www.carealotpets.com

What about adding an condition that says if the current row is Ds.Tables(0).Rows.Count then "add new row". So if the count is 50 (0-49) and the current row is 51 (1-50), then you would ask to add a new row. ------ http://www.carealotpets.com

Bascily I am trying to append a table to another table in a completely different database. This code here gives me an error. Any ideas on how to fix it? Private Sub CatalogMaster(ByVal myds As System.Data.DataSet) Try Dim Connect As New SqlClient.SqlConnection...