Not really sure why this isn’t working. I’ve mirrored this webpage from a friend’s page – everything is literally identical, save for the references to the databases. His works, and mine doesn’t. Here’s an example of one of the tables I’m trying to sort:
…

Hello everyone,

I have a pdf file in which there are about 1700 pages each page contains about 7 records and each record contains the following data:

company_name,
address_line_1,
address_line_2,
telephone,
fax,
email,

I have started working on ADF and can anybody inform me in ADF how can i insert data in multiple table if they have foreign key,please?

Thnak you very much.

Given a list of tables and a user ID with valid access rights the program will log into the front end of Oracle ERP and download the back end tables requested I need to be able to call the program from C … Required Skills: Oracle ERP , Programming

Hi something is not working right with my code!!! what it is sopposed to do is (1) reads a list of integers from a file, (2) prints the maximum value in the list to the console, and (3) removes the maximum value from the list, and stores the (smaller) list back to the file.) The problem is i am…

Hello,

I have two tables with the same structure, and both contain an ID field of auto_increment.
I would like to move a row from one table to the other.

I know I can use:

INSERT INTO `new_table` VALUES (SELECT * FROM `old_table`)

But that way the ID in new_table will receive the ID of old_table. So I would basically want to copy all fields except for the ID, which needs to get the auto_increment value of new_table. How can I do that?

Thanks!

Joel

Hi all,

I have 2 polymorphic associations through which I need to query.

I have a news_article table which has a polymorphic association to teams, players, etc. Those teams, players, etc have a polymorphic association to photos through phototenic.

I need to find all articles that have at least one picture that is 500px wide.

The Article model I have a has_many :teams (through the polymorphic table)
and in the teams I have a has_many :photos (though another polymorphic table)

I thought that I could use joins like this

Article.find(:last, :joins => {:teams => :photos}, :conditions => “photos.aspect_ratio < 1.55 AND photos.aspect_ratio > 1.30″)

but it is not working. Any ideas?

What is the best way to define a method signature when you have to pass many values to a function and some of these may be optional. And in future, May be I have to pass more variables or subtract some passed values given to function.

For example: (phone and address are optional)

function addInfo( $name, $dob, $phone='', $address='' ) {
       // Store data
}

addInfo( 'username', '01-01-2000', '1111111' ); // address is not given

OR

function addInfo( $info ) {
    // Store data
}

$info = array( 'name'=>'username',
               'dob'=>'01-01-2000',
               'phone'=>'1111111',
               'address'=>'' );
addInfo( $info );