| Author |
 Topic  |
|
|
BinaryBoy
Starting Member
USA
49 Posts |
 Posted - 14 January 2001 : 02:22:15
|
Ok, I haven't gone through all of the files but in default.asp and pop_profile.asp there are fields that are being listed twice in the select statements and I was getting errors when I tried to run it (Access 2000). Anyway, here are the details of the errors:
In default.asp:
* The SQL that starts on line 161 duplicates F_STATUS and CAT_ID in the select statement.
In pop_profile.asp:
* The SQL that starts on line 69 duplicates COUNTRY and POSTS in the select statement.
* The SQL that starts on line 597 duplicates COUNTRY and POSTS in the select statement.
* The SQL that starts on line 700 duplicates COUNTRY and POSTS in the select statement.
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 January 2001 : 07:17:48
|
You are absolutely correct about the duplicates, but why this should be causing you problems is a mystery, Both my test sites use Access 2000, I have not noticed any stange behaviour, there is nothing wrong with doing this, just obviously unnecessary.
What were the problems you were getiing ?
'Resistance is futile' |
 |
|
|
BinaryBoy
Starting Member
USA
49 Posts |
Posted - 14 January 2001 : 10:39:29
|
Ack, you would ask that... It would start to display the main forum page and there would be an error message right in the middle of it... Can't remember the error but someone else had posted about it in here before.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 January 2001 : 10:59:20
|
Ok thanks, I'll see if I can dig it out.
I was just curious as to what circumstances would cause it to give problems, when it doesn't appear to affect most people.
'Resistance is futile' |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 23 February 2001 : 21:15:28
|
<-- bump -->
(think I'm starting to get a headache)
As Huwr had said, this doesn't really cause any errors or shouldn't cause any errors, but no harm in fixing it.
Updated line numbers(Alpha 8 version):
default.asp
line 187, 188(original) and line 193, 197 (duplicates)
pop_profile.asp
line 76, 77 and line 80, 81
line 652, 653 and line 656, 657
line 765, 766 and line 769 770
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----* |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 25 February 2001 : 18:10:50
|
fixed in the source of sf2k_31a3.zip
Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
| |
Topic |
|
Forum Locked
Topic Locked
