|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
January 9th, 2007, 07:44 AM
|
|||
|
|||
Insert textarea data to mysql text field
hi there,
i tried to insert textarea data to mysql 4.0.26, mysql 5.0.27 but can't succed on that. my code are a.html !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "(URL address blocked: See forum rules)"> <html xmlns="(URL address blocked: See forum rules)"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <form id="form1" name="form1" method="post" action="test.asp"> <label>test <textarea name="test" id="test"></textarea> </label> <p> <label>submit <input type="submit" name="Submit" value="Submit" /> </label> </p> </form> </body> </html> test.asp <% set myConnection = server.createobject("ADODB.connection") myConnection.open "test", "admin", "admin" mySQL ="INSERT INTO test VALUES('"&request.form("test")&"')" Set rs = myConnection.execute(mySQL) rs.Close Set rs = Nothing myConnection.Close Set myConnection = Nothing response.write("Success") Session("type") = NULL %> all the time i got error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /maxfinal/abc/test.asp, line 5 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) Page: POST 26 bytes to /maxfinal/abc/test.asp POST Data: test=asdfasd&Submit=Submit please let me know how can i solve this
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Insert textarea data to mysql text field |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
