Search Results

Search found 10815 results on 433 pages for 'stored procedure'.

Page 200/433 | < Previous Page | 196 197 198 199 200 201 202 203 204 205 206 207  | Next Page >

• SQL Server 2005: Why would a delete from a temp table hang forever?

  - by Dr. Zim

  DELETE FROM #tItem_ID WHERE #tItem_ID.Item_ID NOT IN (SELECT DISTINCT Item_ID FROM Item_Keyword JOIN Keyword ON Item_Keyword.Keyword_ID = Keyword.Record_ID WHERE Keyword LIKE @tmpKW) The Keyword is %macaroni%. Both temp tables are 3300 items long. The inner select executes in under a second. All strings are nvarchar(249). All IDs are int. Any ideas? I executed it (it's in a stored proc) for over 12 minutes without it finishing.

  Read the article

• Store global values for use in a wordpress theme

  - by CeejeeB

  How/Where can I store some values such as a phone number or email address so I can use these values on any page in a my custom theme? Example: I want to store a contact phone number that should be displayed in the header file of my theme but i dont want to hardcode it into the html. I would like to store it in a simerlar way custom values are stored but accessable from any theme page.

  Read the article

• how to know on which column,the sequence is applied?

  - by Vineet

  I have to fetch all sequences with their table name along with the column name on which sequence is applied .Some how i managed to fetch table name corresponding to sequence because in my data base sequence is stored with first name as table name from data dictionary(all_sequences and all_tables) . Please let me know how to fetch corresponding column name also if possible!!

  Read the article

• How do I debug a Unity Container "Resolve"?

  - by willem

  I'm using the MS Unity container to do dependency injection, but a "Resolve" is returning unexpected results. Is there an way I can debug this resolution? It would be great if I could view what Types/Instances are registered in the container, but I can't see where this is stored when using QuickWatch. It would also be useful if I could get the container to output some debug Traces. Any suggestions?

  Read the article

• How i can i use the value of a variable from one class in another in objective c?

  - by user337174

  Hi i am fairly new to objective c and have been doing some iphone programming. Is it possible to look up the value of a variable in a different class? Basically what i am doing is running a function that exists in my app delegate from a view controller, but the app delegate needs to use a variable stored in the view controller from which the app delegate function was called. Make sense??? Any help would be grateful. James

  Read the article

• what causes a bad token on iPhone- NSLog(@"token:%@",[devToken description]); crashes

  - by Grant M

  I am getting a bad token passed to me in - (void)application:(UIApplication *)app didRegisterForRemoteNotificationsWithDeviceToken:(NSData *)devToken this code crashes on my iPhone but not my clients. - (void)application:(UIApplication *)app didRegisterForRemoteNotificationsWithDeviceToken:(NSData *)devToken { NSLog(@"token:%@",[devToken description]); } I think something is wrong with my stored notifications settings on my iPhone but I can't find a way to delete them. deleting the app does not seem to do it.

  Read the article

• Air applicationUpdater: updates every run, should be once a day

  - by artie

  I use the applicationUpdater framework with an Air application. The delay property is set (in AS code) to 1 day. However, the application checks every time it is run: the delay property seems to be ignored. Does any one know where last run time is stored, so I can check if there's a reason it can't seem to remember ;-) the app is at http://muchoswing.com/cantoyo

  Read the article

• How to get the response of XMLHttpRequest?

  - by Rohan

  I'd like to know how to use XMLHttpRequest to load the content of a remote URL and have the HTML of the accessed site stored in a JS variable. Say, if I wanted to load and alert() the HTML of http://foo.com/bar.php, how would I do that?

  Read the article

• Personal directories on file server for each user in AD

  - by Niels Kootstra

  I want to make a home directory for each user of every group in AD using a batch script. the users personal directories (my documents, ...) should be stored in there as well. the path should be as following: \Fileserver{group name}{user name} can someone give me some pointers on how to achieve this?

  Read the article

• In mysql I want to set lower_case_table_names=1 on existing databases to avoid cases-sensitivity issues accross multiple platforms

  - by sakhunzai

  In mysql I want to set lower_case_table_names=1 on existing databases to avoid cases-sensitivity issues accross multiple platforms. A) What are the risks ?( besides show table issue) B) After setting lower_case_table_names=1, will I be in position to query databases across multiple platforms consistantly ? select * from USERS == select * from users; C) How the triggers + stored procedure + functions + views + events will be affected in this regards. I know lower_case_table_names is only for "TABLE" names but how about triggers other database objects . Will they remain case-insensitive How about views ? D) Do I need to rename all tables before/after this configuration setting or this will do the miracle in one step (i.e lower_case_table_names=1 neutralize table names) ? E) What will be the exact steps WRT:mysqd / my.ini ?

  Read the article

• How Google is managing authentication between multiple domains?

  - by vaibhav

  I think everyone here would be knowing that, if I am logged in any of the google's website(i.e www.orkut.com), I don't need to authenticate again for www.gmail.com. How google is managing this. I think, it would be a cookie stored on user's browser. But, if it is a cookie, how different domains are able to read this cookie. What do you say.

  Read the article

• Accessing Arbitrary Columns from an R Data Frame using with()

  - by johnmyleswhite

  Suppose that I have a data frame with a column whose name is stored in a variable. Accessing this column using the variable is easy using bracket notation: df <- data.frame(A = rep(1, 10), B = rep(2, 10)) column.name <- 'B' df[,column.name] But it is not obvious how to access an arbitrary column using a call to with(). The naive approach with(df, column.name) effectively evaluates column.name in the caller's environment. How can I delay evaluation sufficiently that with() will provide the same results that brackets give?

  Read the article

• Automatic Garbage Collection

  - by user367201

  Hi, I have an list of items that is stored in the $_SERVER["my_key"]. Are these items garbage collected automatically?

  Read the article

• Alternative Django Authenication

  - by pq

  Need to integrate Django with an existing authentication system. That system has it's own database, API, login/logout,edit profile web pages and cookie. (I may have to add a few additional profile fields stored/updated locally) What's the proper approach to substitute the out-of-the-box authentication in Django?

  Read the article

• Bypass Credential dialog box of internet explorer

  - by m23

  My c# application opens the Internet explorer for different web URL/ domains. And I have all those credential information (username, password and domain name) stored in the database for each web application. Now how I can authenticate automatically without entering credential in “Network Credential” dialog box using code or bypass that dialog box? In other words I need to store those credential on system so no need to enter. I am using c#

  Read the article

• Looking for a tool that can return SPs doing a DML on a table in SQL Server 2008

  - by Kiran

  I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?

  Read the article

• How to: compare array with string and create hastags before tweeting

  - by krike

  Let's say I have the following array (which is the returned value of a database query): Array ( [0] => PHP [1] => Webdesign [2] => Wordpress [3] => Drupal [4]) And the following string: Working With Wordpress Shortcodes How can I compare the array with the string to see if the string contains any word stored in the array? (hopefully that made sense to you :d ) When he finds a match (eg: Wordpress) it should create a hashtag like so: Working With #Wordpress Shortcodes

  Read the article

• Find value in collection

  - by Srikanth

  I need to search a name which is stored in collection. Search criteria: eg: 'Search Name' . If i give 'N' this name should be displayed. If i give any alphabet then all the names which contains the given alphabet should be displayed..the name can contains more than one word. I am using List collection. search criteria: eg. 1) a 2) xyz 3) full name I have .Net 3.5

  Read the article

• Efficiently store last X items in an MySQL Database

  - by Saif Bechan

  I want to store the last 3 items in an MySQL database in an efficient way. So when the 4th item is stored the first should be deleted. The way I do this not is first run a query getting the items. Than check what I should do then insert/delete. There has to be a better way to do this. Any suggestions?

  Read the article

• Using XMLHttpRequest ??

  - by Rohan

  Hey I'd like to know how to use XMLHttpRequest to load the content of a remote URL and have the HTML of the accessed site stored in a JS variable. Say, if I wanted to load and alert() the HTML of http://foo.com/bar.php, how would I do that? Thanks!

  Read the article

• Ordered hash in JavaScript

  - by hekevintran

  JavaScript objects have no order stored for properties (according to the spec). Firefox seems preserve the order of definition of properties when using a for...in loop. Is this behaviour something that I can rely on? If not is there a piece of JavaScript code somewhere that implements an ordered hash type?

  Read the article

• ListPreference, how can you make it to NOT save to SharedPreference?

  - by Pentium10

  I am resuing ListPreference for a setting which I store in the database. I do not want it stored in the preference file. How can I reuse ListPreference in such way that it does not save to SharedPreference file?

  Read the article

• how to read check box in a word document in asp.net

  - by Nataraja

  hi friends present i am working as developes, i want code for the following scenario my scenario is the word document must contain checkbox, and this word document should read to asp.net page, when user click the check box, the selected value should be stored into the database can any one help me

  Read the article

• PHP - get MySQL query results as their native data type?

  - by redidas

  I've tried fetching MySQL query results using mysql_fetch_row() mysql_result() and numeric values are being returned as strings. Is there any way to fetch the data as its datatype stored in the table? The application will be querying many different queries so I will be unable to cast the values as the intended datatype on a 1 by 1 basis.

  Read the article

• Programatic Access to the Java Plug-in Control Panel

  - by Mike Caron

  Is there a way to access the Java Plug-in Control Panel programatically? Or at least find the places in the Windows File System where the information backing that control panel is stored?

  Read the article

< Previous Page | 196 197 198 199 200 201 202 203 204 205 206 207  | Next Page >