result

Store SQL Server result set into an array with ASP 3.0

My ASP knowledge is shaky--I haven't used it regularly in years. I'm working with an ASP application. It performs a basic search, returning multiple columns and rows: rs = conn.execute("SELECT col1, col2, col3, col4, col5, col6, etc. FROM some tables") While Not rs.EOF Response.Write rs("col1") Response.Write rs("col2") etc. W...

How to modify SQL SELECT results

I need to write a SQL function that will allow me to strip an email address to the bare domain name. EX: I would make [email protected] read as [email protected]. This is most likely very simple but, I cannot seem to find any information on it. ...

Android onActivityResult triggered before activity even starts!

Hi all, I have an app that needs to scan a barcode to get a code before it can continue. I use this code to start the scanning activity: finish = (Button) findViewById(R.id.finishButton); finish.setOnClickListener(new OnClickListener() { public void onClick(View viewParam) { /*Prompt the user to s...

android startActivityForResult FLAG_ACTIVITY_NEW_TASK

Is there a way to use startActivityForResult() in conjunction with the FLAG_ACTIVITY_NEW_TASK flag? I have a dialog activity that i want to be started new each time, however when i pass in the FLAG_ACTIVITY_NEW_TASK flag, then the onActivityResult() method of the calling activity is not called when i return from the child activity (usin...

google search result URL error

In google search result URL is showing wrong that is https: rather than http: How to rectify this error? In yahoo and other search engine its showing right URL ...

PHP Query Result From One Column to Multiple Columns

// Database Settings define('DB_HOST', '**'); define('DB_PORT', '**'); define('DB_USER', '**'); define('DB_PASS', '**'); define('DB_NAME', '**'); // Connection to Database $database = new MySQLi(DB_HOST, DB_USER, DB_PASS, DB_NAME, DB_PORT); $sql = 'SELECT AManufactureBrand.brand, AManufactureModel.model, AManufactureEdition.edition' ...

Visual Studio 2010: Unit test results with "jump to file at line/col" links

I'm unit testing a compiler and would like to provide a unit test result that can be clicked and will bring visual studio to a specified test input file with the cursor at a specified line/col. Is this possible? I've tried the format outlined at http://blogs.msdn.com/b/msbuild/archive/2006/11/03/msbuild-visual-studio-aware-error-message...

MySQL:set result two digits behind comma

i have some formula: CONCAT((SUM(X.lot_qty)-SUM(X.reject))/SUM(X.accept)*100,'%') AS Acceptance but i get result like: 100.0000% how to get result as 100.00%? ...