Listing Numbers

Oli · Nov 30, 2003

Hi

I have 2 textboxes - "from" & "to".

Assume I enter number 1 in "from" and 10 in "to" - I want the ASP to return:
1,2,3,4,5,6,7,8,9,10 and insert this into an Access database over 10 rows
into the 'number' field.

Anyone got any ideas how to do this?

TIA
Oli

Aaron Bertrand [MVP] · Nov 30, 2003

Please don't multi-post. I answered this in another group...

Evertjan. · Nov 30, 2003

Bhaskardeep Khaund wrote on 30 nov 2003 in
microsoft.public.inetserver.asp.general:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.3790.94" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>

Bhaskardeep, please no html on usenet !

Bhaskardeep Khaund · Nov 30, 2003

Hi,

You can do this:-

<%
Dim to, from, i

to = Request.Form("to")
from = Request.Form("from")

For i = cInt(to) to cInt(from)
sql = "insert into table_name (field_name) values ("&i&")"
objConn.Execute(sql)
Next

%>

Hope this helps,

Regards,
Bhaskardeep Khaund

ValueError - "Found input variables with inconsistent numbers of samples: [100, 120]"	1	Jul 27, 2023
Hello guys ! How do I convert a string from an array into numbers ? Javascript	3	Dec 19, 2022
How to limit text and numbers in python/tkinter GUI interface	5	Dec 6, 2019
How works with large integers ?	0	Aug 16, 2022
C coding a rotate function (help me pleasee)	1	Dec 26, 2022
Java matrix problem	3	Sep 10, 2023
How do I make my code output information about the students in the C# assignment:	1	Nov 28, 2024
Trouble with prediction code, for the life of me I can't figure out why it isnt running properly. Help would be appreciated.	0	Jul 8, 2023

Listing Numbers

Oli

Aaron Bertrand [MVP]

Evertjan.

Bhaskardeep Khaund

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads