Hi

Please help me to write an insert statement.



if (request.querystring("mode")= "insert" and

Request.Form("dowork")="insert") then		

		  			sqlup = ""

		  		    sqlup = "insert into

ari.nc_sftyplan_altcontacts "

		  		    sqlup = sqlup & "

(l_name,address,city,state,zip,telno,email,fax)" 

		  		     sqlup = sqlup & " values("  

					 sqlup  = sqlup  & "f_name = '" &

Request.Form("l_name") & "', "

					 sqlup  = sqlup  & "address = '" &

Request.Form("address") & "', "

					 sqlup  = sqlup  & "city = '"  &

Request.Form("city") & "', "

					 sqlup  = sqlup  & "state = '" &

Request.Form("state") & "', "

					 sqlup  = sqlup  & "zip = '" &

Request.Form("zip") & "', "

					 sqlup  = sqlup  & "telno = '" &

Request.Form("telno") & "', "

					 sqlup  = sqlup  & "email = '" &

Request.Form("email") & "', "

					 sqlup  = sqlup  & "fax = '" &

Request.Form("fax") & "') "

					 'sqlup = sqlup & " WHERE client 

'" & Request.QueryString("clientid") & "'"

				     'sqlup = sqlup & " AND division = '" &

Request.QueryString("group")& "'"

				     'sqlup = sqlup & " AND service_type 

'" & Request.QueryString("service") & "'"

					

					Response.Write (sqlup)

			

			set objCmd = Server.CreateObject("ADODB.Command")

			objCmd.ActiveConnection=objConn

			objCmd.CommandType=adCmdText

			objCmd.CommandText=sqlup

			'objCmd.Execute



---

You are currently subscribed to aspx as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-aspx-$subst('Recip.MemberIDChar')@p2p.wrox.com

This is a multi-part message in MIME format.



------=_NextPart_000_000B_01C065B3.A0A08680

Content-Type: text/plain;

	charset="x-user-defined"

Content-Transfer-Encoding: quoted-printable



Hi ,



     Here is the insert statemment. To return an double quotes we have 

to join two double quotes.Following is the example.



sqlup =3D "insert into ari.nc_sftyplan_altcontacts 

l_name,address,city,state,zip,telno,email,fax) values( " & " "" " & 

Request.Form("l_name") & " "" " & ...........................



Hope this will help U.



Regards



SATHISH C.G.





-----Original Message-----

From: Naraparaju, Venkat <VNaraparaju@a...>

To: ASP+ <aspx@p...>

Date: Wednesday, December 13, 2000 8:48 PM

Subject: [aspx] begin ASp





>Hi

>Please help me to write an insert statement.

>

>if (request.querystring("mode")=3D "insert" and

>Request.Form("dowork")=3D"insert") then

>   sqlup =3D ""

>       sqlup =3D "insert into

>ari.nc_sftyplan_altcontacts "

>       sqlup =3D sqlup & "

>(l_name,address,city,state,zip,telno,email,fax)"

>        sqlup =3D sqlup & " values(" 

> sqlup  =3D sqlup  & "f_name =3D '" &

>Request.Form("l_name") & "', "

> sqlup  =3D sqlup  & "address =3D '" &

>Request.Form("address") & "', "

> sqlup  =3D sqlup  & "city =3D '"  &

>Request.Form("city") & "', "

> sqlup  =3D sqlup  & "state =3D '" &

>Request.Form("state") & "', "

> sqlup  =3D sqlup  & "zip =3D '" &

>Request.Form("zip") & "', "

> sqlup  =3D sqlup  & "telno =3D '" &

>Request.Form("telno") & "', "

> sqlup  =3D sqlup  & "email =3D '" &

>Request.Form("email") & "', "

> sqlup  =3D sqlup  & "fax =3D '" &

>Request.Form("fax") & "') "

> 'sqlup =3D sqlup & " WHERE client =3D

>'" & Request.QueryString("clientid") & "'"

>      'sqlup =3D sqlup & " AND division =3D '" &

>Request.QueryString("group")& "'"

>      'sqlup =3D sqlup & " AND service_type =3D

>'" & Request.QueryString("service") & "'"

>

> Response.Write (sqlup)

>

> set objCmd =3D Server.CreateObject("ADODB.Command")

> objCmd.ActiveConnection=3DobjConn

> objCmd.CommandType=3DadCmdText

> objCmd.CommandText=3Dsqlup

> 'objCmd.Execute

>



>To unsubscribe send a blank email to leave-aspx-$subst('Recip.MemberIDChar')@p2p.wrox.com

>

>