Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jondel81

    Setting up a virtual extension on a 384i system

    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
  2. jondel81

    Update Query Results

    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...
  3. jondel81

    Textbox Drag & Drop

    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
  4. jondel81

    Append a dataset

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

    Queue Status information displayed on phones

    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
  6. jondel81

    Queue Status information displayed on phones

    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
  7. jondel81

    MSSQL Query Help

    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...
  8. jondel81

    MSSQL Query Help

    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...
  9. jondel81

    MSSQL Query Help

    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...
  10. jondel81

    Reading a fixed field text file

    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...
  11. jondel81

    Running a query off the results of another

    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...
  12. jondel81

    Running a query off the results of another

    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...
  13. jondel81

    End of a Dataset

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

    End of a Dataset

    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
  15. jondel81

    add one dataset to another dataset

    ...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 =...
  16. jondel81

    Exporting a table to Fixed Width Text File

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

    Exporting a table to Fixed Width Text File

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

    Exporting a table to Fixed Width Text File

    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
  19. jondel81

    Exporting a table to Fixed Width Text File

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

    Exporting a table to Fixed Width Text File

    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...

Part and Inventory Search

Back
Top