Execute 2 Query In One Connection

I tried to run 2 queries in single connection. But it doesnt work to the second query
page will return an error but execute the frist query only. How can i solve this problem.
I'm using Microsoft Access 2000. Here are the code an error that return

Dim objConn, strSQL1, strSQL2
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=egbit_dev;"

strSQL1 = "Update ADM_USERTAB Set USER_PWD = '" & new_pwd & "' where USER_ID = '" & userid & "'"
set rsUpdate_Pwd = objConn.Execute(strSQL1)

strSQL2 = "Update EGBIT_PWD_STATUS Set password_status = 'change' Where user_id = '" & userid & "'"
set rsstatus = objConn.Execute(strSQL2)

error :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

( it refering to line that execute set rsstatus = objConn.Execute(strSQL2) )

View Replies


ADVERTISEMENT

Connection.execute = Asynchronous Process ??

I'm using an access database and found following problem :

I have a table X with 2 records : record 1 & record 2. I execute following
procedure with 2 steps :

1. The procedure deletes records 1 : connection.execute "delete from X
record 1"

2. The procedure adds record 1 again using the recordset object.

Result : nothing happens !

I have the feeling that the "delete" statement is executed AFTER the "add
record" statement. Or the "delete" statement did not finish before the
start of the "add record" statement (= asyncrhonous processing).

Can somebody explain me this behavior ? I have this problem only when using a MS Access database and not with an MS SQL database.

View Replies View Related

Wait For Connection.execute Method To Complete...

I 've coded an asp webpage where a user could toggle a boolean value through a checkbox.
When the checkbox was pressed, the page posted the toggle action to itself, a

connection.execute "UPDATE tableName SET fieldName=(Not fieldname) WHERE field_id=1

query was performed and the checkbox, after I had retrieved its new value through a recordset, changed its appearence(state). At first I used an MS Access DB and it worked fine.

After I had switched the hole application to work with MS-SQL, although I changed the above query to Code:

View Replies View Related

Time Taken To Execute Query

Using ASP, I would like to write down to the HTML the time taken to execute a query. I am trying to optimize my SQL queries in the ASP page. So I want to determine if my SQL query is optimal or not. So how can I determine how much time it took to execute the query and return the results.
For example, something like: It took 5 seconds.

View Replies View Related

Execute Update Query

wat are the different ways i could execute this update query. Code:

sql="Update Employee Set name='"& name&"', age="& age &" location='"& loc &"'
Conn.Execute sql

the sql statement shows evrythings correct. but when i execute the update query...it shows syntax error in UPDATE statment.

View Replies View Related

Execute An Access Query

How can you use ASP code to execute an Access query. I want to run the query to then display updated data on the webpage.

View Replies View Related

Error-checking And Query-results After Execute

After commands like:

tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?

OR:

Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")

How do I get the count? Do I use rsCatCount(0)?

View Replies View Related

Connection Timeout For Adodb.connection

1.
conn.ConnectionTimeout = 60
conn.Open connString

2.
conn.Open connString
conn.ConnectionTimeout = 60

Do both of them give different?

View Replies View Related

Need To Convert This Sql Query For Access To Identical Sql Query For Sql 2005..

My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"

I have this code, working fine in access 2003

SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"

but get the following error when I run it against my sql 2005 database.

[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.

I don't know the corresponding t-sql for the query.

View Replies View Related

Query A DB - Pass The Query To Next Page

I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....

The trouble:

the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).

View Replies View Related

Query Access With Multiple Query

I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.

{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location

Currently,

strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1

Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?

View Replies View Related

DSN Connection Or Direct Connection

I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?

when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering
is this going to have any affects when i uplode the complete site on the server.

i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.

i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..

View Replies View Related

Execute A Sp

WEll I see that this issue is not yet solved ...
So here's some more beef...
There is an update the first part of the query that takes ~50 seconds
and the connection gets cut off at 30 sec sharp. Logical as the default value us 30 sec.
question :Does anyone know how to increase that value? I can't do it in the udl , it reverts back to nothing.
Option:
[1]I would/could also optimize that update using a hint to fasten it
[2] Or try to execute the proc without using the dsn?

View Replies View Related

Execute Every 5 Min

Using ASP 3 on an ISP account (I don't have access to the root of the
server). I have a page that does some intake processing and I'd like to have
it run every 5 minutes. Right now, the only way I can see to do this is to
have a client task that wakes up every 5 minutes and opens that page.Is
there a better way?

View Replies View Related

Execute SQL

how can i setup a connection to run the sql statement? how can i embedded it in the script? Code:

View Replies View Related

Execute EXE With An ASP

I recently moved an app over to IIS 6 from IIS 5. Everything works great! I use ASPExecute to run an .exe - but it doesn't fire. It just sits in the process window. Doesn't do anything. Is IWAM, or IUSR or both required to run it?

View Replies View Related

Execute DLL In ASP

I need to use a VB6 dll like an ActiveX in ASP page. This dll use other .exe that is configured en DCOMCNFG and this dll is configured too in the same environment (DCOMCNFG) like a DllSurrogate with an specific user administrator.

I don't know how to configure this dll & IIS to it works with Anonymous authentication. I need to do this because is a development that it works in an Internet environtment and I can't assign a administration user in IIS 5 to the anonymous user.

View Replies View Related

Server.execute ?

Can server.execute provide a return value? How? ie.

dim test
test = server.execute("page2.asp")

What code in page2.asp will produce something in test?

View Replies View Related

Global.asa Not Execute

my global.asa file doesn't seem to be executing in IIS and i don't know how to make them run. Any ideas how to execute the global.asa file in IIS 5.1 ,

View Replies View Related

Code Execute First

<%Response.Write "Hello"%>
<html>
<head>
<javascript language="javascript">
alert("First");
</script>
</head>
<body bgcolor="#FFFFFF">
<h1>Testing</h1>
</body>

Which code execute first.

View Replies View Related

Server.Execute() &

In Page1.asp I am calling Server.Execute("Page2.asp"). Before calling
Server.Execute(), I set an application variable to a value that it is
important for me to know that it doesn't get accessed by another ASP page
before I call Application.unlock in Page2.asp, that is why I use
Application.lock.
According to the documentation, Application.lock gets automatically unlocked
when the ASP page terminate, I want to confirm that calling Server.Execute()
doesn't automatically unlock the application, i.e that Page2.asp will start
executing when the application is still locked.

View Replies View Related

Asp Fails To Execute

after publishing a web to iis, asp pages based on a
database fail to work. the browzer starts loading such page
and never does- at some point the status bar stops and the
page never loads without displaying any errors. the browzer
shows that it is busy all the time.

View Replies View Related

Dropdown To Execute

what If i wanted to have a dropdown that executed a query based off the selection. so i have a dropdown on page and when they make there selection it queries other data with out submit?

View Replies View Related

Execute Problem

INSERT INTO results(id, book, book_spoke, recordType, book_title, chap, chapter, chapter_spoke, vers, verse, verse_spoke, text_data) VALUES (, , , '', '', , , , , , , '')
Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'execute'

/kjvresp.asp, line 280

View Replies View Related

Cmd.execute Select SQL?

What is the proper format for my SQL str using command.execute? Even though
I know I have matching data in my table, I keep coming up with a
..RecordCount of -1. What am I doing wrong? Code:

View Replies View Related

Paramater For Cnn.EXECUTE?

How does one pass a parameter to the EXEC query recordset:

set rs = cnn.execute("EXEC tblListings_qry2")

View Replies View Related

How Can You Execute C/c++ Code Within Asp.net?

I am extrememly new to C (only been playing with it for a few days), and will be am required to be using C and ASP.NET (also a language i have only been using for a couple of days) for work purposes in the next few months. I come from a mostly Java background where it was easy to write JAVA code, and provide web interfaces that made use of that code in JSP.

I would be greatful if anyone can tell me...

a) Is the same effect possible using ASP.net to access / execute etc C/C++ (not interested in c# code - all the explanations of this seem to cover c# only - or is there no difference? - Spot the newbie! lol) code (pretty sure that works - but be good to know incase there is another step in there).

b) Where can i learn more about it? Can you suggest any weblinks or books etc?

Incase it makes any difference - the sort of code i am interested in running would simply respond with results from databases, or extracted content of files etc (command line stuff) - and much of the code is already written in c / c++ so i am not keen on re-writting it specifically for asp.net (does that make sense? hope so!).

View Replies View Related

Execute Bat File

Can someone tell me what permissions i need to change.

error
Microsoft VBScript runtime error '800a0046'

Permission denied

/ftp.asp, line 3

Code: ...

View Replies View Related

Execute Request

I am getting "Failed to execute request because the App-Domain could not be created. Error: 0x8013150a"in the event log and "HTTP 500 error" in Visual Studio.when I create a new ASP.Net project. When I browse to an already existing application Internet Explorer shows Application Unavailable page

View Replies View Related

Execute A DOS Command

with dos command of " ipconfig/all>c:ip.txt " I can retrieve some info and save it in a text file of ip.txt, now I am wondering if there is a way to do the same thing within asp?

View Replies View Related

Execute Two Inserts

How do I execute two consecutive insert statements against an oracle database here is the insert that was result of a response.write ...

View Replies View Related

Execute #Include

The web server is running on IIS with asp. I'd like to know how do you execute #include with asp in a file with extension .html. The codes work fine with .asp but I'd like to do this in .html.

View Replies View Related

Execute .exe File In ASP 3.0

I want to execute .exe file like(Media Player) through ASP 3.0. I want to use in ASP folloeing langauge type
<%@ language="Javascript"%>

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved