Command Update variables

[funkster]

Hi,

After some great help from people on this forum I have nearly sorted
collecting my callback from WorldPay.

I am using Command Update which works a treat, apart from the fact that it
will only accept variables which are numbers, which is strange because the
fields in the table I'm inserting into are definitely text fields. Am I
supposed to specify the type of data in my Command Update query?

Thanks, Mark.

[Julian Roberts]

You update SQL would be something like

update myTable set myField='myVar'

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[funkster]

This is my statement:-

INSERT INTO table1 (item1)
VALUES (varValue1)

and my variables:-

Name: varValue1
Run-time value: Request.Form("item1")

If the variable passed from the form is a number it works fine, if it is A-Z
it says:-

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/callback.asp, line 30

(line 30 is the Execute() line)

btw the field in the access table is a text field