Search Results

Search found 20931 results on 838 pages for 'mysql insert'.

Page 601/838 | < Previous Page | 597 598 599 600 601 602 603 604 605 606 607 608  | Next Page >

• What would be the datastructure in following scenorio?

  - by Abhishek Jain

  Please note that there is no limitation of memory. I need to insert int from 1 to 1000. I can do the following operations in constant order of time: push(), pop() and getMax() Please suggest me appropriate datastructure.

  Read the article

• How can we make our website scalable?

  - by Hello you all men

  We own a big site and we submitted it to digg. Overnight, we had too many users added, up to 9000+. We use Zend framework with one MySQL database. What actions should we take to make our server scale well?

  Read the article

• The Best Way to shred XML data into SQL Server database columns

  - by eddiegroves

  What is the best way to shred XML data into various database columns? So far I have mainly been using the nodes and value functions like so: INSERT INTO some_table (column1, column2, column3) SELECT Rows.n.value('(@column1)[1]', 'varchar(20)'), Rows.n.value('(@column2)[1]', 'nvarchar(100)'), Rows.n.value('(@column3)[1]', 'int'), FROM @xml.nodes('//Rows') Rows(n) However I find that this is getting very slow for even moderate size xml data.

  Read the article

• libmysql c++ text problem :P

  - by stefan

  Im using libmysql for mysql in c++ and now i got a column, type= text, and i want the word(s) inside it. how to do this? when i use Blob (dont know what it is) it gives me e44158 :S. can somebody help me please?

  Read the article

• Memory Allocation for a Map with a fixed number of insertions

  - by prasoon99

  I want to insert n elements into a map where n is known ahead of time. I do not want memory allocation at each insertion. I want all memory allocation at the beginning. Is there a way to do this? If so, how? Will writing some sort of memory allocator help?

  Read the article

• How to fill a two Dimensional ArrayList in java with Integers?

  - by eNetik

  I have to create a 2d array with unknown size. So I have decided to go with a 2d ArrayList the problem is I'm not sure how to initialize such an array or store information. Say I have the following data 0 connects 1 2 connects 3 4 connects 5 ....etc up to a vast amount of random connections and I want to insert true(1) into [0][1], true(1) into [2][3], true(1) into [4][5]. Can the array automatically update the column/rows for me Any help is appreciated thanks

  Read the article

• What are the factors in choosing a specific Database Management System?

  - by mr.bio

  Why are there so many Database management systems? I am not an DB expert and I've never thought about using another Database other than mySQL. Programming languages offer different paradigms, so it makes sense to choose a specific language for your purpose. Question What are the factors in choosing a specific Database management system ?

  Read the article

• Inject Javascript into iFrame generated by TinyMCE/YUI?

  - by user365804

  I'm trying to insert/load javascript (e.g. prototype/jquery) into the iFrame generated by TinyMCE (tinymce.moxiecode.com) or YUI's text editor (http://developer.yahoo.com/yui/editor/) so as to better manipulate the objects/images/DIVs inside it. Any thoughts?

  Read the article

• changing the db used with cucumber to the _test db instead of _development

  - by DerNalia

  For whatever reason, my cucumber is using my _development db instead of my _test db. How do I change that? This is what my database.yml says test: adapter: mysql encoding: utf8 but i get the error database configuration does not specify adapter

  Read the article

• get data from a querystring

  - by regwe

  i have this querystring that shall open up my page. http://www.a1-one.com/[email protected]&stuid=123456 Now when this page loads, on page_load, I want to pick up email and stuid in two different variables. So I can use them to insert into my database (sql server) how can this be done in vb.net

  Read the article

• SQL Server: how to export a table

  - by Patrick

  how can I export a SQL Server table to Mysql ? I guess I need to export a .sql file compatible... thanks

  Read the article

• TinyMCE Custom Tags Rendering

  - by Cullen2010

  I have add a custom plugin that insert custom tags into my tinyMCE editor of the format: title I want the custom tags to be rendered with some styles when viewed in the WYSIWYG view. I have seen one response to a similar question : http://topsecretproject.finitestatemachine.com/2010/02/how-to-custom-tags-with-tinymce/ but this doesn't work - they tags are not stripped out but they are not styled either??

  Read the article

• How do I encode Unicode strings using pyodbc to save to a SAS dataset?

  - by Chris B.

  I'm using Python to read and write SAS datasets, using pyodbc and the SAS ODBC drivers. I can load the data perfectly well, but when I save the data, using something like: cursor.execute('insert into dataset.test VALUES (?)', u'testing') ... I get a pyodbc.Error: ('HY004', '[HY004] [Microsoft][ODBC Driver Manager] SQL data type out of range (0) (SQLBindParameter)') error. The problem seems to be the fact I'm passing a unicode string; what do I need to do to handle this?

  Read the article

• Can I run a Firebird stored procedure from a batch file, or is there an ISQL equivalent

  - by Mark

  I want to run a Firebird stored procedure from a batch file or similar on a desktop. The stored procedure contains insert statements and update statements with if possible parameters that I would like to pass. Any ideas or other suggestions would be appreciated.

  Read the article

• Using serializable in hibernate what underlying database types do i use.

  - by joe90

  I need to use a serializable type in hibernate (to store a Subject (security)) All this works fine. I just need to know what the underlying database types are for the following databases: MSSQL - I used 'image' db2 - postgre - mysql - Thanks..

  Read the article

• Cannot add or update a child row: a foreign key constraint fails

  - by sarah

  Hi All, i am having a user table which has desname as FK referring to des table ,i am trying to add desname in user but i am gettng Cannot add or update a child row: a foreign key constraint fails error. desname is prepopulated and i am selected the same for he user.Where i am doing wrong I ma using mysql and hibernate hbm

  Read the article

• Href link with php value

  - by Aruna

  hi i am having a link like below <a href="#" onclick="window.open('http://www.twitter.com/home?status=Reading+Facebook share, Yahoo Buzz and Tweet this buttons for Blogger blogs+http://www.didiknow.com');">Tweet this</a> i want to insert a php variable value inside for the status thing like <a href="#" onclick="window.open('http://www.twitter.com/home?status=$markme_ddesc">Tweet this</a> how to do so?? please help me..

  Read the article

• explain these select statements!

  - by user329820

  Hi, I can not get the difference betwwn these statements? would you please help me,I have read some sample of select statements but I did not get these ones. SELECT 'B' FROM T WHERE A = (SELECT NULL); SELECT 'C' FROM T WHERE A = ANY (SELECT NULL); SELECT 'D' FROM T WHERE A = A; I use MySQL

  Read the article

• Window Application

  - by user350104

  how to create connection using class file in C# for windows application?... how to develop Data access layer... regarding 3-tire architecture using mysql databases

  Read the article

• asp.net formview data tool

  - by Parth

  the formview in data tools in asp.net by default gives textbox in insert mode template. how to change this to textarea or dropdown selection list?

  Read the article

• word Application.AddIns.Add throws 'Word cannot open this document template'

  - by Vinay B R

  Hi, I have a template document with a simple macro to insert a file into a document. When i try to load this template file using Application.Addins.Add i am getting an error saying 'Word cannot open this document template'. wordApplication.AddIns.Add( %template file path%, ref trueObj ); This works fine on some machines. Also is there any way to make sure that we load the template file as a global Template always.

  Read the article

• sql data source

  - by George

  I have a table (EmployeeID,EmployeeName,ManagerID) How can I create a sqldatasource to include the ManagerName from the EmployeeName given EmployeeID = ManagerID? In my gridview after dragging a dropdownlist what bindings should I do to display the managerName? Is it possible to use it without writing custom select,insert,delete,update? If not what are the steps I need to do to write the whole thing i.e. custom grid and source? Thank you very much

  Read the article

• Web site backup in PHP?

  - by Pekka

  Does anybody know a clean PHP-based solution that can backup remote web sites using FTP? Must haves: Recursive FTP backups Possible to run through a cron job Easy to configure (easy adding of multiple sites) Local storage of backup files is sufficient Would be nice: Backed up sites are stored as zip files A nice interface to manage things Provides notification when backup has succeeded or failed Does incremental backups Does MySQL Database backups I need this to be PHP (or Perl) based because it's going to be used on shared hosting packages that do not allow usage of the standard GNU/Linux tools available.

  Read the article

• Cassandra replication system - how it works

  - by inquisitor

  Does cassandra replicates only on write procedure (with choosen consistency level)? Is there any auto-replicate option for absent nodes, if i want symetric data in every node? If I plug in new node to cluster there is no auto replication - how to sync data from others nodes with new one? If I want replication like multimaster (2 nodes) with slave backup (1 node) known from MySQL, what is the proper logic setup and manage that on cassandra (3 nodes)? How about two nodes?

  Read the article

• Trace Flag 1211 Not Working - SQL Server 2008 R2

  - by psam

  During a SSIS load, when an employee table is getting updated, locking comes into effect. However, have disabled lock escalation on the table using the following statements: ALTER TABLE dbo.Employee SET (LOCK_ESCALATION = DISABLE) DBCC TRACEON (1211,-1) However, the table (object) does get locked and is held for almost an hour. The total no. of updates (insert, update, delete statements) are approx 200,000

  Read the article

< Previous Page | 597 598 599 600 601 602 603 604 605 606 607 608  | Next Page >