entering data in sql database through asp

Posted by sushant on Stack Overflow See other posts from Stack Overflow or by sushant
Published on 2010-06-14T07:19:33Z Indexed on 2010/06/14 7:22 UTC
Read the original article Hit count: 142

Filed under:

asp-classic

pass=session("password")
Set objIns=server.CreateObject("adodb.connection")
objIns.Open session("Psrconnect")

inspass="Insert into passwords(pass) values ('&pass&')"
objIns.Execute(inspass)

i dont know what should be the syntax to pass the value stored in the variable. with this syntax, the value entered in the database is &pass&. can anyone plz help me out?

Related posts about asp-classic

Looping through an array and calling a function on each pass in v-basic / asp classic

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I loop through an array and call a function on each pass? At the minute I'm trying the following... if Request.Form("authorize") <> "" then dim post_ids, ids post_ids = Request.form("authorize") ids = split(post_ids, ",") For i = LBound(ids) to UBound(ids) … >>> More
ASP Classic Session Variable Not Always Getting Set

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a classic ASP site I'm maintaining and recently we wanted to do special rendering actions if the visitor was coming from one specific set of websites. So in the page where those visitors have to come through to get to our site, I put a simple line setting a session variable: <!-- #include… >>> More
ASP Classic page quit working

as seen on Stack Overflow - Search for 'Stack Overflow'
I've had a set of legacy pages running on my IIS7 server for at least a year. Sometime last week something changed and now this line: Response.Write CStr(myRS(0).name) & "=" & Cstr(myRS(0).value) which used to return nothing more exciting than the string: 'Updated=true' (the sproc processing… >>> More
in visual studio 2008, when I stop debugging an asp classic website visual studio always crashes

as seen on Stack Overflow - Search for 'Stack Overflow'
We are running visual studio 2008 (with the service pack) and having troubles when we are debugging an asp classic website. We can attach to the w3p process and debug just fine. breakpoints work, we can view variable values. The difficulty arises when it comes time to detach or stop the debugger… >>> More
HTML to PDF conversion from hosted ASP classic?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to convert HTML to PDF on the fly from a hosted ASP classic page. WkHtmlToPDF is great, but unfortunately requires installation on the server which is not possible in this case. Is there something out there that would do this? >>> More

Developer IT

entering data in sql database through asp - Developer IT

entering data in sql database through asp

asp-classic

Related posts about asp-classic

Looping through an array and calling a function on each pass in v-basic / asp classic

ASP Classic Session Variable Not Always Getting Set

ASP Classic page quit working

in visual studio 2008, when I stop debugging an asp classic website visual studio always crashes

HTML to PDF conversion from hosted ASP classic?

Categories cloud