smus

Members
  • Content count

    69
  • Joined

  • Last visited

Community Reputation

0 Neutral

About smus

  • Rank
    Newbie
  1. sco.Open SQLStatement, adoCon, 3, 3 What do 3, 3 numbers mean in this expression?
  2. Cannot add even with addNew method: one of the variables is not added to the table, while others are inserted
  3. 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
  4. 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.
  5. 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
  6. Running as an admin: npm install mongodb - without errors npm start - the same error
  7. 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.
  8. 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'
  9. 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?
  10. 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?
  11. 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
  12. Thank you, dsonesuk! The main thing is that it works! Your information was very helpful, especially in 9th post. Appreciate your help!
  13. 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.
  14. 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(); }