Snitz Forums 2000 - problem with link.asp

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

problem with link.asp

New Topic

Topic Locked

Printer Friendly

Author

Topic

blues
Starting Member

26 Posts

Posted - 05 June 2003 : 04:41:50

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]You have an error in your SQL syntax near 'show = 1' at line 1

/forum/links.asp, line 64

this is the code

<%
sqlcount = "SELECT count(url) FROM LINKS where category =" & rsSubcat("subcat_id") & " and show = 1"
Set RScounts = my_Conn.Execute(sqlcount)

rcounts = RScounts(0)
if rcounts <> 0 then
Response.Write " (" & rcounts & ")"
end if
Response.Write "</a>"

rssubcat.movenext
if rsSubcat.eof then Response.Write "." else Response.Write ", "
%>

and the line is

Set RScounts = my_Conn.Execute(sqlcount)

my connection is Mysql

Francodepaw
Junior Member

USA
111 Posts

Posted - 05 June 2003 : 16:14:34

Hello Blues,
If I remember right links manager was a pain in the butt to get working on MySql. Thought I had posted something over a SHN Forum but I can't locate yet. It was not fun.

But the issue had something to do with MySql would not all SHOW as a field name or it is a reserved word or something like that. Did you run into errors when you ran the dbs_links file?

I ended up editing about 5-6 of the files for the mod to make it work.

EDIT:

It was here http://forum.snitz.com/forum/topic.asp?TOPIC_ID=38979&SearchTerms=Links+manager

Gives you a starting point.

Edited by - Francodepaw on 05 June 2003 16:24:54

blues
Starting Member

26 Posts

Posted - 06 June 2003 : 11:08:32

thanks now i try!!!

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.35 seconds.