Search Results

Search found 7884 results on 316 pages for 'ben record'.

Page 32/316 | < Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >

• in mysql table update 'a' record with 'b' and 'b' with 'a'

  - by chetan

  IN my table there are two field one is name and other is gender I want to fire query so that every male is update with female and vice a versa. I don't want to use procedure ,trigger or function.I have to do this only with simple query.

  Read the article

• How to find and update the next record in a linking table

  - by someoneinomaha

  I have a classifieds system I'm working on. People are able to add photos to a classified, but I only display one when displaying the list of classifieds. To do that, I have a linking table between classifieds and photos that has a "is_main" boolean field. When someone deletes one of their classified photos, I want to: 1) See if there is…

  Read the article

• Codeigniter - Active record - sql - complex join

  - by Jack

  I have a function that retrieves all tags from a table: function global_popular_tags() { $this->db->select('tags.*, COUNT(tags.id) AS count'); $this->db->from('tags'); $this->db->join('tags_to_work', 'tags.id = tags_to_work.tag_id'); $this->db->group_by('tags.id'); $this->db->order_by('count',…

  Read the article

• Random Record from Recordset

  - by Tony Hanks

  I have the fillowing Query: SELECT a.*, ps4_media.filename, ps4_galleries.name as galleryname, ps4_media_iptc.description, ps4_media_iptc.title, ps4_media_iptc.headline, ps4_media.date_added, ps4_galleries.created, ps4_folders.name as foldername, ps4_galleries.gallery_count FROM ps4_media_galleries a INNER JOIN (SELECT…

  Read the article

• How to know record has been updated successfully in php

  - by Lisa Ray

  $sql = "UPDATE...."; if(mysql_query($sql)) { $_SESSION['Trans']="COMMIT"; header("location:result.php"); exit; } else { $_SESSION['Trans']="FAIL"; $_SESSION['errors'] = "Error: Sorry! We are unable to update your Profile, Please contact to PNP…

  Read the article

• How to get mx records for a dns name with System.Net.DNS?

  - by Segfault

  Is there any built in method in the .NET library that will return all of the MX records for a given domain? I see how you get CNAMES, but not MX records.

  Read the article

• On saving a new record an associated id changes to 9 figure number

  - by Dave

  Hi, I have a table of venues, with each venue belonging to an area and a type. I recently dropped the table and added to it some addressline fields. I have re-migrated it but now the area_id field saves as a random? 9 figure number. Both the area_id and venuetype_id integers are created in the same way from the…

  Read the article

• 'Good' programming form in maintaining / updating / accessing files by entry

  - by zhermes

  Basic Question: If I'm storying/modifying data, should I access elements of a file by index hard-coded index, i.e. targetFile.getElement(5); via a hardcoded identifier (internally translated into index), i.e. target.getElementWithID("Desired Element"), or with some intermediate DESIRED_ELEMENT = 5; ...…

  Read the article

• zend form check record no exists in database

  - by Yafa Su

  I have a form that check if email exists in the database within 2 tables. I'm using Zend_Validate_Db_NoRecordExists for both validate, but it only check the second one. Any idea why it's not working? class Application_Form_ReferUser extends Zend_Form { public $email, $freeDownload, $buyNow; public…

  Read the article

• loading record into detailview

  - by summer

  please please i need help..i think i am lost somewhere..basically i followed the example http://www.iphonesdkarticles.com/2008/10/sqlite-tutorial-loading-data-as.html, but i was stuck with error on reading description..something must had gone wrong some well but i am not very sure how should i solve…

  Read the article

• Insert Statment with Case for avoid duplicate record insertion

  - by rama

  I have written the below SP for Precheck for Duplicate records before insert into Table . but it is not allow me yo write insert staement inside the CASE . how can I write Stored Procedure for fist Check the value @Ordername into table After that if it is not present then it should inserted into…

  Read the article

• SqlAlchemy hangs after adding record in MS SQL

  - by Patrick

  I'm running SQLAlchemy on Jython and trying to connect to a MS SQL database using jTDS with windows authentication. I can query and delete just fine but when I try to insert new values it will hang when I commit. int 'before add' session.add(newVal) print 'after add' session.commit() print…

  Read the article

• How do record updates behave internally?

  - by redxaxder

  data Thing = Thing {a :: Int, b :: Int, c :: Int, (...) , z :: Int} deriving Show foo = Thing 1 2 3 4 5 (...) 26 mkBar x = x { c = 30 } main = do print $ mkBar foo What is copied over when I mutate foo in this way? As opposed to mutating part of a structure directly. Data Thing = Thing…

  Read the article

• SQL Server 2008 - Get Latest Record from Joined Table

  - by user336786

  Hello, I have a SQL Server 2008 database. This database has two tables called Customer and Order. These tables are defined as follows: Customer -------- ID, First Name, Last Name Order ----- ID, CustomerID, Date, Description I am trying to write a query that returns all of the…

  Read the article

• Saving a Record with Rails Association

  - by tshauck

  Hi, I've been going through the Rails Guides, but have gotten stuck on associations after going through validations and migrations. So, I have the following models Job and Person, where a Person can have many jobs. I know that in reality there'd be a many-to-many, but I'm trying…

  Read the article

• Entityframework duplicate record on second insert

  - by Delysid

  I am building an application for recipe/meal planning, and i have come across a problem i cant seem to figure out. i have a table for units of measure, where i keep the used units in, i only want unique units in here (for grocery list calculation and so forth) but if i use a unit…

  Read the article

• why is Active Record firing extra query when I use Includes method to fetch data

  - by riddhi_agrawal

  I have the following model structure: class Group < ActiveRecord::Base has_many :group_products, :dependent => :destroy has_many :products, :through => :group_products end class Product < ActiveRecord::Base has_many :group_products, :dependent =>…

  Read the article

• DataSet.GetChanges - Save the updated record in a different table than the source one

  - by John Dev

  I'm doing operation on a dataset containing data from a sql table named Test_1 and then get the updated records using the DataSet.GetChanges(DataRowState.Modified) function. Then i try to save the dataset containing the updated records on a different table than the source one…

  Read the article

• dealing with a large flat data files with a very big record length

  - by gsp

  I have a large data file that is creatd from a shell script. Next script processes it by sorting and reading several times, that takes more than 14 hours, it is not viable. I want to replace this long running script with a program, probably in JAVA, C, or COBOl, that can run…

  Read the article

• What is Active Record - design pattern or module?

  - by piemesons

  Basically what's the difference between design pattern, module and some other terms we use.

  Read the article

• This query show me with this active record

  - by New Kid

  I am having trouble getting two tables and passing them to controller: IN A MODEL: function get_all_entries() { $query = $this->db->get('entry'); return $query->result(); $this->db->select('entry_id , count(comment_id) as total_comment'); …

  Read the article

• rails active record - Advanced find

  - by par

  I have the following model setup - a User is interested in projects in many project Categories. Each Project has many categories. Like so: class User has_many :projects has_and_belongs_to_many :project_categories class Project belongs_to :user …

  Read the article

• Concatenate multi value into one record.

  - by mikehjun

  I joined two tables together and what I like to do is concatenate multi vaule in one records without duplicated value. TAXLOT_ZONE TID ZONE 1 A 1 A 1 B 1 C 2 D 2 D 2 E 3 A 3 B 4 C 5 D Desirable Final…

  Read the article

• Row for each hour even if there is no record

  - by peku33

  I've got a trouble with creating mysql Query. My PHP script executes this query on each run: INSERT INTO Executes SET UserIp='%s' (%s is user IP) Executes table is: ExecuteId UNSIGNED BIGINT AI PRIMARY Date TIMESTAMP DEFAULT CURRENT_TIMESTAMP…

  Read the article

• google apps is setup on my server, how do i get php mail() to use it?

  - by Haroldo

  Hi, I've got google apps setup on my server with all the correct MX records etc, now i want to start testing it. I want to use it for all automated emails (registration, lost password etc). I'm testing on a localhost.

  Read the article

< Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >