form to db insert problem

ASP Free Forums Sponsor:

May 8th, 2002, 03:25 PM

Steve Schofield

Contributing User

ASP Free God 20th Plane (14500 - 14999 posts)

Join Date: Dec 2002

Posts: 14,575

Time spent in forums: < 1 sec
Reputation Power: 22

form to db insert problem

Originally posted by : DC (dcleslie@partners.org) I'm getting a: Error Type: Microsoft JET Database Engine (0x80004005) Field 'Drugs.DrugInteraction' cannot be a zero-length string. /begasp/drugsheets/confirm_insert.asp, line 21 error when inserting into an access database from a form. can anyone help?? I've posted the code below: form page:  <html> <head> <title>Insert Drug Into Drug Database</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#FFFFFF" text="#000000"> Insert Drug into drug information database <form name="insertdrug" method="post" action="confirm_insert.asp"> <table> <tr> <td width="179" height="44">Short Drug Name: </td> <td width="573" height="44"> <input type="text" name="DrugSheets" size="50"> </td> </tr> <tr> <td width="179" height="44">Medical Drug Name: </td> <td width="573" height="44"> <input type="text" name="DrugName" size="50"> </td> </tr> <tr> <td width="179" height="81">Method Given:</td> <td width="573" height="81"> <textarea name="MethodGiven" cols="50" rows="2"></textarea> </td> </tr> <tr> <td width="179" height="92">Purpose of Drug: </td> <td width="573" height="92"> <textarea name="Purpose" cols="50" rows="3"></textarea> </td> </tr> <tr> <td width="179" height="94">Possible Side Effects: </td> <td width="573" height="94"> <textarea name="PossibleEffects" cols="50" rows="3"></textarea> </td> </tr> <tr> <td width="179" height="92">Early Side Effects: </td> <td width="573" height="92"> <textarea name="EarlyEffects" cols="50" rows="3"></textarea> </td> </tr> <tr> <td width="179" height="92">Late Side Effects: </td> <td width="573" height="92"> <textarea name="LateEffects" cols="50" rows="3"></textarea> </td> </tr> <tr> <td width="179" height="96">Special Points to Consider: </td> <td width="573" height="96"> <textarea name="Points" cols="50" rows="3"></textarea> </td> </tr> <tr> <td width="179">Drug Interactions: </td> <td width="573"> <textarea name="DrugInteractions" cols="50" rows="3"></textarea> </td> </tr> <tr> </tr> </table> <input type="submit" name="Submit" value="Insert Drug> <input type="reset" name="Reset" value="Clear Form> </form> </body> </html> confirm_insert.asp page: <%@ Language = "VBScript"%> <% dim conn dim strconn dim strsql strsql = "" strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:datastoresdrugsheets.mdb;" & _ "Persist Security Info=False" strSQL = "INSERT INTO Drugs(DrugSheets, DrugName, MethodGiven, Purpose, PossibleEffects, EarlyEffects, LateEffects, Points, DrugInteraction) Values('" & request("DrugSheets") & "', '" & request("DrugName") & "', '" & request("MethodGiven") & "', '" & request("Purpose") & "', '" & request("PossibleEffects") & "', '" & request("EarlyEffects") & "', '" & request("LateEffects") & "', '" & request("Points") & "', '" & request("DrugInteraction") & "')" set conn = server.createobject("adodb.connection") conn.open strconn conn.execute(strSQL) conn.close set conn = nothing %> <html><head> <title>Confirmation of Insert</title> </head> <body bgcolor="#FFFFFF"> Confirmation of Insert into drug information database <% = "Your record has been added" %> </body> </html>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: