On Thu, Mar 4, 2010 at 2:24 PM, Ken <ken.w.sm...@gmail.com> wrote:
> Thanks for your example, but whilst you're correct about Person.id not
> getting updated, all the other columns do get changed (even if it is
> to the same value).
>
> Here's my code...
>
> class TcsDetectionListsForm(forms.Form):
> name = forms.CharField()
>
> def candidateWithForm(request, tcs_transient_objects_id):
> detectionListRow = TcsDetectionLists.objects.get(pk=0)
>
>
if request.method == 'POST':
> form = TcsDetectionListsForm(request.POST)
> if form.is_valid(): # All validation rules pass
> detectionListRow.name = form.cleaned_data['name']
> detectionListRow.save()
> else:
> form = TcsDetectionListsForm(initial={'name':
> detectionListRow.name })
>
> Here's what happened in the database (from the DB log):
>
> 223592 Query UPDATE `tcs_detection_lists` SET `name` = 'rubbish',
> `description` = 'Bad Candidates' WHERE `tcs_detection_lists`.`id` = 0
>
> We shouldn't be updating the 'description' column. If my security
> settings were in place, this query would fail, because my DB user only
> has update access to the 'name' column.
>
TcsDetectionLists.objects.filter(pk=0).update('name'=form.cleaned_data['name'])
will produce an SQL UPDATE that only touches the name column.
Karen
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
