Re: [Bodington-developers] Questionnaire tool

[Alistair Y. <ali...@sm...>]

there isn't a problem with the front end - I just have to match a text 
string, such as "Question 8" with the question's text in the db. To do 
that I need to use the ordinal field, which can't handle localisation 
as I've just found out. e.g. "Question 8" could refer to an entry in 
the db anywhere between 701 and 799.

Now, the real problem. Having sorted the questionnaire numbering in the 
front end, a user has then used this layout to create a Gaelic version 
of the questionnaire but as the numbering is already sorted, they don't 
have to mess about moving questions, so there is no 701. Everything in 
the Gaelic questionnaire is 100, 200, ... 2400 etc.

I'll get there, evennwhalleeeee

Alistair

On 10 May 2005, at 10:18, Peter Crowther wrote:

>> From: Andrew Booth [mailto:a.g...@le...]
>> The ordinal value simply sets the order in which the
>> questions appear.  By
>> default they are 100 apart, but you can set them to any
>> value. In your case,
>> question 9 would be presented before question 8.
>>
>> Aggie
>>
>> -----Original Message-----
>> From: [...] Alistair Young
>> in the questionnaire_questions table there's an "ordinal"
>> field, which
>> seems to be related to the question number, i.e. ordinal=100 means
>> question number 1.
>> However, Question 8 in the questionnaire shows as ordinal="701" and
>> Question 9 shows as ordinal="8".
>>
>> Is there any relation between ordinal and question number or
>> is it pure chance?
>
> Is the ordinal sorted as a string rather than as an integer, by any
> chance?  This would give the observed behaviour.
>
> 		- Peter