Grab Results From Recordset
Is it possible to grab recordset even after SQL throws error, but also returns data?
View RepliesIs it possible to grab recordset even after SQL throws error, but also returns data?
View RepliesI keep getting the BOF and EOF error message. My code is testing for entries within the database only from the current. If an entry of the current day doesnt exsist VBScript will spit the EOF /BOF error. I can i get pass this and still display my form as I want to. Here is my code:
View Replies View Relatedi have a recordset in a results page
this retrieves all records but i only show the first 6 with all details (using a repeat region)
then i want to follow this with just thumbnails of the additional results
- this repeat region uses the horozontal looper
Either i need this second repeat region to start at number 7
or i need another recordset but with sql to ignore the first 6
(database is access)
can anyone offer any guidance on either solution?
I have a database with several hundered images and I need to retreive them using recordset paging, otherwise the page will be to long. So far so good.
I added a search function which will return only the desired results. The first page returns the search results (30 per page) and I also have a line of code that tells me how many records was found, let's say 70. This should give me 3 pages of results.
But when clicking on the next link I don't get the next set of results, instead ALL the images from the database is returned on the following pages, starting from image 31 in the DB. Not just the rest of the originally search results. Code:
Does anyone know of any easy way to have shading on alternative rows in a table that loops through the rows in a recordset?
View Replies View RelatedThis seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?
I bet this is a simple one, but I just don't know.
www.mydomainname.com/12345
How do I grab the 12345 in my ASP page as the ID#?
can you grab the computer name via asp?
View Replies View RelatedI am looking to find out how to grab a specific content on a particular Website and put it on my Website. Of course, I will get permissions before doing so. Any ideas? I have found a sample ASP script that shows how to grab the entire page, but certain sections of the page.
View Replies View RelatedIs it possible to grab a client side IP Address using JavaScript in an htm page? I have a web page hosted on a non-ASP server and I want a piece of code in JavaScript to grab the IP address of the client and send it to a web page on another server. The other page will be ASP.I need this for both Netscape and IE browsers.
View Replies View RelatedI'm looking for a way to grab the HTML behind one of my pages and display it
to the user. The page I'm trying to get the HTML from is an ASP page, so
obviously I'm looking for the post-asp processing results. Basically I want
the same HTML that the user could get if they had done a "View Source" in
their browser on the page.
Does IIS/ASP provide a way to do this natively, or do I have to buy a third
party component?
how to grab web content on another Website and put it inside mines? Such as grabbing text, or links then reformmating it on my Webpage. Any ideas on how to do it?
View Replies View Relatedi need some help to grab others website content. after grab the data, i need to store into database. Any idea??
View Replies View RelatedThere's only 15 rows in the table 'FiscalYr', but I can't grab the row I need.
Here's 3 typical rows:
..Year...Start..........End...... Column names = 'year', 'start', 'end'
2003 12/29/2002 12/27/2003
2004 12/28/2003 12/25/2004
2005 12/26/2004 12/24/2005
For example, if the value of 'today' is #07/10/2004", I want the record where the key is 2004. In fact, any value for 'today' between 12/28/2003 and 12/25/2004 should pull up the '2004' row.
Here's my non-functioning code:
SQL = "SELECT * FROM FiscalYr WHERE Start >= #" & today & "# AND End <= #" & today & "#"
Set rs = DBConn.Execute(SQL)
The resultSet obviously should have only one record because the Start and End dates are unique and don't overlap from row-to-row.
but when I:
if rs.recordcount >= 0 Then
response.write. "There are " & rs.recordcount & "rows that match your search."
else
response.write "While attempting to tally a RecCount there is an Error with recordset. <br />"
end if
I keep getting the Error msg. What am I doing wrong?
I am trying to grab the server name and IP address using Response.Write (Request.ServerVariables("ALL_HTTP"). I am using this one because I wanted to see everything that is brought back.
The server name I am getting back seems to be the host name found in IIS not the fullly qualified domain name of the server. Is there a way to get the fully qualified domain name of the server?
Also this server is one of two servers in a cluster and the IP address being returned is the IP address of the cluster server. Is there a way to get the IP address of the server that I am actually logged into?
I have a voting system that works perfect. It calculates the % of votes and shows the total percentage that people picked 1st, 2nd, and 3rd, and a total.
However, I want to be able to select the top 3 of those, and highlight the row, using a bgColor variable that I have defined. The problem with this is that I am calculating the %'s as I am writing the rows, and do not know how to check to see if that row is one of the top 3.
Here is my code:
I have another script where i pull all the information from the database and I want to send it to the person. What they do is they enter in their email, and if the email matches, than it will email them their login information.
How do you grab the info and than use that info and put it into an email to send?
Here is my code thus far for it: ....
Ok i have a shopping cart got everything pretty much going but it didn't allow for quantities to be updated. So in my cart view i decided to add a quantity box so u could enter a new value and then click update to update that item.
However i don't know how to grab the value from the txt box.
I have the code working for all the db updates cause i tested it by hard coding it in. I just cant grab the value and pass it on from the txt box....
I need to grab product info including images from specified websites with no RSS or common structure.
I've been searching and reading articles for 2 days and have played around with grabbing html from a site and trying to find out what to do with it at that point. I think I need to parse it for the patterns I'm looking for, (creating an array out of them?) and save that information to my DB. I also want to grab the actual images and display them from my site so that the product suppliers bandwidth is not used by the pics being on my site...
I'm thinking, with my current skills which are limited, I'll be doing this with ASP (vbscript) and javascript (if necessary). I'm not great with those but good enough to figure stuff out eventually.
Can you tell me if you think I'm on the right track and recommend any learning resources specific to the skills needed to accomplish this?
If it's not too much to ask, a bit of pseudocode might keep me on the right track... what to do and when.
I have this asp page (see code below). It grabs the values from the previous page and populates the email which gets sent to the recipient from the person bidding on his product. I need to grab the bidder's email address (he is logged in when sending this email) from the database.
I can't seem to figure out the code for grabbing a logged in visitor's information from the database to display in the "From" field. Can anyone help? I need the code that grabs his email address, and the code that goes in the "mailer.from" variable to populate that field. Here's the code:
I am wondering if it is possible to have an asp script, called script1.asp sitting on a server called server1. when this asp script runs, i want it to connect too a different server (called server2) somewhere else in the world and grab data, maybe an xml file.
Is this possible? and if so what is the process called (and/or function names etc) that can help me do this, so i can look them up in google and get cracking on the code.
I've been trying to figure out how to grab Outlook information and place it on a webpage for a corporate Intranet site. I've downloaded both ASP and ASP.NET example.
I have gotten the ASP.NET example to work, but can not modify it to showmore than one day. The ASP version will not authenticate properly.
What is the best way to do this? Is there an example of how to grab information from Outlook? Is there a way to connect through SQL or export to a SQL database easily?
I have the following regular expression:
re.Pattern = "style[^=]*=[^""]*""[^""]*"""
It will grab any style attribute within HTML that uses double quotes, and put it in the re.Matches collection.Now, I want to include single quotes into this regular expression. Here's what I have so far:
re.Pattern = "style[^=]*=[^""']*(""|')[^1]*1"
but it does not work.
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
Anybody know how to get only the 10 latest results of an SQL query ?(in SQL)
View Replies View Relatedi have a record that is returned by the database as domain/username. i want to be able to strip off "domain/" and just display "username". is this possible? if so, how would i go about doing this?
View Replies View Relatedi don't know what to do here exactly.
i have seen the TRIM function, but i'm not sure if it's the right way to do it.
i have a recordset called RSUSEREDIT.
in the recordset there is a column called "EMail".
i can print out the results using Code:
<%=RSUSEREDIT("Email")%>
the email column always uses the same domain name... - username@domain.com
is it possible to remove the part after and including the "@"?
I have a URL... everything returned by the url, I need to write to a file. lets say its 40 lines of text... how can I write it to a text file and save it??
ADODB stream?
FSO?
DomObject?
I'm creating a site that pulls details from a database & display it on screen. Problem is that there's sometimes loads of data which makes the page huge. What I want it to do is display ten and a next page link to display the next ten. Like the way Google displays results. Problem is I don't know how to generate pages on the fly. So the question is can it be done and does ne1 know how to do it?
View Replies View RelatedFirst, thanks to all who have helped me over the last few weeks !!
I have a form that allows the user to select multiple options.
These are user names:
Fred S
Bob D
Paul G
Dave O
When the form is submitted, I'm getting the details using
user = request.form("user")
this is returning the mutliple options.
What I would like to do is pass all the options to 'user' but at one
point on the results page only show the first user selected, not the
multiple selection
what is an easy way to go about sorting my search results through links, you know, like clicking the link at the top of a column. i know how to pass the order by in a querystring:
http://www.example.com?lastname=smith&firstname=john&state=GA&orderlast=desc
where orderlast is the order querystring.
but what about all the other links? what do I do with the previous querystring entries like lastname, firstname, and state? i find if i add orderlast to my lastname column and i click on it, i will have 2 orderlast querystrings
I'm using multiple recordsets on a page, and they are all returning correct results and enough of them. My problem is when I try to access the recordcount property rs.recordcount, they all return a result of -1. This would usually mean that no records are returned. So why is showing my recordsets that are displaying records with recordcounts of -1. I can't seem to figure out.
View Replies View Related