Search Results

Search found 32757 results on 1311 pages for 'database cursor'.

Page 880/1311 | < Previous Page | 876 877 878 879 880 881 882 883 884 885 886 887  | Next Page >

• Batch adding attribute to attribute sets

  - by JonB

  I have a Magento installation with around 60 attribute sets. I need to add a new attribute to each of the attribute sets. There doesn't seem to anyway of doing this in the admin control panel. I am sure I can work it out by manually entering the correct fields into the database, but is there a way of doing this through the API or through the Import / Export profiles? Any suggestions would be gladly received.

  Read the article

• set inline style for dynamically created asp panel.

  - by ErnieStings

  I'm taking values from a database and dynamically placing points on a 2d cartesian plane. I need a way to set the top and left css properties. Any help would be much appreciated. Thanks in advance

  Read the article

• Best Practice: Direct SQL Access vs. Web Service

  - by phsr

  With respect to an application that has both a web and desktop client version: What is the best practice for the desktop client which needs access to a SQL Server? What are the benefits of connecting to the database from the application vs using a web service? Which one provides better security? What type of scope would call for one vs the other (enterprise intranet vs. web app, etc) Are there any other considerations that are necessary when choosing on platform?

  Read the article

• Finding City and Zip Code for a Location

  - by Kristopher Johnson

  Given a latitude and longitude, what is the easiest way to find the name of the city and the US zip code of that location. (This is similar to http://stackoverflow.com/questions/23572/latitude-longitude-database, except I want to convert in the opposite direction.) Related question: http://stackoverflow.com/questions/158557/get-street-address-at-latlong-pair

  Read the article

• How to create the div, dynamically in asp.net.

  - by Ayyappan.Anbalagan

  I have some textbox and submit button. When ever I click the submit button the div should be added dynamically in my aspx page. Also the information which is available in the text box also displayed in the page default. Use:Without using database i need to display the user suggestion in my page...

  Read the article

• Sinatra/Rails: Persisting custom class instances during app lifetime

  - by knoopx

  Can I assert rails/sinatra apps are initialized only once and all requests share the same app instance? or do new requests spawn new app instances? Is it possible to instance custom classes and persist them during app lifetime without using sessions, database storages or third party services? If so, what are the implications from a thread-safeness point of view? I'm trying to figure how to implement a web-based download manager and I'm currently evaluating ruby-based frameworks.

  Read the article

• Codeigniter - how to use the foreign keys from one table to look for the id's of another table.

  - by Drew

  I'm having a problem trying to wrap my head around how to query the database to retrieve the foreign keys in my Nav table and then using those to find the id's in the NavItem table. Can someone point me in the right direction or give me some pointers? i'm not even sure if this should be done in the model or the controller! Thanks in advance

  Read the article

• How to get locale using Php.

  - by Ramakrishnan

  How to get Locale using Php,I want to get the time zone based on the location, is there any possibility to get in php. I need to convert it to GMT and save Database.Again i need to Pull it back to UI with same time same time zone.

  Read the article

• is the code given in description is executable in Windows system?

  - by OM The Eternity

  is the code given is executable in Windows system? as it seems to be Linux commands echo 'create database foo2' | mysql -uroot mysqldump --skip-triggers -uroot foo | mysql -uroot foo2

  Read the article

• question for jsp coding

  - by sheetal

  I am reteriving the set of values inside a table from database in a jsp page then it is in the form of link. Now I want to click that value and move to another jsp page. How to code the program so that it can recognise that value and it can move to the next desired page. But I unable to do that. please help me....

  Read the article

• how wordpress can un-slug a title

  - by Mac Taylor

  i still , don't understand , how wordpress can understand what is this url refer to : www.mysite.com/about-me/ they are using no identifier if they using slug functions so how they can retain story information or in other word , how they change back the slugged title to select from database

  Read the article

• Windows Phone Series: Local SQL Server Mobile/Compact information

  - by Calanus

  I know that this is jumping the gun slightly as it is early days but has anyone got any information on how we can build apps that take advantage of a basic local SQL database like you used(!) to in Windows CE/mobile 6.x? I can't find any info on the intertubes so maybe it hasn't been announced yet??

  Read the article

• PHP - Language Data

  - by bobrusha

  What's the best way to store language data? Keep it as variables in some kind of lang.php file... $l_ipsum = 'smth'; $l_rand = 'string'; Or select them from a database? I'm in search of your advice.

  Read the article

• Java Swing how to create a task reminder

  - by newbie123

  How to create a event reminder. Example, an user created an event which is today 5.00pm and stored it into database. When ruun the program the reminder will pop up if the system time is 5.00pm. Is there any API can do that? From google what I got was those freeware.

  Read the article

• MySQL/Rails Version Control for CMS - How is it usually done?

  - by viatropos

  How do projects like BrowserCMS for Rails implement version control for a CMS? What is best practice for version control with database content? How does it relate to git/svn?

  Read the article

• How can a Script be passed through a TextArea into a Form?

  - by William Calleja

  I need to make a form with a Text Area that accepts lines of script, any kind of script be it javascript, css, html, vbscript, whatever. How can the script be passed to a form post? EDIT: How can this script be modified so it can be inserted into a Database? Specifically SQL Server 2005

  Read the article

• Repeating events in a MySQL DB

  - by kylex

  I'm needing to create a MySQL database that is capable repeating events in the exact same way that google calendar repeats events. What is the best way to structure the table(s) to do this?

  Read the article

• Add a foreign key to existing tables in Rails (MySQL)

  - by randombits

  What's the best way to add foreign keys to my existing tables in Rails with an underlying MySQL database? clearly the solution should be done in a migration, as I want this versioned. Otherwise I'd create the constraints myself. I can't seem to find one, conducive response to they above. Again, the tables have already been created with previous migrations. I'm just going back now and adding referential integrity wherever it's applicable.

  Read the article

• Datagrid in JSP

  - by Geethapriya.VC

  Hi, I need to create a Datagrid with a radiobutton column in JSP. The grid is to be binded dynamically to a result set and be populated accordingly. This result set is obtained as a result of search in the database. Please do help with a sample source code, or a useful link for the same. Thanks in advance, Geetha

  Read the article

• Where can I get a machine readable representation of world currencies and their symbols?

  - by Khanzor

  I'm using ASP.Net and would like to display currencies based on a country. I've had a look at http://www.xe.com/symbols.ph, http://www.xe.com/iso4217.php and http://www.iso.org/iso/support/faqs/faqs_widely_used_standards/widely_used_standards_other/currency_codes/currency_codes_list-1.htm Is there anywhere I can get something that I can load into a database? Or is there something built in to SQL Server 2005/ASP.Net to help with this?

  Read the article

• How to get size of file uploaded to SQL-Server?

  - by MadBoy

  Is there a way to tell how to get a file size that is uploaded to database? SELECT [ID] ,[File] FROM [dbo].[Reports] I would like to be able to tell user the size of File which is VarBinary(max) field in MS SQL 2005/2008. How to do that? Maybe the only way to do is to create another column and when inserting file i should also insert it's size in additional column?

  Read the article

• manipluation of date in vb

  - by banita

  how can we extract system time in vb and do calculation ie. adding or subtracing time then store change time in oracle database table in earlier format .

  Read the article

• Click a button on an MS Access form from C# using Access Interop

  - by Az

  Hi, I can connect to the access database and run functions etc from c#, I can even get a hold of the button I need to click, but I can't make it think it's been clicked. nonManagedDb.DoCmd.OpenForm("frmMaintenance", Access.AcFormView.acNormal, MissingVal, Access.AcFormOpenDataMode.acFormReadOnly, Access.AcWindowMode.acWindowNormal, MissingVal); var RunRep = (CommandButton)nonManagedDb.Forms["frmMaintenance"].Controls["btnDailySheetsReport"]; That's as afar as I've gotten with this, I've tried reflection to grab it's event and invoke it but it's classed as a COM object only so that's out.

  Read the article

• uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)

  - by William

  Hi, moved a rails app of mine onto a new server and had to install a few gem dependencies. However, after installing the mysql gem I get the error, uninitialized constant MysqlCompat::MysqlRes, whenever I try to run a rake command that involves the mysql database. It seems I only get this error when I require the mms2r gem. Has anyone ever heard of this? I'm running mysql 2.8.1 gem.

  Read the article

• How to optimize an update SQL that runs on a Oracle table with 700M rows

  - by Bruno Rothgiesser

  UPDATE [TABLE] SET [FIELD]=0 WHERE [FIELD] IS NULL [TABLE] is an Oracle database table with more than 700 million rows. I cancelled the SQL execution after it had been running for 6 hours. Is there any SQL hint that could improve performance? Or any other solution to speed that up?

  Read the article

< Previous Page | 876 877 878 879 880 881 882 883 884 885 886 887  | Next Page >