This topic is locked

Multiple records

1/21/2010 6:08:57 AM
PHPRunner General questions
M
mauro author

It's possible something like this in image.....add multiple rows in a form?
http://yfrog.com/3utestrg

J
Jane 1/21/2010

Hi,
yes it's possible. Add aliases on the Edit SQL querytab for this purpose:

select field1,

field1 as field1_new,

field2,

field2 as field2_new,

...

from Tablename



Then process these fields (field1_new and field2_new) in the Before record added event and remove it from main update query.

M
mauro author 1/22/2010

....Uhm...i'd like have a button (add new rows) to add new rows but these fields: field1, field1_new, field2_new, can have different values.

It's possible use different values with alias? i think no....i think <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=47101&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Can you help me?

Tnx <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=47101&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=47101&image=3&table=forumreplies' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=47101&image=4&table=forumreplies' class='bbc_emoticon' alt=':)' />

J
Jane 1/22/2010

Mauro,
yes you can have different values in these dummy fields.

But you need to process these fields manually in the Before record added event and remove it from main update query.

M
mauro author 1/22/2010

can i have an example <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=47114&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />