Search Results

Search found 6852 results on 275 pages for 'ptr record'.

Page 53/275 | < Previous Page | 49 50 51 52 53 54 55 56 57 58 59 60  | Next Page >

• My Linq to Sql Insert code seems to work fine but I don't get a record in the database

  - by Alex

  Here is my code. In the debugger, I can see that the code is running. No errors are thrown. But, when I go back to the table, no row has been inserted. What am I missing?? protected void submitButton_Click(object sender, EventArgs e) { CfdDataClassesDataContext db = new CfdDataClassesDataContext(); string sOfficeSought =…

  Read the article

• How to block the possibility to add the same record to a SPList?

  - by truthseeker

  Hi, Is there a possibility to block chance to add the same data to SPList? I know that two records always are different regarding the ID field. I would like to validate other custom fields added previously by me, and don't allow of adding same field's value. Can anybody tell me how to implement this? I can guess that event…

  Read the article

• How to do an additional search on archive in rails if record not found, by extending model?

  - by Nick Gorbikoff

  Hello, I was wondering if somebody knows an elegant solution to the following: Suppose I have a table that holds orders, with a bunch of data. So I'm at 1M records, and searches begin to take time. So I want to speed it up by archiving some data that is more than 3 years old - saving it into a table called…

  Read the article

• Fetching a random record from the Google App Engine Datastore?

  - by demos

  I have a datastore with around 1,000,000 entities in a model. I want to fetch 10 random entities from this. I am not sure how to do this? can someone help?

  Read the article

• Is it possible to use SQL XML to insert, and get output from each record?

  - by nbolton

  I would like to perform a SQL XML insert (on MSSQL), and in this case I need to insert a list of files into the DB (this is simple enough). However, there's an auto generated PK column (ID), and I need the ID for each newly created filename without performing a 2nd query. Is this possible? I guess it doesn't…

  Read the article

• Active Record Associations: has_one :through? Or multiple has_one's?

  - by jmccartie

  I'm brand new to Rails, so bear with me. I have 3 models: User, Section, and Tick. Each section is created by a user. My guess with this association: class Section < ActiveRecord::Base has_one :user end Next, each user can "tick" off a section -- only once. So for each tick, I have a section_id,…

  Read the article

• rails 3, active record: any way to tell how many unique values match a "x LIKE ?" query

  - by jpwynn

  I have a query to find all the phone numbers that match a partial expression such as "ends with 234" @matchingphones = Calls.find :all, :conditions => [ "(thephonenumber LIKE ?)", "%234"] The same phone number might be in the database several times, and so might be returned multiple times by this…

  Read the article

• How does object of sub-class record information about its super-class the in a Virtual Inheritance

  - by Summer_More_More_Tea

  Hi there: I encounter this problem when tackling with virtual inheritance. I remember that in a non-virtual inheritance hierarchy, object of sub-class hold an object of its direct super-class. What about virtual inheritance? In this situation, does object of sub-class hold an object of its super-class…

  Read the article

• Should nested attributes be automatically deleted when I delete the parent record?

  - by brad

  I'm playing around with nested forms in attributes and have a model Invoice that has_many invoice_phone_numbers. I have the following line in my invoice.rb model file accepts_nested_attributes_for :invoice_phone_numbers, :allow_destroy => true, :reject_if => proc { |attrs| attrs.all? { |k, v|…

  Read the article

• how to display the list of records in the same form page below form, as every time record is submitt

  - by OM The Eternity

  I have a form with 3 text values and one image.. I want to save these values such that i can display these records in the list below.. hoe can i do that... I am using osCommerce

  Read the article

• How can I get FOUND_ROW()s from an active record object in rails?

  - by Justin Tanner

  When querying the database with: @robots = Robot.all(:limit => 50, :offset => 0) What is the best way to get the total number of rows without the :limit? In raw MySQL you could do something like this: SELECT SQL_CALC_FOUND_ROWS * FROM robots LIMIT 0, 50 SELECT FOUND_ROWS();

  Read the article

• How do I select a random record efficiently in MySQL?

  - by user198729

  mysql> EXPLAIN SELECT * FROM urls ORDER BY RAND() LIMIT 1; +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |…

  Read the article

• How to fetch a random record from SQLite database?

  - by Bruce

  I am working on PHP. I was working with MySQL before. Here is the code I used - $offset_result = mysqli_query($con, " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM students "); $offset_row = mysqli_fetch_object( $offset_result ); $offset = $offset_row->offset; $result =…

  Read the article

• How do I return the IDENTITY for an inserted record from a stored Proecedure?

  - by user54197

  I am adding data to my database, but would like to retrieve the UnitID that is Auto generated. using (SqlConnection connect = new SqlConnection(connections)) { SqlCommand command = new SqlCommand("ContactInfo_Add", connect); command.Parameters.Add(new SqlParameter("name",…

  Read the article

• Set to null a parent record so that children are removed: howto?

  - by EugeneP

  How to delete a child row (on delete cascade ?) when setting a null value on a parent? Here's the db design. table A [id, b_id_1, b_id_2] table B [id, other fields...] b_id_1 and b_id_2 can be NULL if any of them is null, it means NO B records for corresponding FK…

  Read the article

• What's the easiest and safest way to record data being inputted by a user on a web site

  - by fred august

  Apologies, this is a tragically simple question that will bore most of you. I need to implement the simplest "leave your email and we'll contact you" web page. The simplest thing I could think of is doing an HTML form which calls a PHP script which appends the data in…

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't…

  Read the article

• How to get only one record for each duplicate rows of the id in oracle?

  - by Psychocryo

  suppose i have this table: group_id | image | image_id | ----------------------------- 23 blob 1 23 blob 2 23 blob 3 21 blob 4 21 blob 5 25 blob 6 25 blob 7 how to get…

  Read the article

• Rails - HABTM Relationship -- How Can I Find A Record Based On An Attribute Of The Associated Model

  - by ChrisWesAllen

  I have setup this HABTM relationship in the past and its worked before....Now it isnt and I'm at my wits end trying to figure out whats wrong. I've looking through the rails guides all day and cant seem to figure out what I'm doing wrong, so help would really…

  Read the article

• HOw do I delete record in a table by keeping certain datas??

  - by mathew

  my site has lots of incoming searches which is stored in a database to show recent queries into my website. due to high search queries my database is getting bigger in size. so what I want is I need to keep only recent queries in database say 10 records. this…

  Read the article

• How do I check whether the table has a record with a primary key values?

  - by KIM

  I have a exception to prevent inserting same records on my oracle. I've haerd that COUNT(*) has lots of cost which I don't want to use. Is there any alternative way to make it at least cost?

  Read the article

• How do I display the record count of a related model with CakePHP?

  - by Josh Brown

  I have two models. Lets say they are "Posts" and "Comments". In an admin view for Posts, I want to display how many comments are on that post. I am confused on where to put the code. In the controller or the view? I would like it to be in the controller.

  Read the article

• In Django, using __init__() method of non-abstract parent model to record class name of child model

  - by k-g-f

  In my Django project, I have a non-abstract parent model defined as follows: class Parent(models.Model): classType = models.CharField(editable=False,max_length=50) and, say, two children models defined as follows: class ChildA(Parent): parent =…

  Read the article

• :from parameter in active record find not well designed?

  - by potlee

  i got this error: SQLite3::SQLException: no such column: apis.name: SELECT * FROM examples WHERE ("apis"."name" = 'deep') my code Api.find :all, :from => params[:table_name], :conditions => {:name => 'deep' } I need to make a back end…

  Read the article

• How do I compare 2 fields and return the lowest value of each record?

  - by BigRob

  I'm slowly learning access to make a database of products and suppliers for my parents' business. What i've got is a table of products indexed by our product reference and 2 more tables for 2 different suppliers that contains the suppliers product…

  Read the article

< Previous Page | 49 50 51 52 53 54 55 56 57 58 59 60  | Next Page >