On Fri, May 21, 2010 at 2:40 PM, Tim Chase python.l...@tim.thechases.comwrote:
On 05/21/2010 12:31 PM, Victor Subervi wrote:
cursor.execute('insert into Baggage values (Null, %s, %s, %s,
%s)', (flight_id, customer_id, weight, ticket_no))
You're trying to insert stuff...
Christian Heimes wrote:
MRAB wrote:
I think you need to 'commit' any changes to do to the database.
Yeah, you are right.
Also some RDBMS don't support DDL and DML statements inside one
transaction. You may need to commit and begin after the create table DDL.
Christian
Er, yes.
Hi;
When I try to execute this code from my Python script, I get this error:
Traceback (most recent call last):
File
/var/www/html/creative.vi/clients/sea-flight/reservations/create_edit_bags3.py,
line 38, in ?
create_edit_bags3()
File
On 05/21/2010 12:31 PM, Victor Subervi wrote:
cursor.execute('insert into Baggage values (Null, %s, %s, %s,
%s)', (flight_id, customer_id, weight, ticket_no))
You're trying to insert stuff...
OperationalError: (1452, 'Cannot add or update a child row: a foreign
key constraint fails
Hi;
I have this code:
#!/usr/bin/python
import cgitb; cgitb.enable()
import cgi
import sys,os
sys.path.append(os.getcwd())
import MySQLdb
from login import login
def create_edit_passengers4():
print Content-Type: text/html
print
print '''
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0
Victor Subervi wrote:
Hi;
I have this code:
#!/usr/bin/python
import cgitb; cgitb.enable()
import cgi
import sys,os
sys.path.append(os.getcwd())
import MySQLdb
from login import login
def create_edit_passengers4():
print Content-Type: text/html
print
print '''
!DOCTYPE html PUBLIC
MRAB wrote:
I think you need to 'commit' any changes to do to the database.
Yeah, you are right.
Also some RDBMS don't support DDL and DML statements inside one
transaction. You may need to commit and begin after the create table DDL.
Christian
--
On Thu, May 20, 2010 at 12:56 PM, MRAB pyt...@mrabarnett.plus.com wrote:
When performing SQL operations, don't insert the values using Python's
string formatting, because that makes it vulnerable to SQL-injection
attacks, ie don't do this:
cursor.execute(sql_command % values)
do this:
Comments in line...
On Thu, Apr 3, 2008 at 12:35 AM, John Nagle [EMAIL PROTECTED] wrote:
Steve Holden wrote:
Define no longer works.
Sorry. Throws HTTP 200 error.
On Thu, Apr 3, 2008 at 12:35 AM, John Nagle [EMAIL PROTECTED] wrote:
John Nagle wrote:
works fine? Please check again...
En Thu, 03 Apr 2008 09:43:57 -0300, Victor Subervi
[EMAIL PROTECTED] escribió:
Steve Holden wrote:
Define no longer works.
Sorry. Throws HTTP 200 error.
HTTP 200 means OK.
The same remarks I've posted earlier apply here.
Must have missed those. Yes, the code works fine. Repeatedly.
On Thu, Apr 3, 2008 at 9:34 AM, Gabriel Genellina [EMAIL PROTECTED]
wrote:
En Thu, 03 Apr 2008 09:43:57 -0300, Victor Subervi
[EMAIL PROTECTED] escribió:
Steve Holden wrote:
Define no longer works.
Sorry. Throws HTTP 200 error.
HTTP 200 means OK.
Yes. But there is an error somewhere,
En Thu, 03 Apr 2008 14:03:53 -0300, Victor Subervi
[EMAIL PROTECTED] escribió:
On Thu, Apr 3, 2008 at 9:34 AM, Gabriel Genellina
[EMAIL PROTECTED]
wrote:
Thank you. I believe you mean by bound, something like this, right?
binary(picdata)
I am now doing that, if I am not mistaken.
No,
Hi;
I have this code which works fine:
#!/usr/local/bin/python
import _mysql
import MySQLdb, cPickle
host = 'mysqldb2.ehost-services.com'
user = 'user'
passwd = 'pass'
db = 'bre'
print 'Content-Type: image/jpeg\r\n'
print 'htmlbody\nHi!\n'
connection = MySQLdb.connect(host=host, user=user,
Victor Subervi wrote:
Hi;
I have this code which works fine:
#!/usr/local/bin/python
import _mysql
import MySQLdb, cPickle
host = 'mysqldb2.ehost-services.com http://mysqldb2.ehost-services.com'
user = 'user'
passwd = 'pass'
db = 'bre'
print 'Content-Type: image/jpeg\r\n'
print
En Wed, 02 Apr 2008 16:36:43 -0300, Victor Subervi
[EMAIL PROTECTED] escribió:
I have this code which works fine:
works fine? Please check again...
The same remarks I've posted earlier apply here.
print 'Content-Type: image/jpeg\r\n'
print 'htmlbody\nHi!\n'
Don't you see a conflict among
Gabriel Genellina wrote:
En Wed, 02 Apr 2008 16:36:43 -0300, Victor Subervi
[EMAIL PROTECTED] escribió:
I have this code which works fine:
works fine? Please check again...
The same remarks I've posted earlier apply here.
In addition, you're not committing the database update.
You
16 matches
Mail list logo
