Search results for query: *

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

...Dim Ds As New DataSet Dim i Dim ConnectString, SelectStatement As String SelectStatement = "Select * from catalogmaster WHERE CRID = -1" ConnectString = ConfigurationSettings.AppSettings("InternalWeb") Connect.ConnectionString =...

Char(13) and Char(10) works like a charm. Thank you for your help. ------ http://www.carealotpets.com

vbCr and vbLf are acting like params. ------ http://www.carealotpets.com

Its not spaces, but something else. Like a line feed. How do I search for line feed character in the field? ------ http://www.carealotpets.com

Yes, all cells have the trim function being ran on them. ------ http://www.carealotpets.com

I have a table full of customer information I need to be in a fixed width text file. I can export it just fine. When looking at the file, there seems to be extra line feeds in some of the records. The data output looks something liket his http://www.carealotpets.com/ebay/examples.txt Not...