w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Transfer data from access table into mysql table
Maybe your date field is a dateTime type Try this DataTable ds = tempaccesscon.exexutesql("select top 100 * from record where time between #7/1/2013 00:00:00# and #7/31/2013 23:59:59#")

Categories : Mysql

Transfer values multiple text inputs to table view, add table view items as NSManaged Objects
Connect your add table view to the original table view via a delegate @protocol so it can inform the other on its state and enable it to react accordingly. Of course you use the same type of managed object throughout, no interim objects such as dictionaries. When the added data is saved, you could send the object back to the original table to be processed. (Alternatively you can save and rely on e.g. the fetched results controller delegate - but maybe that is too advanced at this stage.)

Categories : Objective C

How to transfer a row from one table to another?
mysqli::multi_query performs a query (one or multiple queries) on the database. It does not create a prepared statement (like mysqli::prepare) to be used with mysqli_stmt::bind_param and executed with mysqli_stmt::execute. Furthermore, the query parameter in the prepared statement must consist of a single SQL statement. You should do a transaction (No prepared statements!) this way (taken from PHP + MySQL transactions examples): $tradeid= filter_var($_GET['trade_id'], FILTER_SANITIZE_NUMBER_INT); require_once('connect.php'); $mysqli = new mysqli($database_hostname, $database_username, $database_password, $database_name) or exit("Error connecting to database"); try { // First of all, let's begin a transaction $mysqli->begin_transaction(); // A set of queries; if one fails,

Categories : PHP

transfer selected row to another table
There are couple of issues with your code 1) You are not closing your <td> properly 2) You are not using data-index attribute in tbl1 <tr> The html should be like this <table id='tbl1' style='border: solid 1px red'> <tr> <td>File Name</td> <td>File Size</td> <td>Date Modified</td> </tr> <tr data-index="5"> <td> <input type='checkbox' class='chkclass' name='' value='1' /> </td> <td>500,b</td> <td>yes</td> </tr> </table> <table id='tbl2' style='border: solid 1px blue; margin-top: 10px'> </table> EXAMPLE

Categories : Javascript

Transfer data from one table to another on insert
replace this WHERE board_id='$row_b[board_id]' by WHERE board_id='".$row_b['board_id']."' ^--------^--------you need quotes here

Categories : PHP

Upload only one table using heroku pg:transfer instead of whole database
did it with pg_dump: pg_dump -Fc --no-acl --no-owner -h localhost -U username -t properties idx_map_development > properties.dump The file called properties.dump gets only the data for the properties table and I upload the file to an Amazon S3 bucket and can then push it to heroku with this: heroku pgbackups:restore DATABASE 'https://s3.amazonaws.com/bucket_name/properties.dump' The other tables on my heroku db are unaffected. You don't need to specify the properties table in the pgbackups:restore command.

Categories : Postgresql

Transfer data from an ORACLE View to greenplum DB table
The last time I used Greenplum (3 years ago) I don't think there were any untrusted languages like plperlu, so fetching directly from Oracle from within Greenplum might not be possible. If the data has a primary key, are you able to fetch in batches, compress it, then ship it to Greenplum? Do you have a Greenplum support contract? If so, you could also try them if you haven't already: https://sso.emc.com/sso/login.htm I recall that gpfdist can be configured to fetch from remote servers with a bit of fiddling, so if you are able to copy out the Oracle data to disk, you could fetch it using gpfdist without any intermediary steps.

Categories : Oracle

I have to transfer a file from one system to another , but i want to display a message to user showing progress of transfer
If you work with Unix/Linux, you have a easy way, RSYNC. rsync -chavz --partial --progress --stats source_files remotehost.domain:target_dir Where: --checksum -c -- skip based on checksums, not mod-time & size --human-readable -h -- output numbers in a human-readable format --archive -a -- archive mode; same as -rlptgoD (no -H) --verbose -v -- increase verbosity

Categories : Networking

Data transfer from a view from one database to a table in another database
You will want to double click the connector from the Execute SQL Task to Send Mail Task Currently it's green which indicates it will only take that path on Success. You will want to update the constraint to be on Completion as you don't care if it's Success or Fail. It sounds like you have your data flow pulling all of the data from your source and writing to a staging table. In your Execute SQL Task, you then use a query to add data into your target table where it doesn't exist. This can be consolidated into a single Data Flow. Between your OLE DB Source and OLE DB Destination, add a Lookup task. Since you are on 2005, the Lookup behaves a bit differently than 2008+. You will write a query that pulls back the business keys in your target table and then compares that to what is coming f

Categories : SQL

I have two table called Event table and Date table.I want to show following display table without duplicating rows using sql
Try this: For MySQL SELECT EVENT_NAME, REPLACE(REPLACE(DATE_FORMAT(START_DATE, '%Y/%m/%d %h:%i:%s %p'), 'AM', 'a.m.'), 'PM', 'p.m.') START_DATE, CONCAT(REPLACE(REPLACE(DATE_FORMAT(START_DATE, '%Y/%m/%d %h:%i:%s %p'), 'AM', 'a.m.'), 'PM', 'p.m.'), ' - ', REPLACE(REPLACE(DATE_FORMAT(END_DATE, '%Y/%m/%d %h:%i:%s %p'), 'AM', 'a.m.'), 'PM', 'p.m.')) FROM_TO FROM (SELECT ET.EVENT_NAME, MIN(STR_TO_DATE(REPLACE(ET.START_DATE, '.', ''), '%Y/%m/%d %h:%i:%s %p')) START_DATE, MAX(STR_TO_DATE(REPLACE(ET.START_DATE, '.', ''), '%Y/%m/%d %h:%i:%s %p')) END_DATE FROM EVENT_TABLE ET INNER JOIN DATE_TABLE DT ON ET.E_ID = DT.E_ID GROUP BY ET.E_ID ) AS A;

Categories : Mysql

how to fetch particular record from table X joining table Y or table Z where table Y and Z has same column name with same kind of data?
Assuming that the child record will ALWAYS be in either equipment or equipment2, but never both, you could just add equipment2 with an outer join, and use NVL() to pick the not null value: SELECT TO_CHAR (a.LOG_DATE, 'mm/dd/yyyy HH:MI:SS') LOG_DATE, nvl(b.id,b2.id), a.atid, a.l_type, a.l_subtype, a.eq, a.name, a.comments FROM log a, equipment b, equipment2 b2 WHERE a.eqid = b.eqid(+) AND a.eqid = b2.eqid(+) AND log_date BETWEEN TO_DATE ('07/01/2013', 'MM/DD/YYYY') AND TO_DATE ('07/08/2070', 'MM/DD/YYYY') ORDER BY 2 This also assumes that you're only picking a column that will not be populated with a NULL. If, for example, equipment/equipment2 also contains a "name" column that might be null, you'd need some additional logic: case when b.

Categories : SQL

Join two table show all record on left table if right table exists, use right table
you can use Full outer join here... here is an example SELECT Customers.CustomerName, Orders.OrderID FROM Customers FULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerID

Categories : SQL

Best way to transfer value from an ArrayList to another
The first one replaces the content of the list by another content. The second one creates another ArrayList instance, leaving the previous one untouched. If the list is referenced by some other object, and you want this other object to be untouched, use the second one. If you want the other object to also have the new content, use the first one. If nothing else referenced the list, it doesn't matter much. The second one will reduce the memory used in case you replace the content of a huge list by a few elements.

Categories : Java

I can't transfer int value from one activity to another
"besos" is an int. You have to use getInt (String key, int defaultValue) to get its value. int intValue = bundle.getInt("besos", 0); tv1.setText(String.valueOf(intValue));

Categories : Android

Transfer Session ID from ASP.NET to ASP
ASP and ASP.NET sessions are not shareable. We would need something intermediate so that there is minimal rewriting of code. We should be able to uniquely identify each client's session. Check this Code Project Post.

Categories : Asp Net

DMA transfer size
This is extremely platform-dependent. According to this information sheet on PCI-E: Intel desktop chipsets support at most a 64-byte maximum payload while Intel server chipsets support at most a 128-byte maximum payload. The primary reason for this is to match the cache line size for snooping on the front side bus. ... Chipsets produced by vendors other than Intel have supported a higher value; 512 bytes is the commonly known maximum payload value for a server North Bridge. Assuming you are talking about PCI-E, the search terms you want are "PCI Express" and "payload size".

Categories : Misc

Transfer of SVN Repos
Simplest way with least possibility of anyone inexperienced getting their working copies chewed/broken/confused: Make sure everyone commits their changes to the old repo. Copy the whole repo folder entirely from the old machine to the new machine. Install and open VisualSVN on the new machine, and select 'Import Repository'. Have everyone checkout their project from the new repo.

Categories : Svn

transfer DTO to ViewModel
I would use AutoMapper to do this: https://github.com/AutoMapper/AutoMapper http://automapper.org/ You can easily map collections, see https://github.com/AutoMapper/AutoMapper/wiki/Lists-and-arrays It would look something like this: var viewLoadSources = Mapper.Map<IEnumerable<LoadSourceDetail>, IEnumerable<LoadSourceViewModel>>(loadSources); If you are using this in an MVC project I usually have an AutoMapper config in the App_Start that sets the configuration i.e. fields that do not match etc.

Categories : C#

RSA transfer iOS to Java
The Problem was not in the RSA part but the Base64 encoding and transfer. All "+" in the String were received as " " due to HTTP(S) transfer (of course, I should have thought of that). Replacing them with "-" as proposed by the unofficial Base64URL version solves the problem. (also all "/" with "_") This also explain why only 2 bytes were different - those were the "+" symbol bytes.

Categories : Java

ASP.NET - How to Transfer to XML File
Based on your question what I understand is you need XML file as downloadable content, is this understanding correct? How about making your own plain entity or data structure [C#/VB Class with [properties get/set]? What I mean is, once you have .net object you just assign value to its properties and take the advantage of .Net Serialization [XML or JSON whatever you need], put the serialized content in HTTPResponse object and specify the response content type. From above sample structure XML, elements will become your fields or properties inside class. Hint: If you have sample XML structure then convert to XSD and use XSD command line utility to generate .net class [VB or C#]. Do not forget to mark you classes with serialize attribute [Serializable] if you write manually. Below is th

Categories : C#

transfer php variables from one server to another
You can send the post request using file_get_contents() (for example) : // example data $data = array( 'foo'=>'bar', 'baz'=>'boom', ); // build post body $body = http_build_query($data); // foo=bar&baz=boom // options, headers and body for the request $opts = array( 'http'=>array( 'method'=>"POST", 'header'=>"Accept-language: en ", 'data' => $body ) ); // create request context $context = stream_context_create($opts); // do request $response = file_get_contents('http://other.server/', false, $context)

Categories : PHP

Can't transfer List to Json
You have a cycle in your object model. Question has a list of Answers and Answer knows its Question. That is not serializable to JSON because it would result in an JSON document with infinite length. It will not work until you either model the relation between Question and Answer as a unidirectional one or you mark one side as "transient". But the second approach may have an impact on your JPA handling as well so I suggest to think about the first approach. Do you really need bidirectional relations or may it be sufficient if the Question knows its answers but not vice-versa?

Categories : Json

What does TRANSFER stand for in VPS spedifications?
It means the amount of data that can be downloaded (or transferred) from your VPS. It's hard to estimate how much transfer you might use as it entirely depends on what kind of app you're serving and how many users you will have. I wouldn't worry about it unless you're serving large files such as video, in which case you'd probably want to store those elsewhere.

Categories : Ruby On Rails

transfer logic into controller
Just slice your array of news when controller is initialized and each time you call the changeCurrent function and iterate through newsVisible. Possible code could be : $scope.changeCurrent = function(value){ $scope.currentPosition = $scope.currentPosition + value; if($scope.currentPosition < 0 ){ $scope.currentPosition = 0; } var end = Math.min($scope.currentPosition + $scope.qntVisibleRecords, $scope.news.length) //ensure that you won t slice at an index greater than news.length $scope.newsVisible = $scope.news.slice($scope.currentPosition, end); } BTW you can call this function when the controller initialized in order to init your array of newsVisible. $scope.changeCurrent($scope.currentPosition); You can check it here http://jsfiddle.net/rrnJc/1/

Categories : Javascript

transfer files from one webserver to another
use the php ftp functions. Set ini_set('max_execution_time', 0); and ignore_user_abort(1) then $File = "PathToFile"; $Ftp = ftp_connect("IP of the othe server that will receive the file"); ftp_login($Ftp,"ftpuser","ftppassword"); ftp_pasv($Ftp,true); // Join pasv which is always better ftp_put($Ftp,"Path in the remote server",$File,FTP_BINARY); ftp_close($Ftp); Always use FTP_BINARY when sending binary files and of course fire the php script, via web browser or cron Edit: Forgot ftp_login()

Categories : PHP

Substitute s in transfer function
What's wrong with saving m-file with function g = transferFun( s ) g = 1 ./ ( s + 3 ) And then calling the function >> transferFun( -2.118 + 2.221*j )

Categories : Matlab

How to transfer data across pages in asp.net?
You can send it with query string or using session as well for session you can use simply Session["HotelID"] = 5; // whatever id there then access like int _hotelID = (int)Session["HotelID"]; for query string response.ridrect("HotelEdit.apsx?HotelID=" + value); value is HotelID Retrieve at Edit Hotel Page string _HotelID = Request.QueryString["HotelID"].ToString();

Categories : Asp Net

Transfer an image from CDC to CBitmap
Create another device context and one by one create and select your target bitmaps into it and use BitBlt to copy portions of the source bitmap into them. Below is an example of how you might do this. // Create a DC compatible with the display // this is used to copy FROM the source bitmap sourceDC.CreateDC(NULL); sourceDC.SelectObject(&sourceBitmap); // Create another device context for the destination bitmap destDC.CreateCompatibleDC(&sourceDC); for(int i = 0; i < numBitmaps; i++) { // Determine the x, y, sourceX, sourceY, with and height here // ... // create a new bitmap CBitmap *destBitmap = new CBitmap(); destBitmap->CreateCompatibleBitmap(&destDC, width, height); // Select the bitmap into the destination device context CBitmap *oldBi

Categories : C++

Transfer TFS 2012 to another machine
After some investigation, we found out the way to store the tfs is wrong. Actually we are doing tfs transfer. So we should do the following steps to do tfs transfer and it works: Logon tfs server in data center as tfs service account, and the tfs service account should be in local administrator group Open tfs console and remove tfs feature : remove the current installed tfs instance Manually delete all tfs related data bases in data base server Be sure the related tfs service is running including www service Run the TfsRestore.exe (C:Program FilesMicrosoft Team Foundation Server 11.0Tools) to restore data base backup Run TFS installer and follow the Application-Tier Only wizard to do tfs transfer configuration At the data base step, click list available data base to list the restored d

Categories : Tfs

Rails Net::SCP file transfer
I ended up using a different method to scp the file over: require 'net/ssh' require 'net/scp' desc "Fetch hadoop data" task :fetch_data => :environment do date_yesterday = (DateTime.now - 1.days).strftime("%Y%m%d") date_today = (DateTime.now).strftime("%Y%m%d") Net::SSH.start("server_name", "user",:password => "*****") do |session| session.scp.download!("path_to_file_on_remote", "/home/rails_app/lib/tasks/folder", :recursive => true) end end

Categories : Ruby On Rails

Need a little guidance with NFC Data Transfer
If I got you correct you want kind of p2p. So you are typing something on the phone A and simultaniously get that text on phone B. If yes then short answer - it is not possible for now in android. Max that you can get for now it's 1 message to each way like it in Google Beam.

Categories : Android

Big Data transfer between different systems
I see two questions here: How can I consolidate data from different systems into one system? How can I create some data in Mongo for people to experiment with? Here we go ... =) I would pick one system and target that for consolidation. In other words, between Hadoop, Cassandra and MongoDB, which one does your team have the most experience with? Which one do you find easiest to query with? Which one do you have set up to scale well? Each one has pros and cons to scale, storage and queryability. I would pick one and then pump all data to that system. At a recent job, that ended up being MongoDB. It was easy to move data to Mongo and it had by far the best query language. It also had a great community and setting up nodes was easier than Hadoop, etc. Once you have solved (1), you ca

Categories : Hadoop

How can I limit transfer speed?
I'd calculate the transfer rates by hand. The devices which can limit transfer bandwidth consumption in this scenario are going to be located between the client and the server (layer 3 devices like routers), or the server, or the client themselves. Since all you are guaranteed have control over is the client, you'll need to do it yourself. I don't know of any libraries which will handle this for you. The calculation should be pretty simple. Just bytes transferred over time right? Also I suggest having a selection in your FTP app for users which can throttle the bandwidth your FTP app is using.

Categories : Java

Partial udp file transfer
Both are true: UDP is not meant to be used for file transfer without implementing checking, reordering and retransmission. Instead of implementing all these over UDP, it is much better just to switch to TCP. With the rare exception of resource limited embedded systems. In your code you use strlen to get block length, since the file (most probably) is binary this is producing incorrect length values and you do not transmit the whole file data. strlen operates on zero terminated strings and counts only up to the first 0 byte in the data. To get more correct results, the easiest way is to replace strlen(memblock) with min(1024,filesize). This is not a perfect solution because it does not check exactly how many bytes were read by myfile.read.

Categories : C++

PHP 5.0 ... Want affiliate ID to transfer to all pages
If I understood you right, than you want to track from which affiliate ID a user comes from. I would simply save that information to a cookie or a session variable (which would also use cookies normally). So you can track the user even days later if your new user has decided to register or to use your service. setcookie("AffiliateID", $affiliateID, time()+3600*24*$days);

Categories : PHP

Dump MysqlDB and transfer it to FTP
How about using ftp command line utility? It is capable of using scripts (lists of commands from external files) ftp -s:ftpcmd.dat your.ftp.server.com Now you can either create this script file beforehand or make it on the fly from your batch file using echo.

Categories : Mysql

Speeding up S3 to GCS transfer using GCE and gsutil
use the parallel_thread_count and parallel_process_count values in your boto configuration (usually, ~/.boto) file. You can get more info on the -m option by typing: gsutil help options

Categories : Amazon

Transfer datafrom one form to an other
Usually, it's using a Data Transfer Object: http://msdn.microsoft.com/en-us/library/ff649585.aspx Or a Domain Object. http://msdn.microsoft.com/en-us/magazine/dd419654.aspx

Categories : C#

Transfer a value from one thread to another without locks
In case you are interested in lockless thread, then you can check this link. However, Go through in detail about its predeined assumption - which will be very important for the implementation.

Categories : C

why Server.Transfer changes the font in asp.net
What is changing the font is the Response.Write and not the Server.Transfer. Use this: ClientScriptManager.RegisterClientScriptBlock...check here

Categories : Asp Net



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.