Search Results

Search found 4215 results on 169 pages for 'andrew price'.

Page 75/169 | < Previous Page | 71 72 73 74 75 76 77 78 79 80 81 82  | Next Page >

• C# Excel Exception

  - by Andrew James Watt

  I am trying to copy all data from worksheet1 and paste the values into worksheet2 at the same position I am using office 2003 and the Interlop library. Here is my code; public void CreateExcelWorksheet() { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); if…

  Read the article

• Best way to stop SQL Injection in PHP

  - by Andrew G. Johnson

  So specifically in a mysql database. Take the following code and tell me what to do. // connect to the mysql database $unsafe_variable = $_POST["user-input"]; mysql_query("INSERT INTO table (column) VALUES ('" . $unsafe_variable . "')"); // disconnect from the mysql database

  Read the article

• Creating a [materialised]view from generic data in Oracle/Mysql

  - by Andrew White

  I have a generic datamodel with 3 tables CREATE TABLE Properties ( propertyId int(11) NOT NULL AUTO_INCREMENT, name varchar(80) NOT NULL ) CREATE TABLE Customers ( customerId int(11) NOT NULL AUTO_INCREMENT, customerName varchar(80) NOT NULL ) CREATE TABLE PropertyValues ( propertyId int(11) NOT NULL, customerId int(11) NOT…

  Read the article

• Building html tables from query data... faster?

  - by Andrew Heath

  With my limited experience/knowledge I am using the following structure to generate HTML tables on the fly from MySQL queries: $c = 0; $t = count($results); $table = '<table>'; while ($c < $t) { $table .= "<tr><td>$results[0]</td><td>$results[1]</td> (etc etc) </tr>"; ++$c; } $table…

  Read the article

• Change cell color in Excel according to adjacent dropdown value

  - by Andrew Heath

  I understand how to make a dropdown list. I understand how to make conditional formatting change the color of a cell. What I do not understand is how to make conditional formatting change the color of a cell based solely on the state of another cell (not a comparison). A1 is a No / Yes dropdown list B1 is a criteria statement If the…

  Read the article

• When to alter a function vs when to just write a new one...?

  - by Andrew Heath

  /is n00b Through the gift of knowledge and expertise encoded here, I am doing my best to avoid n00b mistakes as I learn the basics of programming. I use functions when I (think I) can in PHP, and keep them somewhat sorted in different includes. The n00b problem I'm running into now is situations where perhaps 4/5th of an existing…

  Read the article

• How can I create Wikipedia's footnote highlighting solely with jQuery

  - by andrew.bachman

  I would like to duplicate Wikipedia's footnote highlighting from in-text citation click solely in jQuery and CSS classes. I found a webpage that describes how to do so with CSS3 and then a JavaScript solution for IE. I would like however to do so solely with jQuery as the site I'm doing it on already has a bunch of jQuery elements. …

  Read the article

• Exporting WPF DataGrid to a text file in a nice looking format. Text file must be easy to read.

  - by Andrew

  Hi, Is there a simple way to export a WPF DataGrid to a text file and a .csv file? I've done some searching and can't see that there is a simple DataGrid method to do so. I have got something working (barely) by making use of the ItemsSource of the DataGrid. In my case, this is an array of structs. I do something with…

  Read the article

• How can I create XSD files from M documents?

  - by Andrew Matthews

  Does anyone know of a nice way to: produce XSD documents from an OSLO model consume conformant XML documents using that model and add directly into the DB created from the model? I can't see any obvious way from the current documentation, but I'm a newcomer, so I may have missed something. Thanks.

  Read the article

• Secure database connection. DAL .net architecture best practice

  - by Andrew Florko

  We have several applications that are installed in several departments that interact with database via Intranet. Users tend to use weak passwords or store login/password written on a shits of paper where everybody can see them. I'm worried about login/password leakage & want to minimize consequences. Minimizing…

  Read the article

• GDI+ Rotated sub-image

  - by Andrew Robinson

  I have a rather large (30MB) image that I would like to take a small "slice" out of. The slice needs to represent a rotated portion of the original image. The following works but the corners are empty and it appears that I am taking a rectangular area of the original image, then rotating that and drawing it on an…

  Read the article

• Choosing a Java IDE for homework assignments

  - by Andrew

  Can anyone recommend a light Java IDE that doesn't require you to make new projects each time you want to compile and run a program? I just want to be able to open java files and compile and run them. I have already tried Eclipse and NetBeans but both require you to make a new project each time you want to compile…

  Read the article

• Facebook: "URL could not be liked because it has been blocked" error in iOS app

  - by Andrew Madsen

  I'm working on an iOS app that allows the user to like a Facebook page within the app. I've implemented this using FacebookLikeView. During the course of testing this functionality, I've liked and unliked the same page multiple times. Unfortunately, this seems to have triggered Facebook's spam detection. Now, when…

  Read the article

• Jquery binding event on selected class

  - by Andrew

  Is it achievable in jquery to bind an event to a group of control that has certain class? It seems to me, it can't. I google a bit and all that came up are nothing to do with events. Here's how my code looks - $('.numonly').bind('keypress',function(event){ if (event.which > 31 && (event.which <…

  Read the article

• Selenium RC: How to assert an element contains text and any number of other elements?

  - by Andrew

  I am using Selenium RC and the PHPUnit Selenium Extension. I am trying to assert that a table row exists, with the content that I expect, while making it flexible enough to be reused. Thanks to this article, I figured out a way to select the table row, asserting that it contains all the text that I expect. …

  Read the article

• How should I launch a Portable Python Tkinter application on Windows without ugliness?

  - by Andrew

  I've written a simple GUI program in python using Tkinter. Let's call this program 'gui.py'. My users run 'gui.py' on Windows machines from a USB key using Portable Python; installing anything on the host machine is undesirable. I'd like my users to run 'gui.py' by double-clicking an icon at the root of the…

  Read the article

• How to make NetBeans IDE 6.8 show svn commit status (especially for "dirty" files)

  - by Andrew M. Andrews III

  I just switched from Eclipse to NetBeans IDE 6.8 for my PHP/Ajax development. Eclipse always showed a little hard disk symbol over the file icon for files that were in sync with the svn repository, and an asterisk for files with changes that have not been committed. Is there a way to see the commit status…

  Read the article

• counting twice in a query, once using restrictions

  - by Andrew Heath

  Given the following tables: Table1 [class] [child] math boy1 math boy2 math boy3 art boy1 Table2 [child] [glasses] boy1 yes boy2 yes boy3 no If I want to query for number of children per class, I'd do this: SELECT class, COUNT(child) FROM Table1 GROUP…

  Read the article

• Selenium RC: Selecting elements using the CSS :contains pseudo-class

  - by Andrew

  I would like to assert that a table row contains the data that I expect in two different tables. Using the following HTML as an example: <table> <tr> <th>Table 1</th> </tr> <tr> <td>Row 1 Col 1</td> <td>Row 1 Col…

  Read the article

• Tips for a successful AppStore submission?

  - by Andrew Grant

  In a day or two I'll be ready to submit my iPhone app to the AppStore and I'm curious whether people who have gone through this process have any tips / suggestions for a smooth submission process. Here's things I've covered; No memory leaks Tested performance on an actual device Doesn't crash :)…

  Read the article

• Using unmanaged code, how can I find a type that has a given custom attribute assigned to it?

  - by Andrew

  I had thought I could enumerate the types using IMetaDataImport.EnumTypeDefs and for each of the tokens returned, call IMetaDataImport.EnumCustomAttributes. This works, in so much as I get an array of mdCustomAttribute tokens. Using these tokens I can get a metadata token representing the Type of…

  Read the article

• Use database field maxlength as html layout input maxlength best practice. asp.net mvc

  - by Andrew Florko

  Hello everybody, There are string length limitations in database structure (email is declared as nvarchar[30] for instance) There are lots of html forms that has input textbox fields that should be limited in length for that reason. What is the best practice to synchronize database fields and…

  Read the article

• c# object initializer complexity. best practice

  - by Andrew Florko

  I was too excited when object initializer appeared in C#. MyClass a = new MyClass(); a.Field1 = Value1; a.Field2 = Value2; can be rewritten shorter: MyClass a = new MyClass { Field1 = Value1, Field2 = Value2 } Object initializer code is more obvious but when properties number come to…

  Read the article

• Using Sandy 3D AS3, fill the viewport (exact fit) with multiple 3D objects.

  - by Andrew Mullins

  I'm stitching together an image using multiple instances of the sandy.primitive.Box. Each box is 96x91 while the viewport is 960x273 which should make for an exact fit if I layout the boxes in a perfect grid of 10x3. However, I can't seem to get the exact camera fieldOfView. I've tried a…

  Read the article

• asp.net membership provider api. usability. best-practice

  - by Andrew Florko

  Hello everybody, Membership/Role/Profile providers API appeared in early days of asp.net Nearly everytime I can't live with standard API & have to add some extra functionality (for sorting, retrieving e.t.c.). I also have to use different database structure often (with foreign key…

  Read the article

< Previous Page | 71 72 73 74 75 76 77 78 79 80 81 82  | Next Page >