Search Results

Search found 10189 results on 408 pages for 'db 11gr2'.

Page 233/408 | < Previous Page | 229 230 231 232 233 234 235 236 237 238 239 240  | Next Page >

• insertion in the same row for all activities

  - by Utman Alami

  i am here to ask for help again, i created one database for all activities, the problem i have is that the insertion in every activity comes in with new row, but that's not what i want, what i am looking for is in the same row in each activity insert the columns that contains. i already looked for solution here, they are speaking about static…

  Read the article

• NullPointerException while trying to bind at SimpleCursorAdapter

  - by hrskrs

  I have asked a question before where i found my mistake. However now i am facing with another problem. I have checked all the similar errors asked on StackOverflow but without success.Any help is appriciated. The idea here is that i am getting image names from DB so depending on those names images from Drawable folder will be shown in a listView…

  Read the article

• Allow users to pull temporary data then delete table data (headers remain)?

  - by JM4

  I don't know the best way to title this question but am trying to accomplish the following goal: When a client logs into their profile, they are presented with a link to download data from an existing database in CSV format. The process works, however, I would like for this data to be 'fresh' each time they click the link so my plan was - once a…

  Read the article

• best way to display image in php

  - by pradeep

  Hi, I am storing images in mysql Db directly. what is the best way to display the image in good quality (thumbnail and original size images) using php.

  Read the article

• Is The Transaction Log Truncated When Doing a Backup In Full Recovery Mode?

  - by byte_slave

  Is the database transaction log automatically truncated after we create a backup and the DB is in full recovery mode? Or do we need to make 2 different backups, let's say 1 in full recovery mode and a different one for the log file.

  Read the article

• How can I remove the unique option from a column in MySQL ?

  - by Tom Nipravsky

  Hello, I have a field in my db called "user" which is unique. I would like to remove the "unique" option so I can have couple of users with the same nickname. Which sql statement should I execute to perform this action ? Thanks

  Read the article

• Find query that caused update

  - by MadMax

  We have been having problems with ghost updates in our DB (SQL Server 2005) fields are changeing and we cannot find the routine that is updating. Is there a way using an update trigger (Or any other way) to tell what caused the update?

  Read the article

• SQL query help - finding rows with no relationships

  - by DD

  Consider a DB with a Client table and a Book table: Client: person_id Book: book_id Client_Books: person_id,book_id How would you find all the Person ids which have no books? (without doing an outer join and looking for nulls)

  Read the article

• Easiest way to copy a mysql database from windows to linux?

  - by acidzombie24

  I dont have perl install on windows. I would like to copy the entire testdb to testdb on my linux VM. What is the easiest way to do that? I can run code on my windows machine to connect to both DB and do sql operations. I am using C#.NET so if i need to write code and its simple then i'm open to that.

  Read the article

• Check mysql_query results if DELETE query worked?

  - by Camran

  I have a DELETE query which deletes a record from a mysql db. is there any way to make sure if the delete was performed or not? I mean, for a query to FIND stuff you do $res=mysql_query($var); $nr=mysql_num_rows($res); and you get nr of rows returned. Is there any similiar method for deletion of records? Thanks

  Read the article

• case-insensitive search of MySQL?

  - by Haroldo

  case-insensitive search of MySQL? For my site search, what is the most efficient way of to query my db for a word/phrase regardless of case?

  Read the article

• Any other way to import data files(like .csv) in python sqlite3 module ?[not insert one by one]

  - by cyaos

  in sqlite3's client CLI, there is " .import file TABLE_name " to do it. But, I do not want to install sqlite3 to my server at present. in python sqlite3 module, we can creat and edit a DB. But, I have not found a way to import data-file to a TABLE, except inserting rows one by one. any other way? Thanks.

  Read the article

• Download a file+

  - by Martin

  Hi, First PHP project and I'm stuck! I wish to allow users to click a button or a link and download a file. However, my PHP must first perform some tasks, choose the right file, record the download event in a db etc. This I can do, but how do I then send the file as a response to the user's click? Thanks for any help.

  Read the article

• MySQL Can't Handle Parameters for Stored Procedures

  - by Takkun

  I'm trying to make a stored procedure but it doesn't seem to be recognizing the parameters I've given it. Procedure create procedure test_pro(IN searchTable VARCHAR(55)) begin select * from searchTable limit 10; end // Trying to execute mysql> call test_pro('exampleTable'); ERROR 1146 (42S02): Table 'db.searchTable' doesn't exist It…

  Read the article

• mysql_query() returns returns true, but mysql_num_rows() and mysql_fetch_array() give "not a valid r

  - by zlance4012

  Here is the code in question: -----From index.php----- require_once('includes/DbConnector.php'); // Create an object (instance) of the DbConnector $connector = new DbConnector(); // Execute the query to retrieve articles $query1 = "SELECT id, title FROM articles ORDER BY id DESC LIMIT 0,5"; $result = $connector-query($query1); echo…

  Read the article

• Check value existance while performing a UPDATE query

  - by nimo

  Hi, I need to perform a simple update query where the update should only be done, if there is no value with updating value (item_name). For example, DB table [item_types] item_id(PK) | item_name Assuming there exist item_id with 6, My attempt is UPDATE item_types as k SET k.item_name = 'item_1' WHERE NOT EXISTS (SELECT * FROM…

  Read the article

• Multiple reference in SQL

  - by AGarofoli

  Hi! I'm working on a db but i'm kinda new to this so i've bumped into a problem today. I've got some tables: OFFICE, ROOM, EMPLOYEE and DOCUMENT. Document must specify the sender, which can be a single employee, an entire room or an entire office so it must have a reference to the primary keys of those tables. Should I do a…

  Read the article

• Is there any way for the controler to get values from a form in your view before it is saved?

  - by Datatec

  I assume the values must be passed back to the controller for use, but everything I have tried seems to only get values that have already saved in the db.

  Read the article

• How to create Local Data Caching in c# WinApps?

  - by kurt_jackson19

  Anyone can give me an example on how to create local data caching? Like for example I query 10 millions records from my DB and I want to store it in my local so that I would not encounter performance problem next time when I want to reload the data. Thank you so much.

  Read the article

• What's the best way to store sensative data in MySQL?

  - by embedded

  I'm managing the MySQL database from PHP scripts. the communication between server and client is secured via SSL. I store user account data which is sensitive. Is there a way to encrypt this data when entered into the DB? What is the best way to protect this sensitive data? Thanks

  Read the article

• Windows Mobile - Is it possible to get list of calls?

  - by dynback.com

  I want to save some data automaticly from phones to central db? Is that possible in Windows Mobile 6.0?

  Read the article

• Query to get largest datatype in schema

  - by crazyguy-or-am-i

  What is the query to get the top 5 ...data types ...used in a DB by size? for eg. int(20) is greater than int(4)

  Read the article

• How to handle XML string %Like% search in C#

  - by Nano HE

  Hi, As I know I can search DB with Sql %like% syntax. Now I am working with XML, how can I handle the same search condition for XML file in C#? Thank you.

  Read the article

• The command redirect_to "http://google.com" doesn't appear to be working!

  - by rtfminc

  So I have the final line in my controller: redirect_to "http://google.com" And the prod log has: Redirected to http://google.com Completed in 8ms (DB: 4) | 302 Found [http://www.exmaple.com/728zz5d/delete_stuff] And the web page still had the original info - I'm not sent to google??? What am I not understanding?

  Read the article

• SQL Developer Blitz at ODTUG Kscope12

  - by thatjeffsmith

  Oracle Development Tools User Group (ODTUG) puts on an outstanding event, and I enjoy that the content comes FIRST. Yes, the after-event parties and entertainment are first class, but I look forward most to sitting in on some excellent sessions. For Kscope12 one would expect Oracle to have a large presence, and you would be…

  Read the article

< Previous Page | 229 230 231 232 233 234 235 236 237 238 239 240  | Next Page >