Search Results

Search found 30279 results on 1212 pages for 'database drift'.

Page 791/1212 | < Previous Page | 787 788 789 790 791 792 793 794 795 796 797 798  | Next Page >

• Effects of order of columns, while defining an index on them, on the performance of the queries

  - by Hossein

  Hi, Does order of the columns in an Index definition for a table in a database has any effect on the performance? for e.g. are these two queries different ? CREATE INDEX xxx ON tablex(col1,col2) CREATE INDEX xxx ON tablex(col2,col1) what about the in case that I use a BTREE index? I am using Mysql. thanks

  Read the article

• Pass windows authentication username to asp variable

  - by Darren Cook

  Hi, I have a site that processes orders taken by phone into a SQL database. Access to the portal uses Windows Authentication and I would like to pass the username of the order processor along with the order so that I can record who has taken the order. How can I pass the user name to a form element? The pages are written in classic asp. Thanks.

  Read the article

• Image path insert to Mysql through jsp code

  - by merin

  I want to insert image path to database through JSP. I am selecting the images using check box. please give me the code.

  Read the article

• here is my code for spinner with dropdownlist:

  - by user555910

  I have spinner in my application .The spinner have drop down list.I want to take the value of the dropdown list from the database .how can i do this ? here is my code for spinner with dropdownlist: ArrayAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_spinner_item, selectdefault); adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); spinner.setAdapter(adapter);

  Read the article

• Subsonic SELECT FROM msdb

  - by Lukasz Lysik

  Hi, I want to execute the following query using Subsonic: SELECT MAX([restore_date]) FROM [msdb].[dbo].[restorehistory] While the aggregate part is easy for me, the problem is with the name of the table. How should I force Subsonic to select from different database than default one.

  Read the article

• What does the exception "javax.servlet.jsp.JspException: Broken pipe" signify?

  - by Ruepen

  I'm getting the following error: javax.servlet.jsp.JspException: Broken pipe Now I have seen questions/answers with respects to the socket exception, but this error is coming from a different package. Any help is greatly appreciated. BTW, I am seeing quite a lot of these errors in a struts web app Weblogic Node logs and I am thinking that it has to do with end users closing their web browser before the page reloads/executes the next step (database transaction which takes quite a bit of time to execute, anywhere from 30 seconds to 4 mins).

  Read the article

• How to generate Image at server side in java [ blob-> string_image -> *.png or .jpg ]

  - by Vaibhav Bhalke

  Hi All I want to generate image on server side. My Image is stored in server side's database in blob format and I am able to convert it into string_image; Then How to convert that string_image into actual .jpg or .png format. Actually I am posting attachment as image on users facebook' wall. How to generate Image at server side in Java? Is there any sample code to do it?

  Read the article

• MySQL very slow compared to MS Access when inserting hundred of thousands of rows ! So is there a my

  - by asksuperuser

  I am currently adding hundred of thousands of rows of data to a table first on a MS Access Table then on a MySQL Table. I first tried with MS Access, it tooks less than 40 seconds. Then I tried exactly with the same source and with the same table structure to MySQL and it took 6 min and 40 seconds that is 1000% slower !!! So is there a myth that a database server is more performant ?

  Read the article

• jQuery Plugin to update live a <li> from PHP

  - by Francesc

  Hi, is there any jQuery plugin to create something like the live feed from the Twitter Main Page , using PHP, which is getting the data from a MySQL database? How has to be the PHP file? Thanks.

  Read the article

• Does Google app engine supports JDBC?

  - by Rakesh Juyal

  I have heard the Google App Engine[java] do not support JDBC and Hibernate. Is it true? If yes then how do we access the database in Google App Engine. Also, is there any [basic] sample application which can help me understand how to perform CRUD operations in GAE.

  Read the article

• How to find the nearest integer to a specified integer from a table of integers?

  - by corrilaz

  How to find the nearest integer upon the provided one? Say, I have the following integers in the mysql database: 405, 600, 304. The question is how to I select 600 upon providing 550 or select 304 upon providing 300 (ie, so as to find the nearest integer)? i am talking about INTEGERS, not floats.

  Read the article

• Client/Server communication via internet

  - by user957829

  Hi, Which is the best solution to communicate bidirectionally between a remote server and a client behind an internet box? UPnP with Sockets. HTTPS/Database Server and the client make 1 request every Xsec to know if there is new data. Client opens 1 connection on the server and it maintains open to make a tunnel. Thanks in advance for your help

  Read the article

• MySQL 5.0.22 export dump file not importing - syntax errors

  - by user348033

  Hello, I backed up my db with mysqldump from phpMyAdmin. Using MySQL 5.0.22. Made no changes to database file. Import fails. Found many instances of extra spaces using notepad, but now cannot find any other such extraneous spaces. Error is 1064. Any suggestions on how to import file properly? Thanks.

  Read the article

• Make a collection with movies

  - by Dimitar Vouldjeff

  Hello, I need to make a collection with a lot of movies, but I was wandering if there is something like API or other method to make that database automatically? I will be using Ruby on Rails, but if there is a useful and fast tool, I will use it. Thank you.

  Read the article

• When would isSearchable return false for an Oracle JDBC column?

  - by Ian Varley

  In what cases would a call to java.sql.ResultSetMetaData.isSearchable(int col) return false for an Oracle database? The documentation for the method doesn't really answer the question: "Indicates whether the designated column can be used in a where clause." I can think of only one case - when the column is the result of an aggregate function (in which case it would have to be part of a HAVING filter, not a WHERE filter). Are there any other cases?

  Read the article

• date / time convert to time since php

  - by Webby

  Hello in my database date / time are stored in this format 2010-06-01T18:20:25+0000 I'd like to echo that out to time passed since that date / time e.g. 2 minutes ago or 2 days ago is this possible?

  Read the article

• accessing Excelfile from Resources

  - by Sathish

  i am trying to access a Excel file stored in my Resources and build-embed by OLEDB but when i run the program i get database is read only.. i am using the below code. Please help conMap.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + CTARepository.Properties.Resources.mapping + ";Extended Properties=Excel 8.0;"; conMap.Open(); mapping is my mapping.xls file

  Read the article

• You do not have sufficient permissions to access this page.

  - by WmasterJ

  I recently set up a local copy of Wordpress, added some content and created a child theme. Then I moved it to my webserver, changed the config file, changed the "localhost" occurences in my SQL file to my online URL. I also changed my database prefix from what I had locally on all tables and in the config file. Everything works well on the outside. But then as I log-in is get the: You do not have sufficient permissions to access this page.

  Read the article

• Loading a entity IDs CSV column as hydrated entities in NHibernate

  - by James L

  I have a number of database table that looks like this: EntityId int : 1 Countries1: "1,2,3,4,5" Countries2: "7,9,10,22" I would like to have NHibernate load the Country entities identifed as 1,2,3,4,5,7,9 etc. whenever my EntityId is loaded. The reason for this is that we want to avoid a proliferation of joins, as there are scores of these collections.

  Read the article

• how can I easily upload outlook contacts into my web application?

  - by Angela

  Hi, I am trying to find a way for our users to very easily upload their outlook contacts into our web application (mysql database). I'm not sure where to begin. I've seen various tools which are pretty complex. I am open to existing third-party solutions, but my hope is that there is something which is very simple to use or build. Thanks. PS: Ideally, it would not involve using visual basic.

  Read the article

• deployement of a windows application project

  - by pk

  hi, i have made a project using c# .net windows application . i deployed it also bt wen i install n run it it throws an exception database not faund plz help me

  Read the article

• auto reload: how it works?

  - by Syom

  i need to change something in my site, if some fields changed in database, but without reloading the page! but i have no idea how i can do it. could you give me an idea? thanks

  Read the article

• cmd line SQL server 2008 express install

  - by Balaram

  hi, I am trying to install SQL server 2008 express on windows 7 64 bit machine using the following command: Setup.exe /qs /Action=Install /Features=SQL /InstanceName=XXX /SQLSYSADMINACCOUNTS="Builtin\Administrators" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" I can not access the database and get "access denied" error. I narrowed down the issue to the /SQLSYSADMINACCOUNTS="Builtin\Administrators" parameter not working. When I change this parameter value to currnet user or try manual install it works Any idea is appreciated.

  Read the article

• order keywords by frequency in PHP mySql

  - by Gusepo

  Hello, I've got a database with video ids and N keywords for each video. I made a table with 1 video ID and 1 keyword ID in each row. What's the easiest way to order keywords by frequency? I mean to extract the number of times a keyword is used and order them. Is it possible to do that with sql or do I need to use php arrays? Thanks

  Read the article

• mysql: inserting data and autoincrement

  - by every_answer_gets_a_point

  i am converting from access to mysql i have a table in access where one of the columns is an autonumber when i transfer the data into the mysql database (where i also have a column that is auto_increment), should i be transfering the auto_increment data into the auto_increment column, or will it auto_increment itself? how do i ensure that if i do not transfer the autoincrement data from access, that it auto_increments properly?

  Read the article

< Previous Page | 787 788 789 790 791 792 793 794 795 796 797 798  | Next Page >