Search Results

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

Page 591/838 | < Previous Page | 587 588 589 590 591 592 593 594 595 596 597 598  | Next Page >

  • can't add a custom marker to Google maps ( JS )

    - by user296516
    Hi, Was wondering, how do I add a custom marker to google maps, JavaScript, integrated into my site. This code adds a regular marker: var marker = new GMarker(center); map.addOverlay(marker); but where do I insert an image tag (say, "marker.png" ) for it to appear instead of the regular google marker? Thanks!

    Read the article

  • jQuery user input to control option of one jquery function

    - by Tristan
    Hello, I'd like an input to control that : jQuery.ajax({ type: "get", dataType: "jsonp", url: "http://www.foo.com/something.php", data: {numberInput: "NUMBER I WANT TO CONTROL" }, On the HTML side I've <input type="text" id="jqueryControl" /> I want when a user enters a number into the jqueryControl to insert it in the .ajax function and reload the data according to the new value entered. Any idea to do that please ? Thanks

    Read the article

  • upsert with addition

    - by cf_PhillipSenn
    How would you write the following in Microsoft SQL Server 2008? IF EXISTS(SELECT * FROM Table WHERE Something=1000) UPDATE Table SET Qty = Qty + 1 WHERE Something=1000 ELSE INSERT INTO Table(Something,Qty) VALUES(1000,1)

    Read the article

  • Version of SQLite used in Android?

    - by Eno
    Reason: Im wondering how to handle schema migrations. The newer SQLite versions support an "ALTER TABLE" SQL command which would save me having to copy data, drop the table, recreate table and re-insert data.

    Read the article

  • Hibernate @DiscriminatorColumn and @DiscriminatorValue issue

    - by user224270
    I have this parent class: @Entity @Inheritance(strategy = InheritanceType.JOINED) @Table(name = "BSEntity") @DiscriminatorColumn(name = "resourceType", discriminatorType = DiscriminatorType.STRING, length = 32) public abstract class BaseEntity { and the subclass @Entity @Table(name = "BSCategory") @DiscriminatorValue("Category") public class CategoryEntity extends BaseEntity { But when I run the program, I get the following error: 2010-06-03 10:13:54,222 [main] WARN (org.hibernate.util.JDBCExceptionReporter:100) - SQL Error: 1364, SQLState: HY000 2010-06-03 10:13:54,222 [main] ERROR (org.hibernate.util.JDBCExceptionReporter:101) - Field 'resourceType' doesn't have a default value Any thoughts? Updated: Database is MySQL. I have also changed inheritance strategy to JOINED instead of SINGLE_TABLE. Help

    Read the article

  • How to get column value into row header

    - by Dharmendra Mohapatra
    ID amount year 1 300 02-02-2010 00:00 2 400 02-02-2009 00:00 3 200 02-02-2011 00:00 4 300 22-02-2010 00:00 5 400 12-02-2009 00:00 6 500 22-02-2009 00:00 7 600 02-02-2006 00:00 8 700 02-07-2012 00:00 9 500 08-02-2012 00:00 10 800 09-02-2011 00:00 11 500 06-02-2010 00:00 12 600 01-02-2011 00:00 13 300 02-02-2019 00:00 Desired output Y1 Y2 Y3 ........... sum(amount) sum(amount) sum(amount) Please suggest a approach Y1 is the year part of the date so my result column would be 2006 2009 2010 2011 2012 600 1300 800 1900 1200 Thanks. DB- MYSQL, SQL SERVER Thanks.

    Read the article

  • defining arrays in smarty via config files

    - by quardas
    Is it possible to defining arrays in config files in smarty?? for example I want have small data base in config file (located in /configs) - few (about 20) products descriptions: title, price, description. After that I want to list it via foreach or section. How can I define that array in Smarty without MySql or other db engine. Can I do that?

    Read the article

  • ComboBox in ASP.NET

    - by nCdy
    I can do DropDownList <asp:DropDownList ID="YearList" runat="server" oninit="YearList_Init1" /> but I can't edit text manually there. I can do Text box with Ajax DropDown extender but I can't select-Insert to textbox there. Only display :S Question : how to create DropDownList which I can edit manually ?

    Read the article

  • php with oracle 9i

    - by php_oracle
    Hi everyone, I am new in php with oracle. Trying to connect with oracle by php. But have no success. I have installed xammp since i had to work with mysql. And now i have to use oracle 9i (9.2.0.6). Now if i use -- oci_connect(username, password, servicename) -- It says undefined function oci_connect(); Can any one tell how to configure xammpp for oracle? Thanks in advance

    Read the article

  • Lightbox close and loading images not showing

    - by Mark Szymanski
    I am using Lightbox 2 and I have followed the short tutorial on how to insert it in a webpage and it works perfectly but the close and refresh images don't show. They are replaced with the classic Mac OS X '?' box. I have checked the paths of these images in the lightbox.js file and they are correct. Thanks in advance!

    Read the article

  • How can I specify that Doctrine must use a mysqli-connection

    - by murze
    Hi, while executing a long script that uses Doctrine to access the db, I get an error 2006 server has gone away. I've already solved this problem on a website that doens't use Doctrine. The solution there was to use mysqli instead of the normal mysql driver. How can i tell Doctrine to use a mysqli-driver in order to avoid 2006-errors? Thanks!

    Read the article

  • cassandra thrift: append data

    - by urssujith
    If I need to append data (not insert) into a particular super column, what should I do? For eg: Consider a existing record described below Kespace : test columFamily: testColum SuperColumn : testSuper column_name : email value : [email protected] Here if I want to add my phone number to the super column "testSuper". What should I do?

    Read the article

  • java progress bar while applet loads

    - by Dan
    OK so, let's say I have a Java applet that takes a while to load (~5 secs). It's getting the mysql-connector.jar and it's loading. Well.. instead of the gray box with the coffee logo... can I make it have a simple progress bar with the percent? Thanks.

    Read the article

  • Search and replace

    - by zx
    Hi, I have a really large SQL dump around 400MB. It's in the following format, "INSERT INTO user VALUES('USERID', 'USERNAME', 'PASSWORD', '0', '0', 'EMAIL', 'GENDER', 'BIRTHDAY', '182', '13', '640', 'Married', 'Straight', '', 'Yes', 'Yes', '1146411153', '1216452123', '1149440844', '0', picture', '1', '0', '0', 'zip', '0', '', '0', '', '', '0')" Is there anyway I can just get the email and password out from that, I want to import the users into another table. Anyone know how I can do this and just get email-password stripped out from that content? Thank you in advance

    Read the article

  • How to make a stored procedure return the last inserted id

    - by Luke101
    Here I have a stored procedure that inserts a row but how do you make it return the last inserted id without making another query CREATE PROCEDURE [dbo].[spInsertCriteriaItem] @GroupID int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; insert into CriteriaItem (CriteriaGroupID) VALUES(@GroupID) --I don't want to make another query here END Is it possible to do this

    Read the article

  • Need some code modification in jquery slider plugin

    - by Mirage
    I am using JCarousel plugin for sliders. It is working fine. But i wan this effect in another plugin called moving boxes I have 3 List items in Jcarousel. i want that the middle should expand like in moving boxes. There are two functions in moving boxes JS file called slider.js returnToNormal("#panel_"+curPanel); growBigger("#panel_"+next); But i don't know how i can insert those in Jcarousel

    Read the article

  • How can I make a resizable array in Java?

    - by Soren Johnson
    What is the best way to do a resizable array in Java? I tried using Vector, but that shifts all elements over by when when you do an insert, and I need an array that can grow but the elements stay in place. I'm sure there's a simple answer for this, but I still not quite sure.

    Read the article

< Previous Page | 587 588 589 590 591 592 593 594 595 596 597 598  | Next Page >