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:
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.
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.
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".
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".....
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
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:
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?.
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:
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?
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.
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:
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?
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?
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??
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?
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.
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?
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.
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?
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:
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.
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)
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?
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 ...
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.
