spowel4

I'm trying to create a loop to create 20 text input fields for username & 20 text input fields for password and my current attempt is listed below. It isn't working & if I view source the $i variable doesn't seem to be expanding properly. [CODE]<?php for ($i = 0; …

I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change …

I am defining the following variables inside a bash script (note: I ultimately want to pass these values to the bash script from the commandline but I haven't gotten that far yet): OFS=',' INPUTFILE='~/data.txt' OUTPUTFILE='~/delimited.txt' FIELDWIDTHS='1 10 4 2 2' Next, inside the bash script I'm attempting to call an …

I need to programmatically set the Internet Explorer home page for all local users (no domain). Can this be accomplished via a batch file, through C#, or through some other method that does not involve a gui?

In Laravel 4, which I am just beginning to learn, I have this bit of logic in my controller: `$guid = Input::get('guid');`. I know that part works because I can echo out the value successfully. I am trying to pass the $guid value to a view through a redirect like …

I need to disable cd-rom and usb drive access for certain users, via a batch file or something similar so that it can be scripted/automated. Any suggestions on how to do this?

I am trying to set ntfs permissions for a user folder such that the user has Read and Execute permissions for This Folder Only but has Full Control for All Subfolders and Files. I am using this code, which is not doing what I need: public void AddDirectorySecurity(string dirName, string …

I'm trying to figure out how to disable some of the right-click Windows context menu items for certain users (i.e. users with less security), can someone point me in the right direction please? Specifically, the lower-security users should only have New-Word Document, New-Excel Document, and New-Powerpoint Document in their right-click …

I have a tab control with three tabs and I have added a datagridview to each of the first two tabs at design time. Programatically, when the second tab is selected, I am attempting to create columns and add them to the datagridview on the second tab. However, they show …

I am populating a combobox with a list of names and the list contains approximately 7600 items. Here is the code: foreach (string customerName in customerNames) { comboBoxCustName.Items.Add(customerName); } This loop takes nearly one minute to complete (58.6 seconds to be precise). I don't think it should take that long, …

One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run …

I have a csv file with lines like this example: 14," APPLES, GRANNY SMITH 72 CT usa, Case",101-016,40.00,7/16/2013,7/22/2013 14," APPLES, GRANNY SMITH 72 CT, Each",010-017,0.60,7/16/2013,7/22/2013 I need to do a few things here - I need to remove any surrounding quotes from around fields; I also need to split the …

Is it possible to create a delimited file and structure the delimited file in some way so that opening that file in Excel creates an Excel file with multiple worksheets with data on each worksheet?

I am trying to set the value of cells in an Office 2010 worksheet using this code in Visual Studio 2012: for (int i = 1; i < 5; i++) { xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(i); int columnCounter = 1; foreach (string s in columnNames) { range = ((Excel.Range)xlWorkSheet.Cells[1, columnCounter]); range.Value = …

I am opening a tab-delimited file in Excel 2010; the delimited file displays correctly in Excel but when I do a save as, to save it as a native Excel 2010 format, the resulting saved file is empty. The resulting saved file generates no errors when debugging and saves with …

I have a table with several columns, the two relevant columns for what I need to do are invoiceNumber and stockNumber. The scenario here is that it's a table of invoice information, so each invoice can have and will most likely have multiple rows in the table which represent each …

Using this example json file: { "stores": [ { "storeName":"AUGUSTA", "company":"CC", "emailAddresses": ["spowel4@gmail.com", "spowel4@yahoo.com", "steve@compsysplus.com"] }, { "storeName":"CHATTANOOGA", "company":"CC", "emailAddresses": ["spowel4@gmail.com"] } ] } I have this code to try to parse the file: public static void main(final String[] args) throws Exception { // TODO code application logic here ObjectMapper …

Given a comma-delimited file like this example: "92528","1","36","38280","51801","PLANT 5 - LINE 1","37", "92528","1","8","37450","51801","PLANT 5 - LINE 1","37", "92528","2","8","37896","51801","PLANT 5 - LINE 1","37", "92528","3","8","37450","51801","PLANT 5 - LINE 1","37", "92528","61","32","37450","51802","PLANT 5 - LINE 2","37", "92528","62","16","38721","51802","PLANT 5 - LINE 2","37", "92528","63","8","38722","51802","PLANT 5 - LINE 2","37", "92528","64","4","37450","51802","PLANT 5 - LINE 2","37", "92528","149","8","37450","51804","PLANT 5 - …

I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 …

Using java, I need to parse a json text file that will contain data according to the layout shown below. The number of email addresses per store will vary. The point is to get a list of stores & corresponding email addresses, then send emails to the addresses. I have …

I understand that when casting a string to a float, php will evaluate from left to right and stop at the first invalid character. So for example, the string "1-23" will cast to a 1. I need to evaluate the entire string though, so that the string "1-23" would not …

hi everyone I recently designed my webpage via notepad++ I am very basic at this, right now some pages of my site doesn't show up in other browsers than firefox. (like the contact form in contact page doesn't show in IE) please help me what to do. Also it seems …

I have a class with a required file: require_once 'includes/constants.php'; That required file contains the following: <?php // Define constants here define("DB_SERVER", "localhost"); define('DB_USER', 'xxxxxxxxxx'); define('DB_PASSWORD', 'xxxxxxxxxx'); define("DB_NAME", "customerInfo"); define("ERROR_FILE", "c:\wamp\www\customerinfo\Errors.txt"); The class has a constructor: function __construct() { $dbServer = DB_SERVER; $dbName = DB_NAME; $dbUser = DB_USER; $dbPWD = …

This is a sample from a payroll file I have to work with, it lists employee number, different types of earnings, & check date. The goal is to get a subtotal per employee that lists the employee's total wages and other earnings. I can't get my head around how to …

We have a system that has a drive bay, mounted in the computer in a 5.25" bay, which connects to an internal pci sata card. The drive bay accepts 2.5" sata drives, and the drives themselves are inside an enclosure that inserts into/ejects from the drive bay. The connection between …

If I have an arraylist of arrays (each item in the arraylist is itself a one-dimensional array), how can I iterate over each element of each array contained in the arraylist?

I have a list of type <string[]>, and each item in the list is a one-dimensional array. I need to sort the list according to a particular field in the arrays, how can I do this? An illustration for clarity: list item #1 = array(112, Maxwell Smart, MIS) list item …

I am having trouble getting this to work. I have a form which when the Go button is clicked, calls a function; code for the form & the script listed below: <script> function RunSelectedReport(reportChoice) { alert("reportChoice: " + reportChoice); if ( reportChoice === "AllCalls" ) { alert("All Calls"); } else …

I have the following, which creates a list of arrays: static List<string[]> ReadFileIntoList(string fileName) { List<string[]> parsedData = new List<string[]>(); string fullLine; string[] row; try { StreamReader sr = new StreamReader(new FileStream(fileName, FileMode.Open, FileAccess.Read)); while ((fullLine = sr.ReadLine()) != null) { row = fullLine.Split('\t'); parsedData.Add(row); } sr.Close(); } catch (Exception …