[thelist] ASP using SQL but anoing me like $%&#

[Mike Hardaker]

> when I leave out the fourth column (order; '1'), access
> agrees and accepts the addition <sigh>
> So now I'm closer to the truth, but still having problems.

Is the DB field "order" defined as a Number?

If so, you need something like:

	strsql = strsql & Request.form("order") & ")"

Without the single quotes, if my memory serves...

-------------------
Mike Hardaker
Founder & Publisher
AngloINFO
www.angloinfo.com