Recent content by jw2000

Can anyone help?

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?

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

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">' +...

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

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

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">' +...

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

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

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)?

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

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

Got it to work! Thank you Vongrunt.

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