Re: Maximum field length with PHP 4.1.2/MSSQL v7 ?
| From: | Chris MacKenzie | Date: | Sun, 28 Apr 2002 05:02:28 +0000 |
| Subject: | Re: Maximum field length with PHP 4.1.2/MSSQL v7 ? | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18855@lists.php.net to get a copy of this message | ||
pan wrote:
> >Ah, sorry I didn't make it terribly clear. I meant that I only ever get
> >a maximum of 255 chars returned.
>
> O.K. - then that makes it seem a truncation problem and not a
> data definition problem.
>
> minor thing: in edit_exam_question.php there is
> " print '<a align="left">Select Correct Answer:<br>';
> "
>
> What's the <a tag? I don't know that one :)
It's a new tag I just invented :-)
> You might want to add the 'readonly' attritbute to
> that textarea - lessens chance of unwanted post variables.
> You seem to be using that textarea only for displaying the
> retrieved question_text
These pages are for the "admin" user to be able to edit/delete any
question or possible answers, As such I left the text area rw so that
they could change it.
> Either one of the unknown queries in edit_exam_question.inc
> is truncating the data or the url parameter is truncated, or
> dbconn.inc is the culprit.
dbconn.inc only holds servername, username and password. I've attached
it and the other missing file to this message - with differing passwords
of course :-)
> Three chances at answering the problem, not enough data.
> Except for the url parameter passing - but only id and
> question_id get passed so no chance on the parameter formatting
Yes, I thought I'd keep url passing down to a minimum and only ever pass
record id's.
> ooops ... files attached only reiterate the problem and do not serve to
> further illuminate the path to happiness.
I've attached the two missing files, so this should help to diagnose
what I've stuffed up.
--
Rgds,
Chris MacKenzie
Windows: "Where do you want to go today ?"
Mac OS: "Where do you want to be tomorrow ?"
Linux: "Are you coming or what ?"