Like the error says, row is a tuple, so you can't do row["pool_number"]. You need to use the index: row[0].
result = await cur.execute("SELECT balance FROM profile WHERE uid=%s", user.id)
row = await cur.fetchall()
if result == 1:
return row[0]The powershell thing worked! Thank you so much!
VCRUNTIME140.dll' 14.12 is not compatible with this PHP build linked with 14.29pyinstaller и os.system используют несовместимый VCRUNTIME140.dll.
CREATE TABLE TestGETDATE (
[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[Value] VARCHAR (50) NULL,
[Data_create] DATETIME NULL DEFAULT GETDATE(),
[Updated_at] DATETIME NULL)
GO
CREATE OR ALTER TRIGGER TestGETDATEUpdate ON TestGETDATE FOR UPDATE AS
BEGIN
UPDATE TestGETDATE
SET Updated_at = GETDATE()
WHERE ID IN ( SELECT ID FROM Inserted )
END
GOSELECT 1, * FROM products WHERE name LIKE '%что-то%'
UNION
SELECT 2, * FROM products WHERE description LIKE '%что-то%'
AND NOT name LIKE '%что-то%'
ORDER BY 1код короче и без тире
SELECT LEFT(REPLACE(CONVERT(varchar(255), NEWID()),'-',''),20)SELECT dbo.IntToAlpha( 1136572 )cmriiCREATE OR ALTER FUNCTION dbo.IntToAlpha ( @IN INT ) RETURNS VARCHAR(16)
WITH EXECUTE AS CALLER
AS
BEGIN
DECLARE @ST VARCHAR(16) = ''
WHILE @IN > 0 BEGIN
SET @ST = CHAR((@IN % 26) + 97 ) + @ST
SET @IN = @IN / 26
END
RETURN @ST
END
--
GOCREATE TABLE TestGUID (
ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT NEWID(),
Name VARCHAR (50) NOT NULL )