Waspman
Posts: 948
|
| Posted: 03/14/2009, 4:50 AM |
|
Anybody got a solution for this that will handle hundreds of simultaneous users?
T
_________________
http://www.waspmedia.co.uk |
 |
 |
Gena
Posts: 591
|
| Posted: 03/19/2009, 4:21 AM |
|
what are you talking about?
_________________
Gena |
|
|
|
Waspman
Posts: 948
|
| Posted: 03/19/2009, 6:16 AM |
|
I want to populate a checkbox list with a many to many relationship, as the CCS example does.
However, the example says it's not suitable for large numbers of simultaneous users and I wonderd if anyone had found a solution?
Tony
_________________
http://www.waspmedia.co.uk |
|
|
|
Gena
Posts: 591
|
| Posted: 03/19/2009, 6:34 AM |
|
but what is "simultaneous users" and why is not suitable? where is a problem?
_________________
Gena |
|
|
|
Waspman
Posts: 948
|
| Posted: 03/19/2009, 6:56 AM |
|
It's this or am I not understanding it correctly?
if($Actions == "Insert"){
//Retrieve the last inserted key
//Use MS SQL method
//$GetLastInsKey = CCDLookup("@@IDENTITY","employees","",$DBIntranetDB);
//Use a method compatible with all databases (unsafe when multiple users insert records at the same time)
$GetLastInsKey = CCDLookup("max(emp_id)", "employees", "", $DBIntranetDB);
I say large numbers cos that would increase the chances of users inserting at the same time.
T
_________________
http://www.waspmedia.co.uk |
|
|
|
Gena
Posts: 591
|
| Posted: 03/19/2009, 7:05 AM |
|
Unsafe (and absolutely stupid) is to use sintax like
max(emp_id)  in multiusers environment
For MS SQL you need to use
'select @@identity'
and for mySQL
SELECT LAST_INSERT_ID() FROM table
_________________
Gena |
|
|
|
Waspman
Posts: 948
|
| Posted: 03/19/2009, 7:11 AM |
|
Thanks for that (I think) I'll give it a go...
No second thoughts, I don't understand. Can I pay you to mod the CCS code?
T
_________________
http://www.waspmedia.co.uk |
|
|
|
Waspman
Posts: 948
|
| Posted: 03/20/2009, 6:31 AM |
|
Anyone want to help sort the many to many issue that Gena mentioned?
_________________
http://www.waspmedia.co.uk |
|
|
|
Gena
Posts: 591
|
| Posted: 03/20/2009, 6:42 AM |
|
oops
why no. If you want you can send me *.ccp *.html and *.php file for that pages, all the files from "Styles/xxx/" directory too...
And your tables definition (sql dump scripts).
and describe what is your task.
look PM for my email
_________________
Gena |
|
|
|
