Search Results

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

Page 485/838 | < Previous Page | 481 482 483 484 485 486 487 488 489 490 491 492  | Next Page >

  • Do I need Amazon's EC2, Cloudfront, RDS?

    - by Jasie
    Hello, I want to publish a web site on Amazon's servers, that: Runs CakePHP Uses MySQL to store data Lets users upload audio through flash (currently using a hosted Flash Media Server), and listen to the files later Do I need Amazon's EC2 for the website, RDS for the MySQL database, and CloudFront for the FMS? Thanks.

    Read the article

  • Best practices for building a simple, scalable cluster on Amazon EC2 for a Java web app

    - by Alex B
    I want to build a Java web app and deploy it on EC2. It will be written in Java and will use MySQL. I was hoping to get some pointers on the actual deployment process and configuration. In particular I'm interested in the following topics: machine images (diy vs ready made) mysql replication and backup to S3 ways of deploying and redeploying the app to EC2 without interruptions firewalls? load balancing and auto scaling cloudtools (or alternative tools)

    Read the article

  • Getting XQuery [modify()]: Top-level attribute nodes are not supported error while modifying xml

    - by sam
    DECLARE @mycur CURSOR DECLARE @id int DECLARE @ParentNodeName varchar(max) DECLARE @NodeName varchar(max) DECLARE @NodeText varchar(max) SET @mycur = CURSOR FOR SELECT * FROM @temp OPEN @mycur FETCH NEXT FROM @mycur INTO @id,@ParentNodeName,@NodeName,@NodeText WHILE @@FETCH_STATUS = 0 BEGIN PRINT @id -- sample statements PRINT @ParentNodeName PRINT @NodeName SET @x.modify (' insert attribute status {sql:variable("@status")} as first into (/@ParentNodeName/@NodeName/child::*[position()=sql:variable("@status")])[1] ') FETCH NEXT FROM @mycur INTO @id,@ParentNodeName,@NodeName,@NodeText END DEALLOCATE @mycur Any idea why I am getting this error as query works fine if I manually insert path

    Read the article

  • To change the text of LinkButton in EditItemTemplate

    - by Nandini
    Hi, I have a table from which i am getting my data to the GRidview control.I need to Insert Or Update this row to another table, according to some condition.If one condition is true, i need to change the text of the linkbutton in edititemtemplate to insert,else to update itself.How can i change the text of linkbutton in rowcommand? Please Help

    Read the article

  • Tokyo Tyrant indexes

    - by viraptor
    I was wondering about size requirements for Tokyo Tyrant indexes. If I have an index on field x and insert a record with fields y and z only, does the x index grow? Also: does the insert time grow in that case?

    Read the article

  • Cassandra: Using LongType

    - by TheDeveloper
    I'm trying to insert data into a ColumnFamily with "CompareWith" attribute "LongType". However, when trying to insert data under numerical keys, I get a thrift error. When attempting the same operation with the cassandra-cli program, I get the error "A long is exactly 8 bytes". How can I resolve this? Should I use a different comparison type? Thanks

    Read the article

  • Rich Text Editing in Windows Forms

    - by fawad
    I am using following text editor for my windows forms application http://www.codeproject.com/KB/edit/editor_in_windows_forms.aspx This works great and a wonderful control, however I am trying to accomplish one task i.e. I wanted to insert a custom tag to the underlying html for eg if user clicks on a button on form I want to insert a tag <myTag>value</myTag>" at the cursor's position of text editor. Can anyone guide me how to achieve this?

    Read the article

  • Error while installing joomla on iss

    - by Anand
    Hello Guys i have a server on that server iis 7 ,php(5.3.13),.net and mysql is installed and i can easily connect with the mysql but when i am installing joomla and enter DB configuration then hit enter or press Next button then nothing happend and url changes from http://localhost/joomlatest3/installation/index.php to http://localhost/joomlatest3/installation/index.php# i have install fresh stable package 2.5.7 And i have tried joomla 1.5 and 3.0 but the same problem persist any idea why this error is coming Thanks in advance Anand Neema

    Read the article

  • MS SQL and Identity column

    - by andrew007
    Hi, I just noticed that if I have an identity column in a table, when I insert new rows MS SQL 2008 is automatically filling up the sequence if there are discontinuity. I mean, if in my identity column I have 1,2,5,6 if I insert other two rows in the table the system puts automatically 3,7 in the identity column. Do you know how to control this behavior? THANKS

    Read the article

  • Ruby 'if' condition in rjs

    - by ash34
    Hi, I want to insert a user in the userlist only if the user object (@row) is not nil. How do I do the insert conditionally in an rjs template? page.insert_html :bottom, :userlist, render(:partial = "user", :locals = { :user = @row, :myid = @row.id }) thanks much.

    Read the article

  • Getting A LINQ .InsertOnSubmit To Work

    - by Soo
    Hi SO, I'm trying to get an insert to work using LINQ and am having some difficulties. I am using this example to base my code: http://msdn.microsoft.com/en-us/library/bb763516.aspx I have my data object set up, but don't know what's going on when db.Orders.InsertOnSubmit is executed. How can I create this db object to insert a data object into my database using InsertOnSubmit?

    Read the article

  • Oracle 10gR2 CLOB Data type

    - by Dhiv
    I am having table with clob column & trying to insert SIGNED character data which contains =176048 characters, it throws error has Insert exception data transaction java.sql.SQLException: ORA-01704: string literal too long

    Read the article

  • systray gadget to start stop tomcat

    - by opensas
    I'd like to know if anybody knows of any systray applet to control tomcat service con windows xp... apache installs its own, and there's one for mysql in the mysql gui tools... so the only one I'm missing is tomcat... thanks a lot

    Read the article

  • SQL Server Indexing

    - by durilai
    I am trying to understand what is going on with CREATE INDEX internally. When I create a NONCLUSTERED index it shows as an INSERT in the execution plan as well as when I get the query test. DECLARE @sqltext VARBINARY(128) SELECT @sqltext = sql_handle FROM sys.sysprocesses s WHERE spid = 73 --73 is the process creating the index SELECT TEXT FROM sys.dm_exec_sql_text(@sqltext) GO Show: insert [dbo].[tbl] select * from [dbo].[tbl] option (maxdop 1) This is consistent in the execution plan. Any info is appreciated.

    Read the article

  • SSIS flat file insertion failure to rollback

    - by Pramodtech
    I have simple SSIS package which reads data from flat file and insert into SQL database. The file has 90K rows and sometimes because of bad data package fails but it insert the partial records before it fails. What I need is if insertion fails at any time between, no records should be inserted into DB, rollback everything. how can I put it in transaction?

    Read the article

  • i want to call the function when i clicked on the checkbox using prototype.js.here obj[i] contents j

    - by vicky
    DeCheBX = $('MyDiv').insert(new Element('input', { 'type': 'checkbox', 'id': "Img" + obj[i].Nam, 'value': obj[i].IM, 'onClick': SayHi(this) })); document.body.appendChild(DeCheBX); DeImg = $('MyDiv').insert(new Element('img', { 'id': "Imgx" + obj[i].Nam, 'src': obj[i].IM })); document.body.appendChild(DeImg); } SayHi = function(x) { try { if($(x).checked == true) { alert("press" + x); } } catch (e) { alert("error");

    Read the article

  • Conditional ESC, ideas?

    - by Tony
    I often need to enter insert mode just to make changes on a specific line, and would like know if there is a way to enter insert mode in a way that when I am done editing on that line, hitting [Return] gets me back to normal mode. I am aware of the 'r' command for replacing a single character, I guess what I want is something like that but for a line.

    Read the article

  • Connect to Mongodb in python

    - by SpawnCxy
    I'm a little confused by the document when I tried to connect to the Mongodb.And I find it's different from mysql.I want to create a new database named "mydb" and insert some posts into it.The follows is what I'm trying. from pymongo.connection import Connection import datetime host = 'localhost' port = 27017 user = 'ucenter' passwd = '123' connection = Connection(host,port) db = connection['mydb'] post = {'author':'mike', 'text':'my first blog post!', 'tags':['mongodb','python','pymongo'], 'date':datetime.datetime.utcnow()} posts = db.posts posts.insert(post) #print str(db.collection_names()) And I got an error as pymongo.errors.OperationFailure: database error: unauthorized.How can I do the authorizing part?Thanks.

    Read the article

  • SQL Random number not working

    - by JMSA
    declare @fieldForceCounter as int declare @SaleDate as dateTime declare @RandomNoSeed as decimal set @fieldForceCounter = 1 set @SaleDate = '1 Jan 2009' set @RandomNoSeed = 0.0 WHILE @fieldForceCounter <= 3 BEGIN while @SaleDate <= '1 Dec 2009' begin INSERT INTO MonthlySales(FFCode, SaleDate, SaleValue) VALUES(@fieldForceCounter, @SaleDate, RAND(@RandomNoSeed)) set @saleDate = @saleDate + 1 set @RandomNoSeed = Rand(@RandomNoSeed) + 1 end set @SaleDate = '1 Jan 2009' set @fieldForceCounter = @fieldForceCounter + 1 END GO This T-SQL command was supposed to insert random values in the 'SaleValue'-column in the 'MonthlySales'-table. But it is inserting '1' every time . What can be the problem?

    Read the article

  • mysqldumpslow @ Freebsd

    - by Tomasz
    I have installed mysql-client-5.4.2 Multithreaded SQL database (client) mysql-server-5.4.2 Multithreaded SQL database (server) on my FreeBSD 8.0 box Why isnt there mysqldumpslow command available? What port should i install to make it available

    Read the article

< Previous Page | 481 482 483 484 485 486 487 488 489 490 491 492  | Next Page >