quote:

---

Hey Aznknight!

I'll start working on the layout of the "details" page and any extra fields. Basically just don't want to have people duplicate work.

Might be a good idea to find a good example of a classified system we like and work toward that.

Scott LeMieux
NDesigns.net

---

Scott, cool...

I haven't had much time to work on this mod for awhile.

I think we can work together and incrementally improve this mod.
Since you've already done some stuff, you can do the next release of this and after that I can do the next release.
What do you think?


- Alan
"True knowledge is knowing how little you really know"

quote:

---

Hey Aznknight!

I'll start working on the layout of the "details" page and any extra fields. Basically just don't want to have people duplicate work.

Might be a good idea to find a good example of a classified system we like and work toward that.

Scott LeMieux
NDesigns.net

---

quote:

---

Nice mod,

Do you plan to include the ability to post images in the add's in a future release?

---

quote:

---

ok got it working on SQL Server, however, not sure you want to use the format that I've used or continue with the inner joins, etc.

iadID = Request.QueryString("ID")

Set rs = Server.CreateObject("ADODB.Recordset")
gsSQL = "SELECT * from ads_content WHERE ADS_CONTENT.ID = " & iadID
rs.Open gsSQL, My_Conn

gsSQL1 = "SELECT * from ads_category WHERE id = " & RS("topic_id")
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.Open gsSQL1, My_Conn 

I also noticed that you're not checking to see if IadID is empty.. I have added code to mine to see if it's empty, if so send user back to classifieds cause they are doing something they shouldn't be doing :)

Also, might want to check for BOF or EOF if there are no ads, etc.

I will help you with the subcategories if you'd like... not sure if you need help with it but figured I'd at least offer.

P.S. I also added rs.close and rs1.close at the end of the file and set rs/rs1 = nothing to get rid of the object and save resources.

Thanks,
Tim

---

gsSQL = "Select ADS_CONTENT.ID, Topic_ID, ad_title, content, price, image_url, added_By, city, state, email, date_posted, "gsSQL = gsSQL & "link, ADS_CATEGORY.id, category_name FROM ADS_CONTENT left join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.id WHERE ADS_CONTENT.ID = " & iadID

gsSQL = "Select ADS_CONTENT.ID AS CONTENTID, Topic_ID, ad_title, content, price, image_url, added_By, city, state, email, date_posted, "
gsSQL = gsSQL & "link, ADS_CATEGORY.ID AS CATEGORYID, CATEGORY_NAME FROM ADS_CONTENT inner join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.ID WHERE ADS_CONTENT.ID = " & iadID

quote:

---

Hi, is anybody here that have Classifieds running under SQL 7.0 or 2000 ?
I have try long time to make it running but no chance.

Test here:
http://www.itc.dynip.com/kinser/classDetail.asp?id=2

---

quote:

---

Hi...
I had the same problem with this SQL statement:

gsSQL = "Select ADS_CONTENT.ID, Topic_ID, ad_title, content, price, image_url, added_By, city, state, email, date_posted, "gsSQL = gsSQL & "link, ADS_CATEGORY.id, category_name FROM ADS_CONTENT left join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.id WHERE ADS_CONTENT.ID = " & iadID

It's not the inner join that's the problem. I took the gsSQL string from Visual Interdev and ran it in SQL Server Query Anaylyzer and it ran just fine... There seems to be an issue with naming recordset entities. As soon as I renamed ADS_CONTENT.ID and ADS_CATEGORY.ID using aliases it worked fine.

Try this instead:

gsSQL = "Select ADS_CONTENT.ID AS CONTENTID, Topic_ID, ad_title, content, price, image_url, added_By, city, state, email, date_posted, "
gsSQL = gsSQL & "link, ADS_CATEGORY.ID AS CATEGORYID, CATEGORY_NAME FROM ADS_CONTENT inner join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.ID WHERE ADS_CONTENT.ID = " & iadID

Of course you need to make sure your references to those recordset entities are renamed in your code as well...

---

quote:

---

quote:

---

Hi, is anybody here that have Classifieds running under SQL 7.0 or 2000 ?
I have try long time to make it running but no chance.

Test here:
http://www.itc.dynip.com/kinser/classDetail.asp?id=2

---

i'm running this on sql 2000 and it's just fine..I've also tested it on sql 7 without a hitch? what was the problem you had?

- Alan
www.iamviet.com

---

quote:

---

quote:

---

Hi...
I had the same problem with this SQL statement:

gsSQL = "Select ADS_CONTENT.ID, Topic_ID, ad_title, content, price, image_url, added_By, city, state, email, date_posted, "gsSQL = gsSQL & "link, ADS_CATEGORY.id, category_name FROM ADS_CONTENT left join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.id WHERE ADS_CONTENT.ID = " & iadID

It's not the inner join that's the problem. I took the gsSQL string from Visual Interdev and ran it in SQL Server Query Anaylyzer and it ran just fine... There seems to be an issue with naming recordset entities. As soon as I renamed ADS_CONTENT.ID and ADS_CATEGORY.ID using aliases it worked fine.

Try this instead:

gsSQL = "Select ADS_CONTENT.ID AS CONTENTID, Topic_ID, ad_title, content, price, image_url, added_By, city, state, email, date_posted, "
gsSQL = gsSQL & "link, ADS_CATEGORY.ID AS CATEGORYID, CATEGORY_NAME FROM ADS_CONTENT inner join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.ID WHERE ADS_CONTENT.ID = " & iadID

Of course you need to make sure your references to those recordset entities are renamed in your code as well...

---

interesting...I wonder why some people are getting errors where my sql statements used inner joins and not others...Also why would naming recordset field calls in the select fixed it for your instance?

- Alan
www.iamviet.com

---