| Author |
 Topic  |
|
Capt_Dunzell
Junior Member
USA
160 Posts |
 Posted - 22 April 2001 : 22:29:10
|
It deletes the ad, but after it auto refreshes the page it gives me this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Topic_ID ='.
/classifieds_view_ads.asp, line 97
Lines 93 to 103 read like this:
end if
gsSQL = "Select ID, Topic_ID, ad_title, content, price, image_url, name, added_By, address, city, zip, state, email, date_posted, "
gsSQL = gsSQL & "link FROM ADS_CONTENT WHERE Topic_ID = " & catID & " ORDER BY date_posted "
Set rs = my_Conn.Execute(gsSQL)
tSQL = ""
tSQL = tSQL & "SELECT ID, Category_Name FROM ADS_CATEGORY WHERE ID = " & catID
Set Categoryrs = my_Conn.Execute(tSQL)
%>
How can I fix this?
http://www.dunzellsden.com/forum/ |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 April 2001 : 22:48:48
|
redownload the file, I have fixed the error
|
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 23 April 2001 : 00:45:49
|
oh cool
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 23 April 2001 : 10:18:52
|
Ack! No! :) I still need help. It doesn't work right.. :) I'm still having the same problems as before...
quote:
Actually I have been thinking of discontinuing updates of this mod and focus on my other mods. Due to time constraints as well as the low interest in this mod.
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/ |
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 23 April 2001 : 19:06:59
|
HuwR's fix used the old names of the asp pages for this mod... if you just recently downloaded this mod, then the asp pages have underscores in the names now and his fix won't work.
Additionally, there is a broken image for the delete icon.
Here's a fix for both issues:
http://huntcentral.com/download/classifieds_view_ads.txt
Save the above as classifieds_view_ads.asp to replace your existing classifieds_view_ads.asp file and you should be cookin!
Diana
PS.... I forgot to thank HuwR for his fix on the delete.... thanks dude!
Edited by - huntress on 23 April 2001 19:09:09
Edited by - huntress on 23 April 2001 22:27:37 |
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 23 April 2001 : 19:13:54
|
quote:
Actually I have been thinking of discontinuing updates of this mod and focus on my other mods. Due to time constraints as well as the low interest in this mod.
I just wanted to make a note here... not sure how to say this very tactfully, so I'm just going to go for it. Do not take offense, I mean none.
A response such as the above makes one want to shy away from your mods. I could go on, but I'll leave it at that.
Sorry, just felt that needed to be said. 
|
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 23 April 2001 : 19:48:56
|
quote:
One bug I found:
When editing categories in which the name is more than one word, only the first word is populated in the text box. If saved without typing it back, then the category name is changed.
Here's the fix for this one:
http://huntcentral.com/download/classifieds_admin.txt
Save this as classifieds_admin.asp to replace your existing classifieds_admin.asp
The issue was of course not using quotes around the string.
Diana |
|
|
|
Huntress
New Member
USA
96 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 28 April 2001 : 10:53:46
|
need to add a feature to modify the ad, you can edit the categories and subs but not the ads. TIA... if anyone can do it....
Dayve |
|
|
|
KXS
New Member
Canada
66 Posts |
Posted - 30 April 2001 : 02:07:00
|
Aznkinght, I just got back from the non-internet world, been away for sometime now. I just noticed that you are thinking of not adding anymore updates to your classifieds app, I just thought I would let u know that I am very, very interested and I also think many people here want the updates. I think people know that your busy and that's why they not commenting on updating the awesome app...
I hope you continue with this one, anyways I back now, so I will support your efforts in any able way.
Later
------------------
"keeping it real" |
|
|
|
Lucky
Junior Member
USA
127 Posts |
Posted - 30 April 2001 : 14:50:28
|
i am very much interested in this mod, not able to help code a lot, but will test, edit, word, "snitzify" or anything else to help. we want to use it when the classifieds can be broken down into subcategories and want to help until we can get that accomplished.
|
|
|
|
Bookie
Average Member
USA
856 Posts |
Posted - 30 April 2001 : 15:19:36
|
Please don't bail. I installed and tested the first release of it and liked it a lot. I run a web site for a Christian college and seminary and would like to use that mod in a student web site. I haven't made it available for use yet because I've been anticipating other updates to it.
Bookie
|
|
|
|
acpc
Starting Member
Brazil
20 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 May 2001 : 20:27:56
|
when you delete the ad it still shows in the Recent Ads area AND when users click that of course they get the wonderful...
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
?
Dayve |
|
|
|
Topic |
|
Topic Locked
