• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About smus

  • Rank
  1. 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.
  2. How to add smoothness to 'Back to top' scroll using classic JS (without jQuery)?
  3. I don't know, the code worked well with this object, but it looks like it is not needed in this context
  4. sco.Open SQLStatement, adoCon, 3, 3 What do 3, 3 numbers mean in this expression?
  5. Cannot add even with addNew method: one of the variables is not added to the table, while others are inserted
  6. 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
  7. 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.
  8. 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
  9. Running as an admin: npm install mongodb - without errors npm start - the same error
  10. 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.
  11. 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'
  12. 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?
  13. 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?
  14. 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