| Author |
 Topic  |
|
duall
Starting Member
United Arab Emirates
4 Posts |
 Posted - 06 May 2004 : 17:36:52
|
Hello all! Please anyone help me to make classifieds work in SQL2000! It is making records to DB but it is not coming back in view. Only Title shown!
Very thanks for any idea! |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
duall
Starting Member
United Arab Emirates
4 Posts |
Posted - 07 May 2004 : 05:25:18
|
quote:
Originally posted by OneWayMule
First of all, problems with MODs should be posted in the Help: MOD Implementation forum (as also the readme says).
Anyway, on which page(s) are you having this problem? Can you post a link to your forum?
Sorry if it come to wrong plase. In every page if showing classifieds I can see only Title of ad but in DB and when I am editing all data present. Server win2003/IIS 6.0 SQL2000
It is here http://www.inuae.ru/portal/forum/classifieds.asp
|
|
|
|
Ryan
Average Member
USA
858 Posts |
Posted - 24 May 2004 : 18:05:42
|
| I am able to get all the way to the message of the ad. Maybe I misunderstand you or if I do understand then there isnt a problem. |
The Poultry Link - "Serving the best of the fancy with the best of the web"
Forum Setup Help |
|
|
|
duall
Starting Member
United Arab Emirates
4 Posts |
Posted - 24 June 2004 : 11:35:44
|
quote:
Originally posted by Ryan
I am able to get all the way to the message of the ad. Maybe I misunderstand you or if I do understand then there isnt a problem.
Hi Ryan!
Thanks for your attention! I have found solution for the problem it means you have visited after I solve it already.
Now I found other bug with search in classifieds. It is giving this error:
Microsoft VBScript runtime error '800a01a8'
Object required: 'my_Conn'
/portal/forum/inc_func_old.asp, line 636
and I realised that it is bug in all Image3d v 3.4.04 portal i found in the net
Here is what in line 636
function Smile(fString)
'Smile Editing Mod by Eric J starts here
strsql = "Select s_url, s_code from " & strTablePrefix & "smiles" 'Bug
set drs = my_conn.execute(strsql) 'this is line 636
Do until drs.eof
smile_url = drs("s_url")
smile_code = drs("s_code")
fString = replace(fString, "["&smile_code&"]", "<img src=""" & strForumurl & strImageURL &smile_url&""" border=0>")
drs.movenext
loop
set drs=nothing
Smile = fString
'Ends here
end function
Thanks for any suggestions |
|
|
|
fyrman09
Starting Member
1 Posts |
Posted - 07 December 2004 : 23:02:28
|
Anyone have a copy of the this mod the download no longer works.
Thanks |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 15 December 2004 : 11:21:02
|
quote:
Originally posted by fyrman09
Anyone have a copy of the this mod the download no longer works.
Thanks
I would apreciate it too 
thxs |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
digital
Starting Member
4 Posts |
Posted - 15 December 2004 : 14:08:10
|
Me too...
Regards,
Per |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
pemass
Starting Member
9 Posts |
Posted - 05 January 2005 : 07:06:56
|
| Hi. I am implementing this in the UK but I can't find the location of the currency string variable so that I can change it from $ to £. Sorry to be a nuisnace - can someone point me to its location. Many thanks. |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 05 January 2005 : 15:07:18
|
You will find it in the following files:
classifieds.asp
classEditAd.asp
classPlaceAd.asp
classViewAds.asp
Just open each file and do a search for $ and you will find where you need to put your £ symbol.
I hope that helps.
|
Cheers,
David Greening |
|
|
|
pemass
Starting Member
9 Posts |
Posted - 06 January 2005 : 04:47:29
|
| Thanks for the swift reply. I didn't make myself very clear I'm afraid. What I meant was - in ClassPlaceAd.asp at line 212, StrCurrencySmbol is calling that variable defined elsewhere. What I can't find is the location of the definition so I can change it from $ to £. I have looked in the inc_func_common and inc_func_class files but still cannot trace it. Any other suggestions? Thanks again. |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 06 January 2005 : 05:47:13
|
OK, I have just looked at the code and it is in 3 different files where the varible has not been defined. The files you will find strCurrencySymbol in are:
classEditAd.asp
classPlaceAd.asp
classdetail.asp
I would suggest that you add the following code to your inc_header.asp (just below: <!--#INCLUDE FILE="inc_func_common.asp" -->):<%
Dim strCurrencySymbol
strCurrencySymbol = "£"
%> and that will fix it for you.
|
Cheers,
David Greening |
|
|
|
pemass
Starting Member
9 Posts |
Posted - 06 January 2005 : 09:23:50
|
| Hi again. I tried that and now I get the £ and $ next to each other, i.e. £$. Also, the line I inserted appears at the top of the asp page when viewed, even after I have deleted it from the file and refreshed it on the server. How can I get rid of it? This variable must be defined somewhere but I am blowed if I can find it! Thanks for your help. |
Edited by - pemass on 06 January 2005 09:35:22 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 06 January 2005 : 17:39:38
|
Ok, in classEditAd.asp & classPlaceAd.asp find the $ symbol and before the font tag you will see the <%= strCurrencySymbol %>, just cut and paste it to where you see the $ symbol and it will fix your issue.
Now in classViewAds.asp find the $ symbol and add a space and the <%= strCurrencySymbol %> just before the <%if rs("price") <> "" then Response.write (" " & rs("price")) End If %> after removing the $ symbol from that code.
Then it should work for you across the Classifieds..
|
Cheers,
David Greening |
|
|
|
Topic |
|
Topic Locked
