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!
-
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!
-
CrudRepository and second order SQL injection
I am using the CrudRepository.save(entity) method from the Spring framework in my code. Will CrudRepository.save prevent malicious data from entering the database? Data that can be used for second order SQL injection. Such as "A' OR 1=1" Is there validation of the strings in "entity" before... -
Cannot import a package
I am creating a JSP page UploadFile.jsp. I keep getting the error. The org.apache.commons.fileupload.disk cannot be resolved. I need the package for the DiskFileItemFactory class. Based on my online research, I pasted the following JAR files to the WEB-INF/lib folder... -
Autofilter and Delete(partial row deletion)
Below is the code I posted earlier to filter and delete rows that meet certain criteria. const xlUp = -4162 lastRow = ws1.UsedRange.Rows.Count lastColumn = ws1.UsedRange.Columns.Count Set rngDataBlock = ws1.Range(ws1.Cells(1,1),ws1.Cells(lastRow,lastColumn)) rngDataBlock.AutoFilter... -
Cell value when reference is used
One of the cells(Row:5,Column:6) in my Excel Sheet1 has a reference value in Sheet2. ='Sheet2'!$C14 My VBScript code is as follows. Set ws1 = wb1.Worksheets("Sheet1") string1 = ws1.Cells(5,6).Value WScript.Echo string1 string1 returns a value of 0 instead of the final value based on the... -
Autofilter and Delete
I would like to Autofilter an Excel worksheet based on criteria and delete the visible rows. I know Excel VBA has such capability. Link Can you help me in writing such code in VBScript? -
Delete and shift cells up
I have the following code to delete a range of cells and shift cells up. Set objRange = ws1.Range("C4","C7") objRange.Delete xlToUp However, it is giving me an error. Can I get the correct code for this operation? -
VBScript Used Range
I have the following VBScript code. lastRow = editWorkbook.Sheets(sheetName).UsedRange.Rows.Count lastColumn = editWorkbook.Sheets(sheetName).UsedRange.Columns.Count WScript.Echo ("Last row:" & CStr(lastRow)) WScript.Echo ("Last column:" & CStr(lastColumn)) WScript.Echo("Value:" &... -
Runtime error on Validation object
I have the following VBScript code. Dim xlapp ' as excel object Dim WSx, WSy ' as excel worksheet Dim x, y ' as workbook Dim fso Dim list1 Set xlapp = CreateObject("Excel.Application") Set fso = CreateObject("Scripting.FileSystemObject") Dim fullpath fullpath =...
