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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: PAH
  • Order by date
  1. PAH

    SqlParameter limit of 127 characters

    Looks like I got the Answer here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1350344&SiteID=1 Thanks Alex
  2. PAH

    SqlParameter limit of 127 characters

    I have tried Text (2,147,483,647 characters) Varchar (8,000 characters) Ntext (1,073,741,823) characters) Here is a copy of the code using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Xml; using System.Xml.XPath; using System.Data.SqlClient; using...
  3. PAH

    SqlParameter limit of 127 characters

    I am developing a watcher service that picks up an xml file from a directory . using System.XML I read through the XML to provide a string XMLStr = XMLStr+"'"+(pda.ReadInnerXml())+"'"; I then pass this string to my SQL Command to provide the Parameter to a stored procedure...
  4. PAH

    Conditional paramaters

    Is there a way of passing conditional paramaters in CR8.5 if Param A is say 1 Param B will show xyz or Param A is 2 Param B will show abc
  5. PAH

    Joining 3 tables for 2 reports

    using CR 8.5 MS SQL 7 the joins order table order table INNER JOIN jobTable ON OrderTable.orderId = jobTable.orderId INNER JOIN jobtypeTable ON jobtable.jobTypeId = jobtypeTable.jobTypeId and a jobTypeId <> Jobt1 gives a result of orderid job type des 101 Jobt2...
  6. PAH

    Joining 3 tables for 2 reports

    I have three tables within a report the order table orderid Date 101 31/03/2004 102 31/03/2004 103 31/03/2004 104 31/03/2004 The Job Table OrderID Job type 101 1 101 2 102 1 103 2 103 3 104 1 104 4 The Job...
  7. PAH

    URGENT - create an XML file and store HTML form data in it client side

    have look at a product called textpipe it can convert differinf filetypes to other formats
  8. PAH

    Deleting in Outlook

    exchange and on a 100mb lan connection hangs even deleting 2 messages but I see what you mean Paul
  9. PAH

    Pulling Data from an SQL sever into Excel

    I use Get external data MS QUERY Initially pulling data straight from the Database via sql, then used this to build the Stored Procedure and a VBA front end for inputing variables to the spreadsheet
  10. PAH

    Deleting in Outlook

    Following a server move ( went by the book) and despite requesting users to tidy up their mailboxes and empting their deleted items boxes most did not. This morning users are unable to multiple delete items from their email boxes ( the pc just hangs) has anyone any ideas? Many Thanks Paul
  11. PAH

    user wants to have connection to two domains syncronised

    Our Chairman is on the board of two separate companies and wants to be able to have a single calendar covering both domains (there is no direct connection between these domains) his email at our domain is sent automatically to the other domain so he can access it when he is at the other office...
  12. PAH

    Emails Received but not distributed

    The routing has not changed everything was fine before and since it seems it only happens occasionaly.
  13. PAH

    Emails Received but not distributed

    A problem that occured over the last weekend our email server was picking up emails from our isp ( according to the logs) and receiving them but not distributing them to the recipients. I know that the server is short of space and due to be transferred to a new server soon but some of the...
  14. PAH

    Locking down windows

    I need to be able to disable certain users from accessing the control panel and the dialup properties ( I have a lot of fiddlers who continually change settings and then complain that their machine is broken!!!!) I remember reading something about it a long time ago but cant for the life of me...
  15. PAH

    Suppressing Group

    I need to suppress a whole group of records if one of the records within that group contains a certain value can anyone give me the formula many thanks Paul
  16. PAH

    VB6 data form wizard

    I have used the data form Wizard to create three separate data input forms for three departments that have to enter their relative data to a central database. I have attempted to substitute the DT Picker instead of the text box but I get a data item not bound error when I run the program any...

Part and Inventory Search

Back
Top