nt to screen
in mysql itself?
TIA,
V
On Wed, Sep 2, 2009 at 10:18 AM, Emile van Sebille wrote:
> On 9/2/2009 3:43 AM Victor Subervi said...
>
>> Hi:
>> I have the following python code:
>> import os
>> os.system("mysqldump -u root -pPASSWORD --opt spreadsheets >
11:48 AM, Nitebirdz wrote:
> On Wed, Sep 02, 2009 at 08:43:22AM -0400, Victor Subervi wrote:
> >
> > Obviously I'm sure. It created the file. But the file was blank. How can
> I
> > do a mysqldump in mysql itself?
> >
>
> As I said, I only got a blank file
hury wrote:
> I tried running the mysqldump command
>> from the python prompt
>>
>
> I think you were being asked to try running it from the command prompt
> (cmd.exe) -- it won't work from the Python prompt, of course.
>
>
> On Wed, 02 Sep 2009 10:50:55 -0700, V
Hi:
I have this code:
try:
cursor.execute('select salesperson, office, cell, fax, home, email,
assistant from general where salesperson="%s";' % (catch))
stuff = cursor.fetchone()
test = raw_input('You have selected salesperson %s. Is that correct? (hit
\'enter\' for affirmative, enter anyt
Thu, Sep 3, 2009 at 1:42 PM, Dennis Lee Bieber wrote:
> On Wed, 2 Sep 2009 16:45:02 -0400, Victor Subervi
> declaimed the following in
> gmane.comp.python.general:
>
> > I tried running it like you said, got this error:
> > 'mysqldump' is not a recognized inter
Hi;
Search engines don't like dynamic links. I like to pass at least browser
information from page to page to make pages display properly. Spiders
couldn't care less about asthetics, so that wouldn't matter to them. But
passing something like *.com?browser=IE5 trips the spider up. Is there a way
to
properly.
>>
>
> What kind of web framework are you using? Most allow you to access the HTTP
> headers sent with a request -- in this case, what you'd be after is the
> 'User-Agent' header.
>
>
> On Wed, 16 Sep 2009 16:21:41 -0700, Victor Subervi <
> victor
Session variables, yes. That is what I need. Thanks,
V
On Thu, Sep 17, 2009 at 11:46 AM, Carsten Haese wrote:
> Victor Subervi wrote:
> > Right. Bad example on my part. How about if I want to pass a cookie from
> > page to page? Or some data called up from a database query?
>
Hi;
I have the following code:
while i < num:
cat = 'cat' + str(i)
cat = form.getfirst(cat, '')
item = 'item' + str(i)
item = form.getfirst(item, '')
descr = 'descr' + str(i)
descr = form.getfirst(descr, '')
uom = 'uom' + str(i)
uom = form.getfi
Yeah, that was the problem..."num" was a string ;) Just caught it myself,
too. Thanks,
V
On Sun, Sep 20, 2009 at 2:37 PM, Philip Semanchuk wrote:
>
> On Sep 20, 2009, at 2:25 PM, Victor Subervi wrote:
>
> Hi;
>> I have the following code:
>>
>>w
Hi;
I have a dynamic form in which I do the following:
1) Request two fields (company name, number of entries). That is sent back
to the form.
2) If the two fields are not None, the form requests other data. That, too,
is sent back to the form.
3) That new data is then entered into a MySQL table.
T
'\n'
print "Company Name: \n" % (company)
if num == 0:
print "How many rows of products shall we include? \n"
else:
print "\n"
print "\n" % (num)
i = 0
while i < num:
print '\n'
print "Category: \n" % (str(i))
ot;
if flag == '':
print """
Company Name:
"""
else:
host = 'h'
db = 'db'
user = 'u'
passwd = '1'
database = MySQLdb.connect(host, user, passwd, db)
cursor = database.curso
Hi;
I have this code:
cursor.execute('describe products;')
cols = [item[0] for item in cursor]
cols = cols.reverse()
cols.append('Delete')
cols = cols.reverse()
Unfortunately, the list doesn't reverse. If I print cols after the first
reverse(), it prints None. Please advise. Also, is th
On Wed, Sep 1, 2010 at 9:17 AM, Shashank Singh <
shashank.sunny.si...@gmail.com> wrote:
> reverse reverses in-place
>
> >>> l = [1, 2, 3]
> >>> r = l.reverse()
> >>> r is None
> True
> >>> l
> [3, 2, 1]
> >>>
>
Ah. Thanks!
beno
--
http://mail.python.org/mailman/listinfo/python-list
Hi;
I have this code:
print 'select * from spreadsheets s join products p on p.Item=s.Item
join productsCategories pc on p.ID=pc.ProductsID join categories c on
pc.CategoryID=c.ID where s.Client="%s" order by c.Category, c.Parent' %
(client,)
cursor.execute('select * from spreadsheets s jo
On Wed, Sep 1, 2010 at 9:26 AM, Shashwat Anand wrote:
>
>
> On Wed, Sep 1, 2010 at 6:45 PM, Matt Saxton wrote:
>
>> On Wed, 1 Sep 2010 09:00:03 -0400
>> Victor Subervi wrote:
>>
>> > Hi;
>> > I have this code:
>> >
>> > curso
On Thu, Sep 2, 2010 at 3:02 PM, Ian wrote:
> On 02/09/2010 19:34, Victor Subervi wrote:
>
>> for some reason running the command through python *omits* this one data!!
>> The only difference is that a flag in spreadsheets (Temp) is set to 1. Why
>> on earth doesn't
This is an addendum to my last post. Please observe the following:
mysql> select * from spreadsheets where Temp=1;
+-++---+-++--+
| ID | Client | Multi | Item| Markup | Temp |
+-++---+-++--
On Fri, Sep 3, 2010 at 9:25 AM, Richard Arts wrote:
> These are also mere suggestions.
>
> The statements you use in your print statement and the one you use to
> feed the cursor differ slightly. The latter is missing quotes around
> your search criterium.
>
> Isn't it possible to fetch results r
Hi;
I have this code:
cursor.execute('insert into Passengers values (Null, %s, %s, %s, %s,
%s, %s, %s, %s, "no", "n/a")', (curr_flight, curr_customer, name, curr_sex,
curr_weight, price, curr_rt, curr_confirmation))
Now, when I print it out, add quotes where necessary and enter it in at a
| 1 | '' | NULL | NULL | 0.00
| 0 | 12345| NULL | NULL |
| 15 | 1 | 1 | Dr. Mengela | Male |155 | 0.00
|100 | 654 | no | n/a |
+----++-+-+--++---++--+---
I rebooted MySQL and it now works fine ;)
On Fri, Sep 17, 2010 at 9:26 AM, Victor Subervi wrote:
> Here's some more data:
>
> print 'insert into Passengers values (Null, %s, %s, %s, %s, %s, %s,
> %s, %s, "no", "n/a")' % (curr_flight, curr
501 - 523 of 523 matches
Mail list logo
