Search found 159 matches

by daviddelmonte
Mar 14th, '11, 14:00
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement

Hi, thanks for the info. I ended up using this: $last_id = mysql_insert_id(); //echo $last_id; //checks value of last_id $name= "UPDATE verbs,person SET person.verb_name=verbs.`name` WHERE person.verb_id=verbs.verb_id AND person.person_id=$last_id;"; $result=mysql_query($name); if ($result...
by daviddelmonte
Mar 13th, '11, 10:16
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement

I should have replied earlier. I did try dform of course, but I get this error: Fatal error: Call to undefined method DataForm::GetCurrentId() code line is just after the bind, and is simply: $dform->Bind(); $dform->GetCurrentId(); what have I missed? I cannot find documentation on GetCurrentID Seco...
by daviddelmonte
Mar 10th, '11, 17:05
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement

administrator wrote:If you need to update only current record, use $dgrid->GetCurrentId()


Thanks.. But do you mean $dform?
by daviddelmonte
Mar 10th, '11, 14:51
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement - SOLVED - Sort of

OK, I have a workaround. I have this code for the field: "verb_name" =>array("header"=>"", "type"=>"hidden", "req_type"=>"ry", "default" => $name), and this for the SQL: $name= "UPDATE verbs,person SET person.verb_n...
by daviddelmonte
Mar 8th, '11, 12:04
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement

I'm sorry I'm still stuck. I have tried these SQL statements: $name = "UPDATE person SET person.verb_name = verbs.name"; $name = "SELECT verbs.verb_id, verbs.name FROM verbs"; Then I've tried calling the sql in here: ## *** set data source $dform->DataSource($db_conn, $name); and...
by daviddelmonte
Mar 7th, '11, 19:28
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement

Hi, could you look at this again please.. If I use type => hidden, how do I populate the value with a field from another table?

Thanks
by daviddelmonte
Mar 7th, '11, 12:57
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Re: Adding another SQL statement

I thought I had it but I dont. I have this: // PERSONS.VERB_NAME "verb_name" =>array("header"=>"", "type"=>"hidden","req_type"=>"st", "title"=>"", "readonly"=>"false", "maxlength"=...
by daviddelmonte
Mar 6th, '11, 20:39
Forum: ApPHP DataForm
Topic: Adding another SQL statement
Replies: 14
Views: 8502

Adding another SQL statement

I have a field that I do not want to appear on a form, but want it added to the form's table. I have an SQL command: UPDATE table2 SET field_a= table1.field_a; I think this will do it. I don't know if I can add a command like this in dataForms. Can you let me know a) if I'm doing this correctly and ...
by daviddelmonte
Mar 6th, '11, 12:56
Forum: Field type: "link"
Topic: How to make a link on the Add function
Replies: 3
Views: 4012

Re: How to make a link on the Add function

Sorry to be thick.

1. Is the modes section, the correct place o invoke the button?

2. Can you give a one-line code example..

Thanks
by daviddelmonte
Mar 4th, '11, 04:43
Forum: Field type: "link"
Topic: How to make a link on the Add function
Replies: 3
Views: 4012

How to make a link on the Add function

Hi, I am making progress with my project. I would like to know if there is a way that when the user selects "Add new" that I can direct them to a different web page - that is made by DataForm. It from this code that I'd like the link: $modes = array( "add" =>array("view"...

Go to advanced search