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

    Passing a Comma-Delimited String to Stored Procedure

    I expect, however, that @Zippy might contain as many as 5000 Zip codes. Still recommend @Zippy nvarchar(some integer). Can you explain the SET quoted_identifer off is that really the meat of what I needed.
  2. Paully1999

    Passing a Comma-Delimited String to Stored Procedure

    I am trying to set up a stored procedure that accepts a comma-delimited string and displays all of the records that their zip code located within that string. I have CREATE PROCEDURE dbo_GetContractors @WorkType varchar(1), @Zippy nText AS SELECT Zip, Search_Id, State, City...
  3. Paully1999

    Connection error

    I have two servers 1 NT4 trying to access a Win2000 SQL 2000 server. They are in the same Workgroup not domain. when I attempt to connect I get the following [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. The test DSN connection works...
  4. Paully1999

    SQL "IN" Not Working

    I have a select statement that works fine with ACCESS from ASP but I'm trying to migrate to SQL Server 2000 and I'm getting an error with the folowing statement SELECT Zip, Search_Id, State, City, Company_Name, WorkType1, banner, bold FROM ContractorsOnly WHERE (WorkType1 = 'C' or WorkType1 =...
  5. Paully1999

    Newbie question about image maps

    Code below. Okay forget the image map the really important thing is to stop the animation going on on the page. I need one function that evaluates whether the animation is active if it is then stop it by using clearTimeout(junk); if it's not animate the image using the IF portion of the...
  6. Paully1999

    Newbie question about image maps

    Code below I need to change the imagemap name that is used after a person clicks on the image. I want to swap between image map1 and image map2 I am already swaping the image in the animate function. But how...I don't have a clue. So a little help please. Paul <SCRIPT> var img0 =...

Part and Inventory Search

Back
Top