Search results for query: *

trying to use ASP code that I recently wrote to split data into columns instead of just one. The problem I'm running into is what I went to enter HTML code into said data. Here's the HTML code that II have SET INFO1 = CONN.EXECUTE("SELECT * from videos order by ID DESC") VLINK = INFO1("LINK_")...

It's weird that I cannot get help on this. Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. "It's nice to be important... but it's more important to be nice.

I want to read a text file and display it on webpage. The file to display is based on a variable passed in a querystrind. I am trying the following code, but getting an error: Expected literal constant /STORY/STORY3.ASP, line 155 Const Filename = VTX Here is my code: VID =...

I need to delete this post, but do not know how to. Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. "It's nice to be important... but it's more important to be nice.

****** UPDATE ************ I have figured out how to make the page focus on the title that was clicked. Now I just need to figure out how to make it focus on the location of which the item was clicked. Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database...

I will try to explain this as best as I can. I am not sure if it falls under ASP, or not. Here goes: I am designing a site that hosts short stories. After the client does a search, the results display, let's say, 100 records (Titles). Beside each Title there is heart icon, which when clicked...

Andrzejek, yes it did. Thanks!! Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. "It's nice to be important... but it's more important to be nice.

Thanks a bunch, Andrzejek!1 Chris Miller, I am always learning something new. This is at the top of the list Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. "It's nice to be important... but it's more important to be nice.

I appreciate your feedback. This SQL statement works when ran alone. However, I am getting multiple errors when trying to create a trigger using it. The following query has failed: "CREATE DEFINER=`jeff.ferren`@`gmail.com` TRIGGER `UpdateALLTags` AFTER INSERT ON `stories` FOR EACH ROW DELETE...

Let's say, for the sake of an argument, that I do not empty the DB each time. How can I get this to trigger each time a new story is submitted?? Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. "It's nice to be important... but it's more important to be nice.

Stored Procedures and triggers I am still newish and inexperienced in MySql databases. I am using them for my Classic ASP websites. Here is what I am seeking help with. I have the following query: DELETE FROM STORY_TAGS; INSERT INTO STORY_TAGS (TAGS_) SELECT DISTINCT...

Using classic ASP and MySql database., I want to parse a field that contains a list of tags, and take those results and input into another table. So if I had tea,coffee,bread,milk in a field, it would parse that field and give me tea coffee bread milk then upload the list into a different table...

I am creating a scoresheet for a game. Page 1 has inputs for player 1 and a static grid that contains the scores for player 2 without inputs. And page 2 has the opposite(static scores for player 1 and inputs for player 2. I have included a screenshot of the rough view of how it looks now. This...

Thanks for the ideas. I had to read up on virtual columns, but it solved my issues. Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. Not sure if that information helps or not.

In my mysql DB, I have a field (current_) that automatically defaults as the current date/time. This happens each time there is a new entry. I have another field (next_) that I want to be the current date/time + 4 hours. I have tried this using code(classic asp) as well as using unix time...

I am trying to automate an order based on my input. If I enter a 5, for example, I want the rest of the records to auto-update. So the next record to meet the criteria would be 6, the next 7, and so on. SET INFO1 = CONN.EXECUTE("SELECT * FROM SONGS1 WHERE ID ="&VARID&"") VARNO =...

How do I show a classic asp variable in a javascript link?? <script> var variable = <%=varid%> window.open("https://ferrens.info/MUSIC/PDF2.ASP?id="+variable); </script> I have tried <script type='text/javascript> var variable = '<%=variable%>'; </script> But it will not allow me to close...

I use this, but you have to have a user and password: <% Dim sConnection, objConn , objRS sConnection = "DRIVER={MySQL ODBC 3.51 DRIVER}; SERVER=localhost; DATABASE=MYDB; UID=MYUSER;PASSWORD=MYPASS; OPTION=3" Set Conn = Server.CreateObject("ADODB.Connection") set...

Please delete this thread Thanks, Penguin Please keep in mind that I am using classic ASP with MySQL database. Not sure if that information helps or not.

I have installed iis and have enabled classic asp. However, when I try to view a .asp page, it shows me the HTML and code as seen in the screenshot. How can I fix this?? Using is 21H2 on win 11 This problem started before I upgraded from 10 to 11 Thanks, Penguin Please keep in mind that I am...