sql = "SELECT * FROM tblcsvdump"
set rs = connection.execute(sql)
records = rs.Fields.Count

dim heading(100)
dim pulled(100)
dim i
dim count
dim VAL
dim VEL
i=0
count = 0
for i=0 to records
 heading(count) = rs.Fields(count)
 response.write(heading(count))
 header = heading(count)
'**** THIS ROW HAS ERROR
 pulled(count) = Request.Form(header)
count=count+1
next

The error i receive is....
The function expects a string as input.


What am i doing wrong guys?

Recommended Answers

All 2 Replies

I don't see that any of your variables are typed. Is this VB.NET? Is it loosely typed?

this is very odd code, so let's start by cleaning it up a little

sql = "SELECT * FROM tblcsvdump"
set rs = connection.execute(sql)
records = rs.Fields.Count

dim heading(100)
dim pulled(100)
dim i
dim VAL
dim VEL


for i=0 to records
 heading(i) = rs.Fields(i)
 response.write(heading(i))
 header = heading(i)
'**** THIS ROW HAS ERROR
 pulled(i) = Request.Form(header)
next

now, what line has error?
header = heading(i)
or
pulled(i) = Request.Form(header)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.