Re: Unique Case Sensitivity

2008-07-16 Thread Peter Melvyn
On Wed, Jul 16, 2008 at 3:06 AM, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > I strongly suspect that the problem here is MySQL - in particular, the > collation on your text field. There are certain default setups for > MySQL which will result in all text fields being case insensitive. >

Re: syncdb

2008-07-05 Thread Peter Melvyn
On 7/5/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks a lot!! I am used to rails. Hopefully django will have some > sort of db migrate ability in the future. Django has a separated project http://code.google.com/p/django-evolution/ for such task Peter

Re: HTML Email

2008-07-03 Thread Peter Melvyn
On 7/3/08, Bobby Roberts <[EMAIL PROTECTED]> wrote: > is there a way in Django to send an actual HTML email? I can only get > it to send as an attachment to a text email which is really pointless > in my opinion. Did you read paragraph "Sending alternative content types" in

Re: Some Django unit tests fail...

2008-06-24 Thread Peter Melvyn
> On Fri, Jun 20, 2008 at 1:07 AM, Peter Melvyn <[EMAIL PROTECTED]> wrote: > > Yes, it is the intention. If Django requires test database with > > charset UTF8, IMHO it should create it using related clause. as well > > as proper engine should be choosen

Re: How best to delete one of multiple records?

2008-06-23 Thread Peter Melvyn
On 6/23/08, Emil Styrke <[EMAIL PROTECTED]> wrote: > Having a GET request delete records is usually a bad idea - see for example > http://www.w3.org/2001/tag/doc/whenToUseGet.html Yes, this is a recommendation, not a dogma. IMHO GET method is suitable for dense tables with dozens of operations.

Re: How best to delete one of multiple records?

2008-06-23 Thread Peter Melvyn
> I have a list of records, and I'd like the user to be able to delete > any given record by pressing a button. IMHO there are two basic solutions: 1. each record has column with hyperlink to delete action (ID is part of URL) You can use plain text or image mapped links 2. each record has

Re: Any suggestions on encryption methodology?

2008-06-23 Thread Peter Melvyn
On 6/23/08, Tye <[EMAIL PROTECTED]> wrote: > When the user hits submit, I want the SSN to be encrypted, stored in a > database (encrypted), read from a database (encrypted) by a secure, > authorized & authenticated connection, and decrypted somewhere along > the end of the line for

Re: Any suggestions on encryption methodology?

2008-06-23 Thread Peter Melvyn
On 6/23/08, Tye <[EMAIL PROTECTED]> wrote: > Say - for the sake of example - I'm accepting highly sensitive > financial data through a form over SSL. > > Staff members need to retrieve that information at a later time. > > Meanwhile, I want that data to be encrypted while it's sitting in the

Re: flatpage for 404

2008-06-21 Thread Peter Melvyn
On 6/21/08, mark <[EMAIL PROTECTED]> wrote: > I do not like the django default behaviour for 404 pages since I do > not want to create a 404.html template. I like my flatpages a lot > especially the default.html template I created earlier. Therefore I > would like django to use my

Re: email this page

2008-06-21 Thread Peter Melvyn
On 6/20/08, Support Desk <[EMAIL PROTECTED]> wrote: > submit button. That will send an email containing all the rendered > information. If *all* should mean that you want to send HTML in-line message including related media (images), you have to: 1. compose MIME message having subparts as

Re: Some Django unit tests fail...

2008-06-19 Thread Peter Melvyn
On 6/19/08, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > The only obvious thing I can glean from your stack traces is a > possible language problem - the last stack trace is complaining of a > collation mix, which suggests that your MySQL install isn't using utf8 > all the time. Yes, it

Some Django unit tests fail...

2008-06-19 Thread Peter Melvyn
Hi all, I wanted to make sure that all unit tests will pass after #3030 fix and run Django unit tests on trunk updated to r7703 on Windows, Python 2.4 and MySQL 5.0.37. But I found that some test failes: 1. If I've run all tests, I get error: Traceback (most recent call last): File

Re: Why PostgreSQL?

2008-06-19 Thread Peter Melvyn
On 6/19/08, AmanKow <[EMAIL PROTECTED]> wrote: > Absolutely. I am not pointing fingers, but throwing my two cents into > the answer to "Why PostgresSQL?" I think, given the current state of > MySQL, the problems I outlined are very strong arguments for using > postgres instead of mysql

Re: redirect with post parameters

2008-06-17 Thread Peter Melvyn
On 6/17/08, MarcoX <[EMAIL PROTECTED]> wrote: > I tried with httplib e urllib but with no results Technically, a redirection represents to return result code 301 or 302 and set field Location in the HTTP response header to absolute URL. HTTP Client then issue a new HTTP request to this

Re: Django HTML Editor

2008-06-14 Thread Peter Melvyn
> I want a free HTML editor that is compatible with Django template's > syntax. I just want to edit my Django power application's HTML faster. > When I say compatible, I mean that the editor shouldn't screw up all > the Django template's tags and variables. If you are on Windows, you can try

Re: truncate in mysql database

2008-06-11 Thread Peter Melvyn
On 6/11/08, Frédéric Degraeve <[EMAIL PROTECTED]> wrote: > I use often 'delete' on my tables. I would like to reset everytime the > auto_increment field. Is it possible to use 'truncate' with django > orm? AFAIK not. But you can run custom SQL

Re: undetermined behaviour of manage.py

2008-05-11 Thread Peter Melvyn
On 5/11/08, phactor <[EMAIL PROTECTED]> wrote: > no keyword REFERENCES. Where is it? AFAIK, SQLite engine 'per se' does not support reference integrity, see: - http://www.sqlite.org/lang_createtable.html - http://www.sqlite.org/omitted.html HTH, Peter

Re: Javascript GUI Editor that works with Django templates

2008-04-22 Thread Peter Melvyn
> Since Opera is used by a very very small percentage of web users, > I don't think it would be a major problem in most use cases. My experience says the well behaved applications runs on IS6+, FF2+, Safari3+ and Opera9+ --~--~-~--~~~---~--~~ You received this

Re: Paginator Help

2008-04-22 Thread Peter Melvyn
On 4/21/08, DuncanM <[EMAIL PROTECTED]> wrote: > Please could someone have a look through and see what I'm missing? I'm not a Django skilled user, but I use the similiar pagination and what I see at glance is, that you mix paginator's template with view's template. ### Paginator is inclusion

Re: DateField widget, ModelForm and javascript

2008-04-22 Thread Peter Melvyn
On 4/21/08, Rishabh Manocha <[EMAIL PROTECTED]> wrote: > I'd be interested in knowing how to get it to show up too (what JS/CSS > files need to be added, whether there is some setting we can use in > the python code itself or do we have to print out each field > independently and insert the

Re: Javascript GUI Editor that works with Django templates

2008-04-21 Thread Peter Melvyn
> My favorite is FCKeditor. Its formatting of source code is really > clean and semantic. I have come to hate TinyMCE because it jumbles > source code and uses too many tags at times. Try it out, you may like > it a lot. I've tried it and it seems it does not work with Opera...

Troubles with JavaScript localization

2008-04-11 Thread Peter Melvyn
Hi all, perhaps I've missed something important in my very-beginning with Django, because I encouter a problems with JavaScript localization. 1. I serve .js as a static files directly by Apache, so they reside on MEDIA_ROOT out of project/apps folder tree -> I cannot build message

Re: Error with database encoding in UTF8

2008-03-27 Thread Peter Melvyn
On 3/26/08, Karen Tracey <[EMAIL PROTECTED]> wrote: > you have told MySQL that the data is utf8-encoded. I believe there is a way > (described in the MySQL doc page I cited above) to globally change your > MySQL config so it will expect/supply utf8 instead of latin1, so you might > want to look

Re: Troubles with exceptions having localized text in debug.technical_500_response exception

2008-01-09 Thread Peter Melvyn
On 1/10/08, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > It's a bug. Please open a ticket about it, so we don't forget. Thank you for your help. Done. http://code.djangoproject.com/ticket/6353 Peter --~--~-~--~~~---~--~~ You received this message because

Troubles with exceptions having localized text in debug.technical_500_response exception

2008-01-09 Thread Peter Melvyn
Hi all, I raise an exception with localized text, e.g. raise XXXInternalException, ugettext('_XXX_ERROR_...') % (...) If I catch such exception and handle it in my view, everything is OK. But if I do not catch such exception and it continues until caught in base.get_response() function,

Re: Populating a form

2007-09-13 Thread Peter Melvyn
On 9/13/07, MikeHowarth <[EMAIL PROTECTED]> wrote: > Look at form_for_instance in newforms: I am not sure if it could help me. I try to demostrate my problem on the view fragment handling post request: form = MyHTMLForm(request.POST) if not form.is_valid(): # will render bound form else:

Re: Populating a form

2007-09-13 Thread Peter Melvyn
On 9/11/07, Ole Laursen <[EMAIL PROTECTED]> wrote: > You can also use the initial parameter when instantiating the form: And how to solve situation when you've processed posted data and in the next step you need to redisplay the same form with some values reset to initial values? Peter

Re: When 1.0 ?

2007-09-11 Thread Peter Melvyn
On 9/10/07, est <[EMAIL PROTECTED]> wrote: > Hi I am a new web developer in django. Could anyone tell me when will > django go to 1.0? Will django support py3k? Is django worth learning > compared with other web frameworks like turbogears, RoR? At the end of thread bellow are opinions I tend

Re: newforms and DateField

2007-09-01 Thread Peter Melvyn
On 8/31/07, picky <[EMAIL PROTECTED]> wrote: > I try to create a form with forms.form_for_model but I just get a text > widget for my DateField object. I did not try it yet, but in principle, you should set class attribute of corresponding widget to vDateField and include related JavaScripts

Re: unique_together and composite columns indexing

2007-08-30 Thread Peter Melvyn
On 8/30/07, Peter Melvyn <[EMAIL PROTECTED]> wrote: > 2.a If I let MySQL to explain a select command from such table, there is no >composite index listed > 2.a If I create a composite index by explicit command, it is listed by explain >command among avai

Re: unique_together and composite columns indexing

2007-08-30 Thread Peter Melvyn
On 8/30/07, Nis Jørgensen <[EMAIL PROTECTED]> wrote: > > CREATE INDEX `xxx_amodel_col_a_col_b` > >ON `wss_amodel` (`col_a`,`col_b`); > > Postgresql will implicitly generate this index when it encounters the > UNIQUE constraint. My guess is that other backends will do the same. Are you sure?

Max. size of User.email is 75 chars

2007-08-29 Thread Peter Melvyn
Hi all, I've a question, why max. size of User.email field is set to 75 characters, if RFC 2821 limits local part to 64 characters and domain to 255. With '@' it is together 320 chars. Should not be this field extended? Peter --~--~-~--~~~---~--~~ You received

Re: Django 1 debugging in pydev with breakpoints

2007-08-29 Thread Peter Melvyn
On 8/29/07, Rufman <[EMAIL PROTECTED]> wrote: > does anyone have an idea how i can set breakpoint while debugging in > pydev. i got the dev server to work from inside eclipse but breakpoint > don't seem to work. You need to configure and run dev server first (F9), then break its execution using

Re: Validation problem with newforms and initial value for URLField

2007-08-26 Thread Peter Melvyn
On 8/26/07, Shev <[EMAIL PROTECTED]> wrote: > But neither should an initial field value raise an error when > the POSTed data is exactly the same as the starting value; > it should just be ignored and the value discarded. Even if you supply a valid inital value? It does not sound well for me...

Re: Injecting validation errors into newforms

2007-08-25 Thread Peter Melvyn
On 8/24/07, Kirk Strauser <[EMAIL PROTECTED]> wrote: > problem I'm running into is that I'd really, really like to be able to > associate errors from the form.clean() stage of validation with the fields > that are actually having problems. To assign a single message, I use following assignment:

Is there a way how to modify value of particular field in bound new form

2007-08-23 Thread Peter Melvyn
Hi all, I'd like to clear values of some fields in the bound form before I'll render a page again, by I'm not able achieve this. Please, could anybody advice how to do it? Thank in advance Peter --~--~-~--~~~---~--~~ You received this message because you are

Re: insert or update

2007-08-21 Thread Peter Melvyn
On 8/21/07, George Vilches <[EMAIL PROTECTED]> wrote: > or in the mailing list saying that you would use this > functionality for such and such a reason. OK, I'll specify the reason We use web as administrative/configuration tool for non-web based back-office server and we need to synchronize

Re: insert or update

2007-08-21 Thread Peter Melvyn
On 8/21/07, George Vilches <[EMAIL PROTECTED]> wrote: > http://code.djangoproject.com/ticket/4879 > If you need that functionality, add a vote for it. :) Yes, I need such functionality :) Peter --~--~-~--~~~---~--~~ You received this message because you are

Re: Apache does not serve static files from document root

2007-08-20 Thread Peter Melvyn
On 8/20/07, Graham Dumpleton <[EMAIL PROTECTED]> wrote: > Have you read the mod_python documentation on Django site? It gives an > example, which modified for your case would be: > > > SetHandler None > > > The important bit is the SetHandler directive. Have you done that? Yes, I did.

Re: Apache does not serve static files from document root

2007-08-20 Thread Peter Melvyn
On 8/20/07, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > Not really Django related, so I'll do this briefly... Yes, I know. I appreciate your prompt reply. Thanks. > In this case you'll probably want to add another Location section before > this one to handle things to WWW-ROOT/bizweb

unique_together and composite columns indexing

2007-08-18 Thread Peter Melvyn
Hi all, if I'm not mistaken, if I have a model with unique constraint 'unique_together', Django does not support composite index of related columns, i.e. class AModel (models.Model): col_a = models.CharField(maxlength=20, db_index=True) col_b = models.CharField(maxlength=20,

Re: How to create model with dual primary key in Django?

2007-08-18 Thread Peter Melvyn
On 8/18/07, richard <[EMAIL PROTECTED]> wrote: > I'm working on a database-backed Web site which requires a few tables > to use dual primary keys (two columns acted together as primary key; > each of them is not unique in itself). How to do that properly? > (I'm aware of 'unique_together',

Re: Variable choices in ModelChoiceField

2007-08-17 Thread Peter Melvyn
On 8/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > But how do I pass the 'user' object to the Form so I can use it in > filter() or run .groups.all() on it? I do it this way: self.fields['emails'].queryset = BIZEmail.objects.filter(owner=oa_request.user.id)

Re: Clash of related_names among two tables

2007-08-16 Thread Peter Melvyn
On 8/16/07, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > So - you can use the same related name multiple times - BUT - the same > related name can't be added to a single model more than once. I see - each reference to the same model from different models has to have an unique related_name

Clash of related_names among two tables

2007-08-16 Thread Peter Melvyn
Hi all, please, could anybody confirm my experience with related_names. I tried to find-out some information about it and found invalid model example. If my understanding is correct, then it is not possible to have the same related_names in two different models. Is it correct? Thanks, Peter

Re: make-messages does not generate any message in .po except dummy header

2007-08-12 Thread Peter Melvyn
On 8/11/07, Ramiro Morales <[EMAIL PROTECTED]> wrote: > You are using Windows and a checkout of Django from SVN at a revision > between r5722 and r5842 right?. Yes, you are right, I run r5830. Sorry, I forgot to mention this... > Please update to a revision >= 5842. See ticket #4899. Thanks

make-messages does not generate any message in .po except dummy header

2007-08-11 Thread Peter Melvyn
Hi all, I'm trying to generate messages for transaltion in my project folder. As recommened in Wiki/Localization, I installed gettext utility for SourceForge and if I run make-messages command with verbose option, it produces just a .po file containing dummy header : # SOME DESCRIPTIVE TITLE.

I am not able to run custom SQL commands

2007-08-08 Thread Peter Melvyn
Hi all, I am not able to run custom SQL commands and I cannot discover what is the reason: 1. My models reside in bizweb/wss/models/ package 2. bizweb.wss application is included in INSTALLED_APPS 3. I use customized settings files: local-settings referring common-settings --> I run

Re: value for choices arguments for newforms.MultipleSelectField

2007-08-08 Thread Peter Melvyn
On 8/7/07, Chris Brand <[EMAIL PROTECTED]> wrote: > self.fields[f].queryset = queryset > # Have to force the widget to update itself (bug 4787) > self.fields[f].widget.choices = self.fields[f].choices Hi Chris, thanks for your help - it solved my problem,

How to specify engine type for particular table?

2007-08-06 Thread Peter Melvyn
Hi all, I operate MySQL server with default-storage-engine set to InnoDB. But I need full text search on some tables, which is unfortunatelly supported by MyISAM engine only. Is there a way to specify ENGINE=MyISAM option appended to CREATE TABLE DDL command generated by manage.py? Thanks,

Re: value for choices arguments for newforms.MultipleSelectField

2007-08-05 Thread Peter Melvyn
On 2 Srp, 17:35, Nathan Ostgard <[EMAIL PROTECTED]> wrote: > You can use ModelMultipleChoiceField for this: > > items = > newforms.ModelMultipleChoiceField(queryset=Items.objects.all()) Hi Nathan, I use it this way, but I need to reduce the queryset for current user whom ID is contained in

Re: Name of inclusion-tag template built in run-time

2007-07-31 Thread Peter Melvyn
On 7/29/07, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > I'm not sure how you've got your code set up, I'm looking for a way how to compose web page from the relativelly independent 'tiles'. Tags, especially inclusion tags seem to be a suitable tool for it. Its a pitty they cannot be used

Re: How do I echo template variables?

2007-07-30 Thread Peter Melvyn
On 7/30/07, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > Try {% debug %} If you mentioned this feature: is there an easy way to reformat {% debug %} output the same/similiar way an exception error is reported? Peter --~--~-~--~~~---~--~~ You received this

Re: Problems with i18n of field labels (newforms)

2007-07-25 Thread Peter Melvyn
On 7/25/07, Nathan Ostgard <[EMAIL PROTECTED]> wrote: > What import are you aliasing as _? Nothing, because I believed it is globally available and no import is neccessary. It was probably true before swap to UNICODE. And on the top of it, I got somehow deranged and assumed that _() function

Problems with i18n of field labels (newforms)

2007-07-25 Thread Peter Melvyn
Hi all, I'm trying to embed login form into each page. I implemented it using new forms as inclusion tag. Form model looks like: ... sf_name = forms.CharField(required=True, label=_('Username:'), max_length=30, widget=forms.TextInput(attrs={'class':'wsu-login-edit'})) ... If I change

Re: Auth framework - initials et of users/groups ?

2007-07-24 Thread Peter Melvyn
On 7/25/07, Przemyslaw Wegrzyn <[EMAIL PROTECTED]> wrote: > Thanks! I overlooked the 'fixtures' feature, I'll give it a try. I don't know wjhat kind of SQL server do you use, but If I'm not mistaken, fixtures are not fully supported on MySQL with InnoDB engine.

Re: Insert vs. Update

2007-07-24 Thread Peter Melvyn
On 7/24/07, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > You're not the first to suggest insert() and update() methods that > explicity do SQL INSERT and UPDATE calls. FYI: both, SQLite and MySQL support REPLACE statement to do this automatically.

Re: transaction commit

2007-07-24 Thread Peter Melvyn
> Your example is correct, and you aren't violating any 'Django principles'. Really? Should not be there something like this? enter_transaction_management() try: managed(True) try: ... except: transaction.rollback() raise ... else:

Name of inclusion-tag template built in run-time

2007-07-23 Thread Peter Melvyn
Hi all, I have a box containing some static texts in different languages and I would like to plug-in into few pages as inclusion tag. But I'm not able to find-out a way how to supply language code for its template name containing thos static text. I need something like this:

Re: Usage of {% trans ....%} tag in templates related to inclusion tags

2007-07-20 Thread Peter Melvyn
On 7/20/07, eXt <[EMAIL PROTECTED]> wrote: > Do you have: {% load i18n %} in your template? Certainly not - I forgot it - now it works fine. Thank you for help Peter --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

Usage of {% trans ....%} tag in templates related to inclusion tags

2007-07-20 Thread Peter Melvyn
Hi all, I'am embedding a piece of information into each page using inclusion tag and it seems everything works fine except tag {% trans ... %}. Its occurence in the inclusion template raises expcetion TemplateSyntaxError saying "Invalid block tag: 'trans'". Did I miss anything or it is

Internationalization of templates

2007-06-29 Thread Peter Melvyn
Hi, I'm beginner in Django and I have a question about internationalization support. If my understanding of i18n is correct, there are 3 basic approaches: 1. for views _() function 2. for templates {% trans ... %} block 3. for static files URL containing language code Templates containing