Buy Now
Sign in

auto detect doesnt work

samir1903 , April 23 2019, 20:55
S
samir1903 178
April 23 2019, 20:55 #386222
I have tried all type of write action but doesnt give what i am looking for
i put update where condition aid=student_no
what i am looking for is if this student no exist update if not insert
after there is insert update and all other sections exists, dont tell me use switch or php
healyhatman 8
April 24 2019, 05:47 #386231
Auto detect works off of the primary key. If you're having trouble what you can do is have a read data action looking for the record to update. If it's found, have a save data action set to update. If it's not found, have one set to insert.
Can also try the "Insert - on duplicate key update"
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
admin 27
April 24 2019, 09:47 #386263
 1
"Insert - on duplicate key update" will do what you need!
Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
S
samir1903 178
April 24 2019, 13:20 #386274
insert on update doesnt work
i have read aid:student_no
then form data provider is this db read
then i have module Student[name].........
then when i say db save what ever you say doesnt work
even when i open text puts comes loaded with new student page whit your suggestion
admin 27
April 24 2019, 20:31 #386282
What is the debug result of the "save data" ?
Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!