Bablosoft

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

2 issues SQL module

Support

2 Posts 2 Posters 551 Views

M Offline
M Offline
MegAdan
wrote on last edited by

#1
I'm currently experiencing 2 issues with the SQL module:
1. when inserting a new record, i have to insert as ID a zero padded number (ex: 0000001740 ) but the "Data field" has a built in feature that auto converts strings to numbers.
  so it trasform the value from 0000001740 to 1740
2. when using "update single record" or "update multiple records" nothing happens (while "delete single record", "insert records" and "select single record" works )
anyone has any idea/suggestions?
from j to k

G 1 Reply Last reply
0
G Offline
G Offline
GhostZ Bablosoft Team
replied to MegAdan on last edited by

#2
@MegAdan,
1. Install the latest version of the module SQL.zip and disable the Convert data option located in the additional settings.
2. Do not add extra quotes for strings, any value other than variables and resources is treated like a string.
1 Reply Last reply
1

B

"proxy handshake error"/"Failure when receiving data from the peer" when using proxy with Mail Module
Scheduled Pinned Locked Moved Support

0 Votes

2 Posts

407 Views

U

@Bunnz said in "proxy handshake error"/"Failure when receiving data from the peer" when using proxy with Mail Module:

And proxy is working in HTTP request just fine

email ports are disallowed for these proxies.
1

Does anybody have module to interact with google sheets from bus similar to excel module?
Scheduled Pinned Locked Moved Support

0 Votes

1 Posts

277 Views

No one has replied
D

Twitter Data Scraping Issue: Unable to Retrieve Likes Beyond the 21st User
Scheduled Pinned Locked Moved Support

-1 Votes

8 Posts

860 Views

S

@dayyangee said in Twitter Data Scraping Issue: Unable to Retrieve Likes Beyond the 21st User:

As you can see in this picture, I have added loop and also scrolled, but still, I am getting less data.

I cannot see any logic in your picture that shows me that you scrolled before that loop to get the new data loaded.

If you scrolled inside a loop while scraping data and assumed that you would obtain that data within the loop, this logic is incorrect because the HTML DOM has changed, and you need to restart the loop to retrieve the newly loaded data.

You can not parse all data within one loop. You need to have at minimum 2 loops.

While true(loop first) <==
Scrape data with the Start Loop(loop second) from the last point or from the beginning if you are getting it for the first time. Scroll down or click to load new data.<==
Alternatively, you can follow another approach:
Scroll down to the end of the page and wait for all the data to load. Scrape the data with the Start Loop
H

Use SQL connection file in NodeJS in other file
Scheduled Pinned Locked Moved Support

0 Votes

9 Posts

1269 Views

H

@GaG No it wasn't the issue, else is not in parenthesis so it's gonna execute anyway. I know that's not the ideal code :P

P.S- the above guy's solution worked.
R

Change order that parameters sorted in the call function module?
Scheduled Pinned Locked Moved Support

0 Votes

2 Posts

514 Views

T

@Rae you can change this in the module file. (your_function_interface.js)