The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Ok I am so close on this and I just don't know how to finish this off.
Lets start if you goto www.vmcplugins.com/forum/file_library.asp
If you see depending on if the file is free or paid based on a value in the database called F_ISFREE is shows in the bottom section or top section.
Now if you click on one of the links it goes into list all the files within that section. The problem is it shows both free and paid files. I need this to only display paid or free depending on the link they click.
Here is a .txt version of my file_library.asp:
www.vmcplugins.com/downloads/file_library.asp.txt
On lines 825 - 830 I have my strsql statement to try and display the list on the order to be paid or free using a querystring.
That is being passed on lines 415 and also 479.
I am stuck at this point on how to display this the way I need to can anyone help me from here? I would be greatly appreciated.
Thanks
<
Lets start if you goto www.vmcplugins.com/forum/file_library.asp
If you see depending on if the file is free or paid based on a value in the database called F_ISFREE is shows in the bottom section or top section.
Now if you click on one of the links it goes into list all the files within that section. The problem is it shows both free and paid files. I need this to only display paid or free depending on the link they click.
Here is a .txt version of my file_library.asp:
www.vmcplugins.com/downloads/file_library.asp.txt
On lines 825 - 830 I have my strsql statement to try and display the list on the order to be paid or free using a querystring.
That is being passed on lines 415 and also 479.
I am stuck at this point on how to display this the way I need to can anyone help me from here? I would be greatly appreciated.
Thanks
<
Posted
Originally posted by JJenson goto www.vmcplugins.com/forum/file_library.aspGot a test account for us?
<
Search is your friend
“I was having a mildly paranoid day, mostly due to thefact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Posted
Oh yeah sorry
user: snitz
pass: test<
user: snitz
pass: test<
Posted
cLng(Request.QueryString("IsFree")) Have you tried that?<
Posted
Ok that did the same as the other. This is how I made the line look.
strSql = strSql & "WHERE F_ISFREE = " & cLng(Request.QueryString("IsFree"))
Also you can view it now without being logged in. SOrry about that didn't even know you had to be logged in to see it.
<
strSql = strSql & "WHERE F_ISFREE = " & cLng(Request.QueryString("IsFree"))
Also you can view it now without being logged in. SOrry about that didn't even know you had to be logged in to see it.
<
Posted
Ok trying to go a different route here I tried passing a variable like so:
Then putting this in my strsql statement.
But this did not work either what am I missing cause I am lost as usual<
Code:
Dim IsFree : IsFree = Request.QueryString("IsFree")
Then putting this in my strsql statement.
Code:
strSql = "SELECT FC.F_CAT, FC.ID, COUNT(FF.ID) AS COUNTOFID "
strSql = strSql & "FROM " & strTablePrefix & "FILECAT FC "
strSql = strSql & "LEFT JOIN " & strTablePrefix & "FILEMANAGER FF "
strSql = strSql & "ON FC.ID = FF.F_CAT "
strSql = "WHERE F_ISFREE = " & IsFree & ""
strSql = strSql & " GROUP BY FC.F_CAT, FC.ID "
Set rsX2 = my_Conn.Execute (strSql)
But this did not work either what am I missing cause I am lost
as usual<