Thread: best way to bind values to sql statement?

Hi,

I want to bind values to sql statement.

Example:

[CustomerID*], [RequestID*], [ProblemDescription]


the first text box needs to have the value "1" bound to it as well as the description. and also the session variable for the Customer.

i have loads of request text boxes and drop downs, so i kinda need to know how i would do this on a large scale..

hope you can help..

Originally Posted by richyrich

I'm not sure I entirely understand what you mean. Do you have any code to start from?

Could you maybe give an example of what you want the end result to look like?

1) user logs in,

2) session variable is taken to the form,

3) in order to insert data, the sql statement needs to have customerID, requestID, and problemDescription added.

but because i have 10 different questions for the customer, i want to bind the pre-determined requestID's and session variables to each of the requests.

Originally Posted by richyrich

You mean you want to include the customerID session variable in your SQL statement as one of the values?

Code:

strsql = "INSERT INTO tbl(customerID) VALUES(" & request.session("customerID") & ")"

yes, as well as the RequestID.. for example "1" and as well as the description..

Originally Posted by jmurrayhead

Code:

strsql = "INSERT INTO tbl(customerID, RequestID, ProblemDescription) VALUES(" & request.session("customerID") & ", " & request.session("requestID") & ", " & "'" & request.session("problemDescription") & "')"

cheers for that.. i have like 10 different text boxes, so im guessin i will have different session variables..

wont that make the SQL statement massive....

Originally Posted by jmurrayhead

Not sure you really need to be using sessions for everything. The sessions would be for customerID...something that will stay the same through the session. The user's responses to the questions would be coming from the form fields, so you would use Request.Form("fieldname") instead of session.

but for each question i have to attach the session and the requestID that means each question will have 3 sessions. so if i have 8 questions. that means i have to bind the 3 things together rite?