Search Results

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

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

• Find all the varchar() fields in sql server?

  - by JD

  Hi, Is it possible to find all the varchar() columns in my database? I am using SQL Server 2008 and would like to get the list in SQL server management console. JD.

  Read the article

• Right tool for tracking DB structure changes

  - by termopro

  Right now i have a PHP project and i track all changes in code by SVN. I would also like to track changes made in database structure. Which is the right tool to use ?

  Read the article

• NSMutableDictionary confused over how to use keys with certain code ?

  - by Jules

  I'm getting data from a database and I need to add the string field value and the record id. However, I need this to work with some existing code... I'm replacing this (see code below) and getting data from my database. NSDictionary *dict = [[NSDictionary alloc] initWithContentsOfFile:path]; self.allCategories = dict; [dict release]; But needs to work with these key and value search functions. - (void)resetSearch { NSMutableDictionary *allCategoriesCopy = [self.allCategories mutableDeepCopy]; self.Categories = allCategoriesCopy; [allCategoriesCopy release]; NSMutableArray *keyArray = [[NSMutableArray alloc] init]; [keyArray addObject:UITableViewIndexSearch]; [keyArray addObjectsFromArray:[[self.allCategories allKeys] sortedArrayUsingSelector:@selector(compare:)]]; self.keys = keyArray; [keyArray release]; } . - (void)handleSearchForTerm:(NSString *)searchTerm { NSMutableArray *sectionsToRemove = [[NSMutableArray alloc] init]; [self resetSearch]; for (NSString *key in self.keys) { NSMutableArray *array = [Categories valueForKey:key]; NSMutableArray *toRemove = [[NSMutableArray alloc] init]; for (NSString *name in array) { if ([name rangeOfString:searchTerm options:NSCaseInsensitiveSearch].location == NSNotFound) [toRemove addObject:name]; } if ([array count] == [toRemove count]) [sectionsToRemove addObject:key]; [array removeObjectsInArray:toRemove]; [toRemove release]; } [self.keys removeObjectsInArray:sectionsToRemove]; [sectionsToRemove release]; [table reloadData]; } Keep getting an error from this code... NSDictionary *arrayTmp= [[NSDictionary alloc] init]; ... loop records int cid = sqlite3_column_int(statementTMP, 0); NSString *category = [[NSString alloc] initWithUTF8String:(char *)sqlite3_column_text(statementTMP, 1)]; [arrayTmp setObject:category forKey:[NSString stringWithFormat:@"%i", cid]]; Error caused by line above * Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[NSCFString count]: unrecognized selector sent to instance 0x4d4c500' * Call stack at first throw * ... end loop self.allCategories = arrayTmp; [arrayTmp release];

  Read the article

• Programmatically determine whether to describe an object with "a" or "an"?

  - by MarathonStudios

  I have a database of nouns (ex "house", "exclamation point", "apple") that I need to output and describe in my application. It's hard to put together a natural-sounding sentence to describe an item without using "a" or "an" - "a house is BIG", "an exclamation point is SMALL", etc. Is there any function, library, or hack i can use in PHP to determine whether it is more appropriate to describe any given noun with A or AN?

  Read the article

• Can you connect to sql server from Excel?

  - by AnonymousCow

  Hi, I need to create some reports from a sql server database for end users to view. Is it possible to hook into sql server from excel? Update The end user will only click on the file to view the reports, asking them to do more is too much to ask!

  Read the article

• ASP.NET MVC image upload store location (db vs filesystem)

  - by adrin

  I am writing web application using ASP.NET MVC + NHibernate + Postres stack. I wonder if images uploaded should be stored in database as binary blobs or on filesystem (and reference only in db). One advantage of db storage I can think of is easy backup/recovery of all data without reverting to filesystem copy tools. On the other hand I suspect that filesystem access may be faster (but is it especially when dealing with many concurrent requests?) What are your suggestions?

  Read the article

• Application crashes while using the scroll bars in winForm Datagrid view

  - by subbu

  Hi all i have a background worker thread and some unmanaged code dlls , In progress changed event of background worker . I will get the data from my database in a datatable and make this table as my DataSource. But when i use the scrollbards od DataGridView my application crashes.when I try to debug the application it gives "Unhandled exception in TestExe.exe : 0xC0000096: Privileged Instruction.

  Read the article

• Java application on windows server possibility?

  - by Shawn Mclean

  I'd like to know if it is possible to have this application (neo4j) running on windows server 2008 alongside an asp.net mvc application. Reason for this, I need to access the graph database (neo4j) which provides a RESTful service from my mvc application. How would I go about setting up this architecture?

  Read the article

• How can I connect to a mysql db from a different server ?

  - by HJ-INCPP

  Hello, I have, let's say, a root website with mysql db on a remote server. I want to connect to that particular database (to make queries), from many other little websites (with lower priviledges). Can this be done? Language: jsp,java,php Thank you

  Read the article

• Using ASP.Net GridView Update Command for specific fields

  - by kenom

  How do I use the Update command in GrideView? I would like to use update command for specific fields in the dataset, but not all fields from database ( or maybe in GridView? )

  Read the article

• How can i retrieve a jpg image in my WebView in android

  - by Maxood

  I have a jpg image in my resource folder. Now i want it to be displayed in my WebView along with other text in HTML coming from a database field. How can i retrieve/display that jpg image?

  Read the article

• Long time to load first sql connection in .NET

  - by Shrage Smilowitz

  For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second. any idea what could be the reason? I'm using C# and asp.net Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.

  Read the article

• Adding code to plugin that only executes the first time its activated?

  - by Scott B

  Is it possible to wrap code in a special function that only executes the first time the plugin is activated? I have some database code I need to run on plugin activation, but the code need not run again after that.

  Read the article

• select top 50 records from sql

  - by air

  i have following database table name tbl_rec recno uid uname points ============================ 1 a abc 10 2 b bac 8 3 c cvb 12 4 d aty 13 5 f cyu 9 ------------------------- ------------------------- i have about 5000 records in this table. i want to select first 50 higher points records. i can't use limit statement as i am already using limit for paging. Thanks

  Read the article

• removing non ascii characters from a string using python / django

  - by Gaurav

  I have a string of HTML stored in a database. Unfortunately it contains characters such as ® I want to replace these characters by their HTML equivalent, either in the DB itself or using a Find Replace in my Python / Django code. Any suggestions on how I can do this?

  Read the article

• What is Best way to obtain filename for HTML FILE Uploading on forms?

  - by CitadelCSAlum

  I need to obtain the String for the file that is being uploaded from forms to store in the database. I am using the usual form input file element input type="file" name="some_name" I found a couple JS scripts that allow me to do useless things like display the string in a dialog box, etc. I need this as an element on the request object or as a hidden field on my page when the form is posted.

  Read the article

• Unserialize data and check it against an id in MySQL

  - by kylex

  I have a row of IDs in a database that has been serialized. What I'm trying to do is check those serialized IDs against a known ID to see if it should be excluded or not. for example: "SELECT * FROM mydb WHERE id = 4 AND checkID != 'an id in the serialized column' " What's the best way to go about this?

  Read the article

• Page_Load after Modal Popup

  - by n0chi

  I have a page with a user control which gets some data updated via a modal popup. Upon clicking "ok" on the modal popup - the new data is being written to the database - but the base page doesnt "reload" to show the updated data. How do I get that to happen?

  Read the article

• PayPal debit VISA automatically?

  - by Mark

  If I have a Visa card number saved in my database, is there a way I can charge that Visa automatically through the PayPal API without the user having to enter anything? We want to keep this site as easy and hassle-free to use as possible. It would be a variable amount, based on how they use the site. (Don't worry, proper disclaimers will be in place, and the user will be notified)

  Read the article

• i m new to sharepoint and confuse, where coding take place in sharepoint application as other norma

  - by girish

  hello, i m new to sharepoint and bit confuse, i don't understand where coding take place in sharepoint as other asp.net application. how it work if i have to create a page for adding record to database.

  Read the article

• Using PHP to populate a <select></select> ?

  - by Flins

  <select name="select"> </select> I want to populate the above tag with values from database. I have written php code up to this. while($row=mysql_fetch_array($result)) { } $row is fetching fetching correct values.. how to add it to the <select> please help... Am new to programming

  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

• Postgres turn on log_statement programmatically

  - by rwallace

  I want to turn on logging of all SQL statements that modify the database. I could get that on my own machine by setting the log_statement flag in the configuration file, but it needs to be enabled on the user's machine. How do you enable it from program code? (I'm using Python with psycopg2 if it matters.)

  Read the article

• HIbernate - HBM.xml Automatic generation from DB Schema

  - by frappuccino

  Is there any plugin available for Eclipse or Netbeans or any other IDE which can help me generate the hbm.xml by directly reading the schema from the database. Writing those XMLs seem to be unnecessary waste of time, and feel it should be automated.

  Read the article

• How to auto insert the current user when creating an object in django admin?

  - by FurtiveFelon

  Hi all, I have a database of articles with a submitter = models.ForeignKey(User, editable=False) Where User is imported as follows: from django.contrib.auth.models import User. I would like to auto insert the current active user to the submitter field when a particular user submits the article. Anyone have any suggestions?

  Read the article

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