INSERT syntax using DRW

T

Tim Barker

I have two forms. The first one (Enroll.asp) collects data from an end user.
The second one (Enroll2.asp) inserts the entered data into a SQL database.
The syntax that I'm using with the DRW is:

INSERT INTO TblEnroll(AccountID) VALUES('::AccountNR::')

AccountNR is the form textbox name so I want to write the value of that
textbox into the field name AccountID in the database. However, when I try an
proceed to the next step of the DRW, I get the error message "Errors
contained in Custom Query". If I replace the '::AccountNR::' with a text
string ('test123' as example) then everything works fine so I think the
syntax for the variable is wrong. Help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top