- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
41 Posted Topics
 | 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; … |
| | If I have a datagridview that is bound to a dataset which comes from a MSSQL database, how can I have the datagridview display only one row of data from the dataset rather than all of the rows? Specifically, the first column is a combobox which is bound to the …  |
| | 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 … |
| | I'm no expert on this stuff but it seems that you are not declaring a doctype at the top of your page, you might start with that to see if it makes any difference. IE will go into quirks mode if no doctype is declared at the top of the …  |
| | 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 …  |
| | I need to create a service that will call a batch file. Here's the catch though - once the service calls the batch file, the command window that the batch file runs in must be visible on the desktop, it cannot run hidden. So far nothing I've tried results in … |
| | I'm posting 20 usernames and 20 passwords, they're named username1 ... username20 and then password1 ... password20. In the page that processes the posted values I have an array like this: [CODE] $postArray = array( *** * other values in array *** $userName1 = $_POST['userName1']; $password1 = $_POST['password1']; * * … |
| | I need to pass close to 100 variables between pages and I'm not sure of the best way to do it. Any suggestions? |
| | I know this has been asked many times before so I apologize but here's the php file that's generating the error on the "if($stmt = $this->conn->prepare($query))" line: [CODE]<?php require_once 'includes/constants.php'; class Mssql { private $conn; function __construct() { $dbServer = DB_SERVER; $dbName = DB_NAME; $conn = new PDO( "sqlsrv:Server=$dbServer;Database=$dbName", NULL, … |
| | I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it …  |
| | Is it possible to create a stored procedure to delete all records from a table (i.e. DELETE FROM <tablename>), but pass the table name to the procedure as a parameter? My desire is to have only one procedure for deleting multiple tables' records; I would simply pass in the table … |
| | I've got a simple mail utility that is supposed to send an email through an Exchange 2007 server (which is installed on Windows Server 2008 R2 64bit) and it won't work, giving the following error message at the commandline: "Mailbox unavailable. The server response was: 5.7.1 Unable to relay". I've … |
| | If I have the following line in a bash script, it works fine: [CODE]CoDescDate=$(awk -F"\t" '{print $22}' $1)[/CODE] If I embed the above line in a function that is within the same bash script, the script seems to hang at the point of invoking the function. [CODE]pay_ending_date () { CoDescDate=$(awk … |
| | Can someone tell me how to print a dollar amount (i.e. 1140.95) as 114095?  |
| | Here's something that is probably simple but so far I haven't figured out how to do it: I have a console application that I want to pass three arguments to when I call it. The three arguments are the input file name, the field delimiter, and the output file name. … |
| | I've got two ms access tables within one .mdb file, the tables are mrproduction & fglotnum. From mrproduction I need records from fields mrStkNum, mrLotNum, and mrQty. From fglotnum I need records from field mrCost. The common field between the two tables is lotNum (i.e. mrproduction.mrLotNum & fglotnum.mrLotNum). I guess …  |
The End.