Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. penguinspeaks

    write HTML code within ASP line

    ...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_") VRELEASE = INFO1("RELEASE_DATE_") VTHUMB = INFO1("THUMB_ADDRESS_") VTITLE =...
  2. penguinspeaks

    READ TEXT FILE BASED ON VARIABLE

    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.
  3. penguinspeaks

    READ TEXT FILE BASED ON VARIABLE

    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 =...
  4. penguinspeaks

    Return to current location on page after asp processes.

    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.
  5. penguinspeaks

    Return to current location on page after asp processes.

    ****** 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...
  6. penguinspeaks

    Return to current location on page after asp processes.

    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...
  7. penguinspeaks

    Stored Procedures and triggers

    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.
  8. penguinspeaks

    Stored Procedures and triggers

    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.
  9. penguinspeaks

    Stored Procedures and triggers

    ...INSERT INTO STORY_TAGS (TAGS_) SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(TAGS_,',',mCtr),',',-1) AS valsAsRows FROM (SELECT (cb.ctr*cc.ctr)+ca.ctr AS mCtr FROM (SELECT 1 ctr UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) ca CROSS JOIN (SELECT 0 ctr UNION SELECT 1 UNION SELECT 2 UNION...
  10. penguinspeaks

    Stored Procedures and triggers

    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.
  11. penguinspeaks

    Stored Procedures and triggers

    ...INSERT INTO STORY_TAGS (TAGS_) SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(TAGS_,',',mCtr),',',-1) AS valsAsRows FROM (SELECT (cb.ctr*cc.ctr)+ca.ctr AS mCtr FROM (SELECT 1 ctr UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) ca CROSS JOIN (SELECT 0 ctr UNION SELECT 1 UNION SELECT 2 UNION...
  12. penguinspeaks

    Parse a database field that is comma delimited and input the results into another table

    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...
  13. penguinspeaks

    Refresh page after input from another

    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...
  14. penguinspeaks

    Update column based on input from another column

    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.
  15. penguinspeaks

    Update column based on input from another column

    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...
  16. penguinspeaks

    Start loop from a specified point

    ...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 = INFO1("setlist_order") varorder is the number entered on my form. I want the records that follow to be...
  17. penguinspeaks

    How do I pass a classic asp variable to JS

    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...
  18. penguinspeaks

    How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain

    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...
  19. penguinspeaks

    iis woos (not displaying pages correctly)

    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.
  20. penguinspeaks

    iis woos (not displaying pages correctly)

    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...

Part and Inventory Search

Back
Top