Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: PySimpleGUI Try Except
Post: RE: PySimpleGUI Try Except

Hi all, I found the solution in the end : try: imageView['imageview'].update(filename = (r'your path\\yourimage'+".jpg")) while True: event,...
jamesaarr GUI 1 1,905 Nov-18-2021, 02:02 PM
    Thread: PySimpleGUI Try Except
Post: PySimpleGUI Try Except

Hi all, I'm trying to get my program to try to make a layout with an sg.Image element, however the file path is a variable so it can update the image in the window based on the user input. However I ...
jamesaarr GUI 1 1,905 Nov-18-2021, 01:37 PM
    Thread: Flask dynamic data ?
Post: RE: Flask dynamic data ?

(Nov-15-2021, 01:19 PM)buran Wrote: (Nov-15-2021, 09:47 AM)jamesaarr Wrote: Your flask site will just update as it is refreshed in the client's browser.That's exactly what OP is trying to avoid - ...
jamesaarr General Coding Help 10 6,958 Nov-15-2021, 01:57 PM
    Thread: SQL Query is not executing WHERE clause
Post: RE: SQL Query is not executing WHERE clause

(Nov-15-2021, 11:44 AM)ibreeden Wrote: Hi @hammer, I don't see 'Hermas' in your code but I think it is string data to be selected. First something about syntax: string data must be in single quotes....
jamesaarr General Coding Help 7 2,275 Nov-15-2021, 01:00 PM
    Thread: Flask dynamic data ?
Post: RE: Flask dynamic data ?

Hi all, Another way you can do this is in Flask itself. If you set it up so your Flask program says something like: from flask import Flask #import your date/time module however you like,my choice m...
jamesaarr General Coding Help 10 6,958 Nov-15-2021, 09:47 AM
    Thread: SQL Query is not executing WHERE clause
Post: RE: SQL Query is not executing WHERE clause

Hi mate, there are two possible causes that I can think of that are causing the above errors. Try something similar to the below, but look at bobby tables as suggested above to make sure it's protecte...
jamesaarr General Coding Help 7 2,275 Nov-15-2021, 09:40 AM
    Thread: simple html page with update data
Post: RE: simple html page with update data

Flask is 100% the best go to here. If you do something such as: from flask import Flask app = Flask(__name__) @app.route('/') def home(): a = 100 + 100 return aThen that will show 200 on yo...
jamesaarr General Coding Help 3 2,587 Nov-15-2021, 09:31 AM
    Thread: how to use 3 variables python loop
Post: RE: how to use 3 variables python loop

Also which task are you looking at on Github? I am struggling to understand the outcome you want. Could you rephrase the question or provide an example of the correct output? Thanks James
jamesaarr General Coding Help 2 1,632 Nov-12-2021, 11:43 AM
    Thread: how to use 3 variables python loop
Post: RE: how to use 3 variables python loop

What module are you using to query SQL?
jamesaarr General Coding Help 2 1,632 Nov-12-2021, 11:32 AM
    Thread: SQLALCHEMY - Column doesn't exist
Post: RE: SQLALCHEMY - Column doesn't exist

(Nov-02-2021, 11:20 AM)buran Wrote: (Nov-02-2021, 08:43 AM)jamesaarr Wrote: the page's role is to dynamically display data.I still think you don't understand. How does it display data dynamically,...
jamesaarr General Coding Help 9 7,437 Nov-03-2021, 10:10 AM
    Thread: SQLALCHEMY - Not selecting data from table
Post: RE: SQLALCHEMY - Not selecting data from table

(Nov-02-2021, 08:24 AM)ibreeden Wrote: (Nov-01-2021, 11:39 AM)jamesaarr Wrote: select style_no where style_no_size = '12-2408-08:29'Where is the "from" clause? Should there not be "from <tablen...
jamesaarr General Coding Help 4 2,178 Nov-02-2021, 08:45 AM
    Thread: SQLALCHEMY - Column doesn't exist
Post: RE: SQLALCHEMY - Column doesn't exist

(Nov-01-2021, 02:00 PM)buran Wrote: The vulnerability that @ndc85430 mentions has nothing to do with closing connection before returning anything to frontend. Assuming you run query based on some qu...
jamesaarr General Coding Help 9 7,437 Nov-02-2021, 08:43 AM
    Thread: SQLALCHEMY - Column doesn't exist
Post: RE: SQLALCHEMY - Column doesn't exist

(Nov-01-2021, 12:45 PM)ndc85430 Wrote: You also shouldn't be concatenating strings to build SQL statements, as that's vulnerable to SQL injection. Bobby Tables can educate you on this. Hi there, I ...
jamesaarr General Coding Help 9 7,437 Nov-01-2021, 12:59 PM
    Thread: SQLALCHEMY - Not selecting data from table
Post: SQLALCHEMY - Not selecting data from table

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 pu...
jamesaarr General Coding Help 4 2,178 Nov-01-2021, 11:39 AM
    Thread: SQLALCHEMY - Column doesn't exist
Post: RE: SQLALCHEMY - Column doesn't exist

Figured out a fix - if I put the column names in quotes then it works fine. Thanks, James
jamesaarr General Coding Help 9 7,437 Nov-01-2021, 10:51 AM
    Thread: SQLALCHEMY - Column doesn't exist
Post: SQLALCHEMY - Column doesn't exist

Hi all, Very simple issue - code in question is: for data in engine.execute('select style_no from data where style_size_no_in = "' +myVariable[0] + '"'): print(x) The below error is being flagg...
jamesaarr General Coding Help 9 7,437 Nov-01-2021, 10:35 AM
    Thread: Heroku Error H10
Post: RE: Heroku Error H10

Hello, Fixed the issue, in my flask code it was trying to import a module that wasnt there. Further to this the procfile was looking at the wrong thing. It should have said "web: gunicorn --bind 0.0....
jamesaarr Web Scraping & Web Development 1 1,979 Oct-21-2021, 03:43 PM
    Thread: Heroku Error H10
Post: Heroku Error H10

Hi all, My flask app is crashing constantly with this error. Files are: app name on heroku settings is: "obscure-citadel-40024" basic flask app(flasktest.py) Procfile (Named "Procfile") web: gunic...
jamesaarr Web Scraping & Web Development 1 1,979 Oct-21-2021, 03:27 PM
    Thread: PySimpleGUI Bugging out
Post: RE: PySimpleGUI Bugging out

Hello, me again! I've taken on-board your advice and have begun redesigning the program. What do you think of below? There are still some global variables and I still have to destroy and recreate so...
jamesaarr GUI 9 5,135 Sep-29-2021, 10:47 AM
    Thread: PySimpleGUI Bugging out
Post: RE: PySimpleGUI Bugging out

(Sep-23-2021, 12:57 PM)deanhystad Wrote: I played around with your code. It is an, um, er, interesting approach. I would never have come up with the idea of destroying and re-creating windows just...
jamesaarr GUI 9 5,135 Sep-23-2021, 01:47 PM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020