Hi Everybody...<br>
<br>
I have a query that works as follows:<br>
<br>
<div style="margin: 5px 20px 20px;">
        <div class="smallfont" style="margin-bottom: 2px;">Code:</div>
        <pre class="alt2" dir="ltr" style="border: 1px inset ; margin: 0px; padding: 6px; overflow: auto; width: 480px; max-width: 480px; height: 114px; text-align: left;">db.query("""SELECT traveler.travelerFirstName,vaccine.vaccineName from<br>
(traveler INNER JOIN takenvaccine ON traveler.travelerID = takenvaccine.travelerID)<br>        INNER JOIN vaccine ON takenvaccine.vaccineID=vaccine.vaccineID<br>        INNER JOIN requiredvaccine ON vaccine.vaccineID=requiredvaccine.requiredvaccineID<br>
        INNER JOIN city ON requiredvaccine.cityID = city.cityID<br>WHERE traveler.travelerFirstName = 'John'""")</pre>
</div>The output gives me all vaccines taken by a given employee. To
allow the user to choose different names when running the system, I am
trying to use a variable, named <i><b>person</b></i>:<br>
<br>
<div style="margin: 5px 20px 20px;">
        <div class="smallfont" style="margin-bottom: 2px;">Code:</div>
        <pre class="alt2" dir="ltr" style="border: 1px inset ; margin: 0px; padding: 6px; overflow: auto; width: 480px; max-width: 480px; height: 146px; text-align: left;">person = "John"<br><br>db.query("""SELECT traveler.travelerFirstName,vaccine.vaccineName from<br>
(traveler INNER JOIN takenvaccine ON traveler.travelerID = takenvaccine.travelerID)<br>        INNER JOIN vaccine ON takenvaccine.vaccineID=vaccine.vaccineID<br>        INNER JOIN requiredvaccine ON vaccine.vaccineID=requiredvaccine.requiredvaccineID<br>
        INNER JOIN city ON requiredvaccine.cityID = city.cityID<br>WHERE traveler.travelerFirstName = 'person'""")</pre>
</div>Then I run the query inside my python program. The first version without variable works fine. <img src="http://www.sitepoint.com/forums/images/smilies/smiles2/rofl.gif" alt="" title="ROFL" class="inlineimg" border="0"> But the second, using variable, doesn't give me any output. <img src="http://www.sitepoint.com/forums/images/smilies/bawling.gif" alt="" title="Bawling" class="inlineimg" border="0"> What I am missing here about the python variable sintaxe to make the MySQL work with variable <img src="http://www.sitepoint.com/forums/images/smilies/smiles2/juggle-new.gif" alt="" title="Juggle" class="inlineimg" border="0">... Any suggestion?<br>

<br>
All comments or suggestions are highly appreciated! <img src="http://www.sitepoint.com/forums/images/smilies/smiles2/biggrin.gif" alt="" title="Big Grin" class="inlineimg" border="0"> <img src="http://www.sitepoint.com/forums/images/smilies/smiles2/biggrin.gif" alt="" title="Big Grin" class="inlineimg" border="0"> <img src="http://www.sitepoint.com/forums/images/smilies/smiles2/biggrin.gif" alt="" title="Big Grin" class="inlineimg" border="0"><br>
<br>Threader<br>