2. PHPRunner General questions
  3. Current User Problem
This topic is locked

Current User Problem

 		3/8/2006 12:17:37 PM
PHPRunner General questions
T
 Tommy B author

The current user's login ID should be captured in a read only format, which displays fine on the add page. However when I press submit to add the record, I get the following error.

Technical information

Error type 256

Error description Column 'UserID' specified twice
URL secure.healthclaimsplus.com/employee2/CCProcessing_add.php?

Error file /hhhh/dddddd/domains/xxxxxxx.com/private_html/secure/employee/include/dbconnection.php
Error line 26

SQL query insert into `CCProcessing` (`CurrentDate`, `NameOnCard`, `StreetAddress1`, `StreetAddress2`, `City`, `State`, `ZipCode`, `CardType`, `CardNumber`, `CCID`, `ExpirationMonth`, `ExpirationYear`, `PaymentAmount`, `NameofCaller`, `Relationship`, `AccountNumber`, `PatientName`, `Provider`, `UserID`, `Notes`, `UserID`) values ('2006-3-8', 'asda', 'dasdasd', 'asda', 'dsasd', 'DE', 'asd', 'American Express', 'asdas', NULL, 'Mar', '2010', 'asdas', 'dasd', 'asdasd', 'asdas', 'dasd', '63', 'wdbrents', 'adas', 'wdbrents')


I can see where it is trying to insert "UserID" twice in the SQL, but I can't figure out why this is happening. It is only one field in the database and it is listed in the PHPRunner GUI once.
Any suggestions?
Sergey Kornilov admin 3/8/2006

I guess you use Users can see and edit their own data only security mode choosing UserID field as OwnerID. In this case you need to remove UserID from the Add page because it will filled with correct value automatically.
T
 		Tommy B author 3/9/2006

Thanks Sergey. This was the case, and taking the steps you described solved the problem.