loop to retrieve form field names not working.

darkmunk · #1 (**permalink**) 06-02-07, 08:08

Any ideas why this isn't working?

Code:

Dim sMessage
	
		for each field in request.form
			if sMessage = "" Then
				sMessage = field & " = " & request.form(field)
			Else
				sMessage = sMessage & (Chr(10)) & field & " = " & request.form(field)
			End If
		Next
		response.write(sMessage)

It is not outputting anything. and no apparent errors.

Later I want the code to build an SQL INSERT string using the field names as DB column names, but I'll get to that when this bit is working!

thanks
M

pootle flump · #2 (**permalink**) 06-02-07, 10:20

Quote:

Originally Posted by darkmunk

Any ideas why this isn't working?

Probably because SQL Server can't parse vb script

Moving to asp forum or somewhere like that.

darkmunk · #3 (**permalink**) 06-02-07, 11:39

sorry, it was leading to a really useful script to generate SQL strings which I have now accomplished. but you don't apear to want them.

pootle flump · #4 (**permalink**) 06-02-07, 11:53

I'm not quite sure what you mean. My point was that your problem was with asp but you posted in the SQL Server forum. I therefore moved the thread to the appropriate forum.

Internet Services

Web Development

Digital Marketing

Consumer Tech