add a new row when cursor comes to the last field

bullsb · February 26th, 2007, 03:28 AM

Hi,
Im developing package in ASP.
Wherein i have a row & i have the following details
ID, Name, City, Country.

if the cursor comes to country (on the lost focus event) i have to add another row which should allow me to enter another customers details (ID, Name, City, Country).

So, by default i should have only one row & once it comes to country. Another row should be displayed.

I hope i have not confused in sentence what i have put accrossed.

Need this @ the earliest.

Regards,
BullsB

dparsons · February 26th, 2007, 09:04 AM

I am not sure what you mean. Are you looping through a row and if that row contains a country column you want to add a new row to the database?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

mat41 · February 26th, 2007, 06:43 PM

mmmm - I am 'confused in sentence'

Wind is your friend
Matt

mat41 · February 26th, 2007, 06:54 PM

It seems you got your ASP answer in the JS area of this forum:

http://p2p.wrox.com/topic.asp?TOPIC_ID=56785

Wind is your friend
Matt

bullsb · February 26th, 2007, 11:36 PM

Hi Matt,

How to add a new row (user defined)

I have the following fields in the first row (default)

ID
Name
City
Country

Aall these are input box wherein the user will enter the data.

After country i should have a option ADD ANOTHER ROW & when the user clicks the add new row button another row should be added allowing the user to enter the 2nd data (ID, Name, City, Country).

I doing a Project in ASP with ACCESS as backend.

Regards,
BullsB

mmltonge · March 3rd, 2007, 12:51 PM

Hi,

You could do something nice and simple like this...

At top of the page have a quick checker. Say the page is called addrow.asp, use the following, changing your column names and table name, and setting your connection

Code:

Dim addRow

addRow = Request.Form("country")

if addRow <> "" Then

Dim strSql, objCmd, strConn, newCountry, newCity, newName

newName = Request.Form("name")
newCity = Request.Form("city")
newCountry = Request.Form("country")

strConn = ConnectionStringHere

strSql = "INSERT INTO tblTableName(colName, colCity, colCountry) VALUES ('" & newName & "','" & newCity & "','" & newCountry & "')"

Set objCmd = Server.CreateObject("ADODB.Command")
objCmd.ActiveConnection = strConn
objCmd.CommandText = strSql
objCmd.Execute
Set objCmd = Nothing

Response.Redirect("addrow.asp")

End If

Then in the body of the page, have your form as usual, making sure the input box names match up with those above and that you are posting back to the same page the form is on. Good Luck

mmltonge · March 3rd, 2007, 12:53 PM

Whoops, don't forget to End If below Response.Redirect

saurabhj · March 9th, 2007, 07:24 AM

mmltonge,

Is this what bullsb wants?

-Saurabh

mmltonge · March 11th, 2007, 04:11 PM

From reading his questions, the code is a generic code solution to the problem, he will need to apply it to his own application for it to work though (own field names, own html etc)

I don't know for sure as he hasn't replied saying so :(