Search results for query: *

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

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

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?

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

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.

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?