| Author |
 Topic  |
|
Aznknight
Senior Member
USA
1373 Posts |
 Posted - 02 April 2001 : 04:39:42
|
quote:
a little bug,
did you know that one can create two,three or more subcategories with the same name ?
These is feature not a bug...There are no restrictions on subcategories names...so admin can name it whatever they want including same names. Say you want "music" in both arts and literature and "music" under entertainment. that is perfectly fine.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
 |
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 02 April 2001 : 04:54:48
|
quote:
that is perfectly fine.
yeah, seemed logical to me,too, now 
|
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 04 April 2001 : 04:17:09
|
Sometimes, I get that error when I run links.asp file.
--
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/links.asp, line 85
|
|
|
|
doulos
Starting Member
7 Posts |
Posted - 12 April 2001 : 12:20:45
|
Problem #1
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
/admin_links_delete.asp, line 24
Tried to delete a Category got this error. Running SQL 2000.
Problem #2:
The next issue I'm having is when I go to approve a URL I get sent to admin_links_approve.asp
The only issue is I get a HTTP 500 error. Any suggestions? My server is not busy. CPU usage is at 4% on a dual P3.
Suggestion: When your approving a submission maybe you should show the Category and Sub Category to help keep people from spamming url's into inappropriate categories.
Suggestion 2
admin_links_approve.asp should be edited to reflect your personal info.
strFrom = "doulos@snitz.com"
strFromName = "Snitz Forum"
Queston: What is the format for the keywords when adding a url?.. is it tab or comma dilimented? Just curious because I would like to add verbage indicating what is appropriate.
Great mod and idea..
doulos
Edited by - doulos on 12 April 2001 13:00:45
Edited by - doulos on 12 April 2001 13:11:33 |
|
|
|
doulos
Starting Member
7 Posts |
Posted - 12 April 2001 : 13:44:02
|
quote:
Problem #1
Tried to delete a Category got this error. Running SQL 2000.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
/admin_links_delete.asp, line 24
Here's the Fix
In
admin_links_delete.asp, line 24
Change
set rs = my_Conn.Execute ("delete * From LINKS_CATEGORIES where cat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete * From links_subcategories where Cat_ID=" & cat )
TO
set rs = my_Conn.Execute ("delete From LINKS_CATEGORIES where cat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete From links_subcategories where Cat_ID=" & cat )
And in: admin_links_deletesubcat.asp, line 27
Change
set rs = my_Conn.Execute ("delete * From links_subcategories where subcat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete * From links where Category=" & cat )
TO
set rs = my_Conn.Execute ("delete From links_subcategories where subcat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete From links where Category=" & cat )
Hope that helps you SQL 2000 peoples..
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 12 April 2001 : 15:34:40
|
quote:
quote:
Problem #1
Tried to delete a Category got this error. Running SQL 2000.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
/admin_links_delete.asp, line 24
Here's the Fix
In
admin_links_delete.asp, line 24
Change
set rs = my_Conn.Execute ("delete * From LINKS_CATEGORIES where cat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete * From links_subcategories where Cat_ID=" & cat )
TO
set rs = my_Conn.Execute ("delete From LINKS_CATEGORIES where cat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete From links_subcategories where Cat_ID=" & cat )
And in: admin_links_deletesubcat.asp, line 27
Change
set rs = my_Conn.Execute ("delete * From links_subcategories where subcat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete * From links where Category=" & cat )
TO
set rs = my_Conn.Execute ("delete From links_subcategories where subcat_ID=" & cat)
set rssubcat = my_Conn.Execute ("delete From links where Category=" & cat )
Hope that helps you SQL 2000 peoples..
The original code for this was for access only I think. I went about to make it sql server friendly and i guess i missed the "delete *"  . I'll fix it in the zip.
Also i'm looking into your other probs/suggestions.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
doulos
Starting Member
7 Posts |
Posted - 12 April 2001 : 20:00:14
|
Alan,
is admin_links_approve.asp supposed to be a "read only file" ?
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 12 April 2001 : 20:06:58
|
quote:
Alan,
is admin_links_approve.asp supposed to be a "read only file" ?
it's my editor, visual interdev, it sets it as read only so that only it uses it or something. you can just right-click the file and uncheck the read only attribute. editing it is fine with me.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
doulos
Starting Member
7 Posts |
Posted - 16 April 2001 : 16:18:31
|
I think one of the most difficult things is when your approving links you don't know where the link is going.
Can we get the code to add so we see the CATEGORY and SUBCATEGORY they user is trying to post thier link in?
Edited by - doulos on 17 April 2001 22:03:57 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 24 April 2001 : 17:16:10
|
quote:
I think one of the most difficult things is when your approving links you don't know where the link is going.
Can we get the code to add so we see the CATEGORY and SUBCATEGORY they user is trying to post thier link in?
Edited by - doulos on 17 April 2001 22:03:57
I totally agree. the original version didn't have this and I left it like that. But it's a big incovenience not knowing where you're adding a link.
I just added this feature in now. This is what it looks like:
Just replace your admin_links_main.asp page with the code from this text file:
http://www.calvsa.net/snitz/admin_links_main.txt
I will update the zip with this as well. 
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Topic |
|
Topic Locked
