from django import forms

class DateTimeForm(forms.Form):
	last_date = forms.DateTimeField()

from myapp.forms import DateTimeForm
from myapp.models import Message
from django.http import HttpResponseRedirect
from django.shortcuts import render_to_response

def do_form_stuff(request):
	if request.method == 'POST':
		date_time_form = DateTimeForm(request.POST)
		if date_time_form.is_valid():
			new_messages = Message.objects.filter(when__gte=date_time_form.cleaned_data['last_date'])
			# do stuff with new_messages
			return HttpResponseRedirect('somewhere')
	else:
		date_time_form = DateTimeForm()
	
	return render_to_response('sometemplate.html', 
	  {'form': date_time_form},
	  context_instance=RequestContext(request)
	)

Lamacq fucked around with this message at 20:06 on Oct 13, 2010

SlightlyMadman fucked around with this message at 16:59 on Oct 19, 2010

duck monster fucked around with this message at 01:45 on Nov 2, 2010

OperationalError: (1305, 'PROCEDURE myapp.LatLonDistance does not exist')

cursor = connection.cursor()
result = cursor.callproc("myapp.LatLonDistance", (lat1, lon1, lat2, lon2))
cursor.close()

SELECT id,myapp.LatLonDistance(lat1, lon1, lat2, lon2) AS distance FROM myapp.users_userprofile;

delimiter //
CREATE FUNCTION airrun.LatLonDistance (lat1 double, lon1 double, lat2 double, lon2 double)
RETURNS double
DETERMINISTIC
READS SQL DATA
BEGIN
	
		DECLARE theta double;
		DECLARE dist double;
		DECLARE miles double;
		SET theta = lon1 - lon2; 
		SET dist = SIN(RADIANS(lat1)) * SIN(RADIANS(lat2)) + COS(RADIANS(lat1)) * COS(RADIANS(lat2)) * COS(RADIANS(theta)); 
		SET dist = ACOS(dist); 
		SET dist = DEGREES(dist); 
		SET miles = dist * 60 * 1.1515;
	
		
		RETURN miles;
END
//
delimiter ;

Ferg fucked around with this message at 21:24 on Nov 17, 2010