SQLALCHEMY - Not selecting data from table

[jamesaarr]

Hi all,

I thought it best to create a new thread instead of replying to the old one. Basically I'm querying a Postgresql server using SQLAlchemy. The issue I have is that for some reason it's not pulling through any results. Now this issue isn't exactly python related as I've tried it using the query tool on PGAdmin 4 and it also pulls no results.

Data example:

Output:
style_no        style_no_size
12-2408-08    12-2408-08:10
12-2408-08    12-2408-08:20
12-2408-08    12-2408-08:29

The code is running

Output:
select style_no where style_no_size = '12-2408-08:29' 

and it's pulling nothing through, even when I try the opposite.

If anyone can help then I would really appreciate it.

Thanks,
James

[Larz60+]

try: select style_no where style_no_size like '12-2048-08%29';
also: select style_no where style_no_size like '%12-2048-08%';
see if you get a result

[ibreeden]

select style_no where style_no_size = '12-2408-08:29'

Where is the "from" clause? Should there not be "from <tablename>" in the query?

[jamesaarr]

select style_no where style_no_size = '12-2408-08:29'

Where is the "from" clause? Should there not be "from <tablename>" in the query?

Hi,

Yeah I just didn't write the from in on this thread.

I got it fixed in the end by doing:

select data from table where column = '%%data%%';

[Larz60+]

Yeah I just didn't write the from in on this thread.

And I copied your error, sorry