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

    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_")...
  2. 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 =...
  3. 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...
  4. penguinspeaks

    Stored Procedures and triggers

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

    Start loop from a specified point

    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 =...
  9. 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...
  10. 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...
  11. penguinspeaks

    JS Open print dialog page to print a file

    Greetings: I need to print a pdf file. The file names are listed from a database loop that contains the filenames within a folder. I have a script that can directly send to the printer, but I want to open the dialogue page instead. Depending on the file, I may only want certain pages printed...
  12. penguinspeaks

    fso Question

    Hello all. First question. I am using FSO to loop through a folder and get the names of files. I want to upload all of the filenames to my DB. I cannot seem to figure out how to loop through and do this. Here is my code: <% Dim strPathInfo, strPhysicalPath strPathInfo =...
  13. penguinspeaks

    Noob Ajax question

    Being brand new to Ajax and a beginner to JS, I cannot locate the resources that will teach me how to do what I wish to do. I have a form with three fields. One is a dropdown, one is a radio button, and the last is a text field. I want to be able to, using onchange, send the three values to a...
  14. penguinspeaks

    2 columns of data

    I have a table that I want data in. The data will be from a database and sorted by id. Here is the raw table and how I want it to display. <table align="center" cellspacing="5" class="auto-style1"> <tr> <td>Player 1</td> <td>VS</td> <td>Player 2</td> </tr> <tr> <td>1</td>...
  15. penguinspeaks

    Unknown column

    My statement is a simple one: STRSQL = "UPDATE BRACKET16_"&tid&" SET NAME2 = "&TNM12&" WHERE POS = 17" conn.execute(strSQL) Pretty straight forward right?? However, when it is executed I get" [MySQL][ODBC 3.51 Driver][mysqld-5.6.33-log]Unknown column 'Bob' in 'field list' /STARTTOURNEY.ASP...
  16. penguinspeaks

    Undeclared variable error

    Hello. I am hoping is a simple answer to this because I have not come across it before. I have run similar code many times but now getting an error. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver][mysqld-5.6.33-log]Undeclared variable: BRACKET16_73...
  17. penguinspeaks

    Undeclared variable error

    Hello. I am hoping is a simple answer to this because I have not come across it before. I have run similar code many times but now getting an error. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver][mysqld-5.6.33-log]Undeclared variable: BRACKET16_73...
  18. penguinspeaks

    Date woes

    I am not sure if this is an asp issue or mysql so I may post to both. I am combining a date and time to enter into a DATETIME field in mysql database. When I response.write the variable it displays correctly. The issue is it is not getting updated in the database. However, when I response.write...
  19. penguinspeaks

    work with end number

    Hello gang, I hope all is well in your world. I want to be able to work with the end digit in the days of the year, and have an if/then to make it be a nd, st, rd, ect. So it would read "This is the 222nd day of the year." I have the code to get the day of the year using...
  20. penguinspeaks

    if statement going rouge

    My simple statement is not sending to the correct place. here is code: if cStr(rsv) > cStr(dm) then response.redirect "premium2.asp?id="&var1&"" else response.redirect "voucher_success.asp?id="&vid&"" end if just so you know the variables, and I have tested the results are...

Part and Inventory Search

Back
Top