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

    Has anyone found a way to do an insert with an apostrophe

    You can imbed single quotes using an additional quote in the string. Your example would work like this: insert... select 'Gary''s Garage' For quotes at the end of a string, you will need to add an additional quote. If you wanted "The ball is Chris'" (it is the best example i can...
  2. trompetaloco

    DTS Job and Exit Code

    I have a DTS task that uses an Active X controller step to determine if the entire routine should be executed based on the existence of records to be processed. If there are no records to be processed, the controller step sets all subsequent steps to completed and sets ExecResult to successful...
  3. trompetaloco

    Complex stored procedure issue

    Sorry. I did over simplify a bit. The validation table will actually contain the table and field name of the validation table for each parm to be validated (ie. the validation table will contain the name of the productcode parm, the table name of the Product table and the field name of the...
  4. trompetaloco

    Complex stored procedure issue

    I have a need to validate certain input parameters on a stored procedure. The situation is this: The stored procedure performs an order insert. As such, it contains a number of input parameters. Some of these require data validation prior to inserting the order. The validation info is...
  5. trompetaloco

    Nortel Extranet (VPN) over LAN to DSL router to Corp WAN

    StLouie, thanks for the response. I don't actually get any errors whe I connect. Infact, all appears fine. It is when I attempt to access shares across the VPN, I just can't. It tells me that the network path was not found. The curious thing is that my Win2K laptop works fine. I have checked...
  6. trompetaloco

    Nortel Extranet (VPN) over LAN to DSL router to Corp WAN

    I have been reading these posts and am still having trouble using Extranet. I have two machines(a laptop and a desktop) at home. I am also using a cable modem. I do not have a router, so I just swap the line to switch between the machines. The laptop connects fine and has access to corp shares...

Part and Inventory Search

Back
Top