169 questions
0
votes
0
answers
38
views
Do files on remote server exist?
I have a database of 1000 events. Each event has an entity code 1..1000. Each event may or may not have an associated .jpg file, which is stored on a remote server. If it exists, it is named nnnn....
0
votes
0
answers
477
views
pymssql, fetchall for table with many colnames couse error: (20047, b'DB-Lib error message 20047, severity 9:\nDBPROCESS is dead or not enabled\n')
I call pymssql, fetchall for table "CDN.Kontrahenci", and where I enter many columns names, as:
"Knt_KntId,Knt_Kod,Knt_Nazwa1,Knt_Nazwa2,Knt_Nazwa3,Knt_Kraj,Knt_Wojewodztwo,Knt_Ulica,...
1
vote
1
answer
70
views
PHP PDO fetchAll only returning result on localhost
Ok I'm hoping someone can help me past this and I think it's gotta be something simple. I'm building a website using Apache, PHP, and MySQL. The code runs great on localhost, but not when I make a ...
- 11
0
votes
0
answers
372
views
Python. pymssql.fetchall() performance slows down when using Thread, threading
I have a problem that I just can't solve on my own.
There is a Python script that looks something like:
from threading import Thread
import threading
import pymssql
lock = threading.Lock()
global_list ...
- 3
0
votes
1
answer
74
views
Why fetchall always results none?
I just need help to solve this, when I execute my code, the result of the fetchall is 'None', but these are the expected results
(https://i.sstatic.net/OZL5R.png)
this is my code
def verificar_saldo(...
1
vote
1
answer
546
views
How to only take 1 value in one row in fetchall()
Is there any way to take 1 value in fetchall() without displaying the other values?
import mysql.connector
import hashlib
#connect to database
cnx = mysql.connector.connect(
host = '127.0.0.1',
...
- 13
0
votes
0
answers
113
views
PHP fetchAll() returning empty array
I have a prepared query with 3 result sets. I used fetch() for the first two since they only have one row each and they are appearing correctly in the View. For the 3rd result set, it consists of ...
- 13
1
vote
2
answers
312
views
Is combining FETCH_OBJ And FETCH_ASSOC in PDO fetchAll() possible?
I am trying to migrate from mysqli procedural to PDO because my website was halfway, half in pdo, and the rest in mysqli procedural, now I want to shift to PDO completely. Here is an example of the ...
0
votes
0
answers
1k
views
aiogram, fetch all from database and message in telegram bot by 5 rows with labeks
Good day,Everyone
I am trying to build a telegram bot that fetchs all rows from database and shows message by 5 rows in tg bot with next page inline_keybord
here is my code
from aiogram import Bot, ...
- 98
0
votes
2
answers
5k
views
must be compatible with PDOStatement::fetchAll(int $mode = PDO::FETCH_DEFAULT, mixed ...$args)
Our client has a drupal website, but the host has forced all clients from PHP 7.4 to PHP version 8, causing a PDO fatal error preventing the site from loading.
Error Received:
Fatal error: ...
- 29
0
votes
1
answer
344
views
Fetching data in Jupyter Notebook is taking too long
I want to fetch all rows from a table, using the following code:
table_row_count = 1000000
batch_size = 10000
sql = """SELECT t.*
FROM (
SELECT ROWNUM AS row_num,
sub_t.*...
- 33
0
votes
0
answers
91
views
Making Messagebox show results
(using python) In my section "Def display_record():" I can not get the messagebox.showinfo(results) to pop up and show the result.
The error I get is "Expected type 'str | None', got '...
- 9
1
vote
1
answer
3k
views
Snowflake python connector error when fetching data - SSLError: HTTPSConnectionPool
I was able to connect to the Snowflacke database and ran queries in Python via Snowflake python connector.
The problem was when I was fetching data by cursor.fetch(), it gave me this error when I did ...
- 11
0
votes
1
answer
129
views
Fetchall() is excluding one row which is stored in fetchrow()
I am trying to create a code where i would get all the rows from the existing table if the condition matches otherwise return "Record is not there". Below fetchall() excludes one row which ...
0
votes
0
answers
15
views
Fatal error: Uncaught Error: Call to a member function fetchAll() [duplicate]
I know this question has been asked before but the answers found don't help me to find why my code is not working.
I specify that I use WAMP under Windows, that the name of my database is "myapp&...
- 33