no mistake but i didnt get what i want (with python module pymssqlsend information to the mssql)

[gdyren]

the code is below:
import pymssql
conn = pymssql.connect (host = "121.198.126.23 3",user = "xxxx",pass word
= "xxxx",data base = "test")
print "connecting success"
cursor = conn.cursor()
cursor.execute( "insert into bbs_test values(%s,%s,%s ,%s,%s)",
("1","nju","9:1 3","ustc","test "))
cursor.close()
conn.close()
in the idle:
connecting success

then i get into the database :test and find that there is nothing in
the table bbs_test.
i don't know why

[Peter Otten]

gd****@gmail.co m wrote:

the code is below:
import pymssql
conn = pymssql.connect (host = "121.198.126.23 3",user = "xxxx",pass word
= "xxxx",data base = "test")
print "connecting success"
cursor = conn.cursor()
cursor.execute( "insert into bbs_test values(%s,%s,%s ,%s,%s)",
("1","nju","9:1 3","ustc","test "))
cursor.close()
conn.close()
in the idle:
connecting success

then i get into the database :test and find that there is nothing in
the table bbs_test.
i don't know why

Because you did not commit your changes with conn.commit().

Peter

[gdyren]

On 10ÔÂ17ÈÕ, ÏÂÎç6ʱ41·Ö, Peter Otten <__pete...@web. dewrote:

[e-mail] m wrote:

the code is below:
import pymssql
conn = pymssql.connect (host = "121.198.126.23 3",user = "xxxx",pass word
= "xxxx",data base = "test")
print "connecting success"
cursor = conn.cursor()
cursor.execute( "insert into bbs_test values(%s,%s,%s ,%s,%s)",
("1","nju","9:1 3","ustc","test "))
cursor.close()
conn.close()
in the idle:
connecting success

then i get into the database :test and find that there is nothing in
the table bbs_test.
i don't know why

Because you did not commit your changes with conn.commit().

Peter- Òþ²Ø±»ÒýÓÃÎÄ×Ö -

- ÏÔʾÒýÓõÄÎÄ×Ö -

???how to.

[gdyren]

On 10ÔÂ17ÈÕ, ÏÂÎç6ʱ41·Ö, Peter Otten <__pete...@web. dewrote:

[e-mail] m wrote:

the code is below:
import pymssql
conn = pymssql.connect (host = "121.198.126.23 3",user = "xxxx",pass word
= "xxxx",data base = "test")
print "connecting success"
cursor = conn.cursor()
cursor.execute( "insert into bbs_test values(%s,%s,%s ,%s,%s)",
("1","nju","9:1 3","ustc","test "))
cursor.close()
conn.close()
in the idle:
connecting success

then i get into the database :test and find that there is nothing in
the table bbs_test.
i don't know why

Because you did not commit your changes with conn.commit().

Peter- Òþ²Ø±»ÒýÓÃÎÄ×Ö -

- ÏÔʾÒýÓõÄÎÄ×Ö -

thank you . I know how .

[Peter Otten]

gd****@gmail.co m wrote:

On 10月17日, 下�6时41分 , Peter Otten <__pete...@web. dewrote:

>gdy...@gmail.c om wrote:

the code is below:
import pymssql
conn = pymssql.connect (host = "121.198.126.23 3",user = "xxxx",pass word
= "xxxx",data base = "test")
print "connecting success"
cursor = conn.cursor()
cursor.execute( "insert into bbs_test values(%s,%s,%s ,%s,%s)",
("1","nju","9:1 3","ustc","test "))
cursor.close()

conn.commit() # This makes the inserted record permanent

conn.close()
in the idle:
connecting success

then i get into the database :test and find that there is nothing in
the table bbs_test.
i don't know why

Because you did not commit your changes with conn.commit().

???how to.

Call conn.commit() before conn.close() like shown above.

Peter