This topic is locked

Illegal assignment

8/25/2006 9:17:46 AM
ASPRunnerPro General questions
B
bluecells author

Hello,
On BeforeUpdate, I run a query to trigger an email with all the values of the differents fields.
Here is the code:

message =""
keys = dict.keys

For n = 0 To dict.Count-1

message = message & keys(n) & " : " & dict(keys(n)) & vbcrlf

Next
email="my-email@chez.net"

subject="Ressource_update"
sendmail email, subject, message
BeforeAdd = True
but I keep on having this 501 error.

Could you please help me?
Thanks a lot

Jerome
----
Here is the detailed error message.
Technical information
Error number 501

Error description Illegal assignment
URL /translators/Ressources_admin_edit.asp
SQL query select [ID], [Ressource], [Company_name], [Photo], [Login], [Password], [Address], [Postal_code], [City], [Country], [Email], [Email2], [Phone], [Mobile], [Fax], [Web_site], [VAT_number], [P_Quality], [Internet_connection], [Secondary_school], [College_University], [Mother_tongue], [Year_Start], [Software_localization], [Average_capacity], [Field_of_expertise], [Sworn], [Sworn_language], [Sworn_court], [Bank_name], [IBAN], [P_Comment], [P_Agreement], [BIC], [PayPal], [more_info], [Skype_ID], [P_User_level], [Why_me], [Translation_team], [Active], [Status], [CAT1], [CAT2], [CAT3], [DTP1], [DTP2], [DTP3], [Preferred_payment] From [Ressources] where ([Ressources].[ID]=5)
Additional info Event: RetVal = BeforeEdit(dict, sWhere)

Sergey Kornilov admin 8/28/2006

Jerome,
please zip and send your files to support@xlinesoft.com for investigation.

R
rpeeks 7/30/2008

I just ran into the same error.
Problem: Copying over event code from BeforeAdd to BeforeEdit and not changing BeforeAdd = True to BeforeEdit = True .
Once I made that change, everything was fine...