Styjun

How to prevent YouTube from showing already watched videos?

How do ultrasonic sensors differentiate between transmitted and received signals?

Can a malicious addon access internet history and such in chrome/firefox?

What should I use for Mishna study?

Organic chemistry Iodoform Reaction

Pronouncing Homer as in modern Greek

Installing PowerShell on 32-bit Kali OS fails

Perfect riffle shuffles

Should my PhD thesis be submitted under my legal name?

Indicating multiple different modes of speech (fantasy language or telepathy)

Lifted its hind leg on or lifted its hind leg towards?

How can I raise concerns with a new DM about XP splitting?

How do I repair my stair bannister?

Simulating a probability of 1 of 2^N with less than N random bits

Teaching indefinite integrals that require special-casing

Can I use my Chinese passport to enter China after I acquired another citizenship?

How will losing mobility of one hand affect my career as a programmer?

Is there an Impartial Brexit Deal comparison site?

Simple image editor tool to draw a simple box/rectangle in an existing image

node command while defining a coordinate in TikZ

Why is delta-v is the most useful quantity for planning space travel?

Is the next prime number always the next number divisible by the current prime number, except for any numbers previously divisible by primes?

How can I successfully establish a nationwide combat training program for a large country?

What does the "3am" section means in manpages?

How to get certain data from a SQL table with an input in python?

How can I prevent SQL injection in PHP?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow can I safely create a nested directory in Python?How to get the current time in PythonHow can I make a time delay in Python?Getting the last element of a list in PythonHow do I get the number of elements in a list in Python?How do I UPDATE from a SELECT in SQL Server?Finding duplicate values in a SQL table

-1

I got this table in Microsoft Access

NAME - GENDER - NUMBER
Jo - Male - 1
Ali - Male - 2
MO - Male - 3

I want to use this input:

question = input("What is your name: ")

I want the user to fill in a name and get the gender and the number as output.

I am a SQL beginner and I am a python beginner.

I use pyodbc.
Can anyone help me how to do this?

Can you also explain why you did what you did?

Many thanks in advance!

This is my code so far:

import pyodbc

conn = pyodbc.connect(r'Driver=Microsoft Access Driver (*.mdb, *.accdb);' +
 r'DBQ=C:UsersGebruikerPycharmProjectsTennisDatabase.accdb;')
gegevens = conn.cursor()

SelectString = 'SELECT NAME, GENDER, NUMBER FROM LIST;'

gegevens.execute(SelectString)
gegevensList = gegevens.fetchall()

print(len(gegevensList), "Teamgegevens : ")

for gegevens in gegevensList:
 print (gegevens)
print('')

python sql ms-access

share|improve this question

edited Mar 21 at 14:51

Josse Lardinois

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What code do you have so far? Without any attempt this question is too broad. You are asking us to write code as well as tutor.
  
  – Andy G
  Mar 21 at 14:47
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is your output? What errors do you get? Where exactly are you stuck?
  
  – Pax Vobiscum
  Mar 21 at 14:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I do not now where to begin
  
  – Josse Lardinois
  Mar 21 at 14:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  With books, courses or tutorials. The question remains too broad. Although, the code you have added seems to indicate that you have progressed further than indicated.
  
  – Andy G
  Mar 21 at 14:56
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have begun, you showed us your code. Where in the code does it give an error? What is your output?
  
  – Pax Vobiscum
  Mar 21 at 15:56
  

  
  
  
  

add a comment | 

-1

I got this table in Microsoft Access

NAME - GENDER - NUMBER
Jo - Male - 1
Ali - Male - 2
MO - Male - 3

I want to use this input:

question = input("What is your name: ")

I want the user to fill in a name and get the gender and the number as output.

I am a SQL beginner and I am a python beginner.

I use pyodbc.
Can anyone help me how to do this?

Can you also explain why you did what you did?

Many thanks in advance!

This is my code so far:

import pyodbc

conn = pyodbc.connect(r'Driver=Microsoft Access Driver (*.mdb, *.accdb);' +
 r'DBQ=C:UsersGebruikerPycharmProjectsTennisDatabase.accdb;')
gegevens = conn.cursor()

SelectString = 'SELECT NAME, GENDER, NUMBER FROM LIST;'

gegevens.execute(SelectString)
gegevensList = gegevens.fetchall()

print(len(gegevensList), "Teamgegevens : ")

for gegevens in gegevensList:
 print (gegevens)
print('')

python sql ms-access

share|improve this question

edited Mar 21 at 14:51

Josse Lardinois

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What code do you have so far? Without any attempt this question is too broad. You are asking us to write code as well as tutor.
  
  – Andy G
  Mar 21 at 14:47
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is your output? What errors do you get? Where exactly are you stuck?
  
  – Pax Vobiscum
  Mar 21 at 14:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I do not now where to begin
  
  – Josse Lardinois
  Mar 21 at 14:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  With books, courses or tutorials. The question remains too broad. Although, the code you have added seems to indicate that you have progressed further than indicated.
  
  – Andy G
  Mar 21 at 14:56
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have begun, you showed us your code. Where in the code does it give an error? What is your output?
  
  – Pax Vobiscum
  Mar 21 at 15:56
  

  
  
  
  

add a comment | 

I got this table in Microsoft Access

NAME - GENDER - NUMBER
Jo - Male - 1
Ali - Male - 2
MO - Male - 3

I want to use this input:

question = input("What is your name: ")

I want the user to fill in a name and get the gender and the number as output.

I am a SQL beginner and I am a python beginner.

I use pyodbc.
Can anyone help me how to do this?

Can you also explain why you did what you did?

Many thanks in advance!

This is my code so far:

import pyodbc

conn = pyodbc.connect(r'Driver=Microsoft Access Driver (*.mdb, *.accdb);' +
 r'DBQ=C:UsersGebruikerPycharmProjectsTennisDatabase.accdb;')
gegevens = conn.cursor()

SelectString = 'SELECT NAME, GENDER, NUMBER FROM LIST;'

gegevens.execute(SelectString)
gegevensList = gegevens.fetchall()

print(len(gegevensList), "Teamgegevens : ")

for gegevens in gegevensList:
 print (gegevens)
print('')

python sql ms-access

share|improve this question

edited Mar 21 at 14:51

Josse Lardinois

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44

NAME - GENDER - NUMBER
Jo - Male - 1
Ali - Male - 2
MO - Male - 3

question = input("What is your name: ")

import pyodbc

conn = pyodbc.connect(r'Driver=Microsoft Access Driver (*.mdb, *.accdb);' +
 r'DBQ=C:UsersGebruikerPycharmProjectsTennisDatabase.accdb;')
gegevens = conn.cursor()

SelectString = 'SELECT NAME, GENDER, NUMBER FROM LIST;'

gegevens.execute(SelectString)
gegevensList = gegevens.fetchall()

print(len(gegevensList), "Teamgegevens : ")

for gegevens in gegevensList:
 print (gegevens)
print('')

share|improve this question

edited Mar 21 at 14:51

Josse Lardinois

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44

share|improve this question

edited Mar 21 at 14:51

Josse Lardinois

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44

asked Mar 21 at 14:46

Josse LardinoisJosse Lardinois

44