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 Chriss Miller 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: jw2000
  • Order by date
  1. jw2000

    Query Help

    Can anyone help?
  2. jw2000

    Running a Perl File (.pl) from ASP

    Hello Tarwn, The perl file is in C:/myPerlFiles/perl1.pl How do I run perl1.pl from ASP? perl1.pl also prints out messages when it's running ... can I see these in ASP as well?
  3. jw2000

    Running a Perl File (.pl) from ASP

    I am currently using running a perl script (.pl) from the Command Prompt. How can I run this .pl file from ASP?
  4. jw2000

    Query Help

    Zhavic, Thanks for the pointer, but with the new code: declare @str1 as varchar(8000) declare @str2 as varchar(8000) declare @str3 as varchar(8000) select @str1 = Substring('<A href="http://www.domain.com/chem.asp?cId=' + CAST(chemicalId AS varchar) + '" target="NEW">' +...
  5. jw2000

    Query Help

    Any other suggestions? I'm not sure what I'm doing wrong.
  6. jw2000

    Running a Perl File (.pl) from ASP

    How can I run a Perl file (.pl) from ASP?
  7. jw2000

    Query Help

    Using the following code, I still get the same errors (shown above): declare @str1 as varchar(8000) declare @str2 as varchar(8000) declare @str3 as varchar(8000) set @str1 = Substring('<A href="http://www.domain.com/chem.asp?cId=' + CAST(chemicalId AS varchar) + '" target="NEW">' +...
  8. jw2000

    Query Help

    maswien, I changed the code to: INSERT INTO #TempChemicalsChunk (chemicalsInfo) SELECT Substring('<A href="http://www.domain.com/chem.asp?cId=' + CAST(chemicalId AS varchar) + '" target="NEW">' + dbo.PROPER(chemicalTITLE) + '</A><BR>' +...
  9. jw2000

    Query Help

    Can anyone help?
  10. jw2000

    Query Help

    Type above, the 3 selects should read: SELECT @Chunk1 = Substring(chemicalsInfo, 1, 8000) FROM #TempChemicalsChunk SELECT @Chunk2 = Substring(chemicalsInfo, 8001, 8000) FROM #TempChemicalsChunk SELECT @Chunk3 = Substring(chemicalsInfo, 16001, 8000) FROM...
  11. jw2000

    Query Help

    chemicalsInfo in #TempChemicalsChunk is TEXT, so it doesn't have a maximum length of 8000, does it? If it does, do you have suggestions on how I can temporarily store chemicalsInfo (which can have up to 24,000 characters) to break down into 3 chucks (@Chuck1, @Chuck2, and @Chuck3)?
  12. jw2000

    Query Help

    Code compiles but I get alot of errors for line "SELECT Substring ..." because chemicalId, chemicalTitle, chemicalDescription, chemicalCountry, chemicalState, chemicalCity, etc. gets the following errors: Invalid column name 'chemicalId' Invalid column name 'chemicalTitle' Invalid column name...
  13. jw2000

    @Var into Two Parameters Using Temp Table

    Druer, I apologize for any confusion and I appreciate your help so far. Thank you!
  14. jw2000

    Generating a Unique ID

    Got it to work! Thank you Vongrunt.
  15. jw2000

    Generating a Unique ID

    If I use @RecordTimestamp which is the record value of a datetime field in the database: set @datestr = replace(convert(char(10), cast(@RecordTimestamp as varchar), 10), '-', '') set @timestr = replace(convert(char(12), cast(@RecordTimestamp as varchar), 114), ':', '') 2003-03-23 10:34:01.513...
  16. jw2000

    Generating a Unique ID

    My mistake ... I created a stored procedure: CREATE PROCEDURE sp_AddUniqueId @dt VARCHAR(250) AS DECLARE @datestr VARCHAR(6) DECLARE @timestr VARCHAR(9) DECLARE @randstr VARCHAR(11) DECLARE @out VARCHAR(26) BEGIN set @datestr = replace(convert(char(10), @dt, 10), '-', '') set @timestr...
  17. jw2000

    Generating a Unique ID

    I only have varchar (20) for the Unique ID string. The code currently creates 26 characters. If I change your @out to: declare @out varchar(20) Will your code break?
  18. jw2000

    Generating a Unique ID

    I would like to be able to generate a Unique ID string (varchar 20) that is based on a datetime field (RecordCreated) and an algorithm. eg. 2001-08-21 21:08:11.620 -> ef2108g11x620y8a331g082101 where "ef", "g", "x" and "y8a331g" are randomly created letters and or numbers in...
  19. jw2000

    How to Re-attach database?

    I don't remember if I was able to attach both versions to the same SQL Server instance, and I don't suggest doing this. If you want to back up your database before making a lot of changes to it, you should copy the original mdf / ldf files into another directory. These will be your backup files.
  20. jw2000

    @Var into Two Parameters Using Temp Table

    Druer, I can't use a text field (ie. YourTextField) in a stored procedure because SQL server does not allow the use of TEXT datatype for local variables. How can I get around this?

Part and Inventory Search

Back
Top