Recent content by rabinski

You can use Win32::ODBC Then create a DSN/Password to connect you to your SQL box - and use that in your perl script .... Hope that helps .... HTH Rab

Hi gurus - I have a DTS that just does a count on a table , writes the info to a txt file and should then increment the global variable using this ' increment the Global Variable (BatchNumber) DTSGlobalVariables("BatchNumber").value = iBatchNumber + 1 it works fine when I run...

Unfortunately it looks like there have been deletions leaving gaps in the id no's everywhere ... eg a TOP 20 PERCENT gives row 5000 a unique id of 67000 + !

>>Do you have any identity column in the table? yes >> Can you change the structure of the table? no I just need to change one field to this - row 1-5000 field = Batch1 row 5001 - 10,000 field = batch2 etc cheers for the prompt reply

hi gurus I have 25000 rows that need updating (eg first 5000 = batch1,next 5000 = batch 2 etc) What is the best way to do this ? SELECT TOP 20 PERCENT ? or a cursor ... ? any pointers would be most appreciated ... cheers

I like MySQLMan ,browser-based written in perl .... http://gossamer-threads.com/scripts/mysqlman/ but use MySQLCC more ... cheers Rab

cheers dude !

update table set id= 55, name = 'jo', name2 = 'smith' where ISNULL(postcode,'none'), LEFT(ContactPostCode,3) IN ('L60','L61','L98','L97') I know it must be obvious ;@) cheers guys !

yeah looking at it now - it is a bit of a read tho ;@) Thought there may be a quicker fix ...

Gurus - I need to strip out invlaid dates (eg leap years etc) - Using this regex at the mo if ($phone_num !~ /^[0-3][0-9]\/[0-1][0-9]\/[1-2][0-9][0-9][0-9]$/) - This will not catch leap years or 39/16/2005 etc ... Any help would be great chaps .... Rab

OK gurus - I come from a perl/mysql background but need to get up to speed with VBScript/ActiveX within DTS's etc.. Can any one give me a few links etc ... Just simple stuff for now ... eg just need to read in a file and write out a new one if a certain field is not certain criteria ...

cheers fishi Wil let you know next week .... Rab

Gurus I have a file in this format - field1 field2 I am substituting the spaces for commas and then doing a foreach splitting on the comma - great - But I have just found that the first field can be of differing lengths hence the number of commas inserted will change eg -...

Hi again gurus - A more general question this time - Is it feasible to read in 2 spreadsheets (with say Spreadsheet::ParseExcel) and combine the two into one ... Each of the input spreadsheets will only have one worksheet ... I just need to put them both into one ... Any pointers would...

Cheers Trojan - I will take your points on board ... Rab