Jump to content

smus

Members
  • Posts

    177
  • Joined

  • Last visited

Everything posted by smus

  1. smus

    W3 Buttons

    Really? Would be very glad if you provide links to the full version. Thanks in advance!
  2. I need two submit buttons in my form, first is going to show result in the same tab and another one is in another one. <submit target="_blank"> is not correct. <target="_blank"> is for <form> tag, right?
  3. smus

    W3 Buttons

    Yes, sure, I am using W3 for quite a while. The buttons have all the effects aside from this one.
  4. smus

    W3 Buttons

    When I'm using W3 button with hover property, for example: <button class="w3-yellow w3-hover-blue">button</button> locally, there is no hover effect at all (i.e no color changing). Why that might happen? Oh, sorry, please move the topic to the CSS thread
  5. smus

    "Insert into" query

    You are right, it is difficult to define it without the context. I took this sample code from one of the tutorials and adjusted it for my simple needs. Now as we can see from the code below there are double object creations there. I am also not sure why there is the second RecordSet creation here: Dim adoCon, strCon, sco, SQLStatement Set adoCon = Server.CreateObject("ADODB.Connection") strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\wwwroot\msaccess.mdb;" 'Set the connection string to the database adoCon.connectionstring = strCon 'Set an active connection to the Connection object adoCon.Open 'Initialise the main ADO recordset object Set sco = Server.CreateObject("ADODB.Recordset") This code was initially previous to the code I copied at the beginning of this topic.
  6. How to add smoothness to 'Back to top' scroll using classic JS (without jQuery)?
  7. smus

    "Insert into" query

    I don't know, the code worked well with this object, but it looks like it is not needed in this context
  8. smus

    "Insert into" query

    sco.Open SQLStatement, adoCon, 3, 3 What do 3, 3 numbers mean in this expression?
  9. smus

    "Insert into" query

    Cannot add even with addNew method: one of the variables is not added to the table, while others are inserted
  10. smus

    "Insert into" query

    How to add some data to DB using "Insert into" query. I now use AddNew and Update with "Select from": Dim adoCon, strCon, sco, SQLStatement Set adoCon = Server.CreateObject("ADODB.Connection") SQLStatement = "SELECT * FROM table" sco.Open SQLStatement, adoCon, 3, 3 sco.AddNew "string", info sco.Update But I need 'Insert into' to be executed
  11. smus

    Node.js + MongoDB

    I've no idea where to configure an address of the db folder. I've installed node.js using Windows installer (from *.msi file). But MongoDB has been installed manually from zip file.
  12. smus

    Node.js + MongoDB

    No, I didn't install it. Now after npm install and npm install mongodb, npm start shows connection errors with mongodb - failed to connect to a server localhost:27017
  13. smus

    Node.js + MongoDB

    Running as an admin: npm install mongodb - without errors npm start - the same error
  14. smus

    Node.js + MongoDB

    Exactly! When I type "npm start" - this is the number of line in module.js file. There goes "Cannot find module 'express'" and then the same errors like in the previous message.
  15. I'm new to Node.js and MongoDB. I can't run Mongo on Node as it is explained here in w3 reference. There's an error 471 when I run 'node install mongodb'
  16. But hypothetically, if we take, for example, time constant from PHP that contains fixed date and time value, then set an interval and place it to a "perpetual" cycle - we will be able to make it, isn't that possible? Or it is too complicated?
  17. I know, it's pretty common question, but I wonder if there is a way to schedule a PHP script to be executed periodically (with some intervals) without using server utilities, such as Cron?
  18. I need to create a search in a field where there are several delimiters, such as commas, brackets and slashes. I used FIND_IN_SET parameter when there was just single commas, but it doesn't find a substring when I add more delimiters as a search rule: SELECT * FROM field WHERE FIND_IN_SET ($searchquery, searchfield) > 0 SELECT * FROM field WHERE FIND_IN_SET ($searchquery, REPLACE(searchfield, '\', '')) > 0 I've connected the second query to the first using OR
  19. Thank you, dsonesuk! The main thing is that it works! Your information was very helpful, especially in 9th post. Appreciate your help!
  20. Thanks again! Your version is good, but I've decided instead to correct some HTML display while request is processing, to simplify the task. Now there's an additional <td> </td> after each informational <td> (even at the end of a row). And my script removes the last <td> before the array reversal and after it adds new <td> at the end of the table(so that the table will have the same view if you toggle it once again). There are just <td> </td> filling the rest of the space in case if there are 2 results. I think I have to somehow add fixed width to them or give <tbody> 66% of width of the table.
  21. Thank you very much! It works well, but there is a mistake with HTML display. It turned, the table structure is a bit more complicated: there's an additional <td> </td> between the main td's (td's that hold an information), so when, for example, number of results equal 6, the overall number of td's is 10: <table> <tr><td>1</td><td> </td><td>2</td><td> </td><td>3</td></tr> <tr><td>4</td><td> </td><td>5</td><td> </td><td>6</td></tr> </table> But when the row is not full, there is an additional <td> </td> at the end of it (9 td's instead of 8): <table> <tr><td>1</td><td> </td><td>2</td><td> </td><td>3</td></tr> <tr><td>4</td><td> </td><td>5</td><td> </td></tr> </table> So it looks not right when I reverse it. I guess, I would need somehow to exclude the last td, if the tr contains less than 3 td. I can apply to main td via class(".td"), so I'm not sure if this code would work: if ($(".td").len % 3 <> 0) { $("table.td:last").empty(); }
  22. In order not to reload a page and send another query to the server
  23. Right, I just wanted to know if it's possible (using JS or JQuery). The task is slightly different: I'm showing the results in a table with a random number of <td>s, depending on the query; there are 3 <td>s in each <tr>. I need to reverse the order of <td>s in this table without sending additional queries. The initial order is: <table> <tr><td>1</td><td>2</td><td>3</td></tr> <tr><td>4</td><td>5</td><td>6</td></tr> </table> I need: <table> <tr><td>6</td><td>5</td><td>4</td></tr> <tr><td>3</td><td>2</td><td>1</td></tr> </table>
  24. Allow me to ask more theoretic question: for example, I've got usual PHP+MySQL search that gets some information from database. I've typed some searching values, submitted the form and got some results. Now I need to sort them onclick, for instance, alphabetically, not repeating mysql-query to the server (on client side), is it possible to make it simply using JavaScript (not AJAX)?
×
×
  • Create New...