Please find below the properly indented code. However pdb stack trace
doesn't seem to be of much use in this case. In this code the view is
working properly if the table name is NOT 'Master'. If the table name
turns out to be 'Master' the value error is displayed.
def dbout(request):
try:
filter_string= request.GET.get('filter_string', '')
table_name=request.GET.get('table_name','')
field_name=request.GET.get('field_name','')
if table_name=='Master':
if field_name=='hostid':
results=eval(table_name).objects.filter
(hostid__icontains=str(filter_string)).values()
elif field_name=='plat_manu_name':
results=eval(table_name).objects.filter
(plat_manu_name__icontains=str(filter_string)).values()
elif field_name=='hostname':
results=eval(table_name).objects.filter
(hostname__icontains=str(filter_string)).values()
elif field_name=='mac':
results=eval(table_name).objects.filter
(mac__icontains=str(filter_string)).values()
return HttpResponse(Template(open("/TCDB/
masterout.html").read()).render(Context({'results':results})))
else:
if field_name=='hostid':
results=eval(table_name).objects.filter
(hostid__icontains=str(filter_string)).values()
elif field_name=='hostname':
results=eval(table_name).objects.filter
(hostname__icontains=str(filter_string)).values()
elif field_name=='date_entered':
results=eval(table_name).objects.filter
(date_entered__icontains=str(filter_string)).values()
elif field_name=='sysfw_ver':
results=eval(table_name).objects.filter
(sysfw_ver__icontains=str(filter_string)).values()
elif field_name=='sysfw_bld':
results=eval(table_name).objects.filter
(sysfw_bld__icontains=str(filter_string)).values()
elif field_name=='os_ver':
results=eval(table_name).objects.filter
(os_ver__icontains=str(filter_string)).values()
elif field_name=='os_bld':
results=eval(table_name).objects.filter
(os_bld__icontains=str(filter_string)).values()
elif field_name=='sunvts_ver':
results=eval(table_name).objects.filter
(sunvts_ver__icontains=str(filter_string)).values()
elif field_name=='sunvts_bld':
results=eval(table_name).objects.filter
(sunvts_bld__icontains=str(filter_string)).values()
elif field_name=='test_info':
results=eval(table_name).objects.filter
(test_info__icontains=str(filter_string)).values()
return HttpResponse(Template(open("/TCDB/
configout.html").read()).render(Context({'results':results})))
except:
pass
On Jan 27, 8:22 pm, Karen Tracey <kmtra...@gmail.com> wrote:
> On Wed, Jan 27, 2010 at 10:02 AM, Malcolm Box <malcolm....@gmail.com> wrote:
> > It was indented if you looked in the original message text - I suspect your
> > (and my) default email program is stripping leading spaces.
>
> How odd. Looking at it in Gmail one space has been removed from the front
> of all lines that had more than one leading space. Looking at it on the
> Google Groups page the indentation is legal (if extremely hard to see
> properly) Python. Another email client I use also shows it correctly. I've
> not noticed Gmail doing that before.
>
> 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.
