I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst'
Does someone know where i am going wrong? Code:
i have been trying to create a search and result page. - (The same page if possible) using both Dreamweaver and Frontpage. But keeps returning a provider failure code. i know want to just code it to see if that will work but am a newbie when it comes to coding. I wish to do a search on 1 field in a SQL database if at all possible using a trusted connection, but return more fields from various tables.
View Replies View RelatedI'm trying to get results from a number of areas via one command string.for example ?location=devon retrieves everything in devon but I've only got a link for the whole south west so I need to send ?location=devon or cornwall or dorset etc. altogether.Is there a way I can do this without changing the asp page or do I have to only search one field at a time.
View Replies View RelatedI'm either way too tired or this is a bit above my head. I have a database (access) with four fields. One field is a unique id (rs("id")), one is a category (rs("category")), the third is type (rs("type)), and finally a title (rs("title")). There are and will always be seven types, numbered 1 - 7, with each type identifying a category. To be more specific, 1 = appetizer, 2 = soup, 3 = main dish, etc.
What I am trying to do is to create seven seperate drop down list, one for each type. The options in the drop down list will each be identified with the id (rs("id") and the values for each option will be the rs("title") field. I am having a hard time in the Loop distinguishing when to end one select statement and begin another.
We have an IIS+ASP based application server that is capable of providing
complex reports to hundreds of users but in some circumstances these reports
can take a long time to create. However the data for the report is cached
so subsequent calls to view the same report come back with a sub-second
response time.
In order to make use of this caching we pre-prepare some of the reports by
getting back a list of potential users from the server and then executing
reports on their behalf. When the real users log in the report is served
from the cache.
I wrote the warm caching application using VB6 and it uses XMLHTTP requests
to execute the reports. However because ASP serializes the requests to the
server the application can only have a single session open with the server.
To get round this I spawn multiple instances of the application, each
instance then has its own ASP session and the server is loaded more
efficiently.
The question is how can I create multiple ASP sessions from within a single
VB application and have each session handle its own XMLHTTP requests? Its
obviously possible as MACT, OpenSTA and LoadRunner all achieve it.
I am working with IIS 5.0 and would like use the property CentralBinaryLoggingEnabled which if set true will create one single binary log file in place of a separate log file for multiple websites.
This property is available in IIS 6.0. I would like to know if there is a patch available for IIS 5.0 which will create this property in IIS 5.0.
I've got a product database with some pretty heafty table joins. At the moment if I return all products, the script often times out since there can be 10,000 + products per search result.
What is the best way to retrieve only, say, 100 results per page?
I currently have a script which loops through the entire recordset and only writes the appropriate records (say, records 300-400) but it would be nice only to pull the correct records from the database as people page through. Basically I need to have the least amount of memory usage during pulling these results from the database.
Does that make sense? What do you guys suggest?
I'm doing pretty well with my SE and getting all my results but I'm trying to come up with a way to have a maximum of 10 results per page. Code:
View Replies View RelatedI have a ASP page that triggers a db-side stored procedure.At the end of the procedure, it spits out a log file, that this ASP page reads and displays for the users.
But the problem is that the database-stored Proc could take anything between 10 secs - to - 10 mins. I dont want the page to time out [But I dont want to increase the time out in the IIS webserver]. Is there a way, like the airlines websites do, where I can just show an animated gif while the procedure runs and redirect the page to results at the end of the procedure run.
ex: like orbitz or hotwire.... or anything like that, but not as complicated as them.
I have a page with some search criteria at the top. On submit, I am displaying my query results for this criteria. I need the user to just be able to print the results without the search criteria. Whats the best/easiest way to achieve this? Frames? Printable version?
View Replies View Relatedhow to create a search option that would search the recordsets in my database table.
I would be allowing users to search by name or date. I'd like the results in the same page. Any suggestions or tutorials?
I am trying to debug a problem with some ASP pages when accessed via IIS on
Windows 2003 Server SP1.
In summary, the pages are structured as follows:
Root page
Page loaded via IMG SRC
Root Page extract Code:
I have created a quiz with 14 questions that the user can click a yes radiobutton or no radiobutton. In the code-behind I have set a varable to store the selected items.
What I have taking place is if yesRadiobutton is selected the variable is incremented by 1. then after all the radiobuttons have been added up. i check the variable using an if statement. Code:
I have set up Index Server in IIS to search my intranet. I've installed the Adobe PDF filter so that words from PDF files are included.
I can get results from PDFs when querying the catalogue in the Windows console. However, I have tried various ASP Search pages and they all ignore PDF files from a browser (even though the scripts include the pdf extension).
i want to include an xml file as an asp include file - i'm transforming it using xslt, but it just appears as a blank.i take it i have to use xslt to transform the xml file to an asp page. can anyone point me to tutorials or tell me how ?
View Replies View RelatedI try to develope a category page in asp. How can i creat a new asp page and save it on the server dynamically?
View Replies View RelatedI am looking to create some sort of function that on the click of a submit button, a new HTML page will be created. Is this a simple task or something that I should research?
View Replies View Relatedmy problem is:
i am creating a appointment calender everything is fine except for one page
what I want is to have no duplicate times for example if someone books 2opm on tuesday 22 of june no one else can book the same time.
I have set the database to not allow duplicate entries but I need a page that if someone tries to book the same time it will say sorry that time is taken.
Does anyone know of a web-based tool that will allow users to print certain pages in PDF?
View Replies View RelatedIn my site i need to give the user an option to have a landing page to a site or not to.
If they choose no i need to create a page that has a basic response.redirect in the page
so the code that would be used to generate the link would look something like this :
<%response.redirect("/site/" &siteName & "/" & pageName & ".asp")%>
So how do i create a page with asp?
how to get started with this project. I want a page where a
user can manually enter an order. Our users know our order# system and it's
much easier to manually enter items as opposed to using a shopping cart and
flipping through multiple pages.
On the page would be the following....
1) Billing address
2) shipping address
3) fields for order numbers
Billing and shipping seem pretty straight forward.
Because I have no idea of how many products a customer will order, I'm
picturing a new order# field being created when one is filled out. How do I
do this?Then, assuming I get all these dynamically generated fields, how do I get
them into an OrderDetails table?
if there is a method out there that allows me to create a web page util to see if URL links are still valid. In other words I've created a system whereby a user can add their own links/urls page, but they want to periodically check whether all of these links by executing a multi-check.
My theoretical thought on this would be that the script would check if it receives a 404 on each page request and mark a flag if and when it gets it, but as to how I would do this in ASP or JavaScript.
How can I create an automatic reload page, depending on a timer in ASP code?
View Replies View RelatedI got a ASP page where one can add a record or update any existing records.
As soon as a record is added it is appended to the existing records. With
this design user can check for erors in existing records or the added record.
Initially, there was ino data validation rule.
Now, as soon as I am putting
data validation via script, I cannot update the exisiting data as the
validation looks for empty space in the text boxes meant for adding data. Is
there any way, I can avoid this situation and can update existing records. If
this is possible, how does one validate the existing records.
I’ve created an application with 3 pages[forms] that have information that must be entered. This application has a session variable that is passed from page to page to ensure that the information that is put in the tables in the Sql Server database is linked together. It also sends an email after the last page is submitted.
My problem is that I am trying to create a page that will show the user what they have entered and allow them to go back and make changes if necessary, before they go to the next page. [A verification page I guess you would say]
I have created the 1st verification page which shows the info [from the first form] the way I want it to and it allows them to go back and make changes, [while I’m testing locally, that is]. When I go live, it skips over the 1st verification page and goes straight to the next form page. It does process all the code that is in the verification page and adds the info to the database but it will not show the verification page! When I do get it to show the verification page, it does not process the code behind the page that adds to the database. Code:
I have created a database request page (wahooo - new to asp and it works)
and everything is great. Now I'm creating a second page and want to know if
I'm able to make two different queries on one page. I want to be able to
create one query that uses a Request.QueryString from a URL and then use one
of the returned values from that query to create another query on the same
page. I hope that make sense. Here is the database connection code:
i was wondering how to go about making a multiple page reports. i am really clue less.
View Replies View RelatedIf you are going to be making multiple calls to the same database from a single page, should you connect/close, connect/close, connect/close....or just connect once at the beginning of the page and close at the end?
View Replies View Relatedi'm thinking about making a muti page survey and was looking for some input on the best way to go about it. example
i want 3 questions on the first page, the user answers then hits next the next questions load and so on. what would be the best way of programming this?
i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.
if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?
Im basically making a site that will have a homepage with links I will add everyday to graphics and movies on my server. When you click the link it will open a new page similiar to the homepage with the graphic/movie in the middle of hte page.
I know there's an easy way to do this so i can just have it call a database or something like that. Basically I want to just have to add a link to the home page describing what it is, then and add the link to the file to the database and have the coding do everything for me. I think this is asp.
Can someone clue me in. All the sites i've built up until now have hundreds of pages all consisting of the same thing and it's such a pain to keep duplicating code. I'm not looking to get too advanced. If I don't have to use an access database, i don't want to.
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.
The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
I currently have designed a web page and inserted some ASP modules into it. But, if I insert more than one ASP module I receive an "Internal Server Error". If I delete the second ASP module the page works perfectly. So, my questions is this. Can you only insert one ASP module per web page? Where is the problem. Code:
View Replies View Related