SELWONK - I Need your help PLEASE!

Hi Selwonk,

I have been browsing through the forums today and your name has popped up a number of timws, helping people out...I have tried to email you but i cant seem to, so I thought I would post in here and see if you would respond!

The problem I have is knowing how to transfer an existing frameset with variables into a standard page with page includes. I have posted the full description in the forum but no one has responded...

If there is any chance at all you can help me out that would be great . I have included what I have posted again in here for you to see and I desperately hope I hear from you. Many thanks Lottie

Hi there really need some help ). I have a frameset with multiple frames which I want to convert to a simpler frameset with pages with "includes" rather than frames. However each frame has ASP code with variable controls ,etc. as well as some javascript functions and I have tried to move these around to make the same page work with the menu in an include rather than frame, but with no success! The URL is : www.trust-europe.com/dev This is the frameset as is, what I could kinda do with is someone to take a peak at the actual files in the frameset and let me know how to swap it, as I am really desperate having spent most of today on it!! ( Look forward to hearing from you!!

Sorry - only just spotted this (shucks - thanks for thinking of me )

Post some of your code so we can see what the score is

Hi Selwonk,

Thank you SO much for getting back to me ) I have actually managed to fix this problem now but I have a new problem!!!

<%
sql = "SELECT ID_Pais," & Ucase(idioma) & ",idioma FROM NombrePaises Where Activo=1 ORDER BY " & Ucase(idioma) & " ASC"
set rdo = conex.Execute(sql)
%>

<% while not rdo.EOF %>
<%=rdo(1)%><br>
<%rdo.MoveNext %>
<% wend %>

If you can could you please explain to me exactly what this code does, as I am getting a little lost as to what the 1 indicates in : <%=rdo(1)%>

Thank you so much

This will return the first column of your record set (<%=rdo(1) %>) for each row (<% while not rdo.EOF %>)

To make you code simpler to understand you could use <%= rdo("FieldName") %>

Thank you so much! Perfect, that makes total sense, I was just getting a bit lost, because i tried putting 2 there and it errored, then I looked at it and it didnt visually appear to be column 1, but yeah now you have said it totally fits in!!!
Could you maybe help me with another little problem...... sorry to bother you again, you must get sick of newby learners like me!!!
I think I need to make some sort of loop???? Basically I need to count how many records there are in the database for each country code. At the moment I am only calculating it for Spain, as below....

set conexTJL = Server.CreateObject("ADODB.Recordset")
conexTJL.ActiveConnection = "Driver={SQL Server};" & _
"Server=217.76.131.33;" & _
"Address=217.76.131.33,1433;" & _
"Network=DBMSSOCN;" & _
"Database=qj003;" & _
"Uid=qj003;" & _
"Pwd=nicolas;"

conexTJL.Source = "SELECT * FROM Anuncios WHERE CodPais=6 AND Activo=1"
conexTJL.CursorType = 1
conexTJL.CursorLocation = 2
conexTJL.LockType = 3
conexTJL.Open()
numAdsES = conexTJL.RecordCount
So CodPais=6 is COUNTRY CODE = 6 which is SPAIN, and there is a numeric value representing each country in the database and I need to count how many records there are per country, NOT JUST SPAIN. Please could you let me know how i could do this, the only way i have thought is to just repeat the above chunk of text for EACH country, but wouldnt this be really long winded and memory intense with so many - what i hope are - unnecessary database connections??
I was thinking maybe some kind of loop?? For i = 1 to 6 (for say 6 countries) and then something like ... WHERE CodPais="i" ????
I hope I am making sense!! And thank you again for your help ).

hi there


you need group clause to do this thing, i mean if u want to count on basis of country


regards

ashish