| Author |
 Topic  |
|
|
andretti
New Member
70 Posts |
 Posted - 24 March 2005 : 09:28:33
|
I am using the classfieds mod. On the front page I am using an addon to the mod that allows me to show last 5 ads placed etc...
When I load up the file in my portal page as an include I get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/inc_Classifieds.asp, line 12
###### Lines 8 - 12 are as follows #####
sql = "SELECT ID, AD_TITLE,IMAGE_URL,ADDED_BY,DATE_POSTED from " & strTablePrefix & "ADS_CONTENT "
sql = sql & " order by DATE_POSTED desc"
set rsClassAds = Server.CreateObject("ADODB.Recordset")
rsClassAds.open TopSQL(Sql,intNumClass), my_Conn, 0, 1, &H0001
###########################
Does anyone know what is wrong with this or know what may be causing my problem?
Thanks in advance |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 25 March 2005 : 01:37:00
|
I am working on a MOD to do what you are after and will get to it this week-end, just got some other non-computer stuff to do for one of the families in the street., Building a deck for their back yard first.
|
Cheers,
David Greening |
 |
|
|
andretti
New Member
70 Posts |
Posted - 25 March 2005 : 07:26:02
|
| Ok cool. Did you get my email? |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 25 March 2005 : 15:07:42
|
Yes I did and will send it to that email address. How did you find out I was doing this type of MOD before I said anything?
|
Cheers,
David Greening |
|
|
|
andretti
New Member
70 Posts |
Posted - 25 March 2005 : 15:31:52
|
| Think I seen something on your web site :) I usually do not miss much |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 26 March 2005 : 02:39:25
|
But that is hard as I have it on a page I created as I was doing the mod (found some issues so need toime to do it better) and it did not have time to get in the search engines and I told no one else anything about it..
Shall have time on Monday to look at it with tomorror being easter for me.
|
Cheers,
David Greening |
|
|
|
andretti
New Member
70 Posts |
Posted - 26 March 2005 : 06:58:53
|
actually I think I saw it on your portal page...
Have a Happy easter! |
|
|
| |
Topic |
|
Topic Locked
