Caiorr
Posts: 8
|
| Posted: 06/20/2011, 10:44 PM |
|
Im trying to execute this command in a record page:
INSERT INTO Paginas(Nome, Tempo, ID_Formato, ID_Tema, ID_Usuario, Ordem) VALUES('{Nome}', {Tempo}, {ID_Formato}, {ID_Tema}, {Usuario}, {Expr0})
{Expr0} have to be LAST_INSERT_ID() function in Custom Insert Parameter Screen
I tryed all kind of combinations in Custom Insert Parameter Screen and nothing, can someone help?
http://www.neopubliq.com.br/temp/1.jpg
Tks
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 07/21/2011, 6:22 PM |
|
Caiorr,
Have you resolved this or do you still need assistance?
|
|
|
|
scarvello
Posts: 64
|
| Posted: 07/22/2011, 1:32 AM |
|
The value of mysql_insert_id() is affected only by statements issued
within the current client connection.
I'm not sure but may be that "Custom Insert" create a new connection.
You can try by building a stored procedure that insert the Master record and capture Last_Inserd_Id for the Detail record.
|
|
|
|
Caiorr
Posts: 8
|
| Posted: 07/22/2011, 6:59 AM |
|
I created a hidden control.
Before execute the insert, i change this control with mysql command.
Its not the best way, but it worked.
Now my real problem is something that i cant say, cause every time i try to post a question here, Yes Software delete it.
And im not alone in this problem, and maybe Yes Software will delete it again.
I can tell that this posture just confirm how they care about us (clients).
|
|
|
|
datadoit
|
| Posted: 07/22/2011, 7:08 AM |
|
It's possible that your messages may be getting deleted automatically
due to the content looking like some sort of SQL injection. Try posting
your questions/comments that include code snippets from the web
interface, and placing your code into the code tags (<code></code>).
|
|
|
|
Caiorr
Posts: 8
|
| Posted: 07/22/2011, 7:18 AM |
|
My question is about CCS u p d a t e s .... dont have codes...
|
|
|
|
CodeChargeMVP
Posts: 473
|
| Posted: 10/23/2011, 2:17 AM |
|
sometimes forum does some weird behaviour and this could happen.
_________________
Best Regards
Entrepeneur | NT Consultant
|
|
|
|
|
