Cancelling Long Database Query
I don't excactly know whether this is an ASP, webserver or SQL-Server problem:
I have an ASP with a search form. By clicking the submit button it redirects to my result.asp page which initiates a database query that takes pretty long (up to 4 minutes).
Now if I push the cancel button in my browser because it takes too long and want to open another ASP page in that browser window I just get the "page loading" bar until, it seems, the query I initiated before has finished, and then shows up the wished page.
What I think is, that the webserver is waiting for the the command:
set rs = db.Execute(sql_search_string)
to be finished by the SQL-server and does'nt respond to other page requests (but only in the same browser window) until the recordset is filled with the information from the SQL-server. Code:
View Replies
ADVERTISEMENT
I am trying to return a recordset of data. The problem is my SQL query does not fit on 1 row. What do I need to do to start a new row. I tested the asp when I trimmed my query down to 1 row and it worked.
View Replies
View Related
I'm trying to put a long hyperlink into my database table which works fine. I used longtext as the field type. My records insert just fine. But when I try to retrieve the records on the asp page all the other data shows up but the hyperlink data. Here's an example of my link.
INSERT INTO products
(manufaturer, prod_category, prod_link)
VALUES ('Xtra','Irons','<a href="http://www.kqzyfj.com/click-1692223-10304326?url=http%3A%2F%2Fwww.golfsmith.com%2Fppage.php%3Fstynum%3DCL1480%26tcode%3Dcj" target="_top" >CG1 Irons w/ Steel - 3-PW Iron Set<br>$799.99</a><img src="http://www.afcyhf.com/image-1692223-10304326" height="1" width="1" border="0">');
What am I doing wrong.
View Replies
View Related
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already :
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".
View Replies
View Related
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already:
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".....
View Replies
View Related
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work
View Replies
View Related
I have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:
View Replies
View Related
i'm confused about perfoming insert, update and delete operations in a database. I know that to only use SELECT statement you would create a recordset and use it but for all other you need to use Command or Connection Object.
I'm confused because in some books/articles they create and open a connection and perform insert/update using that. in others they say to use Command object instead. which one do u use when?, why?.
View Replies
View Related
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
View Replies
View Related
The following code works fine doing a query in the db and return the data with the link ...mes.asp?month=X (where X is a month and mes.asp is the name of the file that this code is in...)
I have a ID column in the database and would like to know how to catch data from ID.. i have tried without success, dunno why but the code comes with a error in the line "rs.Open sqlStr, data_source"... Code:
View Replies
View Related
i have this shopping cart i'm working on and it keeps giving me this error and the original code is on the bottom. Code:
View Replies
View Related
I am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
View Replies
View Related
im using ajax to load different pages of code into containers on one page.. i have checked my code.. and things SEEM to be named correctly.. and i know the db is workin because it populates the drop downs properly.
so if you could do this form me.. choose the first radio.. 'london postcode' and proceed from there.. when you click the get quote that error comes up.
View Replies
View Related
I am trying to create a xml tree using sql server 2000 and asp 3.0 i am looking for a code for it .
View Replies
View Related
I need to know the syntax to achieve the following.
<%
Dim Year_Value_Num = 1999
Year_Value_Num = 1999
rsUsage.Open "Select AuthorLastName,ReceptorName,Year from TblAuthorInfo where Year > Year_Value_Num ", strConn
%>
The database access works fine otherwise But if i attempt the above code i get the error.
View Replies
View Related
I am trying to query an Access database using the like operation; however, when I test the query in the browser all records from the database are displayed. Here is my code:
View Replies
View Related
I am using ASP with VBScript. I want to query an access database username
field, and display the output as a hyperlink on an a webpage.The webpage
will display all records. I then need to be able to select a given
record(hyperlink), and display all of the fields for that record on another
webpage so I can execute some code against it.
Can anyone point me to some sample code so I can get an idea of how to
accomplis this?
View Replies
View Related
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
View Replies
View Related
it possible to pull the information from a query located inside the .mdb database already, instead of pulling the information from the tables ?
View Replies
View Related
I have an Access database that I created a query in. The query brings fields from related tables and prompts users to perform a search based on 3 criterias.
NOTE: the prompts can be bypassed by just leaving it blank and selecting OK. So in other words, the user does not need to fill in each prompt for the search to work, it just give them a more narrowed down search if they fill more in...
Now for the ASP part... I want to create an ASP page where the use selects from 3 drop downs. These drop downs are named the same as the field names in my query. How do I get this to work??
View Replies
View Related
I have created a query and everytime I try to run it I get this error:
Microsoft JET Database Engine error '80004005'
Record is deleted.
/vsadmin/inc/incsearch.asp, line 162
This is the query: Code:
View Replies
View Related
I want to retrieve a large number of rows from my database (Select SomeColumns from myDatabase)and then to fill a table with the retrieved data. What can i do?
View Replies
View Related
I would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.
By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.
So when the user clicks an image or link i would like it to preform a SELECT query using the id number.
How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.
View Replies
View Related
Currently, I do the following in my ASP pages when making use of an MS
Access database:
Dim adoCon, rsSet, strSQL
Set AdoCon = server.CreateObject("ADODB.Connection")
Set RsSet = Server.CreateObject("ADODB.RecordSet")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("MyDB.mdb")
strSQL="SELECT * FROM MyTable;"
rsSet.Open strSQL, adoCon
...do some stuff...
rsSet.Close
adoCon.Close
Set rsSet=Nothing
Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access.
Can I call these queries instead of using a string to specify the SQL
command?
The above seems kind of verbose for making use of a database. Can it be
simplified at all?
View Replies
View Related
I have a form and when you click submit it is supposed to open up the database add the stuff from the form to the database and close the database. The problem is i am getting an error that says this:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/getInfo.asp, line 35
this is line 35:
objRS.Update
View Replies
View Related
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
View Replies
View Related
I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. Code:
View Replies
View Related
I want to insert a new row in my db but it says that the "identifier is too long"...
ORA-00972: identifier is too long
to be more precised... I googled it but I can't seem to pinpoint how to work around this
View Replies
View Related
When sending long emails a mysterious space-character is added after a
certain number of characters. Any idea why that happens?
I am using a Dundas Mailer control (if that matters) called from an asp
script.
View Replies
View Related
I have a database-driven site and it is possible for users to leave comments, which get written to the database. How do I make it so large comments can be added?I am getting this error message:
Microsoft JET Database Engine error'80040e21'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/wall2.asp, line 37
I have set the default field type in the database to be 'memo'and set the default text field size to 255 (the maximum allowed)
View Replies
View Related
How do i make this number shorter?like 65.3846153846154%.how to make it like.let's say 65.39?
View Replies
View Related
Is anyone aware of any sort of asp coding to deal with long URLs? I have a few asp that pull URLs from fields within a MS db, which then display on a width-limited table. Is there any way to wrap these long URLs such that my table doesn't get widened? e.g. wrapping at "/" or something similar?
View Replies
View Related
ok I have a page that displays all of the 3000+ records of people, phone numbers, and email addresses. on this page I have added a link that combines all of the e-mail addresses into one mailto: link so that we can mass notify these people of upcoming projects. the problem is that i think the link is too big for the browser to handle. the view source shows that everything is there but i cannot click the link. i have tried both IE and FireFox to no avail. The code is below just in case i have a typo or something...
sql = "Select * from people WHERE (IsNull(m_idstatus) OR m_idstatus <> 'id2') AND (m_email Like '%@%')"
...
y = 0
do while not rs.eof
If (rs("m_email") = "" OR IsNull(rs("m_email"))) Then
e_email = e_email
Else
e_email = e_email & rs("m_first_name") & " " & rs("m_last_name") & "(" & rs("m_email") & "); "
y = y + 1
End If
rs.movenext
loop
...
<a href="mailto:?bcc=<%= e_email %>">E-MAIL ALL</a> |
I have also tried changing the format of the link by adding test@test.com before the ?bcc= but get the same results on both browsers. Like I said in the beginning I assume that the link is just too big for the browser; does anyone have any ideas besides making a mail form in the page? I would prefer to stick with a mailto link so that we can keep internal Outlook features.
View Replies
View Related