Okay!! My bad.. was using the wrong function to fetch. Use fetchone() instead.
On Tuesday, 1 May 2012 07:22:11 UTC+5:30, Aditya Sriram M wrote: > > > I have been trying a lot but could not make out why it happens, > > class FortressUserAdmin(admin.ModelAdmin): > list_display(. . . , get_my_schema) > def get_my_schema(self, obj): > sql_query = "select prop_val from customer_property where customer_id = > %d and property_value like '%%%%SCHEMA%%%%'" % obj.customer_id.customer_id > property_value = connection.cursor().execute(sql_query).fetch_one() > > print sql_query > return 1 > # return "aditya" > get_my_schema.short_description = 'Schema Instance' > > > - why the column values are always (None) > - why the print 1 or print 'aditya' won't print anything to the console > > Screen shot of the column admin site: [image: enter image description > here] > -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/VYyulm2657MJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
