| Author |
 Topic  |
|
|
dkerns
Starting Member
14 Posts |
 Posted - 27 June 2001 : 11:02:22
|
I am having a problem and hopefully someone can point me to the correct location in the various files to fix...
When a user registers, all the information from the profile screen is properly recorded in my SQL 2000 database.
However, when the user goes to edit the profile, all fields display EXCEPT
1) Hobbies
2) Latest News
3) Favorite Quote
And if they submit the information again, of course the real data is overwritten with the blank fields.
So for some reason it is not displaying the current content in these three fields.
Any help would be appreciated.
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 June 2001 : 13:04:00
|
OK, the problem is that these 3 fields are of Type nText, and therefore the positioning of them in queries and how you reference them in the code is important, although, this problem appears to have increased lately, so I am assuming it is an ADO version specific problem. It may also have been caused by installing a MOD, thus changing the select statements.
If you could email me your inc_profile.asp and pop_profile.asp files, I will fix them and tell you which was causing the problem
|
 |
|
|
Blade
New Member
66 Posts |
Posted - 18 July 2001 : 09:52:41
|
Was this ever resolved? I am having the same problem...
-------------------------
=>Blade<= |
|
|
|
dkerns
Starting Member
14 Posts |
Posted - 24 July 2001 : 23:35:14
|
No, HUWR looked at my code and offered a suggestion but that broke other things. If I recall correctly, he thought the problem had to do with the ADO version and the order of things...but it was never resolved and I haven't gone back to it since. If someone complains, I add the info manually...not an ideal solution!
I did confirm that it is only a problem on editing a profile (it doesn't display the stored values for some fields...and when you submit the form, it writes blanks/empty string back into the table).
- Don K
|
|
|
| |
Topic |
|
Topic Locked
