quote:

---

Itrepidone,

It's already done but I have a little problem implementing some of my code in the mod's database setup file. Plus, it's exam week here at school (heavy material) .

The original code for that mod is not mine. I loved the way it's done, so I hacked it to work with snitz and made it easier to navigate thru, plus other things with the db.

I promise it'll be out in the next two days (if problem is fixed!)

ô¿~

Edited by - frankie on 19 February 2001 20:51:27

---

quote:

---

i wanted to upgade and this what hepend
http://ofird.trab.dk/f/listings_setup.asp

CREATE TABLE CAT(ID INT (11) DEFAULT '' NOT NULL auto_increment , CAT VARCHAR(255))
-2147467259 | [TCX][MyODBC]Incorrect table definition; There can only be one auto column and it must be defined as a key
CREATE TABLE SUBCAT(SUBCATID INT (11) DEFAULT '' NOT NULL auto_increment , SUBCATNAME VARCHAR(255), CATID VARCHAR(50))
-2147467259 | [TCX][MyODBC]Incorrect table definition; There can only be one auto column and it must be defined as a key
CREATE TABLE LINK2(ID INT (11) DEFAULT '' NOT NULL auto_increment , NAME VARCHAR(100), URL VARCHAR(255), KEYWORD MEMO, DESCRIPTION MEMO, EMAIL VARCHAR(100), POSTDATE VARCHAR(100), HIT INT DEFAULT 0, CATEGORY VARCHAR(50), PARENTID VARCHAR(50), SHOW BIT, BADLINK BIT)
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near 'MEMO, DESCRIPTION MEMO, EMAIL VARCHAR(100), POSTDATE VARCHAR(100), HIT INT DEFAU' at line 1

---

ofird,

Are using mysql? anyways, your're missing a quotation mark in this string:

" NOT NULL auto_increment 

change it to this:

" NOT NULL auto_increment "

Plus, try to change all the MEMO fields in that file to TEXET.

Keep me in touch. PEACE

ô¿~

quote:

---

What exactly can't be used in submitting a URL for the user. I'm not sure which punctuation in which fields are causing the error.

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression ''The home of the TFM message boards. If you're looking at this link'.

/forum/addurl.asp, line 51

If I take out all punctuation from all fields, I can submit URLs. As soon as I put in a more detailed description, it chokes at mulitple points. Above is one example.

Thanks,
Paul

---

quote:

---

If anyone is not getting a Total URL Count beside the ex:"CategoryName (4)" , from all the subcategories in listings.asp, if the count is always ex:"CategoryName (0)" even though you do have URL's in the subcategories, edit these lines in listings.asp

approx Lines 83 and 123

sqlcount = "SELECT count(url) FROM link2 where parentid='" & rs("id") & "' and show=1"

change them to

sqlcount = "SELECT count(url) FROM link2 where parentid='" & rs("id") & "' and show=yes"

changing the 1 to a yes now gives me a Total URL Count of all URL's in that Categories subcategories.

Intrepidone

---

Intrpidone,

Thanks for your non-stop help. change all the 1's and 0's in the code to yes and no respectivly unless you're using sql server.

ô¿~

quote:

---

gmcm ......

change this line

<option value="<%=rscat("ID")%>"><%= ChkString(rs("cat"), "display") %></option>

to this

<option value="<%=rscat("ID")%>"><%=rscat("cat")%></option>

I got the same error as you so I just replaced that line with my old backup copy
(Tested it with Netscape and it works)

frankie.....

After I ran into the problem I mentioned I changed the lines back to the original. It is soooo close to working with Netscape.

Personally I do not use Netscape, I really don't like it but when building websites I use IE 4 and Netscape 4 for compatibility testing. Last thing you need is a person complaining ....lol

I am sure we'll nail this puppy with it's Netscape problem

Intrepidone



Edited by - Intrepidone on 14 February 2001 18:55:18

---

	<option value="<%=rscat("ID")%>"><%=rs("cat") %></option>

	<option value="<%=rscat("ID")%>"><%=rscat("cat") %></option>